cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Travis Graham...@tgraham.us>
Subject Re: fail to login after recovery Cloud MySQL database.
Date Mon, 26 Aug 2013 17:04:52 GMT
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, 不坏阿峰 <onlydebian@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


Mime
View raw message