[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