Re: [Sqlrelay-discussion] LD_PRELOAD problem

[D. V. <as...@gm...>]

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