For some reason, the database connection up and quit #306


  • New
  • Defect
Open
Assigned to _ForgeUser7076494
  • RalphORama created this issue May 9, 2012

    What is the problem?
    While trying to use HawkEye to check a greifed area, I started getting the error "com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure" out of the blue.

    What steps will reproduce the problem?
    I'm not sure how to reproduce this error, as nothing changed in the database or the config at the time the problem started happening.

    What version of HawkEye are you using (shown in console during start-up)?
    1.0.7

    Show me any console errors and/or your start-up console message for HawkEye
    [SEVERE] [HawkEye] Error whilst attempting to get connection: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

    The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    [SEVERE] [HawkEye] Error initiating HawkEye database connection, disabling plugin
    [INFO] [HawkEye] Disabling HawkEye v1.0.7
    [INFO] [HawkEye] Version 1.0.7 disabled!

    Show me your config.yml and/or your config.php (REMOVE YOUR PASSWORD)
    log:
      lava-bucket: true
      water-bucket: true
      painting-place: true
      pvp-death: true
      mob-death: true
      other-death: true
      command: true
      chat: true
      join: true
      quit: true
      door-interact: true
      open-container: true
      container-transaction: true
      item-pickup: true
      item-drop: true
      button: true
      teleport: true
      lever: true
      sign-place: true
      sign-break: true
      painting-break: true
      flint-steel: true
      block-place: true
      block-break: true
      block-burn: true
      block-fade: true
      block-form: true
      leaf-decay: true
      mushroom-grow: true
      tree-grow: true
      water-flow: false
      lava-flow: false
      explosion: true
      enderman-pickup: true
      enderman-place: true
      entity-kill: true
      other: true
    general:
      max-lines: 0
      log-item-drops-on-death: false
      cleanse-period: 60m
      cleanse-age: 1w
      delete-data-on-rollback: true
      log-ip-addresses: true
      debug: false
      max-radius: 0
      give-user-tool: true
      tool-block: '17'
      default-here-radius: 5
      default-tool-command: ''
      check-for-updates: true
      op-permissions: false
    mysql:
      hawkeye-table: hawkeye
      port: 1030
      player-table: hawk_players
      username: **********
      world-table: hawk_worlds
      hostname: ***.***.***.***
      max-connections: 10
      password: **************
      database: mksminecraft
    ignore-worlds:
    - thisworldisignored
    - soisthisone
    version: 1.0.7
    command-filter:
    - /login
    - /restartsrv
    - /register
    block-filter:
    - 140
    - 150

    Have you checked the FAQ page?
    Yes, nothing there about my situation (hosting data on external SQL server, host allows outgoing MySQL connections)

    Notes:
    I have checked all the data for both the MySQL database and in the config, and nothing appeared to be wrong. The database had 100mb (1/3) of free space in it, the information matched up, the only thing I've changed (and this was after the problem started happening) was the port.

  • RalphORama added the tags New Defect May 9, 2012

To post a comment, please login or register a new account.