i have researched the methods and steps of the setup for the ireport connect to the Kace K1000 database. However, it showed me error during test stage.

 

Name              : K1000

JDBC              : MySQL(com.mysql.jdbc.Driver)

JDBC URL       : jdbc:mysql://K1000/ORG1

Username       : R1

Password        : box747

============================================

SQL problems: Communications link failure

 

Last packet sent to the server was 0 ms ago.

...

 

============================================

 

Please help me...

Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

3

JDBC URL       : jdbc:mysql://K1000/ORG1

needs to be 

jbdc:mysql://<FQDN of your KBox>/ORG1

Answered 07/31/2012 by: dugullett
Red Belt

  • sorry, i not so clear on what is this mean <FQDN of your KBox> ?
    • It stands for "fully qualified domain name". It would be whatever you type in your web address when accessing the kbox minus the /admin.

      So.....
      jbdc:mysql://yourkboxname.domain.org/org1

      This can also be found under the network settings of your kbox. "K1000 Web Server Name".
Please log in to comment

Answers

2

Make sure you have enabled database access as well.

Settings>Security Settings>General Security Settings>Enable database access

R1 is the user and box747 is the password.  This can't be changed without organizations.

Or, if you have organizations enabled:

System>K1000 Settings>Security Settings>Enable database access

Then click Organization and pick the org that you are working with, set a password under Report User Password.  Use that to access the database. R1 is the user if you are in the first org.

Answered 07/31/2012 by: jknox
Red Belt

  • Message:
    java.sql.SQLException: Access denied for user ''@'198.1.1.25' (using password: YES)
    Level:
    SEVERE
    Stack Trace:
    Access denied for user ''@'198.1.1.25' (using password: YES)
    com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
    com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
    com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
    com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
    com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:910)
    com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3923)
    com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1273)
    com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2031)
    com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)
    com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
    sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    java.lang.reflect.Constructor.newInstance(Unknown Source)
    com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
    com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
    com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
    com.jaspersoft.ireport.designer.connection.JDBCConnection.getConnection(JDBCConnection.java:140)
    com.jaspersoft.ireport.designer.connection.JDBCConnection.test(JDBCConnection.java:447)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog.jButtonTestActionPerformed(ConnectionDialog.java:335)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog.access$300(ConnectionDialog.java:43)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog$4.actionPerformed(ConnectionDialog.java:290)
    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.dispatchEventImpl(Unknown Source)
    java.awt.EventQueue.access$200(Unknown Source)
    java.awt.EventQueue$3.run(Unknown Source)
    java.awt.EventQueue$3.run(Unknown Source)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
    java.awt.EventQueue$4.run(Unknown Source)
    java.awt.EventQueue$4.run(Unknown Source)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
    java.awt.EventQueue.dispatchEvent(Unknown Source)
    org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)
    java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    java.awt.WaitDispatchSupport$2.run(Unknown Source)
    java.awt.WaitDispatchSupport$4.run(Unknown Source)
    java.security.AccessController.doPrivileged(Native Method)
    java.awt.WaitDispatchSupport.enter(Unknown Source)
    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)
    com.jaspersoft.ireport.designer.welcome.QuickStartPanel.jButton1ActionPerformed(QuickStartPanel.java:295)
    com.jaspersoft.ireport.designer.welcome.QuickStartPanel.access$200(QuickStartPanel.java:50)
    com.jaspersoft.ireport.designer.welcome.QuickStartPanel$2.actionPerformed(QuickStartPanel.java:124)
    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.dispatchEventImpl(Unknown Source)
    java.awt.EventQueue.access$200(Unknown Source)
    java.awt.EventQueue$3.run(Unknown Source)
    java.awt.EventQueue$3.run(Unknown Source)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
    java.awt.EventQueue$4.run(Unknown Source)
    java.awt.EventQueue$4.run(Unknown Source)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
    java.awt.EventQueue.dispatchEvent(Unknown Source)
    org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)
    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)
  • I still have this message: SQL problems: Access denied for user ''@'198.1.1.25' (using password: YES)
    jdbc:mysql://198.1.1.247/ORG1
Please log in to comment
Answer this question or Comment on this question for clarity