Hi all, I followed the instructions under http://docs.cloudstack.apache.org/projects/cloudstack-release-notes/en/4.9.0/upgrade/upgrade-4.8.html to upgrade form 4.8.0 to 4.9.0 and it seems to have overwritten the default DB connection config.
The setup is running two management nodes connecting to a HAProxy balanced Active-Passive Galera cluster. It seems that after the upgrade both management nodes are trying to connect to the local MySQL server (127.0.0.1) which is wrong. Where should I edit the config? Thanks in advance! Paste of log: 2016-08-22 16:23:46,669 ERROR [c.c.u.d.DriverLoader] (main:null) (logid:) DB driver type null is not supported! 2016-08-22 16:23:46,693 WARN [c.c.u.d.T.Transaction] (main:null) (logid:) Unable to load db configuration, using defaults with 5 connections. Falling back on assumed datasource on localhost:3306 using username:password=cloud:cloud. Please check your configuration com.cloud.utils.exception.CloudRuntimeException: DB driver type null is not supported! 2016-08-22 16:23:46,939 ERROR [c.c.u.d.Merovingian2] (main:null) (logid:) Unable to get a new db connection java.sql.SQLException: Access denied for user 'cloud'@'127.0.0.1' (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.cloud.utils.db.TransactionLegacy.getStandaloneConnectionWithException(TransactionLegacy.java:202) 2016-08-22 16:23:46,952 WARN [o.a.c.s.m.c.ResourceApplicationContext] (main:null) (logid:) Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'lockMasterListener' defined in URL [jar:file:/usr/share/cloudstack-management/webapps/client/WEB-INF/lib/cloud-server-4.9.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 initialize a connection to the database for locking purposes 2016-08-22 16:28:16,582 ERROR [c.c.u.d.DriverLoader] (main:null) (logid:) DB driver type null is not supported! 2016-08-22 16:28:16,602 WARN [c.c.u.d.T.Transaction] (main:null) (logid:) Unable to load db configuration, using defaults with 5 connections. Falling back on assumed datasource on localhost:3306 using username:password=cloud:cloud. Please check your configuration com.cloud.utils.exception.CloudRuntimeException: DB driver type null is not supported! 2016-08-22 16:28:16,811 ERROR [c.c.u.d.Merovingian2] (main:null) (logid:) Unable to get a new db connection java.sql.SQLException: Access denied for user 'cloud'@'127.0.0.1' (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.cloud.utils.db.TransactionLegacy.getStandaloneConnectionWithException(TransactionLegacy.java:202) 2016-08-22 16:28:16,822 WARN [o.a.c.s.m.c.ResourceApplicationContext] (main:null) (logid:) Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'lockMasterListener' defined in URL [jar:file:/usr/share/cloudstack-management/webapps/client/WEB-INF/lib/cloud-server-4.9.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 initialize a connection to the database for locking purposes
