You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by Jisha Ashokan <ji...@gmail.com> on 2020/05/08 06:19:28 UTC
Problem accessing /client/ - Service Unavailable
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
Posted by welly sunardy <we...@gmail.com>.
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, <ji...@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 <we...@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, <ji...@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 <lm...@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<
> > > nicovazquez90@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
> > > > (<lm...@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 <lm...@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<
> > > jishaashok@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.
> > > > > >>
> > > > > >>
> > > > > >>
> > > > >
> > > >
> > >
> >
>
Re: Problem accessing /client/ - Service Unavailable
Posted by Jisha Ashokan <ji...@gmail.com>.
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 <we...@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, <ji...@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 <lm...@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<
> > nicovazquez90@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
> > > (<lm...@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 <lm...@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<
> > jishaashok@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.
> > > > >>
> > > > >>
> > > > >>
> > > >
> > >
> >
>
Re: Problem accessing /client/ - Service Unavailable
Posted by welly sunardy <we...@gmail.com>.
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, <ji...@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 <lm...@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<
> nicovazquez90@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
> > (<lm...@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 <lm...@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<
> jishaashok@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.
> > > >>
> > > >>
> > > >>
> > >
> >
>
Re: Problem accessing /client/ - Service Unavailable
Posted by Jisha Ashokan <ji...@gmail.com>.
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 <lm...@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<ni...@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
> (<lm...@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 <lm...@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<ji...@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.
> > >>
> > >>
> > >>
> >
>
Re: Problem accessing /client/ - Service Unavailable
Posted by Luis <lm...@yahoo.com.INVALID>.
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<ni...@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
(<lm...@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 <lm...@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<ji...@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.
> >>
> >>
> >>
>
Re: Problem accessing /client/ - Service Unavailable
Posted by Nicolas Vazquez <ni...@gmail.com>.
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
(<lm...@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 <lm...@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<ji...@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.
> >>
> >>
> >>
>
Re: Problem accessing /client/ - Service Unavailable
Posted by Luis Martinez <lm...@yahoo.com.INVALID>.
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 <lm...@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<ji...@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.
>>
>>
>>
Re: Problem accessing /client/ - Service Unavailable
Posted by Jisha Ashokan <ji...@gmail.com>.
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 <lm...@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<ji...@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.
>
>
>
Re: Problem accessing /client/ - Service Unavailable
Posted by Luis <lm...@yahoo.com.INVALID>.
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<ji...@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.
Re: Problem accessing /client/ - Service Unavailable
Posted by Jisha Ashokan <ji...@gmail.com>.
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 <ji...@gmail.com> 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 <ji...@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.
> >
> >
>
Re: Problem accessing /client/ - Service Unavailable
Posted by Jisha Ashokan <ji...@gmail.com>.
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 <ji...@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.
>
>