Code: [01:38:30] [Server thread/INFO]: [PermissionsEx] Enabling PermissionsEx v2.0-SNAPSHOT [01:38:30] [Server thread/INFO]: [PermissionsEx] Initializing sql backend [01:38:30] [Server thread/INFO]: [PermissionsEx] Successfully connected to SQL database [01:38:30] [Server thread/INFO]: [PermissionsEx] Deploying default database scheme [01:38:31] [Server thread/ERROR]: [PermissionsEx] ========== UNABLE TO LOAD PERMISSIONS BACKEND ========= Your configuration must be fixed before PEX will enable Details: Deploying of default data failed. Please initialize database manually using mysql.sql ======================================================= ru.tehkode.permissions.exceptions.PermissionBackendException: Deploying of default data failed. Please initialize database manually using mysql.sql at ru.tehkode.permissions.backends.sql.SQLBackend.deployTables(SQLBackend.java:342) ~[PermissionsEx.jar:?] at ru.tehkode.permissions.backends.sql.SQLBackend.<init>(SQLBackend.java:172) ~[PermissionsEx.jar:?] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.7.0_51] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[?:1.7.0_51] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.7.0_51] at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[?:1.7.0_51] at ru.tehkode.permissions.backends.PermissionBackend.getBackend(PermissionBackend.java:372) ~[PermissionsEx.jar:?] at ru.tehkode.permissions.backends.PermissionBackend.getBackend(PermissionBackend.java:347) ~[PermissionsEx.jar:?] at ru.tehkode.permissions.PermissionManager.createBackend(PermissionManager.java:604) ~[PermissionsEx.jar:?] at ru.tehkode.permissions.PermissionManager.setBackend(PermissionManager.java:586) ~[PermissionsEx.jar:?] at ru.tehkode.permissions.PermissionManager.initBackend(PermissionManager.java:663) ~[PermissionsEx.jar:?] at ru.tehkode.permissions.PermissionManager.<init>(PermissionManager.java:62) ~[PermissionsEx.jar:?] at ru.tehkode.permissions.bukkit.PermissionsEx.onEnable(PermissionsEx.java:164) [PermissionsEx.jar:?] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:316) [Spigot:git-Spigot-1543] at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:329) [Spigot:git-Spigot-1543] at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405) [Spigot:git-Spigot-1543] at org.bukkit.craftbukkit.v1_7_R3.CraftServer.loadPlugin(CraftServer.java:476) [Spigot:git-Spigot-1543] at org.bukkit.craftbukkit.v1_7_R3.CraftServer.enablePlugins(CraftServer.java:394) [Spigot:git-Spigot-1543] at net.minecraft.server.v1_7_R3.MinecraftServer.n(MinecraftServer.java:360) [Spigot:git-Spigot-1543] at net.minecraft.server.v1_7_R3.MinecraftServer.g(MinecraftServer.java:334) [Spigot:git-Spigot-1543] at net.minecraft.server.v1_7_R3.MinecraftServer.a(MinecraftServer.java:290) [Spigot:git-Spigot-1543] at net.minecraft.server.v1_7_R3.DedicatedServer.init(DedicatedServer.java:194) [Spigot:git-Spigot-1543] at net.minecraft.server.v1_7_R3.MinecraftServer.run(MinecraftServer.java:458) [Spigot:git-Spigot-1543] at net.minecraft.server.v1_7_R3.ThreadServerApplication.run(SourceFile:628) [Spigot:git-Spigot-1543] Caused by: java.sql.BatchUpdateException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*/ CREATE TABLE IF NOT EXISTS `server_permissions` ( `id` int(11) NOT NULL AU' at line 1 at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1065) ~[Spigot:git-Spigot-1543] at ru.tehkode.libs.org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) ~[PermissionsEx.jar:?] at ru.tehkode.libs.org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) ~[PermissionsEx.jar:?] at ru.tehkode.permissions.backends.sql.SQLBackend.executeStream(SQLBackend.java:321) ~[PermissionsEx.jar:?] at ru.tehkode.permissions.backends.sql.SQLBackend.deployTables(SQLBackend.java:336) ~[PermissionsEx.jar:?] ... 23 more [01:38:31] [Server thread/INFO]: [PermissionsEx] Disabling PermissionsEx v2.0-SNAPSHOT [01:38:31] [Server thread/INFO]: WEPIF: Using the Bukkit Permissions API. [01:38:31] [Server thread/INFO]: WEPIF: Using the Bukkit Permissions API. I hooked pex up to sql but when I restart the server, I run into this, anyone got a idea?
Code: multiserver: use-netevents: true permissions: debug: false allowOps: true user-add-groups-last: false log-players: false createUserRecords: false backend: sql informplayers: changes: false backends: sql: uri: mysql://localhost/pex user: root password: ********** deploy: permissions.sql aliases: permissions: server_permissions permissions_inheritance: server_inheritance permissions_entity: server_entity basedir: plugins/PermissionsEx updater: true alwaysUpdate: false Here you go jkjames6
xXMaTTHDXx Try 2 things: 1} Change your config to this permissions: basedir: plugins/PermissionsEx backend: sql backends: sql: driver: mysql uri: mysql://domain:3306/database user: username password: password superperms: {} 2} Try not using a Snapshot of the plugin, try this version: http://dev.bukkit.org/bukkit-plugins/permissionsex/files/33-permissions-ex-v1-22-1/
Code: [PermissionsEx] Initializing sql backend [15:08:21] [Server thread/INFO]: [PermissionsEx] Successfully connected to SQL database [15:08:21] [Server thread/INFO]: [PermissionsEx] Deploying default database scheme [15:08:21] [Server thread/ERROR]: [PermissionsEx] ========== UNABLE TO LOAD PERMISSIONS BACKEND ========= Your configuration must be fixed before PEX will enable Details: Deploying of default data failed. Please initialize database manually using mysql.sql ======================================================= ru.tehkode.permissions.exceptions.PermissionBackendException: Deploying of default data failed. Please initialize database manually using mysql.sql at ru.tehkode.permissions.backends.sql.SQLBackend.deployTables(SQLBackend.java:342) ~[PermissionsEx.jar:?] at ru.tehkode.permissions.backends.sql.SQLBackend.<init>(SQLBackend.java:172) ~[PermissionsEx.jar:?] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.7.0_51] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[?:1.7.0_51] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.7.0_51] at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[?:1.7.0_51] at ru.tehkode.permissions.backends.PermissionBackend.getBackend(PermissionBackend.java:372) ~[PermissionsEx.jar:?] at ru.tehkode.permissions.backends.PermissionBackend.getBackend(PermissionBackend.java:347) ~[PermissionsEx.jar:?] at ru.tehkode.permissions.PermissionManager.createBackend(PermissionManager.java:604) ~[PermissionsEx.jar:?] at ru.tehkode.permissions.PermissionManager.setBackend(PermissionManager.java:586) ~[PermissionsEx.jar:?] at ru.tehkode.permissions.PermissionManager.initBackend(PermissionManager.java:663) ~[PermissionsEx.jar:?] at ru.tehkode.permissions.PermissionManager.<init>(PermissionManager.java:62) ~[PermissionsEx.jar:?] at ru.tehkode.permissions.bukkit.PermissionsEx.onEnable(PermissionsEx.java:164) [PermissionsEx.jar:?] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:316) [Spigot:git-Spigot-1543] at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:329) [Spigot:git-Spigot-1543] at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405) [Spigot:git-Spigot-1543] at org.bukkit.craftbukkit.v1_7_R3.CraftServer.loadPlugin(CraftServer.java:476) [Spigot:git-Spigot-1543] at org.bukkit.craftbukkit.v1_7_R3.CraftServer.enablePlugins(CraftServer.java:394) [Spigot:git-Spigot-1543] at net.minecraft.server.v1_7_R3.MinecraftServer.n(MinecraftServer.java:360) [Spigot:git-Spigot-1543] at net.minecraft.server.v1_7_R3.MinecraftServer.g(MinecraftServer.java:334) [Spigot:git-Spigot-1543] at net.minecraft.server.v1_7_R3.MinecraftServer.a(MinecraftServer.java:290) [Spigot:git-Spigot-1543] at net.minecraft.server.v1_7_R3.DedicatedServer.init(DedicatedServer.java:194) [Spigot:git-Spigot-1543] at net.minecraft.server.v1_7_R3.MinecraftServer.run(MinecraftServer.java:458) [Spigot:git-Spigot-1543] at net.minecraft.server.v1_7_R3.ThreadServerApplication.run(SourceFile:628) [Spigot:git-Spigot-1543] Caused by: java.sql.BatchUpdateException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*/ CREATE TABLE IF NOT EXISTS `permissions` ( `id` int(11) NOT NULL AUTO_INCR' at line 1 at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1065) ~[Spigot:git-Spigot-1543] at ru.tehkode.libs.org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) ~[PermissionsEx.jar:?] at ru.tehkode.libs.org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) ~[PermissionsEx.jar:?] at ru.tehkode.permissions.backends.sql.SQLBackend.executeStream(SQLBackend.java:321) ~[PermissionsEx.jar:?] at ru.tehkode.permissions.backends.sql.SQLBackend.deployTables(SQLBackend.java:336) ~[PermissionsEx.jar:?] ... 23 more Still getting the error. jkjames6