PermissionsEx MySQL

Qvarix_CZ

Člen
Zpráv
4
Bodů
29
Servery
89.203.248.174:25565 BungeeCord
Dobrý den,
dnes jsem si zakoupil McUltimate a potřebuji nastavit PermissionsEX na bungeecord. Ale když server spustím napíše mi to toto:
Kód:
[17:44:39 INFO]: [PermissionsEx] Enabling PermissionsEx v1.23.3
[17:44:39 INFO]: [PermissionsEx] Initializing sql backend
[17:44:39 ERROR]: [PermissionsEx]
========== UNABLE TO LOAD PERMISSIONS BACKEND =========
Your configuration must be fixed before PEX will enable
Details: Unable to connect to SQL database
=======================================================
ru.tehkode.permissions.exceptions.PermissionBackendException: Unable to connect to SQL database
at ru.tehkode.permissions.backends.sql.SQLBackend.<init>(SQLBackend.java:118) ~[PermissionsEx-1.23.3.jar:?]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_171]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_171]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_171]
at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_171]
at ru.tehkode.permissions.backends.PermissionBackend.getBackend(PermissionBackend.java:392) ~[PermissionsEx-1.23.3.jar:?]
at ru.tehkode.permissions.backends.PermissionBackend.getBackend(PermissionBackend.java:367) ~[PermissionsEx-1.23.3.jar:?]
at ru.tehkode.permissions.PermissionManager.createBackend(PermissionManager.java:624) ~[PermissionsEx-1.23.3.jar:?]
at ru.tehkode.permissions.PermissionManager.setBackend(PermissionManager.java:606) ~[PermissionsEx-1.23.3.jar:?]
at ru.tehkode.permissions.PermissionManager.initBackend(PermissionManager.java:693) ~[PermissionsEx-1.23.3.jar:?]
at ru.tehkode.permissions.PermissionManager.<init>(PermissionManager.java:67) ~[PermissionsEx-1.23.3.jar:?]
at ru.tehkode.permissions.bukkit.PermissionsEx.onEnable(PermissionsEx.java:175) [PermissionsEx-1.23.3.jar:?]
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321) [server.jar:git-Spigot-db6de12-18fbb24]
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:340) [server.jar:git-Spigot-db6de12-18fbb24]
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405) [server.jar:git-Spigot-db6de12-18fbb24]
at org.bukkit.craftbukkit.v1_8_R3.CraftServer.loadPlugin(CraftServer.java:357) [server.jar:git-Spigot-db6de12-18fbb24]
at org.bukkit.craftbukkit.v1_8_R3.CraftServer.enablePlugins(CraftServer.java:317) [server.jar:git-Spigot-db6de12-18fbb24]
at net.minecraft.server.v1_8_R3.MinecraftServer.s(MinecraftServer.java:414) [server.jar:git-Spigot-db6de12-18fbb24]
at net.minecraft.server.v1_8_R3.MinecraftServer.k(MinecraftServer.java:378) [server.jar:git-Spigot-db6de12-18fbb24]
at net.minecraft.server.v1_8_R3.MinecraftServer.a(MinecraftServer.java:333) [server.jar:git-Spigot-db6de12-18fbb24]
at net.minecraft.server.v1_8_R3.DedicatedServer.init(DedicatedServer.java:263) [server.jar:git-Spigot-db6de12-18fbb24]
at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:525) [server.jar:git-Spigot-db6de12-18fbb24]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_171]
Caused by: java.sql.SQLException: Access denied for user 'Quarix'@'89.203.248.174' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) ~[server.jar:git-Spigot-db6de12-18fbb24]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593) ~[server.jar:git-Spigot-db6de12-18fbb24]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525) ~[server.jar:git-Spigot-db6de12-18fbb24]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931) ~[server.jar:git-Spigot-db6de12-18fbb24]
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031) ~[server.jar:git-Spigot-db6de12-18fbb24]
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296) ~[server.jar:git-Spigot-db6de12-18fbb24]
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338) ~[server.jar:git-Spigot-db6de12-18fbb24]
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371) ~[server.jar:git-Spigot-db6de12-18fbb24]
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163) ~[server.jar:git-Spigot-db6de12-18fbb24]
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) ~[server.jar:git-Spigot-db6de12-18fbb24]
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[server.jar:git-Spigot-db6de12-18fbb24]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_171]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_171]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_171]
at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_171]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[server.jar:git-Spigot-db6de12-18fbb24]
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378) ~[server.jar:git-Spigot-db6de12-18fbb24]
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) ~[server.jar:git-Spigot-db6de12-18fbb24]
at ru.tehkode.libs.org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) ~[PermissionsEx-1.23.3.jar:?]
at ru.tehkode.libs.org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) ~[PermissionsEx-1.23.3.jar:?]
at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) ~[PermissionsEx-1.23.3.jar:?]
at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ~[PermissionsEx-1.23.3.jar:?]
at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) ~[PermissionsEx-1.23.3.jar:?]
at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) ~[PermissionsEx-1.23.3.jar:?]
at ru.tehkode.permissions.backends.sql.SQLBackend.getSQL(SQLBackend.java:245) ~[PermissionsEx-1.23.3.jar:?]
at ru.tehkode.permissions.backends.sql.SQLBackend.<init>(SQLBackend.java:112) ~[PermissionsEx-1.23.3.jar:?]
... 22 more
[17:44:39 INFO]: [PermissionsEx] Disabling PermissionsEx v1.23.3
Zde config :
Kód:
multiserver:
  use-netevents: true
