Re: [Sqlrelay-discussion] LD_PRELOAD problem
Brought to you by:
mused
|
From: D. V. <as...@gm...> - 2008-06-19 08:43:47
|
It was. Later I managed to get it working, but unfortunately got informed by a later letter of yours, that PHP cannot be subject of this 'cheat', as it uses it's own libraries to connect to mysql. My notes/questions on it: - can it be workarounded by starting PHP as standalone process (for example, as FastCGI) - i'll try to get mysql-proxy work with this, but as mysql-proxy executes queries as well as accepts them, i'm not sure what will be the results of the LD_PRELOAD tweak asd On Thu, Jun 12, 2008 at 11:41 PM, David Muse <dav...@fi...> wrote: > It looks like the LD_PRELOAD part is working. The: > > Failed to get a cursor id. > A network error may have ocurred. > > Error is a sqlrelay client error, not a mysql error. So I believe that > the mysql client is using the drop-in replacement library. The > host/port/user/password may not be correct. Double-check those. > > David Muse > dav...@fi... > > On Fri, 2008-06-06 at 09:35 +0200, Dániel Vásárhelyi wrote: >> Hello, >> >> I've got a problem with the mysql drop-in replacement library on Debian 4.0 >> >> Basically this: >> vm-99:~# ldd `which mysql` | grep sql >> libmysqlclient.so.15 => /usr/lib/libmysqlclient.so.15 (0xb7d0a000) >> vm-99:~# LD_PRELOAD=/usr/lib/libmysql50sqlrelay-0.37.1.so.1 ldd `which >> mysql` | grep sql >> /usr/lib/libmysql50sqlrelay-0.37.1.so.1 (0xb7eea000) >> libmysqlclient.so.15 => /usr/lib/libmysqlclient.so.15 (0xb7c9a000) >> libsqlrclient-0.37.1.so.1 => >> /usr/lib/libsqlrclient-0.37.1.so.1 (0xb79ca000) >> >> It seems regardless I specify the mysql replacement library, the mysql >> client library (which I've used for testing) was somehow "forced" to >> use the original one. >> >> It isn't working: >> >> vm-99:~# LD_PRELOAD=/usr/lib/libmysql50sqlrelay-0.37.1.so.1 mysql >> --host=localhost --port=9000 --user=root -p >> Enter password: >> Welcome to the MySQL monitor. Commands end with ; or \g. >> Your MySQL connection id is 0 >> Server version: 5.0.0 >> >> Type 'help;' or '\h' for help. Type '\c' to clear the buffer. >> >> mysql> show tables; >> ERROR: >> Failed to get a cursor id. >> A network error may have ocurred. >> mysql> >> >> Do anyone have an idea why does it happen? >> >> asd > > > > __________________________________________________ > D O T E A S Y - "Join the web hosting revolution!" > http://www.doteasy.com > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > -- Dániel Vásárhelyi "He who asks a question is a fool for five minutes; he who does not ask a question remains a fool forever" Chinese proverb |