SQL configuration backends
There is 2 types of SQL configuration backends for LemonLDAP::NG:
- CDBI: very simple storage (recommended)
- RDBI: triple store storage
You can use any database engine if it provides a Perl Driver. You will find here examples for MySQL and PostgreSQL, but other engines may also work.
MySQL
Perl Driver
You need DBD::MySQL Perl module:
- Debian:
apt install libdbd-mysql-perl
- Red Hat:
yum install perl-DBD-MySQL
Database and table creation
Create database:
CREATE DATABASE lemonldap-ng CHARACTER SET utf8;
Use database to create table:
USE lemonldap-ng
RDBI
CREATE TABLE lmConfig ( cfgNum INT(11) NOT NULL, FIELD VARCHAR(255) NOT NULL DEFAULT '', VALUE longtext, PRIMARY KEY (cfgNum,FIELD) );
CDBI
CREATE TABLE lmConfig ( cfgNum INT NOT NULL PRIMARY KEY, DATA longtext );
Grant access
You have to grant read/write access for the manager component. Other components needs just a read access. You can also use the same user for all.
You can use different dbiUser strings:
- one with read/write rights for servers hosting the manager
- one with just read rights for other servers
For example (suppose that our servers are in 10.0.0.0/24 network):
GRANT SELECT,INSERT,UPDATE,DELETE,LOCK TABLES ON lemonldap-ng.lmConfig TO lemonldaprw@manager.host IDENTIFIED BY 'mypassword'; GRANT SELECT ON lemonldap-ng.lmConfig TO lemonldapro@'10.0.0.%' IDENTIFIED BY 'myotherpassword';
Connection settings
Change configuration settings in /etc/lemonldap-ng/lemonldap-ng.ini
file (section configuration):
[configuration] type = RDBI dbiChain = DBI:mysql:database=lemonldap-ng;host=1.2.3.4 dbiUser = lemonldaprw dbiPassword = mypassword ; optional dbiTable = mytablename
PostGreSQL
Perl Driver
You need DBD::Pg Perl module:
- Debian:
apt install libdbd-pg-perl
- Red Hat:
yum install perl-DBD-Pg
Database and table creation
Create database:
CREATE DATABASE lemonldap-ng;
Use database to create table:
USE lemonldap-ng
RDBI
CREATE TABLE lmconfig ( cfgnum INTEGER NOT NULL, FIELD text NOT NULL, VALUE text, PRIMARY KEY (cfgNum,FIELD) );
CDBI
CREATE TABLE lmConfig ( cfgnum INTEGER NOT NULL PRIMARY KEY, DATA text );
Connection settings
Change configuration settings in /etc/lemonldap-ng/lemonldap-ng.ini
file (section configuration):
[configuration] type = RDBI dbiChain = DBI:Pg:database=lemonldap-ng;host=1.2.3.4 dbiUser = lemonldaprw dbiPassword = mypassword ; optional dbiTable = mytablename