search

games647 / FlexibleLogin

A Sponge minecraft server plugin for second factor authentication
https://forums.spongepowered.org/t/8872
MIT License
87 stars 22 forks source link

MySQL / MariaDB #104

Closed fmohican closed 6 years ago

fmohican commented 6 years ago

Hi! I use your plugin on my server, i setup mariadb, but the plugin isn't use... There its console error and the config https://gist.github.com/fmohican/af6bb4eb435b41140f7ae15f0e4ede3b

games647 commented 6 years ago

Just put MySQL in there. MariaDB is backwards compatible to MySQL

fmohican commented 6 years ago

Yes i know that, but you in config but separately MariaDB & MySQL, i will change to mysql and i will reply you back.

games647 commented 6 years ago

That comment will be fixed in the next version to make it more clear.

fmohican commented 6 years ago

Thanks you ! now the plugin work fine. But why UUID and IP are stored as Binary Data ? prove

games647 commented 6 years ago

The thought was that this is smaller and so reduces the size of the database and improve performance of indices.

For example UUIDs only have a width of 2 64 bits (long) = 128 bits. If you store it as a fixed string the size would be 36 (UUID without dashes) 16 bits (UTF-8) = 576 bits, but now I think it's unnecessary.

fmohican commented 6 years ago

Well thanks you for making clear about mySQL / mariadb. Thanks for support.

On Thu, 1 Mar 2018, 09:53 games647, notifications@github.com wrote:

Closed #104 https://github.com/games647/FlexibleLogin/issues/104.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/games647/FlexibleLogin/issues/104#event-1498414263, or mute the thread https://github.com/notifications/unsubscribe-auth/AIL4lXIFloYIT8KD1Y0T1mqLtx11-auoks5tZ6jxgaJpZM4SXAEp .