Hi, I have been trying to setup Zeppelin to talk to Apache Ignite, but no success.
I have my ignite servers running on remote nodes. I keep getting this error. I followed this documentation to set it up - http://apacheignite.gridgain.org/v1.1/docs/data-analysis-with-apache-zeppelin ERROR [2016-01-17 23:44:24,598] ({pool-2-thread-2} IgniteSqlInterpreter.java[open]:100) - Can't open connection: java.sql.SQLException: Failed to establish connection. at org.apache.ignite.internal.jdbc.JdbcConnection.isValid(JdbcConnection.java:447) at org.apache.ignite.internal.jdbc.JdbcConnection.<init>(JdbcConnection.java:123) at org.apache.ignite.IgniteJdbcDriver.connect(IgniteJdbcDriver.java:347) at java.sql.DriverManager.getConnection(DriverManager.java:571) at java.sql.DriverManager.getConnection(DriverManager.java:233) at org.apache.zeppelin.ignite.IgniteSqlInterpreter.open(IgniteSqlInterpreter.java:95) at org.apache.zeppelin.interpreter.ClassloaderInterpreter.open(ClassloaderInterpreter.java:74) at org.apache.zeppelin.interpreter.LazyOpenInterpreter.open(LazyOpenInterpreter.java:68) at org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:92) at org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:276) at org.apache.zeppelin.scheduler.Job.run(Job.java:170) at org.apache.zeppelin.scheduler.FIFOScheduler$1.run(FIFOScheduler.java:118) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: class org.apache.ignite.internal.client.GridClientDisconnectedException: Latest topology update failed. at org.apache.ignite.internal.client.impl.connection.GridClientTopology.nodes(GridClientTopology.java:335) at org.apache.ignite.internal.client.impl.GridClientAbstractProjection.projectionNodes(GridClientAbstractProjection.java:312) at org.apache.ignite.internal.client.impl.GridClientAbstractProjection.balancedNode(GridClientAbstractProjection.java:352) at org.apache.ignite.internal.client.impl.GridClientAbstractProjection.withReconnectHandling(GridClientAbstractProjection.java:109) at org.apache.ignite.internal.client.impl.GridClientComputeImpl.executeAsync(GridClientComputeImpl.java:132) at org.apache.ignite.internal.jdbc.JdbcConnection.isValid(JdbcConnection.java:444) ... 18 more Caused by: class org.apache.ignite.internal.client.GridServerUnreachableException: Failed to connect to any of the servers in list: [/127.0.0.1:40075] at org.apache.ignite.internal.client.impl.connection.GridClientConnectionManagerAdapter.connect(GridClientConnectionManagerAdapter.java:414) at org.apache.ignite.internal.client.impl.connection.GridClientConnectionManagerAdapter.init(GridClientConnectionManagerAdapter.java:226) at org.apache.ignite.internal.client.impl.GridClientImpl.tryInitTopology(GridClientImpl.java:498) at org.apache.ignite.internal.client.impl.GridClientImpl.<init>(GridClientImpl.java:194) at org.apache.ignite.internal.client.GridClientFactory.start(GridClientFactory.java:58) at org.apache.ignite.internal.jdbc.JdbcConnection.<init>(JdbcConnection.java:117) ... 17 more Caused by: java.net.ConnectException: Connection refused at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method) at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:744) at sun.nio.ch.SocketAdaptor.connect(SocketAdaptor.java:117) at org.apache.ignite.internal.client.impl.connection.GridClientNioTcpConnection.<init>(GridClientNioTcpConnection.java:217) at org.apache.ignite.internal.client.impl.connection.GridClientConnectionManagerAdapter.connect(GridClientConnectionManagerAdapter.java:463) at org.apache.ignite.internal.client.impl.connection.GridClientConnectionManagerAdapter.connect(GridClientConnectionManagerAdapter.java:399)