FATAL: Connection to Cacti database failed

[Natarajan]

After i installed cacti on my centos 7 machine im not getting cacti webpage.

Error i got listed as follows,

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.

referred documents : https://www.tecmint.com/install-cacti-n ... os-fedora/

checked configs bit by bit and searched about this errors on google also didnt help.

I resetted my machine and installed cacti still im getting same errors please help me out.

[Natarajan]

No replies from cacti team till now.

Mysql is running .
config.php is configured perfectly.
php mysql modules is installed and enabled.

but still im getting this error.

Verified cacti docs and other bloggers docs nothing helped me to resolve this issue.!!

[tertius]

Firewall open?
Mysql server actually running?
Configured mysql server to use tcp/ip socket and not unix socket only?
Created mysql user that is allowed to connect from the cacti machine?
Allowed the httpd daemon to create tcp/ip connections with selinux? (setsebool)

[bmfmancini]

What version of PHP ?
What version of Cacti ?

What is the status of SELINUX ?

Try this simeple php script to see if php can connect to the db

Code: Select all

 <?php
$servername = "localhost";
$username = "username";
$password = "password";

// Create connection
$conn = new mysqli($servername, $username, $password);

// Check connection
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
?>

[Achea9]

Hi,

try to change the "localhost" to 127.0.0.1 in cacti and check.
If that doesn't help remove MARIADB, make sure you use from a proper Repository for MARIADB and reinstall, make sure to mysql_secure_installation to set root password and create cacti under mysql and go ahead with installation process. Good Luck:-)

[Natarajan]

everything is perfect, but still im not getting cacti webpage.

finally uninstalled cacti db and installed PRTG.