Re: [Sqlrelay-discussion] Sqlrelay 0.39.4 + dropin mysql library + PHP 5.1.6 + MySQL 5.0.22

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

David Muse wrote:
> PHP actually contains it's own copy of the mysql client library that is
> compiled into PHP itself.  Since it doesn't dynamically load the mysql
> client library, it can't be overridden with the SQL Relay drop-in
> library.

Oh, This explains why there is that license exception for PHP :)

> A long time ago, it was possible to build PHP such that it dynamically
> linked in the mysql client library.  But I don't believe that option
> exists any more, and may not have for a while.

What would that option have been or where to look if one might want to
search that possibility? Then these configure parameters must just mean 
that they are not builded into php binary itself 
'--with-mysql=shared,/usr' '--with-mysqli=shared,/usr/bin/mysql_config'
but they still use own mysql code?

> Unfortunately, at this time, the only solution would be to find a
> version of PHP that dynamically links to mysql and use it if you can.

Most probably too old PHP's and not suitable for OO coding.

> I've been looking into what it would take to remap mysql calls in PHP,
> but I haven't come up with a solution yet.
> Sorry for the bad news.

Well, we made couple of classes to emulate PDO's basic features which
we need. More work and not so nice but it seems to do it's work and 
that's what counts.

And of course requests are easy to say and the coding is a big job
but PDO or MDB2 driver for sqlrelay would be nice. As Pear DB is now 
"obsolete" and superseded with MDB2. Pear DB doesn't feel like the right
choice to use in new projects.

