This guide covers all the available environment variables to fine-tune OpenLIT UI according to your needs.

Environment Varibales

INIT_DB_HOST
required

Sets the host address of the ClickHouse server for OpenLIT UI to connect

Example:

export INIT_DB_HOST=127.0.0.1
INIT_DB_PORT
required

Sets the port on which ClickHouse listens

Example:

export INIT_DB_PORT=8123
INIT_DB_DATABASE
required

Sets the name of the database in Clickhouse to be used by OpenLIT UI

Example:

export INIT_DB_DATABASE=default
INIT_DB_USERNAME
required

Sets the username for authenticating with ClickHouse

Example:

export INIT_DB_USERNAME=default
INIT_DB_PASSWORD
required

Sets the password for authenticating with ClickHouse

Example:

export INIT_DB_PASSWORD=default
SQLITE_DATABASE_URL
required

Sets the location where SQLITE data is stored.

Example:

export SQLITE_DATABASE_URL=file:/app/client/data/data.db

Sample Environment File (.env)

.env
INIT_DB_HOST="127.0.0.1"
INIT_DB_PORT="8123"
INIT_DB_DATABASE="default"
INIT_DB_USERNAME="default"
INIT_DB_PASSWORD="OPENLIT"
SQLITE_DATABASE_URL="file:/app/client/data/data.db"