Question mariadb service is still in stop mode - SSH blocked by firewall

[MedB]

Hello,

I just had a big problem and can't find a solution.

the mariadb service is still in stop mode on the repair panel. I restarted my server a number of times but without success and I clicked on restart processes and it is still in stop mode.

The problem is, I can't access SSH because the plesk firewall is blocking me all the time.

I can't find any solution. How can I do it please?

Thank you in advance

 

[LTUser]

Question - Reset firewall rules with command line

Hi, I no longer have access to my server because my IP address has changed. I can access to it in rescue mode... How can I reset firewall rules with command line ? Thanks,

talk.plesk.com

 

[Nik G]

hello @MedB ,

if you have access to control panel you can install an extension called 'SSH Terminal'. It allows to access server via SSH right from your browser.
As it connects to the localhost from the server point of view - firewall should not block it.

If all that you have is a server with enabled firewall and stopped DB server (which leads to Plesk Panel malfunction)
then please follow instructions provided by LTUser: you have to boot your server in rescue mode (probably from rescue media)
and modify /usr/local/psa/var/modules/firewall/firewall-active.sh

you can add something like below

/usr/sbin/iptables -F
/usr/sbin/iptables -X
/usr/sbin/iptables -Z
/usr/sbin/iptables -P INPUT ACCEPT
/usr/sbin/iptables -P OUTPUT ACCEPT
/usr/sbin/iptables -P FORWARD ACCEPT
exit 0;

to the beginning and try restart your server.