|SEVERE: Unable to open connection. [message #521084]
||Tue, 16 March 2010 08:47
Registered: March 2010
I'm rather new to BIRT and was getting along just fine, but now I'm stuck with a database connection problem.|
(Using Birt 2.5.1)
I created my report on my desktop with a JDBC Connection to my MYSQL database on another machine, by hardcoding the IP of the MYSQL server. This worked fine until of course when I try to deploy the report to production and the IP is different.
So, I set up a SSH tunnel to forward localhost:3306 to mysqlserver:3306.
Mysqlserver is the same machine the reprots will be deployed to, assuming then that the deployed report would happily connect to localhost on the production server.
The report (and I've recreated the simplest of reports to test with) works on my desktop, but when I deploy the report to the remote machine I keep getting:
16 Mar 2010 2:14:15 PM org.eclipse.birt.data.engine.odaconsumer.ConnectionManager openConnection
SEVERE: Unable to open connection.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, 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..
The connection in the rptdesign file is as follows
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="7">
<encrypted-property name="odaPassword" encryptionID="base64">Y2xpZW50X3Bhc3M=</encrypted-property>
And I can happily connect to mysql from localhost with username probe and supplied password.
But for some reason BIRT does not want to connect via jdbc driver ??
|Re: SEVERE: Unable to open connection. [message #824705 is a reply to message #521146]
||Mon, 19 March 2012 20:39
| Meghan Missing name
Registered: November 2010
I'm wondering if you might have some insight. I have been working in the BIRT tool for some time and have established a connection to MySQL using the jdbc driver (v5.1). It has worked consistently up until about a week ago when all of a sudden it stopped working. I get the following error message:
'There is an error in get connection. Communication link failure. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server'
Nothing, to my knowledge has changed. Do you know where I can look next to troubleshoot? At this point all of my report editing/creation has come to a stand still so I'm really stuck. Any help is appreciated.
[Updated on: Mon, 19 March 2012 20:40]
Report message to a moderator
Powered by FUDForum
. Page generated in 0.07317 seconds