Bungee pex

[mijo1652]

Server: cez VPS 82.208.17.141

Ahojte.. poznáte plugin, že keď na jednom serveri niekoho dám do skupiny VIP tak ho dá na všetkých serveroch bungeecordu tiež do skupiny VIP? Hľadal som na webe, len nič také som nenašiel.

Ďakujem za radu

[Port2]

Jednoduché propojení MySQL

[mijo1652]

Pex nemá mysql

[pitilon@seznam.cz]

má config.yml ..

[mijo1652]

Kód: Vybrat vše

multiserver:
  use-netevents: true
permissions:
  debug: false
  allowOps: false
  user-add-groups-last: false
  log-players: false
  createUserRecords: false
  backend: file
  informplayers:
    changes: false
  basedir: plugins/PermissionsEx
  backends:
    file:
      type: file
      file: permissions.yml
updater: true
alwaysUpdate: false


mysql?

[NEZNAMY]

Kód: Vybrat vše

permissions:
    backend: sql
    backends:
        sql:
            uri: mysql://localhost/databasename
            user: username
            password: password

[mijo1652]

Kde môže byť chyba?

log

Kód: Vybrat vše

[18:29:27] [Server thread/INFO]: [PermissionsEx] Enabling PermissionsEx v1.23.4
[18:29:27] [Server thread/INFO]: [PermissionsEx] Initializing sql backend
[18:29:27] [Server thread/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.4.jar:?]
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_121]
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_121]
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_121]
   at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_121]
   at ru.tehkode.permissions.backends.PermissionBackend.getBackend(PermissionBackend.java:392) ~[PermissionsEx-1.23.4.jar:?]
   at ru.tehkode.permissions.backends.PermissionBackend.getBackend(PermissionBackend.java:367) ~[PermissionsEx-1.23.4.jar:?]
   at ru.tehkode.permissions.PermissionManager.createBackend(PermissionManager.java:624) ~[PermissionsEx-1.23.4.jar:?]
   at ru.tehkode.permissions.PermissionManager.setBackend(PermissionManager.java:606) ~[PermissionsEx-1.23.4.jar:?]
   at ru.tehkode.permissions.PermissionManager.initBackend(PermissionManager.java:693) ~[PermissionsEx-1.23.4.jar:?]
   at ru.tehkode.permissions.PermissionManager.<init>(PermissionManager.java:67) ~[PermissionsEx-1.23.4.jar:?]
   at ru.tehkode.permissions.bukkit.PermissionsEx.onEnable(PermissionsEx.java:175) [PermissionsEx-1.23.4.jar:?]
   at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:292) [spigot.jar:git-Spigot-72c2605-251a5b6]
   at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:337) [spigot.jar:git-Spigot-72c2605-251a5b6]
   at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405) [spigot.jar:git-Spigot-72c2605-251a5b6]
   at org.bukkit.craftbukkit.v1_10_R1.CraftServer.enablePlugin(CraftServer.java:373) [spigot.jar:git-Spigot-72c2605-251a5b6]
   at org.bukkit.craftbukkit.v1_10_R1.CraftServer.enablePlugins(CraftServer.java:323) [spigot.jar:git-Spigot-72c2605-251a5b6]
   at net.minecraft.server.v1_10_R1.MinecraftServer.t(MinecraftServer.java:412) [spigot.jar:git-Spigot-72c2605-251a5b6]
   at net.minecraft.server.v1_10_R1.MinecraftServer.l(MinecraftServer.java:377) [spigot.jar:git-Spigot-72c2605-251a5b6]
   at net.minecraft.server.v1_10_R1.MinecraftServer.a(MinecraftServer.java:332) [spigot.jar:git-Spigot-72c2605-251a5b6]
   at net.minecraft.server.v1_10_R1.DedicatedServer.init(DedicatedServer.java:271) [spigot.jar:git-Spigot-72c2605-251a5b6]
   at net.minecraft.server.v1_10_R1.MinecraftServer.run(MinecraftServer.java:535) [spigot.jar:git-Spigot-72c2605-251a5b6]
   at java.lang.Thread.run(Thread.java:745) [?:1.8.0_121]
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_121]
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_121]
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_121]
   at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_121]
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) ~[spigot.jar:git-Spigot-72c2605-251a5b6]
   at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:983) ~[spigot.jar:git-Spigot-72c2605-251a5b6]
   at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:339) ~[spigot.jar:git-Spigot-72c2605-251a5b6]
   at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2252) ~[spigot.jar:git-Spigot-72c2605-251a5b6]
   at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2285) ~[spigot.jar:git-Spigot-72c2605-251a5b6]
   at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2084) ~[spigot.jar:git-Spigot-72c2605-251a5b6]
   at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:795) ~[spigot.jar:git-Spigot-72c2605-251a5b6]
   at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44) ~[spigot.jar:git-Spigot-72c2605-251a5b6]
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_121]
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_121]
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_121]
   at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_121]
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) ~[spigot.jar:git-Spigot-72c2605-251a5b6]
   at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400) ~[spigot.jar:git-Spigot-72c2605-251a5b6]
   at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:327) ~[spigot.jar:git-Spigot-72c2605-251a5b6]
   at ru.tehkode.libs.org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) ~[PermissionsEx-1.23.4.jar:?]
   at ru.tehkode.libs.org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) ~[PermissionsEx-1.23.4.jar:?]
   at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) ~[PermissionsEx-1.23.4.jar:?]
   at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ~[PermissionsEx-1.23.4.jar:?]
   at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) ~[PermissionsEx-1.23.4.jar:?]
   at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) ~[PermissionsEx-1.23.4.jar:?]
   at ru.tehkode.permissions.backends.sql.SQLBackend.getSQL(SQLBackend.java:245) ~[PermissionsEx-1.23.4.jar:?]
   at ru.tehkode.permissions.backends.sql.SQLBackend.<init>(SQLBackend.java:112) ~[PermissionsEx-1.23.4.jar:?]
   ... 22 more
