|
Hi I am new to the list and was hoping for a bit of advice
I am Running 2.1.14 on win2000 with back-sql
I have been trying to get this to work for days. Slapd works + connects + runs thro its diagnostics + back-sql startup diagnostics are fine. When I try + connect from a client to backsql I get the following trace when back-sql is in debug mode.
do_search ber_get_next ldap_read: want=9 error=unknown error ber_scanf fmt ({miiiib) ber: ber_dump: buf=0x00d80500 ptr=0x00d80503 end=0x00d80541 len=62 0000: 63 3c 04 1b 6f 75 3d 63 6f 6e 74 61 63 74 73 2c c<..ou=contacts, 0010: 64 63 3d 6b 2d 69 6e 74 2c 64 63 3d 63 6f 6d 0a dc=k-int,dc=com. 0020: 01 00 0a 01 00 02 02 03 e8 02 01 02 01 01 00 87 ................ ber_get_next on fd 1092 failed errno=10035 (WSAEWOULDBLOCK) 0030: 0b 6f 62 6a 65 63 74 63 6c 61 73 73 30 00 .objectclass0. >>> dnPrettyNormal: <ou=contacts,dc=k-int,dc=com> => ldap_bv2dn(ou=contacts,dc=k-int,dc=com,0) <= ldap_bv2dn(ou=contacts,dc=k-int,dc=com,0)=0 => ldap_dn2bv(272) <= ldap_dn2bv(ou=contacts,dc=k-int,dc=com,272)=0 daemon: select: listen=340 active_threads=1 tvp=NULL => ldap_dn2bv(272) <= ldap_dn2bv(ou=contacts,dc=k-int,dc=com,272)=0 <<< dnPrettyNormal: <ou=contacts,dc=k-int,dc=com>, <ou=contacts,dc=k-int,dc=com> SRCH "ou=contacts,dc=k-int,dc=com" 0 0 1000 2 0 begin get_filter PRESENT ber_scanf fmt (m) ber: ber_dump: buf=0x00d80500 ptr=0x00d80532 end=0x00d80541 len=15 0000: 87 0b 6f 62 6a 65 63 74 63 6c 61 73 73 30 00 ..objectclass0. end get_filter 0 filter: (objectClass=*) ber_scanf fmt ({M}}) ber: ber_dump: buf=0x00d80500 ptr=0x00d8053f end=0x00d80541 len=2 0000: 00 00 .. attrs: ==>backsql_search(): base='ou=contacts,dc=k-int,dc=com', filter='(objectClass=*)', scope=0, deref=0, attrsonly=0, attributes to load: all ==>backsql_get_db_conn() <==backsql_get_db_conn() ==>backsql_oc_get_candidates(): oc='organizationalUnit' ==>backsql_srch_query() ==>backsql_process_filter() <==backsql_process_filter() <==backsql_srch_query() Constructed query: SELECT DISTINCT ldap_entries.id,orgunit.id,'organizationalUnit' AS objectClass,ldap_entries.dn AS dn FROM ldap_entries,orgunit WHERE orgunit.id=ldap_entries.keyval AND ldap_entries.oc_map_id=? AND ldap_entries.dn=? AND NOT ('organizationalUnit' IS NULL) backsql_oc_get_candidates(): added entry id=1, keyval=1 dn='ou=contacts,dc=k-int,dc=com' <==backsql_oc_get_candidates() ==>backsql_oc_get_candidates(): oc='inetOrgPerson' ==>backsql_srch_query() ==>backsql_process_filter() <==backsql_process_filter() <==backsql_srch_query() Constructed query: SELECT DISTINCT ldap_entries.id,contacts.id,'inetOrgPerson' AS objectClass,ldap_entries.dn AS dn FROM ldap_entries,contacts WHERE contacts.id=ldap_entries.keyval AND ldap_entries.oc_map_id=? AND ldap_entries.dn=? AND NOT ('inetOrgPerson' IS NULL) <==backsql_oc_get_candidates() backsql_search(): loading data for entry id=1, oc_id=1, keyval=1 ==>backsql_id2entry() >>> dnPrettyNormal: <ou=contacts,dc=k-int,dc=com> => ldap_bv2dn(ou=contacts,dc=k-int,dc=com,0) <= ldap_bv2dn(ou=contacts,dc=k-int,dc=com,0)=0 => ldap_dn2bv(272) <= ldap_dn2bv(ou=contacts,dc=k-int,dc=com,272)=0 => ldap_dn2bv(272) <= ldap_dn2bv(ou=contacts,dc=k-int,dc=com,272)=0 <<< dnPrettyNormal: <ou=contacts,dc=k-int,dc=com>, <ou=contacts,dc=k-int,dc=com> backsql_id2entry(): retrieving all attributes ==>backsql_get_attr_vals(): oc='organizationalUnit' attr='objectClass' keyval=1 <==backsql_get_attr_vals() ==>backsql_get_attr_vals(): oc='organizationalUnit' attr='ref' keyval=1 <==backsql_get_attr_vals() ==>backsql_get_attr_vals(): oc='organizationalUnit' attr='ou' keyval=1 <==backsql_get_attr_vals() backsql_search(): error in backsql_id2entry() - skipping entry send_ldap_result: conn=0 op=5 p=3 send_ldap_result: err=0 matched="" text="" send_ldap_response: msgid=6 tag=101 err=0 ber_flush: 14 bytes to sd 1092 0000: 30 0c 02 01 06 65 07 0a 01 00 04 00 04 00 0....e........ ldap_write: want=14, written=14 0000: 30 0c 02 01 06 65 07 0a 01 00 04 00 04 00 0....e........ <==backsql_search()
I am using mysql. But there also seem to be inconsistencies with the sql files in the rdbms-depend folder with a variety of tables depending upon the database. It seems that the software now depends on sel_expr_u but this is not in the mysql test file for example.
The problem is that I have no idea anymore whether I am seeing a bug or an error in the schema mappings or what. I have tried every example I can find but they all give me the same error.
Help
Rob Tice
|