[Sqlrelay-discussion] Connecting to sql relay from mysql client
Brought to you by:
mused
|
From: CyberGod <cyb...@li...> - 2007-06-08 12:53:30
|
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
|