Plugin won't connect to Database #353


  • New
  • Other
Open
Assigned to _ForgeUser7781625
  • _ForgeUser10715648 created this issue Mar 26, 2015

    What steps will reproduce the problem?
    1. Enter in the mysql details
    2. Restart the Server
    3. Get error in console

    What is the expected output? What do you see instead?

    To connect to the database.
    No connection.

    What version of the product are you using?

    1.2.3

    Do you have an error log of what happened? (Portal: check cache/error.txt)

    26.03 13:36:19 [Server] ERROR Is the plugin set up correctly?
    26.03 13:36:19 [Server] ERROR Cannot establish a database connection!
    26.03 13:36:19 [Server] INFO +----------------------------------+
    26.03 13:36:19 [Server] INFO |  All patch files are up to date  |
    26.03 13:36:19 [Server] INFO +------ [ Fetching Patches ] ------+
    26.03 13:36:19 [Server] INFO Enabling Statistics v1.2.3

    From my servers console.

    Please provide any additional information below. (Plugin/Portal Version, Server Version, PHP Version. MySQL Version)

    Server Version - 1.8

    Here is the config of the plugin:

    debug: false
    log-prefix: Stats
    database:
    host: *******
    port: 3306
    name: 'Statistics'
    prefix: stats_
    user: Statistics
    pass: *******
    reconnect_interval: 5

    Here is a picture of my MYSQL Database.

    http://gyazo.com/7fc5b5f89887ffb047006a5c91312c43.png

    All the info entered above (Usernames, Passwords ect is correct.)

    PhP Version - 5.4.37
    MySQL Version - 5.5.41-cll-lve
    Plugin Version - 1.2.3

  • _ForgeUser10715648 added the tags New Other Mar 26, 2015
  • _ForgeUser10715648 posted a comment Mar 26, 2015

    What steps will reproduce the problem? 1. Enter in the mysql details 2. Restart the Server 3. Get error in console


    Edited Mar 26, 2015
  • _ForgeUser10715648 edited description Mar 26, 2015
  • _ForgeUser7781625 edited description Mar 27, 2015
  • _ForgeUser7781625 removed their assignment Mar 27, 2015
  • _ForgeUser7781625 assigned issue to _ForgeUser74709 Mar 27, 2015
  • _ForgeUser7781625 unassigned issue from _ForgeUser74709 Mar 27, 2015
  • _ForgeUser7781625 self-assigned this issue Mar 27, 2015
  • _ForgeUser7781625 posted a comment Mar 27, 2015

    Please set debug: to true in the config and post the server log here.

  • _ForgeUser10715648 posted a comment Mar 27, 2015

    Here you go

    27.03 02:39:47 [Server] WARN ... 12 more 27.03 02:39:47 [Server] WARN at com.wolvencraft.yasp.db.Database.<init>(Database.java:74) 27.03 02:39:47 [Server] WARN at java.sql.DriverManager.getConnection(Unknown Source) 27.03 02:39:47 [Server] WARN at java.sql.DriverManager.getConnection(Unknown Source) 27.03 02:39:47 [Server] WARN at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) 27.03 02:39:47 [Server] WARN at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378) 27.03 02:39:47 [Server] WARN at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) 27.03 02:39:47 [Server] WARN at java.lang.reflect.Constructor.newInstance(Unknown Source) 27.03 02:39:47 [Server] WARN at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) 27.03 02:39:47 [Server] WARN at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) 27.03 02:39:47 [Server] WARN at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 27.03 02:39:47 [Server] WARN at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) 27.03 02:39:47 [Server] WARN at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) 27.03 02:39:47 [Server] WARN at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163) 27.03 02:39:47 [Server] WARN at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371) 27.03 02:39:47 [Server] WARN at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338) 27.03 02:39:47 [Server] WARN at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296) 27.03 02:39:47 [Server] WARN at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031) 27.03 02:39:47 [Server] WARN at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931) 27.03 02:39:47 [Server] WARN at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525) 27.03 02:39:47 [Server] WARN at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593) 27.03 02:39:47 [Server] WARN at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) 27.03 02:39:47 [Server] WARN Caused by: java.sql.SQLException: Access denied for user 'Statistics'@'159.8.141.201' (using password: YES) 27.03 02:39:47 [Server] WARN at java.lang.Thread.run(Unknown Source) 27.03 02:39:47 [Server] WARN at net.minecraft.server.v1_8_R1.MinecraftServer.run(MinecraftServer.java:505) 27.03 02:39:47 [Server] WARN at net.minecraft.server.v1_8_R1.DedicatedServer.init(DedicatedServer.java:211) 27.03 02:39:47 [Server] WARN at net.minecraft.server.v1_8_R1.MinecraftServer.a(MinecraftServer.java:325) 27.03 02:39:47 [Server] WARN at net.minecraft.server.v1_8_R1.MinecraftServer.k(MinecraftServer.java:370) 27.03 02:39:47 [Server] WARN at net.minecraft.server.v1_8_R1.MinecraftServer.q(MinecraftServer.java:402) 27.03 02:39:47 [Server] WARN at org.bukkit.craftbukkit.v1_8_R1.CraftServer.enablePlugins(CraftServer.java:316) 27.03 02:39:47 [Server] WARN at org.bukkit.craftbukkit.v1_8_R1.CraftServer.loadPlugin(CraftServer.java:356) 27.03 02:39:47 [Server] WARN at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405) 27.03 02:39:47 [Server] WARN at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:335) 27.03 02:39:47 [Server] WARN at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321) 27.03 02:39:47 [Server] WARN at com.wolvencraft.yasp.Statistics.onEnable(Statistics.java:121) 27.03 02:39:47 [Server] WARN at com.wolvencraft.yasp.db.Database.<init>(Database.java:79) 27.03 02:39:47 [Server] WARN java.sql.SQLException: Access denied for user 'Statistics'@'159.8.141.201' (using password: YES) 27.03 02:39:47 [Server] ERROR Is the plugin set up correctly? 27.03 02:39:47 [Server] ERROR Cannot establish a database connection! 27.03 02:39:46 [Server] INFO +------+ 27.03 02:39:46 [Server] INFO | All patch files are up to date | 27.03 02:39:46 [Server] INFO + [ Fetching Patches ] + 27.03 02:39:46 [Server] INFO Enabling Statistics v1.2.3

  • _ForgeUser7781625 posted a comment Mar 27, 2015

    Access denied for user 'Statistics'@'159.8.141.201' (using password: YES)

    I think that the minecraft server don't has access to the MySQL server (host blocked) or your password is wrong.


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