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 :

 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