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

RE: openLDAP + Oracle



Hi All,

I managed to get openLDAP 2.1 talk to Oracle9i!!..but I see some errors
in the log..I am guessing this is probably due to a schema mapping
mismatch..Has anyone seen this problem bfore in 8i?

Mar 28 21:19:40 localhost slapd[16687]: backsql_db_open(): setting
'DELETE FROM ldap_entries WHERE id=?' by default 
Mar 28 21:19:40 localhost slapd[16687]: ==>backsql_get_db_conn() 
Mar 28 21:19:40 localhost slapd[16687]: ==>backsql_open_db_conn() 
Mar 28 21:19:40 localhost slapd[16687]: backsql_open_db_conn():
connected, adding to tree 
Mar 28 21:19:40 localhost slapd[16687]: <==backsql_open_db_conn() 
Mar 28 21:19:40 localhost slapd[16687]: backsql_get_db_conn(): first
call -- reading schema map 
Mar 28 21:19:40 localhost slapd[16687]: ==>load_schema_map() 
Mar 28 21:19:40 localhost slapd[16687]: ldapinfo.dn_ru field exists in
the schema 
Mar 28 21:19:40 localhost slapd[16687]: load_schema_map(): at_query
'SELECT
name,sel_expr,from_tbls,join_where,add_proc,delete_proc,param_order,expe
ct_return,sel_expr_u FROM ldap_attr_mappings WHERE oc_map_id=?' 
Mar 28 21:19:40 localhost slapd[16687]: load_schema_map(): objectClass
'person': keytbl='persons' keycol='id' 
Mar 28 21:19:40 localhost slapd[16687]: create_proc='{call
create_person(?)}' 
Mar 28 21:19:40 localhost slapd[16687]: delete_proc='{call
delete_person(?)}' 
Mar 28 21:19:40 localhost slapd[16687]: expect_return: add=0, del=0;
attributes: 
Mar 28 21:19:40 localhost slapd[16687]: load_schema_map(): autoadding
'objectClass' and 'ref' mappings 
Mar 28 21:19:40 localhost slapd[16687]: ********'cn' 
Mar 28 21:19:40 localhost slapd[16687]:
name='cn',sel_expr='persons.name' from='persons'
Mar 28 21:19:40 localhost slapd[16687]: join_where='',add_proc='{call
set_person_name(?,?)}'
Mar 28 21:19:40 localhost slapd[16687]: delete_proc='' 
Mar 28 21:19:40 localhost slapd[16687]: sel_expr_u='' 
Mar 28 21:19:40 localhost slapd[16687]: load_schema_map():
preconstructed query 'SELECT persons.name AS cn FROM persons WHERE
persons.id=?' 
Mar 28 21:19:40 localhost slapd[16687]: ********'telephoneNumber' 
Mar 28 21:19:40 localhost slapd[16687]:
name='telephoneNumber',sel_expr='phones.phone' from='persons,phones'
Mar 28 21:19:40 localhost slapd[16687]:
join_where='phones.pers_id=persons.id',add_proc='{call add_phone(?,?)}'
Mar 28 21:19:40 localhost slapd[16687]: delete_proc='{call
delete_phone(?,?)}' 
Mar 28 21:19:40 localhost slapd[16687]: sel_expr_u='' 
Mar 28 21:19:40 localhost slapd[16687]: load_schema_map():
preconstructed query 'SELECT phones.phone AS telephoneNumber FROM
persons,phones WHERE persons.id=? AND phones.pers_id=persons.id' 
Mar 28 21:19:40 localhost slapd[16687]: ********'sn' 
Mar 28 21:19:40 localhost slapd[16687]:
name='sn',sel_expr='persons.name' from='persons'
Mar 28 21:19:40 localhost slapd[16687]:
join_where='phones.pers_id=persons.id',add_proc='{call
set_person_name(?,?)}'
Mar 28 21:19:40 localhost slapd[16687]: delete_proc='{call
delete_phone(?,?)}' 
Mar 28 21:19:40 localhost slapd[16687]: sel_expr_u='' 
Mar 28 21:19:40 localhost slapd[16687]: load_schema_map():
preconstructed query 'SELECT persons.name AS sn FROM persons WHERE
persons.id=?' 
Mar 28 21:19:40 localhost slapd[16687]: ********'documentDN' 
Mar 28 21:19:40 localhost slapd[16687]:
name='documentDN',sel_expr='ldap_entries.dn'
from='ldap_entries,documents,authors_docs,persons'
Mar 28 21:19:40 localhost slapd[16687]:
join_where='ldap_entries.keyval=documents.id AND
ldap_entries.oc_map_id=2 AND authors_docs.doc_id=documents.id AND
authors_docs.pers_id=persons.id',add_proc='{?=call make_doc_link(?,?)}'
Mar 28 21:19:40 localhost slapd[16687]: delete_proc='{?=call
del_doc_link(?,?)}' 
Mar 28 21:19:40 localhost slapd[16687]: sel_expr_u='' 
Mar 28 21:19:40 localhost slapd[16687]: load_schema_map(): attribute
'documentDN' for objectClass 'person' is not defined in schema:
attribute type undefined 
Mar 28 21:19:40 localhost slapd[16687]: ==>backsql_free_db_conn() 
Mar 28 21:19:40 localhost slapd[16687]: backsql_free_db_conn(): closing
db connection 
Mar 28 21:19:40 localhost slapd[16687]: ==>backsql_close_db_conn() 
Mar 28 21:19:40 localhost slapd[16687]: <==backsql_close_db_conn() 
Mar 28 21:19:40 localhost slapd[16687]: <==backsql_free_db_conn() 
Mar 28 21:19:40 localhost slapd[16687]: backsql_db_open(): connection
failed, exiting 
Mar 28 21:19:40 localhost slapd[16687]: backend_startup: bi_db_open(0)
failed! (1) 
Mar 28 21:19:40 localhost slapd[16687]: slapd shutdown: initiated 
Mar 28 21:19:40 localhost slapd[16687]: ==>backsql_db_close() 
Mar 28 21:19:40 localhost slapd[16687]: <==backsql_db_close() 
Mar 28 21:19:40 localhost slapd[16687]: slapd shutdown: freeing system
resources. 
Mar 28 21:19:40 localhost slapd[16687]: ==>backsql_db_destroy() 
Mar 28 21:19:40 localhost slapd[16687]: ==>backsql_free_db_env() 
Mar 28 21:19:40 localhost slapd[16687]: <==backsql_free_db_env() 
Mar 28 21:19:40 localhost slapd[16687]: ==>destroy_schema_map() 
Mar 28 21:19:40 localhost slapd[16687]: ==>free_oc(): 'person' 
Mar 28 21:19:40 localhost slapd[16687]: ==>free_attr(): 'objectClass' 
Mar 28 21:19:40 localhost slapd[16687]: <==free_attr() 
Mar 28 21:19:40 localhost slapd[16687]: ==>free_attr(): 'cn' 
Mar 28 21:19:40 localhost slapd[16687]: <==free_attr() 
Mar 28 21:19:40 localhost slapd[16687]: ==>free_attr():
'telephoneNumber' 
Mar 28 21:19:40 localhost slapd[16687]: <==free_attr() 
Mar 28 21:19:40 localhost slapd[16687]: ==>free_attr(): 'sn' 
Mar 28 21:19:40 localhost slapd[16687]: <==free_attr() 
Mar 28 21:19:40 localhost slapd[16687]: ==>free_attr(): 'ref' 
Mar 28 21:19:40 localhost slapd[16687]: <==free_attr() 
Mar 28 21:19:40 localhost slapd[16687]: <==free_oc() 
Mar 28 21:19:40 localhost slapd[16687]: <==destroy_schema_map() 
Mar 28 21:19:41 localhost slapd[16687]: <==backsql_db_destroy() 
Mar 28 21:19:41 localhost slapd[16687]: slapd stopped. 
Mar 28 21:19:41 localhost slapd[16687]: connections_destroy: nothing to
destroy. 

Any ideas??

Thanks
Ravi