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

[David M. <dav...@fi...>]

Hello,

Sorry for taking a while to respond.

Make sure you're using the user/pass defined in your sqlrelay.conf file:

mysql --port=9000 --host=10.0.0.1 --user=root --password=pass

Other than that, and assuming you're using the LD_PRELOAD, it should
work.

Dave
dav...@fi...

On Fri, 2007-06-08 at 07:53 -0500, CyberGod wrote:
> 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
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>