[cloudstack] branch master updated: db: alter cloud.sslcerts fingerprint column from varchar(62) to text (#3132)

[ro...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

rohit pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/cloudstack.git


The following commit(s) were added to refs/heads/master by this push:
     new 2d37b74  db: alter cloud.sslcerts fingerprint column from varchar(62) to text (#3132)
2d37b74 is described below

commit 2d37b746b8e8d472c6d2a5e643c6cf74d7b4ef3b
Author: Matheus Marabesi <ma...@gmail.com>
AuthorDate: Thu Jan 17 08:56:22 2019 +0100

    db: alter cloud.sslcerts fingerprint column from varchar(62) to text (#3132)
    
    As described in the issue #3123 the certificate endpoint throws an exception when a request is made to create the certificate.
    Fixes #3123
---
 engine/schema/src/main/resources/META-INF/db/schema-41120to41200.sql | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/engine/schema/src/main/resources/META-INF/db/schema-41120to41200.sql b/engine/schema/src/main/resources/META-INF/db/schema-41120to41200.sql
index 78c512b..fb588e8 100644
--- a/engine/schema/src/main/resources/META-INF/db/schema-41120to41200.sql
+++ b/engine/schema/src/main/resources/META-INF/db/schema-41120to41200.sql
@@ -46,3 +46,6 @@ INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Storage', 'DEFAULT', 'Storag
 -- add KVM Guest OS mapping for Windows Server 2019
 INSERT IGNORE INTO `cloud`.`guest_os` (id, uuid, category_id, display_name, created) VALUES (276, UUID(), 6, 'Windows Server 2019 (64-bit)', now());
 INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, hypervisor_type, hypervisor_version, guest_os_name, guest_os_id, created, is_user_defined) VALUES (UUID(), 'KVM', 'default', 'Windows Server 2019', 276, now(), 0);
+
+-- changed fingerprint type to TEXT, it avoids db exception when creating the certificate issue #3123
+ALTER TABLE `cloud`.`sslcerts` MODIFY `fingerprint` TEXT;
\ No newline at end of file