search

KitsuneLab-Development / K4-System

K4-Systems is a plugin that enhances the server with features such as a playtime tracker, statistical records, and player ranks. Additionally, it includes VIP functions and admin commands for added functionality.
GNU General Public License v3.0
104 stars 35 forks source link

[BUG] SQL Failure #200

Closed AxiomaticIntrusion closed 1 month ago

AxiomaticIntrusion commented 1 month ago

Describe the bug Set the plugin up yesterday and connected to SQL DB, was working perfectly (restarts and all worked fine), this morning after restarting the server, I was given the error that the authentication method failed and I needed to set AllowPublicKeyRetrieval to true.

Expected behavior A clear and concise description of what you expected to happen.

Logs/Screenshots Please attach logs or screenshots if available. image_2024-08-01_084242531

Environment (please complete the following information):

Additional context Add any other context about the problem here.

AxiomaticIntrusion commented 1 month ago

Recreated a new SQL server identical to yesterdays process, results in the same error.

K4ryuu commented 1 month ago

The error literally says to use secure connection. This is why the "sslmode" is added to the database section, which I bet you left on "none".

Your database is configured to allow only secure connection, so set the plugin to use it.

image

AxiomaticIntrusion commented 1 month ago

My apologies, thank you very much

K4ryuu commented 1 month ago

My apologies, thank you very much

No issues, don't worry about it! Cheers mate!