ServerBuddies Support Blog

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.

Select the psa database.

To view all the tables

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:

If required you can always reset your default firewall settings via the AccountCenter.

Reference: http://parallels.com/

Restarting services in Plesk

If a service, such as Apache, has stopped you may need to restart the service.

The following guide shows you how to start/stop/restart system services from within Plesk.

From Plesk Services Management

1. Login to Plesk.
2. Click on Server.
3. Click on Service Management.

Now you can start|stop|restart the service of your choice.

From Virtuozzo System Services

1. Login to Plesk.
2. Click on Virtuozzo.
3. Click on System Services.
4. Now you can start|restart|stop the service of your choice. You can also enable the Autostart feature.

Disable ping requests in Plesk

By default your server can be pinged by anyone, meaning it is discoverable. You can improve security by changing your firewall to only allow known IP addresses to ping your server.

If your static IP is 192.168.1.1 change the rules under Ping Service in Plesk’s default Firewall rules.

Using the built-in Plesk firewall

Although you could edit the firewall from the command-line it is much easier using Plesk’s firewall instead.

Just navigate to Modules > Firewall. If you have a static IP address you can create rules so that the server will only allow access from your IP address at your home and/or office.

By default the SSH standard port number is 22. If you look at your logs you might see a large number bad login attempts on that port. Changing this port number is a simple way to make your server more secure. To change the port number login as root and run the following command:

Find the line that says:

Change this line to another port number above 1024. Using a port number above 1024 prevents scans like nmap picking up ssh.

Save the sshd_config file and then restart sshd.