Compiling PHP with mysql

**Jerry Stuckle** · Mar 28 '07, 08:05 PM

Re: Compiling PHP with mysql

Jagadish Kumar, Maripi wrote:

Hi,
I got the following error while trying to compile php with mysql. I would be
glad if anyone can help me on this. Here is the error that i've got in
config.log
>
The command i used is:
./configure --prefix=/opt1/php.5.2.1 --with-oci8=instantcli ent,/opt1/oracle_instantc lient_10_2
\
>
--with-apxs2=/spare/WWW2/bin/apxs --enable-sigchild --with-libxml-dir=/opt1/xml2
\
>
--with-config-file-path=/spare/WWW2/conf --with-mysql=/spare/mysql
\
>
--with-zlib-dir=/opt1/zlib
>
>
>
configure:57708 : checking for MySQL support
configure:57754 : checking for specified location of the MySQL UNIX socket
configure:57811 : checking for MySQL UNIX socket location
configure:58001 : checking for mysql_close in -lmysqlclient
configure:58020 : gcc -o
onftest -I/usr/include -g -O2 -D_POSIX_PTHREAD _SEMANTICS -R/spare/mysql/lib
-L/spare/mysql/lib -L/usr/lib -R/usr/ucblib -L/usr/ucblib -R/opt/jmaripi/gcc/lib/gcc/sparc-sun-solaris2.9/4.0.4
-L/opt/jmaripi/gcc/lib/gcc/sparc-sun-solaris2.9/4.0.4 -R/opt1/libxml2.2.6.27/lib
-L/opt1/libxml2.2.6.27/lib -R/opt1/zlib/lib -L/opt1/zlib/lib
conftest.c -lmysqlclient -lz -lresolv -lm -ldl -lnsl -lsocket -lgcc -lxml2
-lz -lm -lsocket -lnsl -lxml2 -lz -lm -lsocket -lnsl 1>&5
ld: warning: file /spare/mysql/lib/libmysqlclient. a(libmysql.o): wrong ELF
class: ELFCLASS64
Undefined first referenced
symbol in file
mysql_close /var/tmp//ccdtPtSd.o
ld: fatal: Symbol referencing errors. No output written to conftest
collect2: ld returned 1 exit status
configure: failed program was:
#line 58009 "configure"
#include "confdefs.h "
/* Override any gcc2 internal prototype to avoid an error. */
/* We use char because int might match the return type of a gcc2
builtin and then its argument prototype would still apply. */
char mysql_close();
>
int main() {
mysql_close()
; return 0; }
configure:58241 : checking for mysql_error in -lmysqlclient
configure:58260 : gcc -o
onftest -I/usr/include -g -O2 -D_POSIX_PTHREAD _SEMANTICS -R/spare/mysql/lib
-L/spare/mysql/lib -R/opt1/zlib/lib -L/opt1/zlib/lib -L/usr/lib -R/usr/ucblib
-L/usr/ucblib -R/opt/jmaripi/gcc/lib/gcc/sparc-sun-solaris2.9/4.0.4 -L/opt/jmaripi/gcc/lib/gcc/sparc-sun-solaris2.9/4.0.4
-R/opt1/libxml2.2.6.27/lib -L/opt1/libxml2.2.6.27/lib -R/opt1/zlib/lib -L/opt1/zlib/lib
-R/opt1/zlib -L/opt1/zlib
conftest.c -lmysqlclient -lz -lz -lresolv -lm -ldl -lnsl -lsocket -lgcc -lxml2
-lz -lm -lsocket -lnsl -lxml2 -lz -lm -lsocket -lnsl 1>&5
ld: warning: file /spare/mysql/lib/libmysqlclient. a(libmysql.o): wrong ELF
class: ELFCLASS64
Undefined first referenced
symbol in file
mysql_error /var/tmp//ccwk7Kaa.o
ld: fatal: Symbol referencing errors. No output written to conftest
collect2: ld returned 1 exit status
configure: failed program was:
#line 58249 "configure"
#include "confdefs.h "
/* Override any gcc2 internal prototype to avoid an error. */
/* We use char because int might match the return type of a gcc2
builtin and then its argument prototype would still apply. */
char mysql_error();
>
int main() {
mysql_error()
; return 0; }
>
>
Thank you,
Jagadish
>
>

Just a wild guess. Do you have more than one version of MySQL on your
system? It looks like it may be picking up headers from one version but
the lib from another one.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===

**Jagadish Kumar, Maripi** · Mar 28 '07, 08:55 PM

Re: Compiling PHP with mysql

No, I just have one version of mysql on the system and it is on
/spare/mysql/.
This is a Sun Solaris SPARC 9 machine. I have a guess but i'm not sure it is
the problem though. It is looking for MySQL Unix Socket but it doesn't find
it. Can anyone provide me information on this? or can help me in figuring
out the cause of the error.

