Big problem after migration to 05/11/29

[Achraf]

Big problem after migration to 5.11.29

OS CentOS 6.2 (Final)
Parallels Panel version 11.0.9 Update # 53

problem after migration to 5.11.29

during the migration process this message is displayed:
see Log Attached

Parallels Panel pre-upgrade check...

PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/sqlite3.so' - /usr/lib64/php/modules/sqlite3.so: undefined symbol: sqlite3_stmt_readonly in Unknown on line 0
WARNING: SSO start-up script has wrong execution priority. Please, check http://kb.parallels.com/en/112666 for more details.

----
- Now I can not enter on the panel or continue the migration and when I tried to solve the problem due to: http://kb.parallels.com/en/112666

# Rpm-q sw-sso | xargs rpm-e - nodeps - justdb

error: package package is not installed
error: package sw-sso is not installed
error: package is is not installed
error: package not is not installed
error: package installed is not installed

and when I want to run this command:
/usr/local/psa/admin/sbin/autoinstaller --select-release-current --upgrade-installed-components

this, message displayed:

Doing restart of Parallels Installer ...

BUSY: Update operation was locked by Reviews another update process.

After I installed SSO following:
1. download sw-sso package - "wget
2. remove installed package sw-sso - "rpm-e - nodeps sw-sso"
3. remove old certificates - "rm-f / etc / sso / * pem."
4. reinstall sw-sso package - "rpm-i sw-sso-2.12-12053113.noarch.rpm"


I restart the migration , an error message displayed:

Some errors occured during installation.

see the log

 

[IgorG]

# Rpm-q sw-sso | xargs rpm-e - nodeps - justdb

Are you sure that this command is correct? It should be:

# rpm -q sw-sso | xargs rpm -e --nodeps --justdb

 

[Achraf]

Are you sure that this command is correct? It should be:

# rpm -q sw-sso | xargs rpm -e --nodeps --justdb

Thinks for your answers,

after the execution of this order, I have not access to Installation and migration plesk program:
https://my/tld:8447
and also when I want to access the panel:
https://my.tld:8443
I wrote you the error message:

ERROR: Zend_Db_Statement_Exception
Niveau sup.
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 'DELETE FROM `ServiceNodeProperties` WHERE (name LIKE '%.synced')', array)
3: Abstract.php:238
Zend_Db_Adapter_Pdo_Abstract->query(string 'DELETE FROM `ServiceNodeProperties` WHERE (name LIKE '%.synced')', array)
4: Mysql.php:19
Db_Adapter_Pdo_Mysql->query(string 'DELETE FROM `ServiceNodeProperties` WHERE (name LIKE '%.synced')')
5: Abstract.php:663
Zend_Db_Adapter_Abstract->delete(string 'ServiceNodeProperties', string 'name LIKE '%.synced'')
6: Abstract.php:1184
Zend_Db_Table_Abstract->delete(string 'name LIKE '%.synced'')
7: ServiceNode.php:84
Db_Table_Row_ServiceNode->refreshProperties()
8: auth.php3:507

 

[IgorG]

Have you tried bootstrapper repair procedure?

 

[Achraf]

no I not recognize
please explain

 

[IgorG]

Plesk use forum or KB articles search engine. bootstrapper repair procedure was mentioned a lot of times there.

 

[Achraf]

Thinks ,

I'm already in the process of doing that

 

[Achraf]

the same problem after: http://kb.parallels.com/en/9266

Message in plesk panel:

ERROR: Zend_Db_Statement_Exception


SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.ServiceNodeProperties' doesn't exist

--------------------------------------------------------------------------------
0: Pdo.php:234Zend_Db_Statement_Pdo->_execute(array)
1: Statement.php:300Zend_Db_Statement->execute(array)
2: Abstract.php:479Zend_Db_Adapter_Abstract->query(string 'DELETE FROM `ServiceNodeProperties` WHERE (name LIKE '%.synced')', array)
3: Abstract.php:238Zend_Db_Adapter_Pdo_Abstract->query(string 'DELETE FROM `ServiceNodeProperties` WHERE (name LIKE '%.synced')', array)
4: Mysql.php:19Db_Adapter_Pdo_Mysql->query(string 'DELETE FROM `ServiceNodeProperties` WHERE (name LIKE '%.synced')')
5: Abstract.php:663Zend_Db_Adapter_Abstract->delete(string 'ServiceNodeProperties', string 'name LIKE '%.synced'')
6: Abstract.php:1184Zend_Db_Table_Abstract->delete(string 'name LIKE '%.synced'')
7: ServiceNode.php:84Db_Table_Row_ServiceNode->refreshProperties()
8: auth.php3:507

 

