[Sqlrelay-discussion] Problems with MySQL 5.0.37

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

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" 
runasuser="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