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

Re: (ITS#5062) back-sql with non-integer keycol's



lehner@webdynamite.com wrote:
> Full_Name: GeorgLehner
> Version: 2.3.30
> OS: Debian Gnu/Linux i386
> URL: 
> Submission from: (NULL) (83.64.52.210)
> 
> 
> The slapd-sql(5) man page states:
> 
>   '- the key must be an integer. ...
>    If anyone needs support for different types for keys
>    - he may want to write a patch,'
> 
> I am configuring back-sql as a frontend to the SugarCRM Customer Database.
> SugarCRM uses UUID's as keys:
> 
>   http://dev.mysql.com/doc/refman/5.0/en/miscellaneous-functions.html#function_uuid
> 
> so I want (to write) a patch. Can you please give me some hint where
> to start?

Actually, I think this has been already implemented (although possibly 
experimental).  You need to rebuild back-sql after manually defining 
BACKSQL_ARBITRARY_KEY in <servers/slapd/back-sql/back-sql.h>.  In that 
case, however, all keys need to be strings.  Please test and report.

p.



Ing. Pierangelo Masarati
OpenLDAP Core Team

SysNet s.r.l.
via Dossi, 8 - 27100 Pavia - ITALIA
http://www.sys-net.it
---------------------------------------
Office:  +39 02 23998309
Mobile:  +39 333 4963172
Email:   pierangelo.masarati@sys-net.it
---------------------------------------