xAuth databáze pro více serverů

[stefkoun]

Server: 93.91.250.123:37313

Zdravím,

Mám menší nápad, který bych rád uskutečnil, ale nejsem si jistý jestli to tak úplně jde.
Chtěl bych udělat databázi, která by byla pro všechny mé servery stejná a kdyby se někdo registroval na jednom serveru, už by mel účet na všech ostatních serverech.
Teoreticky by to mělo jít, ale malá pomoc by se hodila.

Děkuji předem!

[zdenda204]

Co přesně by jsi chtěl slyšet?
Jde to. Stačí všechny plugin napojovat na jednu databází.

[Sejsel]

Stačí to vše napojit na stejnou databázi, jak už napsal zdenda. Pozor ale na IP serveru, je nutno použít xxxx.fakaheda.eu nebo číselnou IP místo localhost.

[stefkoun]

Ano to mam, akorat mam problem s portem...
Nevim jestli tam mam dat port serveru nebo tam nechat 3306

[Sejsel]

Nech tam 3306.

[stefkoun]

Tohle mi vypise konzole, kdyz zapnu server.

Spoiler: zobrazit

Kód: Vybrat vše

> 16:05:08 [INFO] [xAuth] Enabling xAuth v2.0.20
> 16:05:08 [WARNING] [xAuth] -------- xAuth Updater --------
> 16:05:08 [WARNING] [xAuth] This server appears to be running an older version
> 16:05:08 [WARNING] [xAuth] of xAuth. Version 2.0.26 is now available.
> 16:05:08 [WARNING] [xAuth]
> 16:05:08 [WARNING] [xAuth] Priority: HIGH
> 16:05:08 [WARNING] [xAuth] Details: http://github.com/lycano/xAuth/
> 16:05:08 [WARNING] [xAuth] Download: http://ci.luricos.de/public/xAuth/
> 16:05:08 [WARNING] [xAuth] -------------------------------
> 16:05:08 [INFO] [xAuth] PermissionAlias backend: 'pex' registered!
> 16:05:08 [INFO] [xAuth] PermissionAlias backend: 'gm' registered!
> 16:05:08 [INFO] [xAuth] PermissionAlias backend: 'bukkit' registered!
> 16:05:08 [INFO] [xAuth] Attempting to use supported permissions plugin 'GroupManager'
> 16:05:08 [INFO] [xAuth] Attempting to use supported permissions plugin 'PermissionsEx'
> 16:05:08 [INFO] [xAuth] Config node permissions.backend changed to 'pex'
> 16:05:08 [INFO] [xAuth] Initializing pex backend
> 16:05:08 [WARNING] [xAuth] This plugin is not ready yet.
> 16:05:08 [INFO] [xAuth] Attached to PermissionsEx version 1.19.3
> 16:05:08 [SEVERE] [xAuth] Failed to borrow MySQL connection from pool!
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'gs_37313_1'@'%' to database 'xauth'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
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.checkErrorPacket(MysqlIO.java:931)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
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.ConnectionImpl.getInstance(ConnectionImpl.java:378)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
at java.sql.DriverManager.getConnection(DriverManager.java:579)
at java.sql.DriverManager.getConnection(DriverManager.java:221)
at com.cypherx.xauth.database.ConnectionPool.leaseConn(ConnectionPool.java:62)
at com.cypherx.xauth.database.DatabaseController.getConnection(DatabaseController.java:105)
at com.cypherx.xauth.database.DatabaseController.isConnectable(DatabaseController.java:94)
at com.cypherx.xauth.xAuth.onEnable(xAuth.java:154)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:217)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:374)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)
at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:270)
at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:252)
at net.minecraft.server.MinecraftServer.j(MinecraftServer.java:320)
at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:299)
at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:258)
at net.minecraft.server.DedicatedServer.init(DedicatedServer.java:147)
at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:398)
at net.minecraft.server.ThreadServerApplication.run(SourceFile:856)
> 16:05:08 [SEVERE] [xAuth] Failed to establish MySQL database connection!
> 16:05:08 [INFO] [xAuth] Disabling xAuth v2.0.20
> 16:05:08 [INFO] [xAuth] Detached from Permissions plugin 'PermissionsEx'.
> 16:05:08 [INFO] [xAuth] v2.0.20 Disabled!

[Sejsel]

Oba configy, bez hesel..

[zdenda204]

Hod sem config.
Zkouší se to připojit na Databází XAuth.
A ještě se mi nezdá adres na kterou se to snaží připojit...

[stefkoun]

Uz jsem vse zpravil databaze je spravne napojena ted mi to zas hazi tohle

Kód: Vybrat vše

> 16:26:12 [SEVERE] [xAuth] Something went wrong while creating account for player: gregy18
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'playername' in 'field list'

[Sejsel]

Rozhodně se neshodují názvy sloupců tabulek, to je chyba.. dej sem oba configy a napiš, který je původní.. ti to spravím