BryanMLima commented on PR #6812: URL: https://github.com/apache/cloudstack/pull/6812#issuecomment-1516808436
I got some time to work on this one again, and now I could understand what you meant @weizhouapache. I added the methods `migrateEncryptedAccountDetails` and `migrateEncryptedDomainDetails` to the `EncryptionSecretKeyChanger` class. I tested it in a local environment and it executed correctly, as presented below. @weizhouapache let me know if I missed anything in the migration process. ~~~ > cloudstack-migrate-databases -m password -d password -n password -f -v V1 Started database migration at Thu Apr 20 18:52:29 UTC 2023 Parsing db.properties file DB Secret key provided matched the key in db.properties INFO: Migrate properties with DB encryptor version: V1 Migrating db.properties.. Migrating db.properties Done. Migrating server.properties.. Skipping server.properties as password.encryption.type is null Begin Data migration Initialised Encryptors WARN [c.c.u.c.EncryptionSecretKeyChecker] (main:null) (logid:) Encryption already enabled, is check() called twice? INFO [c.c.u.d.T.Transaction] (main:null) (logid:) Is Data Base High Availiability enabled? Ans : false Begin migrate config values End migrate config values Begin migrate host details End migrate host details Beginning migration of account_details encrypted values End migrate config values Beginning migration of domain_details encrypted values End migrate config values Begin migrate cluster details End migrate cluster details Begin migrate image store details End migrate image store details Begin migrate storage pool details End migrate storage pool details Begin migrate storage pool details for ScaleIO End migrate storage pool details for ScaleIO Begin migrate user vm details End migrate user vm details Begin migrate user vm deploy_as_is details End migrate user vm deploy_as_is details Begin migrate image store url if protocol is cifs End migrate image store url if protocol is cifs Begin migrate storage pool path if pool type is SMB End migrate storage pool path if pool type is SMB Skipped table ucs_manager as there is no data in the table Skipped table vpn_users as there is no data in the table Skipped table sslcerts as there is no data in the table Begin migrate table vm_instance field vnc_password Done migrating database field vm_instance.vnc_password Skipped table external_stratosphere_ssp_credentials as there is no data in the table Begin migrate table keystore field key Done migrating database field keystore.key Skipped table passphrase as there is no data in the table Begin migrate table storage_pool field user_info Done migrating database field storage_pool.user_info Skipped table remote_access_vpn as there is no data in the table Begin migrate table user field secret_key Done migrating database field user.secret_key Skipped table oobm as there is no data in the table Skipped table s2s_customer_gateway as there is no data in the table End Data migration Successfully updated secret key(s) Finished database migration at Thu Apr 20 18:52:38 UTC 2023 ~~~ -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@cloudstack.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
