Problem 8.4 => 8.6. Websites/Email still working. Control panel not available

[mwarreyn]

Hello everybody,

today I tried to upgrade from 8.4 to 8.6.
Websites and Email are still working. But I cannot connect to the Plesk control panel.

/etc/init.d/psa restart tells me that Plesk is starting
PSA is down, performing full restart.
Starting xinetd service... done
Starting named service... done
Starting mysql service... done
Starting qmail service... done
Starting courier-imap service... done
Starting postgresql service... not installed
Starting psa-spamassassin service... done
Syntax OK
Starting Plesk... done
Starting drwebd service... not installed

Browsing to <ip>:8443 or telnet <ip> 8443 => no connection

netstat -pantlu tells me, that nobody is listening to 8443

in /usr/local/psa/admin/logs/error_log I found several entries like this
date [crit] (98)Address already in use: make_sock: could not bind to port 80

I also found this in the Plesk autoupdate failure report

Trying to restart service mysql... Restarting service MySQL
Shutting down service MySQL ..done
Starting service MySQL ..done
done
===> 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_suse10.1.build86080722.00_upgrade.080729.12.15.log), fix and try again

Aborting...

error: %post(psa-8.6.0-suse10.1.build86080722.00.x86_64) scriptlet failed, exit status 1
Trying to install PAM module... 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
ERROR: An error occurred during installation of packages.
Attention! Your software might be inoperable.
Please, contact product technical support.

Is there a chance to fix this problem?
Where can I find more information regarding this problem?
Can I downgrade to 8.4?

Please help me in finding the best solution to handle this
Thanks in advance

 

[mwarreyn]

I fixed it

Check if webservers are running
netstat -tulpe

Check Plesk status
/etc/init.d/psa status

If locked then
rm /var/lock/subsys/psa

Check contents of
/usr/local/psa/admin/conf/httpsd.conf
/usr/local/psa/admin/conf/httpsd.include
/usr/local/psa/admin/logs/httpsd.pid

My httpsd.conf was empty!
I used an old copy in the /usr/local/psa/admin/conf/ directory.

After
/etc/init.d/psa restart

/etc/init.d/psa status
told me, that the server was running

then I was able to connect with the browser under <ip>:8443

 

[mwarreyn]

MySQL-Errors after upgrade

After the upgrade the control panel had problems like this

MySQL query failed: Unknown column 'serial' in 'field list'

0: /usr/local/psa/admin/plib/common_func.php3:250

db_query(string 'select `id`,`name`,`displayName`,`email`,`status`,`type`,`ttl`,`ttl_unit`,`refresh`,`refresh_unit`,`retry`,`retry_unit`,`expire`,`expire_unit`,`minimum`,`minimum_unit`,`serial`,`serial_format` from dns_zone where `id`=6')

1: /usr/local/psa/admin/plib/class.Table.php:180

Table->select()

2: /usr/local/psa/admin/plib/dns/DNSZone.php:56

DNSZone->DNSZone(string '6')

3: /usr/local/psa/admin/plib/common_func.php3:2930

objectMaker(string 'DNSZone', string '6')

4: /usr/local/psa/admin/plib/dns/DNSManager.php:37

DNSManager::getDNSZone(string '6')

5: /usr/local/psa/admin/plib/class.Domain.php:682

Domain->getDNSZone()

6: /usr/local/psa/admin/plib/class.PhDomain.php:812

PhDomain->getWebmail()

7: /usr/local/psa/admin/plib/class.MailNamesList.php:53

MailNamesList->MailNamesList(object of type Client, object of type PhDomain, boolean true)

8: /usr/local/psa/admin/htdocs/domains/mail/mail_names.php:66


Reason: The database was not correctly upgraded

First I compared the databases using the database schema script
http://forum.swsoft.com/showthread.php?t=54256

Then I found this one
http://forum.swsoft.com/showthread.php?t=54210cd /root/psa/PSA_8.6.0/dist-rpm-SuSE-10.1-x86_64/base
rpm -Uvh * --force

Now everything seems to run just fine.

 

[mactator]

Thank you mwarreyn.

I had the same problem and got Plesk running again with your help.

Now i tried to update to 8.6 again with the following error:
Installing the package psa-8.6.0-suse10.2.build86080722.00.x86_64
package psa-8.6.0-suse10.2.build86080722.00 is already installed
ERROR: Unable to install the requested packages because of package dependency problems.

I downloaded the new version of the Plesk Autoupdater for my Linux version here
http://www.parallels.com/en/download/
and put it into
.../psa/admin/sbin/autoinstaller
.../psa/bin/autoinstaller
chmod 755 both files
(source: http://kb.odin.com/en/3543)

And tried again.
But the autoinstaller stoped with the same error.
Could this be the same error described here:
http://forum.swsoft.com/showthread.php?t=54277

And should i wait for a fixed autoinstaller or is it another problem.