Help s napojením permissionsEx na mysql
Napsal: 20 bře 2015, 16:30
Čau lidi, potřeboval bych pomoct s napojením permissionsEX na mysql. Config mám nestavenej . V consoli to napíše že se v pohodě připojil na mysql ,ale potom to vypíše chybu:
Můj config:
Server: 93.91.250.159:27402
Kód: Vybrat vše
> [15:27:06 INFO]: [PermissionsEx] Enabling PermissionsEx v1.22.5
> [15:27:06 INFO]: [PermissionsEx] Initializing sql backend
> [15:27:06 INFO]: [PermissionsEx] Successfully connected to SQL database
> [15:27:06 INFO]: [PermissionsEx] Deploying default database scheme
> [15:27:06 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:420) ~[PermissionsEx.jar:?]
at ru.tehkode.permissions.backends.sql.SQLBackend.<init>(SQLBackend.java:193) ~[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:392) ~[PermissionsEx.jar:?]
at ru.tehkode.permissions.backends.PermissionBackend.getBackend(PermissionBackend.java:367) ~[PermissionsEx.jar:?]
at ru.tehkode.permissions.PermissionManager.createBackend(PermissionManager.java:624) ~[PermissionsEx.jar:?]
at ru.tehkode.permissions.PermissionManager.setBackend(PermissionManager.java:606) ~[PermissionsEx.jar:?]
at ru.tehkode.permissions.PermissionManager.initBackend(PermissionManager.java:684) ~[PermissionsEx.jar:?]
at ru.tehkode.permissions.PermissionManager.<init>(PermissionManager.java:67) ~[PermissionsEx.jar:?]
at ru.tehkode.permissions.bukkit.PermissionsEx.onEnable(PermissionsEx.java:164) [PermissionsEx.jar:?]
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:316) [minecraft_server.jar:git-Spigot-1646]
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:332) [minecraft_server.jar:git-Spigot-1646]
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:417) [minecraft_server.jar:git-Spigot-1646]
at org.bukkit.craftbukkit.v1_7_R4.CraftServer.loadPlugin(CraftServer.java:476) [minecraft_server.jar:git-Spigot-1646]
at org.bukkit.craftbukkit.v1_7_R4.CraftServer.enablePlugins(CraftServer.java:394) [minecraft_server.jar:git-Spigot-1646]
at org.bukkit.craftbukkit.v1_7_R4.CraftServer.reload(CraftServer.java:866) [minecraft_server.jar:git-Spigot-1646]
at org.bukkit.Bukkit.reload(Bukkit.java:301) [minecraft_server.jar:git-Spigot-1646]
at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:23) [minecraft_server.jar:git-Spigot-1646]
at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:181) [minecraft_server.jar:git-Spigot-1646]
at org.bukkit.craftbukkit.v1_7_R4.CraftServer.dispatchCommand(CraftServer.java:767) [minecraft_server.jar:git-Spigot-1646]
at org.bukkit.craftbukkit.v1_7_R4.CraftServer.dispatchServerCommand(CraftServer.java:753) [minecraft_server.jar:git-Spigot-1646]
at net.minecraft.server.v1_7_R4.DedicatedServer.aB(DedicatedServer.java:326) [minecraft_server.jar:git-Spigot-1646]
at net.minecraft.server.v1_7_R4.DedicatedServer.v(DedicatedServer.java:290) [minecraft_server.jar:git-Spigot-1646]
at net.minecraft.server.v1_7_R4.MinecraftServer.u(MinecraftServer.java:584) [minecraft_server.jar:git-Spigot-1646]
at net.minecraft.server.v1_7_R4.MinecraftServer.run(MinecraftServer.java:490) [minecraft_server.jar:git-Spigot-1646]
at net.minecraft.server.v1_7_R4.ThreadServerApplication.run(SourceFile:628) [minecraft_server.jar:git-Spigot-1646]
Caused by: java.sql.BatchUpdateException: Unknown character set: 'utf8mb4'
at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1065) ~[minecraft_server.jar:git-Spigot-1646]
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:402) ~[PermissionsEx.jar:?]
at ru.tehkode.permissions.backends.sql.SQLBackend.deployTables(SQLBackend.java:417) ~[PermissionsEx.jar:?]
... 28 more
> [15:27:06 INFO]: [PermissionsEx] Disabling PermissionsEx v1.22.5Můj config:
Kód: Vybrat vše
permissions:
basedir: plugins/PermissionsEx
backend: sql
backends:
sql:
driver: mysql
uri: mysql://93.91.250.209:3306/177996_mysql_db
user: 177996_mysql_db
password: *********
superperms:
disable-unmatched: false
enable: true
matched-permissions: true
debug: false
raw-permissions: true
strict-mode: false
parent-nodes: true
createUserRecords: false
allowOps: true
debug: falseServer: 93.91.250.159:27402
pre mna je to zložité ale potreboval by som to.