How to config PHP4 with MySQL 3.22.32?

Anon

I have redhat 6.2, apache 1.3.12 and mysql 3.22.32.
I downloaded php 4.0.1pl2 and config with following options:
./configure --prefix=/usr
--with-config-file-path=/etc/httpd \
--with-exec-dir=/usr/bin \
--with-apxs=/usr/sbin/apxs \
--enable-track-vars \
--with-mysql=/usr \
--with-imap=/usr

make
make install

Apache can't start and I run /etc/rc.d/init.d/httpd status, it tell me that "httpd dead but subsys locked".

But if I change --with-mysql=/usr to --with-mysql=shared, Apache can start.
How to config PHP4 with MySQL 3.22.32?

Thank you.

Anon

Try to follow EXACTLY (even the directory structure) what in PHP manual written is.
Hoping you have mysql in /usr/local/mysql/
you should have a nice working apache with PHP module with MySQL support.

At have the same software versions, i did so and it works. Didn't try the other way.

fell free to mail me.
Marcin

Anon

I installed MySQL(server,client,share & devel) from RPM. If i did for other options, configure reported that "cannot find header files under ...".
If I use --with-mysql=/usr, I can config,make and install. But after installed, apache can't start.

Anon

I can help it exactly.
But try this way:
1) go to www.mysql.com and download latest version of mysql applicable for your system.

2) extract the downloaded file (most propably *.tar.gz) into /usr/local/
you will then have direcory like mysql-version-other-info in /usr/local/

!!! do not install , extract only !!!

3) make a symbolic link from /usr/local/mysql to the directory that was created step earlier.

4) compile php with --with-mysql=/usr/local/mysql

5) finally - compile apache 🙂

If it fails do the same, but with installing mysql (you would have to remove mysql installed from RPM to avoid conflict)

If the apache works ok try to change directory name from /usr/local/mysql to /usr/local/mytest for example.
if apache still starts, you can safely delete mysql you've downloaded. if not change the directory name back again.

If you should have problems with mysql installation fell free to contact.

That's exactly the way i did it.
(i'd installed mysql, because i had no rpm of one)

good luck!
Marcin.

Anon

I was having similar problem on the Solaris side and found that env parameters were not pulling the lib files. I was able to modify my .profile to include the exact path for the LD_LIBRARY_PATH for mysql (and Oracle) and apache finally started.

I had not had this problem using Apache 1.3.9 with PHP3 and MySQL 3.22.32, but the change to Apache 1.3.12 and PHP4 did not pull from the paths I built into Apache nor PHP. Apache appears to default to your shell's path for lib.

Anon

hi there
i want to compile php4 with latest version of mysql. i envoke as:
./configure --with-mysql=/usr/include/mysql --with-apxs
and prompts that "no hearder files found".
Plz help me.

Paras

Anon

I found that my problem was related to not having the proper path set to the lib files. This could be the reason for the "no headers" in your case.

All the best,
Tom

Anon

is /usr/include/mysql is the right place for headers??.

Paras