Getting connected to our database

[dgespejo]

I just installed the iReport and I'm trying to connect to the database in our server but no luck. The url of our server is http://support2/dbm. Every time I press the TEST button, an error pops up. What could be the error?

[dgespejo]

The error message is attached

[dgespejo]

Exception

 

 

Message:

java.sql.SQLException: null, message from server: "Host '192.168.1.254' is not allowed to connect to this MySQL server"

Level:

SEVERE

Stack Trace:

com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:991)

com.mysql.jdbc.Connection.createNewIO(Connection.java:2544)

com.mysql.jdbc.Connection.<init>(Connection.java:1474)

com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)

it.businesslogic.ireport.connection.JDBCConnection.getConnection(JDBCConnection.java:105)

it.businesslogic.ireport.connection.JDBCConnection.test(JDBCConnection.java:404)

it.businesslogic.ireport.connection.gui.ConnectionDialog.jButtonTestActionPerformed(ConnectionDialog.java:322)

it.businesslogic.ireport.connection.gui.ConnectionDialog.access$300(ConnectionDialog.java:24)

it.businesslogic.ireport.connection.gui.ConnectionDialog$4.actionPerformed(ConnectionDialog.java:274)

javax.swing.AbstractButton.fireActionPerformed(Unknown Source)

javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)

javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)

javax.swing.DefaultButtonModel.setPressed(Unknown Source)

javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)

java.awt.Component.processMouseEvent(Unknown Source)

javax.swing.JComponent.processMouseEvent(Unknown Source)

java.awt.Component.processEvent(Unknown Source)

java.awt.Container.processEvent(Unknown Source)

java.awt.Component.dispatchEventImpl(Unknown Source)

java.awt.Container.dispatchEventImpl(Unknown Source)

java.awt.Component.dispatchEvent(Unknown Source)

java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)

java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)

java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)

java.awt.Container.dispatchEventImpl(Unknown Source)

java.awt.Window.dispatchEventImpl(Unknown Source)

java.awt.Component.dispatchEvent(Unknown Source)

java.awt.EventQueue.dispatchEvent(Unknown Source)

java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)

java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

java.awt.Dialog$1.run(Unknown Source)

java.awt.Dialog$3.run(Unknown Source)

java.security.AccessController.doPrivileged(Native Method)

java.awt.Dialog.show(Unknown Source)

java.awt.Component.show(Unknown Source)

java.awt.Component.setVisible(Unknown Source)

java.awt.Window.setVisible(Unknown Source)

java.awt.Dialog.setVisible(Unknown Source)

it.businesslogic.ireport.gui.ConnectionsDialog.jButtonNewParameterActionPerformed(ConnectionsDialog.java:550)

it.businesslogic.ireport.gui.ConnectionsDialog.access$200(ConnectionsDialog.java:53)

it.businesslogic.ireport.gui.ConnectionsDialog$6.actionPerformed(ConnectionsDialog.java:216)

javax.swing.AbstractButton.fireActionPerformed(Unknown Source)

javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)

javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)

javax.swing.DefaultButtonModel.setPressed(Unknown Source)

javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)

java.awt.Component.processMouseEvent(Unknown Source)

javax.swing.JComponent.processMouseEvent(Unknown Source)

java.awt.Component.processEvent(Unknown Source)

java.awt.Container.processEvent(Unknown Source)

java.awt.Component.dispatchEventImpl(Unknown Source)

java.awt.Container.dispatchEventImpl(Unknown Source)

java.awt.Component.dispatchEvent(Unknown Source)

java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)

java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)

java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)

java.awt.Container.dispatchEventImpl(Unknown Source)

java.awt.Window.dispatchEventImpl(Unknown Source)

java.awt.Component.dispatchEvent(Unknown Source)

java.awt.EventQueue.dispatchEvent(Unknown Source)

java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)

java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

java.awt.Dialog$1.run(Unknown Source)

java.awt.Dialog$3.run(Unknown Source)

java.security.AccessController.doPrivileged(Native Method)

java.awt.Dialog.show(Unknown Source)

java.awt.Component.show(Unknown Source)

java.awt.Component.setVisible(Unknown Source)

java.awt.Window.setVisible(Unknown Source)

java.awt.Dialog.setVisible(Unknown Source)

it.businesslogic.ireport.gui.ConnectionsDialog.setVisible(ConnectionsDialog.java:623)

it.businesslogic.ireport.gui.ToolbarConnectionPanel.jButtonDatasourcesActionPerformed(ToolbarConnectionPanel.java:114)

it.businesslogic.ireport.gui.ToolbarConnectionPanel.access$100(ToolbarConnectionPanel.java:45)

it.businesslogic.ireport.gui.ToolbarConnectionPanel$2.actionPerformed(ToolbarConnectionPanel.java:100)

javax.swing.AbstractButton.fireActionPerformed(Unknown Source)

javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)

javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)

javax.swing.DefaultButtonModel.setPressed(Unknown Source)

javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)

java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)

java.awt.Component.processMouseEvent(Unknown Source)

javax.swing.JComponent.processMouseEvent(Unknown Source)

java.awt.Component.processEvent(Unknown Source)

java.awt.Container.processEvent(Unknown Source)

java.awt.Component.dispatchEventImpl(Unknown Source)

java.awt.Container.dispatchEventImpl(Unknown Source)

java.awt.Component.dispatchEvent(Unknown Source)

java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)

java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)

java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)

java.awt.Container.dispatchEventImpl(Unknown Source)

java.awt.Window.dispatchEventImpl(Unknown Source)

java.awt.Component.dispatchEvent(Unknown Source)

java.awt.EventQueue.dispatchEvent(Unknown Source)

java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)

java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)

java.awt.EventDispatchThread.pumpEvents(Unknown Source)

java.awt.EventDispatchThread.pumpEvents(Unknown Source)

java.awt.EventDispatchThread.run(Unknown Source)

[dgespejo]

The error message is attached

[lshannon]

Looks like a security issue. You should check with IT team to see if you can access this server.

 

A simple test you can try. Ping the DB server from the command line of your machine. If this fails then you can be sure it is a security issue. If it succeeds then perhaps the DB server is not using MySQL's default port of 3309, maybe they are using a different port.

 

Either way I don't think this is a iReport issue.