Plesk Update failed

[ErlandL]

hi,

i am using plesk 11.5 with debian and have the following problem:

I cant update plesk anymore.

Stopping psa... done
Stopping sw-cp-serverd: sw-cp-server.
Starting psa... Starting Plesk engine pool manager: sw-engine-fpm.
done
Starting xinetd service... done
Starting sw-cp-server service... done
Starting mysql service... done
Trying to connect to MySQL... Failed to connect to MySQL: ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
Trying to start service mysql... /usr/sbin/mysqld (pid 2924) is running...
done
Trying to establish test connection... ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
[...]
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
failed

ERROR while trying to establish test connection
Check the error reason(see log file: /tmp/plesk_11.5.30_reset_instance_data.log), fix and try again

Starting bind9 service... done
Starting postgresql service... not installed
Starting spamassassin service... done
Plesk: Starting Mail Server... already started
Starting psa... Starting Plesk engine pool manager: sw-engine-fpm.
done
***** problem report *****
ERROR while trying to establish test connection
Check the error reason(see log file: /tmp/plesk_11.5.30_installation.log), fix and try again
Synchronizing the Debian APT package index files...

ERROR: An error occurred during performing of installation PREP actions (see log for details). Installation was rolled back.
Warning! Not all packages were installed.
Please check if your system services are operable.
Please resolve this issue and try installing the packages again.
If you cannot resolve the issue on your own, contact product technical support for assistance.

When I check the /tmp-file, i dont anymore information, than I already posted.

BUT!

Plesk is running and I am able to login. I change my password in plesk, which was ok.

My mysql-database is also running

mysql -u admin -p

(works with the right password)

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

(works as well)


How is plesk "testing my database connection" here? where does it get the right password from.

Any idea?


Thanks for reading.


Erland

 

[IgorG]

Check this article - http://kb.parallels.com/116916

 

[ErlandL]

Hi Igor,

thanks for your answer. Unfortunately it did not help

mysql> SHOW GRANTS FOR 'admin'@'localhost'\G
*************************** 1. row ***************************
Grants for admin@localhost: GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' IDENTIFIED BY PASSWORD '*XXXXXXXXX' WITH GRANT OPTION
1 row in set (0.00 sec)

mysql> GRANT GRANT OPTION ON *.* TO 'admin'@'localhost' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

It looks like, that the database connection works fine. And indeed, it does - plesk is working, but I just can't update it.
plesk-restart works as well, but throws alot of errors

ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)

Any other idea for that problem? Is the password maybe deposited somewhere in any file except in ".psa.shadow"?


Thanks in advance!

Check this article - http://kb.parallels.com/116916

 

[IgorG]

Have you tried to use autoinstaller from http://www.parallels.com/products/plesk/download/ for upgrade?

 

[ErlandL]

hey,

just tried it but also with errors.

Stopping psa... done
Stopping sw-cp-serverd: sw-cp-server.
Starting psa... Starting Plesk engine pool manager: sw-engine-fpm.
done
Starting xinetd service... done
Starting sw-cp-server service... done
Starting mysql service... done
Trying to connect to MySQL... Failed to connect to MySQL: ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
Trying to start service mysql... /usr/sbin/mysqld (pid 11812) is running...
done
Trying to establish test connection... ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
[...]
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
failed

ERROR while trying to establish test connection
Check the error reason(see log file: /tmp/plesk_11.5.30_reset_instance_data.log), fix and try again

Starting bind9 service... done
Starting postgresql service... not installed
Starting spamassassin service... done
Plesk: Starting Mail Server... already started
Starting psa... Starting Plesk engine pool manager: sw-engine-fpm.
done
***** problem report *****
ERROR while trying to establish test connection
Check the error reason(see log file: /tmp/plesk_11.5.30_installation.log), fix and try again
Synchronizing the Debian APT package index files...

ERROR: An error occurred during performing of installation PREP actions (see log for details). Installation was rolled back.
Warning! Not all packages were installed.
Please check if your system services are operable.
Please resolve this issue and try installing the packages again.
If you cannot resolve the issue on your own, contact product technical support for assistance.

Maybe it helps, when I tell you that I got the message

ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)

60 times!

greetings.

 

[IgorG]

I can just suggest you contact Support Team in this case. They will check and fix it directly on your server.

 

[ErlandL]

I am not directly a parallels customer. do i still get help?

 

[ErlandL]

I am not directly a parallels customer. do i still get help?

is it possible????

 

[IgorG]

You can buy Per Incident Support here - http://www.parallels.com/store/support/plesk/linux/