prosím o pomoc při napojení pex na MySQL ,config.yml:
Kód: Vybrat vše
permissions:
basedir: plugins/PermissionsEx
backend: sql
backends:
sql:
driver: mysql
uri: mysql://localhost/164136_mysql_db
user: 164136_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: false
Konzole:
Spoiler: zobrazit
Kód: Vybrat vše
[11:16:31] [Server thread/INFO]: [PermissionsEx] Enabling PermissionsEx v1.22.5
[11:16:31] [Server thread/INFO]: [PermissionsEx] Initializing sql backend
[11:16:31] [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:117) ~[PermissionsEx.jar:?]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.7.0_60]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[?:1.7.0_60]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.7.0_60]
at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[?:1.7.0_60]
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-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:324) [minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:404) [minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at org.bukkit.craftbukkit.v1_7_R4.CraftServer.loadPlugin(CraftServer.java:455) [minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at org.bukkit.craftbukkit.v1_7_R4.CraftServer.enablePlugins(CraftServer.java:389) [minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at net.minecraft.server.v1_7_R4.MinecraftServer.n(MinecraftServer.java:352) [minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at net.minecraft.server.v1_7_R4.MinecraftServer.g(MinecraftServer.java:326) [minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at net.minecraft.server.v1_7_R4.MinecraftServer.a(MinecraftServer.java:282) [minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at net.minecraft.server.v1_7_R4.DedicatedServer.init(DedicatedServer.java:189) [minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at net.minecraft.server.v1_7_R4.MinecraftServer.run(MinecraftServer.java:436) [minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at net.minecraft.server.v1_7_R4.ThreadServerApplication.run(SourceFile:628) [minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
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_60]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[?:1.7.0_60]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.7.0_60]
at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[?:1.7.0_60]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116) ~[minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343) ~[minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334) ~[minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371) ~[minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163) ~[minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) ~[minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.7.0_60]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[?:1.7.0_60]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.7.0_60]
at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[?:1.7.0_60]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378) ~[minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) ~[minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at ru.tehkode.libs.org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) ~[PermissionsEx.jar:?]
at ru.tehkode.libs.org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) ~[PermissionsEx.jar:?]
at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) ~[PermissionsEx.jar:?]
at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ~[PermissionsEx.jar:?]
at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) ~[PermissionsEx.jar:?]
at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) ~[PermissionsEx.jar:?]
at ru.tehkode.permissions.backends.sql.SQLBackend.getSQL(SQLBackend.java:239) ~[PermissionsEx.jar:?]
at ru.tehkode.permissions.backends.sql.SQLBackend.<init>(SQLBackend.java:111) ~[PermissionsEx.jar:?]
... 22 more
Caused by: java.net.UnknownHostException: 164136_mysql_db: Name or service not known
at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method) ~[?:1.7.0_60]
at java.net.InetAddress$1.lookupAllHostAddr(InetAddress.java:901) ~[?:1.7.0_60]
at java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1293) ~[?:1.7.0_60]
at java.net.InetAddress.getAllByName0(InetAddress.java:1246) ~[?:1.7.0_60]
at java.net.InetAddress.getAllByName(InetAddress.java:1162) ~[?:1.7.0_60]
at java.net.InetAddress.getAllByName(InetAddress.java:1098) ~[?:1.7.0_60]
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:244) ~[minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292) ~[minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334) ~[minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371) ~[minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163) ~[minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) ~[minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.7.0_60]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[?:1.7.0_60]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.7.0_60]
at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[?:1.7.0_60]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378) ~[minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) ~[minecraft_server.jar:git-Bukkit-1.7.9-R0.2-24-g07d4558-b3116jnks]
at ru.tehkode.libs.org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) ~[PermissionsEx.jar:?]
at ru.tehkode.libs.org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) ~[PermissionsEx.jar:?]
at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) ~[PermissionsEx.jar:?]
at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ~[PermissionsEx.jar:?]
at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) ~[PermissionsEx.jar:?]
at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) ~[PermissionsEx.jar:?]
at ru.tehkode.permissions.backends.sql.SQLBackend.getSQL(SQLBackend.java:239) ~[PermissionsEx.jar:?]
at ru.tehkode.permissions.backends.sql.SQLBackend.<init>(SQLBackend.java:111) ~[PermissionsEx.jar:?]
... 22 more
[11:16:31] [Server thread/INFO]: [PermissionsEx] Disabling PermissionsEx v1.22.5
[11:16:31] [Server thread/INFO]: WEPIF: Using the Bukkit Permissions API.
[11:16:31] [Server thread/INFO]: WEPIF: Using the Bukkit Permissions API.
[11:16:31] [Server thread/INFO]: [Vault][Permission] PermissionsEx hooked.
