Problem with installing MySQL

[pwpeterson]

I am having problems getting PHP's ./configure to complete when I include --with-myslq=/usr/local/mysql. I get
"configure: error: Cannot find header files under /usr/include/mysql". The headers are there. I tried to move them to another directory and I get the same message.

I can get it to configure with just --with-myslq, but then I get a warning message at the end stating in part: "instead build it with your local MySQL support files, by adding --with-mysql=/path/to/mysql to your configure line.

I am using PHP-4.3.2RC1 and have installed:

MySQL-embedded-4.0.12-0
MySQL-client-4.0.12-0
MySQL-bench-4.0.12-0
MySQL-devel-4.0.12-0
libmysql10-3.23.55-1mdk
MySQL-server-4.0.12-0
MySQL-shared-4.0.12-0

What am I doing wrong?

pwpeterson

 

[sleipnir214]

The only thing that comes to mind is that PHP may be expecting the MySQL v. 3.x headers by explicit name. Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[pwpeterson]

How would I check that?

 

[pwpeterson]

I rpm -e'd the MySQL rpms and installed MySQL using the binaries. I ran into the same problem.

Ideas?

pwp

 

[sleipnir214]

I've looked in config.status from the last time I compiled PHP. I used --with-mysql=/usr and it worked. Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[pwpeterson]

Are the mysql headers in your /usr directory? Mine are in /usr/local/mysql/include. I set it to -with-mysql=/usr and got the same result:

configure: error: Cannot find header files under /usr

pwp

 

[danielhozac]

It doesn't want the directory that contains the headers, rather, it tries to find the files under [tt]<supplied directory>/include/mysql[/tt]. Have you tried using [tt]/usr/local[/tt] instead? //Daniel

 

[sleipnir214]

pwpeterson

No, my libraries are not in /usr. They are in /usr/lib/mysql, as they are on your machine. PHP's compile script will find them if you specify just &quot;/usr&quot;. Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[pwpeterson]

sleipnir, Thank you... Keep in mind I installed the binaries to /usr/local/myslq which puts the headers in /usr/local/mysql/include. I created and moved the headers to /usr/lib/mysql and set -with-mysql=/usr. I still got the same error.

danielhozac, Thank you as well... I created and moved the headers to /usr/local/include/mysql and used -with-mysql=/usr/local. This time it worked. However, I did encounter another problem that I resolved by moving libmysqlclient* to /usr/lib and creating a soft link
ln -s libmysclient.so.10 libmysqclient.so

My thanks to both of you again.

pwp