WebScHoLaR Dot NET

A blog discussing common issues of Linux, cPanel/WHM, Plesk, DirectAdmin, InterWorx

1. Check for processes holding the rpm database open (usually in MUTEX/FUTEX states):

lsof | grep /var/lib/rpm

If it finds any, kill -9 them all.

2. Delete any temporary DB files:

rm -fv /var/lib/rpm/__*

3. Rebuild your RPM database:

rpm –rebuilddb -v -v

If you still have problems, a reboot is probably quickest, then repeat steps 2 and 3 above.

The Plesk admin password can simply be reset by login to VPS using RDP with following command:

%plesk_bin%\plesksrvclient.exe

Just run the command and it will ask for new admin password. If it also shows the message that Access denied/can’t connect to MySQL then:

1. Add parameter skip_grant_tables=1 into the [PleskSQLServer] section.
2. Restart service Plesk SQL Server.

%plesk_bin%\plesksrvclient.exe -get command can be used to retrieve the Plesk admin password from the database to verify that the password has been successfully updated in Plesk system database. If Plesk admin password is not updated somehow then it can be updated manually. To do it, please, follow the steps:

1. Edit MySQL configuration file my.ini located within %plesk_dir%\mysql\data\.
2. Add parameter skip_grant_tables=1 into the [PleskSQLServer] section.
3. Restart service Plesk SQL Server.
4. Log into Plesk MySQL.

%plesk_dir%\mysql\bin\mysql.exe -P8306 mysql

1. Execute the following query:

mysql> update mysql.user set password=password(‘NEWPASSWORD’) where user=’admin’;

1. Remove skip_grant_tables=1 from within the [PleskSQLServer] section within %plesk_dir%\mysql\data\my.ini
2. Restart service Plesk SQL Server.

New Plesk versions 8.6+ comes with MSDE (Microsoft SQL Desktop Edition) by default so you just need to follow the below mentioned steps in order to configure it.In earlier Plesk versions, MSDE needs to be installed. This can be done by downloading the MSDE from Microsoft site or installing “msde” virtuozzo template. Virtuozzo template can be installed to VPS using VZMC or “vzpkgadd” command. Read the rest of this entry »