Issue After ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] Now 502 Bad Gateway error

[ismail el moussati]

Hi all, as you may know this morning it was horrible for the previous mysql update.

After i had the error of
Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002]
I followed these lines:

yum remove -y mysql
yum clean all
rpmdb --rebuilddb
yum update -y
wget -q -O - http://www.atomicorp.com/installers/atomic | sh
yum install -y mysql


nano -w /etc/my.cnf
skip-grant-tables

But didn't work, but i guess made my server more horrible, Thereafter, i used those lines:
Because i didn't find any one posting the official link for that issue from Plesk:
Please read: https://support.plesk.com/hc/en-us/articles/115001906725
I just run their command and everything is fine again:
install -m 0700 -o mysql -g mysql -d /var/lib/mysql-files

Now i have 502 Bad Gateway, nginx .

Shown in my Plesk admin link, and my websites : 500 Internal Server Error.

Any idea ?

Yours,

 

[ismail el moussati]

This is outline of yum check
[root@vps274104 ~]# yum check
Loaded plugins: presto
plesk-config-troubleshooter-17.0.17-cos6.build1700161028.14.x86_64 has missing r equires of plesk-core >= ('0', '17.0.17', None)
plesk-config-troubleshooter-17.0.17-cos6.build1700161028.14.x86_64 has missing r equires of plesk-mysql-server >= ('0', '17.0.17', None)
psa-firewall-17.0.17-cos6.build1700161028.14.x86_64 has missing requires of ples k-core >= ('0', '17.0.17', None)
psa-firewall-17.0.17-cos6.build1700161028.14.x86_64 has missing requires of ples k-mysql-server >= ('0', '17.0.17', None)
psa-firewall-17.0.17-cos6.build1700161028.14.x86_64 has missing requires of /usr /local/psa/bin/sw-engine-pleskrun
Error: check all

 

[UFHH01]

Hi ismail el moussati,

I strongly recommend to open a ticket at the Plesk Support ( Pls. see: https://support.plesk.com/hc/en-us/articles/213953025 or/and https://support.plesk.com/hc/en-us/articles/213608509 ) , due to the fact that I have the feeling, that you are overwhelmed with the server administration tasks ( update/upgrade to a current supported MySQL version, restore psa/mysql backup, solve package dependencies on your server, correct and re-install missing Plesk packages on your server, correct vhosts configurations on your server, ... ).

Pls. don't get my suggestion wrong, but there are several tasks which you should solve step-by-step and your provided informations indicate, that your current knowledge to administrate your server, is not sufficient to solve your current misconfigurations. The Plesk Support will be happy to assist here.