I have run the installer however it says it will not connect to the database (unable to connect to database).

PROBLEM:

I have run the initial (setup.exe) DCA installer however I keep receiving an unable to connect to database error?

TROUBLESHOOTING:


The dca_config.php should contain all of the settings after you run the setup.

Does the dca_config.php exist?

The database parameters are in the dca_db.php Are they correct inside this file?

Are you running on windows or solaris?


What happens when you type

#  mysql -u <the userid you gave> -p <the password you gave> -D<database name>

the default userid is [root]
the default password is [password]
the default database is [dca]

Therefore the default syntax would be:

# mysql -uroot -ppassword -Ddca

*note, it does not matter if you put a space between the "-u" and "-p" and "-D"

If you can not connect to mysql database using your userid/password then I would verify mysql is up and running.  In windows check Services (control panel - administrative tools -- services) or in unix "ps -ef|grep mysql"

If you can connect then you would need to contact support to describe the error.

The majority of these errors are due to either an incorrect userid/password, or the mysql service not being properly started.