RE: ldap-backend-sql

["suresh" <suresh@mithi.com>]

Hi
thanx for yur reply
I got the sample scripts and ran them,I am also using the same slapd.conf(is
it ok?)
but now the slapd comes out after throwing connection busy error
This is the debug

Again,thanx for yur reply
Suresh
Mithi.com Pvt. Ltd.
------------------------------------------
Send and receive mail in Indian languages
Register free at http://www.mailjol.com

____________________________________________________________________________
___________________________________
bash-2.03# /usr/local/libexec/slapd -f slapd.conf.sql -d 1
@(#) $OpenLDAP: slapd 2.0.7-Release (Thu Nov 23 13:58:38 CST 2000) $
        root@qmailjol:/install/openldap-2.0.7/servers/slapd
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=demo
==>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 directive in slapd.conf)
backsql_db_open(): setting 'SELECT
name,sel_expr,from_tbls,join_where,add_proc,delete_proc,param_order,expect_r
eturn FROM ldap_attr_mappings WHERE oc_map_id=?' by default
backsql_db_open(): entry insertion SQL statement not specified (use
insentry_query 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_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: SQLConnect() succeeded with info:
Return code: 1
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(): objectclass 'inetorgperson': keytbl='persons' keycol='id'
create_proc='{call create_person(?)}' delete_proc='{call delete_person(?)}'
expect_return=0; attributes:
load_schema_map(): autoadding 'objectClass' and 'ref' mappings
load_schema_map(): error executing at_query:
Return code: -1
Native error code: 0
SQL engine state: S1000
Message: [unixODBC][Microsoft][ODBC SQL Server Driver]Connection is busy
with results for another hstmt
<==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()
==>free_oc(): 'inetorgperson'
==>free_attr(): 'ref'
<==free_attr()
==>free_attr(): 'objectClass'
<==free_attr()
<==free_oc()
<==destroy_schema_map()
<==backsql_db_destroy()
slapd stopped.
connections_destroy: nothing to destroy.
bash-2.03#

-----Original Message-----
From: mitya@samovaar.dot.ru [mailto:mitya@samovaar.dot.ru]On Behalf Of
Dmitry Kovalev
Sent: Monday, November 27, 2000 9:13 AM
To: suresh
Subject: Re: ldap-backend-sql


suresh wrote:

> Hello
>
> I cant any sample database .Can yu tell me which folder they are located
in
>
> Suresh
> Mithi.com Pvt. Ltd.

see servers/slapd/back-sql/rdbms_depend