Jasper Server & iReport: How to access a datasource in a remote server to create reports

[sebastian_2]

Hello,

I have been trying to find a way to create reports in my windows computer (using iReport 5) for a Jasperserver (community edition) that I have set up in a linux box. Jasperserver works fine and it is able to access my datasource (using JDBC connection to a mysql database, more especifically a infobright sql database).

Now, I want to design reports for that server from my windows computer using that datasource; however, I don't seem to find a way to connect to the datasource from my computer. I have already modyfied the my.cnf file to listen to the address of my windows computer and it is working fine.

My main concern is that I want to be able to design my reports in iReport and then load them to my Jasperserver.

The following is the information I use for the datasource:

driver: com.mysql.jdbc.Driver

URL:  jdbc:mysql://Jasperserver_IP:Port/database

(The database was setup in the jasper server)

username and password were also added

When I try to connect to this datasource I get the following error:

 

net.sf.jasperreports.engine.JRException: 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.

 

at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:129)

 

at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:128)

 

at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.run(Unknown Source)

 

at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)

 

Caused by: 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.

 

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

 

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

 

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

 

at java.lang.reflect.Constructor.newInstance(Unknown Source)

 

at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

 

at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117)

 

at com.mysql.jdbc.MysqlIO.(MysqlIO.java:350)

 

at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2408)

 

at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2445)

 

at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2230)

 

at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:813)

 

at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)

 

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

 

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

 

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

 

at java.lang.reflect.Constructor.newInstance(Unknown Source)

 

at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

 

at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)

 

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:334)

 

at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:167)

 

at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:127)

 

... 3 more

 

Caused by: java.net.ConnectException: Connection refused: connect

 

at java.net.DualStackPlainSocketImpl.connect0(Native Method)

 

at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)

 

at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)

 

at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)

 

at java.net.AbstractPlainSocketImpl.connect(Unknown Source)

 

at java.net.PlainSocketImpl.connect(Unknown Source)

 

at java.net.SocksSocketImpl.connect(Unknown Source)

 

at java.net.Socket.connect(Unknown Source)

 

at java.net.Socket.connect(Unknown Source)

 

at java.net.Socket.(Unknown Source)

 

at java.net.Socket.(Unknown Source)

 

at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:259)

 

at com.mysql.jdbc.MysqlIO.(MysqlIO.java:300)

 

... 17 more

 

Any ideas on how to solve this?

 

Thank you

[brave.net2006]

I'm facing same problem. Did you able to manage to solve this problem by any chance??