can not access cacti

[minhnh]

FATAL: Connection to Cacti database failed. Please ensure the database is running and your credentials in config.php are valid.

[phalek]

Well, did you check this ?

Code: Select all

Please ensure the database is running and your credentials in config.php are valid.

[netniV]

As phalek said, check as mentioned that the configuration file exists and has valid credentials.

If you can see everything looks OK there, check that you can connect using the command line to the database.

For example, using mysql this would be something like:
mysql -u <mysql_user> -p <mysql_database>

This will then prompt you for the password. Once entered, you should end up with a mysql> prompt.

Assuming that works, try issuing a command such as SHOW TABLES;

[minhnh]

Thank you everyone,
I can access database

I am newbie
Please help me

Can you give to mysql parameter config?

Thank you very much

[amazen123]

Thank you everyone,
I can access database

I am newbie
Please help me

Can you give to mysql parameter config?

Thank you very much

You can see the recommended parameters during installation of cacti.
So you need to add or change it in my.cnf.

[netniV]

If you know the credentials for your cacti database, not the superuser/root pasword, these can be entered into config.php. However, you should also make sure that you have PHP's PDO libraries installed because MySQL connectivity changed to use the PDO system in version 1.x.

On ubuntu/debian, you would do this by install php-pdo, then you may have the enable it

Code: Select all

apt install php-pdo
phpenmod pdo

If phpenmod gives an error, try php5enmod as I think older versions of php used that.

[paulgevers]

On ubuntu/debian, you would do this by install php-pdo, then you may have the enable it

Code: Select all

apt install php-pdo
phpenmod pdo

Interesting, I can't find the package¹. I think you get it by installing php-mysql (which is a dependency of the Cacti package in Debian).

¹ https://packages.debian.org/search?keywords=php-dpo

[netniV]

Sorry, you would be correct. I was away from a ubuntu machine at the time. I just tried to install use that above command and it's actually a virtual package supplied when you install PHP itself. So it may just be that they need to enable the PDO mod as it should already be installed.

Code: Select all

Package php-pdo is a virtual package provided by:
  php7.0-common 7.0.22-0ubuntu0.17.04.1
  php7.1-common 7.1.11-0ubuntu0.17.10.1
You should explicitly select one to install.

I believe that 7.0 is the zesty (17.04) version and 7.1 is the artful version. I still swear my ubuntu's upgrade went screwy as I wouldn't expect to see both! Not sure if the same applies to Debian as I don't have a machine with that installed. I'll defer to your expertise on that one

[minhnh]

Thank you every one
i solved that