Re: [Sqlrelay-discussion] Problems with MySQL 5.0.37

[Michael R. <mr...@ma...>]

With MySQL 3.23 as client connecting to MySQL 5.0.37 it works well.

Client Configuration:

MySQL 3.23.58
Red Hat Enterprise Linux AS release 3 (Taroon Update 9)
rudiments 0.30
sqlrelay 0.38

I think there is an incompatibility between "/usr/bin/mysql" from MySQL 
5.0.37 and the sqlrelay library "/usr/local/lib/libmysql50sqlrelay.so".
I will do some more tests.


Michael Roth schrieb:
> I tried:
>
> # /usr/bin/mysql -h test1 -P 9000 --user=mysqltest --password=mysqltest
>
> The command still hangs and do nothing.
>
> When I try:
>
> # /usr/bin/mysql -h test5 --user=xxx --user=xxx
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 159
> Server version: 5.0.26-standard-log MySQL Community Edition - Standard 
> (GPL)
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql>
>
> Everything works , the connection is ok !
>
> I would really need sqlrelay for a project, and I don't like to do it 
> with "sequoia" because of its complexity.
>
> Thanks
> Michael
>
>
>> Try using:
>>
>>  
>>
>>  # /usr/bin/mysql -h test1 -P 9000 --user=mysqltest --password=mysqltest
>>
>>  
>>
>>  the user/password need to be the ones defined in the sqlrelay.conf 
>> file,
>>
>>  not the database's user/password.
>>
>>  
>>
>>  Alternatively, you could set authtier="database" and use the db
>>
>>  user/pass.
>>
>>  
>>
>>  David Muse
>>
>>  david.muse@fi...I cannot connect to sqlrelay using the mysql client.
>> I have the following configuration:
>>
>> MySQL 5.0.37
>> rudiments 0.30
>> sqlrelay 0.38
>> Red Hat Enterprise Linux AS release 4 (Nahant Update 5)
>>
>> sqlrelay.conf
>>
>> <?xml version="1.0"?>
>> <!DOCTYPE instances SYSTEM "sqlrelay.dtd">
>> <instances>
>>
>>         <instance id="mysqltest" port="9000" socket="/tmp/mysql.sock" 
>> dbase="mysql" connections="3" maxconnections="5" maxqueuelength="0" 
>> growby="1" ttl="60" endofsession="commit" sessiontimeout="600" 
>> runauser="nobody" runasgroup="nobody" cursors="5" authtier="listener" 
>> handoff="pass">
>>                 <users>
>>                         <user user="mysqltest" password="mysqltest"/>
>>                 </users>
>>                 <connections>
>>                         <connection connectionid="mysqltest" 
>> string="user=xxx;password=xxx;db=testdb;host=test5" metric="1"/>
>>                 </connections>
>>         </instance>
>>
>> </instances>
>>
>> I'have started the instance using sqlr-start, then I've check the 
>> connection using sqlrsh, everything looks allright.
>>
>> # sqlrsh  -id mysqltest
>> SQLRShell - Version 0.22
>>         Connected to: localhost:9000 as mysqltest
>>
>>         type help; for a help.
>>
>> 0> ping;
>>         The database is up.
>> 0> quit;
>> #
>>
>> I tried to connect to sqlrelay using the following commands:
>>
>> # LD_PRELOAD=/usr/local/lib/libmysql50sqlrelay.so
>> # export LD_PRELOAD
>> # ldd /usr/bin/mysql
>>         /usr/local/lib/libmysql50sqlrelay.so (0x00804000)
>>         libncurses.so.5 => /usr/lib/libncurses.so.5 (0x049af000)
>>         libpthread.so.0 => /lib/tls/libpthread.so.0 (0x00499000)
>>         libcrypt.so.1 => /lib/libcrypt.so.1 (0x00d93000)
>>         libnsl.so.1 => /lib/libnsl.so.1 (0x00d7b000)
>>         libm.so.6 => /lib/tls/libm.so.6 (0x0037b000)
>>         libc.so.6 => /lib/tls/libc.so.6 (0x0024d000)
>>         libsqlrclient-0.38.so.1 => 
>> /usr/local/lib/libsqlrclient-0.38.so.1 (0x006ec000)
>>         librudiments-0.30.so.1 => 
>> /usr/local/lib/librudiments-0.30.so.1 (0x00595000)
>>         libssl.so.4 => /lib/libssl.so.4 (0x00d45000)
>>         libcrypto.so.4 => /lib/libcrypto.so.4 (0x00881000)
>>         libgssapi_krb5.so.2 => /usr/lib/libgssapi_krb5.so.2 (0x0086b000)
>>         libkrb5.so.3 => /usr/lib/libkrb5.so.3 (0x00111000)
>>         libcom_err.so.2 => /lib/libcom_err.so.2 (0x006cc000)
>>         libk5crypto.so.3 => /usr/lib/libk5crypto.so.3 (0x007ca000)
>>         libresolv.so.2 => /lib/libresolv.so.2 (0x004e2000)
>>         libz.so.1 => /usr/lib/libz.so.1 (0x003a6000)
>>         libpcre.so.0 => /lib/libpcre.so.0 (0x00176000)
>>         librt.so.1 => /lib/tls/librt.so.1 (0x00dea000)
>>         libdl.so.2 => /lib/libdl.so.2 (0x003a0000)
>>         libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x003b6000)
>>         libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x00186000)
>>         /lib/ld-linux.so.2 (0x00233000)
>> # /usr/bin/mysql -h test1 -P 9000 --user=xxx --password=xxx
>>
>> The Command seems to do nothing. I've to press CTRL-C to stop it.
>>
>> What I'm doing wrong ?
>>
>> Thanks,
>> Michael
>>
>>   
>
>


-- 
--------------------------------------------------------------------------
Michael Roth                           email ro...@zi...
Certified Project Management Associate http://www.zid.tuwien.ac.at/michael_roth/
Zentraler Informatikdienst (ZID)       Tel. (++43-1) 588 01 - 42091
Technische Universitaet Wien           Fax. (++43-1) 588 01 - 42099
Wiedner Hauptstr. 8-10, A-1040 Wien