Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    2

    Unanswered: Remote Connect problem

    Hi All,

    I'm new Java and Mysql Programmer and have a big problem to remote connect Mysql Server by following Setting:

    1. Server Computer : Linux 9.0 with LAN IP : 10.2.112.100 / 255.255.255.0
    2. Router Setting LAN IP MAP with True IP : 218.111.231.22 /255.255.255.240
    3. Server Installed : MySQL, Java SDK 1.4 and JRE 1.4 with Java-web Start JNLP

    Problem :
    1. We can access MySQL internal with Client in LAN IP
    2. Once i came home and remote connect by True IP the following message occur.

    My Connect Message -----------------------------------------------
    Connection c = DriverManager.getConnection(
    "jdbc:mysql://218.111.231.22:3306/IOP?user=mysql&password=admin");
    ---------------------------------------------------------------------

    Error Message -----------------------------------------------------
    SQLException Status : SQLException: Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused: connect

    ** BEGIN NESTED EXCEPTION **

    java.net.ConnectException
    MESSAGE: Connection refused: connect

    STACKTRACE:
    java.net.ConnectException: Connection refused: connect
    at java.net.PlainSocketImpl.socketConnect(Native Method)
    at java.net.PlainSocketImpl.doConnect(Unknown Source)
    at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
    at java.net.PlainSocketImpl.connect(Unknown Source)
    at java.net.Socket.connect(Unknown Source)
    at java.net.Socket.connect(Unknown Source)
    at java.net.Socket.<init>(Unknown Source)
    at java.net.Socket.<init>(Unknown Source)
    at com.mysql.jdbc.StandardSocketFactory.connect(Stand ardSocketFactory.java:121)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:219)
    at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:1771)
    at com.mysql.jdbc.Connection.<init>(Connection.java:4 40)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java:400)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    ...........
    ** END NESTED EXCEPTION **
    SQLStatus : SQLState: 08S01
    Vendor Status : VendorError: 0
    ----------------------------------------------------------------------------
    Thanks
    Sanki Poon

  2. #2
    Join Date
    Apr 2004
    Posts
    110
    Are you sure the router is not blocking the connection from the WAN to the LAN?

    George Papadopoulos

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •