Hi I agree that the script should be granting the privileges but for some reason is not happening. I have been installing CS more than 20 the las week and I always have to do the granting privileges, just saying but maybe that past is disabled in the script. I may be wrong.
Sent from Yahoo Mail on Android On Fri, May 8, 2020 at 10:34 AM, Nicolas Vazquez<nicovazque...@gmail.com> wrote: Hi Jisha, Just adding to Luis' comments, granting privileges shouldn't be necessary, the script should handle that for you. Please consider the steps in the documentation as well: http://docs.cloudstack.apache.org/en/latest/quickinstallationguide/qig.html#database-installation-and-configuration Regards, Nicolas Vazquez El vie., 8 may. 2020 a las 10:45, Luis Martinez (<lmartinez...@yahoo.com.invalid>) escribió: > 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. > >> > >> > >> >
