FATAL: Connection to Cacti database failed

Hi,
After reinstalling mysql-server because it was magically gone, trying to access our cacti site fails ... can't connect to database.

Can connect to mysql as user cacti with its password listed in /usr/local/share/cacti/include/config.php

Code:
# mysql -u cacti -p cacti
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 118
Server version: 8.0.33 Source distribution

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

cacti@localhost [cacti]>

php modules seem to be OK

Code:
# php -m
[PHP Modules]
Core
ctype
date
filter
gd
gettext
gmp
hash
intl
json
ldap
libxml
mbstring
mysqli
mysqlnd
openssl
pcntl
pcre
PDO
pdo_mysql
posix
Reflection
session
SimpleXML
snmp
sockets
SPL
standard
xml
zlib

[Zend Modules]

Don't see anything in logs that give me any clue.

TIA for any help with this.
 
Is cacti running on the same machine? Or from some other host? Your MySQL might not be listening on a network port?
 
Back
Top