Category: Plesk

Installing Apps from Plesk Application Vault Hangs

July 21, 2017 The Geek Decoder No Comments Plesk

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)

March 15, 2017 The Geek Decoder No Comments Plesk

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