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
|