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.
>
|
