Hidendra/LWC — Issue #217: MYSQL problem
Author: Thalwin2
Created: 2012-01-18 17:56:37+00:00
State: open

can someone help me with this problem?

2012-01-18 15:51:08 [INFO] Starting minecraft server version 1.1
2012-01-18 15:51:08 [INFO] Loading properties
2012-01-18 15:51:08 [INFO] Starting Minecraft server on *:25566
2012-01-18 15:51:08 [WARNING] **** SERVER IS RUNNING IN OFFLINE/INSECURE MODE!
2012-01-18 15:51:08 [WARNING] The server will make no attempt to authenticate usernames. Beware.
2012-01-18 15:51:08 [WARNING] While this makes the game possible to play without internet access, it also opens up the ability for hackers to connect with any username they choose.
2012-01-18 15:51:08 [WARNING] To change this, set "online-mode" to "true" in the server.properties file.
2012-01-18 15:51:08 [INFO] This server is running Craftbukkit version git-Bukkit-1.0.1-R1-39-g60409d1-b1717jnks (MC: 1.1) (Implementing API version 1.1-R1-SNAPSHOT)
2012-01-18 15:51:08 [INFO] LWC: Loading shared objects
2012-01-18 15:51:08 [INFO] LWC: Native library: plugins/LWC/lib/native/Windows/x86/sqlitejdbc.dll
2012-01-18 15:51:08 [INFO] LWC: Protection cache: 0/10000
2012-01-18 15:51:08 [INFO] LWC: Loaded 207 locale strings (0 overrides)
2012-01-18 15:51:08 [INFO] LWC: Permissions API: SuperPermsPermissions
2012-01-18 15:51:08 [INFO] LWC: Currency API: NoCurrency
2012-01-18 15:51:08 [INFO] LWC: Connecting to MySQL
2012-01-18 15:51:12 [INFO] LWC: Failed to connect to MySQL
2012-01-18 15:51:12 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
2012-01-18 15:51:12 [SEVERE]	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2012-01-18 15:51:12 [SEVERE]	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
2012-01-18 15:51:12 [SEVERE]	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
2012-01-18 15:51:12 [SEVERE]	at java.lang.reflect.Constructor.newInstance(Unknown Source)
2012-01-18 15:51:12 [SEVERE]	at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
2012-01-18 15:51:12 [SEVERE]	at com.mysql.jdbc.Util.getInstance(Util.java:382)
2012-01-18 15:51:12 [SEVERE]	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
2012-01-18 15:51:12 [SEVERE]	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
2012-01-18 15:51:12 [SEVERE]	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
2012-01-18 15:51:12 [SEVERE]	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
2012-01-18 15:51:12 [SEVERE]	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2239)
2012-01-18 15:51:12 [SEVERE]	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2168)
2012-01-18 15:51:12 [SEVERE]	at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:794)
2012-01-18 15:51:12 [SEVERE]	at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)
2012-01-18 15:51:12 [SEVERE]	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2012-01-18 15:51:12 [SEVERE]	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
2012-01-18 15:51:12 [SEVERE]	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
2012-01-18 15:51:12 [SEVERE]	at java.lang.reflect.Constructor.newInstance(Unknown Source)
2012-01-18 15:51:12 [SEVERE]	at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
2012-01-18 15:51:12 [SEVERE]	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
2012-01-18 15:51:12 [SEVERE]	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
2012-01-18 15:51:12 [SEVERE]	at com.griefcraft.sql.Database.connect(Database.java:243)
2012-01-18 15:51:12 [SEVERE]	at com.griefcraft.lwc.LWC.load(LWC.java:1511)
2012-01-18 15:51:12 [SEVERE]	at com.griefcraft.lwc.LWCPlugin.onEnable(LWCPlugin.java:247)
2012-01-18 15:51:12 [SEVERE]	at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:230)
2012-01-18 15:51:12 [SEVERE]	at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:970)
2012-01-18 15:51:12 [SEVERE]	at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:280)
2012-01-18 15:51:12 [SEVERE]	at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:190)
2012-01-18 15:51:12 [SEVERE]	at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:173)
2012-01-18 15:51:12 [SEVERE]	at org.bukkit.craftbukkit.CraftServer.(CraftServer.java:132)
2012-01-18 15:51:12 [SEVERE]	at net.minecraft.server.ServerConfigurationManager.(ServerConfigurationManager.java:52)
2012-01-18 15:51:12 [SEVERE]	at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:147)
2012-01-18 15:51:12 [SEVERE]	at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:406)
2012-01-18 15:51:12 [SEVERE]	at net.minecraft.server.ThreadServerApplication.run(SourceFile:465)
2012-01-18 15:51:12 [SEVERE] Caused by: java.sql.SQLException: Access denied for user 'pedigree22'@'localhost' (using password: YES)
2012-01-18 15:51:12 [SEVERE]	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
2012-01-18 15:51:12 [SEVERE]	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
2012-01-18 15:51:12 [SEVERE]	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
2012-01-18 15:51:12 [SEVERE]	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931)
2012-01-18 15:51:12 [SEVERE]	at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031)
2012-01-18 15:51:12 [SEVERE]	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296)
2012-01-18 15:51:12 [SEVERE]	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)
2012-01-18 15:51:12 [SEVERE]	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2186)
2012-01-18 15:51:12 [SEVERE]	... 23 more
2012-01-18 15:51:12 [INFO] LWC: Performing any necessary database updates
2012-01-18 15:51:12 [SEVERE] java.lang.NullPointerException
2012-01-18 15:51:12 [SEVERE]	at com.griefcraft.sql.PhysDB.doUpdate302(PhysDB.java:1781)
2012-01-18 15:51:12 [SEVERE]	at com.griefcraft.sql.PhysDB.load(PhysDB.java:244)
2012-01-18 15:51:12 [SEVERE]	at com.griefcraft.lwc.LWC.load(LWC.java:1516)
2012-01-18 15:51:12 [SEVERE]	at com.griefcraft.lwc.LWCPlugin.onEnable(LWCPlugin.java:247)
2012-01-18 15:51:12 [SEVERE]	at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:230)
2012-01-18 15:51:12 [SEVERE]	at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:970)
2012-01-18 15:51:12 [SEVERE]	at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:280)
2012-01-18 15:51:12 [SEVERE]	at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:190)
2012-01-18 15:51:12 [SEVERE]	at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:173)
2012-01-18 15:51:12 [SEVERE]	at org.bukkit.craftbukkit.CraftServer.(CraftServer.java:132)
2012-01-18 15:51:12 [SEVERE]	at net.minecraft.server.ServerConfigurationManager.(ServerConfigurationManager.java:52)
2012-01-18 15:51:12 [SEVERE]	at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:147)
2012-01-18 15:51:12 [SEVERE]	at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:406)
2012-01-18 15:51:12 [SEVERE]	at net.minecraft.server.ThreadServerApplication.run(SourceFile:465)
2012-01-18 15:51:12 [INFO] ######################################################
2012-01-18 15:51:12 [INFO] ######################################################
2012-01-18 15:51:12 [INFO] SQLite to MySQL conversion required
2012-01-18 15:51:16 [INFO] LWC: Failed to connect to MySQL
2012-01-18 15:51:16 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
2012-01-18 15:51:16 [SEVERE]	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2012-01-18 15:51:16 [SEVERE]	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
2012-01-18 15:51:16 [SEVERE]	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
2012-01-18 15:51:16 [SEVERE]	at java.lang.reflect.Constructor.newInstance(Unknown Source)
2012-01-18 15:51:16 [SEVERE]	at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
2012-01-18 15:51:16 [SEVERE]	at com.mysql.jdbc.Util.getInstance(Util.java:382)
2012-01-18 15:51:16 [SEVERE]	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
2012-01-18 15:51:16 [SEVERE]	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
2012-01-18 15:51:16 [SEVERE]	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
2012-01-18 15:51:16 [SEVERE]	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
2012-01-18 15:51:16 [SEVERE]	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2239)
2012-01-18 15:51:16 [SEVERE]	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2168)
2012-01-18 15:51:16 [SEVERE]	at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:794)
2012-01-18 15:51:16 [SEVERE]	at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)
2012-01-18 15:51:16 [SEVERE]	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2012-01-18 15:51:16 [SEVERE]	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
2012-01-18 15:51:16 [SEVERE]	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
2012-01-18 15:51:16 [SEVERE]	at java.lang.reflect.Constructor.newInstance(Unknown Source)
2012-01-18 15:51:16 [SEVERE]	at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
2012-01-18 15:51:16 [SEVERE]	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
2012-01-18 15:51:16 [SEVERE]	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
2012-01-18 15:51:16 [SEVERE]	at com.griefcraft.sql.Database.connect(Database.java:243)
2012-01-18 15:51:16 [SEVERE]	at com.griefcraft.lwc.LWC.reloadDatabase(LWC.java:1799)
2012-01-18 15:51:16 [SEVERE]	at com.griefcraft.migration.MySQLPost200.run(MySQLPost200.java:75)
2012-01-18 15:51:16 [SEVERE]	at com.griefcraft.lwc.LWC.load(LWC.java:1524)
2012-01-18 15:51:16 [SEVERE]	at com.griefcraft.lwc.LWCPlugin.onEnable(LWCPlugin.java:247)
2012-01-18 15:51:16 [SEVERE]	at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:230)
2012-01-18 15:51:16 [SEVERE]	at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:970)
2012-01-18 15:51:16 [SEVERE]	at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:280)
2012-01-18 15:51:16 [SEVERE]	at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:190)
2012-01-18 15:51:16 [SEVERE]	at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:173)
2012-01-18 15:51:16 [SEVERE]	at org.bukkit.craftbukkit.CraftServer.(CraftServer.java:132)
2012-01-18 15:51:16 [SEVERE]	at net.minecraft.server.ServerConfigurationManager.(ServerConfigurationManager.java:52)
2012-01-18 15:51:16 [SEVERE]	at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:147)
2012-01-18 15:51:16 [SEVERE]	at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:406)
2012-01-18 15:51:16 [SEVERE]	at net.minecraft.server.ThreadServerApplication.run(SourceFile:465)
2012-01-18 15:51:16 [SEVERE] Caused by: java.sql.SQLException: Access denied for user 'pedigree22'@'localhost' (using password: YES)
2012-01-18 15:51:16 [SEVERE]	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
2012-01-18 15:51:16 [SEVERE]	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
2012-01-18 15:51:16 [SEVERE]	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
2012-01-18 15:51:16 [SEVERE]	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931)
2012-01-18 15:51:16 [SEVERE]	at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031)
2012-01-18 15:51:16 [SEVERE]	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296)
2012-01-18 15:51:16 [SEVERE]	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)
2012-01-18 15:51:16 [SEVERE]	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2186)
2012-01-18 15:51:16 [SEVERE]	... 25 more
2012-01-18 15:51:16 [SEVERE] java.lang.NullPointerException
2012-01-18 15:51:16 [SEVERE]	at com.griefcraft.sql.PhysDB.doUpdate302(PhysDB.java:1781)
2012-01-18 15:51:16 [SEVERE]	at com.griefcraft.sql.PhysDB.load(PhysDB.java:244)
2012-01-18 15:51:16 [SEVERE]	at com.griefcraft.lwc.LWC.reloadDatabase(LWC.java:1800)
2012-01-18 15:51:16 [SEVERE]	at com.griefcraft.migration.MySQLPost200.run(MySQLPost200.java:75)
2012-01-18 15:51:16 [SEVERE]	at com.griefcraft.lwc.LWC.load(LWC.java:1524)
2012-01-18 15:51:16 [SEVERE]	at com.griefcraft.lwc.LWCPlugin.onEnable(LWCPlugin.java:247)
2012-01-18 15:51:16 [SEVERE]	at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:230)
2012-01-18 15:51:16 [SEVERE]	at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:970)
2012-01-18 15:51:16 [SEVERE]	at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:280)
2012-01-18 15:51:16 [SEVERE]	at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:190)
2012-01-18 15:51:16 [SEVERE]	at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:173)
2012-01-18 15:51:16 [SEVERE]	at org.bukkit.craftbukkit.CraftServer.(CraftServer.java:132)
2012-01-18 15:51:16 [SEVERE]	at net.minecraft.server.ServerConfigurationManager.(ServerConfigurationManager.java:52)
2012-01-18 15:51:16 [SEVERE]	at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:147)
2012-01-18 15:51:16 [SEVERE]	at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:406)
2012-01-18 15:51:16 [SEVERE]	at net.minecraft.server.ThreadServerApplication.run(SourceFile:465)
2012-01-18 15:51:17 [SEVERE] java.lang.NullPointerException
2012-01-18 15:51:17 [SEVERE]	at com.griefcraft.migration.DatabaseMigrator.migrate(DatabaseMigrator.java:50)
2012-01-18 15:51:17 [SEVERE]	at com.griefcraft.migration.MySQLPost200.run(MySQLPost200.java:87)
2012-01-18 15:51:17 [SEVERE]	at com.griefcraft.lwc.LWC.load(LWC.java:1524)
2012-01-18 15:51:17 [SEVERE]	at com.griefcraft.lwc.LWCPlugin.onEnable(LWCPlugin.java:247)
2012-01-18 15:51:17 [SEVERE]	at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:230)
2012-01-18 15:51:17 [SEVERE]	at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:970)
2012-01-18 15:51:17 [SEVERE]	at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:280)
2012-01-18 15:51:17 [SEVERE]	at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:190)
2012-01-18 15:51:17 [SEVERE]	at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:173)
2012-01-18 15:51:17 [SEVERE]	at org.bukkit.craftbukkit.CraftServer.(CraftServer.java:132)
2012-01-18 15:51:17 [SEVERE]	at net.minecraft.server.ServerConfigurationManager.(ServerConfigurationManager.java:52)
2012-01-18 15:51:17 [SEVERE]	at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:147)
2012-01-18 15:51:17 [SEVERE]	at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:406)
2012-01-18 15:51:17 [SEVERE]	at net.minecraft.server.ThreadServerApplication.run(SourceFile:465)
2012-01-18 15:51:17 [INFO] #### SEVERE ERROR: Something bad happened when converting the database (Oops!)
2012-01-18 15:51:17 [INFO] ######################################################
2012-01-18 15:51:17 [INFO] ######################################################
2012-01-18 15:51:17 [SEVERE] Error occurred while enabling LWC v4.0.5 (b607-git-e22604a9) (Is it up to date?): null
java.lang.NullPointerException
at com.griefcraft.sql.PhysDB.precache(PhysDB.java:830)
at com.griefcraft.lwc.LWC.load(LWC.java:1527)
at com.griefcraft.lwc.LWCPlugin.onEnable(LWCPlugin.java:247)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:230)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:970)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:280)
at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:190)
at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:173)
at org.bukkit.craftbukkit.CraftServer.(CraftServer.java:132)
at net.minecraft.server.ServerConfigurationManager.(ServerConfigurationManager.java:52)
at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:147)
at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:406)
at net.minecraft.server.ThreadServerApplication.run(SourceFile:465)
2012-01-18 15:51:17 [INFO] Preparing level "world"
2012-01-18 15:51:17 [INFO] Default game type: 0
2012-01-18 15:51:17 [INFO] Preparing start region for level 0 (Seed: -8693542314000989473)
2012-01-18 15:51:17 [INFO] Preparing start region for level 1 (Seed: -2409768736228309779)
2012-01-18 15:51:18 [INFO] Preparing start region for level 2 (Seed: -2409768736228309779)
2012-01-18 15:51:18 [INFO] Preparing spawn area: 4%
2012-01-18 15:51:18 [INFO] Server permissions file permissions.yml is empty, ignoring it
2012-01-18 15:51:18 [INFO] Done (1,653s)! For help, type "help" or "?"
2012-01-18 15:51:27 [INFO] CONSOLE: Stopping the server..
2012-01-18 15:51:27 [INFO] Stopping server
2012-01-18 15:51:27 [INFO] LWC: Flushing protection updates (0)
2012-01-18 15:51:27 [INFO] LWC: Freeing MySQL
2012-01-18 15:51:27 [INFO] Saving chunks