Solved PermissionsEx SQL

So when I try to get PEX working with SQL, I use this config:

Code:

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
    sql:
      driver: mysql
      uri: mysql://198.*.75.*:3306/mc_**
      user: mc_**
      password: ***
updater: true
alwaysUpdate: false

and then run /pex backend sql in console, it spits out the following:

Show Spoiler Hide Spoiler

15.09 18:11:27 [Server] INFO ... 26 more
15.09 18:11:27 [Server] INFO at ru.tehkode.permissions.backends.sql.SQLBackend.deployTables(SQLBackend.java:354) ~[PermissionsEx.jar:?]
15.09 18:11:27 [Server] INFO at ru.tehkode.permissions.backends.sql.SQLBackend.executeStream(SQLBackend.java:339) ~[PermissionsEx.jar:?]
15.09 18:11:27 [Server] INFO at ru.tehkode.libs.org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) ~[PermissionsEx.jar:?]
15.09 18:11:27 [Server] INFO at ru.tehkode.libs.org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) ~[PermissionsEx.jar:?]
15.09 18:11:27 [Server] INFO at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1065) ~[spigot.jar:git-Spigot-1.7.9-R0.2-204-g8f343a4]
15.09 18:11:27 [Server] INFO Caused by: java.sql.BatchUpdateException: Unknown character set: 'utf8mb4'
15.09 18:11:27 [Server] INFO at net.minecraft.server.v1_7_R4.ThreadServerApplication.run(SourceFile:628) [spigot.jar:git-Spigot-1.7.9-R0.2-204-g8f343a4]
15.09 18:11:27 [Server] INFO at net.minecraft.server.v1_7_R4.MinecraftServer.run(MinecraftServer.java:490) [spigot.jar:git-Spigot-1.7.9-R0.2-204-g8f343a4]
15.09 18:11:27 [Server] INFO at net.minecraft.server.v1_7_R4.MinecraftServer.u(MinecraftServer.java:584) [spigot.jar:git-Spigot-1.7.9-R0.2-204-g8f343a4]
15.09 18:11:27 [Server] INFO at net.minecraft.server.v1_7_R4.DedicatedServer.v(DedicatedServer.java:290) [spigot.jar:git-Spigot-1.7.9-R0.2-204-g8f343a4]
15.09 18:11:27 [Server] INFO at net.minecraft.server.v1_7_R4.DedicatedServer.aB(DedicatedServer.java:326) [spigot.jar:git-Spigot-1.7.9-R0.2-204-g8f343a4]
15.09 18:11:27 [Server] INFO at org.bukkit.craftbukkit.v1_7_R4.CraftServer.dispatchServerCommand(CraftServer.java:753) [spigot.jar:git-Spigot-1.7.9-R0.2-204-g8f343a4]
15.09 18:11:27 [Server] INFO at org.bukkit.craftbukkit.v1_7_R4.CraftServer.dispatchCommand(CraftServer.java:767) [spigot.jar:git-Spigot-1.7.9-R0.2-204-g8f343a4]
15.09 18:11:27 [Server] INFO at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:181) [spigot.jar:git-Spigot-1.7.9-R0.2-204-g8f343a4]
15.09 18:11:27 [Server] INFO at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44) [spigot.jar:git-Spigot-1.7.9-R0.2-204-g8f343a4]
15.09 18:11:27 [Server] INFO at ru.tehkode.permissions.bukkit.PermissionsEx.onCommand(PermissionsEx.java:304) [PermissionsEx.jar:?]
15.09 18:11:27 [Server] INFO at ru.tehkode.permissions.commands.CommandsManager.execute(CommandsManager.java:110) [PermissionsEx.jar:?]
15.09 18:11:27 [Server] INFO at ru.tehkode.permissions.commands.CommandsManager$CommandBinding.call(CommandsManager.java:248) [PermissionsEx.jar:?]
15.09 18:11:27 [Server] INFO at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_55]
15.09 18:11:27 [Server] INFO at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.7.0_55]
15.09 18:11:27 [Server] INFO at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[?:1.7.0_55]
15.09 18:11:27 [Server] INFO at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.7.0_55]
15.09 18:11:27 [Server] INFO at ru.tehkode.permissions.bukkit.commands.UtilityCommands.setBackend(UtilityCommands.java:132) [PermissionsEx.jar:?]
15.09 18:11:27 [Server] INFO at ru.tehkode.permissions.PermissionManager.setBackend(PermissionManager.java:606) ~[PermissionsEx.jar:?]
15.09 18:11:27 [Server] INFO at ru.tehkode.permissions.PermissionManager.createBackend(PermissionManager.java:624) ~[PermissionsEx.jar:?]
15.09 18:11:27 [Server] INFO at ru.tehkode.permissions.backends.PermissionBackend.getBackend(PermissionBackend.java:367) ~[PermissionsEx.jar:?]
15.09 18:11:27 [Server] INFO at ru.tehkode.permissions.backends.PermissionBackend.getBackend(PermissionBackend.java:392) ~[PermissionsEx.jar:?]
15.09 18:11:27 [Server] INFO at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[?:1.7.0_55]
15.09 18:11:27 [Server] INFO at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.7.0_55]
15.09 18:11:27 [Server] INFO at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[?:1.7.0_55]
15.09 18:11:27 [Server] INFO at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.7.0_55]
15.09 18:11:27 [Server] INFO at ru.tehkode.permissions.backends.sql.SQLBackend.<init>(SQLBackend.java:189) ~[PermissionsEx.jar:?]
15.09 18:11:27 [Server] INFO at ru.tehkode.permissions.backends.sql.SQLBackend.deployTables(SQLBackend.java:357) ~[PermissionsEx.jar:?]
15.09 18:11:27 [Server] INFO ru.tehkode.permissions.exceptions.PermissionBackendException: Deploying of default data failed. Please initialize database manually using mysql.sql
15.09 18:11:27 [Server] INFO [18:11:27 WARN]: [PermissionsEx] Backend initialization failed when CONSOLE was initializing sql
15.09 18:11:27 [Server] INFO Error (see console for more): Deploying of default data failed. Please initialize database manually using mysql.sql
15.09 18:11:27 [Server] INFO [18:11:27 INFO]: Backend initialization failed! Fix your configuration!
15.09 18:11:27 [Server] INFO [18:11:27 INFO]: [PermissionsEx] Deploying default database scheme
15.09 18:11:27 [Server] INFO [18:11:27 INFO]: [PermissionsEx] Successfully connected to SQL database
15.09 18:11:27 [Server] INFO [18:11:27 INFO]: [PermissionsEx] Initializing sql backend

EDIT: Forgot to star out the password lol

 

same ^

 

This stacktrace comes from a Spigot server, an unsupported server mod.

 

Issue is SQL database isn't accepting the character set uft8mb4. Have to update SQL database software to 5.5.3 or higher.

 

We do not support Spigot on these forums, please take requests to the forums where you downloaded the software...