I’m running the 64 bit version of Ubuntu 14.04 LTS and I’m getting all sorts of database errors. Did not have this problem with the 32 bit. Would like to finish Inductive Univeristy but it won’t load the challenge file without errors.
Can you give us some kind of hint about the errors?
Here is the status of the DB
hide Details
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (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.)
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.getConnectionInternal(DatasourceImpl.java:199)com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.runTest(DatasourceImpl.java:155)com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl$FaultedDatasourceRetryer$1.run(DatasourceManagerImpl.java:1121)com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$TrackedTask.run(BasicExecutionEngine.java:573)java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)java.lang.Thread.run(Thread.java:745)
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: 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.
sun.reflect.GeneratedConstructorAccessor45.newInstance(Unknown Source)sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)java.lang.reflect.Constructor.newInstance(Constructor.java:408)com.mysql.jdbc.Util.handleNewInstance(Util.java:411)com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117)com.mysql.jdbc.MysqlIO.(MysqlIO.java:355)com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2461)com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2498)com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2283)com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:822)com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)sun.reflect.GeneratedConstructorAccessor41.newInstance(Unknown Source)sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)java.lang.reflect.Constructor.newInstance(Constructor.java:408)com.mysql.jdbc.Util.handleNewInstance(Util.java:411)com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404)com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317)org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.getConnectionInternal(DatasourceImpl.java:199)com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.runTest(DatasourceImpl.java:155)com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl$FaultedDatasourceRetryer$1.run(DatasourceManagerImpl.java:1121)com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$TrackedTask.run(BasicExecutionEngine.java:573)java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)java.lang.Thread.run(Thread.java:745)
java.net.ConnectException: Connection refused
java.net.PlainSocketImpl.socketConnect(Native Method)java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:345)java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)java.net.Socket.connect(Socket.java:589)sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)java.lang.reflect.Method.invoke(Method.java:483)com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:332)com.mysql.jdbc.MysqlIO.(MysqlIO.java:305)com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2461)com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2498)com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2283)com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:822)com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)sun.reflect.GeneratedConstructorAccessor41.newInstance(Unknown Source)sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)java.lang.reflect.Constructor.newInstance(Constructor.java:408)com.mysql.jdbc.Util.handleNewInstance(Util.java:411)com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404)com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317)org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.getConnectionInternal(DatasourceImpl.java:199)com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.runTest(DatasourceImpl.java:155)com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl$FaultedDatasourceRetryer$1.run(DatasourceManagerImpl.java:1121)com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$TrackedTask.run(BasicExecutionEngine.java:573)java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)java.lang.Thread.run(Thread.java:745)
This indicates a network problem with your database connection. Are all the data source connection settings correct? Ports being blocked by firewall?
Here is the port that SQL provided automatically. I did not reconfigure any ports or firewalls but I will take a look at my firewall settings once I figure out how to do that… jdbc:mysql://localhost:3306/test
According to Ubuntu.com the firewall provided is not turned on by default. But I did perform a status check anyway( sudo ufw status) and confirmed that it was inactive.
