Easyapache not building php with mysql support

[Psychoholic]

When I try and run a pretty stripped down version of the easyapache configuration with php 5.2.6, apache 2.2 and mysql 5.0.51a it fails through the build process:

-- Begin opt 'Mysql' --
	-- Begin dryrun test 'mysql compilation test' --
/usr/local/lib/mysql/libmysqlclient.so: undefined reference to `gethostbyname_r'
Can't exec "/cpmysql": No such file or directory at /var/cpanel/perl/easy/Cpanel/Easy/Utils/MySQL.pm line 102.
Use of uninitialized value in string eq at /var/cpanel/perl/easy/Cpanel/Easy/Utils/MySQL.pm line 108.
	dryrun test 'mysql compilation test' did not return true
	
	!! Dry run failed for 'Cpanel::Easy::PHP5::Mysql' skipping option !!

I have tried the mysqlup --force but it is showing that it is already up to the latest version, I have tried running the 'basic' config for easyapache and only adding the things that mysql needs (to shorten the build time and try and narrow down the issue). Mysql is running on the machine and I am able to connect to it, apache is running, php won't do mysql_connects (since it's not built in). My customers are freaking out on me (every site I have built for them is a php/mysql site) and are threatening bodily harm! (not really, but they aren't happy). The file 'cpmysql' is not on the server anywhere.

I am running:

WHM 11.23.2 cPanel 11.23.4-S26157
FREEBSD 6.1-RELEASE i386 on standard - WHM X v3.1.0

[Psychoholic]

Ended up rebuilding the mysql50-client from ports (make deinstall first, then 'make reinstall', ran the easyapache update again and rebuilt php - works like a champ!

[Interdit]

Similar error with Apache 2.2 and Mysql 5.1.x:

The last time Cpanel::Easy::PHP5::Mysql was run; step returned 0.

That just caused Cpanel::Easy::PHP5::Mysql to be skipped.

The message it gave was:
Could not compile a simple mysql.h program: -compile- -output-

You might want to take that into consideration when choosing options and troubleshooting.

The log for that build is here: /usr/local/cpanel/logs/easy/apache/build.1235516398

Any fix ?

[cPanelDavidG]

Similar error with Apache 2.2 and Mysql 5.1.x:


Any fix ?

MySQL 5.1.x is not natively supported by cPanel/WHM at this time. I currently recommend using MySQL 5.0.67 instead (the latest 5.0 version of MySQL that is currently supported).