Database Error

Permalink
I'm not sure where this should go but all of a sudden my website is down saying it's having an issue connecting to the database. I'm not a web guy, if someone could PM me that can fix it, I'll be happy to pay your rate.

Thanks,
Gabe

1 Attachment

tcsllc
 
mesuva replied on at Permalink Reply
mesuva
If you haven't made any changes to your site's config, it's very likely it's a hosting problem.
I'd suggesting you contact your host and ask them to check that their MySQL database is running correctly.
tcsllc replied on at Permalink Reply
tcsllc
Thank you. Is there a way to review the settings and make sure they are correct?

Thanks,
Gabe
mesuva replied on at Permalink Reply
mesuva
Not really, if it connects and your website comes up, they're correct! :-)

A test can often be that if you've got cPanel (or equivalent) access to your hosting, you can try logging into that and viewing the database via phpMyAdmin.. if you can't connect to that either, the database is having issues - then you'd contact the host for them to fix it.
tallacman replied on at Permalink Reply
tallacman
If you need help with this PM me your contact information.
tcsllc replied on at Permalink Reply
tcsllc
Ok so I guess my hosting company upgraded their MySQL on the server.

They said
"... MySQL was recently upgraded on the server hosting your account. As such, the database user's password need to be reset. This is because the previous MySQL used 16 bytes (old, deprecated) password hash, whereas post-upgrade it uses a 41 bytes hash.

How everhttp://tcsolutionsllc.com/ is coming with strict standard error. You will need update your code according to php version.

In order to ensure the upgrade goes smoothly please review your sites for compatibility with PHPs 5.6.x branch.
Incompatibilities between PHPs versions 5.3, 5.4 and 5.5 can be found through the URLs below:
http://php.net/manual/en/migration54.php...
http://php.net/manual/en/migration55.php...
http://php.net/manual/en/migration56.php...
"

I updated my password, same as what I had before, and now getting strict errors. You can see them athttp://www.tcsolutionsllc.com

Thanks,
Gabe
mesuva replied on at Permalink Reply
mesuva
Although the longer term solution would be to try to update your site to concrete5.6, you can at least hide the errors for now with some very minor tweaks to files. See:

http://legacy-documentation.concrete5.org/tutorials/how-fix-strict-...

It's really just the case of following that guide carefully. It's the addition of one line of code to two files.
tcsllc replied on at Permalink Reply
tcsllc
I did this exact thing and now nothing shows up at all. Just a blank page.
mesuva replied on at Permalink Reply
mesuva
Double check the changes you've made - a white screen like is probably due to a typo.
I followed this the other day to fix a concrete5.4 and it worked correctly.
tcsllc replied on at Permalink Reply 1 Attachment
tcsllc
My file had all this extra stuff in it. Is this normal? I copied and pasted the text and I checked it, didn't see anything extra.
mesuva replied on at Permalink Reply
mesuva
No, that's certainly not normal. Normally the top level index.php file just has one line of PHP in it.

Unfortunately this looks like you're website files have been compromised at some point, that's the kind of code that is added to files as part of a hack.

Often such hacks will just target common file names such as index.php, so you may be lucky and find that it's just this one file. But you'll want to check other files on your site to see if they've been modified as well, and restore them from a known good source.

You could for example download a fresh copy of the concrete5 version that matches you current install. You'd then replace the index.php file and the entire /concrete directory. You'd also want to check the packages directory, and any themes, in case those have been compromised as well. Make sure you take a good backup of your site incase you make a mistake with this process.

Concrete5 has a very good track record for security, so I'd wager that this hack isn't due to concrete5, but something else on your webserver/webspace. You may need to review what else you have installed (like older Wordpress sites, Joomla, random scripts, etc), and make sure they aren't still vulnerable - otherwise such a hack may keep occurring.