使用mysqli solaris构建php - ld：fatal：符号引用错误

Question

I'm trying to build PHP with mysqli on Solaris 10. I hit a stupid problem, it used to work before but now I'm getting the error below.

configure options:

./configure --with-mysql=/usr/local/mysql \
--with-mysqli=/usr/local/mysql/bin/mysql_config \
--with-apxs2=/usr/apache2/bin/apxs --with-gd --with-jpeg-dir=/usr/local \
--with-xpm-dir=/usr/local --with-png-dir=/usr/local --with-openssl \
--enable-zip --with-ldap

configure works fine, like it used to do. Path to mysql_config is valid, otherwise it would fail.

Make fails with the following error:

Undefined                       first referenced
 symbol                             in file
mysql_stmt_param_count              ext/mysqli/.libs/mysqli_api.o
mysql_set_character_set             ext/mysql/.libs/php_mysql.o
mysql_stmt_send_long_data           ext/mysqli/.libs/mysqli_api.o
mysql_stmt_data_seek                ext/mysqli/.libs/mysqli_api.o
mysql_stmt_insert_id                ext/mysqli/.libs/mysqli_api.o
mysql_stmt_store_result             ext/mysqli/.libs/mysqli_api.o
mysql_stmt_reset                    ext/mysqli/.libs/mysqli_api.o
mysql_stmt_close                    ext/mysqli/.libs/mysqli.o
mysql_stmt_fetch                    ext/mysqli/.libs/mysqli_api.o
mysql_stmt_error                    ext/mysqli/.libs/mysqli_api.o
mysql_stmt_errno                    ext/mysqli/.libs/mysqli_api.o
mysql_commit                        ext/mysqli/.libs/mysqli_api.o
mysql_get_server_version            ext/mysqli/.libs/mysqli_api.o
mysql_stmt_attr_set                 ext/mysqli/.libs/mysqli_api.o
mysql_stmt_attr_get                 ext/mysqli/.libs/mysqli_api.o
mysql_next_result                   ext/mysqli/.libs/mysqli_api.o
mysql_stmt_free_result              ext/mysqli/.libs/mysqli_api.o
mysql_stmt_bind_result              ext/mysqli/.libs/mysqli_api.o
mysql_stmt_num_rows                 ext/mysqli/.libs/mysqli_api.o
mysql_warning_count                 ext/mysqli/.libs/mysqli_api.o
mysql_stmt_prepare                  ext/mysqli/.libs/mysqli.o
mysql_rollback                      ext/mysqli/.libs/mysqli_api.o
mysql_stmt_bind_param               ext/mysqli/.libs/mysqli_api.o
mysql_sqlstate                      ext/mysqli/.libs/mysqli_api.o
mysql_stmt_sqlstate                 ext/mysqli/.libs/mysqli_api.o
mysql_get_character_set_info        ext/mysqli/.libs/mysqli_nonapi.o
mysql_more_results                  ext/mysqli/.libs/mysqli_api.o
mysql_stmt_field_count              ext/mysqli/.libs/mysqli_api.o
mysql_stmt_execute                  ext/mysqli/.libs/mysqli_api.o
mysql_stmt_affected_rows            ext/mysqli/.libs/mysqli_api.o
mysql_stmt_result_metadata          ext/mysqli/.libs/mysqli_api.o
mysql_autocommit                    ext/mysqli/.libs/mysqli_api.o
mysql_stmt_init                     ext/mysqli/.libs/mysqli.o
mysql_set_local_infile_handler      ext/mysqli/.libs/mysqli.o
mysql_set_server_option             ext/mysql/.libs/php_mysql.o
ld: fatal: Symbol referencing errors. No output written to sapi/cli/php
collect2: ld returned 1 exit status
*** Error code 1
make: Fatal error: Command failed for target `sapi/cli/php'
# 

Any clues?

Thank You!

Answer 1

bad library order...

fast&dirty hack: just change "-L/usr/sfw/lib -L/opt/mysql/lib" to "-L/opt/mysql/lib -L/usr/sfw/lib" in Makefile

/opt/mysql/lib - path to your mysql libraries.

sh> diff -b Makefile Makefile.orig
91,92c91,92
< EXTRA_LDFLAGS = -avoid-version -module -L/usr/ucblib -L/usr/sfw/lib/gcc/i386-pc-solaris2.10/3.4.3 -L/opt/mysql/lib -L/usr/sfw/lib
< EXTRA_LDFLAGS_PROGRAM = -L/usr/ucblib -L/usr/sfw/lib/gcc/i386-pc-solaris2.10/3.4.3 -L/opt/mysql/lib -L/usr/sfw/lib
---
> EXTRA_LDFLAGS = -avoid-version -module -L/usr/ucblib -L/usr/sfw/lib/gcc/i386-pc-solaris2.10/3.4.3 -L/usr/sfw/lib -L/opt/mysql/lib
> EXTRA_LDFLAGS_PROGRAM = -L/usr/ucblib -L/usr/sfw/lib/gcc/i386-pc-solaris2.10/3.4.3 -L/usr/sfw/lib -L/opt/mysql/lib
105c105
< PHP_LDFLAGS = -L/usr/ucblib -L/usr/sfw/lib/gcc/i386-pc-solaris2.10/3.4.3 -L/opt/mysql/lib -L/usr/sfw/lib
---
> PHP_LDFLAGS = -L/usr/ucblib -L/usr/sfw/lib/gcc/i386-pc-solaris2.10/3.4.3 -L/usr/sfw/lib -L/opt/mysql/lib