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.

See how to change configuration backend.

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