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