PEX BungeeCord Sql config

Discussion in 'BungeeCord Help' started by PixelParty, Jun 11, 2016.

  1. Hi guys,

    I've been trying to setup Pex so that I can share the ranks across multiple servers however I have no idea which information I have to input and where, can anyone help?

    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
     
  2. Code (Text):
    multiserver:
      use-netevents: true
    permissions:
      debug: false
      allowOps: false
      user-add-groups-last: false
      log-players: false
      createUserRecords: false
      backend: sql
      informplayers:
        changes: false
      basedir: plugins/PermissionsEx
      backends:
        sql:
          uri: mysql://HOST/DATABASE
          user: USERNAME
          password: PASSWORD
          type: sql
    updater: true
    alwaysUpdate: false
    replace HOST, DATABASE, USERNAME, PASSWORD with your mysql info
     

  3. multiserver:
    use-netevents: true
    permissions:
    debug: false
    allowOps: false
    user-add-groups-last: false
    log-players: false
    createUserRecords: false
    backend: sql
    informplayers:
    changes: false
    basedir: plugins/PermissionsEx
    backends:
    sql:
    type: sql
    uri: mysql://91.208.99.2:1139/evoballn_main
    user: evoballn_main
    password: *password*
    updater: true
    alwaysUpdate: false

    So this looks about right?
     
  4. yes
     
  5. Ok well I did that and it just reset it back to the default file
     
  6. Infact now it's just generating the bit that I changed again???

    use-netevents: true
    debug: false
    allowOps: false
    user-add-groups-last: false
    log-players: false
    createUserRecords: false
    backend: sql
    changes: false
    basedir: plugins/PermissionsEx
    type: sql
    uri: mysql://91.208.99.2:1139/evoballn_main
    user: evoballn_main
    password: *pass*
    updater: true
    alwaysUpdate: false
    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
     
  7. Woaaaahhh ok, I typed /pex backend sql in chat and it did something which is progress, however.

    [10:43:51] [Server thread/INFO]: [PermissionsEx] Initializing sql backend
    [10:43:51] [Server thread/INFO]: Backend initialization failed! Fix your configuration!
    Error (see console for more): SQL connection is not configured, see config.yml
    [10:43:51] [Server thread/WARN]: [PermissionsEx] Backend initialization failed when CONSOLE was initializing sql
    ru.tehkode.permissions.exceptions.PermissionBackendException: SQL connection is not configured, see config.yml
    at ru.tehkode.permissions.backends.sql.SQLBackend.<init>(SQLBackend.java:84) ~[PermissionsEx-1.23.3.jar:?]
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.7.0_101]
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[?:1.7.0_101]
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.7.0_101]
    at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[?:1.7.0_101]
    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.bukkit.commands.UtilityCommands.setBackend(UtilityCommands.java:133) [PermissionsEx-1.23.3.jar:?]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.7.0_101]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[?:1.7.0_101]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.7.0_101]
    at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_101]
    at ru.tehkode.permissions.commands.CommandsManager$CommandBinding.call(CommandsManager.java:248) [PermissionsEx-1.23.3.jar:?]
    at ru.tehkode.permissions.commands.CommandsManager.execute(CommandsManager.java:110) [PermissionsEx-1.23.3.jar:?]
    at ru.tehkode.permissions.bukkit.PermissionsEx.onCommand(PermissionsEx.java:315) [PermissionsEx-1.23.3.jar:?]
    at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:141) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at org.bukkit.craftbukkit.v1_8_R3.CraftServer.dispatchCommand(CraftServer.java:641) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at org.bukkit.craftbukkit.v1_8_R3.CraftServer.dispatchServerCommand(CraftServer.java:627) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at net.minecraft.server.v1_8_R3.DedicatedServer.aO(DedicatedServer.java:412) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at net.minecraft.server.v1_8_R3.DedicatedServer.B(DedicatedServer.java:375) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at net.minecraft.server.v1_8_R3.MinecraftServer.A(MinecraftServer.java:654) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:557) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at java.lang.Thread.run(Thread.java:745) [?:1.7.0_101]
     
  8. And now, it generated the sql part and I filled it in, it's saying:
    [11:16:14] [Server thread/INFO]: [PermissionsEx] Enabling PermissionsEx v1.23.4
    [11:16:14] [Server thread/INFO]: [PermissionsEx] Initializing sql backend

    then it just stops.
    And spews this:

    ========== 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.7.0_101]
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[?:1.7.0_101]
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.7.0_101]
    at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[?:1.7.0_101]
    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) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:340) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at org.bukkit.craftbukkit.v1_8_R3.CraftServer.loadPlugin(CraftServer.java:357) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at org.bukkit.craftbukkit.v1_8_R3.CraftServer.enablePlugins(CraftServer.java:317) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at net.minecraft.server.v1_8_R3.MinecraftServer.s(MinecraftServer.java:414) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at net.minecraft.server.v1_8_R3.MinecraftServer.k(MinecraftServer.java:378) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at net.minecraft.server.v1_8_R3.MinecraftServer.a(MinecraftServer.java:333) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at net.minecraft.server.v1_8_R3.DedicatedServer.init(DedicatedServer.java:263) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:525) [spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at java.lang.Thread.run(Thread.java:745) [?:1.7.0_101]
    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.7.0_101]
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[?:1.7.0_101]
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.7.0_101]
    at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[?:1.7.0_101]
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.7.0_101]
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[?:1.7.0_101]
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.7.0_101]
    at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[?:1.7.0_101]
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) ~[spigot-1.8.8.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
    Caused by: java.net.ConnectException: Connection timed out
    at java.net.PlainSocketImpl.socketConnect(Native Method) ~[?:1.7.0_101]
    at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) ~[?:1.7.0_101]
    at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) ~[?:1.7.0_101]
    at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) ~[?:1.7.0_101]
    at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[?:1.7.0_101]
    at java.net.Socket.connect(Socket.java:579) ~[?:1.7.0_101]
    at java.net.Socket.connect(Socket.java:528) ~[?:1.7.0_101]
    at java.net.Socket.<init>(Socket.java:425) ~[?:1.7.0_101]
    at java.net.Socket.<init>(Socket.java:241) ~[?:1.7.0_101]
    at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:254) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.7.0_101]
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[?:1.7.0_101]
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.7.0_101]
    at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[?:1.7.0_101]
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378) ~[spigot-1.8.8.jar:git-Spigot-db6de12-18fbb24]
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) ~[spigot-1.8.8.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
    [11:18:22] [Server thread/INFO]: [PermissionsEx] Disabling PermissionsEx v1.23.4
     
  9. Noble Pro

    Moderator

    Make sure the database is online, and that you are using the correct IP and port.