[Sqlrelay-discussion] SQL Relay 0.41 Couldn't parse config file sqlrelay.conf

[Olivia <oli...@ya...>]

Hi all,

I've installed SQL Relay 0.41. There is error when I try to run it. Initially my sqlrelay.conf is like this:
------START CONFIG---------------
<?xml version="1.0"?>
<!DOCTYPE instances SYSTEM "sqlrelay.dtd">
<instances>
	<instance id="mysql1" port="9000" socket="/tmp/mysql1.socket" dbase="mysql" connections="3" maxconnections="20" maxqueuelength="2" growby="1" ttl="60" maxsessioncount="10" endofsession="commit" sessiontimeout="600" runasuser="nobody" runasgroup="nobody" cursors="5" authtier="listener" handoff="pass" deniedips="" allowedips="" debug="none" maxquerysize="65536" maxstringbindvaluelength="32768" maxlobbindvaluelength="71680" idleclienttimeout="-1" maxlisteners="-1" listenertimeout="0" reloginatstart="no" timequeriessec="-1" timequeriesusec="-1">
		<users>
			<user user="user" password="pw"/>
		</users>
		<connections>
			<connection connectionid="mysql1" string="user=me;password=pass;db=db1;socket=/var/lib/mysql/mysql.sock" metric="1" behindloadbalancer="no"/>
		</connections>
	</instance>

</instances>
------END CONFIG---------------

When I run "sqlr-start -id mysql1", I get this:
--------START ERR MSG--------
Starting listener:
  sqlr-listener -id mysql1 -config /usr/local/etc/sqlrelay.conf

Starting 3 connections to mysql1 :
  sqlr-connection-mysql -id mysql1 -connectionid mysql1 -config /usr/local/etc/sqlrelay.conf
  sqlr-connection-mysql -id mysql1 -connectionid mysql1 -config /usr/local/etc/sqlrelay.conf
  sqlr-connection-mysql -id mysql1 -connectionid mysql1 -config /usr/local/etc/sqlrelay.conf

Starting scaler:
  sqlr-scaler -id mysql1 -config /usr/local/etc/sqlrelay.conf

sqlr-scaler error: 
	The file /usr/local/var/sqlrelay/tmp/pids/sqlr-listener-mysql1 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.


Thanks to MP3.com for sponsoring: 
	Clustered/Replicated database support.
	Perl API.
Thanks to FeedLounge for sponsoring: 
	Query routing and filtering.
--------END ERR MSG--------

I followed a solution found at:
http://sourceforge.net/mailarchive/forum.php?thread_name=59D43F9401ECAC43BD3FADCC97D850A9012643DB%40sysm0030.sysinf.local&forum_name=sqlrelay-discussion

and added a dummy instance as first entry. When I try to run again, I get this error:
Couldn't parse config file /usr/local/etc/sqlrelay.conf.
Couldn't find id mysql1.

I've checked and sqlrelay.conf is readable by all groups. So I assume it must a problem with the XML parser. I'm using 0.41 while the person giving the solution is using 0.40. Not sure is there is any change in both versions that makes the solution not working.

Anyone knows of a solution? Or will this be fixed in the coming versions?

Thanks,
Olivia