> -----Original Message----- > From: Chip Childers [mailto:chip.child...@sungard.com] > Sent: Monday, July 09, 2012 10:34 AM > To: cloudstack-dev@incubator.apache.org > Subject: Re: [RFC] DevCloud, an all-in-one-box CloudStack development > environment > > Edison, > > I'm getting database connection issues (I'm past the root password > config) during the rdeploydb ant task. > > I'll keep debugging, but a pointer would be helpful. > > Here's the command I'm using: > > # ant rdeploydb -Drhost=127.0.0.1 -Drport=2222 > > Here's the relevant log: > > [sshexec] deploy-cloudstack-db: > [sshexec] > [sshexec] [echo] deploydb server-setup.xml templates.sql > [sshexec] > [sshexec] [exec] Recreating Database cloud. > [sshexec] > [sshexec] [exec] Recreating Database cloud_usage > [sshexec] > [sshexec] [exec] CP is > ./:/opt/cloudstack/apache-tomcat-6.0.32/conf:/opt/cloudstack/apache- > tomcat-6.0.32/webapps/client/WEB-INF/lib/cloud- > agent.jar:/opt/cloudstack/apache-tomcat-6.0.32/webapps/client/WEB- > INF/lib/cloud-api.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/webapps/client/WEB-INF/lib/cloud- > axis.jar:/opt/cloudstack/apache-tomcat-6.0.32/webapps/client/WEB- > INF/lib/cloud-backport-util-concurrent-3.0.jar:/opt/cloudstack/apache- > tomcat-6.0.32/webapps/client/WEB-INF/lib/cloud-bcprov-jdk16- > 1.45.jar:/opt/cloudstack/apache-tomcat-6.0.32/webapps/client/WEB- > INF/lib/cloud-cglib.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/webapps/client/WEB-INF/lib/cloud-commons-codec- > 1.5.jar:/opt/cloudstack/apache-tomcat-6.0.32/webapps/client/WEB- > INF/lib/cloud-commons-collections-3.2.1.jar:/opt/cloudstack/apache- > tomcat-6.0.32/webapps/client/WEB-INF/lib/cloud-commons-configuration- > 1.8.jar:/opt/cloudstack/apache-tomcat-6.0.32/webapps/client/WEB- > INF/lib/cloud-commons-dbcp-1.4.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/webapps/client/WEB-INF/lib/clo > [sshexec] ud-commons-discovery.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/webapps/client/WEB-INF/lib/cloud-commons-httpclient- > 3.1.jar:/opt/cloudstack/apache-tomcat-6.0.32/webapps/client/WEB- > INF/lib/cloud-commons-lang-2.6.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/webapps/client/WEB-INF/lib/cloud-commons-logging- > 1.1.1.jar:/opt/cloudstack/apache-tomcat-6.0.32/webapps/client/WEB- > INF/lib/cloud-commons-pool-1.5.6.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/webapps/client/WEB-INF/lib/cloud-console- > proxy.jar:/opt/cloudstack/apache-tomcat-6.0.32/webapps/client/WEB- > INF/lib/cloud-core.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/webapps/client/WEB-INF/lib/cloud-dp-user-concentrated- > pod.jar:/opt/cloudstack/apache-tomcat-6.0.32/webapps/client/WEB- > INF/lib/cloud-dp-user-dispersing.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/webapps/client/WEB-INF/lib/cloud- > ehcache.jar:/opt/cloudstack/apache-tomcat-6.0.32/webapps/client/WEB- > INF/lib/cloud-email.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/webapps/client/WEB-INF/lib/cloud-google-gson- > 1.7.1.jar:/opt/cloud > [sshexec] stack/apache-tomcat-6.0.32/webapps/client/WEB- > INF/lib/cloud-host-allocator-random.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/webapps/client/WEB-INF/lib/cloud-httpcore- > 4.0.jar:/opt/cloudstack/apache-tomcat-6.0.32/webapps/client/WEB- > INF/lib/cloud-iControl.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/webapps/client/WEB-INF/lib/cloud-jasypt- > 1.8.jar:/opt/cloudstack/apache-tomcat-6.0.32/webapps/client/WEB- > INF/lib/cloud-jnetpcap.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/webapps/client/WEB-INF/lib/cloud-jsch- > 0.1.42.jar:/opt/cloudstack/apache-tomcat-6.0.32/webapps/client/WEB- > INF/lib/cloud-jstl-1.2.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/webapps/client/WEB-INF/lib/cloud- > junit.jar:/opt/cloudstack/apache-tomcat-6.0.32/webapps/client/WEB- > INF/lib/cloud-libvirt-0.4.5.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/webapps/client/WEB-INF/lib/cloud-log4j- > extras.jar:/opt/cloudstack/apache-tomcat-6.0.32/webapps/client/WEB- > INF/lib/cloud-log4j.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/webapps/client/WEB-INF/lib/cloud-manageontap.jar:/opt/clouds > [sshexec] tack/apache-tomcat-6.0.32/webapps/client/WEB-INF/lib/cloud- > netscaler.jar:/opt/cloudstack/apache-tomcat-6.0.32/webapps/client/WEB- > INF/lib/cloud-netscaler-sdx.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/webapps/client/WEB-INF/lib/cloud-ovm.jar:/opt/cloudstack/apache- > tomcat-6.0.32/webapps/client/WEB-INF/lib/cloud-plugin- > elb.jar:/opt/cloudstack/apache-tomcat-6.0.32/webapps/client/WEB- > INF/lib/cloud-plugin-f5.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/webapps/client/WEB-INF/lib/cloud-plugin- > netapp.jar:/opt/cloudstack/apache-tomcat-6.0.32/webapps/client/WEB- > INF/lib/cloud-plugin-netscaler.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/webapps/client/WEB-INF/lib/cloud-plugin- > ovs.jar:/opt/cloudstack/apache-tomcat-6.0.32/webapps/client/WEB- > INF/lib/cloud-plugin-srx.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/webapps/client/WEB-INF/lib/cloud- > server.jar:/opt/cloudstack/apache-tomcat-6.0.32/webapps/client/WEB- > INF/lib/cloud-storage-allocator-random.jar:/opt/cloudstack/apache- > tomcat-6.0.32/webapps/client/WEB-INF/lib/cloud-trilead-ssh2-build > [sshexec] 213.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/webapps/client/WEB-INF/lib/cloud-user-authenticator- > ldap.jar:/opt/cloudstack/apache-tomcat-6.0.32/webapps/client/WEB- > INF/lib/cloud-user-authenticator-md5.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/webapps/client/WEB-INF/lib/cloud-user-authenticator- > plaintext.jar:/opt/cloudstack/apache-tomcat-6.0.32/webapps/client/WEB- > INF/lib/cloud-utils.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/webapps/client/WEB-INF/lib/cloud-vmware- > base.jar:/opt/cloudstack/apache-tomcat-6.0.32/webapps/client/WEB- > INF/lib/cloud-vmware.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/webapps/client/WEB-INF/lib/cloud-ws-commons-util- > 1.0.2.jar:/opt/cloudstack/apache-tomcat-6.0.32/webapps/client/WEB- > INF/lib/cloud-wsdl4j-1.6.2.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/webapps/client/WEB-INF/lib/cloud- > wsdl4j.jar:/opt/cloudstack/apache-tomcat-6.0.32/webapps/client/WEB- > INF/lib/cloud-xen.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/webapps/client/WEB-INF/lib/cloud-xenserver-5.6.100- > 1.jar:/opt/cloudstack/apache-tomcat-6.0.32 > [sshexec] /webapps/client/WEB-INF/lib/cloud-xmlrpc-client- > 3.1.3.jar:/opt/cloudstack/apache-tomcat-6.0.32/webapps/client/WEB- > INF/lib/cloud-xmlrpc-common-3.1.3.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/webapps/client/WEB-INF/lib/cloud-xstream- > 1.3.1.jar:/opt/cloudstack/apache-tomcat-6.0.32/webapps/client/WEB- > INF/lib/vmware-apputils.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/webapps/client/WEB-INF/lib/vmware-lib- > jaxrpc.jar:/opt/cloudstack/apache-tomcat-6.0.32/webapps/client/WEB- > INF/lib/vmware-vim25.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/webapps/client/WEB-INF/lib/vmware- > vim.jar:/opt/cloudstack/apache-tomcat-6.0.32/lib/annotations- > api.jar:/opt/cloudstack/apache-tomcat-6.0.32/lib/catalina- > ant.jar:/opt/cloudstack/apache-tomcat-6.0.32/lib/catalina- > ha.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/lib/catalina.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/lib/catalina-tribes.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/lib/cloud-mysql-connector-java-5.1.7- > bin.jar:/opt/cloudstack/apache-tomcat-6.0.32/lib/ecj- > 3.3.1.jar:/opt/cloudstack/apache-tomc > [sshexec] at-6.0.32/lib/el-api.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/lib/jasper-el.jar:/opt/cloudstack/apache-tomcat- > 6.0.32/lib/jasper.jar:/opt/cloudstack/apache-tomcat-6.0.32/lib/jsp- > api.jar:/opt/cloudstack/apache-tomcat-6.0.32/lib/mysql-connector-java- > 5.1.7-bin.jar:/opt/cloudstack/apache-tomcat-6.0.32/lib/servlet- > api.jar:/opt/cloudstack/apache-tomcat-6.0.32/lib/tomcat- > coyote.jar:/opt/cloudstack/apache-tomcat-6.0.32/lib/tomcat- > dbcp.jar:/opt/cloudstack/apache-tomcat-6.0.32/lib/tomcat-i18n- > es.jar:/opt/cloudstack/apache-tomcat-6.0.32/lib/tomcat-i18n- > fr.jar:/opt/cloudstack/apache-tomcat-6.0.32/lib/tomcat-i18n-ja.jar > [sshexec] > [sshexec] [exec] Log4j configuration from : > /opt/cloudstack/apache-tomcat-6.0.32/conf/log4j-cloud.xml > [sshexec] > [sshexec] [exec] ERROR [cloud.test.DatabaseConfig] (main:) > error creating service offering > [sshexec] > [sshexec] [exec] > com.cloud.utils.exception.CloudRuntimeException: DB Exception on: null > [sshexec] > [sshexec] [exec] at > com.cloud.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1310) > [sshexec] > [sshexec] [exec] at > com.cloud.utils.db.DatabaseCallback.intercept(DatabaseCallback.java:34) > [sshexec] > [sshexec] [exec] at > com.cloud.test.DatabaseConfig.saveServiceOffering(DatabaseConfig.java:9 > 24) > [sshexec] > [sshexec] [exec] at > com.cloud.utils.db.DatabaseCallback.intercept(DatabaseCallback.java:34) > [sshexec] > [sshexec] [exec] at > com.cloud.test.DatabaseConfig.saveCurrentObject(DatabaseConfig.java:456) > [sshexec] > [sshexec] [exec] at > com.cloud.test.DatabaseConfig.access$100(DatabaseConfig.java:62) > [sshexec] > [sshexec] [exec] at > com.cloud.test.DatabaseConfig$DbConfigXMLHandler.endElement(DatabaseCon > fig.java:1289) > [sshexec] > [sshexec] [exec] at > com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement > (AbstractSAXParser.java:604) > [sshexec] > [sshexec] [exec] at > com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl. > scanEndElement(XMLDocumentFragmentScannerImpl.java:1759) > [sshexec] > [sshexec] [exec] at > com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$ > FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2915) > [sshexec] [exec] at > com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XML > DocumentScannerImpl.java:625) > [sshexec] [exec] at > com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl. > scanDocument(XMLDocumentFragmentScannerImpl.java:488) > [sshexec] [exec] at > com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML > 11Configuration.java:819) > [sshexec] [exec] at > com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML > 11Configuration.java:748) > [sshexec] [exec] at > com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.ja > va:123) > [sshexec] [exec] at > com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Abst > ractSAXParser.java:1208) > [sshexec] [exec] at > com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.par > se(SAXParserImpl.java:525) > [sshexec] [exec] at > javax.xml.parsers.SAXParser.parse(SAXParser.java:392) > [sshexec] [exec] at > javax.xml.parsers.SAXParser.parse(SAXParser.java:328) > [sshexec] [exec] at > com.cloud.test.DatabaseConfig.doConfig(DatabaseConfig.java:424) > [sshexec] [exec] at > com.cloud.utils.db.DatabaseCallback.intercept(DatabaseCallback.java:34) > [sshexec] [exec] at > com.cloud.test.DatabaseConfig.main(DatabaseConfig.java:365) > [sshexec] [exec] Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: > Could not create connection to database server. Attempted reconnect 3 > times. Giving up. > [sshexec] [exec] at > sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > [sshexec] [exec] at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructor > AccessorImpl.java:57) > [sshexec] [exec] at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCon > structorAccessorImpl.java:45) > [sshexec] [exec] at > java.lang.reflect.Constructor.newInstance(Constructor.java:532) > [sshexec] [exec] at > com.mysql.jdbc.Util.handleNewInstance(Util.java:406) > [sshexec] [exec] at > com.mysql.jdbc.Util.getInstance(Util.java:381) > [sshexec] [exec] at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984) > [sshexec] [exec] at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) > [sshexec] [exec] at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) > [sshexec] [exec] at > com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2270) > [sshexec] [exec] at > com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:723) > [sshexec] > [sshexec] [exec] at > com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46) > [sshexec] > [sshexec] [exec] at > sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > [sshexec] > [sshexec] [exec] at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructor > AccessorImpl.java:57) > [sshexec] > [sshexec] [exec] at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCon > structorAccessorImpl.java:45) > [sshexec] > [sshexec] [exec] at > java.lang.reflect.Constructor.newInstance(Constructor.java:532) > [sshexec] > [sshexec] [exec] at > com.mysql.jdbc.Util.handleNewInstance(Util.java:406) > [sshexec] [exec] at > com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302) > [sshexec] [exec] at > com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:2 > 82) > [sshexec] [exec] at > java.sql.DriverManager.getConnection(DriverManager.java:620) > [sshexec] [exec] at > java.sql.DriverManager.getConnection(DriverManager.java:200) > [sshexec] [exec] at > org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection > (DriverManagerConnectionFactory.java:75) > [sshexec] [exec] at > org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableCo > nnectionFactory.java:582) > [sshexec] [exec] at > org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObje > ctPool.java:1181) > [sshexec] [exec] at > org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSour > ce.java:106) > [sshexec] [exec] at > com.cloud.utils.db.Transaction.getConnection(Transaction.java:514) > [sshexec] [exec] at > com.cloud.utils.db.Transaction.prepareAutoCloseStatement(Transaction.ja > va:445) > [sshexec] [exec] at > com.cloud.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1268) > [sshexec] [exec] ... 33 more > [sshexec] [exec] Caused by: > com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: > Communications link failure > [sshexec] [exec] > [sshexec] [exec] Last packet sent to the server was 0 ms ago. > [sshexec] [exec] ... 60 more > [sshexec] [exec] Caused by: java.net.UnknownHostException: > @DBHOST@ > [sshexec] [exec] ... 58 more > > Wash, rinse, repeat on many other similar exceptions...
It's a bug the latest master, replace.properties is missing under build directory. I'll fix it. > > -chip
