2022-08-27 16:12:56: ACTION[Main]: Server for gameid="capturetheflag" listening on [::]:30001.
2022-08-27 16:13:04: ACTION[Server]: IRC: Connected!
2022-08-27 16:13:10: ACTION[Server]: IRC CHAT: -!- CTF_Bot joined ##minetest-ctf
2022-08-27 16:13:11: ACTION[Server]: User Thomas-S from IRC logs in as Thomas-S
2022-08-27 16:13:11: ERROR[Server]: _missing "Thomas-S" | nil
2022-08-27 16:13:11: ACTION[Main]: Server: Shutting down
2022-08-27 16:13:11: ACTION[Main]: IRC: Disconnected.
2022-08-27 16:13:11: ERROR[Main]: ServerError: AsyncErr: Lua: Runtime error from mod 'irc' in callback environment_Step(): ...st/bin/../worlds/ctf/worldmods/servermods/sauth/init.lua:308: attempt to index a nil value
2022-08-27 16:13:11: ERROR[Main]: stack traceback:
2022-08-27 16:13:11: ERROR[Main]: 	...st/bin/../worlds/ctf/worldmods/servermods/sauth/init.lua:308: in function 'record_login'
2022-08-27 16:13:11: ERROR[Main]: 	...../worlds/ctf/worldmods/servermods/irc_commands/init.lua:163: in function 'check_host_login'
2022-08-27 16:13:11: ERROR[Main]: 	...../worlds/ctf/worldmods/servermods/irc_commands/init.lua:171: in function 'func'
2022-08-27 16:13:11: ERROR[Main]: 	/home/minetest/minetest/bin/../builtin/common/after.lua:20: in function </home/minetest/minetest/bin/../builtin/common/after.lua:5>
2022-08-27 16:13:11: ERROR[Main]: 	/home/minetest/minetest/bin/../builtin/game/register.lua:429: in function </home/minetest/minetest/bin/../builtin/game/register.lua:415>

2022-04-29 18:10:18: ERROR[Main]: ModError: Failed to load and run script from /home/minetest/mt2/bin/../mods/sauth/init.lua:
2022-04-29 18:10:18: ERROR[Main]: /home/minetest/mt2/bin/../mods/sauth/init.lua:63: attempt to perform arithmetic on field 'result' (a nil value)
2022-04-29 18:10:18: ERROR[Main]: stack traceback:
2022-04-29 18:10:18: ERROR[Main]:       /home/minetest/mt2/bin/../mods/sauth/init.lua:63: in function 'create_cache'
2022-04-29 18:10:18: ERROR[Main]:       /home/minetest/mt2/bin/../mods/sauth/init.lua:106: in main chunk

	set_password = function(name, password)
		assert(type(name) == 'string')
		assert(type(password) == 'string')
		-- get player record
		if get_record(name) == nil then
			sauth.auth_handler.create_auth(name, password)
		else
			-- if player offline, don't touch cash or crash
			if auth_table[name] == nil then
				update_password(name, password)
			else			
				update_password(name, password)
				auth_table[name].password = password
			end
		end
		return true
	end,

		-- Return password,privileges,last_login
		assert(type(name) == 'string')

		if name == nil or name == '' or name == ' ' then
			minetest.log("sauth_handler: Name was missing in call to get_auth. Rejected.")
			return nil
		end

		add_to_cache = add_to_cache or true -- Assert caching on missing param
		local r = auth_table[name]
		-- Check and load db record if reqd
		if r == nil then
			minetest.log("get_record from get_auth: "..name)
			r = get_record(name)
	  	else
		  	return auth_table[name]	-- cached copy			
	  	end
		-- Return nil on missing entry

#!/bin/env python3

# copy all auth entries from an sauth.sqlite file into an existing
# (but empty) auth.sqlite from minetest's normal sqlite3 auth backend

# You'll need an auth.sqlite file from just any minetest world. This
# script will delete all the entries from it. Or you can manually create
# an empty auth.sqlite.

# sauth has a small bug where there may be duplicate `name` entries in the
# auth table, and this script works around them with a `try: except:`
# block. Otherwise it's a very straight copy over of auth and privileges.

# make sure to edit `world.mt` after this runs to assure `auth_backend = sqlite3`
# and `load_mod_sauth = false`

import sqlite3
import sys

try:
    from_name = sys.argv[1]
    to_name = sys.argv[2]
except:
    print("Usage: $0 from_db.sqlite3 to_db.sqlite3")
    exit();

try:
    from_db = sqlite3.connect(from_name)
except:
    print("$1 must be the path to sauth.sqlite3")
    exit();

try:
    to_db = sqlite3.connect(to_name)
except:
    print("$2 must be the path to auth.sqlite3")
    exit();


print("This program will import all auth entries from " + from_name)
print("and import them into " + to_name + ".")
print("to do this, it has to delete all the entries in " + to_name)
print("if you don't want this, press ^C now")

input("Press Enter to continue...")

from_cur = from_db.cursor()
to_cur = to_db.cursor()

print("Deleting all content from " + to_name)
to_cur.execute("delete from auth;")
to_db.commit()
to_cur.execute("delete from user_privileges;")
to_db.commit()

count = 0
last_id = 0

print("Copying entries...")
for row in from_cur.execute("SELECT id, name, password, privileges, last_login FROM auth;"):
    count += 1
    if count % 100 == 0:
        print(count)

    last_id = row[0]

    try:
        to_cur.execute("INSERT INTO auth (id, name, password, last_login) VALUES ("
                       + str(row[0]) + ", \"" + row[1] + "\", \"" + row[2] + "\", "
                       + str(row[4]) + ");")
        to_db.commit()
    except:
        print("An error occured for id " + str(row[0]) + " - skipping")
        continue

    try:
        for priv in row[3].replace(" ", "").split(","):
            to_cur.execute("INSERT INTO user_privileges (id, privilege) VALUES ("
                           + str(row[0]) + ", \"" + priv + "\");")
            to_db.commit()
    except:
        print("An error occured for id " + str(row[0]) + " - skipping")
        continue

print(str(count) + " records written, last id = " + str(last_id)) 

# end
from_db.close()
to_db.commit()
to_db.close()