[PROBLEM]SerWer Minecraft i MySQL

[TheDrHell]

Witam.

Instalowałem bazę MySQL do serwera Minecrafta ,wszystko powiodło się pomyślnie (robiłem z tutorialem).

Ale niestety jedyny plugin jaki mam na serwerze tzn.xauth (wersja 1.3.2) wywala błędy a dane w configu uzupełniłem poprawnie.

Tutaj wykaz logów serwera:

2012-08-26 14:48:06 [iNFO] Starting minecraft server version 1.3.1
2012-08-26 14:48:06 [WARNING] To start the server with more ram, launch it as "java -Xmx1024M -Xms1024M -jar minecraft_server.jar"
2012-08-26 14:48:06 [iNFO] Loading properties
2012-08-26 14:48:06 [iNFO] Default game type: SURVIVAL
2012-08-26 14:48:06 [iNFO] Generating keypair
2012-08-26 14:48:06 [iNFO] Starting Minecraft server on localhost:25565
2012-08-26 14:48:06 [WARNING] **** SERVER IS RUNNING IN OFFLINE/INSECURE MODE!
2012-08-26 14:48:06 [WARNING] The server will make no attempt to authenticate usernames. Beware.
2012-08-26 14:48:06 [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-08-26 14:48:06 [WARNING] To change this, set "online-mode" to "true" in the server.properties file.
2012-08-26 14:48:06 [iNFO] This server is running CraftBukkit version git-Bukkit-1.3.1-R2.0-b2340jnks (MC: 1.3.1) (Implementing API version 1.3.1-R2.0)
2012-08-26 14:48:07 [iNFO] [xAuth] Loading xAuth v2.0.20
2012-08-26 14:48:07 [iNFO] Preparing level "World"
2012-08-26 14:48:07 [iNFO] Preparing start region for level 0 (Seed: -8554519160503538700)
2012-08-26 14:48:08 [iNFO] Preparing spawn area: 73%
2012-08-26 14:48:09 [iNFO] Preparing start region for level 1 (Seed: -8554519160503538700)
2012-08-26 14:48:09 [iNFO] Preparing spawn area: 89%
2012-08-26 14:48:10 [iNFO] Preparing start region for level 2 (Seed: -8554519160503538700)
2012-08-26 14:48:10 [iNFO] [xAuth] Enabling xAuth v2.0.20
2012-08-26 14:48:11 [iNFO] [xAuth] PermissionAlias backend: 'pex' registered!
2012-08-26 14:48:11 [iNFO] [xAuth] PermissionAlias backend: 'gm' registered!
2012-08-26 14:48:11 [iNFO] [xAuth] PermissionAlias backend: 'bukkit' registered!
2012-08-26 14:48:11 [iNFO] [xAuth] Attempting to use supported permissions plugin 'GroupManager'
2012-08-26 14:48:11 [iNFO] [xAuth] Attempting to use supported permissions plugin 'PermissionsEx'
2012-08-26 14:48:11 [iNFO] [xAuth] Attempting to use supported permissions plugin 'Bukkit'
2012-08-26 14:48:11 [iNFO] [xAuth] Initializing bukkit backend
2012-08-26 14:48:11 [iNFO] [xAuth] Attached to Bukkit
2012-08-26 14:48:11 [iNFO] [xAuth] Successfully established connection to MySQL database
2012-08-26 14:48:11 [sEVERE] [xAuth] Failed to load teleport locations!
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'minecraft.lokacje' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
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.LocationManager.loadLocations(LocationManager.java:55)
at com.cypherx.xauth.LocationManager.<init>(LocationManager.java:43)
at com.cypherx.xauth.xAuth.onEnable(xAuth.java:169)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:217)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:365)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)
at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:265)
at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:247)
at net.minecraft.server.MinecraftServer.i(MinecraftServer.java:296)
at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:275)
at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:225)
at net.minecraft.server.DedicatedServer.init(DedicatedServer.java:140)
at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:378)
at net.minecraft.server.ThreadServerApplication.run(SourceFile:539)
2012-08-26 14:48:11 [iNFO] [xAuth] v2.0.20 Enabled!
2012-08-26 14:48:11 [iNFO] Server permissions file permissions.yml is empty, ignoring it
2012-08-26 14:48:11 [iNFO] Done (4,039s)! For help, type "help" or "?"

 

Dodam iż robię to 1 raz więc proszę o wysoko postawioną wyrozumiałość.

Serwer postawiony jest na local-host ,baza MySQL na xampie według tego tutoriala:

[TheDrHell]

@ref

[K4P1K]

Table 'minecraft.lokacje' doesn't exist

Spróbuj zmienić tabelę na:

minecraft_lokacje

[f0kus]

Podaj konfiguracje xAuth'a oraz zamieść SS z PhpMyAdmin z bazy minecraft

[XxNeroxX]

ehhh usuń te tabele! musisz zainstalować te tabele co podał autor wejdź na bukkit.org ściągnij xAuth i tam w paczce masz gotowe tabele!

[TheDrHell]

Ok dzieki wielkie wszscy maja + i like