How to upgrade Mysql on Plesk with CentOS Linux
The procedure for upgrade of Mysql is quite simple.
wget -q -O – http://www.atomicorp.com/installers/atomic.sh | sh
How to upgrade:
yum –enablerepo=atomic-testing upgrade mysql
–enablerepo=repoidglob
Enables specific repositories by id or glob that have been disabled in the configuration file using the enabled=0 option.
To upgrade php run ‘yum upgrade php‘
With the above methods mysql will be upgraded to latest release.
How to access psa database in Plesk Server
We can access plesk psa database, from the Linux command line (via ssh) and from the Plesk control panel.
The /etc/psa/.psa.shadow file contains the Plesk admin password.
So to access the database run the following command.
mysql -uadmin -p`cat /etc/psa/.psa.shadow`
Select the psa database.
To view all the tables
How to check if Python script engine is enabled
We can check using the default Parallels Plesk Panel domain page content (http://domain.tld/index.html) - then by the “Python” item.
The test looks successful if a page with a list of environment variables is shown.
Test can be done using a simple script like this.
#!/usr/bin/env python
# -*- coding: UTF-8 -*-
# enable debugging
import cgitb
cgitb.enable()
print “Content-Type: text/plain;charset=utf-8″
print
print “Hello World!”
It is necessary to put the content into a text file and save in the domain web-accessible folder (like $HTTPD_VHOSTS_D/domain.tld/httpdocs) on the server with .py extension (test.py for example). Then try to open the file via browser by the http://domain.tld/test.py URL.
The test looks successful if a page shows the “Hello World!” string. If an error or full script listing is visible, it means that Python engine is not configured for the domain properly.
Reference: http://parallels.com/
Unable to open configuration file /etc/psa/psa.conf: Permission denied
unable to open configuration file /etc/psa/psa.conf: Permission denied
Such errors are reported when Panel spam-filter processes incoming mail to mailbox with the Spamassasin feature enabled. Error is reported because spam-filter hook has no permission to access files in the /etc/psa directory. However, Spamassassin still processes messages correctly so this error does not mean Spamassassin is not working.
To workaround the issue it is possible to add the execute permissions for the /etc/psa folder.
Reference: http://parallels.com/
Ports need to be opened for Plesk services
Generally it depends on what services are running on the server. All the default ports which can be used by Plesk/services are listed below:
#20 ftp-data
#21 ftp
#22 ssh
#25 smtp
#53 dns (TCP and UDP)
#80 http (web server and Plesk updater)
#106 poppassd (for localhost only)
#110 pop3
#113 auth
#143 imap
#443 https
#465 smtps
#587 mail message submission
#990 ftps
#993 imaps
#995 pop3s
#3306 mysql
#5224 (outgoing connections only) plesk-license-update
#5432 postgres
#8443 plesk-https
#8880 plesk-http
#9080 tomcat
If required you can always reset your default firewall settings via the AccountCenter.
Reference: http://parallels.com/
