Plesk Errors

From Server Knowledge Base
Revision as of 13:38, 5 February 2013 by Rootadminacc (talk | contribs)
Jump to navigationJump to search

The best places to check for Plesk problems are: 

/var/log/sw-cp-server/error_log
/usr/local/psa/admin/logs/panel.log
/var/log/messages

Service logs and configuration files for Linux
Service logs and configuration files for Windows

Attention, The update of Parallels Panel has failed.

It's possible that Plesk may be completely inaccessible via the browser at this stage. The logs are located on the server at /tmp/autoinstaller3.log - it should say what has failed there.

You may wish to try running a repair on Plesk, using the following:

/usr/local/psa/bootstrapper/pp10.13.4-bootstrapper/bootstrapper.sh repair

(the name of the '/pp10.13.4-bootstrapper/' directory may vary depending on the currently installed version).

If that command works then you should find that Plesk is available again - it'll be back to the version prior to the upgrade attempt.

If you then want to run the upgrade manually, you can do this using:

/root/parallels_installer --select-product-id=plesk --select-release-latest


Changing subscriber fails

If when you go to Hosting Services - Subscriptions > tick a domain > Change Subscriber > select the circular radio button next to the customer > click Next >> you get the below: 

0: DNSZone.php:45
DNSZone->DNSZone(string '66')
1: common_func.php3:3262
objectMaker(string 'DNSZone', string '66')
2: DNSManager.php:29
DNSManager::getDNSZone(string '66')
3: chownerCheckForm.php:191
chownerCheckForm->_getCurrentIps(object of type PhDomain)
4: chownerCheckForm.php:55
chownerCheckForm->assign(object of type chowner)
5: chowner.php:59
require(string '/opt/psa/admin/htdocs/domains/chowner.php')
6: plesk.php:68

Remember the value in string '00'. This can happen due to No web hosting [add] in Websites & Domains. Then do: 

mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa;
select * from dns_zone\G

If the entry does not exist, you need to remove the subscription in Plesk. Make a note of the FTP username first and any Databases and their usernames. You can back the websites databases up by doing this in MySQL: 

