Thread: PI Voting problem

Results 1 to 6 of 6
  1. #1 PI Voting problem 
    Registered Member Life's Avatar
    Join Date
    Mar 2012
    Posts
    213
    Thanks given
    24
    Thanks received
    10
    Rep Power
    11
    When I run my server I get the following message, I followed http://www.rune-server.org/runescape...ote4items.html

    Code:
    com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link fai
    lure
    
    The last packet successfully received from the server was 1,381,789,295,912 mill
    iseconds ago.  The last packet sent successfully to the server was 0 millisecond
    s ago.
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
    orAccessorImpl.java:57)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
    onstructorAccessorImpl.java:45)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
            at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1
    074)
            at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2214)
            at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:773)
            at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
    orAccessorImpl.java:57)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
    onstructorAccessorImpl.java:45)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
            at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)
            at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
    :282)
            at java.sql.DriverManager.getConnection(DriverManager.java:579)
            at java.sql.DriverManager.getConnection(DriverManager.java:221)
            at org.runetoplist.VoteChecker.createConnection(VoteChecker.java:27)
            at org.runetoplist.VoteChecker.<init>(VoteChecker.java:18)
            at server.Server.<clinit>(Server.java:85)
    Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communicatio
    ns link failure
    
    The last packet successfully received from the server was 1,381,789,295,912 mill
    iseconds ago.  The last packet sent successfully to the server was 0 millisecond
    s ago.
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
    orAccessorImpl.java:57)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
    onstructorAccessorImpl.java:45)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
            at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1
    074)
            at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341)
            at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2137)
            ... 14 more
    Caused by: java.net.ConnectException: Connection refused: connect
            at java.net.DualStackPlainSocketImpl.connect0(Native Method)
            at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketI
    mpl.java:69)
            at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.ja
    va:339)
            at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocket
    Impl.java:200)
            at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java
    :182)
            at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:157)
            at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:391)
            at java.net.Socket.connect(Socket.java:579)
            at java.net.Socket.connect(Socket.java:528)
            at java.net.Socket.<init>(Socket.java:425)
            at java.net.Socket.<init>(Socket.java:241)
            at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.ja
    va:253)
            at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:290)
            ... 15 more
    Failed to connect to the database, please check the DB details.
    Reply With Quote  
     

  2. #2  
    Registered Member RS From The 00s's Avatar
    Join Date
    Oct 2013
    Age
    34
    Posts
    169
    Thanks given
    63
    Thanks received
    26
    Rep Power
    1
    Are you using remote mysql? My guess is it can't connect to the database because your webhost's firewall is blocking your IP. You need to request to be white listed.
    Reply With Quote  
     

  3. #3  
    Registered Member
    Join Date
    Mar 2009
    Posts
    203
    Thanks given
    14
    Thanks received
    33
    Rep Power
    18
    Simple, in Server.java look for:

    voteChecker = new VoteChecker("DATABASE ADDRESS", "DATABASE NAME", "DATASE UESRNAME", "DATABASE PASSWORD");"

    make sure that Database Address, Database Name, Database Username, and Database Password all correspond to YOUR own database.

    You either have all 4 wrong or made a simple error on one of the four.
    Reply With Quote  
     

  4. #4  
    Registered Member RS From The 00s's Avatar
    Join Date
    Oct 2013
    Age
    34
    Posts
    169
    Thanks given
    63
    Thanks received
    26
    Rep Power
    1
    Ah yes, it would be connection refused if it was something to do with a blocked connection.
    Reply With Quote  
     

  5. Thankful user:


  6. #5  
    Registered Member Life's Avatar
    Join Date
    Mar 2012
    Posts
    213
    Thanks given
    24
    Thanks received
    10
    Rep Power
    11
    So does that mean there isnt a way to fix it?
    EDIT: Thanks figured out that it was blocked, Thanks
    Reply With Quote  
     

  7. #6  
    Registered Member
    Join Date
    Sep 2012
    Posts
    287
    Thanks given
    9
    Thanks received
    6
    Rep Power
    31
    Pm me on skype

    Killlove92
    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

Similar Threads

  1. 317 PI Runetoplist voting problem
    By I cup in forum Help
    Replies: 27
    Last Post: 09-20-2013, 03:27 AM
  2. 317 PI More voting problems
    By I cup in forum Help
    Replies: 1
    Last Post: 09-05-2013, 05:43 AM
  3. [PI] ::vote command problem
    By arcane-scape in forum Help
    Replies: 12
    Last Post: 07-16-2013, 09:44 PM
  4. PI Vote shop problem
    By ikbenpure5 in forum Help
    Replies: 2
    Last Post: 08-17-2012, 05:41 AM
  5. [PI] Vote Problem Probably Simple Fix [PI]
    By I Am Kacey in forum Help
    Replies: 5
    Last Post: 05-21-2011, 03:09 PM
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •