Re: back-sql

[Uwe Hering <uwe.hering@suse.de>]

On Tue, Sep 17, 2002 at 05:12:40PM +0200, Uwe Hering wrote:
> Hi,
> 

[...]

> 
> SELECT DISTINCT ldap_entries.id,persons.id,'inetOrgPerson' AS
> objectClass,ldap_entries.dn AS dn FROM ldap_entries,persons WHERE
> persons.id=ldap_entries.keyval AND ldap_entries.oc_map_id=1 AND
> ldap_entries.dn LIKE CONCAT('%','UR=C,LQS=O%') AND NOT
> ('inetOrgPerson' IS NULL)
> 
> 
> I assume that the string "LIKE CONCAT('%','UR=C,LQS=O%')" ist not
> correct. Changing it to "LIKE CONCAT('%','O=SQL,C=RU%')" works
> within mysql properly.
> 
> 

Putting the search base into slapd.conf will workaround that:

subtree_cond    "ldap_entries.dn LIKE CONCAT('%','%o=sql,c=ru')"

but shouldn't 

subtree_cond   "ldap_entries.dn LIKE CONCAT('%',?)"

work as well if the search base is given by ldapsearch?

Uwe


-- 
--------------------------------------------------------------------
Uwe Hering                      uwe.hering@suse.de
SuSE Linux AG                   phone   +49-30-43 09 44 776
Berliner Straße 27              mobile  +49-179-46 79 78 4
D-13507 Berlin                  fax     +49-30-43 73 28 04
--------------------------------------------------------------------