[Sqlrelay-discussion] listener not listening on port
Brought to you by:
mused
|
From: Andre H. <and...@gm...> - 2010-04-14 09:42:09
|
Hello List, do my first steps with sqlrelay. I installed original packages which were delivered by Ubuntu 8.04.4 LTS, Version should be 0.38 My conf is still simple. i created a listener and a connection to mysql on other host. the connection to mysql is created and seems to work but there is no listener listening on host where sqlrelay is running. also no socket is created. i cant find a explanation (no other process on port 9000) This is the startup output: ### Starting SQL Relay ... Starting listener: sqlr-listener-debug -id my_server_id -config /etc/sqlrelay/sqlrelay.conf & Debugging to: /var/cache/sqlrelay/debug/sqlr-listener.7298 Starting 1 connections to db1 : sqlr-connection-mysql -id my_server_id -connectionid db1 -config /etc/sqlrelay/sqlrelay.conf Starting 1 connections to defaultid : sqlr-connection-mysql -id my_server_id -connectionid defaultid -config /etc/sqlrelay/sqlrelay.conf mysql_real_connect failed: Access denied for user 'sqlrelay'@'localhost' (using password: NO) Couldn't log into database. sqlr-connection-mysql failed to start. Starting scaler: sqlr-scaler -id my_server_id -config /etc/sqlrelay/sqlrelay.conf Starting cache manager: sqlr-cachemanager Warning: using default id. Thanks to MP3.com for sponsoring: Clustered/Replicated database support. Perl API. Thanks to FeedLounge for sponsoring: Query routing and filtering. . ### i wonder why defaultid also is used. i dont use it in my conf and dont find any part where its used. is this efffecting the listener? listener debug log only says: ### creating shared memory and semaphores id filename: /var/cache/sqlrelay/tmp/ipc/dd25012 creating shared memory... creating semaphores... ### this is my current conf: ### <?xml version="1.0"?> <!DOCTYPE instances SYSTEM "sqlrelay.dtd"> <instances> <!-- Regular SQL Relay Instance --> <instance id="my_server_id" addresses="0.0.0.0" port="9000" socket="/tmp/sqlrelay.socket" dbase="mysql" connections="3" maxconnections="15" maxqueuelength="5" growby="1" ttl="60" endofsession="commit" sessiontimeout="600" runasuser="sqlrelay" runasgroup="sqlrelay" cursors="5" authtier="listener" handoff="pass" deniedips="" allowedips="" debug="listener" maxquerysize="65536" maxstringbindvaluelength="4000" maxlobbindvaluelength="71680" idleclienttimeout="-1" maxlisteners="25" listenertimeout="0"> <users> <user user="user1" password="password1"/> </users> <connections> <connection connectionid="db1" string="user=mysqluser;password=mysqlpass;db=mysqldb;host=mysqlhost;port=3306;fakebinds=no" metric="1" behindloadbalancer="no"/> </connections> <router> </router> </instance> </instances> ### What could be the issue? I dont find any fault. Thanks, Andre |