Archive for August, 2009

SBDavid
Aug 17th, 2009

defpackagemng failed: Access is denied.

defpackagemng failed: Access is denied.

If you are getting the following error when logging into Plesk control panel (Windows) :

DefPackageMng() constructor failed: defpackagemng failed: Access is denied. Error code 5) at CreateProcess ‘C:\WINDOWS\system32\cmd.exe /c “”C:\Plesk\admin\bin\defpackagemng.exe” –get”‘
at execUtil C:\Plesk\admin\bin\defpackagemng.exe –get on C:\Plesk\admin(PleskSrvClient::execUtil line 420)at execute console command –get(vconsoleapp::start line 128)
at execute C:\Plesk\/admin/bin/defpackagemng –get(vconsoleapp::run line 138)

Solution:

This error occurs when Plesk Control Panel service Apache can’t access to C:\Windows\System32\cmd.exe. This may happen when administrator manually changes permissions on file system. User SERVICE should have Read+Execute; Read on the file.

>> The following permissions should be set on ‘cmd.exe’ to make server work properly:

Administrators - Full Control
System - Full Control
Service - Read+Execute; Read
Interactive - Read+Execute; Read

Restart the plesk service. Try login again.

SBDavid
Aug 16th, 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.

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

SBDavid
Aug 15th, 2009

Error when try to use PHPMyAdmin in the Plesk CP

Error when try to use PHPMyAdmin in the Plesk CP

Sometimes you might get the following error when try to use PHPMyAdmin in Plesk CP:

“#1045 - Access denied for user ‘pma_xxxxxxx’@'localhost’ (using password: YES)”

You can use the following to fix the issue:

Make sure Plesk PHPMyAdmin user exists in mysql.user table and has right password and privileges. User name and password can be found in /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/config.inc.php file.

# cd /usr/local/psa/admin
# grep controluser htdocs/domains/databases/phpMyAdmin/config.inc.php
$cfg['Servers'][$i]['controluser'] = ‘USER’;

# grep controlpass htdocs/domains/databases/phpMyAdmin/config.inc.php
$cfg['Servers'][$i]['controlpass'] = ‘PASSWORD’;

# grep pmadb htdocs/domains/databases/phpMyAdmin/config.inc.php
$cfg['Servers'][$i]['pmadb'] = ‘DATABASE’;

Try to login as this user into MySQL from the command line. If the password doesn’t match, update mysql.user table and set ‘PASSWORD’ password for ‘USER’. If such user doesn’t exist in Mysql, create it with commands like:

# mysql -uadmin -p`cat /etc/psa/.psa.shadow`

mysql> use mysql;
mysql> insert into user values (’localhost’,'USER’,password(’PASSWORD’),’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',’N',”,”,”,”,0,0,0);
mysql> INSERT INTO `db` VALUES(’localhost’,'DATABASE’,'USER’,'Y’,'Y’,'Y’,'Y’,'N’,'N’,'N’,'N’,'N’,'N’,'N’,'N’);
mysql> flush privileges;

Replace USER, PASSWORD and DATABASE with the right values from config.inc.php.

SBDavid
Aug 14th, 2009

SQL Express not showing up in Plesk

SQL Express not showing up in Plesk

SQL Express not showing up in Plesk :

The SQL server won’t be listed under “Plesk >> Servers >> Database server”.

To solve this, login to the server via RDP.

Start >> Programs >> SQL Server Management Studio Express

Now, login to the SQL server with the below details.

server type : database engine

server name : hostname or IP address

Authentication : Windows Authentication

Do select Authentication type as Windows Authentication. Then create login for ’sa’ user.

security > logins > reset or create new

Or reset the ’sa’ password

security > logins > sa > properties

Also, navigate to

Programs > MS SQL server > Configuration Tools > SQL configuration manager > Network Configuration
> Protocols for MS SQL server

Enable the following :

1. Shared Memory

2. Named Pipes

3. TCP/IP

Once the above are done. Restart the below services.

MS sql server

Plesk sql server

Now you can find the database server under “Plesk >> servers >> database server”.

« Prev - Next »