#35107 [Opn->Asn]: compile failure with PHP 5.1 + MySQL 5

ID: 35107 Updated by: sniper@php.net Reported By: alex at whitewhale dot net -Status: Open +Status: Assigned -Bug Type: Compile Failure +Bug Type: PDO related Operating System: MacOS X 10.4.3 PHP Version: 5CVS-2005-11-05 (snap) -Assigned To: +Assigned To: wez New Comment: Assigned to the PDO maintainer. Previous Comments: ------------------------------------------------------------------------ [2005-11-05 15:42:33] alex at whitewhale dot net Okay, using that configure line I now get: In file included from /Users/sahara/Documents/LAMP/php/ php5-200511041330/ext/pdo_mysql/pdo_mysql.c:31: /Users/sahara/Documents/LAMP/php/php5-200511041330/ext/ pdo_mysql/php_pdo_mysql_int.h:25:19: error: mysql.h: No such file or directory In file included from /Users/sahara/Documents/LAMP/php/ php5-200511041330/ext/pdo_mysql/pdo_mysql.c:31: /Users/sahara/Documents/LAMP/php/php5-200511041330/ext/ pdo_mysql/php_pdo_mysql_int.h:36: error: parse error before 'MYSQL' /Users/sahara/Documents/LAMP/php/php5-200511041330/ext/ pdo_mysql/php_pdo_mysql_int.h:36: warning: no semicolon at end of struct or union /Users/sahara/Documents/LAMP/php/php5-200511041330/ext/ pdo_mysql/php_pdo_mysql_int.h:38: error: parse error before ':' token /Users/sahara/Documents/LAMP/php/php5-200511041330/ext/ pdo_mysql/php_pdo_mysql_int.h:39: error: parse error before ':' token /Users/sahara/Documents/LAMP/php/php5-200511041330/ext/ pdo_mysql/php_pdo_mysql_int.h:40: error: parse error before ':' token /Users/sahara/Documents/LAMP/php/php5-200511041330/ext/ pdo_mysql/php_pdo_mysql_int.h:43: error: parse error before '}' token /Users/sahara/Documents/LAMP/php/php5-200511041330/ext/ pdo_mysql/php_pdo_mysql_int.h:43: warning: data definition has no type or storage class /Users/sahara/Documents/LAMP/php/php5-200511041330/ext/ pdo_mysql/php_pdo_mysql_int.h:46: error: parse error before 'MYSQL_FIELD' /Users/sahara/Documents/LAMP/php/php5-200511041330/ext/ pdo_mysql/php_pdo_mysql_int.h:46: warning: no semicolon at end of struct or union /Users/sahara/Documents/LAMP/php/php5-200511041330/ext/ pdo_mysql/php_pdo_mysql_int.h:47: warning: data definition has no type or storage class /Users/sahara/Documents/LAMP/php/php5-200511041330/ext/ pdo_mysql/php_pdo_mysql_int.h:50: error: parse error before 'pdo_mysql_db_handle' /Users/sahara/Documents/LAMP/php/php5-200511041330/ext/ pdo_mysql/php_pdo_mysql_int.h:50: warning: no semicolon at end of struct or union /Users/sahara/Documents/LAMP/php/php5-200511041330/ext/ pdo_mysql/php_pdo_mysql_int.h:51: warning: data definition has no type or storage class /Users/sahara/Documents/LAMP/php/php5-200511041330/ext/ pdo_mysql/php_pdo_mysql_int.h:52: error: parse error before '*' token /Users/sahara/Documents/LAMP/php/php5-200511041330/ext/ pdo_mysql/php_pdo_mysql_int.h:52: warning: data definition has no type or storage class /Users/sahara/Documents/LAMP/php/php5-200511041330/ext/ pdo_mysql/php_pdo_mysql_int.h:53: error: parse error before 'current_data' /Users/sahara/Documents/LAMP/php/php5-200511041330/ext/ pdo_mysql/php_pdo_mysql_int.h:53: warning: data definition has no type or storage class /Users/sahara/Documents/LAMP/php/php5-200511041330/ext/ pdo_mysql/php_pdo_mysql_int.h:69: error: parse error before '}' token /Users/sahara/Documents/LAMP/php/php5-200511041330/ext/ pdo_mysql/php_pdo_mysql_int.h:69: warning: data definition has no type or storage class make: *** [ext/pdo_mysql/pdo_mysql.lo] Error 1 ------------------------------------------------------------------------ [2005-11-05 12:39:07] sniper@php.net So now we've found out that the problem isn't in ext/mysqli. Try this configure line (with the usual "rm config.cache" and "make clean", which are only needed if you're not using fresh sources everytime) # ./configure --disable-all --enable-pdo --with-pdo-mysql ------------------------------------------------------------------------ [2005-11-05 02:17:26] alex at whitewhale dot net Actually, I ran "make clean" several times in trying to diagnose this. Also, as I said, I tried compiling a fresh snapshot this morning to no avail. I was finally able to compile it with your suggested, stripped-down config line after both "rm config.cache" and "make clean" but the moment I tried it with my normal config line, it failed again with the original error. Just to be clear, the following sequence does *not* work for me (on my Mac, it works on my Linux box): rm config.cache make clean ./configure --with-apxs=/usr/sbin/apxs --prefix=/usr -- enable-inline-optimization --with-libxml-dir=/sw --with- mysqli=/usr/local/mysql/bin/mysql_config --with-gd --with- jpeg-dir=/sw --with-png-dir=/sw --with-zlib-dir=/usr --with- pdo-mysql --with-xmlrpc --with-mm=/usr/local --disable-debug --with-ldap --enable-soap make ------------------------------------------------------------------------ [2005-11-04 18:20:06] sniper@php.net Does this configure line work any better: # rm config.cache # ./configure --disable-all --with-apxs=/usr/sbin/apxs \ --with-mysqli=/usr/local/mysql/bin/mysql_config ------------------------------------------------------------------------ [2005-11-04 17:40:02] alex at whitewhale dot net Description: ------------ Not very knowledgeable about compiler issues, but: getting a compile failure on MacOS X related to MySQL. PHP 5.1 RC3 compiled with MySQL 5 successfully, but RC4 and a snapshot from this morning both fail using the following configure line: ./configure --with-apxs=/usr/sbin/apxs --prefix=/usr --enable- inline-optimization --with-libxml-dir=/sw --with-mysqli=/usr/ local/mysql/bin/mysql_config --with-gd --with-jpeg-dir=/sw -- with-png-dir=/sw --with-zlib-dir=/usr --with-pdo-mysql --with- xmlrpc --with-mm=/usr/local --disable-debug --with-ldap -- enable-soap Reproduce code: --------------- make Expected result: ---------------- a successful compile Actual result: -------------- /usr/bin/ld: warning multiple definitions of symbol _regcomp /usr/sbin/httpd definition of _regcomp /usr/lib/gcc/powerpc-apple-darwin8/4.0.0/../../../libm.dylib (regcomp.So) definition of _regcomp /usr/bin/ld: warning multiple definitions of symbol _regexec /usr/sbin/httpd definition of _regexec /usr/lib/gcc/powerpc-apple-darwin8/4.0.0/../../../libm.dylib (regexec.So) definition of _regexec /usr/bin/ld: warning multiple definitions of symbol _regfree /usr/sbin/httpd definition of _regfree /usr/lib/gcc/powerpc-apple-darwin8/4.0.0/../../../libm.dylib (regfree.So) definition of _regfree /usr/bin/ld: Undefined symbols: _mysql_get_character_set_info _mysql_set_character_set collect2: ld returned 1 exit status make: *** [libs/libphp5.bundle] Error 1 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=35107&edit=1