permissions:
  debug: false
  allowOps: false
  user-add-groups-last: false
  log-players: false
  createUserRecords: true
  backend: sql
  informplayers:
    changes: false
  basedir: plugins/PermissionsEx
  backends:
    file:
      type: file
      file: permissions.yml
    sql:
      driver: mysql
      uri: mysql://89.203.248.6/permissionsex
      user: to_zde_nedam
      password: to_zde_nedam
      type: sql
updater: true
alwaysUpdate: false
Díky za odpověd.
 

StraightCore

VIP
VIP
Zpráv
87
Bodů
264
Místo
Liberec
Servery
cs1.hicoria.com:48320
Máš tam dva různé typy backends:
smaž
Kód:
    file:
      type: file
      file: permissions.yml
databázi permissionsex máš vytvořenou?
 

Neko7894

Veterán
Zpráv
76
Bodů
52
Servery
VPS: 89.203.249.214 (Debian 9)
Vytvořil si server a hned nahrál plugin a config a pak poprvé za pl server, že.
 

_HeroPwP

Moderátor
Moderator
GS sekce
Zpráv
814
Bodů
1 093
Místo
Praha
Servery
mc.DarkMC.eu
Dobrý den,

Kód:
Caused by: java.sql.SQLException: Access denied for user 'Quarix'@'89.203.248.174' (using password: YES)
PermissionsEx se nemůže připojit k MySQL.

Zkontrolujte, zda:
  1. Zadáváte všechny údaje korektně
  2. Máte vytvořeného uživatele
  3. Máte povolené připojení mimo localhost
  4. Máte vytvořenou databázi: permissionsex
 

Neko7894

Veterán
Zpráv
76
Bodů
52
Servery
VPS: 89.203.249.214 (Debian 9)
Taky to tam jde vidět. Vymaž plugin i s configem. Pak nahraje jen samotné permex a zapni server. Po zapnutí serveru teprve nahéj config.
 

Qvarix_CZ

Člen
Zpráv
4
Bodů
29
Servery
89.203.248.174:25565 BungeeCord
Stále nic.

---- Automaticky sloučená zpráva ----

Vyřešeno na podpoře Hicorie
 
Poslední změna:

Neko7894

Veterán
Zpráv
76
Bodů
52
Servery
VPS: 89.203.249.214 (Debian 9)
Dobrý den. Používejte tlačítko upravit a dodejte sem postup vyřešení problému. Dále topic označte jako Vyřešeny.
 
Top