Help with permissionsEX Formatting

Status
This thread has been locked.
Shanks

Shanks

Poggers In the Chat
Premium
Feedback score
12
Posts
450
Reactions
212
Resources
0
Hello Guys, so i have this premade permissions file for HCF and when i try to do for example /pex nothing works. When i do /pl it is red. I know for a fact that it is the way the permissions.yml is formatted because when i put an unedited permissons.yml it works fine. The only thing i need help with is formatting it correctly. Here's my startup log when i startup my server. If anyone could help this problem that would be great, thanks :).








========== 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.22.10.jar:?]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_144]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_144]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_144]
at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:1.8.0_144]
at ru.tehkode.permissions.backends.PermissionBackend.getBackend(PermissionBackend.java:392) ~[PermissionsEx-1.22.10.jar:?]
at ru.tehkode.permissions.backends.PermissionBackend.getBackend(PermissionBackend.java:367) ~[PermissionsEx-1.22.10.jar:?]
at ru.tehkode.permissions.PermissionManager.createBackend(PermissionManager.java:624) ~[PermissionsEx-1.22.10.jar:?]
at ru.tehkode.permissions.PermissionManager.setBackend(PermissionManager.java:606) ~[PermissionsEx-1.22.10.jar:?]
at ru.tehkode.permissions.PermissionManager.initBackend(PermissionManager.java:693) ~[PermissionsEx-1.22.10.jar:?]
at ru.tehkode.permissions.PermissionManager.<init>(PermissionManager.java:67) ~[PermissionsEx-1.22.10.jar:?]
at ru.tehkode.permissions.bukkit.PermissionsEx.onEnable(PermissionsEx.java:178) [PermissionsEx-1.22.10.jar:?]
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:316) [spigot.jar:git-PaperSpigot-1f7d532]
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:332) [spigot.jar:git-PaperSpigot-1f7d532]
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:412) [spigot.jar:git-PaperSpigot-1f7d532]
at org.bukkit.craftbukkit.v1_7_R4.CraftServer.loadPlugin(CraftServer.java:476) [spigot.jar:git-PaperSpigot-1f7d532]
at org.bukkit.craftbukkit.v1_7_R4.CraftServer.enablePlugins(CraftServer.java:394) [spigot.jar:git-PaperSpigot-1f7d532]
at net.minecraft.server.v1_7_R4.MinecraftServer.n(MinecraftServer.java:354) [spigot.jar:git-PaperSpigot-1f7d532]
at net.minecraft.server.v1_7_R4.MinecraftServer.g(MinecraftServer.java:328) [spigot.jar:git-PaperSpigot-1f7d532]
at net.minecraft.server.v1_7_R4.MinecraftServer.a(MinecraftServer.java:284) [spigot.jar:git-PaperSpigot-1f7d532]
at net.minecraft.server.v1_7_R4.DedicatedServer.init(DedicatedServer.java:227) [spigot.jar:git-PaperSpigot-1f7d532]
at net.minecraft.server.v1_7_R4.MinecraftServer.run(MinecraftServer.java:494) [spigot.jar:git-PaperSpigot-1f7d532]
at net.minecraft.server.v1_7_R4.ThreadServerApplication.run(SourceFile:628) [spigot.jar:git-PaperSpigot-1f7d532]
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.8.0_144]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_144]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_144]
at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:1.8.0_144]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[spigot.jar:git-PaperSpigot-1f7d532]
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116) ~[spigot.jar:git-PaperSpigot-1f7d532]
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343) ~[spigot.jar:git-PaperSpigot-1f7d532]
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334) ~[spigot.jar:git-PaperSpigot-1f7d532]
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371) ~[spigot.jar:git-PaperSpigot-1f7d532]
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163) ~[spigot.jar:git-PaperSpigot-1f7d532]
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) ~[spigot.jar:git-PaperSpigot-1f7d532]
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[spigot.jar:git-PaperSpigot-1f7d532]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_144]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_144]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_144]
at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:1.8.0_144]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[spigot.jar:git-PaperSpigot-1f7d532]
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378) ~[spigot.jar:git-PaperSpigot-1f7d532]
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) ~[spigot.jar:git-PaperSpigot-1f7d532]
at ru.tehkode.libs.org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) ~[PermissionsEx-1.22.10.jar:?]
at ru.tehkode.libs.org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) ~[PermissionsEx-1.22.10.jar:?]
at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) ~[PermissionsEx-1.22.10.jar:?]
at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ~[PermissionsEx-1.22.10.jar:?]
at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) ~[PermissionsEx-1.22.10.jar:?]
at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) ~[PermissionsEx-1.22.10.jar:?]
at ru.tehkode.permissions.backends.sql.SQLBackend.getSQL(SQLBackend.java:245) ~[PermissionsEx-1.22.10.jar:?]
at ru.tehkode.permissions.backends.sql.SQLBackend.<init>(SQLBackend.java:112) ~[PermissionsEx-1.22.10.jar:?]
... 22 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method) ~[?:1.8.0_144]
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source) ~[?:1.8.0_144]
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source) ~[?:1.8.0_144]
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source) ~[?:1.8.0_144]
at java.net.AbstractPlainSocketImpl.connect(Unknown Source) ~[?:1.8.0_144]
at java.net.PlainSocketImpl.connect(Unknown Source) ~[?:1.8.0_144]
at java.net.SocksSocketImpl.connect(Unknown Source) ~[?:1.8.0_144]
at java.net.Socket.connect(Unknown Source) ~[?:1.8.0_144]
at java.net.Socket.connect(Unknown Source) ~[?:1.8.0_144]
at java.net.Socket.<init>(Unknown Source) ~[?:1.8.0_144]
at java.net.Socket.<init>(Unknown Source) ~[?:1.8.0_144]
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:254) ~[spigot.jar:git-PaperSpigot-1f7d532]
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292) ~[spigot.jar:git-PaperSpigot-1f7d532]
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334) ~[spigot.jar:git-PaperSpigot-1f7d532]
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371) ~[spigot.jar:git-PaperSpigot-1f7d532]
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163) ~[spigot.jar:git-PaperSpigot-1f7d532]
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) ~[spigot.jar:git-PaperSpigot-1f7d532]
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[spigot.jar:git-PaperSpigot-1f7d532]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_144]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_144]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_144]
at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:1.8.0_144]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[spigot.jar:git-PaperSpigot-1f7d532]
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378) ~[spigot.jar:git-PaperSpigot-1f7d532]
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) ~[spigot.jar:git-PaperSpigot-1f7d532]
at ru.tehkode.libs.org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) ~[PermissionsEx-1.22.10.jar:?]
at ru.tehkode.libs.org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) ~[PermissionsEx-1.22.10.jar:?]
at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) ~[PermissionsEx-1.22.10.jar:?]
at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ~[PermissionsEx-1.22.10.jar:?]
at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) ~[PermissionsEx-1.22.10.jar:?]
at ru.tehkode.libs.org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) ~[PermissionsEx-1.22.10.jar:?]
at ru.tehkode.permissions.backends.sql.SQLBackend.getSQL(SQLBackend.java:245) ~[PermissionsEx-1.22.10.jar:?]
at ru.tehkode.permissions.backends.sql.SQLBackend.<init>(SQLBackend.java:112) ~[PermissionsEx-1.22.10.jar:?]
... 22 more
[11:09:08 INFO]: [PermissionsEx] Disabling PermissionsEx v1.22.10
 
