Issue Database connection fails for no reason

[andreios]

Server operating system version

Ubuntu 22.04.4 LTS (Jammy Jellyfish)

Plesk version and microupdate number

18.0.59 #2

I have a forum which suddenly can no longer connect to mysql.
The only thing done was an upgrade which finished succesfully with the database upgrade directly after that the connection was lost.
But all the file permissions look right. File owner and group is correct. The mysql settings in the forum config is right.
I have enabled mysql logging and the only message is.

[Warning] Access denied for user 'user'@'localhost' (using password: YES)

But I can connect with the username and password from the config file with mysql -u user -p

 

[Dave W]

what are the contents of/etc/mysql/my.cnf

ensure that

bind-address = *

 

[andreios]

I have set bind-address = * still no connection.

 

[Dave W]

what do you get back if you go

mysql -u user -p -h localhost

 

[andreios]

what do you get back if you go

mysql -u user -p -h localhost

I have tried

mysql -u user -p -h localhost database

even as the user. I copied the data directly from Settings.php. No problem on cli, but the forum still doesn't connect.

 

[andreios]

According to the log the forum tries to connect trough the socket.

823 Connect user@localhost on using Socket
823 Connect Access denied for user 'user'@'localhost' (using password: YES)

 

[andreios]

I have reinstalled the forum in a sub directory, there everything works with the same mysql data but different table prefix.

I then made a backup of everything and copied the forum from the sub directory to the root directory. The same files are now in both the sub directory and the root directory. The forum is simple machines forum and they have a repair tool that I use.

In the root directory no connection, in the sub directory it works.

 

[andreios]

Error message is still the same.

[Warning] Access denied for user 'user'@'localhost' (using password: YES)

 

[andreios]

I have now restarted php fpm and the error has disappeared. Nothing has been changed in the files.

 

[andreios]

This is resolved downgrade to PHP 8.1.

 

[andreios]

Related

Resolved - PHP FPM 8.2.17 is not accurately checking cached files for changes

Username: TITLE PHP FPM 8.2.17 is not accurately checking cached files for changes PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE Plesk Obsidian, 18.0.59 Update #2, Ubuntu 22.04.4 LTS Linux 5.15.0-97-generic #107 x86_64 PROBLEM DESCRIPTION PHP 8.2.17 is not checking files of changes...

talk.plesk.com