You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cloudstack.apache.org by Seif Eddine Jemli <se...@gmail.com> on 2014/06/23 23:41:49 UTC
Problem with Management server and connection to the databse
Hi everyone,
I am having a 404 error when trying to access *http://localhost:8080/client
<http://localhost:8080/client>, *this exception is in the
management-server.log
2014-06-23 20:43:26,899 INFO [c.c.u.d.T.Transaction] (main:null) Is Data
Base High Availiability enabled? Ans : false
2014-06-23 20:43:26,915 ERROR [c.c.u.d.Merovingian2] (main:null) Unable to
get a new db connection
*java.sql.SQLException: No suitable driver found for
jdbc:mysql://localhost:3306/cloud?*
autoReconnect=true&prepStmtCacheSize=517&cachePrepStmts=true
at java.sql.DriverManager.getConnection(DriverManager.java:596)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at
org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75)
at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1188)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
at
com.cloud.utils.db.TransactionLegacy.getStandaloneConnectionWithException(TransactionLegacy.java:204)
at com.cloud.utils.db.Merovingian2.<init>(Merovingian2.java:68)
at com.cloud.utils.db.Merovingian2.createLockMaster(Merovingian2.java:80)
at com.cloud.server.LockMasterListener.<init>(LockMasterListener.java:33)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:148)
at
org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:121)
at
org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:280)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1045)
what can be the problem?
thanks.
Re: Problem with Management server and connection to the databse
Posted by sebgoa <ru...@gmail.com>.
you are probably hitting the warning:
http://docs.cloudstack.apache.org/projects/cloudstack-installation/en/latest/installation.html#install-on-ubuntu
On Jun 23, 2014, at 11:54 PM, Ian Duffy <ia...@ianduffy.ie> wrote:
> Sounds like a missing mysql driver jar.
>
> Please see the following solution:
> http://blog.widodh.nl/2014/03/sql-connection-error-after-upgrade-to-cloudstack-4-3-0/
>
>
> On 23 June 2014 22:41, Seif Eddine Jemli <se...@gmail.com> wrote:
>
>> Hi everyone,
>>
>> I am having a 404 error when trying to access *
>> http://localhost:8080/client
>> <http://localhost:8080/client>, *this exception is in the
>> management-server.log
>>
>>
>> 2014-06-23 20:43:26,899 INFO [c.c.u.d.T.Transaction] (main:null) Is Data
>> Base High Availiability enabled? Ans : false
>> 2014-06-23 20:43:26,915 ERROR [c.c.u.d.Merovingian2] (main:null) Unable to
>> get a new db connection
>> *java.sql.SQLException: No suitable driver found for
>> jdbc:mysql://localhost:3306/cloud?*
>> autoReconnect=true&prepStmtCacheSize=517&cachePrepStmts=true
>> at java.sql.DriverManager.getConnection(DriverManager.java:596)
>> at java.sql.DriverManager.getConnection(DriverManager.java:215)
>> at
>>
>> org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75)
>> at
>>
>> org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
>> at
>>
>> org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1188)
>> at
>>
>> org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
>> at
>>
>> com.cloud.utils.db.TransactionLegacy.getStandaloneConnectionWithException(TransactionLegacy.java:204)
>> at com.cloud.utils.db.Merovingian2.<init>(Merovingian2.java:68)
>> at com.cloud.utils.db.Merovingian2.createLockMaster(Merovingian2.java:80)
>> at com.cloud.server.LockMasterListener.<init>(LockMasterListener.java:33)
>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>> at
>>
>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
>> at
>>
>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>> at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
>> at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:148)
>> at
>>
>> org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:121)
>> at
>>
>> org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:280)
>> at
>>
>> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1045)
>>
>>
>> what can be the problem?
>> thanks.
>>
Re: Problem with Management server and connection to the databse
Posted by Ian Duffy <ia...@ianduffy.ie>.
Sounds like a missing mysql driver jar.
Please see the following solution:
http://blog.widodh.nl/2014/03/sql-connection-error-after-upgrade-to-cloudstack-4-3-0/
On 23 June 2014 22:41, Seif Eddine Jemli <se...@gmail.com> wrote:
> Hi everyone,
>
> I am having a 404 error when trying to access *
> http://localhost:8080/client
> <http://localhost:8080/client>, *this exception is in the
> management-server.log
>
>
> 2014-06-23 20:43:26,899 INFO [c.c.u.d.T.Transaction] (main:null) Is Data
> Base High Availiability enabled? Ans : false
> 2014-06-23 20:43:26,915 ERROR [c.c.u.d.Merovingian2] (main:null) Unable to
> get a new db connection
> *java.sql.SQLException: No suitable driver found for
> jdbc:mysql://localhost:3306/cloud?*
> autoReconnect=true&prepStmtCacheSize=517&cachePrepStmts=true
> at java.sql.DriverManager.getConnection(DriverManager.java:596)
> at java.sql.DriverManager.getConnection(DriverManager.java:215)
> at
>
> org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75)
> at
>
> org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
> at
>
> org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1188)
> at
>
> org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
> at
>
> com.cloud.utils.db.TransactionLegacy.getStandaloneConnectionWithException(TransactionLegacy.java:204)
> at com.cloud.utils.db.Merovingian2.<init>(Merovingian2.java:68)
> at com.cloud.utils.db.Merovingian2.createLockMaster(Merovingian2.java:80)
> at com.cloud.server.LockMasterListener.<init>(LockMasterListener.java:33)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at
>
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> at
>
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:148)
> at
>
> org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:121)
> at
>
> org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:280)
> at
>
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1045)
>
>
> what can be the problem?
> thanks.
>