[Sqlrelay-discussion] Listener hangs on query

[Jamie A L. <ja...@ja...>]

Hello,

I'm trying to get a pretty simple sqlrelay setup working. Config:

<?xml version="1.0"?>
<!DOCTYPE instances SYSTEM "sqlrelay.dtd">

<instances>

         <instance id="gab" port="9000" socket="/tmp/sqlrelay.socket"  
dbase="mysql" connections="20" maxconnections="20" maxqueuelength="5"  
growby="1" ttl="60" endofsession="commit" sessiontimeout="600"  
runasuser="sqlrelay" runasgroup="sqlrelay" cursors="5"  
authtier="listener" handoff="pass" deniedips="" allowedips="(127\.0\. 
0\.1|209\.212\.93\.52)" debug="listener_and_connection">
                 <users>
                         <user user="jal" password="xxx"/> -->
                 </users>
                 <connections>
                         <connection connectionid="gab"  
string 
="user=jal;password=xxx;db=gab;host=127.0.0.1;port=3306;fakebinds=no;"  
metric="1"/>
                 </connections>
         </instance>

</instances>


Symptom:

I start sqlrsh, try to ping, and it hangs forever:

[jal@zipp ~]$ sqlrsh localhost 9000 /tmp/sqlrelay.socket jal xxx
SQLRShell - Version 0.22
	Connected to: localhost:9000 as jal

	type help; for a help.

0> ping;


The logs seem to indicate that it is hanging on getting a connection:

::::::::::::::
sqlr-listener.8041
::::::::::::::
03/24/2008 13:58:37 EDT listener [8041] : creating shared memory and  
semaphores

03/24/2008 13:58:37 EDT listener [8041] : id filename:

03/24/2008 13:58:37 EDT listener [8041] : /var/sqlrelay/tmp/gab

03/24/2008 13:58:37 EDT listener [8041] : 	creating shared memory...

03/24/2008 13:58:37 EDT listener [8041] : 	creating semaphores...

03/24/2008 13:58:37 EDT listener [8041] : waiting for client  
connection...

03/24/2008 13:59:08 EDT listener [8041] : done waiting for client  
connection

03/24/2008 13:59:08 EDT listener [8041] : forked a child: 8092

03/24/2008 13:59:08 EDT listener [8041] : waiting for client  
connection...

::::::::::::::
sqlr-listener.8092
::::::::::::::
03/24/2008 13:59:08 EDT listener [8092] : getting authentication...

03/24/2008 13:59:08 EDT listener [8092] : 	listener-based  
authentication succeeded

03/24/2008 13:59:08 EDT listener [8092] : incrementing session count...

03/24/2008 13:59:08 EDT listener [8092] : 	1

03/24/2008 13:59:08 EDT listener [8092] : done incrementing session  
count

03/24/2008 13:59:08 EDT listener [8092] : getting a connection...

This is on FC5, with Mysql 5.0.22 and Sqlrelay from sqlrelay-0.33.1- 
fr0.2.i386.rpm, and rudiments-0.25.1-fr1.i386.rpm

Anyone have any ideas?

Thanks,

-j