Plesk 8.4.0

pedrodj · Unread post by **pedrodj** » Sat May 03, 2008 5:19 am

I have updated to plesk 8.4.0 via updater on rhel3, but now my plesk doesn't work properly.

Error message is

Service is not available now, probably your Plesk is misconfigured.
Contact Your provider for details.

Internal Plesk error occurred: Components::componentUpdate() failed: Unable to exec utility packagemng: packagemng: Unable to connect to Plesk Database: Client does not support authentication protocol requested by server; consider upgrading MySQL client packagemng: Unable to connect to the mysql database

Can i resolve ?

pedrodj · Unread post by **pedrodj** » Sat May 03, 2008 6:39 am

I have tryed to set OLD_PASSWORD in /etc/my.cnf and

mysql> UPDATE mysql.user SET Password=OLD_PASSWORD('*******')
-> WHERE Host ='localhost' AND User ='root' ;

but nothing changed, except the error message when i TRY to use my Plesk Control Panel

"Service is not available now, probably your Plesk is misconfigured.
Contact Your provider for details.

Internal Plesk error occurred: Unable to connect to database: saved admin password is incorrect."

How Can i resolve ?

breun · Unread post by **breun** » Sat May 03, 2008 5:57 pm

There is no root account in MySQL on Plesk machines. Try 'admin' instead.

BerArt · Unread post by **BerArt** » Mon May 05, 2008 3:57 am

Seems like Parralels removed the update

I cannot find the bugfix list, the change log is not that interesting.

BerArt · Unread post by **BerArt** » Thu May 08, 2008 9:05 am

And it is back, anybody updated Plesk to 8.4 together with ALS? No problems? Is it possible to update Plesk via the ART repo?

exi1ed0ne · Unread post by **exi1ed0ne** » Thu May 08, 2008 1:34 pm

Lessons learned:

1) Don't be the first to run across the mine field. There is nothing THAT exciting in 8.4 that I could see from the release notes that would motivate me to install right away. (Still no postfix - WTF?)

2) Test before using in production. Test it again. Get a temp Plesk license key and test it out on a spare box. Make a backup you can do a bare metal restore from if the world goes to pot on you.

3) Wait a couple months. The forums will be filled with the bleeding edge folks with lots of advice and answers.

Patience and caution aren't sexy, but they save you from losing your hair.

Unread post by **scott** » Thu May 08, 2008 3:41 pm

There havent been any issues with ASL so far.

BerArt · Unread post by **BerArt** » Fri May 09, 2008 4:29 am

Thx! exi1ed0ne, nicely putt

and Thx! Scott for the update

jeremiah · Unread post by **jeremiah** » Sun May 11, 2008 10:18 pm

Holy cow - I just wrote quite a detailed post about my upgrade experience via plesk's gui autoupdater and lost it all due to session timeout... granted it took me a while... ah well basically...

i got the '...success report' email with the "Warning: packages conflict by files detected" message for every frickin package... then i got the '...error report' with the error

===> Installing psa database
Trying to start MySQL server... Trying to define valid mysql credentials... Trying to establish test connection... Trying to establish test connection... Trying to establish test connection... Trying to establish test connection... Trying to establish test connection... Trying to establish test connection... Trying to establish test connection... Trying to establish test connection...
ERROR while trying to establish test connection
Check the error reason(see log file: /tmp/psa_8.4.0_cos5.build84080425.19_upgrade.080511.13.57.log), fix and try again

checking the mentioned log i found this

===> Installing psa database
Trying to start MySQL server... mysqld (pid 3154) is running...
Trying to define valid mysql credentials... Trying to establish test connection... /usr/bin/mysql Ver 14.12 Distrib 5.0.51, for redhat-linux-gnu (x86_64) using readline 5.0
Copyright (C) 2002 MySQL AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Usage: /usr/bin/mysql [OPTIONS] [database]
-?, --help Display this help and exit.
-I, --help Synonym for -?

i'll spare you the mysql --help info but following that in the log i found

Trying to establish test connection... ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Trying to establish test connection... ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Trying to establish test connection... ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: NO)
Trying to establish test connection... ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
Trying to establish test connection... ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: NO)
Trying to establish test connection... ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Trying to establish test connection... Could not open required defaults file: /root/.my.cnf
Fatal error in defaults handling. Program aborted

[edit... yes /etc/my.cnf did exist]

and was briefly thrown off track by funny error in dmesg that read

grsec: From x.x.x.x: denied untrusted exec of /usr/local/psa/bin/psa-spamc by /bin/bash[sh:10409] uid/euid:110/110 gid/egid:31/31, parent /var/qmail/bin/qmail-local.moved[qmail-local.mov:10408] uid/euid:110/110 gid/egid:31/31

eventually tried creating /root/.my.cnf with contents of

[client]
user = admin
password = ..pleskpass..

the cd /root/psa/PSA_8.4.0/dist-rpm-CentOS-5-x86_64/base and did rpm -Uvh --force psa-8.4.0-cos5.build84080425.19.x86_64.rpm
which worked... although i then had to go through and manually install/upgrade several rpms after that, which were left out of the previous failed upgrade and --force (i assume).

just thought i'd throw this out there... all this after a 'fixed' release too:P

out of curiosity - any ideas what the hell happened here? that mysql thing seems really strange to me - not that that's indicative of anything

Highland · Unread post by **Highland** » Mon May 12, 2008 8:28 am

In addition to what exiledone said, it's also worth waiting for ART to put out the Plesk RPMs into the yum repo. Yum is 10x easier than the control panel, doesn't leave you guessing as to what your box is doing, and takes your server down for less time.

breun · Unread post by **breun** » Mon May 12, 2008 10:27 am

Running the command line autoinstaller does that as well.

exi1ed0ne · Unread post by **exi1ed0ne** » Mon May 12, 2008 12:07 pm

Just ran the update and only one gotcha. It looks like coldfusion doesn't like the version of apache I have on my CentOS 4 box:

Code: Select all

A dependency problem is found: required package httpd-2.0.52-38.ent.centos4.2.x86_64 conflicts with httpd-2.0.59-1.el4s1.8.el4.centos.x86_64

I don't use coldfusion on the box, so I could care less. This might be a show stopper for someone else though, so I thought I'd give a heads up.

Unread post by **scott** » Mon May 12, 2008 12:11 pm

Until it runs into a hard coded dependency it cant handle of course. I take full blame for the autoinstaller. It was my idea, and I am very very sorry to everyone about how it turned out.

I never ment for it to be a binary install quite like what it turned into, at the time what I wanted to emulate was Ximians installer (which starts as a shell script) that followed up with a yum predecessor called Red Carpet. The way [atomic] and ASL install now is the way it was supposed to be with Plesk.

redman18 · Unread post by **redman18** » Fri May 16, 2008 4:43 am

Any news about this case?
Is plesk 8.4 ready for trying to update some machines without worrying?
Or it is good to wait about month till install it?

BerArt · Unread post by **BerArt** » Fri May 16, 2008 4:51 am

We updated al (ASL) machines to Plesk 8.4 without any problems. Plesk 8.4 resolves 7 moderations (all from Horde/Imp) in ASL.