Account password required trouble B42.13.1 to B42.13.2

[royal locust]

Hi everyone, i have an issu with the new whitelist system, i switch my dedicated server to new version, i see some people on redit have same probleme and patch it by using /addsteamid but that command when i write it just ask me to register a new account by using /adduser, i even try to adduser and replace the password by steamif but nothing work, if someone hva an idee that will help me a lot thx

[royal locust]

i also try to edit database networkPlayers by adding steamid direcly, but same issu

[lean spade]

https://theindiestone.com/forums/index.php?/topic/91011-whitelist-system-issues-after-update-to-unstable-42132/

you can add the steamids manually in the SQLite file with an SQLite Browser, but this cant be the solution

[royal locust]

Ty, that can be a temp good patch

[hasty egret]

this query will copy all known steamids from the old (<=42.13.1) whitelist table to the new allowedsteamid table for steamid-whitelisting all of your previous connections

SELECT DISTINCT steamid FROM whitelist WHERE whitelist.steamid IS NOT NULL AND whitelist.steamid NOT IN (
    SELECT allowedsteamid.steamid FROM 
        allowedsteamid
        INNER JOIN whitelist ON allowedsteamid.steamid=whitelist.steamid
        WHERE whitelist.steamid IS NOT NULL
);```
I really do hope they roll back this change, though

[royal locust]

tank you that will help with curently player, but that will not help if i want add newplayer in my dedicated server, i will need to stop server, edit database and start server right ?

[hasty egret]

for new players, I think the intended actions are to both whitelist the steamid and create the character. so

User username created with password
/addsteamid 123456789
SteamID 123456789 added to allowed SteamIDs```
but usernames+passwords are broken for `Open=false` servers right now, so I'm honestly not 100% sure how they meant for it to work

but from my testing, /adduser doesn't deal with numeric steamids, and /addsteamiddoesn't deal with usernames/passwords. they seem to act on separate tables in the database

here's another thread https://discord.com/channels/136501320340209664/1462809642374664255

[royal locust]

for my dedicated server command /addsteamid dosent work, that say "/adduser user password"

[hasty egret]

the help text is definitely wrong for addsteamid...seems just mistakenly copy/pasted from adduser

this definitely works for me over rcon to a test server on my lan, I haven't tried it in the game console directly

SteamID 11111111111111111 added to allowed SteamIDs```

[royal locust]

yeah but even /addsteamid 123456789 dont add steam id ... , but maybe i have done some mistake in that command

[hasty egret]

via your server hosts console, or in-game as admin, or what?

[royal locust]

in game

and with the fifo also

[hasty egret]

that might be because of another bug...are you sure you actually have admin powers when you're doing it? user roles aren't working for Open=false servers either, so even "admin" logs in without admin powers. you have to setaccesslevel username admin over rcon or console while you're logged in, and it will only last until you log out

lemme test in game

after setaccesslevel admin admin over rcon, it worked fine in game from my admin account

[lean spade]

i dont know why my bug report got moved to pz support, but it seems to be a feature not a bug.

[hasty egret]

there are definitely many bugs in the implementation, like, whitelisted servers don't check accounts passwords at all, and no accounts ever log in with elevated privileges (like, the built-in admin account doesn't log in with admin powers)--the difficulty right now is I don't think it's clear how the whitelist(s) is/are intended to work at this point, but it is definitely broken