Thank you,
Jagadish

"Jerry Stuckle" <jstucklex@attg lobal.netwrote in message
news:mvGdnUFtNe R6VJfbnZ2dnUVZ_ rTinZ2d@comcast .com...

Jagadish Kumar, Maripi wrote:

>Hi,
>I got the following error while trying to compile php with mysql. I would
>be glad if anyone can help me on this. Here is the error that i've got in
>config.log
>>
>The command i used is:
>./configure --prefix=/opt1/php.5.2.1 --with-oci8=instantcli ent,/opt1/oracle_instantc lient_10_2
>\
>>
> --with-apxs2=/spare/WWW2/bin/apxs --enable-sigchild --with-libxml-dir=/opt1/xml2
>\
>>
> --with-config-file-path=/spare/WWW2/conf --with-mysql=/spare/mysql
>\
>>
> --with-zlib-dir=/opt1/zlib
>>
>>
>>
>configure:5770 8: checking for MySQL support
>configure:5775 4: checking for specified location of the MySQL UNIX socket
>configure:5781 1: checking for MySQL UNIX socket location
>configure:5800 1: checking for mysql_close in -lmysqlclient
>configure:5802 0: gcc -o
>nftest -I/usr/include -g -O2 -D_POSIX_PTHREAD _SEMANTICS -R/spare/mysql/lib
> -L/spare/mysql/lib -L/usr/lib -R/usr/ucblib -L/usr/ucblib -R/opt/jmaripi/gcc/lib/gcc/sparc-sun-solaris2.9/4.0.4
> -L/opt/jmaripi/gcc/lib/gcc/sparc-sun-solaris2.9/4.0.4 -R/opt1/libxml2.2.6.27/lib
> -L/opt1/libxml2.2.6.27/lib -R/opt1/zlib/lib -L/opt1/zlib/lib
>conftest.c -lmysqlclient -lz -lresolv -lm -ldl -lnsl -lsocket -lgcc -lxml2
> -lz -lm -lsocket -lnsl -lxml2 -lz -lm -lsocket -lnsl 1>&5
>ld: warning: file /spare/mysql/lib/libmysqlclient. a(libmysql.o): wrong
>ELF class: ELFCLASS64
>Undefined first referenced
> symbol in file
>mysql_close /var/tmp//ccdtPtSd.o
>ld: fatal: Symbol referencing errors. No output written to conftest
>collect2: ld returned 1 exit status
>configure: failed program was:
>#line 58009 "configure"
>#include "confdefs.h "
>/* Override any gcc2 internal prototype to avoid an error. */
>/* We use char because int might match the return type of a gcc2
> builtin and then its argument prototype would still apply. */
>char mysql_close();
>>
>int main() {
>mysql_close( )
>; return 0; }
>configure:5824 1: checking for mysql_error in -lmysqlclient
>configure:5826 0: gcc -o
>nftest -I/usr/include -g -O2 -D_POSIX_PTHREAD _SEMANTICS -R/spare/mysql/lib
> -L/spare/mysql/lib -R/opt1/zlib/lib -L/opt1/zlib/lib -L/usr/lib -R/usr/ucblib
> -L/usr/ucblib -R/opt/jmaripi/gcc/lib/gcc/sparc-sun-solaris2.9/4.0.4 -L/opt/jmaripi/gcc/lib/gcc/sparc-sun-solaris2.9/4.0.4
> -R/opt1/libxml2.2.6.27/lib -L/opt1/libxml2.2.6.27/lib -R/opt1/zlib/lib -L/opt1/zlib/lib
> -R/opt1/zlib -L/opt1/zlib
>conftest.c -lmysqlclient -lz -lz -lresolv -lm -ldl -lnsl -lsocket -lgcc
> -lxml2 -lz -lm -lsocket -lnsl -lxml2 -lz -lm -lsocket -lnsl 1>&5
>ld: warning: file /spare/mysql/lib/libmysqlclient. a(libmysql.o): wrong
>ELF class: ELFCLASS64
>Undefined first referenced
> symbol in file
>mysql_error /var/tmp//ccwk7Kaa.o
>ld: fatal: Symbol referencing errors. No output written to conftest
>collect2: ld returned 1 exit status
>configure: failed program was:
>#line 58249 "configure"
>#include "confdefs.h "
>/* Override any gcc2 internal prototype to avoid an error. */
>/* We use char because int might match the return type of a gcc2
> builtin and then its argument prototype would still apply. */
>char mysql_error();
>>
>int main() {
>mysql_error( )
>; return 0; }
>>
>>
>Thank you,
>Jagadish

>
Just a wild guess. Do you have more than one version of MySQL on your
system? It looks like it may be picking up headers from one version but
the lib from another one.
>
--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===

