Hello Folks,
I have installed a management server where it’s able to connect to the cloud DB, even on the same machine management-server is working find and getting the details from cloud DB, but when I am starting the cloud_usage services it’s giving me error that couldn’t connect to the DB. I have checked the password from DB.properties file, db.cloud.password and db.cloud_usage.password is same, I have tried to dechiper that they are same. Please find the logs below, if anyone can help what else to took at. If the password and connection is wrong then how come my management is running perfectly fine, and db.properties and key is a soft link to management’s db.properties and key. Any help would be appreciated. [root@acs-mgmt-03 ~]# /usr/bin/java -Dpid=105674 -Xms256m -Xmx2048m -cp /usr/share/cloudstack-usage/*:/usr/share/cloudstack-usage/lib/*:/usr/share/cloudstack-mysql-ha/lib/*:/etc/cloudstack/usage:/usr/share/java/mysql-connector-java.jar com.cloud.usage.UsageServer log4j:WARN No appenders could be found for logger (com.cloud.utils.LogUtils). log4j:WARN Please initialize the log4j system properly. log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info. SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder". SLF4J: Defaulting to no-operation (NOP) logger implementation SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details. WARNING: An illegal reflective access operation has occurred WARNING: Illegal reflective access by net.sf.cglib.core.ReflectUtils$1 (file:/usr/share/cloudstack-usage/lib/cglib-nodep-3.3.0.jar) to method java.lang.ClassLoader.defineClass(java.lang.String,byte[],int,int,java.security.ProtectionDomain) WARNING: Please consider reporting this to the maintainers of net.sf.cglib.core.ReflectUtils$1 WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations WARNING: All illegal access operations will be denied in a future release 17:29:24,503 INFO Transaction:1027 - Is Data Base High Availiability enabled? Ans : false Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. 17:29:25,307 INFO ComponentContext:59 - Setup Spring Application context 17:29:25,581 INFO ComponentContext:108 - Configuring org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239 17:29:25,581 INFO ComponentContext:108 - Configuring com.cloud.user.dao.UserStatsLogDaoImpl_EnhancerByCloudStack_71143423 17:29:25,582 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageVMSnapshotDaoImpl_EnhancerByCloudStack_ed7fd69f 17:29:25,582 INFO ComponentContext:108 - Configuring com.cloud.event.dao.UsageEventDaoImpl_EnhancerByCloudStack_d49a40ad 17:29:25,582 INFO ComponentContext:108 - Configuring com.cloud.domain.dao.DomainDaoImpl_EnhancerByCloudStack_64186150 17:29:25,582 INFO ComponentContext:108 - Configuring org.apache.cloudstack.quota.dao.UserVmDetailsDaoImpl_EnhancerByCloudStack_ad02d4e3 17:29:25,582 INFO ComponentContext:108 - Configuring com.cloud.user.dao.SSHKeyPairDaoImpl_EnhancerByCloudStack_c6fd775a 17:29:25,582 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageVmDiskDaoImpl_EnhancerByCloudStack_d213957e 17:29:25,582 INFO ComponentContext:108 - Configuring com.cloud.user.dao.UserStatisticsDaoImpl_EnhancerByCloudStack_eea571f5 17:29:25,582 INFO ComponentContext:108 - Configuring org.apache.cloudstack.quota.dao.QuotaUsageDaoImpl_EnhancerByCloudStack_b12520b4 17:29:25,582 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageVPNUserDaoImpl_EnhancerByCloudStack_c3eb5a9f 17:29:25,583 INFO ComponentContext:108 - Configuring com.cloud.event.dao.EventDaoImpl_EnhancerByCloudStack_92924530 17:29:25,583 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageLoadBalancerPolicyDaoImpl_EnhancerByCloudStack_37f7c74 17:29:25,583 INFO ComponentContext:108 - Configuring com.cloud.user.dao.UserAccountDaoImpl_EnhancerByCloudStack_1d64a023 17:29:25,583 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageStorageDaoImpl_EnhancerByCloudStack_676f39a3 17:29:25,584 INFO ComponentContext:108 - Configuring com.cloud.configuration.dao.ResourceCountDaoImpl_EnhancerByCloudStack_70547415 17:29:25,584 INFO ComponentContext:108 - Configuring org.apache.cloudstack.quota.dao.QuotaBalanceDaoImpl_EnhancerByCloudStack_6bd766c1 17:29:25,584 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageVMInstanceDaoImpl_EnhancerByCloudStack_d215a366 17:29:25,584 INFO ComponentContext:108 - Configuring org.apache.cloudstack.quota.dao.QuotaEmailTemplatesDaoImpl_EnhancerByCloudStack_cd8d2c06 17:29:25,584 INFO ComponentContext:108 - Configuring com.cloud.user.dao.AccountDaoImpl_EnhancerByCloudStack_89d68960 17:29:25,584 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageJobDaoImpl_EnhancerByCloudStack_14b80f91 17:29:25,584 INFO ComponentContext:108 - Configuring org.apache.cloudstack.quota.dao.QuotaTariffDaoImpl_EnhancerByCloudStack_9c5f6c87 17:29:25,584 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.ExternalPublicIpStatisticsDaoImpl_EnhancerByCloudStack_92220bff 17:29:25,584 INFO ComponentContext:108 - Configuring com.cloud.event.dao.UsageEventDetailsDaoImpl_EnhancerByCloudStack_375866a9 17:29:25,585 INFO ComponentContext:108 - Configuring com.cloud.configuration.dao.ResourceLimitDaoImpl_EnhancerByCloudStack_8a16d989 17:29:25,585 INFO ComponentContext:108 - Configuring com.cloud.alert.dao.AlertDaoImpl_EnhancerByCloudStack_11a80a8c 17:29:25,585 INFO ComponentContext:108 - Configuring org.apache.cloudstack.quota.dao.ServiceOfferingDaoImpl_EnhancerByCloudStack_358cbd0 17:29:25,585 INFO ComponentContext:108 - Configuring com.cloud.user.dao.VmDiskStatisticsDaoImpl_EnhancerByCloudStack_dca34224 17:29:25,585 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsagePortForwardingRuleDaoImpl_EnhancerByCloudStack_d0652388 17:29:25,585 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageNetworkDaoImpl_EnhancerByCloudStack_712152b8 17:29:25,585 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageVolumeDaoImpl_EnhancerByCloudStack_b241eee8 17:29:25,585 INFO ComponentContext:108 - Configuring com.cloud.user.dao.UserDaoImpl_EnhancerByCloudStack_2a90c3f0 17:29:25,585 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageNetworkOfferingDaoImpl_EnhancerByCloudStack_636bee22 17:29:25,585 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageVMSnapshotOnPrimaryDaoImpl_EnhancerByCloudStack_ed869b6e 17:29:25,586 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageBackupDaoImpl_EnhancerByCloudStack_6a940000 17:29:25,586 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageSecurityGroupDaoImpl_EnhancerByCloudStack_9cbea2df 17:29:25,586 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageIPAddressDaoImpl_EnhancerByCloudStack_8f89d561 17:29:25,586 INFO ComponentContext:108 - Configuring org.apache.cloudstack.quota.dao.QuotaAccountDaoImpl_EnhancerByCloudStack_d6e28308 17:29:25,586 INFO ComponentContext:108 - Configuring org.apache.cloudstack.quota.dao.QuotaCreditsDaoImpl_EnhancerByCloudStack_86f65ad3 17:29:25,586 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageDaoImpl_EnhancerByCloudStack_db469b32 17:29:25,586 INFO ComponentContext:108 - Configuring com.cloud.usage.UsageManagerImpl_EnhancerByCloudStack_b63073a9 17:29:25,586 INFO UsageManagerImpl:208 - Implementation Version is 4.15.1.0 Exception in thread "main" com.cloud.utils.exception.CloudRuntimeException: DB Exception on: null at com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:423) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239.CGLIB$searchIncludingRemoved$51(<generated>) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239_FastClassByCloudStack_f73b4cff.invoke(<generated>) at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:122) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239.searchIncludingRemoved(<generated>) at com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:359) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239.CGLIB$searchIncludingRemoved$52(<generated>) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239_FastClassByCloudStack_f73b4cff.invoke(<generated>) at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:122) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239.searchIncludingRemoved(<generated>) at com.cloud.utils.db.GenericDaoBase.listIncludingRemovedBy(GenericDaoBase.java:932) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239.CGLIB$listIncludingRemovedBy$80(<generated>) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239_FastClassByCloudStack_f73b4cff.invoke(<generated>) at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:122) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239.listIncludingRemovedBy(<generated>) at com.cloud.utils.db.GenericDaoBase.listIncludingRemovedBy(GenericDaoBase.java:937) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239.CGLIB$listIncludingRemovedBy$81(<generated>) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239_FastClassByCloudStack_f73b4cff.invoke(<generated>) at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:122) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239.listIncludingRemovedBy(<generated>) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl.getConfiguration(ConfigurationDaoImpl.java:78) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239.CGLIB$getConfiguration$7(<generated>) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239_FastClassByCloudStack_f73b4cff.invoke(<generated>) at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:122) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239.getConfiguration(<generated>) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl.getConfiguration(ConfigurationDaoImpl.java:105) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239.CGLIB$getConfiguration$8(<generated>) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239_FastClassByCloudStack_f73b4cff.invoke(<generated>) at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:122) at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239.getConfiguration(<generated>) at com.cloud.usage.UsageManagerImpl.configure(UsageManagerImpl.java:211) at com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:116) at com.cloud.usage.UsageServer.start(UsageServer.java:54) at com.cloud.usage.UsageServer.main(UsageServer.java:41) Caused by: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:906) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:831) at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:197) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228) at org.apache.commons.dbcp2.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:121) at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:357) at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:918) at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:431) at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:356) at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134) at com.cloud.utils.db.TransactionLegacy.getConnection(TransactionLegacy.java:555) at com.cloud.utils.db.TransactionLegacy.prepareStatement(TransactionLegacy.java:466) at com.cloud.utils.db.TransactionLegacy.prepareAutoCloseStatement(TransactionLegacy.java:459) at com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:396) ... 39 more Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection(NativeProtocol.java:338) at com.mysql.cj.protocol.a.NativeAuthenticationProvider.negotiateSSLConnection(NativeAuthenticationProvider.java:777) at com.mysql.cj.protocol.a.NativeAuthenticationProvider.proceedHandshakeWithPluggableAuthentication(NativeAuthenticationProvider.java:486) at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:202) at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1340) at com.mysql.cj.NativeSession.connect(NativeSession.java:157) at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:850) ... 55 more Caused by: javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate) at java.base/sun.security.ssl.HandshakeContext.<init>(HandshakeContext.java:170) at java.base/sun.security.ssl.ClientHandshakeContext.<init>(ClientHandshakeContext.java:103) at java.base/sun.security.ssl.TransportContext.kickstart(TransportContext.java:222) at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:449) at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:427) at com.mysql.cj.protocol.ExportControlled.performTlsHandshake(ExportControlled.java:336) at com.mysql.cj.protocol.StandardSocketFactory.performTlsHandshake(StandardSocketFactory.java:188) at com.mysql.cj.protocol.a.NativeSocketConnection.performTlsHandshake(NativeSocketConnection.java:99) at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection(NativeProtocol.java:329) ... 61 more Vivek Kumar Sr. Manager - Cloud & DevOps TechOps | Indiqus Technologies vivek.ku...@indiqus.com <mailto:vivek.ku...@indiqus.com> www.indiqus.com <https://www.indiqus.com/> -- This message is intended only for the use of the individual or entity to which it is addressed and may contain confidential and/or privileged information. If you are not the intended recipient, please delete the original message and any copy of it from your computer system. You are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited unless proper authorization has been obtained for such action. If you have received this communication in error, please notify the sender immediately. Although IndiQus attempts to sweep e-mail and attachments for viruses, it does not guarantee that both are virus-free and accepts no liability for any damage sustained as a result of viruses.
