New installation issue with mySQL

[rtmtek]

I've installed SugarCRM on a Windows XP Pro box with mySQL 5.0.1. I've read through all the posts and tried all the tricks mentioned. My installation screen comes up as:

In order for your SugarCRM installation to function properly, please ensure all of the system check items listed below are green. If any are red, please take the necessary steps to fix them.

Component Status
PHP version Unsupported (ver 5.1.2)
MySQL Database Not Available
XML Parsing OK
cURL Library Not found: scheduler will not be functional
Writable SugarCRM Configuration File (config.php) OK
Writable Custom Directory OK
Writable Modules Sub-Directories and Files OK
Writable Data Sub-Directories OK
Writable Cache Sub-Directories OK
Writable Session Save Path (C:\PHP\sessiondata) OK
PHP Safe Mode Turned Off OK
PHP Allow Call Time Pass Reference Turned On OK
PHP Memory Limit >= 20M OK (No Limit)

Note: Your php configuration file (php.ini) is located at:
C:\WINDOWS\php.ini

I can connect to mySQL through the command prompt and I think I have all the IIS permissions correct.

Any thoughts on why the database is not available?

Thanks.

[bluskyguy]

I'm experiencing the same exact problem...except on my screen I receive the 'not available' message and don't even see the mysql database reference.

[kbrill]

Can you install something like phpMyAdmin and see if it works? If it does not then the problem most likely is between php and mysql.

[shafik]

I got the same problem with the MySQL DB configuration. The following steps helped me fix the issue:

Modify the php.ini file
- set extension_dir = "./ext" (I had installed PHP5, for PHP4 the directory is ./externsions)
- uncomment extension=php_curl.dll line
- uncomment extension=php_mysql.dll
- set session.save_path = "c:\php\tmp" (You already had a valid path)

Save the php.ini file and restart the web server:
- net stop iisadmin
- net start w3svc

After this, I was able to proceed with my installation of SugarCRM. Hope this helps.

[rtmtek]

Many thanks to Shafik! I did the things you listed. Got an error about finding the 2 dll's. Realized that the files had not been copied to my C:\php directory so I did that. Restarted the installation and everything has gone fine with the exception of a few errors in step 6.

I'll be investigating why the config.php wouldn't create; why permission was denied for .htaccess; figuring out where all the data demo went. But at least php and mySQL are talking nice.

Great responses - I do have Admin downloaded and running for mySQL to administer my remote database I created for blogging. It's a great tool and I'm really happy with mySQL.

Thanks again,
-Mike