problems updating a hosted site which wasn't used for 2 years

Web hosting discussion, programming, and shared and dedicated servers.
8 posts Page 1 of 1
by gacevedobolton » Thu Dec 15, 2022 10:35 am
I hadn't updated my Sonic hosted website for about 2 years. There is notice asking me to update to wordpress 6.1.6. I was able to manually update to 5.1.5, but after that my PHP version is too old to update further. I tried updating PHP by using the .htcaccess file, but the site won't work if I go any higher than PHP 5.5. Any ideas on what I can do?
by keilanisonic » Thu Dec 15, 2022 4:01 pm
I have seen issues with WordPress plug-ins not behaving correctly when things get upgraded; Id double-check your plug-ins to make sure they are compatible with the new PHP 7.4.3 or temporarily deactivate them one by one to rule them out as the issue.
Keilani H
Community & Escalations Specialist
Sonic
by gacevedobolton » Thu Dec 15, 2022 4:11 pm
Found this thread:
viewtopic.php?f=8&t=9245&start=10

I get stuck when I am supposed to add in the password, but it just hangs and then says something about can't connect to mysql from b.custsql.sonic.net

will try using a different ssh client
by gacevedobolton » Thu Dec 15, 2022 5:13 pm
I tried a different client and still having the same error:
ERROR 2003 (HY000): Can't connect to MySQL server on 'b.custsql.sonic.net' (110)

For some background, Here are the steps I took:

deactivated all the plugins
edit .htaccess file to read php56 instead of php55

refresh webpage and get the following message:

"Error establishing a database connection

This either means that the username and password information in your wp-config.php file is incorrect or we can’t contact the database server at b.custsql.sonic.net. This could mean your host’s database server is down.

Are you sure you have the correct username and password?
Are you sure that you have typed the correct hostname?
Are you sure that the database server is running?

If you’re unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress Support Forums."

I tried rehashing my password as suggested in in the link: viewtopic.php?f=8&t=9245&start=10

but get to the step where I am supposed to type:

mysql -u username_oc_1 -h b.custsql.sonic.net -p (but using the username from my wp-config.php file)

I enter the password but it just sits there for awhile before saying:

ERROR 2003 (HY000): Can't connect to MySQL server on 'b.custsql.sonic.net' (110)

I tried starting mysql server using mysql.server start
but says command not found.
by gacevedobolton » Thu Dec 15, 2022 5:26 pm
More info:
trying: service mysql start
redirects to /bin/systemctl start mysql.service
then asks for authentication as root..
by gacevedobolton » Fri Dec 16, 2022 12:11 pm
Today the site crashed on it's own after running okay this morning and me not touching any of the files.

Currently says in big bold font:
"Error establishing a database connection"

Maybe some repair is being done behind the scenes? (wishful thinking!)
by joemuller » Mon Dec 19, 2022 5:55 pm
Hi! I'm the person who was working on the back-end of things and found the fix. There are two issues that you were running into:
1.) Your site was set up long enough ago that it was still using an 'old_password' MySQL password hash (a secure storage method) instead of the newer 'new_password' method. This works fine for older software and servers that can connect to MySQL, but...
2.) Starting with PHP 5.6, the 'old_password' MySQL passwords are no longer allowed. To fix this, I had to update the password on the database so it was in the newer form.

Since you have a login for the Wordpress part of your site, I recommend making sure you are on version 3.7 or newer, as automatic updates started being available on that version. I made sure you are on the latest PHP we have, so that should keep everything supported and working for a while.

-- Joe M
I'm a proud employee of Sonic.net! :-)
by gacevedobolton » Mon Dec 19, 2022 7:37 pm
Thank you very much Joe!
8 posts Page 1 of 1

Who is online

In total there are 17 users online :: 1 registered, 0 hidden and 16 guests (based on users active over the past 5 minutes)
Most users ever online was 999 on Mon May 10, 2021 1:02 am

Users browsing this forum: Bing [Bot] and 16 guests