Help with White-List issue. Images Inside.

[JayT]

Hey folks, so I am trying to set up a whitelisted PZ server I plan to host on my Dell T130 from home.

I want the server to be white-listed as it's going to be for me and co-workers primarily, plus some close friends.

Here is my servertest.ini

 

Quote

nightlengthmodifier=1.0
PVP=true
PauseEmpty=true
GlobalChat=false
Open=false
ServerWelcomeMessage= <RGB:1,0,0> Welcome to PZ RP! to chat locally press 't'.<LINE>Type '/help' to have a list of available commands<LINE>PLEASE REMAIN IN CHARACTER AT ALL TIMES! <RGB:1,1,1>
LogLocalChat=false
AutoCreateUserInWhiteList=false
DisplayUserName=false
SpawnPoint=0,0,0
SafetySystem=false
ShowSafety=false
SafetyToggleTimer=2
SafetyCooldownTimer=3
SpawnItems=
DefaultPort=16261
ResetID=844003742
Mods=
Map=Muldraugh, KY
DoLuaChecksum=true
Public=false
PublicName=PZRP
PublicDescription=The PZ RP Server.
MaxPlayers=20
PingFrequency=10
PingLimit=320
HoursForLootRespawn=48
MaxItemsForLootRespawn=1
ConstructionPreventsLootRespawn=true
DropOffWhiteListAfterDeath=false
NoFire=false
AnnounceDeath=false
MinutesPerPage=1.0
SaveWorldEveryMinutes=60
PlayerSafehouse=false
AdminSafehouse=false
SafehouseAllowTrepass=true
SafehouseAllowFire=true
SafehouseAllowLoot=true
SafehouseAllowRespawn=false
SafehouseDaySurvivedToClaim=0
SafeHouseRemovalTime=144
AllowDestructionBySledgehammer=true
KickFastPlayers=false
ServerPlayerID=367353935
RCONPort=27015
RCONPassword=
Password=
MaxAccountsPerUser=1
SleepAllowed=true
SleepNeeded=true
SteamPort1=8766
SteamPort2=8767
WorkshopItems=
SteamScoreboard=true
SteamVAC=true
UPnP=true
UPnPLeaseTime=86400
UPnPZeroLeaseTimeFallback=true
UPnPForce=true
CoopServerLaunchTimeout=20
CoopMasterPingTimeout=60
VoiceEnable=false
VoiceComplexity=5
VoicePeriod=20
VoiceSampleRate=24000
VoiceBuffering=8000
VoiceMinDistance=1.0
VoiceMaxDistance=50.0
Voice3D=true
PhysicsDelay=500
SpeedLimit=50.0
server_browser_announced_ip=
UseTCPForMapDownloads=false
PlayerRespawnWithSelf=false
PlayerRespawnWithOther=false
FastForwardMultiplier=40.0
PlayerSaveOnDamage=true
SaveTransactionID=false
DisableSafehouseWhenPlayerConnected=false
Faction=true
FactionDaySurvivedToCreate=0
FactionPlayersRequiredForTag=1
AllowTradeUI=true
HoursForWorldItemRemoval=0.0
WorldItemRemovalList=Base.Vest,Base.Shirt,Base.Blouse,Base.Skirt,Base.Shoes
ItemRemovalListBlacklistToggle=false
DisableRadioStaff=false
DisableRadioAdmin=true
DisableRadioGM=true
DisableRadioOverseer=false
DisableRadioModerator=false
DisableRadioInvisible=true
ClientCommandFilter=-vehicle.*;+vehicle.damageWindow;+vehicle.fixPart;+vehicle.installPart;+vehicle.uninstallPart
ItemNumbersLimitPerContainer=0

 

 

So following instructions I found elsewhere, I learned the whitelist is inside the servertest.db. So I downloaded SQLlite Administrator and attempted to make some edit's to my servers whitelist.

 

I attempted to make two test users, and the defualt admin user was already inside, I just changed the passphrase for testing.

 

When I attempt to connect, I see the following.

 

 

Upon clicking JOIN SERVER I get the following response.

 

 

 

I am undoubtedly sure I typed the password correctly. It does this for all accounts I created via the db for the white-list.

 

Quote

 

1535587066661 znet: New connection
1535587066661 znet: Java_zombie_core_raknet_RakNetPeerInterface_GetClientSteamID

1535587066662 [VOICE MANAGER] VoiceConnectAccept uuid=824158937928291466
1535587066710 znet: Java_zombie_core_raknet_RakNetPeerInterface_getIPFromGUID
1535587066711 znet: Java_zombie_core_raknet_RakNetPeerInterface_GetClientSteamID

1535587066711 znet: Java_zombie_core_raknet_RakNetPeerInterface_GetClientOwnerSt
eamID
User admin is trying to connect.
1535587066713 znet: Java_zombie_core_raknet_RakNetPeerInterface_disconnect
1535587066787 znet: Connection closed: reason=1 port=1
1535587066787 znet: Disconnecting client #0 SteamID=76561198026523892
1535587066788 [VOICE MANAGER] VoiceConnectClose uuid=824158937928291466
1535587066788 znet: Java_zombie_core_raknet_RakVoice_CloseVoiceChannel
1535587067011 znet: OnValidateAuthTicketResponse response=6 SteamID=765611980265
23892
1535587069815 znet: Finally disconnected client 76561198026523892

 

 

 

I tried greping for that OnValidateAuthTicketResponse but didn't find anything useful to me, nothing I could make sense of.

Any help is good help. Thanks.

[EnigmaGrey]

The passwords are encrypted, so it's now looking for a password that hashes to, say, 123. 

 

Just delete 'em and let your friends/co-workers log on to those username accounts. Any password they enter will then be saved into the whitelist.

 

You can also skip sqliteadmin by using the command

 

/addusertowhitelist "username"

 

in the chat box. Or, leave off the / to enter it in the server's console.

[Enoahe]

Hey, JayT!

 

I've never been able to login as 'admin' user myself. Maybe this is supposed to be this way? You still can create another special user, give him admin access level and use as an admin account only. 

[EnigmaGrey]

3 hours ago, Enoahe said:

Hey, JayT!

 

I've never been able to login as 'admin' user myself. Maybe this is supposed to be this way? You still can create another special user, give him admin access level and use as an admin account only. 

Have you tried just deleting the database? The server then just prompts you for a new password.

 

This only happens with dedicated servers, though. Hosting through the game won't give you this.

[Enoahe]

On 17.10.2018 at 3:39 AM, EnigmaGrey said:

Have you tried just deleting the database?

Well... thank you for a hint. Apparently, game stores md5 from passwords, so you can change it like this:

 

1. Generate new password. If you have issues with imagination, you can generate it like this:

cat /dev/urandom | tr -dc 'a-zA-Z2-9' | fold -w 18  | head -1

2. Generate md5 hash from your password:

 echo -n 'newpassword' | md5sum

3. Replace old hash with a new one in the database:

sqlite3 ~/Zomboid/db/servername.db
sqlite> update whitelist set password='yournewhash' where username='yourusername';
^D

Now I have access to 'admin' account.

[EnigmaGrey]

Linux is magical.

 

Think we're going to bcrypt in the IWBUMS build, so not sure if that'll prove more difficult. Just a heads up in case something breaks.