Re: Problem accessing /client/ - Service Unavailable
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, 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 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, 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 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 > > > > () 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 > 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 > > > > > che
Re: Problem accessing /client/ - Service Unavailable
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 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, 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 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 > > > () 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 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
Re: Problem accessing /client/ - Service Unavailable
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, 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 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 > > () 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 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.except
Re: Problem accessing /client/ - Service Unavailable
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 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 > 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 > () 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 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 > > 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 acqui
Re: Problem accessing /client/ - Service Unavailable
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 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 () 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 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 > 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. > >
Re: Problem accessing /client/ - Service Unavailable
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 () 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 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 > 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. > >> > >> > >> >
Re: Problem accessing /client/ - Service Unavailable
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 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 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.
Re: Problem accessing /client/ - Service Unavailable
Now, I see this error : Caused by: com.cloud.utils.exception.CloudRuntimeException: cleanupForServer:Exception:cleanupForServer:Exception:Table 'cloud.op_lock' doesn't exist Caused by: com.cloud.utils.exception.CloudRuntimeException: cleanupForServer:Exception:Table 'cloud.op_lock' doesn't exist Caused by: java.sql.SQLSyntaxErrorException: Table 'cloud.op_lock' doesn't exist at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) However, the table op_lock exists. --- | op_host_capacity | | op_host_transfer | | op_host_upgrade | | op_it_work | | op_lock | | op_networks | | op_nwgrp_work --- On 2020/05/08 12:50:36, Jisha Ashokan wrote: > Hello, > > Why are these showing different? > > grep password /etc/cloudstack/management/db.properties > db.cloud.password=ENC(UXU8b795z8qG6w8Q3/06tk5kjuDhCy4l) > db.usage.password=ENC(lfGEk0FBmq1HoScapNcRxXMX+nTGAZIf) > db.simulator.password=cloud > > > > On 2020/05/08 06:19:28, Jisha Ashokan 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. > > > > >
Re: Problem accessing /client/ - Service Unavailable
Hello, Why are these showing different? grep password /etc/cloudstack/management/db.properties db.cloud.password=ENC(UXU8b795z8qG6w8Q3/06tk5kjuDhCy4l) db.usage.password=ENC(lfGEk0FBmq1HoScapNcRxXMX+nTGAZIf) db.simulator.password=cloud On 2020/05/08 06:19:28, Jisha Ashokan 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. > >
Re: Problem accessing /client/ - Service Unavailable
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 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 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. > > >
Re: Problem accessing /client/ - Service Unavailable
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 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.