Back to mods
FabricSQLWhitelister project artwork

CurseForge · Minecraft mod

FabricSQLWhitelister

Overrides vanilla whitelist.json with a MySQL database.

Choose a version Pick your version below, then grab the matching file.

Quick answer

Which FabricSQLWhitelister release should I use?

Updated 4 years ago
Latest stable file 1.18-v1.0.0
Game version 1.18, 1.18.1-pre1, 1.18.1-rc1
Loader Fabric

FabricSQLWhitelister 1.18-v1.0.0 targets 1.18, 1.18.1-pre1, 1.18.1-rc1 with Fabric. The project page does not say whether this file belongs on the client, dedicated server, or both. No extra mods listed for this file.

Where it goes

Is FabricSQLWhitelister required on the client, server, or both?

The project page does not say whether this file belongs on the client, dedicated server, or both.

Client Source doesn’t say
Dedicated server Source doesn’t say
Loader for this release Fabric
Required install it here Optional supported, not mandatory Not supported do not install here Source doesn’t say do not assume

The source does not explicitly classify this release as client-only or server-only.

What else does FabricSQLWhitelister 1.18-v1.0.0 need?

1.18-v1.0.0. Change the file and its required mods may change too.

No extra mods listed for this file

This file does not list any required mods. Do not add a library just because a different file uses it.

This file does not list any required or optional mods.

Before you install it

Add FabricSQLWhitelister without breaking your instance.

Built for FabricSQLWhitelister 1.18-v1.0.0. Pick another file and the loader, install side or required mods may change.

  1. 01

    Stick to this file

    Use 1.18-v1.0.0. It targets 1.18, 1.18.1-pre1, 1.18.1-rc1 with Fabric; another release may have different loader, side or dependency requirements.

  2. 02

    Bring the mods it needs

    This file does not list any required mods. Do not add a library just because a different file uses it.

  3. 03

    Put it on the correct side

    The project page does not say whether this file belongs on the client, dedicated server, or both.

  4. 04

    Pick the file you checked

    Use the “Get this file” button beside 1.18-v1.0.0. It opens that exact file at the source.

About this project

What does FabricSQLWhitelister add?

FabricSQLWhitelister

This is a mod intended to override the whitelist.json by instead using a MySQL database.

How to use

You will need:

  • Fabric API
  • The latest version of FabricSQLWhitelister
  • Fabric Loader version >=0.12.8 (I may backport in the future when I have time to add LTS for 1.16.5 & 1.17.1)
  • Minecraft 1.18.*

Instructions

  1. Boot the server up with the mod installed. This may result in a crash, but that is expected.
  2. Navigate to the whitelist.toml that was generated, and add in your MySQL database logins.
  3. In server.properties, set white-list= to true.
  4. You should be good to go! Reboot your server, and if all is well it'll start successfully.
  5. Add and remove players via the /whitelist add <player> and /whitelist remove <player> commands.

Notes

  • At present, this overrides the ability for opped players to bypass the whitelist, although I may change this in a future patch.
  • I have only tested this with a MariaDB server, but should hopefully work on any other conventional MySQL server.
  • If you would like to write your own application to work in conjunction with this mod, it should be known that UUIDs are stored dehyphenated. This is because Mojang's REST api doesn't store the hyphenated player UUIDs, which make it hard to develop other apps to allow integration.

Project description from CurseForge.

Pick your setup

FabricSQLWhitelister by Minecraft version and loader

Choose the version and loader you play, then open the matching release.

4 available setups

Check the dependencies, then try the file in a copied instance before changing a world you care about.

Recent files

FabricSQLWhitelister versions and loaders

1 of 1 releases match

Looking for an older file? The official CurseForge project page is in Resources.