[Sqlrelay-discussion] Connecting to sql relay from mysql client

[CyberGod <cyb...@li...>]

Hi,
I successfully installed, configured and run the software. The only 
problem I have now is how to connect to it form a mysql client. Port 
9000 is open (defined in the config file), the daemons are connected to 
the remote MySQL server based on host ip, user, pass and table and all 
services are running. I can remotely connect directly to the MySQL 
server using the same settings with the mysql command so its not a 
connectivity or mysql issue. Any suggestions where I can find log files 
if any?
Please advice how to test this setup with mysql client (I tried 
something like this: mysql --port=9000 --host=10.0.0.1 -pc@password, 
where the host ip is the ip of the server that sql-relay is running on).

Here's my config file:

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

<instances>
        <!-- Regular SQL Relay Instance -->
        <instance id="example" port="9000" socket="/tmp/example.socket" 
dbase="mysql" connections="3" maxconnections="15" maxqueuelength="5" 
growby="1" ttl="60" endofsession="commit" sessiontimeout="600" 
runasuser="nobody" runasgroup="nobody" cursors="5" authtier="listener" 
handoff="pass" deniedips="" allowedips="" debug="none" 
maxquerysize="65536" maxstringbindvaluelength="4000" 
maxlobbindvaluelength="71680" idleclienttimeout="-1" maxlisteners="-1" 
listenertimeout="0">
                <users>
                        <user user="root" password="pass"/>
                </users>
                <connections>
                        <connection connectionid="db1" 
string="user=root;password=croot;db=test;host=10.0.0.10;port=3306;" 
metric="1" behindloadbalancer="no"/>
                </connections>
        </instance>
</instances>

Running processes:

11490 ?        Ss     0:00 sqlr-listener -id example -config 
/usr/local/firstworks/etc/sqlrelay.conf
11492 ?        Ss     0:00 sqlr-connection-mysql -id example 
-connectionid db1 -config /usr/local/firstworks/etc/sqlrelay.conf
11494 ?        Ss     0:00 sqlr-connection-mysql -id example 
-connectionid db1 -config /usr/local/firstworks/etc/sqlrelay.conf
11496 ?        Ss     0:00 sqlr-connection-mysql -id example 
-connectionid db1 -config /usr/local/firstworks/etc/sqlrelay.conf
11502 ?        Ss     0:00 sqlr-cachemanager


Thanks.
Konstantin