Issue Server Error - 500 Plesk\Exception\Database

[seanfod]

Server operating system version

CentOS 7

Plesk version and microupdate number

18.0.60

Hi all

I am getting the following error when trying to log in to my Plesk control panel:

Server Error
500 Plesk\Exception\Database
DB query failed: SQLSTATE[HY000] [2002] Connection refused

Type Plesk\Exception\Database
Message DB query failed: SQLSTATE[HY000] [2002] Connection refused
File Mysql.php
Line 79

Any help would be greatly appreciated, as customers are messaging me left, right and centre because all websites are down!

Thanks in advance.

Quote Reply

 

[Kaspar@Plesk]

Have at the the Plesk Knowledge base for possible causes for this particular error.

I you need assistance don't hesitate tp contact Plesk support for help. To sign-in to support please go to https://support.plesk.com

If you experience login issues, please see this KB article:
https://support.plesk.com/hc/en-us/...rt-plesk-com-and-password-reset-does-not-work

If you bought your license from a reseller, your reseller should provide support for you. If the reseller does not provide support, here is an alternative:
https://support.plesk.com/hc/en-us/articles/12388090147095-How-to-get-support-directly-from-Plesk

 

[The 8th]

Have at the the Plesk Knowledge base for possible causes for this particular error.

I you need assistance don't hesitate tp contact Plesk support for help. To sign-in to support please go to https://support.plesk.com

If you experience login issues, please see this KB article:
https://support.plesk.com/hc/en-us/...rt-plesk-com-and-password-reset-does-not-work

If you bought your license from a reseller, your reseller should provide support for you. If the reseller does not provide support, here is an alternative:
https://support.plesk.com/hc/en-us/articles/12388090147095-How-to-get-support-directly-from-Plesk

Why the solution will be only by contacting Plesk support, I have the same issue

 

[Maarten]

Kaspar mentioned another solution first:

https://support.plesk.com/hc/en-us/search?utf8=%E2%9C%93&query=SQLSTATE%5BHY000%5D+%5B2002%5D+Connection+refused

If that doesn't work, you can always contact Plesk support.

Can you open a new thread mentioning your OS and Plesk version if you still need help?

 

[The 8th]

Kaspar mentioned another solution first:

https://support.plesk.com/hc/en-us/search?utf8=%E2%9C%93&query=SQLSTATE%5BHY000%5D+%5B2002%5D+Connection+refused

If that doesn't work, you can always contact Plesk support.

Can you open a new thread mentioning your OS and Plesk version if you still need help?

I checked this KP :
https://support.plesk.com/hc/en-us/...tabase-SQLSTATE-HY000-2002-Connection-refused

but as per the screenshot attached, you can see there is no output from those commands.

 

[Maarten]

This is a common issue with numerous potential solutions—there are, in fact, 199 results for "SQLSTATE[HY000] [2002] Connection refused".
This makes it difficult to provide specific guidance through the forum without access to your server.

Therefore, I recommend contacting Plesk Support so they can investigate the issue directly and help you find the most appropriate solution.

 

[The 8th]

This is a common issue with numerous potential solutions—there are, in fact, 199 results for "SQLSTATE[HY000] [2002] Connection refused".
This makes it difficult to provide specific guidance through the forum without access to your server.

Therefore, I recommend contacting Plesk Support so they can investigate the issue directly and help you find the most appropriate solution.

I subscribed with Plesk support as you suggested, I received the below reply from Plesk support.



and this is the list process

 

[Maarten]

The Process List extension in Plesk looks nice, but it’s not the most useful tool for getting detailed insights.

I recommend installing btop via the command line instead. It provides a much more comprehensive view of your server's resources and performance. You can check it out here:

GitHub - aristocratos/btop: A monitor of resources

A monitor of resources. Contribute to aristocratos/btop development by creating an account on GitHub.

github.com

 

[The 8th]

The Process List extension in Plesk looks nice, but it’s not the most useful tool for getting detailed insights.

I recommend installing btop via the command line instead. It provides a much more comprehensive view of your server's resources and performance. You can check it out here:

GitHub - aristocratos/btop: A monitor of resources

A monitor of resources. Contribute to aristocratos/btop development by creating an account on GitHub.

github.com

how to find the command line for installation

 

[Maarten]

It's available in most repositories. For Debian (which I believe you're using), it should be:

# apt install btop

 

[The 8th]

It's available in most repositories. For Debian (which I believe you're using), it should be:

# apt install btop

thank you, is can it be monitored under processing list or somewhere else

 

[Maarten]

Your server has a memory issue, so you should monitor that. Read the docs on GitHub to try to understand how this tool works. For example, if you double-click on MariaDB in the process list, it opens a section that shows details like used memory, etc.

Another tool to understand how the memory is used on a server is:

GitHub - pixelb/ps_mem: A utility to accurately report the in core memory usage for a program

A utility to accurately report the in core memory usage for a program - pixelb/ps_mem

github.com

That tool also comes as a package for most Linux distros.

# apt install ps_mem

 

[The 8th]

Your server has a memory issue, so you should monitor that. Read the docs on GitHub to try to understand how this tool works. For example, if you double-click on MariaDB in the process list, it opens a section that shows details like used memory, etc.

Another tool to understand how the memory is used on a server is:

GitHub - pixelb/ps_mem: A utility to accurately report the in core memory usage for a program

A utility to accurately report the in core memory usage for a program - pixelb/ps_mem

github.com

That tool also comes as a package for most Linux distros.

# apt install ps_mem

i got this output is it normal