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

Re: (ITS#4604) backs-sql: backsql_process_filter(): invalid filter for UTF-8 querys

On Sat, 2006-07-01 at 16:47 +0200, Thomas Reifferscheid wrote:
> Dear Pieranelo,
> regarding http://student.physik.uni-mainz.de/~reiffert/back_sql.txt
> ...
> On Sat, 1 Jul 2006, Pierangelo Masarati wrote:
> > back-sql acts as a "dumb" backend to a generic RDBMS; LDAP requires UTF8
> > for directory strings,
> Jul  1 09:51:10 hell slapd[25812]:     filter: 
> (|(cn=m\C3\BCl*)(?=undefined)(sn=m\C3\BCl*))

This seems to indicate that the second AVA in your filter is incorrect.
I have no idea as per what Thunderbird sends as search filter, but
likely either that attribute is not defined in your slapd's schema, or
its value does not comply with that attribute's syntax.

I suggest you find out (e.g. by looking at logs with level "packets")
what filter is actually sent; then check if the attribute is defined in
your schema and if the value complies with the syntax of that attribute.

> isn't that in the exact right way it has to be?
> If not, how has it to look like at this place so that
> the answer is not:
> Jul  1 09:51:10 hell slapd[25812]: backsql_process_filter(): invalid 
> filter
> > while the RDBMS uses whatever instructed to.  You
> > need to make sure appropriate conversion occurs in between.  Back-sql
> > does not provide any means to convert strings to/from another character
> > set.  A patch that consistently enables translitteration from UTF8 to
> > whatever charset is used in the RDBMS for a given data type is welcome,
> > provided it complies with the license and other contribution criteria of
> > OpenLDAP software.
> If I'd understand you better, I probably will start finding a workaround
> to enhance openldap getting around that nasty thing!

This remains valid: LDAP strings are UTF8 encoded; data in your RBBMS is
encoded whatever it was set as.  back-sql should be smart enough to
allow mapping, but right now it's not.


Ing. Pierangelo Masarati
Responsabile Open Solution
OpenLDAP Core Team

SysNet s.n.c.
Via Dossi, 8 - 27100 Pavia - ITALIA
Office:   +39.02.23998309          
Mobile:   +39.333.4963172
Email:    pierangelo.masarati@sys-net.it