Hi Jisha, Just checking if you have tried to downgrade the mysql-connector-java?
Regards, Welly On Sat, 9 May 2020, 9:29 pm Jisha Ashokan, <jishaas...@gmail.com> wrote: > Hi, > > I did everything you have told me, but http://IP:8080/client/ still gives > HTTP error. > > Can you please help? > > > On 2020/05/08 15:26:55, Luis <lmartinez...@yahoo.com.INVALID> wrote: > > 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. > > > >> > > > >> > > > >> > > > > > >