topic ant demo.start - Could not create connection to database in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/ant-demo-start-could-not-create-connection-to-database/m-p/24247#M11808 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>I am missing an detailed INSTALL procedure, however I tried to follow these steps to set up an demo instance:</SPAN><BR /><A href="http://activiti.org/userguide/index.html#demo.setup" rel="nofollow noopener noreferrer">http://activiti.org/userguide/index.html#demo.setup</A><BR /><BR /><SPAN>OS is&nbsp; Debian Testing amd64 on ESX. </SPAN><BR /><SPAN># java -version</SPAN><BR /><SPAN>java version "1.6.0_22"</SPAN><BR /><SPAN>Java(TM) SE Runtime Environment (build 1.6.0_22-b04)</SPAN><BR /><SPAN>Java HotSpot(TM) 64-Bit Server VM (build 17.1-b03, mixed mode)</SPAN><BR /><BR /><SPAN>tomcat version 6.0.28-9 is running and listening on port 8080</SPAN><BR /><BR /><SPAN>mysqld version 5.1.49-3 is running and listening on&nbsp; 127.0.0.1:3306</SPAN><BR /><SPAN>User activiti created with access to db activiti</SPAN><BR /><BR /><SPAN>| GRANT USAGE ON *.* TO 'activiti'@'localhost' IDENTIFIED BY PASSWORD '*D5467AF2C8A3ECE7ACF4EFE59E829CF76B8ABB05' |</SPAN><BR /><SPAN>| GRANT ALL PRIVILEGES ON `activiti`.* TO 'activiti'@'localhost'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</SPAN><BR /><BR /><SPAN>libmysql-java 5.1.10+dfsg-2 installed.</SPAN><BR /><BR /><SPAN>I unziped activiti-5.0.zip to /root/activiti2 and changed to directory setup</SPAN><BR /><SPAN>and modified properties</SPAN><BR /><BR /><SPAN># egrep -v "^#|^ *$" build.properties </SPAN><BR /><SPAN>db=mysql</SPAN><BR /><SPAN>tx=standalone</SPAN><BR /><SPAN>tomcat.version=6.0.28</SPAN><BR /><SPAN>feature.cycle=enabled</SPAN><BR /><SPAN>feature.modeler=enabled</SPAN><BR /><BR /><SPAN># egrep -v "^#|^ *$" build.mysql.properties </SPAN><BR /><SPAN>db=mysql</SPAN><BR /><SPAN>jdbc.driver=com.mysql.jdbc.Driver</SPAN><BR /><SPAN>jdbc.url=jdbc:mysql://127.0.0.1:3306/activiti?autoReconnect=true</SPAN><BR /><SPAN>jdbc.username=activiti</SPAN><BR /><SPAN>jdbc.password=activiti</SPAN><BR /><BR /><SPAN>I did not set JAVA_HOME and ANT_HOME environment variables since I have no clue what they should be set to.</SPAN><BR /><SPAN>Now I get this error:</SPAN><BR /><BR /><SPAN># ant demo.start</SPAN><BR /><SPAN>Buildfile: /root/activiti2/setup/build.xml</SPAN><BR /><BR /><SPAN>demo.install:</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; [echo] installing demo</SPAN><BR /><BR /><SPAN>internal.define.jdbc.driver.libs:</SPAN><BR /><BR /><SPAN>build.webapps:</SPAN><BR /><BR /><SPAN>h2.install:</SPAN><BR /><BR /><SPAN>internal.classpath.libs:</SPAN><BR /><BR /><SPAN>internal.taskdef.launch:</SPAN><BR /><BR /><SPAN>h2.start:</SPAN><BR /><BR /><SPAN>db.create:</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; [echo] creating db</SPAN><BR /><BR /><SPAN>internal.classpath.libs:</SPAN><BR /><BR /><SPAN>internal.classpath.libs:</SPAN><BR /><BR /><SPAN>internal.db.create.engine:</SPAN><BR /><BR /><SPAN>BUILD FAILED</SPAN><BR /><SPAN>/root/activiti2/setup/build.xml:145: The following error occurred while executing this line:</SPAN><BR /><SPAN>/root/activiti2/setup/build.xml:182: The following error occurred while executing this line:</SPAN><BR /><SPAN>/root/activiti2/setup/build.xml:192: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Constructor.newInstance(Constructor.java:513)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.Util.getInstance(Util.java:381)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2253)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.ConnectionImpl.&lt;init&gt;(ConnectionImpl.java:718)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.JDBC4Connection.&lt;init&gt;(JDBC4Connection.java:46)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Constructor.newInstance(Constructor.java:513)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:370)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.taskdefs.SQLExec.getConnection(SQLExec.java:942)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:614)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.Task.perform(Task.java:348)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.Target.execute(Target.java:390)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.Target.performTasks(Target.java:411)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1360)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.Project.executeTargets(Project.java:1212)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:441)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.Task.perform(Task.java:348)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.Target.execute(Target.java:390)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.Target.performTasks(Target.java:411)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1360)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.Project.executeTargets(Project.java:1212)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:441)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.Task.perform(Task.java:348)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.Target.execute(Target.java:390)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.Target.performTasks(Target.java:411)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1360)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.Project.executeTarget(Project.java:1329)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.Project.executeTargets(Project.java:1212)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.Main.runBuild(Main.java:801)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.Main.startAnt(Main.java:218)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)</SPAN><BR /><SPAN>Caused by: java.net.SocketException: Network is unreachable</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.PlainSocketImpl.socketConnect(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.Socket.connect(Socket.java:529)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.Socket.connect(Socket.java:478)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.Socket.&lt;init&gt;(Socket.java:375)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.Socket.&lt;init&gt;(Socket.java:218)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.MysqlIO.&lt;init&gt;(MysqlIO.java:280)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2177)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; … 54 more</SPAN><BR /><BR /><SPAN>Total time: 7 seconds</SPAN><BR /><BR /><BR /><SPAN>I have no idea why this happens because "mysql -h 127.0.0.1 -u activiti -pactiviti activiti" just works fine.</SPAN><BR /><SPAN>If I do the "ant demo.start" I do not see any connections attemps to 127.0.0.1:3306</SPAN><BR /><BR /><SPAN>Help is much appreciated</SPAN></BODY></HTML> Wed, 29 Dec 2010 15:22:35 GMT perl 2010-12-29T15:22:35Z ant demo.start - Could not create connection to database https://connect.hyland.com/t5/alfresco-archive/ant-demo-start-could-not-create-connection-to-database/m-p/24247#M11808 Hello,I am missing an detailed INSTALL procedure, however I tried to follow these steps to set up an demo instance:http://activiti.org/userguide/index.html#demo.setupOS is&nbsp; Debian Testing amd64 on ESX. # java -versionjava version "1.6.0_22"Java(TM) SE Runtime Environment (build 1.6.0_22-b04)Java Hot Wed, 29 Dec 2010 15:22:35 GMT https://connect.hyland.com/t5/alfresco-archive/ant-demo-start-could-not-create-connection-to-database/m-p/24247#M11808 perl 2010-12-29T15:22:35Z Re: ant demo.start - Could not create connection to database https://connect.hyland.com/t5/alfresco-archive/ant-demo-start-could-not-create-connection-to-database/m-p/24248#M11809 <HTML><HEAD></HEAD><BODY><SPAN>Found the problem, activity was trying to access mysql using ipv6</SPAN><BR /><SPAN>but mysql is not listening to ipv6</SPAN><BR /><BR /><SPAN>Disabling of ipv6 by</SPAN><BR /><BR /><SPAN>sysctl -w net.ipv6.conf.all.disable_ipv6=1"</SPAN><BR /><BR /><SPAN>helped.</SPAN></BODY></HTML> Wed, 29 Dec 2010 16:23:17 GMT https://connect.hyland.com/t5/alfresco-archive/ant-demo-start-could-not-create-connection-to-database/m-p/24248#M11809 perl 2010-12-29T16:23:17Z