|
Hi there
I am running openldap 2.1.14 with back-sql (mysql) with schemacheck off on win200. My browser fails to find all the entries in my database (The log printout follows this message)
I am getting an error 32 no such object when there are entries in the database. I can view the top level using the softerra browser and there are lots of missing attributes in the display (in comparison to what is displayed for the entries in my functioning bdb database). Could the missing attribute entries be causing this inability to show the information? (btw if I remove the schemacheck off in slapd.conf I don’t see anything - only the error 32 is returned)
Here is the extract of the log printout which appears to suggest a problem with missing attributes, however I'm not sure how to rectify this in my database. I assume these entries are created automatically when slapadd is used on a bdb database? (I have tried to base my data on the test examples supplied but I appeared to get the same problem with this data as well)
If the problem is not obvious from the trace, could anyone show me an example of the metadata and data that works with back-sql and mysql and openldap 2.1.14, that would be a great help (bearing in mind that the shipped examples don’t appear to work).
Thanks
Rob Tice Rob.tice@k-int.com
------------------Debug output-----------------------------------
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(): custom attribute list backsql_id2entry(): attribute 'createTimestamp' is not defined for objectlass 'organizationalUnit' backsql_id2entry(): attribute 'modifyTimestamp' is not defined for objectlass 'organizationalUnit' backsql_id2entry(): attribute 'creatorsName' is not defined for objectlass 'organizationalUnit' backsql_id2entry(): attribute 'modifiersName' is not defined for objectlass 'organizationalUnit' backsql_id2entry(): attribute 'subschemaSubentry' is not defined for objectlass 'organizationalUnit' backsql_id2entry(): attribute 'attributeTypes' is not defined for objectlass 'organizationalUnit' backsql_id2entry(): attribute 'objectClasses' is not defined for objectlass 'organizationalUnit' backsql_id2entry(): attribute 'matchingRules' is not defined for objectlass 'organizationalUnit' backsql_id2entry(): attribute 'matchingRuleUse' is not defined for objectlass 'organizationalUnit' backsql_id2entry(): attribute 'namingContexts' is not defined for objectlass 'organizationalUnit' backsql_id2entry(): attribute 'altServer' is not defined for objectlass 'organizationalUnit' backsql_id2entry(): attribute 'supportedExtension' is not defined for objectlass 'organizationalUnit' backsql_id2entry(): attribute 'supportedControl' is not defined for objectlass 'organizationalUnit' backsql_id2entry(): attribute 'supportedSASLMechanisms' is not defined for objectlass 'organizationalUnit' backsql_id2entry(): attribute 'supportedLDAPVersion' is not defined for objectlass 'organizationalUnit' <==backsql_id2entry() => test_filter PRESENT => access_allowed: search access to "ou=contacts,dc=k-int,dc=com" "objectClass" requested => access_allowed: backend default search access granted to "" <= test_filter 6 => send_search_entry: dn="ou=contacts,dc=k-int,dc=com" => access_allowed: read access to "ou=contacts,dc=k-int,dc=com" "entry" requested => access_allowed: backend default read access granted to "" ==>backsql_operational(): entry 'ou=contacts,dc=k-int,dc=com' ==>backsql_get_db_conn() <==backsql_get_db_conn() ==>backsql_count_children(): dn='ou=contacts,dc=k-int,dc=com' children id query 'SELECT COUNT(distinct subordinates.id) FROM ldap_entries,ldap_entries AS subordinates WHERE subordinates.parent=ldap_entries.id AND ldap_entries.dn=?' <==backsql_count_children(): 3 => access_allowed: read access to "ou=contacts,dc=k-int,dc=com" "subschemaSubentry" requested => access_allowed: backend default read access granted to "" => access_allowed: read access to "ou=contacts,dc=k-int,dc=com" "hasSubordinates" requested => access_allowed: backend default read access granted to "" ber_flush: 102 bytes to sd 1204 0000: 30 64 02 01 07 64 5f 04 1b 6f 75 3d 63 6f 6e 74 0d...d_..ou=cont 0010: 61 63 74 73 2c 64 63 3d 6b 2d 69 6e 74 2c 64 63 acts,dc=k-int,dc 0020: 3d 63 6f 6d 30 40 30 23 04 11 73 75 62 73 63 68 =com0@0#..subsch 0030: 65 6d 61 53 75 62 65 6e 74 72 79 31 0e 04 0c 63 emaSubentry1...c 0040: 6e 3d 53 75 62 73 63 68 65 6d 61 30 19 04 0f 68 n=Subschema0...h 0050: 61 73 53 75 62 6f 72 64 69 6e 61 74 65 73 31 06 asSubordinates1. 0060: 04 04 54 52 55 45 ..TRUE
ldap_write: want=102, written=102 0000: 30 64 02 01 07 64 5f 04 1b 6f 75 3d 63 6f 6e 74 0d...d_..ou=cont 0010: 61 63 74 73 2c 64 63 3d 6b 2d 69 6e 74 2c 64 63 acts,dc=k-int,dc 0020: 3d 63 6f 6d 30 40 30 23 04 11 73 75 62 73 63 68 =com0@0#..subsch 0030: 65 6d 61 53 75 62 65 6e 74 72 79 31 0e 04 0c 63 emaSubentry1...c 0040: 6e 3d 53 75 62 73 63 68 65 6d 61 30 19 04 0f 68 n=Subschema0...h 0050: 61 73 53 75 62 6f 72 64 69 6e 61 74 65 73 31 06 asSubordinates1. 0060: 04 04 54 52 55 45 ..TRUE
<= send_search_entry send_search_result: err=0 matched="" text="" send_ldap_response: msgid=7 tag=101 err=0 ber_flush: 14 bytes to sd 1204 0000: 30 0c 02 01 07 65 07 0a 01 00 04 00 04 00 0....e........ ldap_write: want=14, written=14 0000: 30 0c 02 01 07 65 07 0a 01 00 04 00 04 00 0....e........ <==backsql_search()
|