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 >