Caused by: java.net.NoRouteToHostException: No route to host (Host unreachable)
   at java.net.PlainSocketImpl.socketConnect(Native Method) ~[?:1.8.0_121]
   at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) ~[?:1.8.0_121]
   at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) ~[?:1.8.0_121]
   at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) ~[?:1.8.0_121]
   at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[?:1.8.0_121]
   at java.net.Socket.connect(Socket.java:589) ~[?:1.8.0_121]
   at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:214) ~[spigot.jar:git-Spigot-72c2605-251a5b6]
   at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:298) ~[spigot.jar:git-Spigot-72c2605-251a5b6]
   at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2252) ~[spigot.jar:git-Spigot-72c2605-251a5b6]
   at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2285) ~[spigot.jar:git-Spigot-72c2605-251a5b6]
   at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2084) ~[spigot.jar:git-Spigot-72c2605-251a5b6]
   at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:795) ~[spigot.jar:git-Spigot-72c2605-251a5b6]
   at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44) ~[spigot.jar:git-Spigot-72c2605-251a5b6]
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_121]
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_121]
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_121]
   at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_121]
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) ~[spigot.jar:git-Spigot-72c2605-251a5b6]
   at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400) ~[spigot.jar:git-Spigot-72c2605-251a5b6]
   at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:327) ~[spigot.jar:git-Spigot-72c2605-251a5b6]
   at ru.tehkode.libs.org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) ~[PermissionsEx-1.23.4.jar:?]
   at ru.tehkode.libs.org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) ~[PermissionsEx-1.23.4.jar:?]
   at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) ~[PermissionsEx-1.23.4.jar:?]
   at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ~[PermissionsEx-1.23.4.jar:?]
   at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) ~[PermissionsEx-1.23.4.jar:?]
   at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) ~[PermissionsEx-1.23.4.jar:?]
   at ru.tehkode.permissions.backends.sql.SQLBackend.getSQL(SQLBackend.java:245) ~[PermissionsEx-1.23.4.jar:?]
   at ru.tehkode.permissions.backends.sql.SQLBackend.<init>(SQLBackend.java:112) ~[PermissionsEx-1.23.4.jar:?]
   ... 22 more

config

Kód: Vybrat vše

multiserver:
  use-netevents: true
permissions:
  debug: false
  allowOps: false
  user-add-groups-last: false
  log-players: false
  createUserRecords: false
  informplayers:
    changes: false
  basedir: plugins/PermissionsEx
  backend: sql
  backends:
    file:
      type: file
      file: permissions.yml
    sql:
      uri: mysql://wm145.wedos.net/d157600_mc
      user: a157600_mc
      password: heslo
updater: true
alwaysUpdate: false


[mijo1652]

Používa niekto pex cez mysql?
Pošlite mi prosím aký máte config,

[Mike8748]

chyba je v tom že se pokoušíš napojit na databází webhostingu u wedosu...

v nápovědě mají

databáze přístupná pouze z webhostingu, z bezpečnostních důvodů se k ní nelze připojovat zvenku (ani z VPS či dedikovaných serverů u nás)

[Droopy223]

Dobrý den, máte vůbec koupený či nainstalování MySQL ?