ldap-back-sql

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

Hello
I have succesfully tested ldap with gdbm backend.I am trying to run the
samples of ldap-back-sql
when i try to run a add ,i get this error.
Probably i have not created a particular table.Can any body please help
me.This is tha cammand i used

bash-2.03# ldapadd -D "cn=root, o=sql, c=RU" -h localhost -p 389 -w
secret -f test-ordered.ldif
adding new entry o=sql, c=RU
ldap_add_s: Unknown error


Can yu tell me what this means.On second thought i have included the debug
info.I belive this is not a sql prob.

Thanx in advance

____________________________________________________________________________
_____________________
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 (slapd.conf.sql line 31): unknown directive 'index'
(ignored)
slapd startup: initiated.
==>backsql_db_open(): testing RDBMS connection
backsql_db_open(): subtree search SQL condition not specified (use
subtree_cond directive in slapd.conf)
backsql_db_open(): setting 'ldap_entries.dn LIKE CONCAT('%',?)' as default
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()
<==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 succeeded, schema map loaded
slapd starting
connection_get(8): got connid=0
connection_read(8): checking for input on id=0
ber_get_next
ber_get_next: tag 0x30 len 38 contents:
ber_get_next
ber_get_next on fd 8 failed errno=11 (Resource temporarily unavailable)
do_bind
ber_scanf fmt ({iat) ber:
ber_scanf fmt (o}) ber:
do_bind: version=3 dn="cn=root, o=sql, c=RU" method=128
==>backsql_bind()
<==backsql_bind() root bind
do_bind: v3 bind: "cn=root, o=sql, c=RU" to "cn=root,o=sql,c=RU"
send_ldap_result: conn=0 op=0 p=3
send_ldap_response: msgid=1 tag=97 err=0
ber_flush: 14 bytes to sd 8
connection_get(8): got connid=0
connection_read(8): checking for input on id=0
ber_get_next
ber_get_next: tag 0x30 len 345 contents:
ber_get_next
ber_get_next on fd 8 failed errno=11 (Resource temporarily unavailable)
do_add
ber_scanf fmt ({a) ber:
ber_scanf fmt ({a{V}}) ber:
ber_scanf fmt ({a{V}}) ber:
ber_scanf fmt ({a{V}}) ber:
ber_scanf fmt ({a{V}}) ber:
ber_scanf fmt ({a{V}}) ber:
ber_scanf fmt ({a{V}}) ber:
ber_scanf fmt ({a{V}}) ber:
ber_scanf fmt ({a{V}}) ber:
ber_scanf fmt (}) ber:
==>backsql_add(): adding entry 'o=sql, c=RU'
backsql_add(): cannot determine objectclass of entry -- aborting
send_ldap_result: conn=0 op=1 p=3
send_ldap_response: msgid=2 tag=105 err=80
ber_flush: 31 bytes to sd 8
connection_get(8): got connid=0
connection_read(8): checking for input on id=0
ber_get_next
ber_get_next: tag 0x30 len 5 contents:
ber_get_next
ber_get_next on fd 8 failed errno=0 (Error 0)
connection_read(8): input error=-2 id=0, closing.
connection_closing: readying conn=0 sd=8 for close
connection_close: deferring conn=0 sd=8
do_unbind
==>backsql_unbind()
send_ldap_result: conn=0 op=2 p=3
send_ldap_response: msgid=0 tag=48 err=0
<==backsql_unbind()
connection_resched: attempting closing conn=0 sd=8
connection_close: conn=0 sd=8
==>backsql_connection_destroy()
==>backsql_free_db_conn()
<==backsql_free_db_conn()
<==backsql_connection_destroy()
____________________________________________________________________________
_____________________



Suresh
Mithi.com Pvt. Ltd.
------------------------------------------
Send and receive mail in Indian languages
Register free at http://www.mailjol.com