[PHP] Re: Compiling php-4.0.6 with MySQL support
i tend not to use the internel mysql lib, install mysql into a prefix dir ie /usr/local/etc/mysql then do --with-mysql=/usr/local/etc/mysql u only had --with-mysql= which will use the internal lib. Igor Shulgin [EMAIL PROTECTED] wrote in message 227601c2a67a$0e5fb750$e964a8c0@ptt">news:227601c2a67a$0e5fb750$e964a8c0@ptt... Hi! I cannot compile php-4.0.6 with MySQL support as static module for apache_1.3.20 on FreeBSD 4.4. Early I successfully build and install /usr/ports/databases/mysql323-server and /usr/ports/databases/mysql323-client with standard configuration. I have done following without problems: cd /usr/ports/www/apache13/work/apache_1.3.20 ./configure cd /usr/ports/www/mod_php4/work/php-4.0.6 rm config.cache ./configure --with-mysql= --with-apache=/usr/ports/www/apache13/work/apache_ 1.3.20 --enable-track-vars make make install cd /usr/ports/www/apache13/work/apache_1.3.20 ./configure --prefix=/usr/local/www --activate-module=src/modules/php4/libph p4.a But make stops with following: gcc -funsigned-char -I/usr/ports/www/mod_php4/work/php-4.0.6 -I/usr/ports/w ww/mod_php4/work/php-4.0.6/main -I/usr/ports/www/mod_php4/work/php-4.0.6/mai n -I/usr/ports/www/mod_php4/work/php-4.0.6/Zend -I/usr/ports/www/mod_php4/wo rk/php-4.0.6/Zend -I/usr/ports/www/mod_php4/work/php-4.0.6/TSRM -I/usr/ports /www/mod_php4/work/php-4.0.6/TSRM -I/usr/ports/www/mod_php4/work/php-4.0.6 - DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED `./apaci` -o httpd buildmark.o modules.o modules/standard/libstandard.a modules/php4/libphp4.a main/libmain.a ./os/unix/libos.a ap/libap.a lib/expat-lite/libexpat.a -rdynamic -Lmodules/php4 -L../modules/php4 -L../. ./modules/php4 -lmodphp4 -lpam -lcrypt -lm-lcrypt modules/php4/libphp4.a(php_mysql.lo): In function `_free_mysql_result': php_mysql.lo(.text+0x1c): undefined reference to `mysql_free_result' modules/php4/libphp4.a(php_mysql.lo): In function `_close_mysql_link': php_mysql.lo(.text+0x9d): undefined reference to `mysql_close' modules/php4/libphp4.a(php_mysql.lo): In function `_close_mysql_plink': php_mysql.lo(.text+0xf9): undefined reference to `mysql_close' modules/php4/libphp4.a(php_mysql.lo): In function `php_info_mysql': php_mysql.lo(.text+0x42f): undefined reference to `mysql_get_client_info' modules/php4/libphp4.a(php_mysql.lo): In function `php_mysql_do_connect': php_mysql.lo(.text+0xd0e): undefined reference to `mysql_init' php_mysql.lo(.text+0xd2f): undefined reference to `mysql_real_connect' php_mysql.lo(.text+0xd5c): undefined reference to `mysql_error' php_mysql.lo(.text+0xd89): undefined reference to `mysql_errno' php_mysql.lo(.text+0xe4f): undefined reference to `mysql_stat' php_mysql.lo(.text+0xe8c): undefined reference to `mysql_real_connect' php_mysql.lo(.text+0x105a): undefined reference to `mysql_init' php_mysql.lo(.text+0x107b): undefined reference to `mysql_real_connect' php_mysql.lo(.text+0x10ac): undefined reference to `mysql_error' php_mysql.lo(.text+0x10d9): undefined reference to `mysql_errno' php_mysql.lo(.text+0x10eb): undefined reference to `mysql_error' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_select_db': php_mysql.lo(.text+0x1550): undefined reference to `mysql_select_db' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_get_client_info': php_mysql.lo(.text+0x159d): undefined reference to `mysql_get_client_info' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_get_host_info': php_mysql.lo(.text+0x168d): undefined reference to `mysql_get_host_info' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_get_proto_info': php_mysql.lo(.text+0x1781): undefined reference to `mysql_get_proto_info' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_get_server_info': php_mysql.lo(.text+0x184d): undefined reference to `mysql_get_server_info' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_create_db': php_mysql.lo(.text+0x1a14): undefined reference to `mysql_create_db' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_drop_db': php_mysql.lo(.text+0x1bcc): undefined reference to `mysql_drop_db' modules/php4/libphp4.a(php_mysql.lo): In function `php_mysql_do_query_general': php_mysql.lo(.text+0x1ce5): undefined reference to `mysql_select_db' php_mysql.lo(.text+0x1d42): undefined reference to `mysql_eof' php_mysql.lo(.text+0x1d6d): undefined reference to `mysql_fetch_row' php_mysql.lo(.text+0x1e47): undefined reference to `mysql_real_query' php_mysql.lo(.text+0x1e72): undefined reference to `mysql_use_result' php_mysql.lo(.text+0x1e80): undefined reference to `mysql_store_result' php_mysql.lo(.text+0x1e93): undefined reference to `mysql_field_count' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_list_dbs': php_mysql.lo(.text+0x21a3): undefined reference to `mysql_list_dbs' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_list_tables': php_mysql.lo(.text+0x2370): undefined reference to `mysql_select_db'
Re: [PHP] Re: Compiling php-4.0.6 with MySQL support
Should I use --with-mysl=/usr/ports/databases/mysql323-server/work/mysql-3.23.42 (where sources are placed) or --with-mysql=/usr/local (I see in Makefile in above directory that 'prefix = /usr/local') ? --- With best wishes, Igor Shulgin --- -- JSC Uralsvyazinform | Applied Systems Department - Original Message - From: electroteque [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 2:47 PM Subject: [PHP] Re: Compiling php-4.0.6 with MySQL support i tend not to use the internel mysql lib, install mysql into a prefix dir ie /usr/local/etc/mysql then do --with-mysql=/usr/local/etc/mysql u only had --with-mysql= which will use the internal lib. Igor Shulgin [EMAIL PROTECTED] wrote in message 227601c2a67a$0e5fb750$e964a8c0@ptt">news:227601c2a67a$0e5fb750$e964a8c0@ptt... Hi! I cannot compile php-4.0.6 with MySQL support as static module for apache_1.3.20 on FreeBSD 4.4. Early I successfully build and install /usr/ports/databases/mysql323-server and /usr/ports/databases/mysql323-client with standard configuration. I have done following without problems: cd /usr/ports/www/apache13/work/apache_1.3.20 ./configure cd /usr/ports/www/mod_php4/work/php-4.0.6 rm config.cache ./configure --with-mysql= --with-apache=/usr/ports/www/apache13/work/apache_ 1.3.20 --enable-track-vars make make install cd /usr/ports/www/apache13/work/apache_1.3.20 ./configure --prefix=/usr/local/www --activate-module=src/modules/php4/libph p4.a But make stops with following: gcc -funsigned-char -I/usr/ports/www/mod_php4/work/php-4.0.6 -I/usr/ports/w ww/mod_php4/work/php-4.0.6/main -I/usr/ports/www/mod_php4/work/php-4.0.6/mai n -I/usr/ports/www/mod_php4/work/php-4.0.6/Zend -I/usr/ports/www/mod_php4/wo rk/php-4.0.6/Zend -I/usr/ports/www/mod_php4/work/php-4.0.6/TSRM -I/usr/ports /www/mod_php4/work/php-4.0.6/TSRM -I/usr/ports/www/mod_php4/work/php-4.0.6 - DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED `./apaci` -o httpd buildmark.o modules.o modules/standard/libstandard.a modules/php4/libphp4.a main/libmain.a ./os/unix/libos.a ap/libap.a lib/expat-lite/libexpat.a -rdynamic -Lmodules/php4 -L../modules/php4 -L../. ./modules/php4 -lmodphp4 -lpam -lcrypt -lm-lcrypt modules/php4/libphp4.a(php_mysql.lo): In function `_free_mysql_result': php_mysql.lo(.text+0x1c): undefined reference to `mysql_free_result' modules/php4/libphp4.a(php_mysql.lo): In function `_close_mysql_link': php_mysql.lo(.text+0x9d): undefined reference to `mysql_close' modules/php4/libphp4.a(php_mysql.lo): In function `_close_mysql_plink': php_mysql.lo(.text+0xf9): undefined reference to `mysql_close' modules/php4/libphp4.a(php_mysql.lo): In function `php_info_mysql': php_mysql.lo(.text+0x42f): undefined reference to `mysql_get_client_info' modules/php4/libphp4.a(php_mysql.lo): In function `php_mysql_do_connect': php_mysql.lo(.text+0xd0e): undefined reference to `mysql_init' php_mysql.lo(.text+0xd2f): undefined reference to `mysql_real_connect' php_mysql.lo(.text+0xd5c): undefined reference to `mysql_error' php_mysql.lo(.text+0xd89): undefined reference to `mysql_errno' php_mysql.lo(.text+0xe4f): undefined reference to `mysql_stat' php_mysql.lo(.text+0xe8c): undefined reference to `mysql_real_connect' php_mysql.lo(.text+0x105a): undefined reference to `mysql_init' php_mysql.lo(.text+0x107b): undefined reference to `mysql_real_connect' php_mysql.lo(.text+0x10ac): undefined reference to `mysql_error' php_mysql.lo(.text+0x10d9): undefined reference to `mysql_errno' php_mysql.lo(.text+0x10eb): undefined reference to `mysql_error' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_select_db': php_mysql.lo(.text+0x1550): undefined reference to `mysql_select_db' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_get_client_info': php_mysql.lo(.text+0x159d): undefined reference to `mysql_get_client_info' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_get_host_info': php_mysql.lo(.text+0x168d): undefined reference to `mysql_get_host_info' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_get_proto_info': php_mysql.lo(.text+0x1781): undefined reference to `mysql_get_proto_info' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_get_server_info': php_mysql.lo(.text+0x184d): undefined reference to `mysql_get_server_info' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_create_db': php_mysql.lo(.text+0x1a14): undefined reference to `mysql_create_db' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_drop_db': php_mysql.lo(.text+0x1bcc): undefined reference to `mysql_drop_db' modules/php4/libphp4.a(php_mysql.lo): In function `php_mysql_do_query_general': php_mysql.lo(.tex
RE: [PHP] Re: Compiling php-4.0.6 with MySQL support
not the sources where you put your libmysql, i prefix my apps , as its easier to contain and find stuff -Original Message- From: Igor Shulgin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 10:00 PM To: electroteque; [EMAIL PROTECTED] Subject: Re: [PHP] Re: Compiling php-4.0.6 with MySQL support Should I use --with-mysl=/usr/ports/databases/mysql323-server/work/mysql-3.23.42 (where sources are placed) or --with-mysql=/usr/local (I see in Makefile in above directory that 'prefix = /usr/local') ? --- With best wishes, Igor Shulgin --- -- JSC Uralsvyazinform | Applied Systems Department - Original Message - From: electroteque [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 2:47 PM Subject: [PHP] Re: Compiling php-4.0.6 with MySQL support i tend not to use the internel mysql lib, install mysql into a prefix dir ie /usr/local/etc/mysql then do --with-mysql=/usr/local/etc/mysql u only had --with-mysql= which will use the internal lib. Igor Shulgin [EMAIL PROTECTED] wrote in message 227601c2a67a$0e5fb750$e964a8c0@ptt">news:227601c2a67a$0e5fb750$e964a8c0@ptt... Hi! I cannot compile php-4.0.6 with MySQL support as static module for apache_1.3.20 on FreeBSD 4.4. Early I successfully build and install /usr/ports/databases/mysql323-server and /usr/ports/databases/mysql323-client with standard configuration. I have done following without problems: cd /usr/ports/www/apache13/work/apache_1.3.20 ./configure cd /usr/ports/www/mod_php4/work/php-4.0.6 rm config.cache ./configure --with-mysql= --with-apache=/usr/ports/www/apache13/work/apache_ 1.3.20 --enable-track-vars make make install cd /usr/ports/www/apache13/work/apache_1.3.20 ./configure --prefix=/usr/local/www --activate-module=src/modules/php4/libph p4.a But make stops with following: gcc -funsigned-char -I/usr/ports/www/mod_php4/work/php-4.0.6 -I/usr/ports/w ww/mod_php4/work/php-4.0.6/main -I/usr/ports/www/mod_php4/work/php-4.0.6/mai n -I/usr/ports/www/mod_php4/work/php-4.0.6/Zend -I/usr/ports/www/mod_php4/wo rk/php-4.0.6/Zend -I/usr/ports/www/mod_php4/work/php-4.0.6/TSRM -I/usr/ports /www/mod_php4/work/php-4.0.6/TSRM -I/usr/ports/www/mod_php4/work/php-4.0.6 - DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED `./apaci` -o httpd buildmark.o modules.o modules/standard/libstandard.a modules/php4/libphp4.a main/libmain.a ./os/unix/libos.a ap/libap.a lib/expat-lite/libexpat.a -rdynamic -Lmodules/php4 -L../modules/php4 -L../. ./modules/php4 -lmodphp4 -lpam -lcrypt -lm-lcrypt modules/php4/libphp4.a(php_mysql.lo): In function `_free_mysql_result': php_mysql.lo(.text+0x1c): undefined reference to `mysql_free_result' modules/php4/libphp4.a(php_mysql.lo): In function `_close_mysql_link': php_mysql.lo(.text+0x9d): undefined reference to `mysql_close' modules/php4/libphp4.a(php_mysql.lo): In function `_close_mysql_plink': php_mysql.lo(.text+0xf9): undefined reference to `mysql_close' modules/php4/libphp4.a(php_mysql.lo): In function `php_info_mysql': php_mysql.lo(.text+0x42f): undefined reference to `mysql_get_client_info' modules/php4/libphp4.a(php_mysql.lo): In function `php_mysql_do_connect': php_mysql.lo(.text+0xd0e): undefined reference to `mysql_init' php_mysql.lo(.text+0xd2f): undefined reference to `mysql_real_connect' php_mysql.lo(.text+0xd5c): undefined reference to `mysql_error' php_mysql.lo(.text+0xd89): undefined reference to `mysql_errno' php_mysql.lo(.text+0xe4f): undefined reference to `mysql_stat' php_mysql.lo(.text+0xe8c): undefined reference to `mysql_real_connect' php_mysql.lo(.text+0x105a): undefined reference to `mysql_init' php_mysql.lo(.text+0x107b): undefined reference to `mysql_real_connect' php_mysql.lo(.text+0x10ac): undefined reference to `mysql_error' php_mysql.lo(.text+0x10d9): undefined reference to `mysql_errno' php_mysql.lo(.text+0x10eb): undefined reference to `mysql_error' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_select_db': php_mysql.lo(.text+0x1550): undefined reference to `mysql_select_db' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_get_client_info': php_mysql.lo(.text+0x159d): undefined reference to `mysql_get_client_info' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_get_host_info': php_mysql.lo(.text+0x168d): undefined reference to `mysql_get_host_info' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_get_proto_info': php_mysql.lo(.text+0x1781): undefined reference to `mysql_get_proto_info' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_get_server_info': php_mysql.lo(.text+0x184d): undefined reference to `mysql_get_server_info' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_create_db': php_