Click to expand...
PebbleHost
High performance, consistent uptime and fast support. Minecraft hosting that just works.
Fawks

Fawks

Director @ Synx Games
Supreme
Feedback score
25
Posts
836
Reactions
742
Resources
0
wtfcombo said:
Details: Unable to connect to SQL database
Click to expand...

Literally the third line down man. Either your password is incorrect, your mysql firewall is setup incorrectly or you have no mysql server!
 
Shanks

Shanks

Poggers In the Chat
Premium
Feedback score
12
Posts
450
Reactions
212
Resources
0
Tesco said:
Literally the third line down man. Either your password is incorrect, your mysql firewall is setup incorrectly or you have no mysql server!
Click to expand...
I'm not very familiar with this kind of stuff. How would i setup my mysql firewall corectly?[DOUBLEPOST=1516044405][/DOUBLEPOST]
JoshSmith said:
If you look through the error you can see it is talking about SQL easily.
Click to expand...
So what would i do to fix my "SQL"
 
Last edited:
Shanks

Shanks

Poggers In the Chat
Premium
Feedback score
12
Posts
450
Reactions
212
Resources
0
Kyluxian said:
If you're saying you use a permissions.yml file, that's flatfile and not SQL. Try disabling the MySQL option in Pex's config?

If you are using MySQL, it's most likely what Fawks said above.
Click to expand...
This is my Pex's config


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:
file:
type: file
file: permissions.yml
sql:
type: sql
uri: mysql://localhost/pex
user: root
password: vkp88Tb7L1
updater: true
alwaysUpdate: false
 
Drewbo

Drewbo

BulletClub ︻╦╤─
Premium
Feedback score
2
Posts
47
Reactions
11
Resources
0
wtfcombo said:
This is my Pex's config


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:
file:
type: file
file: permissions.yml
sql:
type: sql
uri: mysql://localhost/pex
user: root
password:
updater: true
alwaysUpdate: false
Click to expand...
You're going to want to edit out your MySQL password.
 
Shanks

Shanks

Poggers In the Chat
Premium
Feedback score
12
Posts
450
Reactions
212
Resources
0
Drewbo said:
You're going to want to edit out your MySQL password.
Click to expand...
Changing to anything or is there something specific i have to change it to?[DOUBLEPOST=1516045051][/DOUBLEPOST]
Kyluxian said:
Maybe changing "backend: sql" to file?

If you want to use MySQL instead of file, I'd get someone else to help you out since I'm not too good with it. Hope I helped.
Click to expand...
Thanks it fixed the problem :)
 
Status
This thread has been locked.
Top