[Achraf]

any help !!!!!???

 

[GravuTrad]

I have the same problem after the same zend warning.

I have two recurrent old upgrade problems: two versions of php and old mysql password scheme problem....

 

[GravuTrad]

Urgent help, server is out cause upgrade. How to update olds passwords to new password scheme cause the plesk 11.0.9 upgrade seems to not doing it to all accounts and i still have t to 11.5.29 upgrade...and the bootstrapper is out cause this too...

 

[GravuTrad]

START Bootstrapper 11.5.29 repair AT Sun Jun 16 21:27:18 CEST 2013
***** problem report *****
Passwords for some MySQL users were not upgraded.
All MySQL DB users that may be used by Panel MUST have passwords in new 41-character format in order for Panel to function properly.
Currently following users have passwords in old format: billing@localhost, billing_7ce4@localhost, billing_c283@localhost, bug115166_88014@%, bug115166_20103@%, sparcool@%, smfnew@%, bug115166_18262@%, smf-fr@%, billing_003e@localhost, aspcomplete@%, aspcomplete@localhost, aspcsk@%, aspcsk@localhost, aspcss@%, aspcss@localhost, aspsession@%, aspsession@localhost, billing_6391@localhost, sitebuilder_db@localhost, billing_1d32@localhost, billing_4940@localhost.
Please ensure that MySQL server is not forced to use old password hashing algorithm and upgrade password format manually for users from the list above. Consult with MySQL server manual on detailed steps.
You may skip certain users if you are sure they weren't created and aren't used by Panel.
STOP Bootstrapper 11.5.29 repair AT Sun Jun 16 21:28:40 CEST 2013: PROBLEMS FOUND

 

[GravuTrad]

Exception: Failed to solve dependencies:
plesk-web-hosting conflicts with psa-php53-configurator

 

[GravuTrad]

