You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by 不坏阿峰 <on...@gmail.com> on 2013/08/26 19:00:38 UTC
fail to login after recovery Cloud MySQL database.
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
Re: fail to login after recovery Cloud MySQL database.
Posted by 不坏阿峰 <on...@gmail.com>.
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 不坏阿峰 <on...@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, 不坏阿峰 <on...@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
>>
Re: fail to login after recovery Cloud MySQL database.
Posted by 不坏阿峰 <on...@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, 不坏阿峰 <on...@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
>
Re: fail to login after recovery Cloud MySQL database.
Posted by 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, 不坏阿峰 <on...@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