Setup a sqlite database

You create the database file with the included script and place it in a proper directory.

1. create a directory for holding the database file. Sqlite needs write access to both the database file and the directory for insertions

   mkdir /var/db/greylite
   chown qmaild:qmaild /var/db/greylite
   

2. create the actual db file in this directory with the script present in the greylite package:

   sqlite -init scripts/greylite-sqlite.sql /var/db/greylite/greylite.db
   

Done.

Placing the database file in other directories is possible, you have to reflect these changes into the control file for tcpserver.

Control variables

You will need the following environment variables for this database configuration:

DBFILE="/var/db/greylite/greylite.db"

See greylite controls for more information.