[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
Re: back-sql problem on win 2000
(redirected from openldap-bugs)
Please use openldap-software for software usage issues.
This list is to discuss bugs, and there is not (yet) any
evidence of a bug in what you report.
> 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
^^^ this is the main error; you should try to see what happens here.
>
> 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.
When ported to 2.1, back-sql (which is clearly marked
as experimental) underwent extended recoding; I was
only able to tst it under postgresql and IBM db2.
There may still be portability issues (wasn't portability
the reason ODBC was used? ;). If you can figure out what
is the actual problem, you may help improve back-sql
portability.
>
>
>
> 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.
Likely a portability issue or a bug or a misconfiguration
of the metainformation in your rdbms.
Unfortunately the developer of back-sql is not maintaining it
any more; I'm working at its maintenance during my (limited)
spare time, and I cannot test it under W2K (another possible
source of portability issues).
If you find more details, you may want to file an ITS.
Let me know if I can help.
p.
--
Pierangelo Masarati
mailto:pierangelo.masarati@sys-net.it