i have fixed it. follow the post: https://cwiki.apache.org/confluence/display/CLOUDSTACK/Management+Controller+Failure+and+Replacement
before i did not purge old cloudstack, will have above issue. my another question is that how Cloudstack working with mysql, i found that has encrypted the communication. such as: db.properties 2013/8/27 不坏阿峰 <onlydeb...@gmail.com>: > can not run, require password. while put password, can run. >>>> > Error: > ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using > password: NO) > > i mention that after i upgrade from 4.0.2 to 4.1.1, it's ok, work fine > and i create VPC ,vpn and etc. i have run one week. so i want can > recover back. > > thanks. > > > > 2013/8/27 Travis Graham <t...@tgraham.us>: >> Since you are on 4.1.1, try this: >> >> cloudstack-setup-databases cloud:password@localhost --deploy-as=root -i >> 192.168.230.2 >> >> Remove the password for your --deploy-as= >> >> >> Travis >> >> >> On Aug 26, 2013, at 1:00 PM, 不坏阿峰 <onlydeb...@gmail.com> wrote: >> >>> Cloudstack 4.1.1 (upgrade from 4.0.2) >>> >>> i want to try back and recovery Database.after than i can not login >>> >>> what i did >>> (1)service cloudstack-management stop >>> (2)mysqldump -u root -p cloud > cloudstack-backup.sql >>> (3)cloudstack-setup-databases cloud:password@localhost \ >>> --deploy-as=root:password \ >>> -i 192.168.230.2 >>> (4)mysqldump -u root -p cloud < cloudstack-backup.sql >>> also try way from phpmyadmin >>> (5)cloudstack-setup-management >>> (6) service cloudstack-management start >>> >>> i know i did a very very stupid thing~~~~~.. pls help me to recovery back. >>> >>> Thanks a lot. >>> >>> when i do this, i can login, but no old config. >>> # cloudstack-setup-databases cloud:password@localhost \ >>> --deploy-as=root:password \ >>> -i 192.168.230.2 >>> >>> >>> ###### some erro when start, but service is running ## >>> >>> 2013-08-26 23:52:24,807 DEBUG [utils.script.Script] (Timer-1:null) >>> Classpath resource: >>> file:/usr/share/cloudstack-management/webapps/client/WEB-INF/classes/scripts/vm/systemvm/injectkeys.sh >>> 2013-08-26 23:52:24,807 DEBUG [utils.script.Script] (Timer-1:null) >>> Absolute path = >>> /usr/share/cloudstack-management/webapps/client/WEB-INF/classes/scripts/vm/systemvm/injectkeys.sh >>> 2013-08-26 23:52:24,840 DEBUG [utils.crypt.DBEncryptionUtil] >>> (Timer-1:null) Error while decrypting: Z/fQVh0fDAljHblryB00Kg== >>> >>> ###### when i want to login after recovery backup mysql ###### >>> >>> 2013-08-26 23:57:24,019 DEBUG [cloud.api.ApiServlet] >>> (catalina-exec-8:null) ===START=== 192.168.123.28 -- GET >>> command=listCapabilities&response=json&sessionkey=null&_=1377536243369 >>> 2013-08-26 23:57:24,072 DEBUG [cloud.api.ApiServlet] >>> (catalina-exec-8:null) ===END=== 192.168.123.28 -- GET >>> command=listCapabilities&response=json&sessionkey=null&_=1377536243369 >>> 2013-08-26 23:57:27,417 DEBUG [cloud.api.ApiServlet] >>> (catalina-exec-5:null) ===START=== 192.168.123.28 -- POST null >>> 2013-08-26 23:57:27,434 DEBUG [cloud.user.AccountManagerImpl] >>> (catalina-exec-5:null) Attempting to log in user: admin in domain 1 >>> 2013-08-26 23:57:27,435 DEBUG [server.auth.MD5UserAuthenticator] >>> (catalina-exec-5:null) Retrieving user: admin >>> 2013-08-26 23:57:27,463 DEBUG [utils.crypt.DBEncryptionUtil] >>> (catalina-exec-5:null) Error while decrypting: >>> 9pzEBgPyi47AVs1+H3s//innPpGJ094Ds17ytVDJiOzL81fpGa8n+TZkdUkNQSsfFQfK3IFOMguXR1pLZGHg79Vwekg1ljTmj1F+5qemLvX6P5Rv+ajEmajh0AjUVCY3 >>> 2013-08-26 23:57:27,476 ERROR [cloud.api.ApiServlet] >>> (catalina-exec-5:null) unknown exception writing api response >>> com.cloud.utils.exception.CloudRuntimeException: Caught: >>> com.mysql.jdbc.JDBC4PreparedStatement@371c1463: SELECT user.id, >>> user.username, user.password, user.firstname, user.lastname, >>> user.account_id, user.email, user.state, user.api_key, >>> user.secret_key, user.created, user.removed, user.timezone, >>> user.registration_token, user.is_registered, >>> user.incorrect_login_attempts, account.account_name, account.type, >>> account.domain_id, account.state FROM user INNER JOIN account ON >>> user.account_id=account.id WHERE user.username = _binary'admin' AND >>> account.domain_id = 1 AND user.removed IS NULL ORDER BY RAND() LIMIT >>> 1 >>> at >>> com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:417) >>> at >>> com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125) >>> at >>> com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:350) >>> at >>> com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125) >>> at >>> com.cloud.utils.db.GenericDaoBase.findOneIncludingRemovedBy(GenericDaoBase.java:860) >>> at >>> com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125) >>> at >>> com.cloud.utils.db.GenericDaoBase.findOneBy(GenericDaoBase.java:871) >>> at >>> com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125) >>> at >>> com.cloud.user.dao.UserAccountDaoImpl.getUserAccount(UserAccountDaoImpl.java:50) >>> at >>> com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125) >>> at >>> com.cloud.server.auth.MD5UserAuthenticator.authenticate(MD5UserAuthenticator.java:49) >>> at >>> com.cloud.user.AccountManagerImpl.getUserAccount(AccountManagerImpl.java:1912) >>> at >>> com.cloud.user.AccountManagerImpl.authenticateUser(AccountManagerImpl.java:1784) >>> at com.cloud.api.ApiServer.loginUser(ApiServer.java:766) >>> at com.cloud.api.ApiServlet.processRequest(ApiServlet.java:210) >>> at com.cloud.api.ApiServlet.doPost(ApiServlet.java:71) >>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) >>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) >>> at >>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) >>> at >>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >>> at >>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) >>> at >>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) >>> at >>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) >>> at >>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) >>> at >>> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:615) >>> at >>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) >>> at >>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) >>> at >>> org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java:889) >>> at >>> org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:744) >>> at >>> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:2282) >>> at >>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146) >>> at >>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) >>> at java.lang.Thread.run(Thread.java:679) >>> Caused by: org.jasypt.exceptions.EncryptionOperationNotPossibleException >>> at >>> org.jasypt.encryption.pbe.StandardPBEByteEncryptor.decrypt(StandardPBEByteEncryptor.java:981) >>> at >>> org.jasypt.encryption.pbe.StandardPBEStringEncryptor.decrypt(StandardPBEStringEncryptor.java:725) >>> at >>> com.cloud.utils.crypt.DBEncryptionUtil.decrypt(DBEncryptionUtil.java:65) >>> at >>> com.cloud.utils.db.GenericDaoBase.setField(GenericDaoBase.java:512) >>> at >>> com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125) >>> at >>> com.cloud.utils.db.GenericDaoBase.setField(GenericDaoBase.java:1686) >>> at >>> com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125) >>> at >>> com.cloud.utils.db.GenericDaoBase.toEntityBean(GenericDaoBase.java:1566) >>> at >>> com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125) >>> at >>> com.cloud.utils.db.GenericDaoBase.toEntityBean(GenericDaoBase.java:1527) >>> at >>> com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125) >>> at >>> com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:411) >>> ... 52 more >>> 2013-08-26 23:57:27,480 DEBUG [cloud.api.ApiServlet] >>> (catalina-exec-5:null) ===END=== 192.168.123.28 -- POST null >>
