ServerBuddies Support Blog

Unable login into the domain stats

Issue: Unable to login into the stats of the domain (in Plesk). It is asking the password continuously.

<Directory "/var/www/vhosts/domainName/statistics">
         AuthType Basic
         AuthName "Domain statistics"
         AuthUserFile /var/www/vhosts/domainName/pd/d..httpdocs@plesk-stat
         require  valid-user
</Directory>

It is in that AuthUserFile, the login name as well as the encrypted password is stored.

So adding a new user login details in that file fix the problem, and you can add it as follows.

Create the encrypted password using htpasswd command.

This will fix the issue.

Note : Replace the domainName by corresponding domain name.

Plesk login page shows “Unable to connect to database : saved admin password is incorrect”

When try to login to Plesk admin panel the following error is displayed.

Reason:

The main reason for the issue is the PSA database user password and the Plesk admin password mismatch.

Solution:

Step 1 : Confirm the Plesk admin password. You can get the current Plesk password with command below.

Step 2 : Edit the MySQL configuration file(my.ini - %plesk_dir%\mysql\data\).

[C:\Program Files\Parallels\Plesk\mysql\data\]

Add the skip_grant_tables=1 parameter and restart the Plesk SQL Server service.

Note : Add to the [PleskSQLServer] section, NOT to [Client] section.

Step 3 : Reset the password

Type the below command to get into the MySQL prompt,

Now from the MySQL prompt, type

where ‘current_password’ is the current Plesk password.

Step 4 : Revert the changes

Remove the parameter ’skip_grant_tables=1′ from the MySQL configuration file and restart service Plesk SQL Server.

You should get the plesk admin page.

“Please Wait Loading…” pop-up is being shown continuously while login to plesk

In order to fix this issue disable magic_quotes_runtime and magic_quotes_sybase in the Plesk control panel PHP configuration file “/usr/local/psa/admin/conf/php.ini”.

These options have to be Off by default:

Switch them off and restart Plesk CP.

How to disable direct root login

Direct login for the root user is a major security issue. We can disable direct login access to reduce the security risk. This way we can have two separate passwords for root access which makes the box more secure. Also we are using the protocol 2 which is newer and more secure.

1. SSH into your server as ‘admin’ and gain root access by su

2. Copy and paste this line to edit the file for SSH logins

3. Find the line

4. Uncomment it and change it to look like

5. Next, find the line

6. Uncomment it and make it look like PermitRootLogin no

7. Save the file Ctrl+X then Y then enter

8. Now you can restart SSH

Now, no one will be able to login to root with out first loggin in as admin and ’su -’ to root.

Be sure that you remember both the passwords!