compiling php 4.3.6 with mysql 4.0.18

[axman505]

I just upgraded my mysql installion, and i went to recompile my php installiong but now i am getting the following errors:

li.lo sapi/cli/getopt.lo main/internal_functions_cli.lo -lcrypt -lcrypt -lpq -lmysqlclient -lresolv -lm -ldl -lnsl -lcrypt -lcrypt -o sapi/cli/php
ext/mysql/php_mysql.lo: In function `zif_mysql_create_db':
/home/aaron/php-4.3.6/ext/mysql/php_mysql.c:1158: undefined reference to `mysql_create_db'
ext/mysql/php_mysql.lo: In function `zif_mysql_drop_db':
/home/aaron/php-4.3.6/ext/mysql/php_mysql.c:1200: undefined reference to `mysql_drop_db'
collect2: ld returned 1 exit status
make: *** [sapi/cli/php] Error 1


any suggestions?

 

[sleipnir214]

How are you invoking the configure script?

How did you install MySQL, and what did you install?



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[axman505]

PHP configure string:

./configure --with-apxs2=/usr/local/apache/bin/apxs --prefix=/usr/local/php --with-mysql=/usr/local/mysql --with-pgsql=/usr/local/pgsql --with-gettext


Mysql Configure String
./configure --prefix=/usr/local/mysql --with-openssl=/usr/local/openssl

 

[sleipnir214]

I assume, then, that you installed MySQL from source. As an aside, MySQL AB recommends that one install MySQL from binary. Yours isn't one of them, is it?

One thing I do differently....I generally have better success when I tell PHP's configure script "--with-mysql=/usr".

Have you successfully compiled PHP from source before using the configure options you've specified?



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[axman505]

I have compilied php several times using the same configure options. ONly when i upgraded mysql did i start getting that error.

 

[sleipnir214]

From what version of MySQL did you upgrade? It may be that if your previous version was 3.x, PHP used its bundled libraries rather than any external code.



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[axman505]

I upgraded from 3.23.53

 

[sleipnir214]

If the MySQL communications library were missing, the compile script would not complete. Could the MySQL library be damaged?



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[axman505]

MySQL is up and running, should i try to recompile it?

 

[sleipnir214]

On what platform are you trying to compile PHP?



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[axman505]

redhat 8.0

 

[sleipnir214]

I've never installed MySQL from source. Could there be some options to the configure script that is causing the problem? Did you install your previous version of MySQL from source, too?




As an aside, this warning from the MySQL downoads page:

Compiler Advisory: Several users have reported random crashes and table corruptions when using MySQL binaries compiled with gcc 2.96 on the x86 Linux platform. We suggest that you use gcc 2.95 or gcc 2.91 to compile your own binaries. It should also be safe to use gcc 3.2.

doesn't apply to you, does it?



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[axman505]

My previous version was also installed from source.

I will check into the gcc thing, that could very well be it.

 

[sleipnir214]

I've had very good success installing MySQL from the binaries provided at [ignore]www.mysql.com[/ignore]



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[axman505]

I am running version 3.2 of GCC

 

[sleipnir214]

Have you tried compiling PHP using the bundled MySQL library code?

--with-mysql

(no "=/some/path")

?



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[sleipnir214]

Also, how did you install your previous version of MySQL?



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[axman505]

Isnt it recommended to specifiy a path with --with-mysql ??

Here is what i just did. i moved the current mysql install from /usr/local/mysql to /usr/local/mysql3

I compiled and installed mysql4 to /usr/local/mysql

However, i still get the same error during make.

 

[sleipnir214]

When recompiling PHP, did you go through the entire "configure - make - make install" sequence?

Have you tried deleting config.cache and running "make clean"?



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[axman505]

Before every compile, i was running make clean and make distclean. I finally got fed up, and deleted the source folder, untared it again. And this time it finally worked.

Thanks everyone for your help!