Joomla! Discussion Forums

Hi, I'm trying to get familiar with Joomla and run it on a local test server, however at the pre installation check Joomla is saying that MySQL Support is unavailable, yet I have both MySQL 5.0.22 installed and running perfectly on my Windows XP machine with IIS installed.

Everything else is showing up as available so it's just this issue that's preventing me from installing Joomla.

Is there any reason why MySQL would be showing as unavailable to Joomla?

Hi,

Maybe the following topic could be of help: http://forum.joomla.org/index.php/topic,10490.0.html

Regards Robin

Thanks for the link, Robin... I think it's pointed me in the right direction but still no joy.

Hi,

What if you check the php info page? Through backend, system info? Does mysql show up in there?

Looking at the PHP info page I can't see any reference to MySQL - that's the big puzzle for me. 

Okay, so you looked at php.ini? any extensions/dll's that need uncommenting in there?

I have:

extension=php_mbstring.dll
extension=php_mssql.dll
extension=php_msql.dll
extension=php_mysql.dll
extension=php_mysqli.dll

All uncommented.

On http://www.design-ireland.net/index.php ... ing-11.php

I also found a note on extension dir, you might want to check that in your php.ini



Also make sure to restart your webserver for settings to take affect.

Yep, already done and done and now double checked.

The server is IIS on my local machine.

Still no joy.

I'll do some digging, see if I can find something else to check...

Thanks, I appreciate the help.

I'll keep looking myself, but I'm at a total loss at the moment.

As an aside, should the MySQL extension on the PHP info page appear as it's own separate category?  If not, where exactly should I be looking for it?

Hi,

Yeah, it should show up on php info page in it's own category with some basic info about mysql. I'm setting up a Windows/IIS server tomorrow so hopefully able to provide more info/help.

Good luck, Robin.

Keep me posted.

Hmmm, trying to install PhPMyAdmin and having a similar problem throws up an interesting clue in the PhPMyAdmin documentation:

[1.20] I receive the error "cannot load MySQL extension, please check PHP Configuration".

To connect to a MySQL server, PHP needs a set of MySQL functions called "MySQL extension". This extension may be part of the PHP distribution (compiled-in), otherwise it needs to be loaded dynamically. Its name is probably mysql.so or php_mysql.dll. phpMyAdmin tried to load the extension but failed.

Usually, the problem is solved by installing a software package called "PHP-MySQL" or something similar.

I haven't had much luck searching for any software called PHP-MySQL, have you heard of it, per chance?

Hi Basil,

I had the same issue and managed to resolve it.

You dont mention which version of PHP you are using, so I'll assume its the latest - i.e. PHP v5.1.4.

First of all, head over to the mysql site and grab their version of the mysql api file for php:
- http://dev.mysql.com/get/Downloads/Conn ... /from/pick [contains php_mysql.dll & libmysql.dll]

Place the 'libmysql.dll' in the "c:\php" folder and 'php_mysql.dll' into the "c:\php\ext" folder (overwriting the existing files from the default php download.

Now check the windows security permissions for both of these files and ensure that its inheriting from the parent. You can fix it if necessary by toggling the inheritance checkbox and applying.

That should do it - at least, thats what worked for me.

Hope this helps!

Hi ArPharazon,

Thanks for that, I'll give it a shot when I get back into work on Monday.

I am using the very latest version of PHP, as it happens - everything have been a fresh download apart from IIS which is just the version I have with XP.

Cheers.

Hi,


I was able to install a fresh Win2003/IIS with latest php/mysql and did what I posted here; http://forum.joomla.org/index.php/topic ... #msg391306

So just uncommented the extension dll's so php connects to mysql. You might want to check that again.

Hi Basil,

Just read your post again - if the php info page does not display a mysql section after updating the php_mysql.dll & libmysql.dll files, then I'm pretty certain that its the file permission on those 2 files that are screwed up!

At least that was the problem in my case.

Let us know if the same works for you or not - good luck!

Hi Guys,

Newbie here trying to set up a joomla server on WinXP using Php 5.1.4 and mySQL Server 5.0.

When loading the "Pre Installation Check" Page, I get "mySQL Support Unavailable" 

Any suggestions would be most appreciated.  I've been searching the forum and tried the various suggestions but still could not get mySQL support to be "available".

There have been suggestions to downgrade to an older version of Php.  Would anyone have a copy of the installer?

Thanks! 

Problem almost solved! 

MySQL is now showing as available - I can finally see it in my PHP info file, also.  However, on the Joomla pre installation page, the session save path has changed from being writable to unwritable.  I'll do a search of the forum and see if I can find out why, but I just wanted to keep everything in here, if you guys have any suggestions?

Thanks to RobInk and ArPharazon for their patience. 

bustmybrain - Make sure you follow the instructions in this thread, noting the quoted post here and the uncommenting of extensions in your php config file, also look up how to make a phpinfo file so you can check the status of your php, try copying the file c:/PHP/backup/php (configuration settings) to c:/PHP/ if it's not already there, it'll need to be.

Hi Basilthefox

Almost there!

To fix the session save path problem, simply create a 'sessions' folder in your main "c:\php" folder.

Now edit your PHP.ini file and set the appropriate variable, i.e.

session.save_path = "C:\PHP\sessions"

(its blank by default if I remember correctly).

Good luck!

Heh... got it.

Cheers mate.

session.save_path = "c:/PHP/tmp"

uncommented, too.

Just linking this for reference:

http://forum.joomla.org/index.php/topic,69709.0.html

Configuratioon file creation.

Hey basilthefox! Thanks for emphasizing that i review this thread again.  I took a deep breath, relaxed and scrolled back the page.  Got to the post by RobInk, clicked on the link he posted.  Followed the instructions on that other page and VOILA!  all the stuff is green on my web installer page.

Have now successfully installed Joomla!  I get a small error on my test homepage, but I'll post that on another thread as it would be off-topic here.

To you, RobInk, Nostra from the other thread for that beautiful "Recap + additional info" and all the rest of the people on this forum, Thanks a million!

I'm glad you guys got it working  It takes some time and effort, but it's worth it, enjoy Joomla!

Hi there,

I'm having a similar problem. This is my first time trying to install Joomla and run it on a local test server. In Step 2 (Pre-Installation Check) it showed "MySQL Support - No". I definitely have installed MySQL successfully, thats what puzzled me. I've searched alot and edited my php.ini file alot but still no luck. Here is what I already installed on my Windows Vista machine:

apache_2.2.11-win32-x86-openssl-0.9.8i
mysql-5.1.32-win32
php-5.2.9-win32-installer
Joomla_1.5.11-Stable-Full_Package

I've also attached my php.ini file in case anyone can point out my mistake.

Any help would be great.

Cheers