(ITS#8437) openldap-2.4.44 slapd.conf: back-sql database parameters, only first character

[piero.astolfi@gmx.com]

Full_Name: Piero Astolfi
Version: openldap-2.4.44
OS: CentOS Linux release 7.1.1503 (Core)
URL: ftp://ftp.openldap.org/incoming/
Submission from: (NULL) (151.1.178.237)


I compiled openldap-2.4.44 enabling the sql backend and configured
slapd.conf accordingly, however slapd fails to start.

It seems that only the first character of the database parameters are used.
After changing the username and the password in my DB to a single character
I can successfully connect to the DB but every sql query fails.

As you can see in my /var/lib/mysql/server_audit.log the query
"SELECT id,name,keytbl,keycol,create_proc,delete_proc,expect_return FROM
ldap_oc_mappings"
results in the single character "S", the same happens to the username
"ldap_user" that results in the single character "l".

Do you have any suggestions on how to proceed?

# cat /usr/local/etc/openldap/slapd.conf
[...]
database sql
dbname          ldap_dbname
dbuser          ldap_user
dbpasswd        ldap_password


# /usr/local/libexec/slapd -d Any -f /usr/local/etc/openldap/slapd.conf
[...]
57581a99 ==>backsql_get_db_conn()
57581a99 ==>backsql_open_db_handle()
57581a9%3<==backsql_open_db_handle()
57581a99 <==backsql_get_db_conn()
57581a99 ==>backsql_load_schema_map()
57581a99 backsql_load_schema_map(): oc_query "SELECT
id,name,keytbl,keycol,create_proc,delete_proc,expect_return FROM
ldap_oc_mappings"
57581a99 backsql_load_schema_map(): error executing oc_query:
57581a99 Return code: -1
57581a99    nativeErrCode=1064 SQLengineState=&#65533;&#65533;&#65533; msg=""
57581a99 backsql_db_open(): schema mapping failed, exiting
57581a99 backend_startup_one (type=sql, suffix="dc=addrbook,dc=clr"): bi_db_open
failed! (1)
57581a99 slapd shutdown: initiated
57581a99 ==>backsql_db_close()
57581a99 <==backsql_db_close()
57581a99 slapd destroy: freeing system resources.
57581a99 ==>backsql_close_db_handle(0x20445f0)
57581a99 <==backsql_close_db_handle(0x20445f0)
57581a99 ==>backsql_db_destroy()
57581a99 ==>backsql_free_db_env()
57581a99 <==backsql_free_db_env()
57581a99 ==>destroy_schema_map()
57581a99 <==destroy_schema_map()
57581a99 <==backsql_db_destroy()
57581a99 slapd stopped.
 

# tail -f /var/lib/mysql/server_audit.log
20160608 15:58:08,cleared_hostname,l,localhost,688,0,CONNECT,,,0
20160608 15:58:08,cleared_hostname,l,localhost,688,3786,QUERY,,'SET NAMES
utf8',0
20160608 15:58:08,cleared_hostname,l,localhost,688,3787,QUERY,,'SET
character_set_results = NULL',0
20160608 15:58:08,cleared_hostname,l,localhost,688,3788,QUERY,,'SET
SQL_AUTO_IS_NULL = 0',0
20160608 15:58:08,cleared_hostname,l,localhost,688,3789,QUERY,,'SET
AUTOCOMMIT=0',0
20160608 15:58:08,cleared_hostname,l,localhost,688,3790,QUERY,,'set
@@sql_select_limit=DEFAULT',0
20160608 15:58:08,cleared_hostname,l,localhost,688,3791,QUERY,,'S',1064 <<<<<<<<
RIGHT HERE <<<<<<<<
20160608 15:58:08,cleared_hostname,l,localhost,68873792,QUERY,,'ROLLBACK',0
20160608 15:58:08,cleared_hostname,l,localhost,688,0,DISCONNECT,,,0