• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Big problem after migration to 05/11/29

Status
Not open for further replies.
A

Achraf

Basic Pleskian
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.
Click to expand...

----
- 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
Click to expand...

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.
Click to expand...

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.
Click to expand...
see the log
 
Last edited:
# Rpm-q sw-sso | xargs rpm-e - nodeps - justdb
Click to expand...

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

# rpm -q sw-sso | xargs rpm -e --nodeps --justdb
 
IgorG said:
Are you sure that this command is correct? It should be:

# rpm -q sw-sso | xargs rpm -e --nodeps --justdb
Click to expand...

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
Click to expand...
 
Plesk use forum or KB articles search engine. bootstrapper repair procedure was mentioned a lot of times there.
 
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
Click to expand...
 
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....
 
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...
 
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
 
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]
 
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
 
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....
 
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 said:
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
Click to expand...

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.
 
Status
Not open for further replies.

Similar threads

D
Resolved After enabling MSMTP: sw-service unable to start
Replies
2
Views
876
dbitsch
D
A
Issue Problems with fail2ban
Replies
1
Views
57
Kaspar@Plesk
Kaspar@Plesk
Gerzam73
Question Help not unistall PHP 7.4
Replies
0
Views
797
Gerzam73
Gerzam73
A
Issue 502 bad gateway error after migrating to alma linux and updating plesk
Replies
8
Views
2K
Bitpalast
Bitpalast
LinqLOL
Resolved DKIM fails on RHEL7
Replies
2
Views
632
LinqLOL
LinqLOL
Back
Top