Hello,

I've never used back-sql, so I may not have the correct answer. However, from the LDAP point of view, the data in the cn attribute is not case sensitive, so if you can change the definition of the column in your SQL Table to be case insensitive, you will solve your problem.

Frank

On 6/21/08 1:11 PM, Benedikt Bär wrote:
Hi list,

I have been configuring back-sql and so far everything works to my
liking.
However, when I have a upper case letter in a cn value, OpenLDAP can't
find the whole entry.

It makes a query like this:

 SELECT id,keyval,oc_map_id,dn FROM ldap_entries WHERE dn='cn=benedikt
help,ou=users,ou=employees,dc=rhino-tde,dc=net'

However it should be 'Benedikt', not 'benedikt' (because in ldap_entries
it's with upper case).

slapd.conf sql part:

database        sql
suffix         "ou=employees,dc=rhino-tde,dc=net"
dbname          MySQL
dbuser          *****
dbpasswd        *****
subtree_cond    "ldap_entries.dn LIKE CONCAT('%',?)"
insentry_query  "INSERT INTO ldap_entries (dn,oc_map_id,parent,keyval)
VALUES (?,?,?,?)"
has_ldapinfo_dn_ru      no
subordinate

Is it possible to change that?

Thanks for your help :).

Cheers,
- Benedikt

This message is digitally signed by a PGP
key, to verify it's authenticity.
If you received this message without key
the message may not be authentic.

www.relamp.tk


------------------------------------------------------------------------

---
You are currently subscribed to [EMAIL PROTECTED] as: [EMAIL PROTECTED]
To unsubscribe send email to [EMAIL PROTECTED] with the word UNSUBSCRIBE as the 
SUBJECT of the message.

--
Frank Swasey                    | http://www.uvm.edu/~fcs
Sr Systems Administrator        | Always remember: You are UNIQUE,
University of Vermont           |    just like everyone else.
  "I am not young enough to know everything." - Oscar Wilde (1854-1900)


---
You are currently subscribed to [EMAIL PROTECTED] as: [EMAIL PROTECTED]
To unsubscribe send email to [EMAIL PROTECTED] with the word UNSUBSCRIBE as the 
SUBJECT of the message.

Reply via email to