[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
Order of variables in ldap_attr_mappings.add_proc
Hello,
I'm working on integrating a MySQL DB into OpenLDAP as backend using the
provided back-sql package. One problem I have not been able to solve
yet is with the order of variables in ldap_attr_mappings.add_proc. As
I can't call a stored procedure in MySQL, I have just plain SQL in there,
for example something like:
update my_table set my_attr = ? where my_id = ?;
The point is that back-sql replaces the first ? with the key and the
second with the value; wrong order here.
I have tried this:
set @key=?; set @value=?;
update my_table set my_attr = @value where my_id = @key;
But that gives syntax errors when run by back-sql (but works with
the MySQL command interpreter). Does anyone have a solution for
this? Plus, does anyone actually use MySQL together with OpenLDAP for
read/write operations (thinking about ldap_oc_mappings.create_proc,
ldap_oc_mappings.delete_proc etc.)?
Thanks,
-Luzian
--
University of Zurich, Centre for Computing Services
Luzian Scherrer <lsc@zi.unizh.ch>
Tel: +41 1 63 56778 Fax: +41 1 63 54505 Office: Y11-F-76