Re: [Sqlrelay-discussion] Problems with MySQL 5.0.37

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

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.zserv.tuwien.ac.at/mroth/
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