Resolved Server Error 500 Plesk\Exception\Database

[mrcx]

Server operating system version

Ubuntu 22.04.3 LTS

Plesk version and microupdate number

Plesk Obsidian 18.0.56.0

I am currently unable to access Plesk. I attempted the solution mentioned here https://support.plesk.com/hc/en-us/articles/12376924598935 , but unfortunately, it did not resolve my issue.

Server Error
500 Plesk\Exception\Database

DB query failed: SQLSTATE[HY000] [2002] No such file or directory
Type Plesk\Exception\Database
Message DB query failed: SQLSTATE[HY000] [2002] No such file or directory
File Mysql.php
Line 79



========
the log from : systemctl status mariadb.service

root@XXXXXXX:~# service mariadb restart
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xeu mariadb.service" for details.
root@XXXXXXX:~# systemctl status mariadb.service
× mariadb.service - MariaDB 10.6.12 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Fri 2023-10-13 19:06:49 UTC; 3s ago
Docs: man:mariadbd(8)
systemd
Process: 6264 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCE>
Process: 6265 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCC>
Process: 6267 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/>
Process: 6276 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, st>
Main PID: 6276 (code=exited, status=1/FAILURE)
CPU: 65ms

Oct 13 19:06:49 XXXXXXX systemd[1]: Starting MariaDB 10.6.12 database server...
Oct 13 19:06:49 XXXXXXX sh[6272]: error: Found option without preceding group in config file: /etc/my.cnf at line: 1
Oct 13 19:06:49 XXXXXXX sh[6272]: Fatal error in defaults handling. Program aborted
Oct 13 19:06:49 XXXXXXX mariadbd[6276]: error: Found option without preceding group in config file: /etc/my.cnf at li>
Oct 13 19:06:49 XXXXXXX mariadbd[6276]: Fatal error in defaults handling. Program aborted
Oct 13 19:06:49 XXXXXXX systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Oct 13 19:06:49 XXXXXXX systemd[1]: mariadb.service: Failed with result 'exit-code'.
Oct 13 19:06:49 XXXXXXX systemd[1]: Failed to start MariaDB 10.6.12 database server.

 

[Kaspar]

This line explains what causing the issue:

Oct 13 19:06:49 XXXXXXX sh[6272]: error: Found option without preceding group in config file: /etc/my.cnf at line: 1

There is an topic on Stackoverflow that might helps you to solve it:

MySQL my.cnf file - Found option without preceding group

I'm trying to connect to my DB in Ubuntu remotely but I receive error message when trying to mysql -u root -p: Found option without preceding group in config file: /etc/mysql/my.cnf at line: 1 ...

stackoverflow.com

 

[mrcx]

Hey Kaspar, I did try that thing, but unfortunately, it didn't fix my problem. I ended up reinstalling the droplet again with a fresh install."