Bug #29520 [Csd]: php mysql compile fail

Edit report at http://bugs.php.net/bug.php?id=29520&edit=1 ID: 29520 Updated by: srinatar@php.net Reported by: martinkuria at hotmail dot com Summary: php mysql compile fail Status: Closed Type: Bug Package: Compile Failure Operating System: Solaris9 PHP Version: 5.0.0 -Assigned To: +Assigned To: srinatar Block user comment: N New Comment: well, most likely what's happening is you have installed the 64-bit version of mysql package. i would suggest removing this package (using pkgrm) and then installing the 32-bit version of mysql package. this is a configuration issue and not a php bug this should give you the clue - which is telling you that the configurator is unable to compile 32-bit php with 64-bit mysql client: ld: warning: file /usr/local/mysql//lib/libmysqlclient.a(libmysql.o): wrong ELF class: ELFCLASS64 Undefined first referenced symbol in file mysql_close /var/tmp//ccYGWfaf.o Previous Comments: ------------------------------------------------------------------------ [2010-07-27 02:52:00] nazd at webmail dot co dot za Description: ------------ Hi there Guys, Im relatively new to Linux. Im having the same problem, difference is that I am using RedHat as my platform. I was able to install Apache 2.2.11 using RPM. This a virtual server I have created using VMware I created the MySQL server using an app called Webmin. When I attempt to install PHP5.2.13 using the command ./configure --prefix=/usr/lib/php --with-apxs2=/usr/local/apache2/bin/apxs --with-mysql=/var/lib/mysql I get the errors below: Configuring extensions checking size of long... (cached) 4 checking size of int... (cached) 4 checking for int32_t... yes checking for uint32_t... yes checking for sys/types.h... (cached) yes checking for inttypes.h... (cached) yes checking for stdint.h... (cached) yes checking for string.h... (cached) yes checking for stdlib.h... (cached) yes checking for strtoll... yes checking for atoll... yes checking for strftime... (cached) yes checking whether to enable LIBXML support... yes checking libxml2 install dir... no checking for xml2-config path... /usr/bin/xml2-config checking whether libxml build works... yes checking for OpenSSL support... no checking for Kerberos support... no checking for PCRE support... yes checking for ZLIB support... no checking if the location of ZLIB install directory is defined... no checking whether to enable bc style precision math functions... no checking for BZip2 support... no checking whether to enable calendar conversion support... no checking whether to enable ctype functions... yes checking for cURL support... no checking if we should use cURL for url streams... no checking for QDBM support... no checking for GDBM support... no checking for NDBM support... no checking for Berkeley DB4 support... no checking for Berkeley DB3 support... no checking for Berkeley DB2 support... no checking for DB1 support... no checking for DBM support... no checking for CDB support... no checking for INI File support... no checking for FlatFile support... no checking whether to enable DBA interface... no checking whether to enable dbase support... no checking whether to enable DOM support... yes checking for xml2-config path... (cached) /usr/bin/xml2-config checking whether libxml build works... (cached) yes checking whether to enable EXIF (metadata from images) support... no checking for FrontBase SQL92 (fbsql) support... no checking for FDF support... no checking whether to enable input filter support... yes checking pcre install prefix... no checking whether to enable FTP support... no checking OpenSSL dir for FTP... no checking for GD support... no checking for the location of libjpeg... no checking for the location of libpng... no checking for the location of libXpm... no checking for FreeType 1.x support... no checking for FreeType 2... no checking for T1lib support... no checking whether to enable truetype string function in GD... no checking whether to enable JIS-mapped Japanese font support in GD... no checking for GNU gettext support... no checking for GNU MP support... no checking whether to enable hash support... yes checking whether byte ordering is bigendian... (cached) no checking size of short... 2 checking size of int... (cached) 4 checking size of long... (cached) 4 checking size of long long... (cached) 8 checking for iconv support... yes checking for iconv... yes checking if iconv is glibc's... yes checking if iconv supports errno... yes checking if your cpp allows macro usage in include lines... yes checking for IMAP support... no checking for IMAP Kerberos support... no checking for IMAP SSL support... no checking for InterBase support... no checking whether to enable JavaScript Object Serialization support... yes checking for ANSI C header files... (cached) yes checking for LDAP support... no checking for LDAP Cyrus SASL support... no checking whether to enable multibyte string support... no checking whether to enable multibyte regex support... yes checking whether to check multibyte regex backtrack... yes checking for external libmbfl... no checking for mcrypt support... no checking for mhash support... no checking whether to include mime_magic support... no checking for MING support... no checking for mSQL support... no checking for MSSQL support via FreeTDS... no checking for MySQL support... yes checking for specified location of the MySQL UNIX socket... no checking for MySQL UNIX socket location... no configure: error: Cannot find MySQL header files under /var/lib/mysql. Note that the MySQL client library is not bundled anymore! [root@gets-dev-form2 php-5.2.13]# I ran the command find / -name mysql.h but found on header files. Running the command: [root@gets-dev-form2 php-5.2.13]# service mysqld start Starting MySQL: [ OK ] [root@gets-dev-form2 php-5.2.13]# MySql seems to start. Can anyone please help? Thanking you in advance. ------------------------------------------------------------------------ [2009-08-28 20:59:49] danbrown@php.net Looks like it's safe to close this out officially now. ------------------------------------------------------------------------ [2009-02-15 07:26:34] gambitrex at hotmail dot com hey, the apt-get install libmysqlclient-dev worked for me too :D ------------------------------------------------------------------------ [2007-11-28 20:16:50] cizarr at gmail dot com yep, this one will solve the problem as anderan wrote: apt-get install libmysqlclient-dev thanks man! ------------------------------------------------------------------------ [2007-11-09 14:41:22] dan at k dot ro well on fedora core 6 is not working what a stupid bug this is! ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/bug.php?id=29520 -- Edit this bug report at http://bugs.php.net/bug.php?id=29520&edit=1