Home
Designing Analytics Reports
BIRT MongoDB connection issues
Migrateduser
<p>Hello everyone,</p>
<p> </p>
<p> I am a newbie to BIRT/Mongo. We are running Mongo v 3.2 and have the mong-java 2.14.3 jar file.</p>
<p>However, we are unable to connect. The error log is as below :-</p>
<p> </p>
<p>
</p>
<div>org.eclipse.datatools.connectivity.oda.OdaException ;</div>
<div> com.mongodb.MongoTimeoutException: Timed out after 10000 ms while waiting for a server that matches AnyServerSelector{}. Client view of cluster state is {type=Unknown, servers=[{address=hadoopsn.cloudapp.net:27017, type=Unknown, state=Connecting, exception={com.mongodb.MongoException$Network: Exception opening the socket}, caused by {java.net.ConnectException: Connection refused: connect}}]</div>
<div> </div>
<div>at org.eclipse.birt.data.oda.mongodb.impl.MDbConnection.authenticateDB(MDbConnection.java:210)</div>
<div> </div>
<div>at org.eclipse.birt.data.oda.mongodb.impl.MDbConnection.getMongoDatabase(MDbConnection.java:92)</div>
<div> </div>
<div>at org.eclipse.birt.data.oda.mongodb.impl.MDbConnection.open(MDbConnection.java:50)</div>
<div> </div>
<div>at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:250)</div>
<div> </div>
<div>at org.eclipse.datatools.connectivity.oda.profile.OdaConnectionWrapper.open(OdaConnectionWrapper.java:209)</div>
<div> </div>
<div>at org.eclipse.datatools.connectivity.oda.profile.OdaConnectionWrapper.<init>(OdaConnectionWrapper.java:59)</div>
<div> </div>
<div>at org.eclipse.datatools.connectivity.oda.profile.OdaConnectionFactory.createConnection(OdaConnectionFactory.java:26)</div>
<div> </div>
<div>at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)</div>
<div> </div>
<div>at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)</div>
<div> </div>
<div>at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)</div>
<div> </div>
<div>at org.eclipse.datatools.connectivity.oda.design.internal.ui.DataSourceWizardPageCore$1.run(DataSourceWizardPageCore.java:244)</div>
<div> </div>
<div>at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)</div>
<div> </div>
<div>at org.eclipse.datatools.connectivity.ui.wizards.ConnectionProfileDetailsPage.testConnection(ConnectionProfileDetailsPage.java:194)</div>
<div> </div>
<div>at org.eclipse.datatools.connectivity.ui.wizards.ConnectionProfileDetailsPage$2.widgetSelected(ConnectionProfileDetailsPage.java:131)</div>
<div> </div>
<div>at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:249)</div>
<div> </div>
<div>at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)</div>
<div> </div>
<div>at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4410)</div>
<div> </div>
<div>at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1079)</div>
<div> </div>
<div>at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4228)</div>
<div> </div>
<div>at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3816)</div>
<div> </div>
<div>at org.eclipse.jface.window.Window.runEventLoop(Window.java:818)</div>
<div> </div>
<div>at org.eclipse.jface.window.Window.open(Window.java:794)</div>
<div> </div>
<div>at org.eclipse.birt.report.designer.data.ui.actions.NewDataSourceAction.run(NewDataSourceAction.java:127)</div>
<div> </div>
<div>at org.eclipse.jface.action.Action.runWithEvent(Action.java:473)</div>
<div> </div>
<div>at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:565)</div>
<div> </div>
<div>at org.eclipse.jface.action.ActionContributionItem.lambda$4(ActionContributionItem.java:397)</div>
<div> </div>
<div>at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)</div>
<div> </div>
<div>at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4410)</div>
<div> </div>
<div>at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1079)</div>
<div> </div>
<div>at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4228)</div>
<div> </div>
<div>at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3816)</div>
<div> </div>
<div>at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$4.run(PartRenderingEngine.java:1121)</div>
<div> </div>
<div>at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:336)</div>
<div> </div>
<div>at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1022)</div>
<div> </div>
<div>at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:150)</div>
<div> </div>
<div>at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:687)</div>
<div> </div>
<div>at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:336)</div>
<div> </div>
<div>at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:604)</div>
<div> </div>
<div>at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:148)</div>
<div> </div>
<div>at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:138)</div>
<div> </div>
<div>at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)</div>
<div> </div>
<div>at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)</div>
<div> </div>
<div>at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)</div>
<div> </div>
<div>at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:388)</div>
<div> </div>
<div>at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:243)</div>
<div> </div>
<div>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</div>
<div> </div>
<div>at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)</div>
<div> </div>
<div>at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)</div>
<div> </div>
<div>at java.lang.reflect.Method.invoke(Unknown Source)</div>
<div> </div>
<div>at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:673)</div>
<div> </div>
<div>at org.eclipse.equinox.launcher.Main.basicRun(Main.java:610)</div>
<div> </div>
<div>at org.eclipse.equinox.launcher.Main.run(Main.java:1519)</div>
<div> </div>
<div>Caused by: com.mongodb.MongoTimeoutException: Timed out after 10000 ms while waiting for a server that matches AnyServerSelector{}. Client view of cluster state is {type=Unknown, servers=[{address=hadoopsn.cloudapp.net:27017, type=Unknown, state=Connecting, exception={com.mongodb.MongoException$Network: Exception opening the socket}, caused by {java.net.ConnectException: Connection refused: connect}}]</div>
<div> </div>
<div>at com.mongodb.BaseCluster.getServer(BaseCluster.java:82)</div>
<div> </div>
<div>at com.mongodb.DBTCPConnector.getServer(DBTCPConnector.java:669)</div>
<div> </div>
<div>at com.mongodb.DBTCPConnector.access$500(DBTCPConnector.java:40)</div>
<div> </div>
<div>at com.mongodb.DBTCPConnector$MyPort.getConnection(DBTCPConnector.java:518)</div>
<div> </div>
<div>at com.mongodb.DBTCPConnector$MyPort.get(DBTCPConnector.java:461)</div>
<div> </div>
<div>at com.mongodb.DBTCPConnector.authenticate(DBTCPConnector.java:639)</div>
<div> </div>
<div>at com.mongodb.DBApiLayer.doAuthenticate(DBApiLayer.java:247)</div>
<div> </div>
<div>at com.mongodb.DB.authenticateCommandHelper(DB.java:745)</div>
<div> </div>
<div>at com.mongodb.DB.authenticateCommand(DB.java:724)</div>
<div> </div>
<div>at org.eclipse.birt.data.oda.mongodb.impl.MDbConnection.authenticateDB(MDbConnection.java:199)</div>
<div> </div>
<div>... 51 more</div>
<div>
</div>
<div> </div>
<div><strong>I am able to connect to the database through MongoChef with the below configuration</strong></div>
<div> </div>
<div>Server - Localhost port - 27017</div>
<div>Authentication mode - none</div>
<div>SSL - None</div>
<div>SSH Tunnel - hadoopsn.cloudapp.net Port - 22</div>
<div>SSH user name - {user}</div>
<div>SSH password -{password}</div>
<div> </div>
<div>Any pointers of what I need to do to connect through eclipse? I realize it could be something very silly but unable to figure it out. Appreciate your assistance.</div>
<div> </div>
<div>Thanks<br>
Venk</div>
<div> </div>
<div> </div>
<div> </div>
Find more posts tagged with
Comments
There are no comments yet