**Man-wai Chang** · Mar 29 '07, 09:25 AM

Re: Compiling PHP with mysql

Jagadish Kumar, Maripi wrote:

Hi,
I got the following error while trying to compile php with mysql. I would be
glad if anyone can help me on this. Here is the error that i've got in
config.log

What linux distribution?

this is the line I ussed on my Ubuntu:

#!/bin/bash

../configure \
--prefix=/usr \
--sysconfdir=/etc \
--with-config-file-path=/etc \
--enable-track-vars \
--enable-ftp \
--enable-sysvsem \
--enable-sysvshm \
--enable-sockets \
--enable-gd-native-ttf \
--enable-memory-limit \
--enable-trans-sid \
--enable-magic-quotes \
--enable-exif \
--enable-inline-optimization \
--enable-dbase \
--enable-mbstring \
--enable-embedded-mysqli \
--with-mysqli \
--with-gettext \
--with-gd \
--with-calendar=shared \
--with-apxs2=`which apxs2` \
--with-imap \
--with-ncurses \
--with-zlib-dir=/usr \
--with-jpeg-dir=/usr \
--with-png-dir=/usr \
--with-xpm-dir=/usr \
--with-openssl=/usr \
--with-freetype-dir=/usr/include \
--with-mysql=/usr \
--with-kerberos \
--with-imap-ssl

#
# --with-ldap \
# --with-ttf=/usr/X11R6 \
# --with-mm=/usr/mm-1.1.3 \
# --with-pgsql=/usr/local/pgsql \
# --with-pdflib=/usr/local \
#

make

echo -n "Remember to back up /etc/apache/httpd.conf first"
exit
checkinstall

--
iTech Consulting Services Limited
Expert of ePOS solutions
Website: http://www.itech.com.hk (IE only)
Tel: (852)2325 3883 Fax: (852)2325 8288

**Jagadish Kumar, Maripi** · Mar 29 '07, 02:55 PM

Re: Compiling PHP with mysql

Hi,
Thanks for your reply. I am installing this on Sun Solaris SPARC 9.

Thank you,
Jagadish

"Man-wai Chang" <toylet.toylet@ gmail.comwrote in message
news:460b836f$1 @127.0.0.1...

Jagadish Kumar, Maripi wrote:

>Hi,
>I got the following error while trying to compile php with mysql. I would
>be glad if anyone can help me on this. Here is the error that i've got in
>config.log

>
What linux distribution?
>
this is the line I ussed on my Ubuntu:
>
#!/bin/bash
>
./configure \
--prefix=/usr \
--sysconfdir=/etc \
--with-config-file-path=/etc \
--enable-track-vars \
--enable-ftp \
--enable-sysvsem \
--enable-sysvshm \
--enable-sockets \
--enable-gd-native-ttf \
--enable-memory-limit \
--enable-trans-sid \
--enable-magic-quotes \
--enable-exif \
--enable-inline-optimization \
--enable-dbase \
--enable-mbstring \
--enable-embedded-mysqli \
--with-mysqli \
--with-gettext \
--with-gd \
--with-calendar=shared \
--with-apxs2=`which apxs2` \
--with-imap \
--with-ncurses \
--with-zlib-dir=/usr \
--with-jpeg-dir=/usr \
--with-png-dir=/usr \
--with-xpm-dir=/usr \
--with-openssl=/usr \
--with-freetype-dir=/usr/include \
--with-mysql=/usr \
--with-kerberos \
--with-imap-ssl
>
#
# --with-ldap \
# --with-ttf=/usr/X11R6 \
# --with-mm=/usr/mm-1.1.3 \
# --with-pgsql=/usr/local/pgsql \
# --with-pdflib=/usr/local \
#
>
make
>
echo -n "Remember to back up /etc/apache/httpd.conf first"
exit
checkinstall
>
>
--
iTech Consulting Services Limited
Expert of ePOS solutions
Website: http://www.itech.com.hk (IE only)
Tel: (852)2325 3883 Fax: (852)2325 8288

**John Cecere** · Mar 31 '07, 04:15 PM

Re: Compiling PHP with mysql

Jagadish,

ld: warning: file /spare/mysql/lib/libmysqlclient. a(libmysql.o): wrong ELF
class: ELFCLASS64
Undefined first referenced
symbol in file
mysql_close /var/tmp//ccdtPtSd.o

This message here means that you're trying to build PHP as 32-bit, but your MySQL library is 64-bit.

You'll either need to build PHP in 64-bit (which means everything else that you link to needs to be 64-bit), or install the 32-bit
version of MySQL and point to it using LDFLAGS.

The 'file' command is your friend. Use it to determine what ELFCLASS your libraries are.

hth,
John

Compiling PHP with mysql

Compiling PHP with mysql

Comment

Comment

Comment

Comment

Comment