Archive for the tag 'connect'

SBDavid
Oct 31st, 2010

Check the most IP connect to server

Check the most IP connect to server

netstat -an | grep :80 | awk ‘{print $5}’ | sed -e s/’:.*’/”/g | sort | uniq -c

or

netstat -anp |grep ‘tcp\|udp’ | awk ‘{print $5}’ | cut -d: -f1 | sort | uniq -c | sort -n

or

netstat -ntu | awk ‘{print $5}’ | cut -d: -f1 | sort | uniq -c | sort -n
SBDavid
Aug 15th, 2009

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

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.

Unable to connect to database: saved admin password is incorrect. 0: C:\\Program Files\\SWsoft\\Plesk\\admin\\auto_prepend\\auth.php3:56 psaerror(string “Unable to connect to database: saved admin password is incorrect.”)

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.

%plesk_bin%\plesksrvclient.exe -get

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,

C:\Program Files\Parallels\Plesk\mysql\bin\mysql.exe -P8306 mysql

Now from the MySQL prompt, type

update mysql.user set password=password(’current_password’) where user=’admin’;

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 now