Plesk Repair Utility

The Plesk self-repair functionality enables you to automatically diagnose and resolve issues with Plesk and Plesk services. If you encounter an issue with one of the Plesk services (for example, if mail is not being sent or delivered, or a website fails to open, and so on), or with Plesk itself (for example, if error messages are being displayed in the Plesk interface, or if Plesk pages fail to load), you can use the Plesk repair utility to attempt to resolve it. The utility can be used to check and repair individual aspects of Plesk (such as the mail service, or the Plesk database), or all the aspects at once.

More at https://docs.plesk.com/en-US/12.5/administrator-guide/plesk-administration/plesk-repair-utility.74649/

Awstats not updating in Plesk

You are checking your stats and see low traffic:

How to recalculate AWStats statistics from logs for previous months. Follow this link for a plesk article:

https://support.plesk.com/hc/en-us/articles/213901965-How-to-recalculate-AWStats-statistics-from-logs-for-previous-months

Plesk Administration: https://docs.plesk.com/en-US/onyx/advanced-administration-guide-linux/statistics-and-logs/calculating-statistics.68650/

Another issue had to do with a bug in plesk.

Check your Plesk Web Statistics at the bottom of the page:

The most frequent HTTP Status code is “301 – Moved permanently (redirect)” at https://domain.com/plesk-stat/webstat/. It takes 49.5%.

In addition, “Permanent SEO-safe 301 redirect from HTTP to HTTPS” is checked under Domains > domain.com > Hosting Settings > Security section.

In this way the SSL traffic is not shown under Domains > domain.com > Web Statistics.

This issue was caused by a product defect. A bug has been already created: PPPM-548: SSL traffic is not shown in webstat.

More information here:
https://docs.plesk.com/release-notes/onyx/change-log/

To view the statistics:

Access SSL traffic statistics using the link below:
https://domain.com/plesk-stat/webstat-ssl/

Please, see the following article in order to get more information on the issue:
https://support.plesk.com/hc/en-us/articles/213951505

Installing Apps from Plesk Application Vault Hangs

When the WordPress Install button is pressed (including the custom install option) in Application Vault, a progress bar is shown but never changes from 0%.

Log into Plesk.

Click "Tools and Utilities" > "Application Vault" > "My Apps".

Try installing the app. Here, the notification bar shows: Please wait…. 0%. This bar may remain the same for several hours with nothing happening.

Cause

A large number of applications are stuck in the psa.longtasks table. Or MySQL service is down.

Resolution

Backup the psa database by following the instructions in KB #213904125

Make sure that MySQL service is running:

Linux:

# service mysqld status 
# systemctl status mysqld.service 
# systemctl status mariadb

Windows:

> net start MySQL

Check that /dev/null has permissions crw-rw-rw-:
Linux:

 ls -la /dev/null
crw-rw-rw-. 1 root root 1, 3 Jul 19 15:15 /dev/null

Log into MySQL and access the psa database:

Linux:

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin psa

Windows:

"%plesk_dir%"\\MySQL\\bin\\mysql.exe -uadmin -p psa -P8306

Check the long tasks that are present on the server:

mysql> select * from longtasks;

+----+--------------+---------+-------------+-----------------+----------------+----------------+-------------+---------------+---------------------+---------------------+-------+
| id | type         | context | status      | statusProcessed | progressStatus | progressParams | progressMax | progressValue | startTime           | finishTime          | pid   |
+----+--------------+---------+-------------+-----------------+----------------+----------------+-------------+---------------+---------------------+---------------------+-------+
|  1 | aps-download | NULL    | started     |               0 | queue          | NULL           |         100 |             0 | 2017-07-21 13:34:03 | 0000-00-00 00:00:00 |     0 |
|  2 | aps-cache    | NULL    | done        |               0 | done           | NULL           |         100 |           100 | 2017-07-21 13:35:56 | 2017-07-21 13:35:56 | 31908 |
|  3 | aps-cache    | NULL    | done        |               0 | done           | NULL           |         100 |           100 | 2017-07-21 13:36:23 | 2017-07-21 13:36:23 | 31973 |
|  4 | aps-download | NULL    | not_started |               0 | queue          | NULL           |         100 |             0 | 2017-07-21 13:48:42 | 0000-00-00 00:00:00 |     0 |
|  5 | aps-cache    | NULL    | done        |               0 | done           | NULL           |         100 |           100 | 2017-07-21 13:57:51 | 2017-07-21 13:57:51 |  4515 |
+----+--------------+---------+-------------+-----------------+----------------+----------------+-------------+---------------+---------------------+---------------------+-------+

Delete these tasks:

mysql> truncate longtasks;
mysql> truncate longtaskparams;

Make sure /etc/localtime file has 644 permissions:

# ls -la /etc/localtime

If not, set it:


# chmod 644 /etc/localtime

Try installing the application again.

MySQL does not start after an Plesk update (14-March, 2017)

Note: article describes the issue caused by MySQL update from Atomic repository, make sure you have Atomic repository enabled before applying fix:


# yum repolist
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* atomic: www4.atomicorp.com

After update MySQL cannot be started. In Plesk the following error message is shown:


    Error in Plesk:
    ERROR: PleskFatalException
    Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: No such file or directory

    0: common_func.php3:153
    psaerror(string 'Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: No such file or directory')
    1: auth.php3:116

or


    ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory
    Additionally, an exception has occurred while trying to report this error: Zend_Exception
    No entry is registered for key &#039;translate&#039; (Abstract.php:144)
    Search for related Knowledge Base articles
    ERROR: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] No such file or directory' in /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php:129 Stack trace: #0 /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(129): PDO->__construct('mysql:dbname=ps...', 'admin', '$AES-128-CBC$Zm...', Array) #1 /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect() #2 /usr/local/psa/admin/externals/Zend/Db/Adapter/Abstract.php(460): Zend_Db_Adapter_Pdo_Mysql->_connect() #3 /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('select param, v...', Array) #4 /usr/local/psa/admin/plib/Db/Adapter/Pdo/Mysql.php(30): Zend_Db_Adapter_Pdo_Abstract->query('select param, v...', Array) #5 /usr/local/psa/admin/plib/db.php(36): Db_Adapter_Pdo_Mysql->query('select param, v...') #6 /usr/local/psa/admin/plib/db.php(212): db_query('select param, v...', false) #7 /usr/local/psa/admin/plib/Plesk/Mode.php(4 (Abstract.php:144)

There are no records in /var/log/mysqld.log

Cause

Atomic issued broken mysql package to their repositories. During updates installation mysql package gets updated, but required directory /var/lib/mysql-files is not created.

This issue has been fixed by Atomic in 5.5.54-1199 version of mysql-server package. Update the package to the latest version:


# yum update mysql-server

If no packages are marked for update, clean yum cache:


# yum clean all


# yum update mysql-server

Plesk Trial

Plesk trial:

http://page.plesk.com/typ-free-trial-for-web-professionals-thank-you-page?submissionGuid=f9242e8e-ac7a-4aa5-89bb-724d5b89dfc3