I have a minecraft server that is running
Recommended Build #617 of CraftBukkit. We have a ton of plugins installed already, but there are a few more that I need to add to wrap everything up. These three (
iConomy,
BigBrother, and
NetStats) all require a database, with two of the three requiring MySQL. Well, I have MySQL set up on the server and running just fine, as I've gotten phpBB running without difficulty, however, each and everytime I start the server, I get the following bit in my error log.
Code:
2011-04-09 05:01:29 [INFO] [iConomy] Could not create connection: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
Last packet sent to the server was 0 ms ago.
2011-04-09 05:01:29 [INFO] [iConomy] Could not load transaction logger:
2011-04-09 05:01:29 [SEVERE] java.lang.NullPointerException
2011-04-09 05:01:29 [SEVERE] at com.nijiko.coelho.iConomy.system.Transactions.load(Transactions.java:31)
2011-04-09 05:01:29 [SEVERE] at com.nijiko.coelho.iConomy.iConomy.onEnable(iConomy.java:138)
2011-04-09 05:01:29 [SEVERE] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:118)
2011-04-09 05:01:29 [SEVERE] at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:514)
2011-04-09 05:01:29 [SEVERE] at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:216)
2011-04-09 05:01:29 [SEVERE] at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:94)
2011-04-09 05:01:29 [SEVERE] at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:72)
2011-04-09 05:01:30 [SEVERE] at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:215)
2011-04-09 05:01:30 [SEVERE] at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:202)
2011-04-09 05:01:30 [SEVERE] at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:142)
2011-04-09 05:01:30 [SEVERE] at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:257)
2011-04-09 05:01:30 [SEVERE] at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
2011-04-09 05:01:30 [INFO] [iConomy] Could not create connection: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
Last packet sent to the server was 0 ms ago.
2011-04-09 05:01:30 [INFO] [iConomy] Failed to load database: java.lang.NullPointerException
2011-04-09 05:01:30 [INFO] [iConomy] Plugin disabled.
All three use a java-mysql connector, and I've ensured that it's been downloaded and placed in the correct folder. I've also created a "minecraft" mysql user and made a "minecraft" database. I got the following YAML from phpMyAdmin.
Code:
%YAML 1.1
---
# mysql.user
-
Host: "localhost"
User: "minecraft"
Password: "BLANKED FOR SECURITY"
Select_priv: "N"
Insert_priv: "N"
Update_priv: "N"
Delete_priv: "N"
Create_priv: "N"
Drop_priv: "N"
Reload_priv: "N"
Shutdown_priv: "N"
Process_priv: "N"
File_priv: "N"
Grant_priv: "N"
References_priv: "N"
Index_priv: "N"
Alter_priv: "N"
Show_db_priv: "N"
Super_priv: "N"
Create_tmp_table_priv: "N"
Lock_tables_priv: "N"
Execute_priv: "N"
Repl_slave_priv: "N"
Repl_client_priv: "N"
Create_view_priv: "N"
Show_view_priv: "N"
Create_routine_priv: "N"
Alter_routine_priv: "N"
Create_user_priv: "N"
Event_priv: "N"
Trigger_priv: "N"
ssl_type: ""
ssl_cipher: ""
x509_issuer: ""
x509_subject: ""
max_questions: 0
max_updates: 0
max_connections: 0
max_user_connections: 0
I can plainly see that my three newly created users don't have privs, even though I did a
Code:
GRANT ALL PRIVILEGES ON minecraft.* TO "minecraft"@"localhost";
So what did I do wrong? This is the only thing I can think of.
Login
Register
FAQ
Search
