[Date Prev][Date Next] [Chronological] [Thread] [Top]

back-sql problem on win 2000



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 so I am suspecting a bug.

 

 

Help

 

Rob Tice

Rob.tice@k-int.com