ENVIRONMENT:
XOOP 2.0.13.1 / Windows 2003 Server / IIS 6.0 / PHP 4.3.11 / MySQL 4.3
I am the root admin for the entire server.

ISSUE: - Installation Error:
Could not connect to the database server.
Please check the database server and its configuration.

NOTES:
I have successfully created the database and was able to login to the MySQL Administrator using the newly created user and password. I have created several MySQL databases and users for number of other php/MySQL applications so I feel confident this was done correctly. I also tried using the known good ‘root’ user just as a test but the install still reported the above error.

File permissions indicate:
Directory uploads/ is writable.
Directory cache/ is writable.
Directory templates_c/ is writable.
File mainfile.php is writable.

As a test I also gave FULL CONTROLL to the wwwRoot folder for the Internet Guest User account, this did not help either.

I have other PHP/MySQL applications running on the same server so I know PHP & MySQL installations are working properly.

QUESTION:
What else might be going one here that would prohibit the install from connecting to the database?

Thanks,
Technobia

Did you pre-build the actual DB without content from phpMyAdmin or similar? If the DB does not exist you could get this type of error.

You might consider including the actual error text here for debugging.

or you could allow XOOPS to create it during installation.

also when you created the database and user... did you assign the user to the database with all priveledges

localhost is your friend....

thats all i got.

Hey Rabideau & Biteronboard

I pre-created the database via the MySQL Command line and I gave the user the following “Schema Privileges” to the database: Select, Insert, Update, Delete, Create, Alter, Index, Drop.

Never thought to try to let XOOPS create the database. I will give that a try and get back with results.

Thanks - Technobia.

Not sure what happended but I tried to let XOOPS create the database as suggested above, I got an internal error in the browser and the install page would not load.

So, I copied all the files over the first set and tried again, install loaded. Then I used the same login & database I originally created and XOOPS installed easily.

I suspect some of the install files were perhaps corrupted. Anyway I am working now!

Thanks for the help
Technobia

Hi guys, im having the same problem here. And i have tried to do all the written stuff but allowing XOOPS to create the database.

Could someone tell me how to do it please? thanks!