Error during auto-update

[pook]

logg
Autoinstaller 3.3.2 (build at 2008-07-10 09:20 svn rev. 0) started at (timezone CET) Sun Aug 24 21:27:18 2008
Command line args: /usr/local/psa/admin/bin/autoinstaller --enable-xml-output --source-type=plesk --select-release-id=PLESK_8_6_0 [email protected] --install-component=base --install-component=java --install-component=spamassassin --install-component=docs --install-component=backup-ded --install-component=api --install-component=pmm --install-component=psa-firewall --install-component=cs-gs --install-component=psa-vpn --install-component=battlefield --install-component=psa-fileserver --install-component=watchdog --install-component=asp --install-component=mailman --install-component=postgresql --install-component=rblsmtpd --install-component=mod_python --install-component=drweb --install-component=ppwse --target=/root/psa

===> Installing rbash
Checking that /bin/rbash registered as login shell...
/bin/rbash is already registered as login shell

Trying to restart service mysql... Restarting service MySQL
Shutting down service MySQL ..failed
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.0.build86080722.00_upgrade.080824.21.33.log), fix and try again

Aborting...

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

when i select domain there is such an error


ERROR: PleskMainDBException
MySQL query failed: Unknown column 'guid' in 'field list'

0: /usr/local/psa/admin/plib/common_func.php3:250
db_query(string 'select `id`,`name`,`displayName`,`cr_date`,`status`,`dns_zone_id`,`htype`,`cl_id`,`limits_id`,`params_id`,`cert_rep_id`,`real_size`,`guid` from domains where `id`=2')
1: /usr/local/psa/admin/plib/class.Table.php:180
Table->select()
2: /usr/local/psa/admin/plib/class.Domain.php:147
Domain->fetchAttrsFromTable_()
3: /usr/local/psa/admin/plib/class.Domain.php:97
Domain->Domain(integer '2')
4: /usr/local/psa/admin/plib/class.PhDomain.php:77
PhDomain->PhDomain(integer '2')
5: /usr/local/psa/admin/plib/common_func.php3:2930
objectMaker(string 'PhDomain', integer '2')
6: /usr/local/psa/admin/auto_prepend/auth.php3:325

what now ?

 

[kbechtold]

Yes, what now? I have the same problem...

Is it possible, to re-run the update? What is about a rollback? Is that possible?

Thank you!

Klaus

...
Installing the package psa-hotfix3-8.6.0-suse10.2.build86080824.12.i586, psa-8.6.0-suse10.2.build86080722.01.i586, psa-libpam-plesk-8.6.0-suse10.2.build86080722.01.i586, psa-locale-base-en-US-8.6.0-suse10.2.build86080722.01.noarch, psa-api-8.6.0-suse10.2.build86080824.12.noarch, plesk-skins-8.6.0-0.97326.noarch, psa-updates-8.6.0-suse10.2.build86080824.12.noarch, psa-backup-manager-8.6.0-suse10.2.build86080824.12.i586, psa-manual-custom-skin-guide-8.6.0-suse10.2.build86080722.01.noarch, psa-migration-manager-8.6.0-suse10.2.build86080824.12.i586, psa-api-rpc-8.6.0-suse10.2.build86080824.12.noarch, psa-awstats-configurator-1.0.0-suse10.2.build86080722.01.noarch
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 create temporary database storage... done
Trying to upgrade persistent database storage... done

Trying to start MySQL server...
===> Checking for the necessary system accounts
Checking for the system groups and users necessary for MySQL...
Checking for the group 'mysql'...
Group 'mysql' already exists

Checking for the user 'mysql'...
User 'mysql' already exists

Checking for the system groups and users necessary for admin server...
Checking for the group 'psaadm'...
Group 'psaadm' already exists

Checking for the user 'psaadm'...
User 'psaadm' already exists

Checking for the group 'psaserv'...
Group 'psaserv' already exists

Checking for the group 'psaserv'...
Trying to add supplementary group 'psaserv' for user 'wwwrun'... already there
Checking for the group 'psaserv'...
Trying to add supplementary group 'psaserv' for user 'psaftp'... already there
Checking for the group 'psaserv'...
Trying to add supplementary group 'psaserv' for user 'psaadm'... already there
Checking for the group 'psacln'...
Group 'psacln' already exists

Checking for the system groups and users necessary for Apache...
Checking for the group 'www'...
Group 'www' already exists

Checking for the user 'wwwrun'...
User 'wwwrun' already exists

Trying to start MySQL server... Trying to establish test connection... connected
done
===> Preparing upgrade
Trying to backup MySQL database... done
MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.dump.gz
Stopping Plesk... done
Checking that /usr/local/psa/bin/chrootsh registered as login shell...
/usr/local/psa/bin/chrootsh already registered as a login shell

Stopping Plesk... done
Trying to register service xinetd... using /sbin/insserv
done
Setting the default locale
The default locale is set to en-US (ENGLISH, UNITED STATES)
config updated
===> Updated /etc/psa/psa.conf


===> Installing rbash
Checking that /bin/rbash registered as login shell...
/bin/rbash is already registered as login shell

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.2.build86080722.01_upgrade.080911.07.04.log), fix and try again

Aborting...

error: %post(psa-8.6.0-suse10.2.build86080722.01.i586) scriptlet failed, exit status 1
Trying to install PAM module... done
Trying to replace files and set up right permissions... 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.


---
Plesk autoinstaller.



######################################################


Here is the content of the logfile (/tmp/psa_8.6.0_suse10.2.build86080722.01_upgrade.080911.07.04.log):

START psa-8.6.0-suse10.2.build86080722.01 upgrading AT Thu Sep 11 07:04:26 CEST 2008
Trying to register service xinetd... using /sbin/insserv
done
Setting the default locale
The default locale is set to en-US (ENGLISH, UNITED STATES)


===> Installing rbash
Checking that /bin/rbash registered as login shell...
/bin/rbash
/bin/rbash is already registered as login shell

Trying to restart service mysql... Checking for service MySQL: ..running
done
===> Installing psa database
Trying to start MySQL server... Checking for service MySQL: ..running
Trying to define valid mysql credentials... Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
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-suse10.2.build86080722.01 upgrading AT Thu Sep 11 07:04:34 CEST 2008