Ho Jisha, Downgrade to version 5.1.x With command
# yum downgrade mysql-connector-java Regards, Welly On Sun, 10 May 2020, 3:40 pm Jisha Ashokan, <jishaas...@gmail.com> wrote: > Hello, > > To which version should it be downgraded to? > > Can you please give me the steps to do it as well? > > Thank you. > > On 2020/05/09 13:41:37, welly sunardy <welly.em...@gmail.com> wrote: > > 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. > > > > > >> > > > > > >> > > > > > >> > > > > > > > > > > > > > > >