[Sqlrelay-discussion] Possible Bug in SQL Relay 0.40

[Manuel S. <man...@sy...>]

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