[Sqlrelay-discussion] Listener hangs on query
Brought to you by:
mused
From: Jamie A L. <ja...@ja...> - 2008-03-24 17:59:36
|
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 |