"You must have the MySQL PHP module installed."

stewie09

Joined: 2008-01-20
Posts: 18
Posted: Sun, 2008-01-20 19:51

I am running Apache 2.2.6, PHP 5.2.5, and Mysql-5.0.45 on WinXP with latest SP. Now I am trying to install Gallery2, but I keep getting the following error:
"You must have the MySQL PHP module installed."
In my attempt to resolve this issue, I did the following but no success.

I added extension=php_mysql.dll to PHP.ini file.

PHPIniDir "C:/PHP/" is in my httpd.conf file.

This is my path:
C:\PHP\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Common Files\Ulead Systems\MPEG;C:\MySQL\bin

I also put the php.ini file in C:\Windows, and I encountered the same problem.

Can you help me to get this install?
Thanks

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Mon, 2008-01-21 14:41

It's been a long time since I've had Apache, PHP and MySQL running on Windows.

Have you rebooted or stopped and restarted Apache? There may be some info here that helps. http://us.php.net/mysql
Looks like there is another dll you need to make sure can be found.

If you have multiple php.ini files, make sure they are all the same, or just get it down to 1 and make sure Windows sees that file in the path.

Did you install Apache, PHP, MySQL through something like XAMPP http://www.apachefriends.org/en/xampp-windows.html If so then everything should just work. If not, I would try that ;) It makes for getting these programs up and running on Winbloze much easier.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
stewie09

Joined: 2008-01-20
Posts: 18
Posted: Mon, 2008-02-11 02:49

Help
I am still unable get gallery2 install.
As suggested, I installed Apache, PHP, MySQL through XAMPP http://www.apachefriends.org/en/xampp-windows.html.

XAMPP was installed successfully, and tried several times to install gallery2 but was unsuccessful. Each time I tried I got the following error:

Unable to connect to database with the information provided.

We received the following database related errors:

Warning: mysqli_real_connect() [function.mysqli-real-connect]: (28000/1045): Access denied for user 'root'@'localhost' (using password: YES) in C:\xampp\htdocs\gallery2\lib\adodb\drivers\adodb-mysqli.inc.php on line 108
Could't connect :
localhost: Connection error to server 'localhost' with user 'root'

Please see the picture for more details. Thank you for your assistance.

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Mon, 2008-02-11 10:19

Make sure mysql is running, also make sure you have the correct username and password. If you need to reset the mysql password click here:
http://www.apachefriends.org/en/faq-xampp-windows.html#password0

Oh and also make sure you don't have anything blocking the port that mysql is running on. Like a local software firewall.

____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
stewie09

Joined: 2008-01-20
Posts: 18
Posted: Sun, 2008-02-17 01:10

I turned off my Windows firewall, successfully reset the mysql password using the instruction from the URL you included, and then I re-tried the installation. Unfortunately, I am still getting the same error. Thank you for replying and for trying to help.