Full_Name: Thomas Fazekas Version: 2.4.44 OS: raspbian URL: ftp://ftp.openldap.org/incoming/ Submission from: (NULL) (213.181.38.213)
My system info : Linux berry 4.4.34+ #930 Wed Nov 23 15:12:30 GMT 2016 armv6l GNU/Linux (raspberry pi 3 with latest raspbian) openldap 2.4.44 built from sources : "./configure --prefix=/opt/openldap-2.4.44 --enable-sql" Mysql deployed from repository : 5.5.54-0+deb8u1 (Raspbian)
followed the mysql specific README from the rdbms sources folder (created the db, schema & test data)
Now, when I try to start-up the server I get :
58e33726 backend_startup_one: starting "dc=berry,dc=office,dc=company,dc=com" 58e33726 ==>backsql_db_open(): testing RDBMS connection 58e33726 backsql_db_open(): concat func not specified (use "concat_pattern" directive in slapd.conf) 58e33726 backsql_db_open(): children search SQL condition not specified (use "children_cond" directive in slapd.conf); preparing default 58e33726 backsql_db_open(): setting "ldap_entries.dn LIKE CONCAT('%,',?)" as default "children_cond" 58e33726 backsql_db_open(): DN match search SQL condition not specified (use "dn_match_cond" directive in slapd.conf); preparing default 58e33726 backsql_db_open(): setting "ldap_entries.dn=?" as default "dn_match_cond" 58e33726 backsql_db_open(): objectclass mapping SQL statement not specified (use "oc_query" directive in slapd.conf) 58e33726 backsql_db_open(): setting "SELECT id,name,keytbl,keycol,create_proc,delete_proc,expect_return FROM ldap_oc_mappings" by default 58e33726 backsql_db_open(): attribute mapping SQL statement not specified (use "at_query" directive in slapd.conf) 58e33726 backsql_db_open(): setting "SELECT name,sel_expr,from_tbls,join_where,add_proc,delete_proc,param_order,expect_return,sel_expr_u FROM ldap_attr_mappings WHERE oc_map_id=?" by default 58e33726 backsql_db_open(): entry deletion SQL statement not specified (use "delentry_stmt" directive in slapd.conf) 58e33726 backsql_db_open(): setting "DELETE FROM ldap_entries WHERE id=?" by default 58e33726 backsql_db_open(): entry deletion SQL statement not specified (use "renentry_stmt" directive in slapd.conf) 58e33726 backsql_db_open(): setting "UPDATE ldap_entries SET dn=?,parent=?,keyval=? WHERE id=?" by default 58e33726 backsql_db_open(): objclasses deletion SQL statement not specified (use "delobjclasses_stmt" directive in slapd.conf) 58e33726 backsql_db_open(): setting "DELETE FROM ldap_entry_objclasses WHERE entry_id=?" by default 58e33726 ==>backsql_get_db_conn() 58e33726 ==>backsql_open_db_handle() 58e33726 <==backsql_open_db_handle() 58e33726 <==backsql_get_db_conn() 58e33726 ==>backsql_load_schema_map() 58e33726 backsql_load_schema_map(): oc_query "SELECT id,name,keytbl,keycol,create_proc,delete_proc,expect_return FROM ldap_oc_mappings" 58e33726 objectClass: id="1" name="inetOrgPerson" keytbl="persons" keycol="id" create_proc="" create_keyval="" delete_proc="" expect_return="0"create_hint="" 58e33726 backsql_load_schema_map(): objectClass "inetOrgPerson": keytbl="persons" keycol="id" 58e33726 expect_return: add=0, del=0; attributes: 58e33726 objectClass: id="2" name="documenterson" keytbl="documents" keycol="id" create_proc="" create_keyval="" delete_proc="" expect_return="0"create_hint="" 58e33726 backsql_load_schema_map(): objectClass "documenterson" is not defined in schema 58e33726 backsql_db_open(): schema mapping failed, exiting 58e33726 backend_startup_one (type=sql, suffix="dc=berry,dc=office,dc=company,dc=com"): bi_db_open failed! (1) 58e33726 slapd shutdown: initiated 58e33726 ==>backsql_db_close() 58e33726 <==backsql_db_close() 58e33726 slapd destroy: freeing system resources.
My related DB content : mysql> select * from ldap_oc_mappings; +----+---------------+------------+--------+-------------+-------------+---------------+ | id | name | keytbl | keycol | create_proc | delete_proc | expect_return | +----+---------------+------------+--------+-------------+-------------+---------------+ | 1 | inetOrgPerson | persons | id | NULL | NULL | 0 | | 2 | document | documents | id | NULL | NULL | 0 | | 3 | organization | institutes | id | NULL | NULL | 0 | | 4 | referral | referrals | id | NULL | NULL | 0 | +----+---------------+------------+--------+-------------+-------------+---------------+ 4 rows in set (0.00 sec)
Now, as far as I can tell what is happening is that when loading the schema the first one (inetOrgPerson) is being overwritten by the second (document) without a terminator, ending up with an "documenterson" which obviously doesn't exist.