Browseable MySQL session backend

Prerequisites

First, make sure you have installed the DBD::mysql perl module.

On Debian-based distributions

apt install libdbd-mysql-perl

On Fedora-based distributions

yum install 'perl(DBD::mysql)'

Create database schema

You can find the database schema in /usr/share/lemonldap-ng/ressources/sessions.my.sql.

LemonLDAP::NG configuration

Go in the Manager and set the session module to Apache::Session::Browseable::MySQL for each session type you intend to use:

  • General parameters » Sessions » Session storage » Apache::Session module

  • General parameters » Sessions » Persistent sessions » Apache::Session module

  • CAS Service » CAS sessions module name

  • OpenID Connect Service » Sessions » Sessions module name

  • SAML2 Service » Advanced » SAML sessions module name

Then, set the following module options:

Required parameters

Name

Comment

Example

DataSource

The DBI string

dbi:mysql:database=lemonldap-ng;port=3306

UserName

The database username

lemonldapng

Password

The database password

mysuperpassword

TableName

Table name (optional)

sessions

Index

Fields to index

refer to List of fields to index by session type

Tip

We recommend adding the mysql_connect_timeout, mysql_write_timeout, and mysql_read_timeout options to the DataSource string