Plesk Postgresql Support

Installing Postgresql and having Plesk recognize it as a valid database option is almost as easy as installing it outside Plesk but with one additional step. You have to tell plesk postgresql is installed on the server.

# yum install postgresql postgresql-server 

After yum downloads and installs the server you have to start the service:

Apache Error Documents

Setting Error Documents:

ErrorDocument 400 /bad_request.html

ErrorDocument 401 /unauthorized.html

ErrorDocument 403 /forbidden.html

ErrorDocument 404 /not_found.html

ErrorDocument 405 /method_not_allowed.html

ErrorDocument 406 /not_acceptable.html

ErrorDocument 407 /proxy_authentication_required.html

ErrorDocument 408 /request_timeout.html

ErrorDocument 409 /conflict.html

ErrorDocument 410 /gone.html

ErrorDocument 411 /length_required.html

ErrorDocument 412 /precondition_failed.html

Modx 0.9.6.3 and PHP 5.3

PHP 5.3 has introduced a new error level that reports deprecated functions. On line 13 of the config file use this line instead:

error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED)

In the file: manager/includes/document.parser.class.php You will need to modify line 2502 from:

if (error_reporting() == 0 || $nr == 0 || ($nr == 8 && $this->stopOnNotice == false)) {

to

Retrieving Plesk FTP Users Names and Passwords for Specific Domain

The following query will retrieve the sub-domain name, ftp username, and ftp password for a specific domain.

SELECT CONCAT(CONCAT(s.name, '.'), d.name) AS subdomain, u.login, a.password FROM subdomains AS s
JOIN domains AS d ON s.dom_id=d.id
JOIN sys_users AS u ON s.sys_user_id=u.id
JOIN accounts AS a ON u.account_id=a.id
WHERE d.name='example.com'

If you want to see all subdomains, then omit the WHERE clause.

Installing Architecture Specific Packages for Red Hat Fedora and EL

When running the yum command to install packages, sometimes you will get a mixture of x86_64 and i386 packages. Depending on what you want to install you may need both architectures and sometimes you don't. If you only need a specific architecture then you can specify it by:

# yum install ImageMagick.x86_64

Recovering Plesk Admin Password

In the highly unlikely event that you ever, for whatever reason forget your password to log into Plesk, one way of recovering the password is by loging into the server via SSH.

In order to view the contents of the file that contains the admin password you will need to be able to acquire root. Once root, you just simplely need to look at the /etc/psa/.psa.shadow file.

# cat /etc/psa/.psa.shadow
The$up3r$ecretPa$$w0rd