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

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

David Muse wrote:
> 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
>>
>>     
>
>
> -------------------------------------------------------------------------
> 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
>
>
> It just sits there doing nothing when I try to connect. I have no idea why, but everything else is exactly as specified. I wonder if it may be the library and my current mysql version.
>