Please describe the issue you're having
If you accept the answer, please mark the topic as [SOLVED] by clicking the tick.

Moderators: RussH, cptr13

Forum rules: Just please remember to play nicely once you walk through the door. You can disagree with us, or any other commenters in this forum, but respect our space and keep your comments directed to the topic at hand.
#3000
Hello everyone,
I have been installing OpenCATS onto a RHEL server with everything loading into Linux just fine. But when I start the actual OpenCats installation, when I get to the CATS installation test, I get:

Cannot connect to database
Access denied for user 'cats'@'localhost' (using password: YES)

Using phpMyAdmin I checked and the cats user is created. One curiosity: In the OpenCATS documentation the instructions to create the user from the command line gave me a syntax error. Also, the documentation says to create user: 'opencats' but the installation test seems to be checking for user: 'cats.' The instructions also indicate 'databasepassword' which I used when I created the user and password in phpMyAdmin. I have tried every combination of user 'opencats' and user 'cats' along with the 'databasepassword' no password, and anything else I could think of.

I am pretty stuck here. Thank you in advance for your help and guidance.
#3026
I think I found it.

I am having hte same issue attempting to get 9.4 installed and running.

In the Config.php there is a section that looks like this:
/* Database configuration. */
define('DATABASE_USER', 'cats');
define('DATABASE_PASS', 'password');
define('DATABASE_HOST', 'localhost');
define('DATABASE_NAME', 'cats_dev');


Note that the username, password and db name are set to values completely different than the instructions. I believe you just need to change these to the values that we were given:

/* Database configuration. */
define('DATABASE_USER', 'opencats');
define('DATABASE_PASS', 'opencats');
define('DATABASE_HOST', 'localhost');
define('DATABASE_NAME', 'opencats');

I am going to test it next - I have to re-upgrade as I backed out when I could not get past the same issue.

Hope this helps.
#3027
Hi Gregg.

when you manually create a database and user in MySQL, you need to specify that in the installation wizard. Please report back if you have further problems!
#5074
gregg wrote: 25 May 2017, 14:51 I think I found it.

I am having hte same issue attempting to get 9.4 installed and running.

In the Config.php there is a section that looks like this:
/* Database configuration. */
define('DATABASE_USER', 'cats');
define('DATABASE_PASS', 'password');
define('DATABASE_HOST', 'localhost');
define('DATABASE_NAME', 'cats_dev');


Note that the username, password and db name are set to values completely different than the instructions. I believe you just need to change these to the values that we were given:

/* Database configuration. */
define('DATABASE_USER', 'opencats');
define('DATABASE_PASS', 'opencats');
define('DATABASE_HOST', 'localhost');
define('DATABASE_NAME', 'opencats');

I am going to test it next - I have to re-upgrade as I backed out when I could not get past the same issue.

Hope this helps.
Thanks gregg!!
I'm trying to install 9.6, and kept running into the user/password issue. I figured out that it was cats and password, but then it couldn't find the database. In the config.php, it was cats_dev not opencats. I changed the database to opencats, and I got further, with some warnings. I may go back and leave cats_dev and see if that resolves the php warnings.

OpenCats is verry easy to back-up with a simple […]

Hi there. I'm not a software guy but I think it […]

Please suggest alternatives. Run 3

Mass Import of Resumes

Hi Kline, okay so you're getting into some awkwa[…]