From:             sfletcher at abcoa dot com
Operating system: AIX 5.2
PHP version:      5.1.1
PHP Bug Type:     *Configuration Issues
Bug description:  Configure failed on MySQLi with library or lib version not 
found

Description:
------------
MySQL Version: 5.0.16 (AIX 64 binary from mysql.com site)

I followed this documentation at http://us3.php.net/mysql that mentioned
"You can download headers and libraries from MySQL." which take me to
mysql.com site.  I then went on to download section and came upon the
"Contributed API" section with a link which then lead me to
http://us3.php.net/manual/en/ref.mysqli.php .  So, I followed this part..

--snip--
 To install the mysqli extension for PHP, use the
--with-mysqli=mysql_config_path/mysql_config  configuration option where
mysql_config_path represents the location of the mysql_config program that
comes with MySQL versions greater than 4.1.
--snip--

which lead me to this configure command..

--snip--
./configure --with-mysqli=/usr/local/mysql/bin/mysql_config
--with-apxs2=../../apache2/bin/apxs --with-unixODBC --with-openssl
--with-curl --disable-libxml --disable-dom --enable-track-vars
--enable-ftp --enable-sockets
--snip--

See actual result below.  I could find no existing bug so I filed a new
bug, upon the submission of this bug that cause me find bug #30835 which
cause to modify this bug report a little more.

I used the "mysql_config --libs" command from bug #30835 and got this
result..

--snip--
-L/usr/local/mysql/lib -lmysqlclient -lz -lcrypt -lnsl_r -lm
--snip--

All of the MySQL stuffs are inside the
"/usr/local/mysql-standard-5.0.16-aix5.2-powerpc-64bit" directory where I
used the symbolic link to make it become a "/usr/local/mysql" directory.

I know the symbolic link is not hte problem because PHP can find it
without a problem.

Expected result:
----------------
PHP should be able to configured successfully without an error.

Actual result:
--------------
Then the configure terminated with errors...

--snip--
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 msession support... no
checking for mSQL support... no
checking for MSSQL support via FreeTDS... no
checking for MySQL support... no
checking for specified location of the MySQL UNIX socket... no
checking for MySQLi support... yes
checking whether to enable embedded MySQLi support... no
checking for mysql_set_server_option in -lmysqlclient... no
configure: error: wrong mysql library version or lib not found. Check
config.log for more information.
--snip--

The config.log is posted here

--snip--
configure:53543: checking for mcrypt support
configure:54372: checking for mhash support
configure:54844: checking whether to include mime_magic support
configure:55199: checking for MING support
configure:56122: checking for msession support
configure:56830: checking for mSQL support
configure:57339: checking for MSSQL support via FreeTDS
configure:57987: checking for MySQL support
configure:58033: checking for specified location of the MySQL UNIX socket
configure:59186: checking for MySQLi support
configure:59232: checking whether to enable embedded MySQLi support
configure:59378: checking for mysql_set_server_option in -lmysqlclient
configure:59397: gcc -o conftest -g -O2  -L/usr/local/mysql/lib
-L/usr/local/mysql/lib  -L/usr/local/ssl/lib -L/usr/local/ssl/lib
-L/usr/local/lib -L/usr/local/lib -lmysqlclient -lz -lcrypt -lnsl_r -lm
conftest.c -lmysqlclient  -liconv -lssl -lcrypto -lcurl -lssl -lcrypto -lm
 -lcurl -lssl -lcrypto 1>&5
ld: 0711-317 ERROR: Undefined symbol: .mysql_set_server_option
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more
information.
collect2: ld returned 8 exit status
configure: failed program was:
#line 59386 "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_set_server_option();

int main() {
mysql_set_server_option()
; return 0; }
--snip--

I hope to have this up and running shortly because of work-related web
site.  If that is possible.





-- 
Edit bug report at http://bugs.php.net/?id=35688&edit=1
-- 
Try a CVS snapshot (PHP 4.4): 
http://bugs.php.net/fix.php?id=35688&r=trysnapshot44
Try a CVS snapshot (PHP 5.1): 
http://bugs.php.net/fix.php?id=35688&r=trysnapshot51
Try a CVS snapshot (PHP 6.0): 
http://bugs.php.net/fix.php?id=35688&r=trysnapshot60
Fixed in CVS:                 http://bugs.php.net/fix.php?id=35688&r=fixedcvs
Fixed in release:             
http://bugs.php.net/fix.php?id=35688&r=alreadyfixed
Need backtrace:               http://bugs.php.net/fix.php?id=35688&r=needtrace
Need Reproduce Script:        http://bugs.php.net/fix.php?id=35688&r=needscript
Try newer version:            http://bugs.php.net/fix.php?id=35688&r=oldversion
Not developer issue:          http://bugs.php.net/fix.php?id=35688&r=support
Expected behavior:            http://bugs.php.net/fix.php?id=35688&r=notwrong
Not enough info:              
http://bugs.php.net/fix.php?id=35688&r=notenoughinfo
Submitted twice:              
http://bugs.php.net/fix.php?id=35688&r=submittedtwice
register_globals:             http://bugs.php.net/fix.php?id=35688&r=globals
PHP 3 support discontinued:   http://bugs.php.net/fix.php?id=35688&r=php3
Daylight Savings:             http://bugs.php.net/fix.php?id=35688&r=dst
IIS Stability:                http://bugs.php.net/fix.php?id=35688&r=isapi
Install GNU Sed:              http://bugs.php.net/fix.php?id=35688&r=gnused
Floating point limitations:   http://bugs.php.net/fix.php?id=35688&r=float
No Zend Extensions:           http://bugs.php.net/fix.php?id=35688&r=nozend
MySQL Configuration Error:    http://bugs.php.net/fix.php?id=35688&r=mysqlcfg

Reply via email to