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

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