Re: [PHP 4.3.6] Compiling agaisnt MySQL 4.0.18 on Redhat 8

Aaron Axelsen wrote:

The mysql 3.x was installed with prefix /usr/local/mysql So why are you pointing to the 3.x path when compiling with 4.x?

And since you are going through all this trouble might as well use a very recent version of mysql

-- Aaron Axelsen Email: lists@frozenpc.net

Greetings, I compiled and installed mysql from source, and now I am trying to recompile php agaisnt the new version of MySQL (was previous running 3.23.53). Here is the configure string I used: ./configure --with-apxs2=/usr/local/apache/bin/apxs --prefix=/usr/local/php --with-mysql=/usr/local/mysql --with-pgsql=/usr/local/pgsql --with-gettext ... 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'

That sound like php used a 3.x mysql_version.h file to include but is trying to link against the real 4.x mysqlclient.so (since 4.x does not have mysql_create_db). At what prefix was mysql 3.x installed? /usr or /usr/local? Couple quick commands to find your mysql files > locate mysql.h > locate mysql_version.h > find / find / -type f -name "mysql*.h" #last resort Curt -- "I used to think I was indecisive, but now I'm not so sure."

-- Raditha Dissanayake. --------------------------------------------- http://www.raditha.com/megaupload/upload.php Sneak past the PHP file upload limits.