You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@cloudstack.apache.org by "Nicolas Lamirault (JIRA)" <ji...@apache.org> on 2013/04/25 17:42:15 UTC

[jira] [Comment Edited] (CLOUDSTACK-2194) Upgrade from 2.2.14 to 4.1.0 failed due to encryption error

    [ https://issues.apache.org/jira/browse/CLOUDSTACK-2194?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13641895#comment-13641895 ] 

Nicolas Lamirault edited comment on CLOUDSTACK-2194 at 4/25/13 3:41 PM:
------------------------------------------------------------------------

By adding a log here : 

diff --git a/server/src/com/cloud/configuration/dao/ConfigurationDaoImpl.java b/server/src/com/cloud/configuration/dao/ConfigurationDaoImpl.java
index fe5f5ae..69524dc 100644
--- a/server/src/com/cloud/configuration/dao/ConfigurationDaoImpl.java
+++ b/server/src/com/cloud/configuration/dao/ConfigurationDaoImpl.java
@@ -81,6 +81,7 @@ public class ConfigurationDaoImpl extends GenericDaoBase<ConfigurationVO, String
             List<ConfigurationVO> configurations = listIncludingRemovedBy(sc);
 
             for (ConfigurationVO config : configurations) {
+                s_logger.info("Config " + config.getName());
                if (config.getValue() != null)
                        _configs.put(config.getName(), config.getValue());
             }

we can see in Cloudstack logs :

2013-04-25 17:37:08,802 INFO  [cloudstack.discovery.ApiDiscoveryServiceImpl] (main:null) Api Discovery Service: Annotation, docstrings, api relation graph processed in 428.764924 ms
2013-04-25 17:37:09,216 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config account.cleanup.interval
2013-04-25 17:37:09,216 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config agent.lb.enabled
2013-04-25 17:37:09,216 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config agent.load.threshold
2013-04-25 17:37:09,216 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config alert.email.addresses
2013-04-25 17:37:09,217 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config alert.email.sender
2013-04-25 17:37:09,217 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config alert.smtp.host
2013-04-25 17:37:09,217 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config alert.smtp.password
2013-04-25 17:37:09,217 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config alert.smtp.port
2013-04-25 17:37:09,217 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config alert.smtp.useAuth
2013-04-25 17:37:09,217 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config alert.smtp.username
2013-04-25 17:37:09,217 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config alert.wait
2013-04-25 17:37:09,217 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config allow.public.user.templates
2013-04-25 17:37:09,217 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config allow.subdomain.network.access
2013-04-25 17:37:09,217 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config backup.snapshot.wait
2013-04-25 17:37:09,217 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config capacity.check.period
2013-04-25 17:37:09,218 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config capacity.skipcounting.hours
2013-04-25 17:37:09,218 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config check.pod.cidrs
2013-04-25 17:37:09,218 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config cloud.identifier
2013-04-25 17:37:09,239 DEBUG [utils.crypt.DBEncryptionUtil] (main:null) Error while decrypting: f8af0421-a349-487f-9a25-8f25540a2d2d

And we can find the entry into database :

mysql> select * from configuration where name = 'cloud.identifier';
+----------+----------+-------------------+------------------+--------------------------------------+------------------------------------+
| category | instance | component         | name             | value                                | description                        |
+----------+----------+-------------------+------------------+--------------------------------------+------------------------------------+
| Hidden   | DEFAULT  | management-server | cloud.identifier | f8af0421-a349-487f-9a25-8f25540a2d2d | A unique identifier for the cloud. |
+----------+----------+-------------------+------------------+--------------------------------------+------------------------------------+

                
      was (Author: nlamirault):
    By adding a log here : 

diff --git a/server/src/com/cloud/configuration/dao/ConfigurationDaoImpl.java b/server/src/com/cloud/configuration/dao/ConfigurationDaoImpl.java
index fe5f5ae..69524dc 100644
--- a/server/src/com/cloud/configuration/dao/ConfigurationDaoImpl.java
+++ b/server/src/com/cloud/configuration/dao/ConfigurationDaoImpl.java
@@ -81,6 +81,7 @@ public class ConfigurationDaoImpl extends GenericDaoBase<ConfigurationVO, String
             List<ConfigurationVO> configurations = listIncludingRemovedBy(sc);
 
             for (ConfigurationVO config : configurations) {
+                s_logger.info("Config " + config.getName());
                if (config.getValue() != null)
                        _configs.put(config.getName(), config.getValue());
             }

we can see in Cloudstack logs :

2013-04-25 17:37:08,802 INFO  [cloudstack.discovery.ApiDiscoveryServiceImpl] (main:null) Api Discovery Service: Annotation, docstrings, api relation graph processed in 428.764924 ms
2013-04-25 17:37:09,216 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config account.cleanup.interval
2013-04-25 17:37:09,216 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config agent.lb.enabled
2013-04-25 17:37:09,216 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config agent.load.threshold
2013-04-25 17:37:09,216 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config alert.email.addresses
2013-04-25 17:37:09,217 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config alert.email.sender
2013-04-25 17:37:09,217 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config alert.smtp.host
2013-04-25 17:37:09,217 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config alert.smtp.password
2013-04-25 17:37:09,217 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config alert.smtp.port
2013-04-25 17:37:09,217 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config alert.smtp.useAuth
2013-04-25 17:37:09,217 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config alert.smtp.username
2013-04-25 17:37:09,217 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config alert.wait
2013-04-25 17:37:09,217 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config allow.public.user.templates
2013-04-25 17:37:09,217 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config allow.subdomain.network.access
2013-04-25 17:37:09,217 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config backup.snapshot.wait
2013-04-25 17:37:09,217 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config capacity.check.period
2013-04-25 17:37:09,218 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config capacity.skipcounting.hours
2013-04-25 17:37:09,218 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config check.pod.cidrs
2013-04-25 17:37:09,218 INFO  [configuration.dao.ConfigurationDaoImpl] (main:null) Config cloud.identifier
2013-04-25 17:37:09,239 DEBUG [utils.crypt.DBEncryptionUtil] (main:null) Error while decrypting: f8af0421-a349-487f-9a25-8f25540a2d2d

And we can find the entry into database :

mysql> select name, value from configuration where name = 'cloud.identifier';
+------------------+--------------------------------------+
| name             | value                                |
+------------------+--------------------------------------+
| cloud.identifier | f8af0421-a349-487f-9a25-8f25540a2d2d |
+------------------+--------------------------------------+

                  
> Upgrade from 2.2.14 to 4.1.0 failed due to encryption error
> -----------------------------------------------------------
>
>                 Key: CLOUDSTACK-2194
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-2194
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the default.) 
>    Affects Versions: 4.1.0
>            Reporter: Nicolas Lamirault
>             Fix For: 4.1.0
>
>
> i'm trying to upgrade from 2.2.14 to 4.1.0.
> After setting encryption like that : 
> $> cloud-setup-encryption -m cloudstackprp -k cloudstackprp
> Preparing /etc/cloud/management/db.properties                                    [ OK ]
> Processing encryption ...                                                                    [ OK ]
> Finalizing setup ...                                                                              [ OK ]
> CloudStack has successfully setup Encryption
> I start Cloudstack. Output logs are here : http://pastebin.com/ZE99v90D
> db.properties content is :
>  $> grep -v "#" /etc/cloudstack/management/db.properties|sort
> cluster.node.IP=127.0.0.1
> cluster.servlet.port=9090
> db.awsapi.host=cloud-sql01-prp.cloud
> db.awsapi.name=cloudbridge
> db.awsapi.password=cloudstackprp
> db.awsapi.port=3306
> db.awsapi.username=cloudstackprp
> db.cloud.autoReconnect=true
> db.cloud.encryption.type=file
> db.cloud.encrypt.secret=ENC(dKaV+o5+JqtVi2tfo9xVn6eyUatFXwfZ)
> db.cloud.host=cloud-sql01-prp.cloud
> db.cloud.keyStore=
> db.cloud.keyStorePassword=
> db.cloud.maxActive=250
> db.cloud.maxIdle=30
> db.cloud.maxWait=10000
> db.cloud.minEvictableIdleTimeMillis=240000
> db.cloud.name=cloud
> db.cloud.password=ENC(IhnVBWyQT2ES/YNjPleAz6GXHoGrVsvq)
> db.cloud.poolPreparedStatements=false
> db.cloud.port=3306
> db.cloud.testOnBorrow=true
> db.cloud.testWhileIdle=true
> db.cloud.timeBetweenEvictionRunsMillis=40000
> db.cloud.trustStore=
> db.cloud.trustStorePassword=
> db.cloud.url.params=prepStmtCacheSize=517&cachePrepStmts=true
> db.cloud.username=cloudstackprp
> db.cloud.useSSL=false
> db.cloud.validationQuery=SELECT 1
> db.simulator.autoReconnect=true
> db.simulator.host=cloud-sql01-prp.cloud
> db.simulator.maxActive=250
> db.simulator.maxIdle=30
> db.simulator.maxWait=10000
> db.simulator.name=simulator
> db.simulator.password=cloudstackprp
> db.simulator.port=3306
> db.simulator.username=cloudstackprp
> db.usage.autoReconnect=true
> db.usage.host=cloud-sql01-prp.cloud
> db.usage.maxActive=100
> db.usage.maxIdle=30
> db.usage.maxWait=10000
> db.usage.name=cloud_usage
> db.usage.password=ENC(K57vTmW5CYCKY5P0B4NoeUchMwBPb1Z3)
> db.usage.port=3306
> db.usage.username=cloudstackprp
> region.id=1

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira