cannot add mysql support to mod_php

nightracer

Hi all,

I'm trying to set up a server that uses apache2, php and mysql.
Apache2 and php are working fine, php pages are displayed correctly, even phpinfo runs.
Now I'm trying to add mysql to php.
So I edited my make.conf and added mysql to USE.
However after recompiling mod_php it still cannot access a mysql database.
The phpinfo still reads: --without_mysql or some thing like that.
But there are other strange things in phpinfo: e.g.: --with_jpeg, --without_jpeg
How can these 2 flags exist at the same time?

I even tried: USE="mysql" emerge mod_php, to no avail.

How do you guys do it?

Regards
Nightracer

chris4linux · Posted: Fri Aug 08, 2003 11:02 am Post subject:

I have apache2, php4 and mysql4 on my box...first I installed mysql, than I give the terminal the following line:

rizzo · Posted: Fri Aug 08, 2003 6:27 pm Post subject:

USE="+mysql" isn't really valid. USE flags are either "mysql" or "-mysql".

maalth · Posted: Sun Aug 10, 2003 12:42 am Post subject:

If you're installing on mod_php on apache2, you have to use the following flags -apache apache2 mysql. If you're using apache1, put the - on apache2 instead.

splooge · l33t Joined: 30 Aug 2002 Posts: 636

I recompiled php and it didn't work for me either ...

Until I restarted apache! =)
_________________
http://get.a.clue.de

maalth · Posted: Sun Aug 10, 2003 3:31 am Post subject:

If you do an emerge -pv mod_php; it will show what flags are enabled. Red flags means it will be compiled in, blue means it will not. You have to make sure that at a minimum of USE="apache2 mysql" are enabled. If you need further help, please post. PHP should also be installed with the same options.

nightracer · Posted: Mon Aug 11, 2003 6:48 am Post subject:

Hi all,

The restart of apache2 did it.

Although a /etc/init.d/apache2 restart did not work, it stopped apache2 but failed to start it. There were errors about '[warn] child process ????? still did not exit, sending a SIGTERM'

Then a /etc/init.d/apache2 start did it. Apache2 is back up and running. phpinfo() now indicated: '--with-mysql=/usr' '--with-mysql-sock=/var/run/mysqld/mysqld.sock'.

maalth: you said PHP should also be installed with the same use flags as mod_php. However when i emerge -pv php, only the mysql flag is there, nothing about apache or apache2.

Everybody, thanks very much for helping me.

Regards,
Nightracer

darookee · Posted: Mon Aug 11, 2003 11:51 am Post subject:

zona · n00b Joined: 14 Aug 2003 Posts: 1

can I emerge mod_php with mysql support and dont have to install mysql?
I'm using a remote mysql and I dont need a database running in my box.
thanks for advise.

rizzo · Posted: Sat Aug 16, 2003 11:50 pm Post subject:

Whatever box you are running apache/mod_php on has to have mysql installed on it. Even if you plan to access a remote mysql database, the mod_php needs to have the mysql libs locally at compile-time, which only happens by emerging mysql.