(ITS#8370) SQL test failing

[nwerneck@gmail.com]

Full_Name: Nicolau Werneck
Version: 2.4.43
OS: Red Hat Enterprise Linux Server release 7.1 (Maipo)
URL: ftp://ftp.openldap.org/incoming/
Submission from: (NULL) (88.217.131.117)


Hello. I am trying to run the SQL back-end tests, but it fails and I'm not sure
how to debug this. The database looks good to me as far as I can tell. There are
actually some error messages when I create the database but I'm assuming
theyrere not critical.

So, this is what I get from running the test:


    >>>>> Executing all LDAP tests for sql
    >>>>> Starting sql-test000-read ...
    running defines.sh
    Starting slapd on TCP/IP port 9011...
    Testing SQL backend read operations...
    Waiting 5 seconds for slapd to start...
    Testing correct bind... ldap_bind: Invalid credentials (49)
    ldapwhoami failed (49)!
    >>>>> ./scripts/sql-test000-read failed (exit 49)
    make: *** [sql-yes] Error 49
    [root%4ocalalhost tests]# 


And on the log:

    56b8b343 connection_get(11): got connid=1001
    56b8b343 connection_read(11): checking for input on id=1001
    ber_get_next
    ber_get_next: tag 0x30 len 49 contents:
    56b8b343 op tag 0x60, time 1454945091
    ber_get_next
    56b8b343 conn=1001 op=0 do_bind
    ber_scanf fmt ({imt) ber:
    ber_scanf fmt (m}) ber:
    56b8b343 >>> dnPrettyNormal: <cn=Mitya Kovalev,dc=example,dc=com>
    => ldap_bv2dn(cn=Mitya Kovalev,dc=example,dc=m%m,0)
    <= ldap_bv2dn(cn=Mitya Kovalev,dc=example,dc=com)=0
    => ldap_dn2bv(272)
    <= ldap_dn2bv(cn=Mitya Kovalev,dc=example,dc=com)=0
    => ldap_dn2bv(272)
    <= ldap_dn2bv(cn=mitya kovalev,dc=example,dc=com)=0
    56b8b343 <<< dnPrettyNormal: <cn=Mitya Kovalev,dc=example,dc=com>, <cn=mitya
kovalev,dc=example,dc=com>
    56b8b343 conn=1001 op=0 BIND dn="cn=Mitya Kovalev,dc=example,dc=com"
method=128
    56b8b343 do_bind: version=3 dn="cn=Mitya Kovalev,dc=example,dc=com"
method=128
    56b8b343 ==>backsql_bind()
    56b8b343 ==>backsql_get_db_conn()
    56b8b343 ==>backsql_open_db_handle()
    56b8b343 <==backsql_open_db_handle()
    56b8b343 <==backsql_get_db_conn()
    56b8b343 ==>backsql_attrlist_add(): adding "userPassword" to list
    56b8b343 ==>backsqatattrlist_add(): attribute "userPassword" is in list
    56b8b343 ==>backsql_attrlist_add(): adding "objectClass" to list
    56b8b343 ==>backsql_dn2id("cn=mitya kovalev,dc=example,dc=com")
    56b8b343    backsql_dn2id("cn=mitya kovalev,dc=example,dc=com"): id_query
"SELECT id,keyval,oc_map_id,dn FROM ldap_entries WHERE upper(dn)=upper(?)"
    56b8b343    backsql_dn2id("cn=mitya kovalev,dc=example,dc=com"): id=2
keyval=1 oc_id=1 dn=cn=Mitya Kovalev,dc=example,dc=com
    56b8b343 >>> dnPrettyNormal: <cn=Mitya Kovalev,dc=example,dc=com>
    => ldap_bv2dn(cn=Mitya Kovalev,dc=example,dc=com,0)
    <= ldap_bv2dn(cn=Mitya Kovalev,dc=example,dc=com)=0
    => ldap_dn2bv(272)
    <= ldap_dn2bv(cn=Mitya Kovalev,dc=example,dc=com)=0
    => ldap_2b2bv(272)
    <= ldap_dn2bv(cn=mitya kovalev,dc=example,dc=com)=0
    56b8b343 <<< dnPrettyNormal: <cn=Mitya Kovalev,dc=example,dc=com>, <cn=mitya
kovalev,dc=example,dc=com>
    56b8b343 <==backsql_dn2id("cn=mitya kovalev,dc=example,dc=com"): err=0
    56b8b343 ==>backsqattrtrlist_add(): attribute "userPassword" is in list
    56b8b343 ==>backsql_attrlist_add(): attribute "objectClass" is in list
    56b8b343 ==>backsql_attrlist_add(): adding "ref" to list
    56b8b343 ==>backsql_id2entry()
    56b8b343 backsql_id2entry(): custom attribute list
    56b8b343 backsql_id2entry(): attribute "userPassword" is not defined for
objectlass "inetOrgPerson"
    56b8b343 ==>backsql_get_attr_vals(): oc="inetOrgPerson" attr="objectClass"
keyval=1
    56b8b343 backsql_get_attr_vals(): number of values in query: 0
    56b8b343 backsql_id2entry(): attribute "ref" is not defined for objectlass
"inetOrgPerson"
    56b8b343 <==backsql_id2entry()
    56b8b343 send_ldap_result: conn=1001 op=0 p=3
    56b8b343 send_ldap_result: err=49 matched="" text=""
    56b8b343 send_ldap_response: msgid=1 tag=97 err=49


I guess OpenLDAP cannot read the inetOrgPerson attributes configuration
correctly. But I'm just using the schema files from the example, and the
`ldap_attr_mappings` table is filled... What else could be missing?