Compiling PHP402 with external mysql header files

Anon

Hi people,
I have tried to do the following on two different boxs with the same error message.
I am trying to run the php 402 configure command with the --with-msql=/usr/lib as the INSTALL instructions say to do but I still a "Configure: Error: Unable to find header files at /usr/lib"
my libmysqlclient.so is located in this directory and is linked to libmysqlclient.so.6.0.0.
I am compiling in mysql v3.22.32 on i686 redhat linux boxes.
I have the client, server, developer and shared mysql rpm's installed.
I have tried different directories where header files etc (including the default) are located but keep getting the same error message.
HELP !!

Thanks in advance.

Anon

It says: Configure: Error: Unable to find header files at /usr/lib"

*.so is a library, not a header file.

Check out where your mysql *.h files are located, and point to that directory.

Anon

Thanks for your reply Vincent, I have tried that as well thinking that might be the problem.
I had used the following switch.
--with-mysql=/usr/include/mysql
This is where a large number of *.h files exist for mysql.
Same problem.

Anon

I have been down this road myself... and I believe this is the issue. There is a default directory that php looks for when compiling itself for MySQL. While all the documentation leads us to do the obvious (which is to point the configure script to the appropriate directory), this does not seem to be how it ACTUALLY works.

Just use...

--with-mysql=/usr

That is what eventually worked with me, although I found out I was doing something else wrong, or at least I think I was which was causing an error. I had made a custom file with all my compile options on it with (./configure \ ) at the top and was executing that file, for some reason that didn't work the same as just copying and pasting this info to the console. Who knows what the real prob was.

Anon

Thanks Alan.

Setting the path to --with-mysql=/usr was indeed the fix to the problem.
It now configures quite happily.

Thanks again.
Mike.

Anon

Thank you both for documenting this problem. I have been beating my head against the wall over this problem for some time now and using --with-mysql=/usr was indeed the cure! Thanks again!