RE: pdo_mysql can not find libmysqlclient.so libz.so...SUCCESS!

["Roland Cruse" <roland.cruse@xxxxxxxxxxxx>]

Success!

I compiled php without the --with-pdo-mysql switch.

Then made a pecl directory inside the php source tree then downloaded
the pdo_mysql "pecl download pdo_mysql"
Then untarred the file 

Then did:
./configure --with-pdo-mysql=/usr LDFLAGS='-L/usr/lib'

(maybe this setting would have worked for the php compile...)

Then copied the resulting pdo_mysql.so to my php include library.

Happy ending :)

>-----Original Message-----
>From: Roland Cruse [mailto:roland.cruse@xxxxxxxxxxxx]
>Sent: Wednesday, May 09, 2007 2:18 PM
>To: php-install@xxxxxxxxxxxxx
>Subject: RE:  pdo_mysql can not find libmysqlclient.so
libz.so
>
>
>>
>>Actually, check the two files it claims are missing.  Typically, those
>>files are actually symbolic links (e.g. /usr/lib/libmysqlclient.so ->
>>/usr/lib/libmysqlclient.so.14) and same for libz
>>
>>--Graham Frank
>
>Thanks. I did not realize they where links.
>I checked and the "missing" files (links) do point to existing files.
>
>lrwxrwxrwx 1 root root      24 May  9 14:00 /usr/lib/libmysqlclient.so
>-> libmysqlclient.so.15.0.0
>lrwxrwxrwx 1 root root      24 May  9 14:00
>/usr/lib/libmysqlclient.so.10 -> libmysqlclient.so.10.0.0
>-rwxr-xr-x 1 root root  224606 Feb 26 08:18
>/usr/lib/libmysqlclient.so.10.0.0
>lrwxrwxrwx 1 root root      24 May  9 14:00
>/usr/lib/libmysqlclient.so.12 -> libmysqlclient.so.12.0.0
>-rwxr-xr-x 1 root root  306483 Feb 26 08:18
>/usr/lib/libmysqlclient.so.12.0.0
>lrwxrwxrwx 1 root root      24 May  9 14:00
>/usr/lib/libmysqlclient.so.14 -> libmysqlclient.so.14.0.0
>-rwxr-xr-x 1 root root 1265956 Feb 26 08:18
>/usr/lib/libmysqlclient.so.14.0.0
>lrwxrwxrwx 1 root root      24 May  9 14:00
>/usr/lib/libmysqlclient.so.15 -> libmysqlclient.so.15.0.0
>-rwxr-xr-x 1 root root 1437860 Feb 26 08:18
>/usr/lib/libmysqlclient.so.15.0.0
>
>And the same with the libz.
>
>The "make" script seems to be looking in /usr/lib/mysql for the missing
>files. When they do exist in /usr/lib These files appear to have come
>from the MySQL-shared-compat rpm.
>
>>
>>----------------------------------------------------------------------
-
>----
>>-----
>>Graham Frank
>>(608) 359-1593
>>Neoservers LLC (http://www.neoservers.com/)
>>Founder and Owner
>>
>>
>>Quoting Roland Cruse <roland.cruse@xxxxxxxxxxxx>:
>>
>>>
>>> Hi
>>>
>>> I am having trouble installing/generating a shared pdo_mysql.
>>>
>>> Php-5.2.1/php-5.2.2
>>> mysql  Ver 14.13 Distrib 5.1.17-beta, official mysql rpm install
>>> 	mysqladmin variables: basedir   /
>>> ...
>>> ./configure \
>>> --with-curl \
>>> --with-apxs2=/usr/local/apache2/bin/apxs \
>>> --with-zlib-dir=/usr/local/include \ --with-zib \ --with-mysql=/usr
\
>>> --enable-pdo=shared \ --with-pdo-mysql=shared,/usr \
>>> --with-pdo-sqlite=shared \ --with-sqlite=shared \ --enable-mbstring
\
>>> --enable-wddx \ --enable-soap \ --enable-calendar \ --enable-bcmath
\
>>> --enable-ftp \ --enable-xmlrpc \ --with-config-file-path=/etc \
>>> --with-xsl=/usr/local \ --with-imap-ssl \
>>> --with-imap=/usr/local/src/imap-2006c \ --with-gd \
>>> --with-t1lib=/usr/include \ --enable-gd-native-ttf \
>--with-ttf=/usr/lib
>>> \ --with-jpeg-dir=/usr/local/src/jpeg-6b/ \ --with-png \
>>> --with-png-dir=/usr/local/src/libpng-1.2.8  \
>>> --with-freetype-dir=/usr/lib \ --with-openssl \
>>> --with-openssl-dir=/usr/local/ssl \ --with-mcrypt \
>>> --with-pfpro=shared,/verisign/payflowpro/linuxrh9 \ --with-ldap \
>>> --with-ldap-sasl=/usr/include/sasl \ --with-ldap-sasl \
>>> --with-mssql=/usr/local/freetds \ --enable-pcntl \ ...
>>>
>>> The configure script runs with no errors.
>>>
>>> "make" chokes here.
>>>
>>> gcc: /usr/lib/mysql/libmysqlclient.so: No such file or directory
>>> gcc: /usr/lib/mysql/libz.so: No such file or directory
>>> make: *** [ext/pdo_mysql/pdo_mysql.la] Error 1
>>>
>>> Even though:
>>> /usr/local/src/php-5.2.2 # locate libmysqlclient.so
>>> /usr/lib/libmysqlclient.so
>>>
>>> /usr/local/src/php-5.2.2 # locate libz.so /usr/lib/libz.so
>>>
>>>
>
>*****************************************************************
>
>IMPORTANT NOTICE
>
>The information in this e-mail and any attached files is CONFIDENTIAL
and
>may be legally privileged or prohibited from disclosure and
unauthorized
>use. The views of the author may not necessarily reflect those of the
>Company. This communication is intended solely for the addressee, or
the
>employee or agent responsible for delivering such materials to the
>addressee. If you have received this message in error please return it
to
>the sender then delete the email and destroy any copies of it. If you
are
>not the intended recipient, any form of reproduction, dissemination,
>copying, disclosure, modification, distribution and/or publication or
any
>action taken or omitted to be taken in reliance upon this message or
its
>attachments is prohibited and may be unlawful.
>
>
>At present the integrity of e-mail across the Internet cannot be
guaranteed
>and messages sent via this medium are potentially at risk. All
liability is
>excluded to the extent permitted by law for any claims arising as a
result
>of the use of this medium to transmit information by or to VillaDirect
>Management LLC.

*****************************************************************

IMPORTANT NOTICE

The information in this e-mail and any attached files is CONFIDENTIAL and may be legally privileged or prohibited from disclosure and unauthorized use. The views of the author may not necessarily reflect those of the Company. This communication is intended solely for the addressee, or the employee or agent responsible for delivering such materials to the addressee. If you have received this message in error please return it to the sender then delete the email and destroy any copies of it. If you are not the intended recipient, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication or any action taken or omitted to be taken in reliance upon this message or its attachments is prohibited and may be unlawful.

At present the integrity of e-mail across the Internet cannot be guaranteed and messages sent via this medium are potentially at risk. All liability is excluded to the extent permitted by law for any claims arising as a result of the use of this medium to transmit information by or to VillaDirect Management LLC.