[Zope-DB] SQL Relay

07 Dec 2002 12:06:03 +0100

--=-1GWuqM3S3F6uFXRgUUzf
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

I want to connect Zope and SQL Server, and I've installed freeTDS ad SQL
Relay with standard prefix (/usr/local/firstworks), but I can't start
sql relay.

The file sqlrelay.conf is placed into /usr/local/firstworks/etc
directory and is correctly configured. 
The ./sqlr-start -id mssql command return this error: Coultd'find id
mssql

Here my sqlrelay.conf

<instances>
        <instance id="mssql" port="9000" socket="/tmp/examplesocket"
dbase="freetds" connections="1" maxconnections="15" maxqueuelength="5"
growby="1" ttl="60"
endofsession="commit" sessiontimeout="600" runasuser="zope"
runasgroup="nobody"
cursors="5" authtier="listener" handoff="pass" debug="none">
        <users>
                <user user="sa" password=""/>
        </users>
        <connections>
                <connection connectionid="db1"
string="sybase=/usr/local/etc/freetds.conf;user=sa;password=;server=sqlserver70;db=ZopeDevel;" metric="1"/>
        </connections>
</instances>

--=-1GWuqM3S3F6uFXRgUUzf
Content-Type: text/html; charset=utf-8

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
  <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
  <META NAME="GENERATOR" CONTENT="GtkHTML/1.0.4">
</HEAD>
<BODY>
I want to connect Zope and SQL Server, and I've installed freeTDS ad SQL Relay with standard prefix (/usr/local/firstworks), but I can't start sql relay.
<BR>

<BR>
The file sqlrelay.conf is placed into /usr/local/firstworks/etc directory and is correctly configured. 
<BR>
The ./sqlr-start -id mssql command return this error: Coultd'find id mssql
<BR>

<BR>
Here my sqlrelay.conf
<BR>

<BR>
&lt;instances&gt;
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;instance id=&quot;mssql&quot; port=&quot;9000&quot; socket=&quot;/tmp/examplesocket&quot; dbase=&quot;freetds&quot; connections=&quot;1&quot; maxconnections=&quot;15&quot; maxqueuelength=&quot;5&quot; growby=&quot;1&quot; ttl=&quot;60&quot;
<BR>
endofsession=&quot;commit&quot; sessiontimeout=&quot;600&quot; runasuser=&quot;zope&quot; runasgroup=&quot;nobody&quot;
<BR>
cursors=&quot;5&quot; authtier=&quot;listener&quot; handoff=&quot;pass&quot; debug=&quot;none&quot;&gt;
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;users&gt;
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;user user=&quot;sa&quot; password=&quot;&quot;/&gt;
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/users&gt;
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;connections&gt;
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;connection connectionid=&quot;db1&quot; string=&quot;sybase=/usr/local/etc/freetds.conf;user=sa;password=;server=sqlserver70;db=ZopeDevel;&quot; metric=&quot;1&quot;/&gt;
<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/connections&gt;
<BR>
&lt;/instances&gt;
<BR>

</BODY>
</HTML>

--=-1GWuqM3S3F6uFXRgUUzf--