How to setup whitelist in Project Zomboid

 

This guide will show you how to setup a project zomboid white list so you can have a private server.

 

This might seem difficult to setup however once you're set up its pretty easy to manage.

The server will look in your zomboid database folder (/server/Zomboid/db) for a database file, this has the name of your service id.

 

For example: ( 101.db ) with username / passwords to authorize people trying to connect to your server.

Firstly Stop your server and download 101.db to your PC.

Next, download this program we have hosted for this purpose here: Download (It's for editing file based sql [sqlite specifically] databases.)

Open SQLite Admin, and open your 101.db in it.

Go into Tables, click whitelist, expand it out and click a random field (say id)

Then click the Edit Data tab, and you can put data in. 

 

Here is an example of data fields, world refers to your database name.

 

All you need to do to add a user is click the + icon, and then (in order) put your database file name e.g. if it's 101.db put 101 into the 'world' column, then add a username and password into their respective columns. Close the database once you've made your changes and it'll auto save. 
Upload the modified file onto the server to replace the existing one

Now edit the server configuration and set "Open" setting to "false". Save

Start server.