error upgrading from 11.0 to 11.5

[reparaciononline]

Hi, i trying upgrade the plesk and after the process i can't login in panel in domain:8443, show:
ERROR: Zend_Db_Statement_Exception
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.ServiceNodeProperties' doesn't exist

0: Pdo.php:234
Zend_Db_Statement_Pdo->_execute(array)
1: Statement.php:300
Zend_Db_Statement->execute(array)
2: Abstract.php:479
Zend_Db_Adapter_Abstract->query(string 'DESCRIBE `ServiceNodeProperties`', array)
3: Abstract.php:238
Zend_Db_Adapter_Pdo_Abstract->query(string 'DESCRIBE `ServiceNodeProperties`', array)
4: Mysql.php:19
Db_Adapter_Pdo_Mysql->query(string 'DESCRIBE `ServiceNodeProperties`')
5: Mysql.php:169
Zend_Db_Adapter_Pdo_Mysql->describeTable(string 'ServiceNodeProperties', NULL null)
6: Abstract.php:835
Zend_Db_Table_Abstract->_setupMetadata()
7: Abstract.php:874
Zend_Db_Table_Abstract->_setupPrimaryKey()
8: Abstract.php:982
Zend_Db_Table_Abstract->info()
9: Select.php:100
Zend_Db_Table_Select->setTable(object of type Db_Table_Broker_ServiceNodeProperties)
10: Select.php:78
Zend_Db_Table_Select->__construct(object of type Db_Table_Broker_ServiceNodeProperties)
11: Abstract.php:1018
Zend_Db_Table_Abstract->select()
12: Abstract.php:1331
Zend_Db_Table_Abstract->fetchAll(string '`serviceNodeId` = '1'')
13: Abstract.php:110
Db_Table_Abstract->findByField(string 'serviceNodeId', string '1')
14: Dictionary.php:75
Db_Table_Dictionary->setId(string '1')
15: ServiceNodeProperties.php:36
Db_Table_Dictionary_ServiceNodeProperties->setId(string '1')
16: Dictionary.php:56
Db_Table_Dictionary->__construct(string '1')
17: ServiceNodeProperties.php:27
Db_Table_Dictionary_ServiceNodeProperties->__construct(string '1')
18: ServiceNode.php:56
Db_Table_Row_ServiceNode->properties()
19: Properties.php:75
Service_Node_Properties->_getPropertyValue(string 'synced', integer '0')
20: Unix.php:321
Service_Node_Components_Unix->_getPropertyValue(string 'synced', integer '0')
21: Properties.php:121
Service_Node_Properties->_isPropertiesSynced()
22: Properties.php:31
Service_Node_Properties->__construct(object of type Db_Table_Row_ServiceNode)
23: ServiceNode.php:185
Db_Table_Row_ServiceNode->components()
24: Integration.php:13
Billing_Integration::isLocalBillingInstalled()
25: Connection.php:421
Billing_Connection->isAvailable()
26: RelyingParty.php:18
isSsoEnabled()
27: auth.php3:200

I trying bootstrapper but not resolve this problem...
any idea?

 

[IgorG]

Try create psa.ServiceNodeProperties table manually with:

