search

HoshiKurama / TicketManager

Minecraft plugin designed to implement a ticketing system
GNU Affero General Public License v3.0
16 stars 5 forks source link

MySQL Configuration #23

Closed earthmutant closed 2 years ago

earthmutant commented 2 years ago

Hi, when I configure this plugin to use my MySQL server I get console spam saying "too many connections". I increased the max_connections value on my MySQL server to 1024 and the plugin was bringing in more connections than that as well. The other 3 plugins I have connected to my database only use 15 connections combined 2022-08-28-23.log .

HoshiKurama commented 2 years ago

Hi! I'm terribly sorry you're experiencing this issue~

Sadly, TicketManager does not support the newer 'caching_sha2_password` authentication method for MySQL 8.0+. This is a current limitation with the library used for connections.

The current fix is to change your default authentication method to mysql_native_password or use a MySQL version between 5.5.3 and 5.7.37. There's a guide for how to change your authentication method in the Discord server. However, if you don't wish to join, this guide might help.