Sure,
this line contains the user and password for the user cloud, I also
changed the password for the user root
cloudstack-setup-databases cloud:Password1@localhost
--deploy-as=root:Password1
here are the instructions to change the password for root
1.- after installing mysql runs this (sudo mysql_secure_installation)
running this will ask you for root password, press (enter) because there
is no password at the moment then it will ask you if you want to change
the root password, press y (remember the password you are going to use)
and for the following questions press y
2.- service mysql restart
3.- mysql -u root -p (this line will allow you to connect to mysql and
it will ask you for root password )
4.- run the following lines
GRANT ALL PRIVILEGES ON *.* TO 'cloud'@'%';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
FLUSH PRIVILEGES;
quit
5.- service mysql restart
6.- ready to run this line
cloudstack-setup-databases cloud:(any password you want to use, this
will be encrypted and saved in db.properties)@localhost
--deploy-as=root:*(here use the password for mysql root)*
*7.- run the rest of you process
*
**On 5/8/2020 8:46 AM, Jisha Ashokan wrote:
Thank you, but the password is encrypted in
/etc/cloudstack/management/db.properties . Can you please tell me how did you
change the password?
Thank you,
On 2020/05/08 11:55:38, Luis <lmartinez...@yahoo.com.INVALID> wrote:
I had the same problem and it may be because the user doesn't have the correct
privileges to the database. You have to login to the database and grant the
user access to the database.
Sent from Yahoo Mail on Android
On Fri, May 8, 2020 at 2:23 AM, Jisha Ashokan<jishaas...@gmail.com> wrote: Hello,
After installing Cloudstack,
IP:8080/client/
gives HTTP ERROR 503
Problem accessing /client/. Reason: Service Unavailable
Tried restarting using
service cloudstack-management restart
Accessing the URL, and
grep -i -E 'error|exception'
/var/log/cloudstack/management/management-server.log gives
----------------------
2020-05-08 10:46:21,300 WARN [o.a.c.s.m.c.ResourceApplicationContext]
(main:null) (logid:) Exception encountered during context initialization -
cancelling refresh attempt:
org.springframework.context.ApplicationContextException: Failed to start bean
'cloudStackLifeCycle'; nested exception is
com.cloud.utils.exception.CloudRuntimeException: Unable to acquire lock to
check for database integrity.
org.springframework.context.ApplicationContextException: Failed to start bean
'cloudStackLifeCycle'; nested exception is
com.cloud.utils.exception.CloudRuntimeException: Unable to acquire lock to
check for database integrity.
Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to acquire
lock to check for database integrity.
2020-05-08 11:28:04,678 ERROR [c.c.u.d.DbUtil] (main:null) (logid:) GET_LOCK()
throws exception
java.sql.SQLException: Operation not allowed for a result set of type
ResultSet.TYPE_FORWARD_ONLY.
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
2020-05-08 11:28:04,684 WARN [o.a.c.s.m.c.ResourceApplicationContext]
(main:null) (logid:) Exception encountered during context initialization -
cancelling refresh attempt:
org.springframework.context.ApplicationContextException: Failed to start bean
'cloudStackLifeCycle'; nested exception is
com.cloud.utils.exception.CloudRuntimeException: Unable to acquire lock to
check for database integrity.
org.springframework.context.ApplicationContextException: Failed to start bean
'cloudStackLifeCycle'; nested exception is
com.cloud.utils.exception.CloudRuntimeException: Unable to acquire lock to
check for database integrity.
Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to acquire
lock to check for database integrity.
----------------------
Please help.