Hi,

Untill now, I've been using apache2, mysql, php4 without any troubles.

But I wanted to switch over to php5 because of the improved class-object system.

But ./configuring the php5 module seems to give a lot of trouble. (in contradiction to php4)
It started with the libxml2 - problem (which can be seen in many posts) and was solved by manually configuring, make and make-installing the version 2.5.10 instead of the apt-get 2.6.x version.
And now, I get this error:
"...
checking for mSQL support... no
checking for MSSQL support via FreeTDS... no
checking for MySQL support... yes
checking for specified location of the MySQL UNIX socket... no
checking for MySQL UNIX socket location... no
configure: error: Cannot find MySQL header files under /usr/local/src/php-4.3.7/ext/mysql/libmysql.
Note that the MySQL client library is not bundled anymore."

I used: ./configure
--with-apxs2=/usr/local/apache2/bin/apxs --with-mysql=/usr/local/src/php-4.3.7/ext/mysql/libmysql
--with-gd --with-zlib --enable-sockets --enable soap

the "--with-mysql=/usr/local/src/php-4.3.7/ext/mysql/libmysq" was changed from originally "--with-mysql" because it gave the same error.
I did a find / -name mysql.h to find out where these headers are and it turned out to be this directory: "/usr/local/src/php-4.3.7/ext/mysql/libmysq"
But the error didn't go away.

I've been googling and forum-searching for some time now but can't figure out a correct solution to this.

If you've got a clue, please let me know. I'm about to install a new version of mysql in the hope (vain?) that this problem would go away.

btw: I've been ./configuring quite a few times now, hope that it don't matter.

Any help is appreciated.

thanks and regards,
Lieven

Anybody got any ideas here? Or has this question been answered before maybe? Just a hint could help me out here.
thanks.

Where is your mysql installed? You must point the --with-mysql= to that directory.

Thanks but it didn't work. (except if I did wrong)

1:
root@lieven:/usr/local/src/php-5.0.1# whereis mysql
mysql: /usr/bin/mysql /etc/mysql /usr/share/mysql /usr/share/man/man1/mysql.1.gz

2:
./configure --with-apxs2=/usr/local/apache2/bin/apxs --with-mysql=/usr/bin/mysql --with-gd --with-zlib --enable-sockets --enable-soap

3:
checking for MySQL support... yes
checking for specified location of the MySQL UNIX socket... no
checking for MySQL UNIX socket location... no
configure: error: Cannot find MySQL header files under /usr/bin/mysql.
Note that the MySQL client library is not bundled anymore.

Thus I have the same error as before.

How did you installed mysql? From source or from binary? Anyway in my installation there is a directory "include" under mysql tree with all the mysql header files. You can also try:
to find out where are the headers.

problem was that the mysql was allready on the distribution installation for some vague reason. (using knoppix 3.4 here) And the folders seemed to be impossible to find.
So I just downloaded the mysql source for a newer version 4.1 instead of 4.0 and configured and installed it.
Now, the ./configure for the php5 worked fine.
Is making now, can take some time on the old K6-II 300MHz.
(making mysql took almost an hour )
thanks for the replies.
rgds,
Lieven

Just ran into that tonight, I just stoped MySQL and then ran make again and it resolved and was successfull.

Folks, I am having the same problem.
I tried to do
find / -name mysql.h
and found out only the ones located in the PHP4-XXX /ext/mysql/libmysql/
tried those and still the same error.
Do I have to reinstall MySQL?
"Share your Experience!"
Thanks,
Teddy

I had the same problem too, on Debian Woody 3.0.

To solve it, I didn't need to reinstall MySQL - what I did was this:
apt-get install libmysqlclient10-dev
(this installs the MySQL client libraries - presumably SUSE has a similar extra package)

And then configure PHP5, pointing to the location where the MySQL client libraries were installed to, like so:
./configure --disable-libxml --with-mysql=/usr/include/mysql/

Then configure worked.

For SUSE, use yast2 to install mysql-devel and everything will be hunky-dory ( at least for me it was)

Solution for fedora is yum install mysql-devel. Then set --with-mysql=/usr/include/mysql/

Forget my post, it doesn't work, if you find the solution for red hat 4 enterprise edition I will thank you

Hello, I installed mysql 5 from the rpm's, and I have become crazy until I have proven the following thing:
./configure <blablabla> --with-MySQL
(write My-SQL, since the packages rpm of mysql 5 distinguish caps from small letters)
(sorry for my horrible english, i used the google translator), cheers from spain

I assume you're all installing based on the PHP install guide which says:
./configure --with-apxs2=/usr/local/apache2/bin/apxs --with-mysql

At this point, you've probably already installed apache and mysql

the first part of this command is pointing the config script at you're apache directory.
the second part is pointing it at the mysql directory, but that isn't clear here

if you installed mysql according to the guidelines, its probably in /usr/local/mysql (because you did a ln -s to create the link).

so do this (from inside the php-nn dir):

./configure --with-axps2=/usr/local/apache2/bin/apxs --with-mysql=../mysql
or
./configure --with-axps2=/usr/local/apache2/bin/apxs --with-mysql=/FULL_PATH_TO_MYSQL_DIR/

Ubuntu: php and apache (from source) and
mysql (from package install)

/usr/local/php-5.2.3# apt-get install libmysqlclient12-dev

./configure \
--with-apxs2=/usr/local/apache2.2.3/bin/apxs \
--with-mysql \
--prefix=/usr/local/apache2.2.3/php \
--with-config-file-path=/usr/local/apache2.2.3/php \
--enable-force-cgi-redirect \
--disable-cgi \
--with-zlib \
--with-gettext

Where --with-config-file-path
copies the php.ini automatically

Fixed

Thank you monguesto. I have spent a few hours looking for the right solution and almost dived into reinstalling mysql, with all the possible horrors connected with it.
You are the hero of the day!