AdvancedBan icon indicating copy to clipboard operation
AdvancedBan copied to clipboard

i Can't connect to database

Open chettestwef opened this issue 3 years ago • 1 comments
trafficstars

What version of AdvancedBan (/AdvancedBan) are you using? [01:00:13 INFO]: Dev • Leoko [01:00:13 INFO]: Status • Stable [01:00:13 INFO]: Version • 2.3.0 [01:00:13 INFO]: License • Public [01:00:13 INFO]: Storage • MySQL (external) [01:00:13 INFO]: Server • Spigot/Bukkit [01:00:13 INFO]: UUID-Mode • DISABLED What kind of server do you have (Bungeecord/single server)? git-Spigot-db6de12-18fbb24 (MC: 1.8.8) What server version (/version) are you using? This server is running CraftBukkit version git-Spigot-db6de12-18fbb24 (MC: 1.8.8) (Implementing API version 1.8.8-R0.1-SNAPSHOT) Please provide the EXACT steps required to reproduce the problem...

  1. set config.yml
  2. restart server
  3. connect to database fail
  4. HikariPool-1 - Error thrown while acquiring connection from data source java.sql.SQLException: Unknown system variable 'tx_isolation'

Any error/log post it through pastebin.com and link it here. (Also include /plugins/AdvancedBan/logs/latest.log) this the my server log: latest (37).log

Add any additional information below.

chettestwef avatar Sep 23 '22 17:09 chettestwef

Hello! This is often caused by Minecraft <1.8.9 not having the required MySQL libraries from spigot itself. You'll either need to install a substitute plugin that does provide these or update your server to at least 1.8.9 or 1.9. You will otherwise not be able to use the MySQL feature within AdvancedBan.

Hopefuls avatar Nov 26 '22 11:11 Hopefuls