After upgrade to 8.6.0 PLESK will not start

[bplinson]

I started an upgrade to 8.6.0 this morning and now PLESK will not start.

I have the following logs. Can anyone provide a solution?

===> 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.6.0_fc7.build86080722.00_upgrade.081013.09.50.log), fix and try again

Aborting...

error: %post(psa-8.6.0-fc7.build86080722.00.x86_64) scriptlet failed, exit status 1
 Trying to install PAM module... done
 Trying to replace files and set up right permissions... done
 Trying to replace files and set up right permissions... done
 Trying to reconfigure Apache... done
 Trying to start MySQL server...  Trying to establish test connection... connected
done
 Trying to establish test connection... connected
 Trying to create temporary database storage... done
 Trying to upgrade persistent database storage... done
 Trying to start MySQL server...  Trying to establish test connection... connected
done
 Trying to establish test connection... connected
 Trying to upgrade persistent database storage... done
 Trying to start MySQL server...  Trying to establish test connection... connected
done
 Trying to establish test connection... connected
 Trying to create temporary database storage... done
 Trying to upgrade persistent database storage... done
ERROR: An error occurred during installation of packages.
Attention! Your software might be inoperable.
Please, contact product technical support.

AND

===> Installing psa database
 Trying to start MySQL server... mysqld (pid 11546) is running...
 Trying to define valid mysql credentials...  Trying to establish test connectio
n... /usr/bin/mysql  Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (x86_64) usi
ng readline 5.0


Default options are read from the following files in the given order:
/etc/my.cnf ~/.my.cnf /etc/my.cnf
The following groups are read: mysql client
The following options may be given as the first argument:
--print-defaults        Print the program argument list and exit
--no-defaults           Don't read default options from any options file
--defaults-file=#       Only read default options from the given file #
--defaults-extra-file=# Read this file after the global files are read

Variables (--variable-name=value)
and boolean options {FALSE|TRUE}  Value (after reading options)
--------------------------------- -----------------------------
auto-rehash                       TRUE
character-sets-dir                (No default value)
default-character-set             latin1
compress                          FALSE
database                          (No default value)
delimiter                         ;
vertical                          FALSE
force                             FALSE
named-commands                    FALSE
local-infile                      FALSE
no-beep                           FALSE
host                              (No default value)
html                              FALSE
xml                               FALSE
line-numbers                      TRUE
unbuffered                        FALSE
column-names                      FALSE
sigint-ignore                     FALSE
port                              0
prompt                            mysql>
quick                             FALSE
raw                               FALSE
reconnect                         FALSE
socket                            (No default value)
ssl                               FALSE
ssl-ca                            (No default value)
ssl-capath                        (No default value)
ssl-cert                          (No default value)
ssl-cipher                        (No default value)
ssl-key                           (No default value)
ssl-verify-server-cert            FALSE
table                             FALSE
debug-info                        FALSE
user                              admin
safe-updates                      FALSE
i-am-a-dummy                      FALSE
connect_timeout                   0
max_allowed_packet                16777216
net_buffer_length                 16384
select_limit                      1000
max_join_size                     1000000
secure-auth                       FALSE
show-warnings                     FALSE
 Trying to establish test connection... ERROR 1045 (28000): Access denied for us
er 'root'@'localhost' (using password: NO)
 Trying to establish test connection... ERROR 1045 (28000): Access denied for us
er 'root'@'localhost' (using password: NO)
 Trying to establish test connection... ERROR 1045 (28000): Access denied for us
er 'admin'@'localhost' (using password: NO)
 Trying to establish test connection... ERROR 1045 (28000): Access denied for us
er 'admin'@'localhost' (using password: YES)
 Trying to establish test connection... ERROR 1045 (28000): Access denied for us
er 'admin'@'localhost' (using password: NO)
 Trying to establish test connection... ERROR 1045 (28000): Access denied for us
er '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

ERROR while trying to establish test connection

Aborting...

STOP psa-8.6.0-fc7.build86080722.00 upgrading AT Mon Oct 13 09:50:38 GMT 2008

 

[bplinson]

Any help out there??

 

[ziba@]

Hi,

As you can see from the error message installation/upgrade failed because it could not connect to mysql.
You will need to rerun upgrade but before that you should make sure that mysql is running and apply one of the following solutions:
http://kb.odin.com/en/228 -- in case it was first time installation
http://kb.odin.com/en/1657 -- in case it was upgrade

After you perform this make sure that you can connect to mysql as user root with empty password (if you used 1-st KB article) or as admin with password stored in /etc/psa/.psa.shadow (if you used 2-nd KB article).

Next you need to rerun upgrade. To do this you should download Plesk distributive archive, unpack it and install all package from dist... directory with 'rpm -Uvh --force LIST_OF_PACKAGES' command.

 

[bplinson]

Thanks for the reply.

MySQL is up and all my websites that require MySQL are up and running.

I can connect to MySQL with the mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa as instructed in http://kb.odin.com/en/1657

I am totally lost with were to find the Plesk Distributive Archive. Also what is the the dist.... directory?

 

[bplinson]

ok....

I went to /etc/init.d and entered ./psa start to start plesk.

This is what I get

./psa start
Starting xinetd service...                                           done
Starting named service...                                            done
Starting mysqld service...                                           done
Starting qmail service...                                            done
Starting courier-imap service...                                     done
Starting postgresql service...                                       failed
Starting psa-spamassassin service...                                 done
Starting Plesk...                                                    done
Starting drwebd service...                                           failed

Look like I have a problem wit the drwebd service but it does not say what it is.

 

[bplinson]

I ran ./drwebd start and here is what I get....

Key file: /opt/drweb/drweb32.key - Key file not found!
A path to a valid license key file does not specified.
Plesk authorization failed: HTTP request error [7]
Error: Plesk Software not running.

What gives??? I has a key file before I attempted to upgrade! Don't know how to get the key file back since Plesk came with my leased server.

Can I deactivate drweb by editing a file? If so which one? I looked in the psa.conf and do not see where it starts this service up.

 

[levelup]

I am glad to read it here.

 

[ziba@]

Hello,

Can you clarify: it Plesk control panel running at all? Can you login and use it at https://IP_OF_SERVER:8443
If yes, then check recommendations from the following article to troubleshoot drweb error:
http://kb.odin.com/en/1658

If Plesk control panel itself in still unusable then you should rerun upgrade:
1. Download Plesk distributive:
http://download1.parallels.com/Ples...sa-8.6.0-fc7.build86080925.19.i586.rpm.tar.gz

2. Extract this archive and reinstall all packages from dist-rpm-FedoraCore-7-i386/base/ using rpm -Uvh --force

Also before running upgrade check that you do not have any custom options in my.cnf or mysql startup script because in upgrade log I can also see the following error:
==============
Trying to establish test connection... Could not open required defaults file: /
root/.my.cnf
Fatal error in defaults handling. Program aborted
==============

If file /root/my.cnf exists, make sure mysql user has enough permissions to read this file.
You can also check the following threads for similar mysql errors:
http://bugs.mysql.com/bug.php?id=20597
http://bugs.mysql.com/bug.php?id=10940
http://forums.fedoraforum.org/archive/index.php/t-67615.html