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_inf
Re: [PHP] Compiling php-4.0.6 with MySQL support
Re: [PHP] Compiling php-4.0.6 with MySQL supportThank you for your answer, Wico!
I had deleted '=' after '--with-mysql' but it didn't help me.
All these messages about "undefined reference to `mysql..." was repeated.
---
With best wishes,
Igor Shulgin
--- --
JSC Uralsvyazinform | Applied Systems Department
- Original Message -
From: Wico de Leeuw
To: Igor Shulgin ; [EMAIL PROTECTED]
Sent: Wednesday, December 18, 2002 2:51 PM
Subject: Re: [PHP] Compiling php-4.0.6 with MySQL support
At 14:44 18-12-02 +0500, Igor Shulgin wrote:
> 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
shouldn;t it be
./configure --with-mysql
--with-apache=/usr/ports/www/apache13/work/apache_1.3.20 --enable-track-vars
(so without the =)
Gr,
Wico
>make
>make install
>cd /usr/ports/www/apache13/work/apache_1.3.20
>./configure --prefix=/usr/local/www
>--activate-module=src/modules/php4/libphp4.a
>
>But
>
>make
>
>stops with following:
>
>gcc -funsigned-char -I/usr/ports/www/mod_php4/work/php-4.0.6
>-I/usr/ports/www/mod_php4/work/php-4.0.6/main
>-I/usr/ports/www/mod_php4/work/php-4.0.6/main
>-I/usr/ports/www/mod_php4/work/php-4.0.6/Zend
>-I/usr/ports/www/mod_php4/work/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
>`p
[PHP] Compiling php-4.0.6 with MySQL support
es/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_list_fields': php_mysql.lo(.text+0x2558): undefined reference to `mysql_select_db' php_mysql.lo(.text+0x2622): undefined reference to `mysql_list_fields' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_error': php_mysql.lo(.text+0x270d): undefined reference to `mysql_error' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_errno': php_mysql.lo(.text+0x27f1): undefined reference to `mysql_errno' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_affected_rows': php_mysql.lo(.text+0x28b1): undefined reference to `mysql_affected_rows' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_escape_string': php_mysql.lo(.text+0x29d9): undefined reference to `mysql_escape_string' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_insert_id': php_mysql.lo(.text+0x2a9d): undefined reference to `mysql_insert_id' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_result': php_mysql.lo(.text+0x2c23): undefined reference to `mysql_num_rows' php_mysql.lo(.text+0x2c6e): undefined reference to `mysql_data_seek' php_mysql.lo(.text+0x2c7a): undefined reference to `mysql_fetch_row' php_mysql.lo(.text+0x2c94): undefined reference to `mysql_fetch_lengths' php_mysql.lo(.text+0x2d3d): undefined reference to `mysql_field_seek' php_mysql.lo(.text+0x2d53): undefined reference to `mysql_fetch_field' php_mysql.lo(.text+0x2ee3): undefined reference to `mysql_num_fields' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_num_rows': php_mysql.lo(.text+0x300d): undefined reference to `mysql_num_rows' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_num_fields': php_mysql.lo(.text+0x308d): undefined reference to `mysql_num_fields' modules/php4/libphp4.a(php_mysql.lo): In function `php_mysql_fetch_hash': php_mysql.lo(.text+0x3230): undefined reference to `mysql_fetch_row' php_mysql.lo(.text+0x3246): undefined reference to `mysql_fetch_lengths' php_mysql.lo(.text+0x325c): undefined reference to `mysql_num_fields' php_mysql.lo(.text+0x3292): undefined reference to `mysql_field_seek' php_mysql.lo(.text+0x329e): undefined reference to `mysql_fetch_field' php_mysql.lo(.text+0x33a2): undefined reference to `mysql_fetch_field' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_data_seek': php_mysql.lo(.text+0x35c8): undefined reference to `mysql_num_rows' php_mysql.lo(.text+0x360b): undefined reference to `mysql_data_seek' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_fetch_lengths': php_mysql.lo(.text+0x3695): undefined reference to `mysql_fetch_lengths' php_mysql.lo(.text+0x36cd): undefined reference to `mysql_num_fields' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_fetch_field': php_mysql.lo(.text+0x3935): undefined reference to `mysql_num_fields' php_mysql.lo(.text+0x3970): undefined reference to `mysql_field_seek' php_mysql.lo(.text+0x397c): undefined reference to `mysql_fetch_field' modules/php4/libphp4.a(php_mysql.lo): In function `php_if_mysql_field_seek': php_mysql.lo(.text+0x3c98): undefined reference to `mysql_num_fields' php_mysql.lo(.text+0x3cd8): undefined reference to `mysql_field_seek' modules/php4/libphp4.a(php_mysql.lo): In function `php_mysql_field_info': php_mysql.lo(.text+0x3e4d): undefined reference to `mysql_num_fields' php_mysql.lo(.text+0x3e9b): undefined reference to `mysql_field_seek' php_mysql.lo(.text+0x3ea4): undefined reference to `mysql_fetch_field' *** Error code 1 Stop in /usr/ports/www/apache13/work/apache_1.3.20/src. *** Error code 1 Stop in /usr/ports/www/apache13/work/apache_1.3.20. *** Error code 1 Stop in /usr/ports/www/apache13/work/apache_1.3.20. How I can build httpd with PHP as static modules in this case? --- With best wishes, Igor Shulgin --- -- JSC Uralsvyazinform | Applied Systems Department
