Good morning,
I have a problem with my Centreon VM this morning when I arrived I had this error: SQLSTATE[HY000] [2002] No such file or directory.
Installing the VM This is the Appliance provided by centreon 22.04
Good morning,
I have a problem with my Centreon VM this morning when I arrived I had this error: SQLSTATE[HY000] [2002] No such file or directory.
Installing the VM This is the Appliance provided by centreon 22.04
Hi
systemctl status mariadb
[root@srv-centreon ~]# systemctl status mariadb
● mariadb.service - MariaDB 10.5.15 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─centreon.conf, migrated-from-my.cnf-settings.conf
Active: failed (Result: exit-code) since Sun 2023-03-19 00:12:35 CET; 1 day 9h ago
Docs: man:mariadbd(8)
https://mariadb.com/kb/en/library/systemd/
Process: 2922500 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 2922463 ExecStartPre=/bin/sh -c 4 ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; ; $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, sta>
Process: 2922461 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 2922500 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
Warning: Journal has been rotated since unit was started. Log output is incomplete or unavailable.
Can you validate that this file exists: /var/lib/mysql/mysql.sock
ls -lah /var/lib/mysql/mysql.sock
Yes he is present
So I d’ont understand why PHP can’t connect to MariaDB.
Can you try:
systemctl restart php-fpm mariadb
Then refresh the page in the browser
systemctl restart php-fpm mariadb
Job for mariadb.service failed because a fatal signal was delivered to the control process.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
So can you execute:
journalctl -xe
or check errors in /var/log/mysql/*.err
I'm very bad in linux so I don't understand all of them, thank you for your help
The problem is storage
/dev/mapper/almalinux-var_lib_mysql 7.1G 6.9G 183M 98% /var/lib/mysql
But how to resize it?
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.