Product SiteDocumentation Site

Chapter 4. Initial configuration

4.1. Preparing the database
4.1.1. SQLite3
4.2. Initialising the database
4.2.1. SQLite3 database
4.3. Initialisation of eurephia
4.3.1. Password parameters
4.3.2. Setting up the eurephia administrator account
4.3.3. Session parameters
4.3.4. Failed attempts limits
4.3.5. Firewall integration
4.4. Preparing eurephiadm - eurephia command line administration utility
In this chapter we will look more into the runtime configuration of eurephia. First we will go through the initial configuration. This is needs to be done only once per server installation. You don't need to do this on the server itself, you need to have the prepared database and the eurephia_init program available. For the SQLite3 database, you will need to copy the configured database file to your OpenVPN server when the initialisation is done.

Presumptions

This chapter will presume that the SQLite3 database file is located under /etc/openvpn, that the eurephiadm utility is available via your system path and the OpenVPN plug-in and eurephia modules are found in /usr/lib/eurephia.

4.1. Preparing the database

Database support

This first release of eurephia supports only the SQLite3 database. Support for PostgreSQL and MySQL is planned in a future release.

4.1.1. SQLite3

When you install eurephia with SQLite3 support, a template database will be installed as /etc/openvpn/eurephiadb-template. This database is supposed to be empty, just containing the needed tables for eurephia to work. In this book, we will use the filename /etc/openvpn/eurephiadb as the file OpenVPN will use for the authentication process. 
user@host: ~ $ su - root
        Password: ......
        root@host: ~ # cp /etc/openvpn/eurephiadb-template /etc/openvpn/eurephiadb
        root@host: ~ # exit
        user@host: ~ $

Warning

Your production database file should use another filename than /etc/openvpn/eurephiadb-template. When upgrading eurephia the installation process will overwrite this template file, which may cause you loss of data.