MongoDB Connection Issue over SSL

I am Not able to connect mongoDB which is over the SSL. Without SSL its working fine.
I tried to ping from datasource connection setting, but its failing. Additionally I have imported public certificate to my jvm keystore.
 
mongodb connection url that I'm trying with is, 
mongodb://[user]:[password]@[hostname]:[port]/[database]?ssl=true

Find more posts tagged with

Comments

JFreeman

What version of BIRT are you using? 
What version of MongoDB are you using?
 
Can you provide the full stack trace you are receiving when attempting to connect with SSL?

swapnilkamthe

I'm using Birt viewer - 4.4.2 and mongoDB - 2.6.9
Following is part of stacktrace.
org.eclipse.datatools.connectivity.oda.OdaException ; com.mongodb.MongoException$Network: can't call something : /ip:port/admin at org.eclipse.birt.data.oda.mongodb.impl.MDbConnection.existsDatabase(MDbConnectioâ€Œâ€‹n.java:246) at org.eclipse.birt.data.oda.mongodb.impl.MDbConnection.getMongoDatabase(MDbConnectâ€Œâ€‹ion.java:83) 
 
 
What I'm suspecting is the eclipse plugin(org.eclipse.birt.data.oda.mongodb) that birt viewer is using may not be supporting SSL connection.

JFreeman

Alright, I've been digging deeper into this and you are correct in your suspicion that the ODA does not support SSL.
 
I'm going to create an enhancement request in bugzilla to request SSL support be added to the ODA.
 
In the mean time, it is still possible to populate a data set using an SSL connection with mongo but you will not be able to use the out of the box ODA.
 
The option I went with for testing is to create a Scripted Data Source/Set and manually populate the data set with some javascript that uses the MongoDB Java driver. Here is a quick example of the code I used in the Scripted Data Set:
 
Open:
<pre class="_prettyXprint _lang-js">
var muri = new Packages.com.mongodb.MongoClientURI ("mongodb://localhost:27017/test?ssl=true");
mc = new Packages.com.mongodb.MongoClient (muri);
var db = mc.getDB("test");
var c = db.getCollection("test");
cursor = c.find();
x = cursor.count();
i=0;
</pre>
Fetch:
<pre class="_prettyXprint _lang-js">
if(i<x){
var data = cursor.next();
row["id"] = data._id;
row["x"] = data.x;
i++;
return true;
}else{
return false;
}
</pre>
close:
<pre class="_prettyXprint _lang-js">
mc.close();
</pre>
Alternatively, you could look at modifying the ODA or creating your own ODA to add SSL support.
 
There also looks to be a JDBC driver available through a third party (doesn't look open source and appears to require a license) which should be able to be added to the designer.

JFreeman

I've been digging even deeper into this and it is not actually the ODA that doesn't support SSL, it is the version of the Mongo Java driver the ODA is using that is causing the SSL issue.
 
The version included out of the box with the ODA is an eclipse orbit release of the 2.10.1 Mongo Java driver. The newest version of the Mongo Java driver, which is what I was using for testing with scripting, is 3.0.0. However, the ODA uses some method calls that were removed in the 3.0.0 release which means upgrading the 3.0.0 will not work without also making quite a few modifications to the ODA.
 
Fortunately, the 2.13.1 version of the Mongo Java driver is still available for download and includes the method calls that were removed in 3.0.0. By replacing the 2.10.1 version pre-bundled in eclipse with the 2.13.1 version from Mongo, I have been able to successfully connection to Mongo using SSL with the out of the box ODA.
 
In order to change to the 2.13.1 driver, you can follow these steps:
<ul><li>Download the 2.13.1 driver from Mongo here: <a data-ipb='nomediaparse' href='https://oss.sonatype.org/content/repositories/releases/org/mongodb/mongo-java-driver/2.13.1/'>https://oss.sonatype.org/content/repositories/releases/org/mongodb/mongo-java-driver/2.13.1/</a></li>
<li>Shutdown eclipse if it is running</li>
<li>Make a backup of the existing driver (org.eclipse.orbit.mongodb_2.10.1.v20130422-1135.jar) located in the ./eclipse/plugins directory</li>
<li>Remove the existing driver from the plugins directory</li>
<li>Copy the 2.13.1 Mongo driver into the plugins directory</li>
<li>Launch Eclipse</li>
</ul>I connected to my SSL enabled MongoDB by building the URI in the data source with the ssl=true flag. I then built a simple data set from a test database, made a table from the data set and run the report without issue.
 
I've not fully tested all functionality of the ODA against the 2.13.1 driver however, it does appear to be working properly from the testing I have done so far.