FATAL: Connection to Cacti database failed

[FriFra]

Code: Select all

FATAL: Connection to Cacti database failed. Please ensure:

the PHP MySQL module is installed and enabled.
the database is running.
the credentials in config.php are valid.

My mysql server is running on another host, but i was able to successfully create a connection to port 3306 using telnet from the exact same machine.

What can i check?

I searched this forum and found a lot of equal error messages, but none whicht helped me to solve the issue.

[TheWitness]

From the web server, attempt to login to the MariaDB/MySQL database directly.

Code: Select all

mysql -ucactiuser -pcactiuser -hmy-database-host -A cacti

Once you can do that, you should be able to use Cacti. Some installs of MariaDB/MySQL disable logins over anything but the local socket or localhost. Not certain that's the issue. If the login fails, you should get a message like:

User 'cactiuser@somehost' is not authorized...

So, from the database server, you do the following:

Code: Select all

GRANT ALL ON cacti.* to 'cactiuser'@'somehost' identified by 'cactiuser';
GRANT SELECT on mysql.time_zone_name to 'cactiuser'@'somehost';

That'll normally do it properly. If not, then check that networking is enabled on the database settings. These are the offending settings on the database to look out for.

Code: Select all

#skip-networking=0
#skip-bind-address

[FriFra]

Thank you. I had a typo in the password.