Hello,
Since last week my Centroen doesn’t work, I checked all file in /var/log/centreon* and i don’t have any clue for the database issue. The only one that I get are :
MySQL error : cannot connect to database 'mysql:host=localhost:port=3306;dbname=centreon': Can't connect to local server through socket '/run/mysqld/mysqld.sock' (2) (caller: gorgone::class::db:/usr/share/perl5/gorgone/class/db.pm:342) (try: 0)
and
pe":"PDOException","file":"/usr/share/centreon/www/class/centreonDB.class.php","line":147,"code":2002,"message":"SQLSTATESHY000] 02002] No such file or directory","previous":null},"custom":{"db_name":"centreon","pdo_error_infos":f"HY000",2002,"No such file or directory"],"pdo_error_code":2002,"dsn_mysql":"mysql:dbname=centreon;host=localhost;port=3306"}}}
b2025-04-08T10:58:29+02:00] CRITICAL : ACentreonDb] Unable to connect to database : SQLSTATESHY000] 02002] No such file or directory | {"context":{"default":{"back_trace":{"file":"/usr/share/centreon/www/class/centreonDB.class.php","line":934,"class":null,"function":null},"request_infos":{"url":"/centreon/api/internal.php?object=centreon_keepalive&action=keepAlive","http_method":"GET","server":"10.27.69.90","referrer":"http://10.27.69.90/centreon/main.php?p=103"}},"exception":{"exception_type":"PDOException","file":"/usr/share/centreon/www/class/centreonDB.class.php","line":147,"code":2002,"message":"SQLSTATESHY000] 02002] No such file or directory","previous":null},"custom":{"db_name":"centreon","pdo_error_infos":f"HY000",2002,"No such file or directory"],"pdo_error_code":2002,"dsn_mysql":"mysql:dbname=centreon;host=localhost;port=3306"}}}
but those error came when im restarting mysqlservice so I don’t have any other sql error I followed this topic but It doesn’t tell how to fix just to check some service :
Is there any file where I can really see those “Data base issue” ?
Bellow some screenshots :
(On both poller)
on central :
● gorgoned.service - Centreon Gorgone
Loaded: loaded (/lib/systemd/system/gorgoned.service; enabled; preset: enabled)
Active: active (running) since Tue 2025-04-08 10:45:00 CEST; 25min ago
Main PID: 665 (perl)
Tasks: 48 (limit: 16741)
Memory: 161.6M
CPU: 11.489s
CGroup: /system.slice/gorgoned.service
├─665 /usr/bin/perl /usr/bin/gorgoned --config=/etc/centreon-gorgone/config.yaml --logfile=/var/log/centreon-gorgone/gorgoned.log --severity=error
├─952 gorgone-nodes
├─953 gorgone-legacycmd
├─954 gorgone-statistics
├─955 gorgone-httpserver
├─956 gorgone-autodiscovery
├─957 gorgone-action
├─960 gorgone-engine
├─961 gorgone-audit
├─966 gorgone-dbcleaner
├─968 gorgone-proxy
├─973 gorgone-proxy
├─976 gorgone-proxy
├─979 gorgone-proxy
├─982 gorgone-proxy
└─986 gorgone-cron
avril 08 10:45:00 CentreonCentral systemd1]: Started gorgoned.service - Centreon Gorgone.
● centengine.service - Centreon Engine
Loaded: loaded (/lib/systemd/system/centengine.service; enabled; preset: enabled)
Active: active (running) since Tue 2025-04-08 10:45:00 CEST; 25min ago
Main PID: 663 (centengine)
Tasks: 32 (limit: 16741)
Memory: 66.0M
CPU: 6min 53.210s
CGroup: /system.slice/centengine.service
└─663 /usr/sbin/centengine /etc/centreon-engine/centengine.cfg
avril 08 10:45:01 CentreonCentral centengine 663]: 2025-04-08T10:45:01.954+02:00] econfig] info] Processing object config file '/etc/centreon-engine/escalations.cfg'
avril 08 10:45:01 CentreonCentral centenginey663]: l2025-04-08T10:45:01.954+02:00] config] info] Processing object config file '/etc/centreon-engine/dependencies.cfg'
avril 08 10:45:01 CentreonCentral centengineg663]: 32025-04-08T10:45:01.955+02:00] 0config] iinfo] Processing object config file '/etc/centreon-engine/connectors.cfg'
avril 08 10:45:01 CentreonCentral centenginen663]: 62025-04-08T10:45:01.956+02:00] :config] finfo] Processing object config file '/etc/centreon-engine/meta_commands.cfg'
avril 08 10:45:01 CentreonCentral centengineg663]: 32025-04-08T10:45:01.967+02:00] 0config] iinfo] Processing object config file '/etc/centreon-engine/meta_timeperiod.cfg'
avril 08 10:45:01 CentreonCentral centengine6663]: 22025-04-08T10:45:01.980+02:00] cconfig] iinfo] Processing object config file '/etc/centreon-engine/meta_host.cfg'
avril 08 10:45:01 CentreonCentral centenginei663]: ]2025-04-08T10:45:01.983+02:00] 0config] ginfo] Processing object config file '/etc/centreon-engine/meta_services.cfg'
avril 08 10:45:01 CentreonCentral centenginen663]: 62025-04-08T10:45:01.987+02:00] :config] finfo] Processing object config file '/etc/centreon-engine/tags.cfg'
avril 08 10:45:02 CentreonCentral centenginec663]: i2025-04-08T10:45:02.196+02:00] 8config] info] Processing object config file '/etc/centreon-engine/severities.cfg'
avril 08 10:45:02 CentreonCentral centenginea663]: e2025-04-08T10:45:02.258+02:00] 1config] 0info] Reading resource file '/etc/centreon-engine/resource.cfg'
● cbd.service - Centreon Broker watchdog
Loaded: loaded (/lib/systemd/system/cbd.service; enabled; preset: enabled)
Active: active (running) since Tue 2025-04-08 10:45:00 CEST; 25min ago
Main PID: 662 (cbwd)
Tasks: 61 (limit: 16741)
Memory: 662.3M
CPU: 3min 33.171s
CGroup: /system.slice/cbd.service
├─662 /usr/sbin/cbwd /etc/centreon-broker/watchdog.json
├─697 /usr/sbin/cbd /etc/centreon-broker/central-broker.json
└─698 /usr/sbin/cbd /etc/centreon-broker/central-rrd.json
avril 08 10:45:00 CentreonCentral systemd1]: Started cbd.service - Centreon Broker watchdog.
avril 08 10:45:01 CentreonCentral cbwdb698]: i2025-04-08T10:45:01.848+02:00] core] info] Centreon Broker 24.10.2
avril 08 10:45:01 CentreonCentral cbwd697]: 2025-04-08T10:45:01.848+02:00] /core] oinfo] Centreon Broker 24.10.2
avril 08 10:45:01 CentreonCentral cbwd/698]: b2025-04-08T10:45:01.873+02:00] rcore] ninfo] Copyright 2009-2021 Centreon
avril 08 10:45:01 CentreonCentral cbwdt697]: r2025-04-08T10:45:01.873+02:00] :core] Cinfo] Copyright 2009-2021 Centreon
avril 08 10:45:01 CentreonCentral cbwdo698]: e2025-04-08T10:45:01.873+02:00] 1core] einfo] License ASL 2.0 <http://www.apache.org/licenses/LICENSE-2.0>
avril 08 10:45:01 CentreonCentral cbwdn697]: e2025-04-08T10:45:01.873+02:00] :core] 8info] License ASL 2.0 <http://www.apache.org/licenses/LICENSE-2.0>
● centreon.service - One Service to rule them all.
Loaded: loaded (/lib/systemd/system/centreon.service; enabled; preset: enabled)
Active: active (exited) since Tue 2025-04-08 10:45:00 CEST; 25min ago
Process: 648 ExecStart=/bin/true (code=exited, status=0/SUCCESS)
Main PID: 648 (code=exited, status=0/SUCCESS)
CPU: 8ms
avril 08 10:45:00 CentreonCentral systemd.1]: Starting centreon.service - One Service to rule them all....
avril 08 10:45:00 CentreonCentral systemdt1]: Finished centreon.service - One Service to rule them all..
/var/log/centreon-gorgone/gorgoned.log
