Update to 8.2 Mysql admin user failes

[hmiddelhoek]

Hi all,

Yesterday I updated Plesk to 8.2 (from 8.1) on a CentOS 4.4 installation. Well, I wish I hadn't started it... What a horror.

At first some MySQL tables were broken because of removal of some field (uid and ownership in the clients table, and server_version in the DatabaseServers table). I found the solution on this forum, really great! Plesk control panel is operating fine now, but the update isn't finished succesfully, too bad.

After the updater within plesk diddn't work I started to use /usr/local/psa/bin/autoinstaller. That works better for me, for the look and feel and the influence of the system administrator

Well, the script stopped at the IMP installation, the test connection (with MySQL) failed and the whole update cancels. I change MySQL user admin's password to setup and I thought the update should finish now. The IMP test connection was succesfull, but now another package couldn't setup a test connection, so I changed back the original admin password and yeah! this package also installs succesfully now.

This trick worked for about 8-10 packages (switching admin passwords), but now I'm stuck on psa-firewall_1.0.1_cos4. With neither passwords it will install and the whole update cancels. The error messages is:
...
Downloading the file PSA_8.2.0/update-rpm-CentOS-4.2-i386/sitebuilder_module-script-4.0.0-all.build07062700.noarch.rpm: skipped because of md5 checksum match.
Downloading the file PSA_8.2.0/update-rpm-CentOS-4.2-i386/sitebuilder_module-voting-4.0.0-all.build07062700.noarch.rpm: skipped because of md5 checksum match.
Downloading the file PSA_8.2.0/update-rpm-CentOS-4.2-i386/sitebuilder_module-flashintro-4.0.0-all.build07062700.noarch.rpm: skipped because of md5 checksum match.
Downloading the file PSA_8.2.0/update-rpm-CentOS-4.2-i386/sitebuilder_module-rssreader-4.0.0-all.build07062700.noarch.rpm: skipped because of md5 checksum match.
Downloading the file PSA_8.2.0/update-rpm-CentOS-4.2-i386/libxslt-shared-1.1.12-4.i386.rpm: skipped because of md5 checksum match.
Downloading the file PSA_8.2.0/update-rpm-CentOS-4.2-i386/php5-ioncube-php52-4.0-rhas4.07041615.i386.rpm: skipped because of md5 checksum match.
Downloading the file PSA_8.2.0/update-rpm-CentOS-4.2-i386/php5sb-5.2.1-10swsoft.i386.rpm: skipped because of md5 checksum match.
Starting installation of packages
Installing the package psa-firewall-1.0.1-cos4.build82070706.15.i586
Trying to establish test connection...
ERROR while trying to establish test connection
Check the error reason(see log file: /tmp/psa-firewall_1.0.1_cos4.build82070706.15_upgrade.070920.14.03.log), fix and try again

Aborting...

error: %pre(psa-firewall-1.0.1-cos4.build82070706.15.i586) scriptlet failed, exit status 1
error: install: %pre scriptlet failed (2), skipping psa-firewall-1.0.1-cos4.build82070706.15
ERROR: An error occurred during installation of packages.
Attention! Your software might be inoperable.
Please, contact product technical support.
----------------------------------------

# cat /tmp/psa-firewall_1.0.1_cos4.build82070706.15_upgrade.070920.14.03.log
START psa-firewall-1.0.1-cos4.build82070706.15 upgrading AT Thu Sep 20 14:03:45 CEST 2007
mysqld (pid 16553) is running...
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 while trying to establish test connection

Aborting...

STOP psa-firewall-1.0.1-cos4.build82070706.15 upgrading AT Thu Sep 20 14:03:45 CEST 2007
---------------------------------

I hope this makes any sense to someone. I'm really stuck in this.

Thanks in advance.
Hans Middelhoek

 

[Amin Taheri]

Remove any special characters from the admin pw and try again.

i had this problem for almost a week and I finally figured out it was becuase I had a # sign in my admin PW and mysql didnt like it.

 

[hmiddelhoek]

SOLVED!

Originally posted by HostingGuy
Remove any special characters from the admin pw and try again.

i had this problem for almost a week and I finally figured out it was becuase I had a # sign in my admin PW and mysql didnt like it.

Hi,

Thanks for your answer, it was really helpful! There was a # in the password, I changed the password and updates are installing without any problem now.

I need to say I could login to MySQL with the original password.

Regards.

 

[Amin Taheri]

Glad I could help.

 

[gecew]

hi
i have same problem but mysql password haven't special character i don't solved pls help

 

[Amin Taheri]

Hi, its not mysql password, its the admin password for the system.

cat /etc/psa/.psa.shadow

if you have a special character in your password it has been known to cause problems during upgrades in previous versions, although PSA has said they fixed the problem I dont always believe companies as they have a tendancy to "fib" a little here and there with what is in the pipeline or cant reproduce.

 

[breun]

Change the password through Plesk. The same password is used for Plesk's admin account and MySQL's admin account. If they don't match I believe there can and will be trouble. So better not change the password in the database directly.