Migration guide

[lokspel]

Download the plugin JAR from its official releases (e.g., GitHub or Spigot), start it once on a test server to generate an empty .db file, then stop the server and extract that file.

Use DB Browser for SQLite: https://sqlitebrowser.org/

Upload both your OpenLogin database (likely accounts.db) and the empty authme.db in DB Browser for SQLite, attach them, and execute this SQL command:

INSERT INTO authme ( username, realname, password, ip, regip, lastlogin, regdate ) SELECT name, realname, password, address, address, lastlogin, regdate FROM openlogin;

In AuthMe's config.yml, set hashing to BCRYPT (under settings > security > passwordHash: BCRYPT), add legacy support if needed for old passwords (search "legacy" section), and reload or restart the server.

Migration to OpenLogin from AuthMe:

INSERT INTO accounts.openlogin (name, realname, password, address, lastlogin, regdate)
SELECT username, realname, password, ip, lastlogin, regdate
FROM authme;

Migration to OpenLogin from nLogin:

INSERT INTO openlogin (name, realname, password, address, lastlogin, regdate) SELECT lower(last_name), last_name, password, last_ip, last_seen, creation_date FROM nlogin;

Migration to nLogin from OpenLogin:

In nLogin's config.yml set

    algorithm: BCRYPT2A
    
    bcrypt:
      rounds: 10

INSERT INTO nlogin (last_name, unique_id, mojang_id, bedrock_id, password, last_ip, last_seen, creation_date, email, discord)
SELECT realname, NULL, NULL, NULL, password, address, lastlogin, regdate, NULL, NULL FROM openlogin