I upgraded my forum from 2.1.1 to 2.1.4.
I upgraded trough upgrade.php which finished without errors, but after that the database connection failed.
I have the repair tool and it says.
QuoteSome settings are not being shown because the database connection information is incorrect.
Check your database login details, table prefix and that the database actually contains your SMF tables.
But every setting is right,
The settings in Settings.php are right.
Access rights of Settings.php are right.
User and group of all files are right.
I can login with mysql -u myuser -p on the server.
I have logging in mysqld on. The only message is:
Quote550 Connect myuser@localhost on using Socket
550 Connect Access denied for user 'myuser'@'localhost' (using password: YES)
Username is right.
I have no idea what's going on.
If you have a backup of 2.1.1, compare database settings in Settings.php with Settings.php in 2.1.4 install. It's not necessary to run upgrade.php to upgrade 2.1 versions, you can do it in package manager to patch from 2.1.1 > 2.1.2 > 2.1.3 > 2.1.4.
I had to copy over the patches manually to do the update, my server is blocked by simplemachines.org.
I have installed a new forum in a sub directory with the mysql data from the old forum and it worked without a problem.
But the old forum still says no connection even in the repair tool.
I have copied all files from the new install over the old install excluding Settings.php still the same error.
So, based on that result, it would seem that your settings are incorrect, regardless of what you THINK they should be....
Quote from: Kindred on March 10, 2024, 08:17:19 AMSo, based on that result, it would seem that your settings are incorrect, regardless of what you THINK they should be....
I made a typo, I meant including not excluding. So the Settings.php is the same file in both directories!
Nevertheless, the repair tool also says that the connection could not be established. The repair tool shows the same password in both directories. All files are exactly the same.
Is there a way to log the connection data including the password that is used?
If the settings are the same, but the directories, paths, and URLs are different then its not going to work either....
But my suggestion is check with your host
I have now restarted php fpm and the error has disappeared. Nothing has been changed in the files.
The you are all set
Quote from: aceone on March 10, 2024, 09:40:50 AMI have now restarted php fpm and the error has disappeared. Nothing has been changed in the files.
I take it that the issue has been solved then. In that case I am marking this as solved. If I read this incorrectly please feel free to unmark it as solved.
Quote from: Doug Heffernan on March 13, 2024, 08:12:12 AMI take it that the issue has been solved then. In that case I am marking this as solved. If I read this incorrectly please feel free to unmark it as solved.
Yes, thank you.
I still don't have an explanation for what really happened. I just restarted PHP FPM and suddenly everything worked again. I didn't change anything else.
Hopefully something weird won't happen again.
Quote from: aceone on March 13, 2024, 08:22:52 AMI still don't have an explanation for what really happened. I just restarted PHP FPM and suddenly everything worked again. I didn't change anything else.
Maybe it was a glitch. If that won't happen again you have nothing to worry about.
Call the glitch extermination team at 1-888-NOGLITCH ... :P
Depending on config it's possible that PHP-FPM was keeping old versions of files in memory and restarting it forced it to properly reload new files.