Dear All,
Who can help my to create a connection with MySQL. I created a JAVA Agent. I open a form and use a button to run the agent. When I use locahost the agent runs and give my results. When iI run this from a server the following displays.
Server error:
29-01-2008 20:54:23 Opened session for Admin Admin/NLD (Release 8.0)
29-01-2008 20:54:43 HTTP JVM: // Get config mysql server op
29-01-2008 20:54:43 HTTP JVM: // Database
29-01-2008 20:54:43 HTTP JVM: // view:Lookup configuration MySQL
29-01-2008 20:54:43 HTTP JVM: // Document found
29-01-2008 20:54:43 HTTP JVM: sUser:test
29-01-2008 20:54:43 HTTP JVM: sPassword:test
29-01-2008 20:54:43 HTTP JVM: sURL:jdbc:mysql://111.111.1.11/
29-01-2008 20:54:43 HTTP JVM: sDatabase:jdbc:mysql://111.111.1.11/jbazar
29-01-2008 20:55:05 HTTP JVM: No communication with MySQL
29-01-2008 20:55:05 HTTP JVM: Message :Communications link failure
Last packet sent to the server was 0 ms ago.
29-01-2008 20:55:05 HTTP JVM: com.mysql.jdbc.CommunicationsException: Communications link failure
Last packet sent to the server was 0 ms ago.
29-01-2008 20:55:05 HTTP JVM: at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1070)
29-01-2008 20:55:05 HTTP JVM: at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2104)
29-01-2008 20:55:05 HTTP JVM: at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:729)
29-01-2008 20:55:05 HTTP JVM: at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:298)29-01-2008 20:55:05 HTTP JVM: at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:283)
29-01-2008 20:55:05 HTTP JVM: at java.sql.DriverManager.getConnection(DriverManager.java:562)
29-01-2008 20:55:05 HTTP JVM: at java.sql.DriverManager.getConnection(DriverManager.java:186)
29-01-2008 20:55:05 HTTP JVM: at Jbazar.connectDB(Jbazar.java:16)
29-01-2008 20:55:05 HTTP JVM: at JavaAgent.NotesMain(JavaAgent.java:31)
29-01-2008 20:55:05 HTTP JVM: at lotus.domino.AgentBase.runNotes(Unknown Source)
29-01-2008 20:55:05 HTTP JVM: at lotus.domino.NotesThread.run(Unknown Source)
29-01-2008 20:55:05 HTTP JVM: Caused by:
29-01-2008 20:55:05 HTTP JVM: java.net.SocketException: Operation timed out: connect:could be due to invalid address
29-01-2008 20:55:05 HTTP JVM: at java.net.PlainSocketImpl.socketConnect(Native Method)
29-01-2008 20:55:05 HTTP JVM: at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:372)
29-01-2008 20:55:05 HTTP JVM: at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:233)
29-01-2008 20:55:05 HTTP JVM: at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:220)
29-01-2008 20:55:05 HTTP JVM: at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:385)
29-01-2008 20:55:05 HTTP JVM: at java.net.Socket.connect(Socket.java:541)
29-01-2008 20:55:05 HTTP JVM: at java.net.Socket.connect(Socket.java:491)
29-01-2008 20:55:05 HTTP JVM: at java.net.Socket.(Socket.java:399)
29-01-2008 20:55:05 HTTP JVM: at java.net.Socket.(Socket.java:237)
29-01-2008 20:55:05 HTTP JVM: at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
29-01-2008 20:55:05 HTTP JVM: at com.mysql.jdbc.MysqlIO.(MysqlIO.java:276)
29-01-2008 20:55:05 HTTP JVM: at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2027)
29-01-2008 20:55:05 HTTP JVM: … 9 more29-01-2008 20:54:23 Opened session for Admin Admin/NLD (Release 8.0)
Local Message:
29-01-2008 22:30:46 HTTP JVM: // Haal configuratie mysql server op
29-01-2008 22:30:46 HTTP JVM: // Document found
29-01-2008 22:30:46 HTTP JVM: sUser:test
29-01-2008 22:30:46 HTTP JVM: sPassword:test
29-01-2008 22:30:46 HTTP JVM: sURL:jdbc:mysql://111.111.1.11/
29-01-2008 22:30:46 HTTP JVM: sDatabase:jdbc:mysql://111.111.1.11/jbazar
29-01-2008 22:30:46 HTTP JVM: connect to MySQL:jdbc:mysql://111.111.1.11/jbazar
29-01-2008 22:30:46 HTTP JVM: // Login information
29-01-2008 22:30:46 HTTP JVM: sUserLoginr:sdfgsdfgesr
29-01-2008 22:30:46 HTTP JVM: sPasswordLogin:erwtertwert
29-01-2008 22:30:46 HTTP JVM: User not found in MySQL
29-01-2008 22:30:46