You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by Patrick Miller <pa...@sungardas.com> on 2017/07/10 15:48:12 UTC

Database connector failure on Upgrade from CS 4.3.2 to 4.9.2

Hello all,

 In preparation for the 4.10 release I tried to do an upgrade from 4.3.2 to 4.9.2

 I followed the release notes for the upgrade process including installing mysql-connector-python but I keep getting "DB driver type null is not supported!"  I googled, and all I found was notes about no end of line in the db.properties file.


   Thanks


   Patrick Miller


Here are the mysql rams installed not the system

rpm -qa | grep mysql

mysql-connector-odbc-5.1.5r1144-7.el6.x86_64

mysql-libs-5.1.73-8.el6_8.x86_64

mysql-5.1.73-8.el6_8.x86_64

mysql-connector-java-5.1.17-6.el6.noarch

mysql-connector-python-2.1.6-1.el6.x86_64

mysql-server-5.1.73-8.el6_8.x86_64


Here is my db.properties


# Licensed to the Apache Software Foundation (ASF) under one

db.cloud.minEvictableIdleTimeMillis=240000

# or more contributor license agreements.  See the NOTICE file

# distributed with this work for additional information

db.simulator.password=cloud

db.simulator.maxIdle=30

# with the License.  You may obtain a copy of the License at

# to you under the Apache License, Version 2.0 (the

# "License"); you may not use this file except in compliance

# regarding copyright ownership.  The ASF licenses this file

db.usage.host=localhost

#   http://www.apache.org/licenses/LICENSE-2.0

# Encryption Settings

# software distributed under the License is distributed on an

db.usage.maxActive=100

# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY

#

# usage database settings

# specific language governing permissions and limitations

db.simulator.maxActive=250

# management server clustering parameters, change cluster.node.IP to the machine

 IP address

db.cloud.username=cloud

# KIND, either express or implied.  See the License for the

# under the License.

# Unless required by applicable law or agreed to in writing,

cluster.node.IP=172.31.97.50

db.usage.port=3306

db.cloud.name=cloud



# CloudStack database settings

cluster.servlet.port=9090

db.cloud.maxActive=250

# in which the management server(Tomcat) is running

db.cloud.host=localhost

region.id=1

# CloudStack database tuning parameters


db.cloud.password=ENC(Hnwt8z1u0mzQABf/X9ZkKziHRHHrT4Y3)

# CloudStack database SSL settings

db.cloud.validationQuery=SELECT 1

db.cloud.testOnBorrow=true

db.awsapi.username=cloud

db.cloud.port=3306

db.cloud.timeBetweenEvictionRunsMillis=40000

db.cloud.keyStorePassword=

db.cloud.autoReconnect=true

db.cloud.keyStore=


db.cloud.poolPreparedStatements=false


db.cloud.maxIdle=30

db.cloud.trustStorePassword=


db.cloud.testWhileIdle=true

db.cloud.url.params=prepStmtCacheSize=517&cachePrepStmts=true



# usage database tuning parameters


db.cloud.maxWait=10000

db.simulator.autoReconnect=true

# Simulator database settings

db.usage.name=cloud_usage

db.simulator.port=3306

db.usage.url.params=

db.usage.maxIdle=30


db.usage.username=cloud

db.cloud.trustStore=

db.usage.maxWait=10000

db.cloud.useSSL=false

db.cloud.encryption.type=file

db.cloud.encrypt.secret=ENC(uAoObwkGyDGXTJKZyHcNRKruRCWJCSg0)

db.awsapi.password=cloud

db.simulator.username=cloud

# awsapi database settings

db.awsapi.host=localhost

db.usage.password=ENC(5JfmqSDGmMvz4DeP6f+yaI9JWh2MUsuI)

db.awsapi.port=3306

db.simulator.maxWait=10000

db.usage.autoReconnect=true

db.awsapi.name=cloudbridge

db.simulator.name=simulator

