Use of MySQL for session storage
MySQL configuration
Remark: we advice to create a specific user/password in MySQL for LemonLDAP::NG, with rights on its database.Database creation
For example, create the database "lemonldapng" :
# mysqladmin create lemonldapng
Session table
If you want to use Apache::Session::MySQL, you can create the database like this:
CREATE TABLE sessions (
id char(32),
a_session blob
);
LemonLDAP::NG configuration
Go to the Manager and go in General Parameters > Session Storage. Then change Apache::Session module to "Apache::Session::MySQL" and in Apache::Session parameters configure the following options:- DataSource (for example: DBI:mysql:database=lemonldapng;host=127.0.0.1)
- UserName
- Password
- TableName
- LockDataSource
- LockUserName
- LockPassword
globalStorage => "Apache::Session::MySQL", globalStorageOptions => { DataSource => "dbi:mysql:database=lemonldapng;host=127.0.0.1", UserName => "db_user", Password => "db_password", TableName => "sessions", LockDataSource => "dbi:mysql:database=lemonldapng;host=127.0.0.1", LockUserName => "db_user", LockPassword => "db_password", },