Re: sql-backend

["Pierangelo Masarati" <ando@sys-net.it>]

> 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?

p.

-- 
Pierangelo Masarati
mailto:pierangelo.masarati@sys-net.it