db.simulator.host=localhost

db.cloud.driver=jdbc:mysql

db.simulator.driver=jdbc:mysql


This is an excerpt from my management-server.log


2017-07-10 14:55:51,599 INFO  [factory.support.DefaultListableBeanFactory] (main:null) Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFact

ory@71a40770: defining beans [ManagedContext,org.apache.cloudstack.managed.context.ManagedContextRunnable#0,databaseUpgradeChecker,versionDaoImpl,configurationDaoImpl,configDepot,scope

dConfigStorageRegistry,entityManagerImpl,lockMasterListener,cloudStackLifeCycle,moduleStartup,transactionContextInterceptor,actionEventInterceptor,org.springframework.aop.config.intern

alAutoProxyCreator,org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor#0,org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor#1,org.springframework.aop.suppo

rt.DefaultBeanFactoryPointcutAdvisor#2,org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor#3,org.apache.cloudstack.spring.lifecycle.registry.RegistryLifecycle#0,org.apach

e.cloudstack.spring.lifecycle.ConfigDepotLifeCycle#0,contrailEventInterceptor,org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor#4,org.springframework.aop.support.Defaul

tBeanFactoryPointcutAdvisor#5,org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcesso

r,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.beans.factory.

config.PropertyPlaceholderConfigurer#0,org.springframework.context.annotation.ConfigurationClassPostProcessor.importAwareProcessor]; parent: org.springframework.beans.factory.support.D

efaultListableBeanFactory@501a7f06

2017-07-10 14:55:52,172 INFO  [db.Transaction.Transaction] (main:null) Is Data Base High Availiability enabled? Ans : false

2017-07-10 14:55:52,258 DEBUG [utils.db.DriverLoader] (main:null) Successfully loaded DB driver com.mysql.jdbc.Driver

2017-07-10 14:55:52,274 ERROR [utils.db.DriverLoader] (main:null) DB driver type null is not supported!

2017-07-10 14:55:52,276 WARN  [db.Transaction.Transaction] (main:null) Unable to load db configuration, using defaults with 5 connections. Falling back on assumed datasource on localho

st:3306 using username:password=cloud:cloud. Please check your configuration

com.cloud.utils.exception.CloudRuntimeException: DB driver type null is not supported!

at com.cloud.utils.db.DriverLoader.loadDriver(DriverLoader.java:47)

at com.cloud.utils.db.TransactionLegacy.initDataSource(TransactionLegacy.java:1120)

at com.cloud.utils.db.TransactionLegacy.<clinit>(TransactionLegacy.java:1009)

at com.cloud.utils.db.Merovingian2.<init>(Merovingian2.java:68)

at com.cloud.utils.db.Merovingian2.createLockMaster(Merovingian2.java:88)

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:277)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1077)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:981)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:487)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:636)

at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:938)

at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)

at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.java:145)

at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:122)

at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:245)

at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:250)

at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:233)

at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContexts(DefaultModuleDefinitionSet.java:117)

at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:79)

at org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory.loadModules(ModuleBasedContextFactory.java:37)

at org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.init(CloudStackSpringContext.java:71)

at org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:58)

at org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:62)

at org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListener.contextInitialized(CloudStackContextLoaderListener.java:52)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4244)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4743)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)

at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1041)

at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:964)

at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)

at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)

at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)

at org.apache.catalina.core.StandardService.start(StandardService.java:516)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)

at org.apache.catalina.startup.Catalina.start(Catalina.java:593)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

2017-07-10 14:55:52,449 ERROR [utils.db.Merovingian2] (main:null) Unable to get a new db connection

java.sql.SQLException: Access denied for user 'cloud'@'localhost' (using password: YES)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:935)

at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4101)

at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1300)

at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2337)

at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2370)

at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2154)

at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)

at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:49)

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 com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)

at java.sql.DriverManager.getConnection(DriverManager.java:571)

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:212)

at com.cloud.utils.db.Merovingian2.<init>(Merovingian2.java:68)

