I’ve successfully upgraded my centreon platform on debian from 23.04 to 23.10
Some time after i received an alert about Broker-Stats was CRITICAL.
I investigated and i saw this error in /var/log/centreon-broker/central-rrd-master.log :
[core] [error] failover: global error: RRD: could not create file '/var/lib/centreon/metrics//tmpl_1703678193_15552000_300_0.rrd:
Cannot create temporary file
I changed /var/lib/centreon/metrics folder’s permissions and restarted cbd : now i can see how rrd files are generated under /var/lib/centreon/metrics but owned by centreon-broker instead of centreon :
BEFORE UPGRADE :
-rwxrwxr-x 1 centreon centreon 450088 Dec 27 11:34 728.rrd
-rwxrwxr-x 1 centreon centreon 450088 Dec 27 11:34 727.rrd
-rwxrwxr-x 1 centreon centreon 450088 Dec 27 11:34 726.rrd
-rwxrwxr-x 1 centreon centreon 450088 Dec 27 11:34 725.rrd
AFTER UPGRADING AND CHANGING FOLDER’S PERMISSIONS :
-rw-r--r-- 1 centreon-broker centreon-broker 450088 Dec 28 09:46 tmpl_1703678193_15552000_300_0.rrd
-rw-rw-r-- 1 centreon-broker centreon-broker 450088 Dec 28 09:46 34810.rrd
-rw-rw-r-- 1 centreon-broker centreon-broker 450088 Dec 28 09:46 34817.rrd
-rw-rw-r-- 1 centreon-broker centreon-broker 450088 Dec 28 09:46 34816.rrd
But graphs are not showing new data :
I investigated more, and i could find any errors neither in centreon, centreon-engine and centreon-broker logs.
The only error i found was in gorgoned.log :
2023-12-28 10:12:10 - ERROR - MySQL error : cannot connect to database 'mysql:host=localhost:3306;dbname=centreon': Can't connect to local MySQL server through s
ocket '/run/mysqld/mysqld.sock' (2) (caller: gorgone::class::db:/usr/share/perl5/gorgone/class/db.pm:339) (try: 0)
I checked manually, and centreon-gorgone user could connect into mysql using
mysql -u centreon -h localhost -p
