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

back-sql problem



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()