at com.cloud.utils.db.Merovingian2.createLockMaster(Merovingian2.java:88)

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:277)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1077)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:981)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:487)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:636)

at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:938)

at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)

at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.java:145)

at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:122)

at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:245)

at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:250)

at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:233)

at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContexts(DefaultModuleDefinitionSet.java:117)

at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:79)

at org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory.loadModules(ModuleBasedContextFactory.java:37)

at org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.init(CloudStackSpringContext.java:71)

at org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:58)

at org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:62)

at org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListener.contextInitialized(CloudStackContextLoaderListener.java:52)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4244)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4743)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)

at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1041)

at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:964)

at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)

at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)

at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)

at org.apache.catalina.core.StandardService.start(StandardService.java:516)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)

at org.apache.catalina.startup.Catalina.start(Catalina.java:593)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

2017-07-10 14:55:52,460 WARN  [module.context.ResourceApplicationContext] (main:null) Exception encountered during context initialization - cancelling refresh attempt: org.springframew

ork.beans.factory.BeanCreationException: Error creating bean with name 'lockMasterListener' defined in URL [jar:file:/usr/share/cloudstack-management/webapps/client/WEB-INF/lib/cloud-s

erver-4.9.2.0.jar!/META-INF/cloudstack/system/spring-server-system-context.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException:

 Could not instantiate bean class [com.cloud.server.LockMasterListener]: Constructor threw exception; nested exception is com.cloud.utils.exception.CloudRuntimeException: Unable to ini

tialize a connection to the database for locking purposes

2017-07-10 14:55:52,460 INFO  [factory.support.DefaultListableBeanFactory] (main:null) Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@71a

40770: defining beans [ManagedContext,org.apache.cloudstack.managed.context.ManagedContextRunnable#0,databaseUpgradeChecker,versionDaoImpl,configurationDaoImpl,configDepot,scopedConfig

StorageRegistry,entityManagerImpl,lockMasterListener,cloudStackLifeCycle,moduleStartup,transactionContextInterceptor,actionEventInterceptor,org.springframework.aop.config.internalAutoP

roxyCreator,org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor#0,org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor#1,org.springframework.aop.support.Defa

ultBeanFactoryPointcutAdvisor#2,org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor#3,org.apache.cloudstack.spring.lifecycle.registry.RegistryLifecycle#0,org.apache.cloud

stack.spring.lifecycle.ConfigDepotLifeCycle#0,contrailEventInterceptor,org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor#4,org.springframework.aop.support.DefaultBeanFa

ctoryPointcutAdvisor#5,org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.s

pringframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.beans.factory.config.

PropertyPlaceholderConfigurer#0,org.springframework.context.annotation.ConfigurationClassPostProcessor.importAwareProcessor]; parent: org.springframework.beans.factory.support.DefaultL

istableBeanFactory@501a7f06


Re: Database connector failure on Upgrade from CS 4.3.2 to 4.9.2

Posted by Patrick Miller <pa...@sungardas.com>.
Thank you.


   I missed the usage entry.

  Though I do not have the usage server installed.


   It is starting up now.



   Thanks again.

    Patrick Miller

________________________________
From: Rene Moser <ma...@renemoser.net>
Sent: Monday, July 10, 2017 9:49:22 AM
To: users@cloudstack.apache.org
Subject: Re: Database connector failure on Upgrade from CS 4.3.2 to 4.9.2

Hi

On 07/10/2017 06:27 PM, Rafael Weingärtner wrote:
> Did you try to set in the db.properties the "db.usage.driver"?
> something like: *db*.cloud.*driver*=jdbc:mysql

Related to CLOUDSTACK-9765

https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_apache_cloudstack_commit_bcc6b4fbaf74865b971a72122d15d5bfde4ab7ba&d=DwIDaQ&c=gYbc-GKV5BQa9zrq1GFCVg&r=PJ6ByoPcXzANpd1lsEuxSI2kVKchOrHCf_mz3Zwy7PQ&m=_4dZCfMfjZs-q6YFUPsrYvZ0AGG7rzcwyJpXNm8VAEs&s=gpxGR_i7PODTlbmuwpvcD_uacbrzdXkXuRyF5xwfi_g&e=

Regards
René

Re: Database connector failure on Upgrade from CS 4.3.2 to 4.9.2

Posted by Rene Moser <ma...@renemoser.net>.
Hi

On 07/10/2017 06:27 PM, Rafael Weingärtner wrote:
> Did you try to set in the db.properties the "db.usage.driver"?
> something like: *db*.cloud.*driver*=jdbc:mysql

Related to CLOUDSTACK-9765

https://github.com/apache/cloudstack/commit/bcc6b4fbaf74865b971a72122d15d5bfde4ab7ba

Regards
René

Re: Database connector failure on Upgrade from CS 4.3.2 to 4.9.2

Posted by Rafael Weingärtner <ra...@gmail.com>.
Did you try to set in the db.properties the "db.usage.driver"?
something like: *db*.cloud.*driver*=jdbc:mysql


On Mon, Jul 10, 2017 at 11:48 AM, Patrick Miller <
patrick.miller@sungardas.com> wrote:

> Hello all,
>
>  In preparation for the 4.10 release I tried to do an upgrade from 4.3.2
> to 4.9.2
>
>  I followed the release notes for the upgrade process including installing
> mysql-connector-python but I keep getting "DB driver type null is not
> supported!"  I googled, and all I found was notes about no end of line in
> the db.properties file.
>
>
>    Thanks
>
>
>    Patrick Miller
>
>
> Here are the mysql rams installed not the system
>
> rpm -qa | grep mysql
>
> mysql-connector-odbc-5.1.5r1144-7.el6.x86_64
>
> mysql-libs-5.1.73-8.el6_8.x86_64
>
> mysql-5.1.73-8.el6_8.x86_64
>
> mysql-connector-java-5.1.17-6.el6.noarch
>
> mysql-connector-python-2.1.6-1.el6.x86_64
>
> mysql-server-5.1.73-8.el6_8.x86_64
>
>
> Here is my db.properties
>
>
> # Licensed to the Apache Software Foundation (ASF) under one
>
> db.cloud.minEvictableIdleTimeMillis=240000
>
> # or more contributor license agreements.  See the NOTICE file
>
> # distributed with this work for additional information
>
> db.simulator.password=cloud
>
> db.simulator.maxIdle=30
>
> # with the License.  You may obtain a copy of the License at
>
> # to you under the Apache License, Version 2.0 (the
>
> # "License"); you may not use this file except in compliance
>
> # regarding copyright ownership.  The ASF licenses this file
>
> db.usage.host=localhost
>
> #   http://www.apache.org/licenses/LICENSE-2.0
>
> # Encryption Settings
>
> # software distributed under the License is distributed on an
>
> db.usage.maxActive=100
>
> # "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
>
> #
>
> # usage database settings
>
> # specific language governing permissions and limitations
>
> db.simulator.maxActive=250
>
> # management server clustering parameters, change cluster.node.IP to the
> machine
>
>  IP address
>
> db.cloud.username=cloud
>
> # KIND, either express or implied.  See the License for the
>
> # under the License.
>
> # Unless required by applicable law or agreed to in writing,
>
> cluster.node.IP=172.31.97.50
>
> db.usage.port=3306
>
> db.cloud.name=cloud
>
>
>
> # CloudStack database settings
>
> cluster.servlet.port=9090
>
> db.cloud.maxActive=250
>
> # in which the management server(Tomcat) is running
>
> db.cloud.host=localhost
>
> region.id=1
>
> # CloudStack database tuning parameters
>
>
> db.cloud.password=ENC(Hnwt8z1u0mzQABf/X9ZkKziHRHHrT4Y3)
>
> # CloudStack database SSL settings
>
> db.cloud.validationQuery=SELECT 1
>
> db.cloud.testOnBorrow=true
>
> db.awsapi.username=cloud
>
> db.cloud.port=3306
>
> db.cloud.timeBetweenEvictionRunsMillis=40000
>
> db.cloud.keyStorePassword=
>
> db.cloud.autoReconnect=true
>
> db.cloud.keyStore=
>
>
> db.cloud.poolPreparedStatements=false
>
>
> db.cloud.maxIdle=30
>
> db.cloud.trustStorePassword=
>
>
> db.cloud.testWhileIdle=true
>
> db.cloud.url.params=prepStmtCacheSize=517&cachePrepStmts=true
>
>
>
> # usage database tuning parameters
>
>
> db.cloud.maxWait=10000
>
> db.simulator.autoReconnect=true
>
> # Simulator database settings
>
> db.usage.name=cloud_usage
>
> db.simulator.port=3306
>
> db.usage.url.params=
>
> db.usage.maxIdle=30
>
>
> db.usage.username=cloud
>
> db.cloud.trustStore=
>
> db.usage.maxWait=10000
>
> db.cloud.useSSL=false
>
> db.cloud.encryption.type=file
>
> db.cloud.encrypt.secret=ENC(uAoObwkGyDGXTJKZyHcNRKruRCWJCSg0)
>
> db.awsapi.password=cloud
>
> db.simulator.username=cloud
>
> # awsapi database settings
>
> db.awsapi.host=localhost
>
> db.usage.password=ENC(5JfmqSDGmMvz4DeP6f+yaI9JWh2MUsuI)
>
> db.awsapi.port=3306
>
> db.simulator.maxWait=10000
>
> db.usage.autoReconnect=true
>
> db.awsapi.name=cloudbridge
>
> db.simulator.name=simulator
>
> db.simulator.host=localhost
>
> db.cloud.driver=jdbc:mysql
>
> db.simulator.driver=jdbc:mysql
>
>
> This is an excerpt from my management-server.log
>
>
> 2017-07-10 14:55:51,599 INFO  [factory.support.DefaultListableBeanFactory]
> (main:null) Pre-instantiating singletons in org.springframework.beans.
> factory.support.DefaultListableBeanFact
>
> ory@71a40770: defining beans [ManagedContext,org.apache.
> cloudstack.managed.context.ManagedContextRunnable#0,
> databaseUpgradeChecker,versionDaoImpl,configurationDaoImpl,
> configDepot,scope
>
> dConfigStorageRegistry,entityManagerImpl,lockMasterListener,
> cloudStackLifeCycle,moduleStartup,transactionContextInterceptor,
> actionEventInterceptor,org.springframework.aop.config.intern
>
> alAutoProxyCreator,org.springframework.aop.support.
> DefaultBeanFactoryPointcutAdvisor#0,org.springframework.aop.support.
> DefaultBeanFactoryPointcutAdvisor#1,org.springframework.aop.suppo
>
> rt.DefaultBeanFactoryPointcutAdvisor#2,org.springframework.aop.support.
> DefaultBeanFactoryPointcutAdvisor#3,org.apache.cloudstack.
> spring.lifecycle.registry.RegistryLifecycle#0,org.apach
>
> e.cloudstack.spring.lifecycle.ConfigDepotLifeCycle#0,
> contrailEventInterceptor,org.springframework.aop.support.
> DefaultBeanFactoryPointcutAdvisor#4,org.springframework.aop.support.Defaul
>
> tBeanFactoryPointcutAdvisor#5,org.springframework.context.annotation.
> internalConfigurationAnnotationProcessor,org.springframework.context.
> annotation.internalAutowiredAnnotationProcesso
>
> r,org.springframework.context.annotation.internalRequiredAnnotationProc
> essor,org.springframework.context.annotation.
> internalCommonAnnotationProcessor,org.springframework.beans.factory.
>
> config.PropertyPlaceholderConfigurer#0,org.springframework.context.
> annotation.ConfigurationClassPostProcessor.importAwareProcessor]; parent:
> org.springframework.beans.factory.support.D
>
> efaultListableBeanFactory@501a7f06
>
> 2017-07-10 14:55:52,172 INFO  [db.Transaction.Transaction] (main:null) Is
> Data Base High Availiability enabled? Ans : false
>
> 2017-07-10 14:55:52,258 DEBUG [utils.db.DriverLoader] (main:null)
> Successfully loaded DB driver com.mysql.jdbc.Driver
>
> 2017-07-10 14:55:52,274 ERROR [utils.db.DriverLoader] (main:null) DB
> driver type null is not supported!
>
> 2017-07-10 14:55:52,276 WARN  [db.Transaction.Transaction] (main:null)
> Unable to load db configuration, using defaults with 5 connections. Falling
> back on assumed datasource on localho
>
> st:3306 using username:password=cloud:cloud. Please check your
> configuration
>
> com.cloud.utils.exception.CloudRuntimeException: DB driver type null is
> not supported!
>
> at com.cloud.utils.db.DriverLoader.loadDriver(DriverLoader.java:47)
>
> at com.cloud.utils.db.TransactionLegacy.initDataSource(
> TransactionLegacy.java:1120)
>
> at com.cloud.utils.db.TransactionLegacy.<clinit>(
> TransactionLegacy.java:1009)
>
> at com.cloud.utils.db.Merovingian2.<init>(Merovingian2.java:68)
>
> at com.cloud.utils.db.Merovingian2.createLockMaster(Merovingian2.java:88)
>
> 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:277)
>
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.autowireConstructor(
> AbstractAutowireCapableBeanFactory.java:1077)
>
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.createBeanInstance(
> AbstractAutowireCapableBeanFactory.java:981)
>
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.doCreateBean(
> AbstractAutowireCapableBeanFactory.java:487)
>
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.createBean(
> AbstractAutowireCapableBeanFactory.java:458)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory$1.
> getObject(AbstractBeanFactory.java:293)
>
> at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.
> getSingleton(DefaultSingletonBeanRegistry.java:223)
>
> at org.springframework.beans.factory.support.
> AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(
> AbstractBeanFactory.java:191)
>
> at org.springframework.beans.factory.support.DefaultListableBeanFactory.
> preInstantiateSingletons(DefaultListableBeanFactory.java:636)
>
> at org.springframework.context.support.AbstractApplicationContext.
> finishBeanFactoryInitialization(AbstractApplicationContext.java:938)
>
> at org.springframework.context.support.AbstractApplicationContext.refresh(
> AbstractApplicationContext.java:479)
>
> at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.
> java:145)
>
> at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:122)
>
> at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:245)
>
> at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:250)
>
> at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:233)
>
> at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.loadContexts(DefaultModuleDefinitionSet.
> java:117)
>
> at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:79)
>
> at org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory.
> loadModules(ModuleBasedContextFactory.java:37)
>
> at org.apache.cloudstack.spring.module.factory.
> CloudStackSpringContext.init(CloudStackSpringContext.java:71)
>
> at org.apache.cloudstack.spring.module.factory.
> CloudStackSpringContext.<init>(CloudStackSpringContext.java:58)
>
> at org.apache.cloudstack.spring.module.factory.
> CloudStackSpringContext.<init>(CloudStackSpringContext.java:62)
>
> at org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListene
> r.contextInitialized(CloudStackContextLoaderListener.java:52)
>
> at org.apache.catalina.core.StandardContext.listenerStart(
> StandardContext.java:4244)
>
> at org.apache.catalina.core.StandardContext.start(
> StandardContext.java:4743)
>
> at org.apache.catalina.core.ContainerBase.addChildInternal(
> ContainerBase.java:791)
>
> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
>
> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
>
> at org.apache.catalina.startup.HostConfig.deployDirectory(
> HostConfig.java:1041)
>
> at org.apache.catalina.startup.HostConfig.deployDirectories(
> HostConfig.java:964)
>
> at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
>
> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
>
> at org.apache.catalina.startup.HostConfig.lifecycleEvent(
> HostConfig.java:321)
>
> at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(
> LifecycleSupport.java:142)
>
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
>
> at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
>
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
>
> at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
>
> at org.apache.catalina.core.StandardService.start(
> StandardService.java:516)
>
> at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
>
> at org.apache.catalina.startup.Catalina.start(Catalina.java:593)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:57)
>
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:43)
>
> at java.lang.reflect.Method.invoke(Method.java:606)
>
> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
>
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
>
> 2017-07-10 14:55:52,449 ERROR [utils.db.Merovingian2] (main:null) Unable
> to get a new db connection
>
> java.sql.SQLException: Access denied for user 'cloud'@'localhost' (using
> password: YES)
>
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
>
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
>
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
>
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:935)
>
> at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4101)
>
> at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1300)
>
> at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2337)
>
> at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(
> ConnectionImpl.java:2370)
>
> at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2154)
>
> at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
>
> at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:49)
>
> 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 com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
>
> at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
>
> at com.mysql.jdbc.NonRegisteringDriver.connect(
> NonRegisteringDriver.java:305)
>
> at java.sql.DriverManager.getConnection(DriverManager.java:571)
>
> 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.getStandaloneConnectionWithExc
> eption(TransactionLegacy.java:212)
>
> at com.cloud.utils.db.Merovingian2.<init>(Merovingian2.java:68)
>
> at com.cloud.utils.db.Merovingian2.createLockMaster(Merovingian2.java:88)
>
> 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:277)
>
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.autowireConstructor(
> AbstractAutowireCapableBeanFactory.java:1077)
>
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.createBeanInstance(
> AbstractAutowireCapableBeanFactory.java:981)
>
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.doCreateBean(
> AbstractAutowireCapableBeanFactory.java:487)
>
> at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.createBean(
> AbstractAutowireCapableBeanFactory.java:458)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory$1.
> getObject(AbstractBeanFactory.java:293)
>
> at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.
> getSingleton(DefaultSingletonBeanRegistry.java:223)
>
> at org.springframework.beans.factory.support.
> AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
>
> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(
> AbstractBeanFactory.java:191)
>
> at org.springframework.beans.factory.support.DefaultListableBeanFactory.
> preInstantiateSingletons(DefaultListableBeanFactory.java:636)
>
> at org.springframework.context.support.AbstractApplicationContext.
> finishBeanFactoryInitialization(AbstractApplicationContext.java:938)
>
> at org.springframework.context.support.AbstractApplicationContext.refresh(
> AbstractApplicationContext.java:479)
>
> at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.
> java:145)
>
> at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:122)
>
> at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:245)
>
> at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:250)
>
> at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:233)
>
> at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.loadContexts(DefaultModuleDefinitionSet.
> java:117)
>
> at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:79)
>
> at org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory.
> loadModules(ModuleBasedContextFactory.java:37)
>
> at org.apache.cloudstack.spring.module.factory.
> CloudStackSpringContext.init(CloudStackSpringContext.java:71)
>
> at org.apache.cloudstack.spring.module.factory.
> CloudStackSpringContext.<init>(CloudStackSpringContext.java:58)
>
> at org.apache.cloudstack.spring.module.factory.
> CloudStackSpringContext.<init>(CloudStackSpringContext.java:62)
>
> at org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListene
> r.contextInitialized(CloudStackContextLoaderListener.java:52)
>
> at org.apache.catalina.core.StandardContext.listenerStart(
> StandardContext.java:4244)
>
> at org.apache.catalina.core.StandardContext.start(
> StandardContext.java:4743)
>
> at org.apache.catalina.core.ContainerBase.addChildInternal(
> ContainerBase.java:791)
>
> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
>
> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
>
> at org.apache.catalina.startup.HostConfig.deployDirectory(
> HostConfig.java:1041)
>
> at org.apache.catalina.startup.HostConfig.deployDirectories(
> HostConfig.java:964)
>
> at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
>
> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
>
> at org.apache.catalina.startup.HostConfig.lifecycleEvent(
> HostConfig.java:321)
>
> at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(
> LifecycleSupport.java:142)
>
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
>
> at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
>
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
>
> at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
>
> at org.apache.catalina.core.StandardService.start(
> StandardService.java:516)
>
> at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
>
> at org.apache.catalina.startup.Catalina.start(Catalina.java:593)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:57)
>
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:43)
>
> at java.lang.reflect.Method.invoke(Method.java:606)
>
> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
>
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
>
> 2017-07-10 14:55:52,460 WARN  [module.context.ResourceApplicationContext]
> (main:null) Exception encountered during context initialization -
> cancelling refresh attempt: org.springframew
>
> ork.beans.factory.BeanCreationException: Error creating bean with name
> 'lockMasterListener' defined in URL [jar:file:/usr/share/
> cloudstack-management/webapps/client/WEB-INF/lib/cloud-s
>
> erver-4.9.2.0.jar!/META-INF/cloudstack/system/spring-server-system-context.xml]:
> Instantiation of bean failed; nested exception is org.springframework.beans.
> BeanInstantiationException:
>
>  Could not instantiate bean class [com.cloud.server.LockMasterListener]:
> Constructor threw exception; nested exception is com.cloud.utils.exception.CloudRuntimeException:
> Unable to ini
>
> tialize a connection to the database for locking purposes
>
> 2017-07-10 14:55:52,460 INFO  [factory.support.DefaultListableBeanFactory]
> (main:null) Destroying singletons in org.springframework.beans.
> factory.support.DefaultListableBeanFactory@71a
>
> 40770: defining beans [ManagedContext,org.apache.
> cloudstack.managed.context.ManagedContextRunnable#0,
> databaseUpgradeChecker,versionDaoImpl,configurationDaoImpl,
> configDepot,scopedConfig
>
> StorageRegistry,entityManagerImpl,lockMasterListener,cloudStackLifeCycle,
> moduleStartup,transactionContextInterceptor,actionEventInterceptor,org.
> springframework.aop.config.internalAutoP
>
> roxyCreator,org.springframework.aop.support.DefaultBeanFactoryPointcutAdvi
> sor#0,org.springframework.aop.support.DefaultBeanFactoryPointcutAdvi
> sor#1,org.springframework.aop.support.Defa
>
> ultBeanFactoryPointcutAdvisor#2,org.springframework.aop.support.
> DefaultBeanFactoryPointcutAdvisor#3,org.apache.cloudstack.
> spring.lifecycle.registry.RegistryLifecycle#0,org.apache.cloud
>
> stack.spring.lifecycle.ConfigDepotLifeCycle#0,
> contrailEventInterceptor,org.springframework.aop.support.
> DefaultBeanFactoryPointcutAdvisor#4,org.springframework.aop.
> support.DefaultBeanFa
>
> ctoryPointcutAdvisor#5,org.springframework.context.annotation.
> internalConfigurationAnnotationProcessor,org.springframework.context.
> annotation.internalAutowiredAnnotationProcessor,org.s
>
> pringframework.context.annotation.internalRequiredAnnotationProc
> essor,org.springframework.context.annotation.
> internalCommonAnnotationProcessor,org.springframework.beans.
> factory.config.
>
> PropertyPlaceholderConfigurer#0,org.springframework.context.annotation.
> ConfigurationClassPostProcessor.importAwareProcessor]; parent:
> org.springframework.beans.factory.support.DefaultL
>
> istableBeanFactory@501a7f06
>
>


-- 
Rafael Weingärtner