the simplest test is - from the acs mgmt node:
mysql -h <DB_SERVER_IP> -u cloud -p <PASSWORD_FOR_CLOUD_USER> -p 3306 that should work - that is what, effectively, acs mgmt server is doing (i.e. your db.properties might be populated with wrong info OR your mysql credentials are invalid in this way or another) (or a firewall, indeed...) best, On Mon, 5 Jul 2021 at 13:39, pradeep pal <[email protected]> wrote: > Hello, > > Thanks, > > I have installed cloudstack 4.15 in test infra and after installation I > have not scene any issue, maybe it is any network policy related issue, I > am looking on it with network team, i will update you on this soon. > > Thanks > Pradeep > > > > Get Outlook for iOS<https://aka.ms/o0ukef> > ________________________________ > From: Andrija Panic <[email protected]> > Sent: Monday, July 5, 2021 3:38:12 AM > To: users <[email protected]> > Subject: Re: Error while starting CloudStack 4.15 > > recheck your credentials that you defined while setup-cloudstack-databases > script - clearly management server can't access the DB (" Unable to get a > new db connection ") and it could be a few reasons: > > 1) ensure MySQL is listening on port 3306 > 2) ensure you have granted the proper permissions (grant all on cloud.*.... > same for cloud_usage.*...to ....) - the credentials you specified while > running setup-cloudstack-databases > 3) no other reasons I can see, based on the error message. > > best, > > On Sat, 3 Jul 2021 at 03:51, pradeep pal <[email protected]> wrote: > > > Hello, > > > > i am able to access MySQL database from remote machine. But still getting > > the same error. > > > > Thanks > > Pradeep > > > > > > > > Get Outlook for iOS<https://aka.ms/o0ukef> > > ________________________________ > > From: pavan aravapalli <[email protected]> > > Sent: Saturday, July 3, 2021 1:49:48 AM > > To: [email protected] <[email protected]> > > Subject: Re: Error while starting CloudStack 4.15 > > > > Hi, > > Looks like you have an issue with mysql configuration where the mysql > > server is running with localhost binding. Try to run the mysql server > below > > config and restart cloudstack service. > > /etc/my.cnf > > bind-address="0.0.0.0" > > > > Regards, > > Pavan > > > > On Fri, 2 Jul 2021 at 15:37, pradeep pal <[email protected]> wrote: > > > > > Hi, > > > > > > I have installed new CloudStack 4.15, when i start cloudstack service, > > > getting below error. > > > > > > OS: CentOS 7 64bit > > > CloudSatck: 4.15 > > > Mysql DB: mysql-community-server-5.7.34 > > > > > > > > > 2021-07-02 14:57:59,600 ERROR [c.c.u.d.Merovingian2] (main:null) > (logid:) > > > Unable to get a new db connection > > > 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:355) > > > at > > > > > > org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:889) > > > at > > > > > > org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:424) > > > at > > > > > > org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:349) > > > at > > > > > > org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134) > > > at > > > > > > com.cloud.utils.db.TransactionLegacy.getStandaloneConnectionWithException(TransactionLegacy.java:211) > > > 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 > > > > > > 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 > > > > org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:203) > > > at > > > > > > org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:117) > > > at > > > > > > org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:310) > > > at > > > > > > org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:295) > > > at > > > > > > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1358) > > > at > > > > > > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1204) > > > at > > > > > > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:557) > > > at > > > > > > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) > > > at > > > > > > org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323) > > > at > > > > > > org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) > > > at > > > > > > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) > > > at > > > > > > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) > > > at > > > > > > org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:879) > > > at > > > > > > org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:878) > > > at > > > > > > org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550) > > > at > > > > > > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.java:144) > > > at > > > > > > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:121) > > > at > > > > > > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:244) > > > at > > > > > > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:249) > > > at > > > > > > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:232) > > > at > > > > > > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContexts(DefaultModuleDefinitionSet.java:116) > > > at > > > > > > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:78) > > > at > > > > > > org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory.loadModules(ModuleBasedContextFactory.java:37) > > > at > > > > > > org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.init(CloudStackSpringContext.java:70) > > > at > > > > > > org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:57) > > > at > > > > > > org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:61) > > > at > > > > > > org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListener.contextInitialized(CloudStackContextLoaderListener.java:51) > > > at > > > > > > org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:933) > > > at > > > > > > org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:553) > > > at > > > > > > org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:892) > > > at > > > > > > org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:356) > > > at > > > > > > org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1445) > > > at > > > > > > org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1409) > > > at > > > > > > org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:825) > > > at > > > > > > org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:275) > > > at > > > org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:524) > > > at > > > > > > org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:72) > > > at > > > > > > org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169) > > > at > > > > > > org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:110) > > > at > > > > > > org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:97) > > > at > > > > > > org.eclipse.jetty.server.handler.gzip.GzipHandler.doStart(GzipHandler.java:425) > > > at > > > > > > org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:72) > > > at > > > > > > org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169) > > > at > > > > > > org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:117) > > > at > > > > > > org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:97) > > > at > > > > > > org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:72) > > > at > > > > > > org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169) > > > at org.eclipse.jetty.server.Server.start(Server.java:407) > > > at > > > > > > org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:110) > > > at > > > > > > org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:97) > > > at org.eclipse.jetty.server.Server.doStart(Server.java:371) > > > at > > > > > > org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:72) > > > at > > org.apache.cloudstack.ServerDaemon.start(ServerDaemon.java:188) > > > at > org.apache.cloudstack.ServerDaemon.main(ServerDaemon.java:104) > > > 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) > > > ... 86 more > > > Caused by: javax.net.ssl.SSLHandshakeException: NotAfter: Thu Jan 06 > > > 12:49:29 IST 2011 > > > at > > > java.base/sun.security.ssl.Alert.createSSLException(Alert.java:131) > > > at > > > > > > java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:349) > > > at > > > > > > java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:292) > > > ... 97 more > > > Caused by: java.security.cert.CertificateExpiredException: NotAfter: > Thu > > > Jan 06 12:49:29 IST 2011 > > > at > > > > > > java.base/sun.security.x509.CertificateValidity.valid(CertificateValidity.java:277) > > > at > > > > > > java.base/sun.security.x509.X509CertImpl.checkValidity(X509CertImpl.java:675) > > > at > > > > > > java.base/sun.security.x509.X509CertImpl.checkValidity(X509CertImpl.java:648) > > > ... 98 more > > > > > > > > > I have followed this link to fix this problem. But no solution has come > > > out. Please help me to solve this. > > > > > > https://github.com/apache/cloudstack/issues/4027 > > > [https://avatars.githubusercontent.com/u/47359?s=400&v=4]< > > > https://github.com/apache/cloudstack/issues/4027> > > > HTTP ERROR 503 Problem accessing /client/. Reason: Service Unavailable > · > > > Issue #4027 · apache/cloudstack · GitHub< > > > https://github.com/apache/cloudstack/issues/4027> > > > I have the same problem with a fresh install of CloudStack 4.13.0 on > > > CentOS Linux release 7.8.2003 (Core) Update: I fixed the problem by > doing > > > the following : > > > github.com > > > > > > Thanks & Regards > > > Pradeep > > > > > > > > > > > -- > > Andrija Panić > -- Andrija Panić