mysql> CREATE TABLE `ServiceNodeProperties` (`serviceNodeId` int(10) unsigned NOT NULL,`name` varchar(255) character set ascii NOT NULL,`value` blob NOT NULL,PRIMARY KEY (`serviceNodeId`,`name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

 

[reparaciononline]

thxs it's works but now i can't login to panel

Try create psa.ServiceNodeProperties table manually with:

mysql> CREATE TABLE `ServiceNodeProperties` (`serviceNodeId` int(10) unsigned NOT NULL,`name` varchar(255) character set ascii NOT NULL,`value` blob NOT NULL,PRIMARY KEY (`serviceNodeId`,`name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Thanks You, it's work , but now i can't login to plesk panel, show me error user and passwd, but i not change the pass!!!

 

[IgorG]

Do you mean login as admin? Try to change admin's password with using /usr/local/psa/admin/bin/ch_admin_passwd utility.

 

[reparaciononline]

thkxsU i do.
The last question, in migration i lost the redirection from http to https when i go to 8443 port. The apache show:

400 Bad Request

The plain HTTP request was sent to HTTPS port
nginx

 

[IgorG]

Could you please send me autoinstaller logs from /tmp/ in PM?

 

[DLopez]

I'm having the same problem.

Where you able to fix it ?

thkxsU i do.
The last question, in migration i lost the redirection from http to https when i go to 8443 port. The apache show:

400 Bad Request

The plain HTTP request was sent to HTTPS port
nginx

 

[sahinler]

Log

Could you please send me autoinstaller logs from /tmp/ in PM?

...
Component ...
Component ...
Component plesk/watchdog: mode up2date, installed_buildtime=1374665628, available_buildtime=1374665628
The following components were selected: 'plesk/awstats'
Gathering information about installed license key...
KeyUpdateChecker::doCheck: no components for check key update
ComponentsExamine::doPreExamine: no components for examination

Getting bootstrapper packages to installation list:
skip package 'pp11.5.30-bootstrapper-11.5.30-cos5.build115130724.18.x86_64' from component common - there is same or newer version of this package is installed (in system pp11.5.30-bootstrapper-11.5.30-cos5.build115130724.18.x86_64)
Following bootstrapper packages will be installed: (empty)
----------------

Getting packages to installation list:
Following packages will be installed: awstats-7.1.1-13052215.parallels.noarch
----------------
Check package set before installation
The following packages from not selected components will be installed because they are required by other components' packages you selected for installation:
Installing packages
~empty
Bootstrapper has finished action (exec time: 0 sec.): parent_name='PLESK_11_5_30', sequence='prep', stage='execute', sequence_order='-1', operation='install', exec_cmd='touch /tmp/pp-bootstrapper-mode.flag; touch /var/lock/parallels-panel-maintenance-mode.flag; rm -f /var/lock/parallels-panel-upgrade-failure.flag; :'
Traceback (most recent call last):
File "/usr/local/psa/bin/yum_install", line 186, in ?
main()
File "/usr/local/psa/bin/yum_install", line 181, in main
installer.perform(to_install, opts.remove)
File "/usr/local/psa/bin/yum_install", line 141, in perform
raise Exception("Scriptlet or other non-fatal errors occurred during transaction.")
Exception: Scriptlet or other non-fatal errors occurred during transaction.
~empty
Bootstrapper has finished action (exec time: 0 sec.): parent_name='PLESK_11_5_30', sequence='pkgs', stage='rollback', sequence_order='1', operation='install', exec_cmd='rm -f /tmp/pp-bootstrapper-mode.flag; rm -f /var/lock/parallels-panel-maintenance-mode.flag; touch /var/lock/parallels-panel-upgrade-failure.flag; :'
Execute command /usr/local/psa/admin/bin/send-error-report install
FileFetcher: get file (~empty)/PSA_11.5.30/plesk-11.5.30-cos5-x86_64.inf3
FileFetcher: get file (~empty)/SITEBUILDER_11.5.6/sitebuilder-11.5.6-rhall-all.inf3
FileFetcher: get file (~empty)/BILLING_11.5.30/billing-11.5.30-rhall-all.inf3
FileFetcher: get file (~empty)/MYSQL_5.5/mysql-5.5-rhel5-x86_64.inf3
FileFetcher: get file (~empty)/APACHE_2.2.24/apache-2.2.24-rh5-x86_64.inf3
FileFetcher: get file (~empty)/NGINX_1.5.0/nginx-1.5.0-cos5-x86_64.inf3
Error: Failed to run the Yum utility.
The Yum utility failed to install the required packages.
Attention! Your software might be inoperable.
Please, contact product technical support.

 

[IgorG]

Remove all third-party repos like epel, for example:

# mv /etc/yum.repos.d/epel.repo /etc/yum.repos.d/epel.repo.bak

and start upgrade again.

 

[sahinler]

I have this:

[root@myserver ~]# mv /etc/yum.repos.d/epel.repo /etc/yum.repos.d/epel.repo.bak
mv: not evaluated `/etc/yum.repos.d/epel.repo': any file ou repertory like that

I have these files:

atomic.repo
CentOS-Base.repo
CentOS-Debuginfo.repo
CentOS-Media.repo
CentOS-Vault.repo
dag.repo

 

[IgorG]

It was just example. There can be other files for third-party repos.

 

[sahinler]

I have these files:
atomic.repo
CentOS-Base.repo
CentOS-Debuginfo.repo
CentOS-Media.repo
CentOS-Vault.repo
dag.repo



If I try to update via Plesk Interface:
Installation started in background

Getting bootstrapper packages to installation list:
skip package 'pp11.5.30-bootstrapper-11.5.30-cos5.build115130724.18.x86_64' from component common - there is same or newer version of this package is installed (in system pp11.5.30-bootstrapper-11.5.30-cos5.build115130724.18.x86_64)
Following bootstrapper packages will be installed: (empty)
----------------

Getting packages to installation list:
Following packages will be installed: awstats-7.1.1-13052215.parallels.noarch
----------------
Check package set before installation
The following packages from not selected components will be installed because they are required by other components' packages you selected for installation:
Packages en cours d'installation
~empty
Bootstrapper has finished action (exec time: 0 sec.): parent_name='PLESK_11_5_30', sequence='prep', stage='execute', sequence_order='-1', operation='install', exec_cmd='touch /tmp/pp-bootstrapper-mode.flag; touch /var/lock/parallels-panel-maintenance-mode.flag; rm -f /var/lock/parallels-panel-upgrade-failure.flag; :'
Traceback (most recent call last):
File "/usr/local/psa/bin/yum_install", line 186, in ?
main()
File "/usr/local/psa/bin/yum_install", line 181, in main
installer.perform(to_install, opts.remove)
File "/usr/local/psa/bin/yum_install", line 141, in perform
raise Exception("Scriptlet or other non-fatal errors occurred during transaction.")
Exception: Scriptlet or other non-fatal errors occurred during transaction.
~empty
Bootstrapper has finished action (exec time: 0 sec.): parent_name='PLESK_11_5_30', sequence='pkgs', stage='rollback', sequence_order='1', operation='install', exec_cmd='rm -f /tmp/pp-bootstrapper-mode.flag; rm -f /var/lock/parallels-panel-maintenance-mode.flag; touch /var/lock/parallels-panel-upgrade-failure.flag; :'
Execute command /usr/local/psa/admin/bin/send-error-report install
Error: Echec de l'exécution de l'utilitaire yum.
L'utilitaire yum n'a pas réussi à installer les packs requis.
Attention ! Votre logiciel risque de ne pas fonctionner.
Veuillez contacter l'assistance technique du produit.

 

[IgorG]

Try to disable dag.repo and atomic.repo

 

[sahinler]

Yes, finally any problem on interface.

Another problem which I had received more than 20 messages since 10 hours about Dr.Web Updater


Hi. This is the qmail-send program at myserver.net.
I'm afraid I wasn't able to deliver your message to the following addresses.
This is a permanent error; I've given up. Sorry it didn't work out.

<[email protected]>:
Unable to forward message: mail server permanently rejected message (#5.3.0).

--- Below this line is a copy of the message.

Return-Path: <[email protected]>
Received: (qmail 7067 invoked by uid 100); 31 Jul 2013 11:30:01 +0200
Date: 31 Jul 2013 11:30:01 +0200
Message-ID: <[email protected]>
From: [email protected] (Cron Daemon)
To: [email protected]
Subject: Cron <drweb@ns226703> /opt/drweb/update.pl >>/var/log/drwebupdate.log
Content-Type: text/plain; charset=ISO-8859-1
Auto-Submitted: auto-generated
X-Cron-Env: <SHELL=/bin/sh>
X-Cron-Env: <HOME=/var/drweb>
X-Cron-Env: <PATH=/usr/bin:/bin>
X-Cron-Env: <LOGNAME=drweb>
X-Cron-Env: <USER=drweb>

ERROR: Dr.Web Updater: key file not found !
See Dr.Web Updater log file for details.