Describe the bug
Okey, I am attempting to connect to my database MYSQL, but this have a ERROR, I dont undestand why dont can connect, the database is good, but the plugin is creating me bugs!
To Reproduce
This is my config of Bungee:
useUUIDs: false
useregexperms: false
grouppermission: true
backendtype: MySQL2
uuidplayerdb: MySQL
tablePrefix: bp_
uuidfetcher:
cooldown: 3000
saveAllUsers: true
deleteUsersOnCleanup: true
notify:
promote: false
demote: false
tabcomplete: true
locale: en-GB
terminate:
prefix:
reset: true
space: true
suffix:
reset: true
space: true
cleanup:
interval: 1800
threshold: 600
async-commands: true
networktype: Global
networkservers:
14:16:38 [INFO] [BungeePerms] Deactivating BungeePerms ...
14:16:38 [INFO] [BungeePerms] Connecting to database
14:16:38 [SEVERE] Thu Jul 11 14:16:38 EDT 2019 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
14:16:39 [INFO] [BungeePerms] Connecting to database
14:16:39 [SEVERE] Thu Jul 11 14:16:39 EDT 2019 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
14:16:41 [INFO] [BungeePerms] loading permissions ...
14:16:41 [SEVERE] java.lang.RuntimeException: java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column 'S0yoCbFbpD.bp_permissions2.id' which is not in SELECT list; this is incompatible with DISTINCT
14:16:41 [SEVERE] at net.alpenblock.bungeeperms.Mysql.returnQuery(Mysql.java:252)
14:16:41 [SEVERE] at net.alpenblock.bungeeperms.Mysql.returnQuery(Mysql.java:111)
14:16:41 [SEVERE] at net.alpenblock.bungeeperms.io.mysql2.MysqlPermsAdapter2.getGroups(MysqlPermsAdapter2.java:63)
14:16:41 [SEVERE] at net.alpenblock.bungeeperms.io.MySQL2BackEnd.loadGroups(MySQL2BackEnd.java:71)
14:16:41 [SEVERE] at net.alpenblock.bungeeperms.PermissionsManager.loadPerms(PermissionsManager.java:115)
14:16:41 [SEVERE] at net.alpenblock.bungeeperms.PermissionsManager.reload(PermissionsManager.java:208)
14:16:41 [SEVERE] at net.alpenblock.bungeeperms.BungeePerms.reload(BungeePerms.java:106)
14:16:41 [SEVERE] at net.alpenblock.bungeeperms.CommandHandler.handleReload(CommandHandler.java:150)
14:16:41 [SEVERE] at net.alpenblock.bungeeperms.CommandHandler.onCommand(CommandHandler.java:55)
14:16:41 [SEVERE] at net.alpenblock.bungeeperms.platform.bungee.BungeePlugin.onCommand(BungeePlugin.java:84)
14:16:41 [SEVERE] at net.alpenblock.bungeeperms.platform.bungee.BungeePlugin$1$1.run(BungeePlugin.java:100)
14:16:41 [SEVERE] at net.md_5.bungee.scheduler.BungeeTask.run(BungeeTask.java:63)
14:16:41 [SEVERE] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
14:16:41 [SEVERE] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
14:16:41 [SEVERE] at java.lang.Thread.run(Thread.java:748)
14:16:41 [SEVERE] Caused by: java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column 'S0yoCbFbpD.bp_permissions2.id' which is not in SELECT list; this is incompatible with DISTINCT
14:16:41 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
14:16:41 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
14:16:41 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
14:16:41 [SEVERE] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
14:16:41 [SEVERE] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
14:16:41 [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495)
14:16:41 [SEVERE] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903)
14:16:41 [SEVERE] at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2011)
14:16:41 [SEVERE] at net.alpenblock.bungeeperms.Mysql.returnQuery(Mysql.java:248)
14:16:41 [SEVERE] ... 14 more
Additional context
Sorry for my bad english xd! I dont understand good! and plis help me!
Describe the bug Okey, I am attempting to connect to my database MYSQL, but this have a ERROR, I dont undestand why dont can connect, the database is good, but the plugin is creating me bugs!
To Reproduce This is my config of Bungee: useUUIDs: false useregexperms: false grouppermission: true backendtype: MySQL2 uuidplayerdb: MySQL tablePrefix: bp_ uuidfetcher: cooldown: 3000 saveAllUsers: true deleteUsersOnCleanup: true notify: promote: false demote: false tabcomplete: true locale: en-GB terminate: prefix: reset: true space: true suffix: reset: true space: true cleanup: interval: 1800 threshold: 600 async-commands: true networktype: Global networkservers:
Expected behavior This can be for the SSL!?
Screenshots or log
Additional context Sorry for my bad english xd! I dont understand good! and plis help me!