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#