[Sqlrelay-discussion] Possible Bug in SQL Relay 0.40
Brought to you by:
mused
|
From: Manuel S. <man...@sy...> - 2009-01-20 13:19:07
|
Hi all, I've just installed SQL Relay 0.40 on my Fedora Core 9 Machine and found a possible bug. It is not reproducible with SQL Relay 0.39.4! The conf file is attached below. I'm connecting to a Sybase Server by using freeTDS and to another postgreSQL db. When I start all connections with: #!/bin/bash sqlr-stop sqlr-start -id sybase-ba1 -config sqlr-config/sqlrelay.conf sqlr-start -id sybase-ba2 -config sqlr-config/sqlrelay.conf sqlr-start -id postgres -config sqlr-config/sqlrelay.conf sqlr-start -id sybase-nodb -config sqlr-config/sqlrelay.conf The first mentioned sqlr-start above ALWAYS fails in the sense: -------------------------------- Starting listener: sqlr-listener -id sybase-ba1 -config sqlr-config/sqlrelay.conf Starting 5 connections to sybase-ba1 : sqlr-connection-freetds -id sybase-ba1 -connectionid sybase-ba1 -config sqlr-config/sqlrelay.conf sqlr-connection-freetds -id sybase-ba1 -connectionid sybase-ba1 -config sqlr-config/sqlrelay.conf sqlr-connection-freetds -id sybase-ba1 -connectionid sybase-ba1 -config sqlr-config/sqlrelay.conf sqlr-connection-freetds -id sybase-ba1 -connectionid sybase-ba1 -config sqlr-config/sqlrelay.conf sqlr-connection-freetds -id sybase-ba1 -connectionid sybase-ba1 -config sqlr-config/sqlrelay.conf Starting scaler: sqlr-scaler -id sybase-ba1 -config sqlr-config/sqlrelay.conf sqlr-scaler error: The file /usr/local/firstworks/var/sqlrelay/tmp/pids/sqlr-listener-sybase-ba1 was not found. This usually means that the sqlr-listener is not running. The sqlr-listener must be running for the sqlr-scaler to start. sqlr-scaler failed to start. ------------------------------------- Ok, there is no pid file for that first listener. The solution to this problem is to add in the conf XML at first a dummy entry such as: <instance id="dummy" port="12009" socket="/tmp/sybase-dummy.socket" dbase="freetds" connections="5" maxconnections="20" maxqueuelength="5" growby="1" ttl="60" endofsession="commit" sessiontimeout="600" runasuser="studma" runasgroup="users" cursors="10" authtier="listener" handoff="pass" deniedips="" allowedips="" debug="none" maxquerysize="65536" maxstringbindvaluelength="4000" maxlobbindvaluelength="71680" idleclienttimeout="-1" maxlisteners="-1" listenertimeout="0" reloginatstart="false"> <users> <user user="user" password="pw"/> </users> <connections> <connection connectionid="sybase-ba1" string="user=sa;password=;server=SYBTEST;db=ba31;charset=iso_1;" metric="1" behindloadbalancer="no"/> </connections> </instance> And then all works! I suppose there is a problem with XML Parsing. Cheers, Manuel |