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

ldap-backend-sql



Hi
 
I am trying to configure backend-sql on ldap.(MSSQL)
i was able to succesfully install the openldap.I changed the slapd.conf (the example itself)entries for dbname,dbuser,dbpasswd
and i did a     /usr/local/libexec/slapd -d  5 and i got these results.
 
I am using easysoft odbc-odbc bridge for cross platform database access which is working well
Please help..
thanx in advance
 
suresh
 
 
 
 
bash-2.03# /usr/local/libexec/slapd -d 5
@(#) $OpenLDAP: slapd 2.0.4-Release (Tue Oct 10 17:07:13 GMT 2000) $
       
root@sunmailjol:/install/openldap-2.0.4/servers/slapd
daemon_init: <null>
daemon_init: listen on
ldap:///
daemon_init: 1 listeners to open...
ldap_url_parse(
ldap:///)
daemon: initialized
ldap:///
daemon_init: 1 listeners opened
slapd init: initiated server.
==>backsql_initialize()
<==backsql_initialize()
==>backsql_db_init()
==>backsql_init_db_env()
<==backsql_init_db_env()
<==backsql_db_init()
==>backsql_db_config()
<==backsql_db_config(): dbname=MAILDB
==>backsql_db_config()
<==backsql_db_config(): dbuser=sa
==>backsql_db_config()
<==backsql_db_config(): dbpasswd=ChalJaldi
==>backsql_db_config()
<==backsql_db_config(): subtree_cond=ldap_entries.dn LIKE '%'+?
slapd startup: initiated.
==>backsql_db_open(): testing RDBMS connection
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 d
irective in slapd.conf)
backsql_db_open(): setting 'SELECT name,sel_expr,from_tbls,join_where,add_proc,d
elete_proc,param_order,expect_return FROM ldap_attr_mappings WHERE oc_map_id=?'
by default
backsql_db_open(): entry insertion SQL statement not specified (use insentry_que
ry directive in slapd.conf)
backsql_db_open(): setting 'INSERT INTO ldap_entries (dn,oc_map_id,parent,keyval
) VALUES (?,?,?,?)' by default
backsql_db_open(): entry deletion SQL statement not specified (use delentry_quer
y 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: SQLConnect() succeeded with info:
Return code: 1
SQL engine state: IM002
Native error code: 0
Message: [unixODBC][Driver Manager]Data source name not found, and no default dr
iver specified
backsql_open_db_conn(): connected, adding to tree
<==backsql_open_db_conn()
backsql_get_db_conn(): first call -- reading schema map
==>load_schema_map()
load_schema_map(): error preparing oc_query: 'SELECT id,name,keytbl,keycol,creat
e_proc,delete_proc,expect_return FROM ldap_oc_mappings'
Return code: -1
SQL engine state: 08003
Native error code: 0
Message: [unixODBC][Driver Manager]Connnection does not exist
<==backsql_get_db_conn()
==>backsql_free_db_conn()
backsql_free_db_conn(): closing db connection
==>backsql_close_db_conn()
<==backsql_close_db_conn()
<==backsql_free_db_conn()
backsql_db_open(): test failed, schema map not loaded - exiting
backend_startup: bi_db_open 0 failed!
slapd shutdown: initiated
==>backsql_db_close()
<==backsql_db_close()
slapd shutdown: freeing system resources.
==>backsql_db_destroy()
==>backsql_free_db_env()
<==backsql_free_db_env()
==>destroy_schema_map()
<==destroy_schema_map()
<==backsql_db_destroy()
slapd stopped.
connections_destroy: nothing to destroy.
bash-2.03#