Article ID: 117956, created on Oct 15, 2013, last review on Aug 12, 2014

  • Applies to:
  • Plesk Automation 11.1

Symptoms

  1. Go to Parallels Plesk Automation (PPA) Provider Panel > System > Task Manager. The task "Create blank subscription" failed with error:

    Connection problem: Please check the PPA system log /usr/local/ppa/log/plesk.log for details.
    
  2. There is an error in /usr/local/ppa/log/plesk.log:

    file: /usr/local/psa/admin/plib/Smb/Exception/Syntax.php
    line: 56
    code: 0
    trace: #0 /usr/local/psa/admin/plib/Hosting/Options/Availability.php(86): Smb_Exception_Syntax::handleError(2, 'Invalid argumen...', '/usr/local/psa/...', 86, Array)
    #1 /usr/local/psa/admin/plib/BsDomain.php(312): Hosting_Options_Availability->getAvailableShells()
    
  3. There are unreadable characters in MySQL database on the Parallels Plesk Automation (PPA) Management node (shown here as "???????"):

    mysql> select * from ServiceNodeEnvironment where serviceNodeId = '1' and section = 'os'\G
    *************************** 1. row ***************************
    serviceNodeId: 1
          section: os
             name: availableShells
            value: a:8:{s:10:"/bin/false";a:3:{s:4:"name";s:21:"??? ???????";s:5:"empty";b:1;s:8:"chrooted";b:0;}s:7:"/bin/sh";a:3:{s:4:"name";s:7:"/bin/sh";s:5:"empty";b:0;s:8:"chrooted";b:0;}s:9:"/bin/bash";a:3:{s:4:"name";s:9:"/bin/bash";s:5:"empty";b:0;s:8:"chrooted";b:0;}s:13:"/sbin/nologin";a:3:{s:4:"name";s:13:"/sbin/nologin";s:5:"empty";b:1;s:8:"chrooted";b:0;}s:9:"/bin/tcsh";a:3:{s:4:"name";s:9:"/bin/tcsh";s:5:"empty";b:0;s:8:"chrooted";b:0;}s:8:"/bin/csh";a:3:{s:4:"name";s:8:"/bin/csh";s:5:"empty";b:0;s:8:"chrooted";b:0;}s:27:"/usr/local/psa/bin/chrootsh";a:3:{s:4:"name";s:20:"/bin/bash (chrooted)";s:5:"empty";b:0;s:8:"chrooted";b:1;}s:10:"/bin/rbash";a:3:{s:4:"name";s:10:"/bin/rbash";s:5:"empty";b:0;s:8:"chrooted";b:0;}}
    

Cause

The issue could persist for locales which are different from default English.

By default the table psa.ServiceNodeEnvironment is created in UTF8 character set. If different locale is used on the system after system reboot the value in required table might get the wrong parameter.

Resolution

  1. Connect to Parallels Plesk Automation (PPA) Management node using terminal.

  2. Create backup of MySQL database according this article:

  3. Log in to MySQL database and modify the corrupted value to correct one:

    [root@ppa ~] mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
    
    mysql> update ServiceNodeEnvironment set value='a:8:{s:10:"/bin/false";a:3:{s:4:"name";s:9:"Forbidden";s:5:"empty";b:1;s:8:"chrooted";b:0;}s:7:"/bin/sh";a:3:{s:4:"name";s:7:"/bin/sh";s:5:"empty";b:0;s:8:"chrooted";b:0;}s:9:"/bin/bash";a:3:{s:4:"name";s:9:"/bin/bash";s:5:"empty";b:0;s:8:"chrooted";b:0;}s:13:"/sbin/nologin";a:3:{s:4:"name";s:13:"/sbin/nologin";s:5:"empty";b:1;s:8:"chrooted";b:0;}s:9:"/bin/tcsh";a:3:{s:4:"name";s:9:"/bin/tcsh";s:5:"empty";b:0;s:8:"chrooted";b:0;}s:8:"/bin/csh";a:3:{s:4:"name";s:8:"/bin/csh";s:5:"empty";b:0;s:8:"chrooted";b:0;}s:27:"/usr/local/psa/bin/chrootsh";a:3:{s:4:"name";s:20:"/bin/bash (chrooted)";s:5:"empty";b:0;s:8:"chrooted";b:1;}s:10:"/bin/rbash";a:3:{s:4:"name";s:10:"/bin/rbash";s:5:"empty";b:0;s:8:"chrooted";b:0;}}' where serviceNodeId = '1' and section = 'os' and name='availableShells';
    
  4. Rerun the failed task.

  5. If task to create new subscription is still failed please make sure:

    • Resources are not overused Reseller > reseller > Resource usage;
    • Go to System > Task Manager > Periodic > Sync resource usage and make sure that task is finished successfully.

If the required task failed again, use this article to resolve the issue.

Search Words

Failed to create subscription

Smb_Exception_Syntax::handleError

Connection problem: Please check the PPA system log

Connection problem: Please check the PPA system log /usr/local/ppa/log/plesk.log for details.

e0aff7830fa22f92062ee4db78133079 c1ecc6010feff26cb42d1d14a7881dd6 caea8340e2d186a540518d08602aa065

Email subscription for changes to this article
Save as PDF