Plesk error: Unable to open logs

While doing a apache restart you see the following error in /var/log/httpd/error_log

Unable to open logs

Try executing the command:

echo $ulimit

If it is blank or a low value, try executing the command

ulimit -n 65536

This is should fix the issue and apache should be working fine.

Webmail error: A fatal error has occurred DB Error: connect failed

While accessing the Webmail URL sometimes you get the following error during attempting to login into Webmail:

A fatal error has occurred
DB Error: connect failed
Details have been logged for the administrator.

Please make sure that the following line exist in /etc/my.cnf:

socket=/var/lib/mysql/mysql.sock

Also check that Mysql service is running and /var/lib/mysql/mysql.sock socket exists..

Make sure that the ‘horde’ user is able to connect to the ‘horde’ database with a password from etc/psa/.webmail.shadow using the command:

# mysql -uhorde -p`cat /etc/psa/.webmail.shadow` -D horde

If /etc/psa/.webmail.shadow is missing, put some password into this file and change the password for the ‘horde’ user in the ‘mysql’ database using the query listed below.

If you get the error, make sure that the only one ‘horde’ MySQL user exists in the ‘user’ table in ‘mysql’ database and try to change it’s password with mysql query like:

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` -D mysql

mysql> update user set password=password(“THE_PASSWORD_FROM_WEBMAIL.SHADOW”) where user=”horde”;

mysql> FLUSH PRIVILEGES;

Look into “psa-horde” log (by default: /var/log/psa-horde). If you see something like:

Nov 02 12:55:06 HORDE [emergency] [horde] DB Error: connect failed: [nativecode=Access denied for user: 'root@localhost' (Using password: NO)] ** Array [on line 1329 of "/usr/share/psa-horde/lib/Horde/DataTree/sql.php"]

make sure that sql.safe_mode is disabled in php.ini, it should be like:

sql.safe_mode=Off

Restart Apache after changes in php.ini have been made

How to access Plesk database

Plesk database can be accessed by following steps below depending on the database provider are configured in current Plesk installation.
Read the rest of this entry »

Default Plesk page

The domain is resolved to an IP that belongs to the Plesk server. If you open the domain you see the Plesk default page:
Read the rest of this entry »

Disable DrWeb notification e-mails in Plesk

To Disable DrWeb notification e-mails

“%plesk_dir%\mysql\bin\mysql” -uadmin -padmin_password -P8306 psa

First, make sure that record responsible for antivirus notification exists in table psa.misc. You can check it using this query…………

Read the rest of this entry »