Issue for new installation
Hello,
I am testing to install lemonldap 2.0.6 as new installation in CentOS7. I followed the instruction and it install. However, it doesn't start apache when I configure to use RDBI by following this instruction: https://lemonldap-ng.org/documentation/2.0/sqlconfbackend
The database is the Mariadb 10.4.8 with following configuration:
[mysql]
# CLIENT #
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
# GENERAL #
user = mysql
default-storage-engine = InnoDB
socket = /var/lib/mysql/mysql.sock
pid-file = /var/lib/mysql/mysqld.pid
# MyISAM #
# key-buffer-size = 32M
# myisam-recover = FORCE,BACKUP
# SAFETY #
max-allowed-packet = 256M
max-connect-errors = 1000000
skip-name-resolve
sql-mode = NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER
sysdate-is-now = 1
innodb-strict-mode = 1
# DATA STORAGE #
datadir = /var/lib/mysql
# SERVER ID #
server-id = 1
# BINARY LOGGING #
log-bin
# CACHES AND LIMITS #
max-connections = 500
tmp-table-size = 32M
max-heap-table-size = 32M
query-cache-type = 0
query-cache-size = 0
thread-cache-size = 50
open-files-limit = 65535
table-definition-cache = 1024
table-open-cache = 2048
# INNODB #
innodb-flush-method = O_DIRECT
innodb-log-files-in-group = 2
innodb-log-file-size = 768M
innodb-flush-log-at-trx-commit = 1
innodb-file-per-table = 1
innodb-buffer-pool-size = 1536M
# LOGGING #
log-error = /var/lib/mysql/mysqld.log
slow-query-log = 1
slow-query-log-file = /var/lib/mysql/mysqld-slow.log
log-queries-not-using-indexes = OFF
long_query_time = 30
since it doesn't allow to do dash for the database name, it change it to lemonldap-ng.
Here is what I set in the /etc/lemonldap-ng/lemonldap-ng.ini
[configuration]
; confTimeout: maximum time to get configuration (default 10)
;confTimeout = 5
; GLOBAL CONFIGURATION ACCESS TYPE
; (File, REST, SOAP, RDBI/CDBI, LDAP, YAMLFile)
; Set here the parameters needed to access to LemonLDAP::NG configuration.
; You have to set "type" to one of the followings :
;
; * File/YAMLFile: you have to set 'dirName' parameter. Example:
;
; type = File ; or type = YAMLFile
type = File
dirName = /var/lib/lemonldap-ng/conf
;
; * RDBI/CDBI : you have to set 'dbiChain' (required) and 'dbiUser' and 'dbiPassword'
; if needed. Example:
;
type = RDBI
; ;type = CDBI
dbiChain = DBI:MariaDB:database=lemonldap_ng;host=localhost
dbiUser = <username>
dbiPassword = <password>
dbiTable = lmConfig
The error is
[Tue Oct 22 16:34:31.605705 2019] [perl:error] [pid 3327] Lemonldap::NG::Handler::ApacheMP2::Main : unable to build configuration: Error: configStorage: type is not well formed.\nError: Unknown package Lemonldap::NG::Common::Conf::Backends::File\nRDBI\nFile.\nCompilation failed in require at /usr/share/perl5/vendor_perl/Lemonldap/NG/Handler/ApacheMP2.pm line 9.\nBEGIN failed--compilation aborted at /usr/share/perl5/vendor_perl/Lemonldap/NG/Handler/ApacheMP2.pm line 9.\nCompilation failed in require at (eval 2) line 2.\n
[Tue Oct 22 16:34:31.605768 2019] [perl:error] [pid 3327] Can't load Perl module Lemonldap::NG::Handler::ApacheMP2 for server <url>:0, exiting...
Did I miss to install something? I did yum install perl-DBD-MySQL
Thanks