Archive for the tag 'plesk'

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”.

SBDavid
Aug 14th, 2009

Postgresql Error on Plesk

Postgresql Error on Plesk

When trying to use Postgresql on Plesk Control Panel >> servers >> Database Servers >> Local PostgreSQL, getting the following error while using the postgresql for the first time.

Unable to rewrite /var/lib/pgsql/data/pg_hba.conf
1
Error on query to PostgreSQL
1
Unable to rewrite /var/lib/pgsql/data/pg_hba.conf
1

0: /usr/local/psa/admin/plib/DatabaseManagerPostgreSQL.php:263DatabaseManagerPostgreSQL-
>createLocalAdminLoginImpl(string ‘admin’, string ‘********’, NULL null)1: /usr/local/psa/
admin/plib/DatabaseManager.php:513DatabaseManager->updateLocalAdmin()2:
/usr/local/psa/admin/plib/DatabaseServerManager.php:229DatabaseServerManager->

updateServer(object of type DatabaseServer)3: /usr/local/psa/admin/htdocs/server/db_server_edit.php:52

This means postgresql is not running and when checking the error logs we can see like this:

#tail -f /usr/local/psa/admin/logs/httpsd_error_log
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket “/tmp/.s.PGSQL.5432″?
sed: can’t read /var/lib/pgsql/data/pg_hba.conf: No such file or directory
#tail -f /var/lib/pgsql/pgstartup.log
postmaster cannot access the server configuration file “/var/lib/pgsql/data/postgresql.conf”:
No such file or directory

Usually this happens when the postgresql database is not properly initialized. For fixing this error, we need to reinitialize the postgrsql database.

# rm -rf /var/lib/pgsql/data
# /etc/rc.d/init.d/postgresql start
Then again go to Plesk Control Panel >> servers >> Database Servers >> Local PostgreSQL and give your
administrator username and password.

« Prev - Next »