1. Вы находитесь в сообществе Rubukkit. Мы - администраторы серверов Minecraft, разрабатываем собственные плагины и переводим на различные языки плагины наших коллег из других стран.
    Скрыть объявление
Скрыть объявление
В преддверии глобального обновления, мы проводим исследования, которые помогут нам сделать опыт пользования форумом ещё удобнее. Помогите нам, примите участие!

Помогите Не могу подключить 2 authme к одной БД

Тема в разделе "Помощь", создана пользователем KirillYno, 28 фев 2020.

  1. Автор темы
    KirillYno

    KirillYno Новичок Пользователь

    Баллы:
    6
    Здравствуйте, обыватели форума! Столкнулся с такой проблемой, при попытке подключить сервер Auth с плагином AuthMe, у меня все работает, НО если я попытаюсь подключить другой сервер, например lobby, то у меня этот сервер выключается после включение, сразу.

    Конфиг Data Score:
    DataSource:
    # What type of database do you want to use?
    # Valid values: SQLITE, MYSQL, POSTGRESQL
    backend: MYSQL
    # Enable the database caching system, should be disabled on bungeecord environments
    # or when a website integration is being used.
    caching: false
    # Database host address
    mySQLHost: localhost
    # Database port
    mySQLPort: '3306'
    # Connect to MySQL database over SSL
    mySQLUseSSL: false
    # Username to connect to the MySQL database
    mySQLUsername: authme
    # Password to connect to the MySQL database
    mySQLPassword: 1234
    # Database Name, use with converters or as SQLITE database name
    mySQLDatabase: voroncraftbd
    # Table of the database
    mySQLTablename: authme
    # Column of IDs to sort data
    mySQLColumnId: id
    # Column for storing or checking players nickname
    mySQLColumnName: username
    # Column for storing or checking players RealName
    mySQLRealName: realname
    # Column for storing players passwords
    mySQLColumnPassword: password
    # Column for storing players passwords salts
    mySQLColumnSalt: ''
    # Column for storing players emails
    mySQLColumnEmail: email
    # Column for storing if a player is logged in or not
    mySQLColumnLogged: isLogged
    # Column for storing if a player has a valid session or not
    mySQLColumnHasSession: hasSession
    # Column for storing a player's TOTP key (for two-factor authentication)
    mySQLtotpKey: totp
    # Column for storing the player's last IP
    mySQLColumnIp: ip
    # Column for storing players lastlogins
    mySQLColumnLastLogin: lastlogin
    # Column storing the registration date
    mySQLColumnRegisterDate: regdate
    # Column for storing the IP address at the time of registration
    mySQLColumnRegisterIp: regip
    # Column for storing player LastLocation - X
    mySQLlastlocX: x
    # Column for storing player LastLocation - Y
    mySQLlastlocY: y
    # Column for storing player LastLocation - Z
    mySQLlastlocZ: z
    # Column for storing player LastLocation - World Name
    mySQLlastlocWorld: world
    # Column for storing player LastLocation - Yaw
    mySQLlastlocYaw: yaw
    # Column for storing player LastLocation - Pitch
    mySQLlastlocPitch: pitch
    # Overrides the size of the DB Connection Pool, default = 10
    poolSize: 10
    # The maximum lifetime of a connection in the pool, default = 1800 seconds
    # You should set this at least 30 seconds less than mysql server wait_timeout
    maxLifetime: 1800

    Пробовал разные варианты, создавал второго пользователя, но ничего не получалось, помогите пожалуйста!
     
    Последнее редактирование: 26 мар 2020
  2. Автор темы
    KirillYno

    KirillYno Новичок Пользователь

    Баллы:
    6
    Логи при ошибке -
    [07:52:29] [Server thread/INFO]: Starting minecraft server version 1.8.8
    [07:52:32] [Server thread/WARN]: To start the server with more ram, launch it as "java -Xmx1024M -Xms1024M -jar minecraft_server.jar"
    [07:52:32] [Server thread/INFO]: Loading properties
    [07:52:32] [Server thread/INFO]: Default game type: ADVENTURE
    [07:52:32] [Server thread/INFO]: This server is running CraftBukkit version git-Spigot-e4d4710-e1ebe52 (MC: 1.8.8) (Implementing API version 1.8.8-R0.1-SNAPSHOT)
    [07:52:33] [Server thread/INFO]: Debug logging is disabled
    [07:52:33] [Server thread/WARN]: *** WARNING *** stats.disable-saving is true but stats.forced-stats.achievement.openInventory isn't set to 1. Disabling stat saving without forcing the achievement may cause it to get stuck on the player's screen.
    [07:52:33] [Server thread/INFO]: Using 4 threads for Netty based IO
    [07:52:33] [Server thread/INFO]: Server Ping Player Sample Count: 12
    [07:52:33] [Server thread/INFO]: Generating keypair
    [07:52:33] [Server thread/INFO]: Starting Minecraft server on 127.0.0.1:25569
    [07:52:33] [Server thread/INFO]: Using default channel type
    [07:52:34] [Server thread/INFO]: Set PluginClassLoader as parallel capable
    [07:52:34] [Server thread/INFO]: [AuthMe] Loading AuthMe v5.5.1-SNAPSHOT-b2192
    [07:52:34] [Server thread/INFO]: [ProtocolSupport] Loading ProtocolSupport v4.29-dev
    [07:52:34] [Server thread/ERROR]: [ProtocolSupport] Unsupported server implementation type or version
    [07:52:34] [Server thread/INFO]: [ProtocolSupport] Enabling ProtocolSupport v4.29-dev
    [07:52:34] [Server thread/ERROR]: Error occurred while enabling ProtocolSupport v4.29-dev (Is it up to date?)
    java.lang.IllegalStateException: Access to implementation before detect
    at protocolsupport.zplatform.ServerPlatform.get(ServerPlatform.java:41) ~[?:?]
    at protocolsupport.ProtocolSupport.onEnable(ProtocolSupport.java:123) ~[?:?]
    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321) ~[Spigot.jar:git-Spigot-e4d4710-e1ebe52]
    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:340) [Spigot.jar:git-Spigot-e4d4710-e1ebe52]
    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405) [Spigot.jar:git-Spigot-e4d4710-e1ebe52]
    at org.bukkit.craftbukkit.v1_8_R3.CraftServer.loadPlugin(CraftServer.java:357) [Spigot.jar:git-Spigot-e4d4710-e1ebe52]
    at org.bukkit.craftbukkit.v1_8_R3.CraftServer.enablePlugins(CraftServer.java:317) [Spigot.jar:git-Spigot-e4d4710-e1ebe52]
    at net.minecraft.server.v1_8_R3.DedicatedServer.init(DedicatedServer.java:199) [Spigot.jar:git-Spigot-e4d4710-e1ebe52]
    at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:525) [Spigot.jar:git-Spigot-e4d4710-e1ebe52]
    at java.lang.Thread.run(Unknown Source) [?:1.8.0_241]
    [07:52:35] [Server thread/WARN]: **** SERVER IS RUNNING IN OFFLINE/INSECURE MODE!
    [07:52:35] [Server thread/WARN]: The server will make no attempt to authenticate usernames. Beware.
    [07:52:35] [Server thread/WARN]: Whilst this makes it possible to use BungeeCord, unless access to your server is properly restricted, it also opens up the ability for hackers to connect with any username they choose.
    [07:52:35] [Server thread/WARN]: Please see http://www.spigotmc.org/wiki/firewall-guide/ for further information.
    [07:52:35] [Server thread/WARN]: To change this, set "online-mode" to "true" in the server.properties file.
    [07:52:35] [Server thread/INFO]: **** Beginning UUID conversion, this may take A LONG time ****
    [07:52:35] [Server thread/INFO]: Preparing level "world"
    [07:52:40] [Server thread/INFO]: -------- World Settings For [world] --------
    [07:52:40] [Server thread/INFO]: Arrow Despawn Rate: 1200
    [07:52:40] [Server thread/INFO]: Item Merge Radius: 2.5
    [07:52:40] [Server thread/INFO]: Item Despawn Rate: 6000
    [07:52:40] [Server thread/INFO]: View Distance: 1
    [07:52:40] [Server thread/INFO]: Max Entity Collisions: 8
    [07:52:40] [Server thread/INFO]: Custom Map Seeds: Village: 10387312 Feature: 14357617
    [07:52:40] [Server thread/INFO]: Allow Zombie Pigmen to spawn from portal blocks: true
    [07:52:40] [Server thread/INFO]: Chunks to Grow per Tick: 650
    [07:52:40] [Server thread/INFO]: Clear tick list: false
    [07:52:40] [Server thread/INFO]: Experience Merge Radius: 3.0
    [07:52:40] [Server thread/INFO]: Zombie Aggressive Towards Villager: true
    [07:52:40] [Server thread/INFO]: Mob Spawn Range: 3
    [07:52:40] [Server thread/INFO]: Anti X-Ray: false
    [07:52:40] [Server thread/INFO]: Engine Mode: 1
    [07:52:40] [Server thread/INFO]: Hidden Blocks: [14, 15, 16, 21, 48, 49, 54, 56, 73, 74, 82, 129, 130]
    [07:52:40] [Server thread/INFO]: Replace Blocks: [1, 5]
    [07:52:40] [Server thread/INFO]: Nerfing mobs spawned from spawners: false
    [07:52:40] [Server thread/INFO]: Cactus Growth Modifier: 100%
    [07:52:40] [Server thread/INFO]: Cane Growth Modifier: 100%
    [07:52:40] [Server thread/INFO]: Melon Growth Modifier: 100%
    [07:52:40] [Server thread/INFO]: Mushroom Growth Modifier: 100%
    [07:52:40] [Server thread/INFO]: Pumpkin Growth Modifier: 100%
    [07:52:40] [Server thread/INFO]: Sapling Growth Modifier: 100%
    [07:52:40] [Server thread/INFO]: Wheat Growth Modifier: 100%
    [07:52:40] [Server thread/INFO]: NetherWart Growth Modifier: 100%
    [07:52:40] [Server thread/INFO]: Structure Info Saving: true
    [07:52:40] [Server thread/INFO]: Max TNT Explosions: 100
    [07:52:40] [Server thread/INFO]: Entity Tracking Range: Pl 32 / An 32 / Mo 32 / Mi 32 / Other 32
    [07:52:40] [Server thread/INFO]: Sending up to 5 chunks per packet
    [07:52:40] [Server thread/INFO]: Hopper Transfer: 8 Hopper Check: 8 Hopper Amount: 1
    [07:52:40] [Server thread/INFO]: Entity Activation Range: An 32 / Mo 32 / Mi 32
    [07:52:40] [Server thread/INFO]: Random Lighting Updates: false
    [07:52:40] [Server thread/INFO]: Tile Max Tick Time: 50ms Entity max Tick Time: 50ms
    [07:52:46] [Server thread/INFO]: Preparing start region for level 0 (Seed: 567522085109905383)
    [07:52:46] [Server thread/INFO]: [AuthMe] Enabling AuthMe v5.5.1-SNAPSHOT-b2192
    [07:52:47] [Server thread/INFO]: [AuthMe] Connection arguments loaded, Hikari ConnectionPool ready!
    [07:52:47] [Server thread/WARN]: [Server thread] INFO fr.xephi.authme.libs.com.zaxxer.hikari.HikariDataSource - AuthMeMYSQLPool - Starting...
    [07:52:48] [Server thread/WARN]: [Server thread] INFO fr.xephi.authme.libs.com.zaxxer.hikari.pool.PoolBase - AuthMeMYSQLPool - Driver does not support get/set network timeout for connections. (com.mysql.jdbc.JDBC4Connection.getNetworkTimeout()I)
    [07:52:48] [Server thread/WARN]: [Server thread] WARN fr.xephi.authme.libs.com.zaxxer.hikari.pool.PoolBase - AuthMeMYSQLPool - Default transaction isolation level detection failed (Unknown system variable 'tx_isolation').
    [07:52:48] [Server thread/WARN]: [Server thread] ERROR fr.xephi.authme.libs.com.zaxxer.hikari.pool.HikariPool - AuthMeMYSQLPool - Exception during pool initialization.
    [07:52:48] [Server thread/WARN]: java.sql.SQLException: Unknown system variable 'tx_isolation'
    [07:52:48] [Server thread/WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
    [07:52:48] [Server thread/WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    [07:52:48] [Server thread/WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    [07:52:48] [Server thread/WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    [07:52:48] [Server thread/WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    [07:52:48] [Server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    [07:52:48] [Server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    [07:52:48] [Server thread/WARN]: at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    [07:52:48] [Server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.getTransactionIsolation(ConnectionImpl.java:3198)
    [07:52:48] [Server thread/WARN]: at fr.xephi.authme.libs.com.zaxxer.hikari.pool.PoolBase.checkDriverSupport(PoolBase.java:466)
    [07:52:48] [Server thread/WARN]: at fr.xephi.authme.libs.com.zaxxer.hikari.pool.PoolBase.setupConnection(PoolBase.java:421)
    [07:52:48] [Server thread/WARN]: at fr.xephi.authme.libs.com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:374)
    [07:52:48] [Server thread/WARN]: at fr.xephi.authme.libs.com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:198)
    [07:52:48] [Server thread/WARN]: at fr.xephi.authme.libs.com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:467)
    [07:52:48] [Server thread/WARN]: at fr.xephi.authme.libs.com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:541)
    [07:52:48] [Server thread/WARN]: at fr.xephi.authme.libs.com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
    [07:52:48] [Server thread/WARN]: at fr.xephi.authme.libs.com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
    [07:52:48] [Server thread/WARN]: at fr.xephi.authme.datasource.MySQL.getConnection(MySQL.java:156)
    [07:52:48] [Server thread/WARN]: at fr.xephi.authme.datasource.MySQL.checkTablesAndColumns(MySQL.java:163)
    [07:52:48] [Server thread/WARN]: at fr.xephi.authme.datasource.MySQL.<init>(MySQL.java:71)
    [07:52:48] [Server thread/WARN]: at fr.xephi.authme.initialization.DataSourceProvider.createDataSource(DataSourceProvider.java:66)
    [07:52:48] [Server thread/WARN]: at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:47)
    [07:52:48] [Server thread/WARN]: at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:25)
    [07:52:48] [Server thread/WARN]: at fr.xephi.authme.libs.ch.jalu.injector.handlers.instantiation.ProviderHandler$InstantiationByProviderClass.instantiateWith(ProviderHandler.java:129)
    [07:52:48] [Server thread/WARN]: at fr.xephi.authme.libs.ch.jalu.injector.InjectorImpl.resolveContext(InjectorImpl.java:164)
    [07:52:48] [Server thread/WARN]: at fr.xephi.authme.libs.ch.jalu.injector.InjectorImpl.resolve(InjectorImpl.java:133)
    [07:52:48] [Server thread/WARN]: at fr.xephi.authme.libs.ch.jalu.injector.InjectorImpl.getSingleton(InjectorImpl.java:72)
    [07:52:48] [Server thread/WARN]: at fr.xephi.authme.AuthMe.instantiateServices(AuthMe.java:242)
    [07:52:48] [Server thread/WARN]: at fr.xephi.authme.AuthMe.initialize(AuthMe.java:217)
    [07:52:48] [Server thread/WARN]: at fr.xephi.authme.AuthMe.onEnable(AuthMe.java:127)
    [07:52:48] [Server thread/WARN]: at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321)
    [07:52:48] [Server thread/WARN]: at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:340)
    [07:52:48] [Server thread/WARN]: at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405)
    [07:52:48] [Server thread/WARN]: at org.bukkit.craftbukkit.v1_8_R3.CraftServer.loadPlugin(CraftServer.java:357)
    [07:52:48] [Server thread/WARN]: at org.bukkit.craftbukkit.v1_8_R3.CraftServer.enablePlugins(CraftServer.java:317)
    [07:52:48] [Server thread/WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.s(MinecraftServer.java:414)
    [07:52:48] [Server thread/WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.k(MinecraftServer.java:378)
    [07:52:48] [Server thread/WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.a(MinecraftServer.java:333)
    [07:52:48] [Server thread/WARN]: at net.minecraft.server.v1_8_R3.DedicatedServer.init(DedicatedServer.java:263)
    [07:52:48] [Server thread/WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:525)
    [07:52:48] [Server thread/WARN]: at java.lang.Thread.run(Unknown Source)
    [07:52:48] [Server thread/WARN]: [AuthMe] Can't initialize the MySQL database: [SQLException]: Unknown system variable 'tx_isolation'
    [07:52:48] [Server thread/WARN]: [AuthMe] Please check your database settings in the config.yml file!
    [07:52:48] [Server thread/WARN]: [AuthMe] Could not create data source: [SQLException]: Unknown system variable 'tx_isolation'
    [07:52:48] [Server thread/WARN]: [AuthMe] Aborting initialization of AuthMe: [IllegalStateException]: Error during initialization of data source
    [07:52:48] [Server thread/WARN]: [AuthMe] THE SERVER IS GOING TO SHUT DOWN AS DEFINED IN THE CONFIGURATION!
    [07:52:48] [Server thread/INFO]: [AuthMe] Waiting for 0 tasks to finish
    [07:52:48] [Server thread/INFO]: [AuthMe] AuthMe 5.5.1-SNAPSHOT-b2192 disabled!
    [07:52:49] [Server thread/INFO]: Server permissions file permissions.yml is empty, ignoring it
    [07:52:49] [Server thread/INFO]: Done (14,084s)! For help, type "help" or "?"
    [07:52:49] [Server thread/INFO]: Stopping server
    [07:52:49] [Server thread/INFO]: [ProtocolSupport] Disabling ProtocolSupport v4.29-dev
    [07:52:49] [Server thread/ERROR]: Error occurred while disabling ProtocolSupport v4.29-dev (Is it up to date?)
    java.lang.IllegalStateException: Access to implementation before detect
    at protocolsupport.zplatform.ServerPlatform.get(ServerPlatform.java:41) ~[?:?]
    at protocolsupport.ProtocolSupport.onDisable(ProtocolSupport.java:133) ~[?:?]
    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:323) ~[Spigot.jar:git-Spigot-e4d4710-e1ebe52]
    at org.bukkit.plugin.java.JavaPluginLoader.disablePlugin(JavaPluginLoader.java:364) [Spigot.jar:git-Spigot-e4d4710-e1ebe52]
    at org.bukkit.plugin.SimplePluginManager.disablePlugin(SimplePluginManager.java:424) [Spigot.jar:git-Spigot-e4d4710-e1ebe52]
    at org.bukkit.plugin.SimplePluginManager.disablePlugins(SimplePluginManager.java:417) [Spigot.jar:git-Spigot-e4d4710-e1ebe52]
    at org.bukkit.craftbukkit.v1_8_R3.CraftServer.disablePlugins(CraftServer.java:336) [Spigot.jar:git-Spigot-e4d4710-e1ebe52]
    at net.minecraft.server.v1_8_R3.MinecraftServer.stop(MinecraftServer.java:460) [Spigot.jar:git-Spigot-e4d4710-e1ebe52]
    at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:593) [Spigot.jar:git-Spigot-e4d4710-e1ebe52]
    at java.lang.Thread.run(Unknown Source) [?:1.8.0_241]
    [07:52:49] [Server thread/INFO]: Saving players
    [07:52:49] [Server thread/INFO]: Saving worlds
    [07:52:49] [Server thread/INFO]: Saving chunks for level 'world'/Overworld
     
    Последнее редактирование: 28 фев 2020
  3. Автор темы
    KirillYno

    KirillYno Новичок Пользователь

    Баллы:
    6
    А, сори, нет не учил, т.к. недавно на сайте
     

Поделиться этой страницей