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:924)
  [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(DatabaseConfig.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(XMLDocumentScannerImpl.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(XML11Configuration.java:819)
  [sshexec]      [exec]         at
com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:748)
  [sshexec]      [exec]         at
com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:123)
  [sshexec]      [exec]         at
com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1208)
  [sshexec]      [exec]         at
com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(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(NativeConstructorAccessorImpl.java:57)
  [sshexec]      [exec]         at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.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(NativeConstructorAccessorImpl.java:57)
  [sshexec]
  [sshexec]      [exec]         at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.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:282)
  [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(PoolableConnectionFactory.java:582)
  [sshexec]      [exec]         at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1181)
  [sshexec]      [exec]         at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
  [sshexec]      [exec]         at
com.cloud.utils.db.Transaction.getConnection(Transaction.java:514)
  [sshexec]      [exec]         at
com.cloud.utils.db.Transaction.prepareAutoCloseStatement(Transaction.java: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...

-chip

Reply via email to