• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

Search results

  1. Tim_Wakeling

    Resolved ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000] [2002] Connection refused (Mysql.php:79)

    Morning - I am pleased to report I worked out what to do, thanks to your guiding me in the right direction. :D A corrupt table on one of my sites was causing MariaDB to crash every time it was accessed, as you said, and that was every couple of minutes. It restarted immediately of course, but...
  2. Tim_Wakeling

    Resolved ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000] [2002] Connection refused (Mysql.php:79)

    That's really helpful. I've tried this and can't see any tables mentioned in the startup sequence: Nov 10 16:17:02 hosting systemd: Starting MariaDB 10.5.13 database server... Nov 10 16:17:02 hosting mariadbd: 2021-11-10 16:17:02 0 [Note] /usr/sbin/mariadbd (mysqld 10.5.13-MariaDB) starting as...
  3. Tim_Wakeling

    Resolved ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000] [2002] Connection refused (Mysql.php:79)

    Thanks! Interestingly, the SHOW PROCESSLIST; command sometimes does what you expect, and other times gives an error: MariaDB [psa]> SHOW PROCESSLIST; +----+-----------------+-----------+----------------+---------+------+----------+------------------+----------+ | Id | User | Host...
  4. Tim_Wakeling

    Resolved ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000] [2002] Connection refused (Mysql.php:79)

    Ah interesting! Lots of repetitions of: Nov 10 15:09:33 hosting mariadbd: 2021-11-10 15:09:33 0 [Note] /usr/sbin/mariadbd (mysqld 10.5.13-MariaDB) starting as process 11039 ... Nov 10 15:09:33 hosting mariadbd: 2021-11-10 15:09:33 0 [Note] InnoDB: Loading buffer pool(s) from...
  5. Tim_Wakeling

    Resolved ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000] [2002] Connection refused (Mysql.php:79)

    I'm getting this error intermittently on my Plesk panel, and also website users are reporting that the database fails to connect every now and then when viewing web pages hosted on the machine. Refreshing the page in all cases solves it, but a few minutes later it happens again. It seems to...
  6. Tim_Wakeling

    Question Can I run a Plesk Migrator resync automatically via the command line or a scheduled task?

    I am running a second server as a backup, and I would like to automatically keep it up to date with my main server, at reasonable intervals, like perhaps hourly, or several times a day. I have found a wonderful manual way to do this which works beautifully - I ran Plesk Migrator once, it copied...
  7. Tim_Wakeling

    HTTP 414 errors on URLs only 256 characters long

    I'll see what I can do - thank you! :)
  8. Tim_Wakeling

    HTTP 414 errors on URLs only 256 characters long

    I see. In this case that's OK. Often, however, I do need to pass GET variables to pages whose URLs are pretty WordPress permalinks ending in "/", not ".php". I'll have to do some more reading on the subject.
  9. Tim_Wakeling

    HTTP 414 errors on URLs only 256 characters long

    OK, I have solved the problem! Well, sort of. I discovered that if I referenced a specific PHP script file instead of a "pretty URL", it worked. So this fails with a 414...
  10. Tim_Wakeling

    HTTP 414 errors on URLs only 256 characters long

    Thanks; just checked nginx configuration and it was set to client_header_buffer_size 2k; large_client_header_buffers 4 8k; I tried increasing it to client_header_buffer_size 8k; large_client_header_buffers 4 16k; just temporarily and restarted nginx, apache and httpd to see whether it solved...
  11. Tim_Wakeling

    HTTP 414 errors on URLs only 256 characters long

    Thanks for the clarification; I will check the heirarchy but I suspect this is how it is set up. It seems to be. I do wonder whether nginx is overriding things somehow although I was under the impression that Apache was serving the PHP. Do you know how I can check what nginx's status is and...
  12. Tim_Wakeling

    HTTP 414 errors on URLs only 256 characters long

    Thanks for your help ... you had me hopeful there for a moment! However I checked the Web Server Settings in Panel, and the two "LimitRequest" lines mentioned above are definitely present in the "Additional directives for HTTP" and "Additional directives for HTTPS" boxes. They are also present...
  13. Tim_Wakeling

    HTTP 414 errors on URLs only 256 characters long

    By the way, I also have these lines: Alias /error_docs /var/www/vhosts/mydomain.com/error_docs ErrorDocument 414 /error_docs/request_uri_too_long.html And they are being ignored. I am not getting an HTML page as an error; just a white screen and an entry in the log file. If I could only...
  14. Tim_Wakeling

    HTTP 414 errors on URLs only 256 characters long

    Thanks for the thought, but sadly not the answer. The file you mention says this: #ATTENTION! # #DO NOT MODIFY THIS FILE BECAUSE IT WAS GENERATED AUTOMATICALLY, #SO ALL YOUR CHANGES WILL BE LOST THE NEXT TIME THE FILE IS GENERATED. #IF YOU REQUIRE TO APPLY CUSTOM MODIFICATIONS, PERFORM THEM IN...
  15. Tim_Wakeling

    HTTP 414 errors on URLs only 256 characters long

    Hi - any thoughts on this little puzzler? :) My Linux (CentOS) server with Plesk 12 is giving HTTP 414 errors ("URL too long") in response to URLs which are over 256 characters in length. They happen to include a GET variable in the query string which accounts for most of this length, and if I...
Back
Top