List of records in [psa.hosting.dom_id] that miss a matching record in [psa.doma ins.id WHERE htype='vrt_hst']
69, 84
List of records in [psa.dom_param.dom_id] that miss a matching record in [psa.do mains.id]
69
List of records in [psa.hosting.sys_user_id] that miss a matching record in [psa .sys_users.id]
28, 42
List of records in [psa.DomainServices.dom_id] that miss a matching record in [p sa.domains.id]
84
Caught exception: MySQL query (SELECT id FROM dns_zone WHERE id<>1 and id not in (select dns_zone_id from domainaliases) failed: Table 'psa.domainaliases' doe sn't exist at running query "SELECT id FROM dns_zone WHERE id<>1 and id not in ( select dns_zone_id from domainaliases);"
Caught exception: MySQL query (SELECT id FROM dns_zone WHERE id<>1 and id not in (select dns_zone_id from domainaliases) failed: Table 'psa.domainaliases' doe sn't exist at running query "SELECT id FROM dns_zone WHERE id<>1 and id not in ( select dns_zone_id from domainaliases);"
ERROR: Table "domainaliases" is not found in database "psa"!
ERROR: Table "domainaliases" is not found in database "psa"!
ERROR: Table "domainaliases" is not found in database "psa"!
ERROR: Table "domainaliases" is not found in database "psa"!
List of records in [psa.Subscriptions.object_id WHERE object_type='domain'] that miss a matching record in [psa.domains.id WHERE parentDomainId=0 AND htype = 'v rt_hst' AND webspace_id=0]
130, 131, 133
List of records in [psa.domains.id WHERE parentDomainId=0 AND htype = 'vrt_hst' AND webspace_id=0] that miss a matching record in [psa.Subscriptions.object_id W HERE object_type='domain']
47, 53, 54, 56, 57, 59, 60, 63, 64, 66, 68, 70, 74, 79, 82, 83
List of records in [psa.Subscriptions.id] that miss a matching record in [psa.Pl ansSubscriptions.subscription_id]
2, 1, 5, 9, 3
List of records in [psa.smb_servicePermissions.id] that miss a matching record i n [psa.smb_servicePermissionAccounts.servicePermissionId]
1, 3
List of records in [psa.smb_apsPackagesCategories.packageId] that exceed N in 1: N (N=1) relation to [psa.smb_apsPackages.id]
36 [count in table psa.smb_apsPackages:1; count in table psa.smb_ap sPackagesCategories:3]
65 [count in table psa.smb_apsPackages:1; count in table psa.smb_ap sPackagesCategories:2]

 

[GravuTrad]

I have a table domain_aliases, not domainaliases....

 

[GravuTrad]

ERR (3) [panel]: Apache config (13714273260.06549200) generation failed: mkdir: cannot create directory `/var/www/vhosts/system/jkifu.com/conf': No such file or directory
mktemp: cannot create temp file /var/www/vhosts/system/jkifu.com/conf/13714273260.06549200_httpd.conf.sK5311: No such file or directory
Can not create temporary file

mkdir: cannot create directory `/var/www/vhosts/system/jkifu.com/conf': No such file or directory
mktemp: cannot create temp file /var/www/vhosts/system/jkifu.com/conf/13714273260.06549200_httpd.conf.sK5311: No such file or directory
Can not create temporary file

 

[GravuTrad]

This system folder is created but empty....

11.5.29 upgrader sucks...grrr....

I had to use 11.5.29 autoinstaller to have plesk working again, then using bootstrapper (on these things i had to remove some packages to have them working)

i had to recreate http://pleskhacker.com/all-tables/domains-all-tables/psa_domainaliases/ and http://pleskhacker.vinnward.net/psa-servicenodeproperties/

But i still have all this above grrr....

And no 11.5.29-psa.sql and 11.5.29-apsc.sql for the schema checker....

 

[GravuTrad]

I created them in the system folder but still this:

Details: 2013-06-17T03:09:22+02:00 ERR (3) [util_exec]: proc_close() failed
2013-06-17T03:09:40+02:00 ERR (3) [panel]: Apache config (13714313370.24148400) generation failed: Can not restart web server: Service /etc/init.d/httpd failed to start
Service /etc/init.d/httpd failed to start

Can not restart web server: Service /etc/init.d/httpd failed to start
Service /etc/init.d/httpd failed to start

 

[GravuTrad]

http://download1.parallels.com/Ples...inistrator-guide/index.htm?fileName=68806.htm

All this is not created for me by the upgrader...

 

[Nikolay.]

START Bootstrapper 11.5.29 repair AT Sun Jun 16 21:27:18 CEST 2013
***** problem report *****
Passwords for some MySQL users were not upgraded.
All MySQL DB users that may be used by Panel MUST have passwords in new 41-character format in order for Panel to function properly.
Currently following users have passwords in old format: billing@localhost, billing_7ce4@localhost, billing_c283@localhost, bug115166_88014@%, bug115166_20103@%, sparcool@%, smfnew@%, bug115166_18262@%, smf-fr@%, billing_003e@localhost, aspcomplete@%, aspcomplete@localhost, aspcsk@%, aspcsk@localhost, aspcss@%, aspcss@localhost, aspsession@%, aspsession@localhost, billing_6391@localhost, sitebuilder_db@localhost, billing_1d32@localhost, billing_4940@localhost.
Please ensure that MySQL server is not forced to use old password hashing algorithm and upgrade password format manually for users from the list above. Consult with MySQL server manual on detailed steps.
You may skip certain users if you are sure they weren't created and aren't used by Panel.
STOP Bootstrapper 11.5.29 repair AT Sun Jun 16 21:28:40 CEST 2013: PROBLEMS FOUND

This is not a fatal error for upgrader. This is a warning. Oh, fix that, it's not even upgrader error, but a warning from bootstrapper.sh repair.

Judging by your other posts you already managed to get mixed packages set and/or partially upgraded (or likely not upgraded at all) DB.

Did you even upgrade using newest autoinstaller? Upgrading manually by just installing new packages is not supported!

Where are error messages from your upgrade procedure?

Edit: P.S.: also, I suggest to avoid hijacking threads.