Re: (ITS#7130) OpenLDAP with BackSQL and Postgres. Upper on bigint?

[masarati@aero.polimi.it]

> Full_Name: Manny
> Version: 2.4.23
> OS: RHEL6
> URL: ftp://ftp.openldap.org/incoming/
> Submission from: (NULL) (193.171.77.1)
>
>
> Hi there.
>
> I'm posting this into the ITS as I didn't get a response on the mailing
> list
> after 1 week.
>
> I'm using the latest stable release of openldap, with back-sql and
> postgresql as a backend.
> I have an sssd which uses this openldap server for ID providing and
> authentication.
> A recent update in this sssd changed the filter used to retrieve
> groupids of users, which surfaced what seems to be a bug in backsql.
>
>>From my investigation it seems to me that when constructing the search
> query, openldap tries to use the UPPER function on every criteria in
> the WHERE clause, no matter which type it is. This causes an error in
> postgresql, as the gidNumber that is supposed to be filtered is of
> type "bigint".

I don't recall seeing your message in openldap-technical, which it belongs
to.  In any case, there should be a field in ldap_at_mappings that tells
how and when an attribute value needs to be uppercased.  However, I can't
check right now whether it works as intended, and back-sql is
unmaintained.

p.