Re: Can't use MySQL 5.x Client with PHP 5.x
> Hi Andy,
>
>> First of all thanks a lot for your
help! :)
>>
>>> You need to build PHP yourself
and link it against
>> libmysqlclient.so.15.
>>> This will happen if you install
>>
libmysqlclient15-dev >= 5.0 and then
>>>
dpkg-buildpackage the
>> PHP5 source package.
>>
>> Is there no way to use the great
>> realease of
php5 of backports.org? PHP 5 works very nice now and if
>>
there
>> is any other way I would let it be to compiling
around. What I need is
>> the
>> same version of
PHP 5 like backports.org's but with MySQL 5 support. So
>> it
>> would be easier to keep it up to date without compiling it
every time
>> again.
>
> No, I just noticed,
the version on Bpo is linked against
> libmysqlclient12, because
that is 'the way to go' on a Sarge system. If
> you want to link
against a newer library, you have to build it yourself.
>
>> mysqli:
>> I've installed php5-mysql
(5.2.0-8~bpo.2)
>> but I really can't found the file mysqli.so
on the whole system (even
>> not
>> in
/usr/lib/php5/20060613/). I've reinstalled php5-mysql to be really
>> sure
>> with "apt-get --reinstall install
php5-mysql" but that didn't
>> helps :( What's my fault?
>
> Not your fault. I just figured it out. The
mysqli-extension was removed
> from the Bpo build, for the exact
same reason: you need a newer library
> version to build mysqli,
it won't build against libmysqlclient12. I'm
> sorry, I was wrong
before.
>
> If you need mysqli and don't want to build
anything yourself, you may
> want to check out DotDeb
(http://www.dotdeb.org/) or use my PHP5
> packages from
http://debian.sipo.nl/ (no garantees!).
>
> Best
regards,
>
> Martijn Grendelman
>
>
Hi Marijn,
Thx again for your answer.
It's funny I had the DotDeb releases installed (where mysqli is included,
thats true) but the people from the german Debian-Mailinglist told me to
use backports.org because the DotDeb releases aren't very good (in the
past they had a lot of bugs thats true). But DotDeb's PHP 5 doesn't
support MySQL 5 not like backports.org's PHP 5.
Btw (it seems
to be that it uses libmysql 14):
-rw-r--r-- 1 root root 1219282
2006-08-28 21:15 libmysqlclient.a
-rw-r--r-- 1 root
root 859 2006-08-28 21:15 libmysqlclient.la
-rw-r--r-- 1 root root 1228328 2006-08-28 21:15
libmysqlclient_r.a
-rw-r--r-- 1 root
root 893 2006-08-28 21:15 libmysqlclient_r.la
lrwxrwxrwx 1 root root 22 2006-11-11
23:07 libmysqlclient_r.so -> libmysqlclient_r.so.14
lrwxrwxrwx 1 root root 26 2006-11-11
23:07 libmysqlclient_r.so.12 -> libmysqlclient_r.so.12.0.0
-rw-r--r-- 1 root root 251880 2006-05-11 18:05
libmysqlclient_r.so.12.0.0
lrwxrwxrwx 1 root
root 26 2006-11-11 23:07
libmysqlclient_r.so.14 -> libmysqlclient_r.so.14.0.0
-rw-r--r-- 1 root root 1073864 2006-08-28 21:15
libmysqlclient_r.so.14.0.0
lrwxrwxrwx 1 root
root 26 2007-02-01 15:21
libmysqlclient_r.so.15 -> libmysqlclient_r.so.15.0.0
-rw-r--r-- 1 root root 1900092 2006-12-08 16:21
libmysqlclient_r.so.15.0.0
lrwxrwxrwx 1 root
root 20 2006-11-11 23:07 libmysqlclient.so
-> libmysqlclient.so.14
lrwxrwxrwx 1 root
root 24 2006-11-11 23:07
libmysqlclient.so.12 -> libmysqlclient.so.12.0.0
-rw-r--r--
1 root root 243592 2006-05-11 18:05 libmysqlclient.so.12.0.0
lrwxrwxrwx 1 root root 24 2006-11-11
23:07 libmysqlclient.so.14 -> libmysqlclient.so.14.0.0
-rw-r--r-- 1 root root 1066632 2006-08-28 21:15
libmysqlclient.so.14.0.0
lrwxrwxrwx 1 root
root 24 2007-02-01 15:21
libmysqlclient.so.15 -> libmysqlclient.so.15.0.0
-rw-r--r--
1 root root 1891836 2006-12-08 16:21 libmysqlclient.so.15.0.0
-rw-r--r-- 1 root root 8844442 2006-08-28 21:15 libmysqld.a
So it seems to be that there is really no other way than building
PHP 5 for myself. My problem is that I don't have a lot of experience with
compiling PHP 5. How can I build everything like backports.org version of
PHP 5 but with MySQL 5 and mysqli support? And how do I get then the 3
versions (module, cgi, cli)? Is there a way I can show the build options
of backports.org's PHP 5?
Greets and big THX again,
Andy
Reply to: