when i do this the slapd would not come up :(.
slapd startup: initiated.
bdb_db_open: dc=my,dc=hosting
bdb_db_open: dbenv_open(/var/lib/openldap-data)
==>backsql_db_open(): testing RDBMS connection
backsql_db_open(): concat func not specified (use "concat_pattern"
directive in slapd.conf)
backsql_db_open(): setting 'ldap_entries.dn=?' as default
backsql_db_open(): objectclass mapping SQL statement not specified (use
"oc_query" directive in slapd.conf)
backsql_db_open(): setting 'SELECT
id,name,keytbl,keycol,create_proc,delete_proc,expect_return FROM
ldap_oc_mappings' by default
backsql_db_open(): attribute mapping SQL statement not specified (use
"at_query" directive in slapd.conf)
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
backsql_db_open(): entry deletion SQL statement not specified (use
"delentry_query" directive in slapd.conf)
backsql_db_open(): setting 'DELETE FROM ldap_entries WHERE id=?' by
default ==>backsql_get_db_conn()
==>backsql_open_db_conn()
backsql_open_db_conn(): connected, adding to tree
<==backsql_open_db_conn()
backsql_get_db_conn(): first call -- reading schema map
==>load_schema_map()
ldapinfo.dn_ru field exists in the schema
load_schema_map(): at_query '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=?'
load_schema_map(): objectClass 'inetOrgPerson': keytbl='persons'
keycol='id' create_proc='insert into persons (name) values ('');
select last_insert_id();'
expect_return: add=0, del=0; attributes:
load_schema_map(): autoadding 'objectClass' and 'ref' mappings
load_schema_map(): error executing at_query:
Return code: -1
Native error code: 1054
SQL engine state: S0022
Message: [unixODBC][MySQL][ODBC 3.51 Driver][mysqld-4.0.16]Unknown
column 'sel_expr_u' in 'field list'
Because metadata in the test is no longer aligned
with the code; "mysql" test data is not actively
maintained, basically because I had no time to
set up a mysql and test it. The only rdbms I
actively etsted and maintained is postgres. From
what I infer, you don't have any sql data to present
in LDAP form, so you don't really need mysql, you
can live with postgres as well; or you can update
mysql examples according to postgres' ones (and
sumbit a patch via ITS :)
ok, i the slapd-sql now and i think it's clear now. i use the BerkeleyDB
for working and the copy the informations the sql that i need :).
than it works but not with the testdb.
This is a bit unclear. If all you need is LDAP,
then why use back-sql? for fun? Otherwise, if you
need SQL, why load it via back-sql? again, for fun?