> David Muse
> dav...@fi...
> 
> On Thu, 2008-06-05 at 11:34 +0300, Jani Ollikainen wrote:
>> Jani Ollikainen wrote:
>>
>> And if this helps I straced the normal mysql client:
>>
>> connect(3, {sa_family=AF_FILE, path="/tmp/sqlrelay.sock"}, 110) = 0
>> setsockopt(3, SOL_TCP, TCP_NODELAY, [1], 4) = -1 EOPNOTSUPP (Operation 
>> not suppo
>> rted)
>> write(3, "\0\0\0\10sqlrelay\0\0\0\tpass", 25) = 25
>> read(3, "\0\1\0\0", 8192)               = 4
>> write(3, "\0\v\0\0\0\10sqlrelay\0\0\0\tpass", 27) = 27
>> read(3, "\0\1", 8192)                   = 2
>>
>> It write()'s before tries to read() which PHP mysql
>> doesn't do.
>>
>> PHP code for connection is:
>>
>> try {
>>      $dbh = new 
>> PDO("mysql:unix_socket=/tmp/sqlrelay.sock;dbname=www",_SQLUSER, _SQLPASS);
>> } catch (PDOException $e) {
>>      echo 'Connection failed: ' . $e->getMessage();
>> }
>>
>> And the _SQLUSER and _SQLPASS are the user/pass for
>> sqlrelay not for the mysql.
>>
>> With LD_PRELOAD defined the normal mysqlsocket connection
>> works..
>>
>> connect(3, {sa_family=AF_FILE, path="/var/lib/mysql/mysql.sock"}, 110) = 0
>> setsockopt(3, SOL_IP, IP_TOS, [8], 4)   = -1 EOPNOTSUPP (Operation not 
>> supported
>> )
>> setsockopt(3, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0
>> read(3, "8\0\0\0\n5.0.22-log\0\371\4\0\0]Z,iN)#q\0,\242\10"..., 16384) = 60
>>
>> So it seems like for some reason the LD_PRELOAD won't do it's trick?
>>
>>
>>> Hi,
>>>
>>> Subject is the problem.
>>>
>>> If I set the LD_PRELOAD cli mysql client
>>> can connect and works nicely.
>>>
>>> But with PHP neither pdo_mysql or mysql
>>> works. It just hangs when connecting.
>>>
>>> Strace says it is trying to connect the
>>> right socket but it just cannot get anything from there.
>>>
>>> Any ideas?
>>>
>>> The system is CentOS.
>>>
>>> Strace output:
>>> connect(3, {sa_family=AF_FILE, path="/tmp/sqlrelay.sock"}, 110) = 0
>>> setsockopt(3, SOL_IP, IP_TOS, [8], 4)   = -1 EOPNOTSUPP (Operation not 
>>> supported)
>>> setsockopt(3, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0
>>> read(3,
>>>
>>> # ldd php-cli
>>>          linux-gate.so.1 =>  (0x00110000)
>>>          /usr/lib/libmysql50sqlrelay.so (0x0018a000)
>>>          libcrypt.so.1 => /lib/libcrypt.so.1 (0x00cf3000)
>>>          libaspell.so.15 => /usr/lib/libaspell.so.15 (0x005e4000)
>>>          libpspell.so.15 => /usr/lib/libpspell.so.15 (0x00ce8000)
>>>          libgmp.so.3 => /usr/lib/sse2/libgmp.so.3 (0x003ff000)
>>>          libdb-4.3.so => /lib/libdb-4.3.so (0x006a7000)
>>>          libpthread.so.0 => /lib/libpthread.so.0 (0x00c78000)
>>>          libcurl.so.3 => /usr/lib/libcurl.so.3 (0x005a6000)
>>>          libbz2.so.1 => /usr/lib/libbz2.so.1 (0x00de6000)
>>>          libz.so.1 => /usr/lib/libz.so.1 (0x00cd3000)
>>>          libpcre.so.0 => /lib/libpcre.so.0 (0x00dc7000)
>>>          libresolv.so.2 => /lib/libresolv.so.2 (0x00d4a000)
>>>          libm.so.6 => /lib/libm.so.6 (0x00c91000)
>>>          libdl.so.2 => /lib/libdl.so.2 (0x00c2a000)
>>>          libnsl.so.1 => /lib/libnsl.so.1 (0x00d23000)
>>>          libxml2.so.2 => /usr/lib/libxml2.so.2 (0x00472000)
>>>          libgssapi_krb5.so.2 => /usr/lib/libgssapi_krb5.so.2 (0x00d97000)
>>>          libkrb5.so.3 => /usr/lib/libkrb5.so.3 (0x00323000)
>>>          libk5crypto.so.3 => /usr/lib/libk5crypto.so.3 (0x00d5f000)
>>>          libcom_err.so.2 => /lib/libcom_err.so.2 (0x00ae3000)
>>>          libssl.so.6 => /lib/libssl.so.6 (0x003b8000)
>>>          libcrypto.so.6 => /lib/libcrypto.so.6 (0x001ee000)
>>>          libidn.so.11 => /usr/lib/libidn.so.11 (0x00435000)
>>>          libc.so.6 => /lib/libc.so.6 (0x00ae8000)
>>>          libsqlrclient-0.39.4.so.1 => /usr/lib/libsqlrclient-0.39.4.so.1 
>>> (0x00111000)
>>>          librudiments-0.31.so.1 => /usr/lib/librudiments-0.31.so.1 
>>> (0x0079e000)
>>>          librt.so.1 => /lib/librt.so.1 (0x0012a000)
>>>          libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x0081a000)
>>>          libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x00d3c000)
>>>          /lib/ld-linux.so.2 (0x00ac6000)
>>>          libkrb5support.so.0 => /usr/lib/libkrb5support.so.0 (0x00d87000)
>>>          libkeyutils.so.1 => /lib/libkeyutils.so.1 (0x00d92000)
>>>          libselinux.so.1 => /lib/libselinux.so.1 (0x00cba000)
>>>          libsepol.so.1 => /lib/libsepol.so.1 (0x00c30000)
>>>
>>> -------------------------------------------------------------------------
>>> 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
>>
>> -------------------------------------------------------------------------
>> 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 O T E A S Y - "Join the web hosting revolution!"
>>              http://www.doteasy.com
> 
> 
> 
> __________________________________________________
> 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