Dobrý den,
mám problém s napojením xauth do mysql databáze.
z xauth configu:
Kód: Vybrat vše
main:
# How should xAuth store data (Accounts, sessions, etc.)?
# Possible values: h2, mysql
datasource: mysql
# If set to true, xAuth will disable itself if the server is in online-mode
auto-disable: true
# If set to true, all required library files will be automatically downloaded
download-libraries: true
# When set to true, if a player connects with the same name as someone who is
# already online, the player connecting will be kicked instead of the online player
reverse-enforce-single-session: true
mysql:
# Location of the MySQL server. Can be either a host name or IP address
host: localhost
# Port used by MySQL. Default is 3306
port: 3306
# User name used to connect to the MySQL server
username: gs_27571_1
# Password used to connect to the MySQL server
password: mojesupertajneheslonakterenikdoneprijde
# Name of the database that will be used by xAuth
database: gs_27571_1
# Names of the tables xAuth will use to store data
tables:
account: accounts
session: sessions
strike: strikes
location: tele_locations
inventory: inventory
výpis z logu:
Kód: Vybrat vše
2011-10-19 20:07:49 [INFO] [xAuth] 'Permissions' v2.7.2 support enabled!
2011-10-19 20:07:49 [INFO] [xAuth] Connection to database established!
2011-10-19 20:07:49 [SEVERE] [xAuth] SQL query failure [write] (DELETE FROM `sessions` WHERE NOW() > ADDDATE(`logintime`, INTERVAL 3600 SECOND))
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'gs_27571_1.sessions' doesn't exist
at sun.reflect.GeneratedConstructorAccessor68.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.Util.getInstance(Util.java:382)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)
at com.cypherx.xauth.database.Database.queryWrite(Database.java:90)
at com.cypherx.xauth.database.DbUtil.deleteExpiredSessions(DbUtil.java:335)
at com.cypherx.xauth.xAuth.onEnable(xAuth.java:107)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:170)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:957)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:280)
at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:171)
at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:154)
at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:413)
at org.bukkit.Bukkit.reload(Bukkit.java:182)
at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:22)
at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:163)
at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:355)
at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:757)
at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:722)
at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:715)
at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:92)
at net.minecraft.server.NetworkListenThread.a(SourceFile:108)
at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:471)
at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:374)
at net.minecraft.server.ThreadServerApplication.run(SourceFile:417)
2011-10-19 20:07:49 [SEVERE] [xAuth] SQL query failure [read] (SELECT * FROM `tele_locations`)
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'gs_27571_1.tele_locations' doesn't exist
at sun.reflect.GeneratedConstructorAccessor68.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.Util.getInstance(Util.java:382)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2273)
at com.cypherx.xauth.database.Database.queryRead(Database.java:69)
at com.cypherx.xauth.xAuth.loadTeleLocations(xAuth.java:467)
at com.cypherx.xauth.xAuth.onEnable(xAuth.java:108)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:170)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:957)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:280)
at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:171)
at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:154)
at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:413)
at org.bukkit.Bukkit.reload(Bukkit.java:182)
at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:22)
at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:163)
at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:355)
at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:757)
at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:722)
at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:715)
at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:92)
at net.minecraft.server.NetworkListenThread.a(SourceFile:108)
at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:471)
at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:374)
at net.minecraft.server.ThreadServerApplication.run(SourceFile:417)
2011-10-19 20:07:49 [SEVERE] Error occurred while enabling xAuth v2.0b4.3 (Is it up to date?): null
java.lang.NullPointerException
at com.cypherx.xauth.xAuth.loadTeleLocations(xAuth.java:503)
at com.cypherx.xauth.xAuth.onEnable(xAuth.java:108)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:170)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:957)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:280)
at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:171)
at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:154)
at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:413)
at org.bukkit.Bukkit.reload(Bukkit.java:182)
at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:22)
at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:163)
at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:355)
at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:757)
at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:722)
at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:715)
at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:92)
at net.minecraft.server.NetworkListenThread.a(SourceFile:108)
at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:471)
at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:374)
at net.minecraft.server.ThreadServerApplication.run(SourceFile:417)
