Hi All,
I have configured Openldap 2.3.32 with back-sql, have followed the readme and http://www.easysoft.com/applications/openldap/back-sql-odbc.html to create test and metadata. But while performing search i am receiving following errors
ldapsearch -x -b dc=example,dc=com name=Mitya
# extended LDIF
#
# LDAPv3
# base with scope subtree
# filter: name=Mitya
# requesting: ALL
#
# search result
search: 2
result: 32 No such object
# numResponses: 1
May 25 10:23:12 ldap1p slapd[7211]: backsql_load_schema_map("inetOrgPerson"): autoadding 'objectClass' and 'ref' mappings
May 25 10:23:12 ldap1p slapd[7211]: <==backsql_load_schema_map()
May 25 10:23:12 ldap1p slapd[7211]: <==backsql_get_db_conn()
May 25 10:23:12 ldap1p slapd[7211]: ==>backsql_free_db_conn()
May 25 10:23:12 ldap1p slapd[7211]: backsql_free_db_conn(): closing db connection 4294967295 (0x9ceb880)
May 25 10:23:12 ldap1p slapd[7211]: ==>backsql_close_db_conn(4294967295)
May 25 10:23:12 ldap1p slapd[7211]: <==backsql_close_db_conn(4294967295)
May 25 10:23:12 ldap1p slapd[7211]: <==backsql_free_db_conn()
May 25 10:23:12 ldap1p slapd[7211]: <==backsql_db_open(): test succeeded, schema map loaded
May 25 10:23:12 ldap1p slapd[7211]: slapd starting
May 25 10:23:12 ldap1p slapd[7211]: daemon: added 4r listener=(nil)
May 25 10:23:12 ldap1p slapd[7211]: daemon: added 7r listener=0x9c9d238
May 25 10:23:12 ldap1p slapd[7211]: daemon: added 8r listener=0x9c9d2f8
May 25 10:23:12 ldap1p slapd[7211]: daemon: epoll: listen=7 active_threads=0 tvp=NULL
May 25 10:23:12 ldap1p slapd[7211]: daemon: epoll: listen=8 active_threads=0 tvp=NULL
May 25 10:23:29 ldap1p slapd[7211]: daemon: activity on 1 descriptor
May 25 10:23:29 ldap1p slapd[7211]: daemon: activity on:
May 25 10:23:29 ldap1p slapd[7211]:
May 25 10:23:29 ldap1p slapd[7211]: >>> slap_listener(ldap:///)
May 25 10:23:29 ldap1p slapd[7211]: daemon: listen=8, new connection on 9
May 25 10:23:29 ldap1p slapd[7211]: daemon: added 9r (active) listener=(nil)
May 25 10:23:29 ldap1p slapd[7211]: conn=0 fd=9 ACCEPT from IP=127.0.0.1:32793 (IP=0.0.0.0:389)
May 25 10:23:29 ldap1p slapd[7211]: daemon: epoll: listen=7 active_threads=0 tvp=NULL
May 25 10:23:29 ldap1p slapd[7211]: daemon: epoll: listen=8 active_threads=0 tvp=NULL
May 25 10:23:29 ldap1p slapd[7211]: daemon: activity on 1 descriptor
May 25 10:23:29 ldap1p slapd[7211]: daemon: activity on:
May 25 10:23:29 ldap1p slapd[7211]: 9r
May 25 10:23:29 ldap1p slapd[7211]:
May 25 10:23:29 ldap1p slapd[7211]: daemon: read active on 9
May 25 10:23:29 ldap1p slapd[7211]: connection_get(9)
May 25 10:23:29 ldap1p slapd[7211]: connection_get(9): got connid=0
May 25 10:23:29 ldap1p slapd[7211]: connection_read(9): checking for input on id=0
May 25 10:23:29 ldap1p slapd[7211]: daemon: epoll: listen=7 active_threads=0 tvp=NULL
May 25 10:23:29 ldap1p slapd[7211]: daemon: epoll: listen=8 active_threads=0 tvp=NULL
May 25 10:23:29 ldap1p slapd[7211]: do_bind
May 25 10:23:29 ldap1p slapd[7211]: >>> dnPrettyNormal: <>
May 25 10:23:29 ldap1p slapd[7211]: <<< dnPrettyNormal: <>, <>
May 25 10:23:29 ldap1p slapd[7211]: do_bind: version=3 dn="" method=128
May 25 10:23:29 ldap1p slapd[7211]: conn=0 op=0 BIND dn="" method=128
May 25 10:23:29 ldap1p slapd[7211]: send_ldap_result: conn=0 op=0 p=3
May 25 10:23:29 ldap1p slapd[7211]: send_ldap_result: err=0 matched="" text=""
May 25 10:23:29 ldap1p slapd[7211]: send_ldap_response: msgid=1 tag=97 err=0
May 25 10:23:29 ldap1p slapd[7211]: daemon: activity on 1 descriptor
May 25 10:23:29 ldap1p slapd[7211]: daemon: activity on:
May 25 10:23:29 ldap1p slapd[7211]: 9r
May 25 10:23:29 ldap1p slapd[7211]:
May 25 10:23:29 ldap1p slapd[7211]: daemon: read active on 9
May 25 10:23:29 ldap1p slapd[7211]: connection_get(9)
May 25 10:23:29 ldap1p slapd[7211]: connection_get(9): got connid=0
May 25 10:23:29 ldap1p slapd[7211]: connection_read(9): checking for input on id=0
May 25 10:23:29 ldap1p slapd[7211]: daemon: epoll: listen=7 active_threads=0 tvp=NULL
May 25 10:23:29 ldap1p slapd[7211]: daemon: epoll: listen=8 active_threads=0 tvp=NULL
May 25 10:23:29 ldap1p slapd[7211]: do_search
May 25 10:23:29 ldap1p slapd[7211]: >>> dnPrettyNormal:
May 25 10:23:29 ldap1p slapd[7211]: <<< dnPrettyNormal: ,
May 25 10:23:29 ldap1p slapd[7211]: SRCH "dc=example,dc=com" 2 0
May 25 10:23:29 ldap1p slapd[7211]: 0 0 0
May 25 10:23:29 ldap1p slapd[7211]: begin get_filter
May 25 10:23:29 ldap1p slapd[7211]: EQUALITY
May 25 10:23:29 ldap1p slapd[7211]: end get_filter 0
May 25 10:23:29 ldap1p slapd[7211]: filter: (name=mitya)
May 25 10:23:29 ldap1p slapd[7211]: attrs:
May 25 10:23:29 ldap1p slapd[7211]:
May 25 10:23:29 ldap1p slapd[7211]: conn=0 op=1 SRCH base="dc=example,dc=com" scope=2 deref=0 filter="(name=mitya)"
May 25 10:23:29 ldap1p slapd[7211]: ==> limits_get: conn=0 op=1 dn="[anonymous]"
May 25 10:23:29 ldap1p slapd[7211]: ==>backsql_search(): base="dc=example,dc=com", filter="(name=mitya)", scope=2,
May 25 10:23:29 ldap1p slapd[7211]: deref=0, attrsonly=0, attributes to load: all
May 25 10:23:29 ldap1p slapd[7211]: ==>backsql_get_db_conn()
May 25 10:23:29 ldap1p slapd[7211]: ==>backsql_open_db_conn(0)
May 25 10:23:29 ldap1p slapd[7211]: conn=0 op=0 RESULT tag=97 err=0 text=
May 25 10:23:29 ldap1p slapd[7211]: do_bind: v3 anonymous bind
May 25 10:23:29 ldap1p slapd[7211]: backsql_open_db_conn(0): connected, adding to tree.
May 25 10:23:29 ldap1p slapd[7211]: <==backsql_open_db_conn(0)
May 25 10:23:29 ldap1p slapd[7211]: conn=0 op=0 RESULT tag=97 err=0 text=
May 25 10:23:29 ldap1p slapd[7211]: do_bind: v3 anonymous bind
May 25 10:23:29 ldap1p slapd[7211]: backsql_open_db_conn(0): connected, adding to tree.
May 25 10:23:29 ldap1p slapd[7211]: <==backsql_open_db_conn(0)
May 25 10:23:29 ldap1p slapd[7211]: <==backsql_get_db_conn()
May 25 10:23:29 ldap1p slapd[7211]: ==>backsql_dn2id("dc=example,dc=com") matched expected
May 25 10:23:29 ldap1p slapd[7211]: backsql_dn2id("dc=example,dc=com"): id_query "SELECT id,keyval,oc_map_id,dn FROM ldap_entries WHERE dn_ru=?"
May 25 10:23:29 ldap1p slapd[7211]: backsql_dn2id("dc=example,dc=com"): upperdn="MOC=CD,ELPMAXE=CD"
May 25 10:23:29 ldap1p slapd[7211]: <==backsql_dn2id("dc=example,dc=com"): err=32
May 25 10:23:29 ldap1p slapd[7211]: send_ldap_result: conn=0 op=1 p=3
May 25 10:23:29 ldap1p slapd[7211]: send_ldap_result: err=32 matched="" text=""
May 25 10:23:29 ldap1p slapd[7211]: send_ldap_response: msgid=2 tag=101 err=32
May 25 10:23:29 ldap1p slapd[7211]: daemon: activity on 1 descriptor
May 25 10:23:29 ldap1p slapd[7211]: daemon: activity on:
May 25 10:23:29 ldap1p slapd[7211]: 9r
May 25 10:23:29 ldap1p slapd[7211]:
May 25 10:23:29 ldap1p slapd[7211]: daemon: read active on 9
May 25 10:23:29 ldap1p slapd[7211]: connection_get(9)
May 25 10:23:29 ldap1p slapd[7211]: connection_get(9): got connid=0
May 25 10:23:29 ldap1p slapd[7211]: connection_read(9): checking for input on id=0
May 25 10:23:29 ldap1p slapd[7211]: ber_get_next on fd 9 failed errno=0 (Success)
May 25 10:23:29 ldap1p slapd[7211]: connection_read(9): input error=-2 id=0, closing.
May 25 10:23:29 ldap1p slapd[7211]: connection_closing: readying conn=0 sd=9 for close
May 25 10:23:29 ldap1p slapd[7211]: connection_close: deferring conn=0 sd=-1
May 25 10:23:29 ldap1p slapd[7211]: daemon: epoll: listen=7 active_threads=0 tvp=NULL
May 25 10:23:29 ldap1p slapd[7211]: daemon: epoll: listen=8 active_threads=0 tvp=NULL
May 25 10:23:29 ldap1p slapd[7211]: daemon: activity on 1 descriptor
May 25 10:23:29 ldap1p slapd[7211]: daemon: activity on:
May 25 10:23:29 ldap1p slapd[7211]:
May 25 10:23:29 ldap1p slapd[7211]: daemon: epoll: listen=7 active_threads=0 tvp=NULL
May 25 10:23:29 ldap1p slapd[7211]: daemon: epoll: listen=8 active_threads=0 tvp=NULL
May 25 10:23:29 ldap1p slapd[7211]: do_unbind
May 25 10:23:29 ldap1p slapd[7211]: conn=0 op=2 UNBIND
May 25 10:23:29 ldap1p slapd[7211]: connection_resched: attempting closing conn=0 sd=9
May 25 10:23:29 ldap1p slapd[7211]: connection_close: deferring conn=0 sd=-1
May 25 10:23:29 ldap1p slapd[7211]: conn=0 op=1 SEARCH RESULT tag=101 err=32 nentries=0 text=
May 25 10:23:29 ldap1p slapd[7211]: <==backsql_search()
May 25 10:23:29 ldap1p slapd[7211]: connection_resched: attempting closing conn=0 sd=9
May 25 10:23:29 ldap1p slapd[7211]: connection_close: conn=0 sd=-1
May 25 10:23:29 ldap1p slapd[7211]: ==>backsql_connection_destroy()
May 25 10:23:29 ldap1p slapd[7211]: ==>backsql_free_db_conn()
May 25 10:23:29 ldap1p slapd[7211]: backsql_free_db_conn(): closing db connection 0 (0x9d16580)
May 25 10:23:29 ldap1p slapd[7211]: ==>backsql_close_db_conn(0)
May 25 10:23:29 ldap1p slapd[7211]: <==backsql_close_db_conn(0)
May 25 10:23:29 ldap1p slapd[7211]: <==backsql_free_db_conn()
May 25 10:23:29 ldap1p slapd[7211]: <==backsql_connection_destroy()
May 25 10:23:29 ldap1p slapd[7211]: daemon: removing 9
May 25 10:23:29 ldap1p slapd[7211]: conn=0 fd=9 closed ()
Following is the slapd configuration
database sql
##suffix "o=sql,c=RU"
suffix "dc=example,dc=com"
rootdn "cn=root,dc=example,dc=com"
#rootdn "cn=root,o=sql,c=RU"
rootpw secret
dbname beora
dbuser ldapuser
dbpasswd ldapuser
subtree_cond "UPPER(ldap_entries.dn) LIKE CONCAT('%',UPPER(?))"
insentry_stmt "INSERT INTO ldap_entries (id,dn,oc_map_id,parent,keyval) VALUES (ldap_entry_ids.nextval,?,?,?,?)"
upper_func UPPER
Kindly suggest.