show databases;
quit
#then outside of MySQL
mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` databasename > databasebk.sql

Re-add the Subscription however you may get the error below: 

Unable to update domain data: Domain::update failed: There is a domain alias with name www.domain.co.uk.

If not carry on. If you do get the error, do the following: 

mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa;
select * from domainaliases;

+----+--------+-------------+--------+----------------------+----------------------+------+------+------+--------+
| id | dom_id | dns_zone_id | status | name                 | displayName          | dns  | mail | web  | tomcat |
+----+--------+-------------+--------+----------------------+----------------------+------+------+------+--------+
|  4 |     43 |          48 |      0 | www.domain.co.uk   | www.domain.co.uk   | true | true | true | false  |

#delete the entry
delete from domainaliases where id=4;

And then try re-add the Subscription and assign it to the Customer/Subscriber you want to.

Creating folder

If you go into Plesk's file manager and try to create a directory within: 

anon_ftp
cgi-bin
conf
error_docs
httpdocs
pd
private
statistics
subdomains
web_users

You will get the error 'Unable to create directory //test: filemng: Error occurred during /bin/mkdir command'. This is because unless you go in via command line/RDC and create the folder manually or create a domain with the folder as it's document root it will not allow it.

Cron runs via SSH but not Plesk

Run this if the server is 10.1+: 

/usr/local/psa/bin/server_pref -u -crontab-secure-shell "/bin/sh"

Default IP Address

If you are on Plesk 9 and within Settings > General - IP Addresses the IP Address is set to Exclusive or Shared and cannot be changed, SSH into the server and do: 

mysql -uadmin -p`cat /etc/psa/.psa.shadow`;
use psa
select * from ip_pool;
update ip_pool set type="shared";
#or
update ip_pool set type="exclusive";

Domains area is blank

Failed to connect to sitebuilder

Fix: http://kb.parallels.com/en/9491

cd %plesk_dir%\admin\plib\report

Running task: C:\Program Files (x86)\Parallels\Plesk\admin\bin\php.exe -q -dauto_prepend_file="" -c php.ini "C:\Program Files(x86)\Parallels\Plesk\admin\plib\DailyMaintainance\script.php"
Started: Tue Nov 20 05:05:04 2012
The task output is attached to the e-mail Ended successfully: Tue Nov 20 05:06:19 2012

The output file (which I've also attached) states the following error:
! 0 Error: Failed to connect to sitebuilder - missing or incorrect C:\Program Files (x86)\Parallels\Plesk\/sb/include/init.php
2012-11-20T05:06:19+00:00 ERR (3): Failed to connect to sitebuilder - missing or incorrect C:\Program Files(x86)\Parallels\Plesk\/sb/include/init.php

IP Pool Empty

When trying to add a subscription and it comes back with the error "The IP Pool is empty" this means the IP/s under Tools & Settings > IP Address is/are set to Dedicated. It/they need to be switched to Shared. 

/opt/psa/bin/ip_pool
/usr/local/psa/bin/ip_pool
/opt/psa/bin/ip_pool -u 0.0.0.0 -type shared -owner mydomains

Get the owner name from within:

  • Main Menu - Clients
  • Click the client under Client's name
  • Account - Personal Data
  • The owner is the entry in the Login* field.

IP Pool Guide
Plesk 10 instructions/prevention

You can try the following. Sometimes it breaks the IP addresses (setting it back will fix it if it breaks), sometimes it will work. 

mysql -uadmin -p`cat /etc/psa/.psa.shadow`;
use psa
select * from ip_pool;

Then pick the entry you want to change from exclusive/dedicated to shared. 

update ip_pool set type="shared" where id="3";

If you get the message "There are no resources of this type (domains) available from your Service Provider. Requested: 1; available: 0. The notification has been sent to your Service Provider." when trying to add a domain in bullet points above field, go to:

  • Main Menu - Settings
  • General - License Management
  • Maximum number of domains will likely be a low number and you have a domain limit you are trying to exceed.
  • Therefore you need to buy a new license key for Plesk.

Migration Fails

Connection to host not available or migration agent is not running on the source host.

This can be caused because on the old VPS the Migration Agent is not running, this can be downloaded onto the server via RDP on Windows/cmd or using wget on Linux at:

- http://www.parallels.com/uk/download/plesk10.3/ (Check Notes for log
- Allow in Tools > Internet Options > Security > Trusted Sites (add parallels.com and *.parallels.com) for Windows
- Scroll to bottom of page
- Download the MSI (for Windows) or the TAR (for Linux)
- Ensure Firewall is off on old and new VPS
- Install
- Do not log off, just X the RDP session after Migration Agent is running.

http://kb.parallels.com/807 

Failed to upload the migration agent
Cannot send scout to the remote host
Lost connection with the remote host

NOTE: You can partly migrate from Linux to Windows but migration from Parallels Plesk Panel Windows to Parallels Plesk Panel UNIX is not supported.

Migration Manager uses SSH protocol for uploading of migration agents to source server and dump files retrieving. Make sure that:

1) SSH server is running and SSH (22) port is opened on the source server (you are performing the migration from),
2) SSH server on the source server allows connecting it with SSH version 2 protocol,
3) you are able to login from destination server to the source one via SSH under the user you specified during the migration. Also check that you can transfer a file from the source server to the destination Parallels Plesk Panel server with scp command.

Migrating from earlier versions of Plesk Panel, refer to: http://download1.parallels.com/Plesk/PPP9/Doc/en-US/plesk-9.2-migration-guide/index.htm?fileName=63282.htm Manual Migration: http://kb.parallels.com/1152

mod_fcgid: read data timeout

mod_fcgid: read data timeout in 45 seconds, referer: https://www.website.com/file.php

FcgidIOTimeout 45

http://www.moe.co.uk/2009/08/17/php-running-under-mod_fcgid-read-data-timeout-in-40-seconds-on-plesk
http://rickchristie.com/blog/2011/note/apache-mod_fcgid-read-data-timeout-error

SSO (Single Sign On)

If a Plesk login URL redirects to a relay or unusual URL, this is caused by the SSO service and configuration files which can be caused when the Customer Billing section is installed. To re/enable SSO use --enable in place of --disable below. To disable SSO use: 

/usr/local/psa/bin/sso --disable
#Windows: C:\>%plesk_dir%/bin/sso --disable
#Server 2003: C:\Parallels\Plesk\bin\sso --disable
#Server 2008: To be noted

http://en.wikipedia.org/wiki/Single_sign-on
http://forum.parallels.com/printthread.php?t=87460

Also try using the command to check encrypted/decrypted plesk password. It is advised NOT to manually configure hosts files as this can also cause conflicts, as within etc/hosts there is the relay to the URL it was taking you to. If you would like to ensure this does not cause issues simply change the URL within there to your VPS hostname. The SSO service has been disabled and now allows you to login to Plesk for your server at it's IP address.

Panel Missing and Applications

Check these locations to check, start it or patch/update it: 

/usr/local/
/etc/init.d/psa
/opt/psa/admin/bin/autoinstaller

netstat -nap | grep 8443 (to check for network activity on Plesk's port). If it is not there, rebuild the VPS.

The error "Update operation was locked by another update process" means you need to ps aux | grep auto and kill the processes and then run autoinstaller again. If the Applications are missing from the Applications tab, go to Tools and Settings > Application Vault > Clear Cache

When upgrading Plesk from 10.2 to 10.4.4 you may get: "There are customized DNS records with host equal host of existing subdomain, they will lost after upgrade to Plesk version above 10.4.4. Check http://kb.parallels.com/en/113310 for more details."

Failed to run the pleskctl utility

MainDBException

The below error normally affects Windows servers, and you should look in the following file to see if port=8306 and is referencing the right file paths: 

\Plesk\MySQL\Data\my.ini

Check Windows Firewall is not causing the issue by turning each one (or all) off and try Plesk, check if the Plesk SQL Service service can start/restart via Services.msc

Also check the third tab along to see if Plesk MySQL Server is ticked (under venet0). 

ERROR: PleskMainDBException
No connection could be made because the target machine actively refused it.

0: common_func.php3:619
reconnect()
1: common_func.php3:582
db_connect()
2: auth.php3:146
ERROR: PleskMainDBException
No connection could be made because the target machine actively refused it.

0: common_func.php3:619
reconnect()
1: common_func.php3:582
db_connect()
2: auth.php3:146

http://forum.parallels.com/pda/index.php/t-113419.html

If you get:

ERROR: PleskMainDBException MySQL query failed: Table 'psa.skins' doesn't exist

Check the directive in the my.cnf file on the server

lower_case_table_names = 1

The Plesk PSA database uses table names that start with a capital letter. With the above directive set to 1 (enabled) any queries are converted to lower case. As MySQL is case sensitive, this causes Plesk to look for a table called skins not Skins. Hence the failure. Disable the directive in the my.cnf file, restart the server and check the Plesk panel is up and running normally now. Ensure you do not change the directive or it will break again.

If you see the below error, look here: 

ERROR: PleskMainDBException
Access denied for user 'admin'@'localhost' (using password: YES)

0: common_func.php3:637
	reconnect()
1: common_func.php3:600
	db_connect()
2: auth.php3:134

The error below needs a fix:

ERROR: PleskMainDBExceptionUp LevelMySQL query failed: Table 'psa.lockout' doesn't exist

0: common_func.php3:206db_query(string 'delete from lockout where (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(last_wrong)) > (30 * 60)')1: cmd_loginup.php:82createSession(string 'admin', string '*********')2: login_up.php3:22

ERROR: PleskMainDBException An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full.

If you see this error, to be fixed:

0: common_func.php3:637 reconnect() 1: common_func.php3:600 db_connect() 2: auth.php3:129 ERROR: PleskMainDBException An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full.

0: common_func.php3:637 reconnect() 1: common_func.php3:600 db_connect() 2: auth.php3:129

PleskDBException

Hosting Services > Domains > Manage Hosting 

Internal error: Unable to find service node for web service on domain with id=7

Message	Unable to find service node for web service on domain with id=7
File	 PhDomainBase.php
Line	775
Type	PleskDBException

http://kb.parallels.com/en/113826

Updating Plesk will NOT solve this problem.

Plesk Fatal Exception

If you get Plesk diagnostics on Plesk 9, restart sw-cp-server via SSH.

Plesk Spider Tool

  • Enable the following options in PRODUCT_ROOT_D/admin/conf/php.ini and restart psa: 'display_errors = On', 'log_errors = On'. Then check error messages in the log file /var/log/sw-cp-server/error_log
  • Plesk's default root directory is /usr/local/psa/
  • The file that declares the paths to be used by services and utilities is /etc/psa/psa.conf
  • To change the default TCP port used to access Plesk change the value in /etc/sw-cp-server/applications.d/plesk.conf
  • The directory containing the application packages used in Plesk Panel is $PRODUCT_ROOT_D/var/apspackages/
  • The general psa database structure is in $PRODUCT_ROOT_D/etc/db/
  • The DNS zone files for domains are stored in $NAMED_RUN_ROOT_D/var/
  • You can restore the configuration of mail server and mail accounts via $PRODUCT_ROOT_D/admin/sbin/mchk
  • To prevent users from running tasks on behalf of root, create one of the following files: $PRODUCT_ROOT_D/var/root.crontab.lock , $PRODUCT_ROOT_D/var/crontab.lock , $PRODUCT_ROOT_D/var/root.event_handler.lock , $PRODUCT_ROOT_D/var/event_handler.lock or $PRODUCT_ROOT_D/etc/root.psa_db.sql.lock
  • GUI engine configuration file is in etc/sw-cp-server/applications.d/

Plesk 11

Removing a domain/subscription shows Internal Server Error. Within /var/log/sw-cp-server/error_log it may show something like:

2012-07-05 09:39:09: (mod_fastcgi.c.2613) unexpected end-of-file (perhaps the fastcgi process died): pid: 10809 socket: unix:/usr/local/psa/tmp/sw-engine.sock-0 2012-07-05 09:39:09: (mod_fastcgi.c.3400) response not received, request sent: 2001 on socket: unix:/usr/local/psa/tmp/sw-engine.sock-0 for /admin/index.php?redirect=/subscription/list/, closing connection

This normally happens when you remove Hosting from a domain. Go into the domain, Websites & Domains tab, click Add next to the domain, select Website hosting, re-add a FTP user/password and click OK.

PMM Folder

PMM stands for Plesk Migration Manager. It can use quite a bit of disk space. If a backup or restoration has been successfully completed and now all works (or is older than a few days) you can remove this data in /opt/psa/PMM ( /usr/local/psa/pmm/tmp ).

Plesk Application tab empty

Check the log file /var/log/sw-cp-server/error_log to see if it contains the following entry:

2011-07-14T15:30:26+01:00 ERR (3): APS Catalog error: Unable to define main IP address

Check if the IP addresses have the true or main attribute in Plesk Panel database: 

mysql> select id, ip_address, main from IP_Addresses;
+----+----------------+-------+
| id | ip_address     | main  |
+----+----------------+-------+
|  1 | X.X.X.X        | false |
|  2 | X.X.X.X        | false |
+----+----------------+-------+

Identify main IP address on the server: 

# ifconfig |grep eth0 -A1
eth0      Link encap:Ethernet  HWaddr 00:0X:00:X0:00:00
        inet addr:X.X.X.X  Bcast:X.X.X.255  Mask:255.255.255.0    <=====
   --
eth0:0    Link encap:Ethernet  HWaddr 00:0X:00:X0:00:00
        inet addr:X.X.X.X  Bcast:X.X.X.255  Mask:255.255.255.0

Mark it as that in IP_Addresses table: 

mysql> update IP_Addresses set main="true" where ip_address="X.X.X.X";

Alternative solution:

1) Check how many applications there are in 'Application vault' under 'Tools & utilities'.

2) Check how many how are getting in the folder '/usr/local/psa/var/apspackages' eg: 

[root@castlerp apspackages]# ls
apscataloglQLE2R.zipc739e4c9-5f6e-70 apscatalogSWLhgA.zipf66f54dc-9b23-f4

3) Move the packages you got from this folder, /usr/local/psa/var/apspackages, to some other location.

4) Then try to 'clear cache' in 'Application vault' under 'Tools & utilities'.

5) Then you will get error regarding some packages which are missing. eg:

Internal error: Cannot find package cache directory: '/usr/local/psa/var/apspackages/apscatalogSWLhgA.zipf66f54dc-9b23-f4'

6) Move those missing packages only to the folder location '/usr/local/psa/var/apspackages'.

For example 'apscatalogSWLhgA.zipf66f54dc-9b23-f4'

See the error in panel, Internal error: Cannot find package cache directory: '/usr/local/psa/var/apspackages/apscatalogSWLhgA.zipf66f54dc-9b23-f4'

7) After that 'clear cache' in 'Application vault' under 'Tools & utilities'. This will remove the temporary files.

Then the Applications will be available in the domain control panel without any issues.

Service Unavailable

If you get the following message: 

Service Unavailable

HTTP Error 503. The service is unavailable.

See this guide. Restart Plesk via services.msc and ensure the firewalls allow port 8843 through them.

The validity period of client account...

If you get this message in Plesk 9:

"The validity period of client account (Contact Name ) is about to expire. The client account and all of related domains will be deactivated by unless the validity period is prolonged."

Check via SSH with /usr/local/psa/bin/domain_pref -i domain.com | grep -i expir

To alter this, go into Plesk and go to:

  • Clients
  • Tick the client you have been warned about
  • Modify
  • Scroll to the bottom
  • Set the Expiration date to Unlimited in the drop down box
  • Click OK

If this doesn't work, do: 

/usr/local/psa/bin/client_pref --update user -expiration year-mm-dd

cd C:\Parallels\Plesk\bin
client_pref.exe -u userwithnospaces -expiration YEAR-MM-DD

Unable to modify admin's personal info

Unable update mailbox mailmng failed

This can happen on both Windows and Unix:

Unix, Details, also try /usr/local/psa/admin/sbin/mchk
Windows, A different fix

This is a unfixable bug as of 12/12/12 for Debian based x86_64, with a fix presumed next week: http://forum.parallels.com/showpost.php?p=659020&postcount=66

Webmail shows Parallels holding page

If this happens ensure mail in Change Settings is on, the webmail and mail DNS records go to the VPS and then attempt to go into Plesk' DNS settings. If it shows: 

ERROR: PleskObjectNotFoundException
DNSZone::Table::select() failed: no such row in the table

Additionally, an exception has occurred while trying to report this error: PleskObjectNotFoundException
DNSZone::Table::select() failed: no such row in the table

0: DNSZone.php:51
	DNSZone->DNSZone(string '3')
1: common_func.php3:3048
	objectMaker(string 'DNSZone', string '3')
2: DNSManager.php:34
	DNSManager::getDNSZone(string '3')
3: class.Domain.php:1148
	Domain->getDNSZone()
4: client.domain.dns.php:28
	plesk__client__domain__dns->getDNSZone()
5: DNSUIPointer.php:87
	DNSUIPointer->getFlavor()
6: UIPointer.php:924
	UIPointer->getCaption(string 'done', string '', NULL null, object of type UserAdmin, NULL null, string '')
7: common_func.php3:3926
	wizard_get_done_message()
8: plesk.php:32

and then 

DNSZone::Table::select() failed: no such row in the table

you need to recreate the subscription.

Websites & Domains tab is blank

Or it will show the below error:

Internal error: Unable to execute serverconf: terminate called after throwing an instance of 'plesk::Exc<&(plesk::ExecCmd::Failed(bool))>' what(): Execution of hostname -f failed with return code 1. Stderr is hostname: Unknown host

Hostname -f or --fqdn, --long means long host name (FQDN) , from using hostname --help

Plesk will try to use your hostname to load parts of Plesk using a Fully Qualified Domain Name (FQDN) at domain.com:8880 over http, this in turn will try to redirect to IP:8443 or domain.com:8443 and will fail. In SSH if you do hostname -f and then ping the result, if this does not resolve you will get the error above.

To resolve this, go to either:

  • Server Management > Tools & settings > General Settings > Server Settings > set Full hostname to a domain name
  • Server tab > General Settings > Server Settings > set Full hostname to a domain name

Zend_Db_Statement_Exception

This happens when retrieving the password using /usr/local/psa/bin/admin --show-password . Disk space is full normally. Run df -h to find out or go [Resource_Usage | here].

ERROR: Zend_Db_Statement_Exception
SQLSTATE[HY000]: General error: 1030 Got error 122 from storage engine 

0: Pdo.php:234
    Zend_Db_Statement_Pdo->_execute(array)
1: Statement.php:300
    Zend_Db_Statement->execute(array)
2: Abstract.php:479
    Zend_Db_Adapter_Abstract->query(string 'DESCRIBE `ServiceNodes`', array)
3: Abstract.php:238
    Zend_Db_Adapter_Pdo_Abstract->query(string 'DESCRIBE `ServiceNodes`')
4: Mysql.php:169
    Zend_Db_Adapter_Pdo_Mysql->describeTable(string 'ServiceNodes', NULL null)
5: Abstract.php:835
    Zend_Db_Table_Abstract->_setupMetadata()
6: Abstract.php:874
    Zend_Db_Table_Abstract->_setupPrimaryKey()
7: Abstract.php:982
    Zend_Db_Table_Abstract->info()
8: Select.php:100
    Zend_Db_Table_Select->setTable(object of type Db_Table_Broker_ServiceNodes)
9: Select.php:78
    Zend_Db_Table_Select->__construct(object of type Db_Table_Broker_ServiceNodes)
10: Abstract.php:1018
    Zend_Db_Table_Abstract->select()
11: Abstract.php:1331
    Zend_Db_Table_Abstract->fetchAll(string '`transport` = 'local'')
12: Abstract.php:110
    Db_Table_Abstract->findByField(string 'transport', string 'local')
13: Abstract.php:122
    Db_Table_Abstract->findOneByField(string 'transport', string 'local')
14: ServiceNodes.php:226
    Db_Table_Broker_ServiceNodes->getLocalServiceNode()
15: auth.php3:505
Retrieved from "http://serverkb.co.uk/index.php?title=Plesk_Errors&oldid=226"