[Date Prev][Date Next] [Chronological] [Thread] [Top]

Re: sql-backend



Pierangelo Masarati wrote:

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?



no, i just want flexiblity for auth. there are always people who only knows *sql.

p.





--
-----------------------------------
Otto Kucera
A-1020 Wien Engerthstrasse 137/6/7
Tel: +43 699 1 942 30 91 [neue Nummer!]
Email: ok@72pixel.at
Icq: 65351173
-----------------------------------

And root said rm -rf /     ......and there was nothing
*BSD is like a wigwam: NO windows, NO gates and an Apache inside!

Your mailserver MUST resolve properly (Fully Qualified Domain Name) or the
mail will not go through!