By sunilwu on

Hi.

A while ago I installed drupal5,2 on a linux box.
The machine was running apache2 and php4.3.

I upgraded to apache2.2 and php5.2.4

The installation went smoothly.

However, when I access my drupal installation via my browser, I get:
"
PHP MySQL support not enabled

We were unable to use the MySQL database because the MySQL extension for PHP is not installed. Check your PHP.ini to see how you can enable it.

For more help, see the Installation and upgrading handbook. If you are unsure what these terms mean you should probably contact your hosting provider.
"

I compiled php with mysql support. When I checking my php.ini, it appears that all the relevant sql entries are included and uncommentented.

Is this really a problem with my php installation? Or is there something else going on?
How can I further diagnose this problem ?

Thanks

⋅ Categories: Drupal 5.x

Comments

sunilwu’s picture

sunilwu commented

I re-installed my older version of php4.3, simply by putting it back into /usr/local.
Still, drupal gives me the same errror message.

If I do:
php -i | grep -i slq

Then the result I get back tells me that mysql support is most certainly configured in.

So (afaik) now the only difference between my current setup and my old one is that I have a newer version of apache running.

Where do I go to from here to figure out the problem ?

tm’s picture

tm commented

not a linux person but... what does phpinfo() tell you? is "php -i | grep -i slq" supposed to do the same thing?

sunilwu’s picture

sunilwu commented

Crap.
phpinfo() tells me (among other things) that one of the configure options was:
'--without-mysql'

This is bizarre.

This is my old php, placed back into /usr/local/php. This had been working, and allowing drupal to work up until I shifted it to a backup directory, where it wasn't being executed. And now that I've put it back into an executable place in the filesystem, it's telling me that it was configured without mysql?

But also, further down the phpinfo() output there are option settings for mysql.

So, I'm not sure whats going on.

I also configured and installed php 4.4.7 ... and made sure to compile in mysql support.
Drupal still gives me the same error - no sql support.
The new phpinfo output gives similair results: in the configure options it gives
'--without-mysql', and still outlines a whole lot of mysql options further down the page.

So, I'm still not sure if this is a drupal problem or if I'm cocking up the php installs.
Any ideas ?

tm’s picture

tm commented

how does apache know about your newly-compiled version of php, and is it possible to have multiple concurrent versions/installations of php on the machine?

and then, is the mysql(i?) support in php specific to the version of mysql? oh, that's three; sorry.

sunilwu’s picture

sunilwu commented

>how does apache know about your newly-compiled version of php

Does apache have to know that Im running a new version?
I'm not so sure that it does. The drupal error message wouldn't appear if it couldn't find
my currently installed version of php.

>possible to have multiple...
yes. But I'm not going to try. That's too kung fu for me. And not neccessary for my needsd

>is the mysql(i?) support in php specific to the version of mysql?
I doubt it. And I'm sure drupal would give me a different error message if that happened.

tm’s picture

tm commented

- asked about the apache thing for the loadmodule stuff in httpd.conf; are there different mods loaded for different versions? but i don't know if that is something that would change or have path info
- asked about the possibility of multiple php installations in case you might have that. guess not in your case. phpinfo would also indicate which version/path of php.ini it is using, i think.
- there were connector issues for some combinations of php/mysql versions, but that was for windows installs.

for the php.ini thing, the indicator i have noted in my (very) short experience is the "no database configured" error, which is not the case here.

hm, anything in linux that would be used globally to indicate where applications are installed?

sorry, not helping any here.

heenak’s picture

heenak commented

After reinstalling the php i am getting following error on my DRUPAL website

"PHP MySQL support not enabled"

Did a lot of manipulation with php.ini file, but nothing has happened.

Kindly help!!