René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Database encryption engine migration script fails","articleBody":"##### ISSUE TYPE\r\n * Bug Report\r\n\r\n##### COMPONENT NAME\r\nDatabase encryption engine migration script\r\n\r\n\r\n##### CLOUDSTACK VERSION\r\n4.18.2.3\r\n\r\n\r\n##### CONFIGURATION\r\nDatabase with legacy cryptographic cipher (MD5/DES)\r\n\r\n\r\n##### OS / ENVIRONMENT\r\nCentos 7\r\n\r\n\r\n##### SUMMARY\r\nWhen migrating from the old database encryption scheme (MD5/DES 56-bit) to the new one (AES-GCM 256-bit) using the supplied script (/usr/bin/cloudstack-migrate-databases) from any of the managers; the migration process starts, but suddenly, when working on on the 'user_vm_deploy_as_is_details' table, we get an error and the process fails.\r\n\r\n\r\n##### STEPS TO REPRODUCE\r\n~~~\r\n# systemctl stop cloudstack-management cloudstack-usage\r\n# /usr/bin/cloudstack-migrate-databases -d oldDBKey -m oldMSKey -e newDBKey -n newMSKey -v V2\r\n...\r\n...\r\nData Migration failed. Reverting db.properties\r\n~~~\r\n\r\n\r\n##### EXPECTED RESULTS\r\nThe script should end without error. The database content is migrated using the new cipher and the configuration files are updated as needed.\r\n\r\n\r\n##### ACTUAL RESULTS\r\nThe database and configuration files remains untouched, the migration script fails with the following error:\r\n\r\n~~~\r\nUnable to update user_vm_deploy_as_is_details values due to: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'vm_instance.id = 20850 AND template_deploy_as_is_details.name = 'property-timezo' at line 1\r\nError during data migration\r\ncom.cloud.utils.exception.CloudRuntimeException: Unable to update user_vm_deploy_as_is_details values\r\n        at com.cloud.utils.crypt.EncryptionSecretKeyChanger.throwCloudRuntimeException(EncryptionSecretKeyChanger.java:794)\r\n        at com.cloud.utils.crypt.EncryptionSecretKeyChanger.migrateTemplateDeployAsIsDetails(EncryptionSecretKeyChanger.java:663)\r\n        at com.cloud.utils.crypt.EncryptionSecretKeyChanger.migrateData(EncryptionSecretKeyChanger.java:485)\r\n        at com.cloud.utils.crypt.EncryptionSecretKeyChanger.migratePropertiesAndDatabase(EncryptionSecretKeyChanger.java:343)\r\n        at com.cloud.utils.crypt.EncryptionSecretKeyChanger.main(EncryptionSecretKeyChanger.java:142)\r\nCaused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'vm_instance.id = 20850 AND template_deploy_as_is_details.name = 'property-timezo' at line 1\r\n        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)\r\n        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)\r\n        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)\r\n        at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)\r\n        at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003)\r\n        at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)\r\n        at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)\r\n        at com.cloud.utils.crypt.EncryptionSecretKeyChanger.migrateTemplateDeployAsIsDetails(EncryptionSecretKeyChanger.java:649)\r\n        ... 3 more\r\nData Migration failed. Reverting db.properties\r\n~~~\r\n","author":{"url":"https://github.com/detaras","@type":"Person","name":"detaras"},"datePublished":"2024-11-26T18:22:30.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":5},"url":"https://github.com/9979/cloudstack/issues/9979"}