Applicable to:
- Plesk for Linux
Symptoms
-
After upgrading MariaDB to 10.6, the service fails to start with:
# service mariadb status
...
mariadbd[32685]: 2022-04-19 6:41:28 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 22: Invalid argument
mariadbd[32685]: 2022-04-19 6:41:28 0 [ERROR] Do you already have another server running on port: 3306 ?
mariadbd[32685]: 2022-04-19 6:41:28 0 [ERROR] Aborting -
Plesk is not accessible:
PLESK_INFO: 500 Plesk\Exception\Database
DB query failed: SQLSTATE[HY000] [2002] No such file or directory
Cause
MariaDB 10.6 does not allow to bind both ::1 and 127.0.0.1 via the setting bind-address = ::ffff:127.0.0.1 in the file /etc/my.cnf.
Resolution
- Connect to the Plesk server via SSH.
-
Open the file in a text editor. In this example, we are using the vi editor:
# vi /etc/my.cnf
-
Change the
bind-addresssetting from:CONFIG_TEXT: bind-address = ::ffff:127.0.0.1
to
CONFIG_TEXT: bind-address = 127.0.0.1
-
Save the changes and close the file.
-
Start the MariaDB service:
# service mariadb restart
Comments
2 comments
Why doesnt the Plesk installer fix this?
Plesk Install fails on below configuration.
Product version: Plesk Obsidian 18.0.44.3
OS version: AlmaLinux 8.6 x86_64
Build date: 2022/06/14 18:00
Revision: 706e0d50fa11eb71b2f8c735856695131f29ef86
because of the ip binding issue in my.cnf
The my.cnf is the default file downloaded from MariaDB-common-10.6.8-1.el8.x86_64
Why is this issue happening?
No changes stille have the error
"DB query failed: SQLSTATE[HY000] [2002] No such file or directory File Mysql.php Line 79"
Please sign in to leave a comment.