Thread: PHP and MYSql highscores problem

Results 1 to 3 of 3
  1. #1 PHP and MYSql highscores problem 
    ̿ ̿̿ ̿̿ ̿̿̿'̿'\̵͇̿̿\=(•̪

    Dragonking's Avatar
    Join Date
    May 2008
    Posts
    2,011
    Thanks given
    16
    Thanks received
    31
    Rep Power
    567
    well im trying to put my highscores on a new host but i cannot get my server to connect to the host mysql can someone help me? the host is 000webhosting.com

    here is the error

    Dragonscape is now online
    _________________________

    [Dragonking]: Logged in. from ip *******************************
    [Dragonking]: ActionButton: 9154
    [Dragonking]: Already online.
    com.mysql.jdbc.CommunicationsException: Communications link failure due to under
    lying exception:

    ** BEGIN NESTED EXCEPTION **

    java.net.ConnectException
    MESSAGE: Connection timed out: connect

    STACKTRACE:

    java.net.ConnectException: Connection timed out: 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.SocksSocketImpl.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.ja
    va:173)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:267)
    at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:2739)
    at com.mysql.jdbc.Connection.<init>(Connection.java:1 553)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java
    :266)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at SQL.createConnection(SQL.java:14)
    at Client.logout(Client.java:6262)
    at Button.doAction(Button.java:840)
    at Client.parseIncomingPackets(Client.java:3179)
    at Client.packetProcess(Client.java:1096)
    at Client.packetSending(Client.java:1064)
    at PlayerManager.process(PlayerManager.java:133)
    at Server.main(Server.java:39)


    ** END NESTED EXCEPTION **



    Last packet sent to the server was 16 ms ago.
    at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:2814)
    at com.mysql.jdbc.Connection.<init>(Connection.java:1 553)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java
    :266)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at SQL.createConnection(SQL.java:14)
    at Client.logout(Client.java:6262)
    at Button.doAction(Button.java:840)
    at Client.parseIncomingPackets(Client.java:3179)
    at Client.packetProcess(Client.java:1096)
    at Client.packetSending(Client.java:1064)
    at PlayerManager.process(PlayerManager.java:133)
    at Server.main(Server.java:39)
    java.lang.NullPointerException
    at SQL.destroyConnection(SQL.java:39)
    at SQL.query(SQL.java:30)
    at SQL.saveHighScore(SQL.java:73)
    at Client.logout(Client.java:6263)
    at Button.doAction(Button.java:840)
    at Client.parseIncomingPackets(Client.java:3179)
    at Client.packetProcess(Client.java:1096)
    at Client.packetSending(Client.java:1064)
    at PlayerManager.process(PlayerManager.java:133)
    at Server.main(Server.java:39)


    [Only registered and activated users can see links. ]
    Reply With Quote  
     

  2. #2  
    Jeremy Yak
    Guest
    Well post your connection error here and I might be able to help. Most free hosts don't allow remote MySQL connections, that's my guess already.
    Reply With Quote  
     

  3. #3  
    ̿ ̿̿ ̿̿ ̿̿̿'̿'\̵͇̿̿\=(•̪

    Dragonking's Avatar
    Join Date
    May 2008
    Posts
    2,011
    Thanks given
    16
    Thanks received
    31
    Rep Power
    567
    here is the error

    Dragonscape is now online
    _________________________

    [Dragonking]: Logged in. from ip *******************************
    [Dragonking]: ActionButton: 9154
    [Dragonking]: Already online.
    com.mysql.jdbc.CommunicationsException: Communications link failure due to under
    lying exception:

    ** BEGIN NESTED EXCEPTION **

    java.net.ConnectException
    MESSAGE: Connection timed out: connect

    STACKTRACE:

    java.net.ConnectException: Connection timed out: 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.SocksSocketImpl.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.ja
    va:173)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:267)
    at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:2739)
    at com.mysql.jdbc.Connection.<init>(Connection.java:1 553)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java
    :266)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at SQL.createConnection(SQL.java:14)
    at Client.logout(Client.java:6262)
    at Button.doAction(Button.java:840)
    at Client.parseIncomingPackets(Client.java:3179)
    at Client.packetProcess(Client.java:1096)
    at Client.packetSending(Client.java:1064)
    at PlayerManager.process(PlayerManager.java:133)
    at Server.main(Server.java:39)


    ** END NESTED EXCEPTION **



    Last packet sent to the server was 16 ms ago.
    at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:2814)
    at com.mysql.jdbc.Connection.<init>(Connection.java:1 553)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java
    :266)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at SQL.createConnection(SQL.java:14)
    at Client.logout(Client.java:6262)
    at Button.doAction(Button.java:840)
    at Client.parseIncomingPackets(Client.java:3179)
    at Client.packetProcess(Client.java:1096)
    at Client.packetSending(Client.java:1064)
    at PlayerManager.process(PlayerManager.java:133)
    at Server.main(Server.java:39)
    java.lang.NullPointerException
    at SQL.destroyConnection(SQL.java:39)
    at SQL.query(SQL.java:30)
    at SQL.saveHighScore(SQL.java:73)
    at Client.logout(Client.java:6263)
    at Button.doAction(Button.java:840)
    at Client.parseIncomingPackets(Client.java:3179)
    at Client.packetProcess(Client.java:1096)
    at Client.packetSending(Client.java:1064)
    at PlayerManager.process(PlayerManager.java:133)
    at Server.main(Server.java:39)


    [Only registered and activated users can see links. ]
    Reply With Quote  
     


Thread Information
Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


User Tag List

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