Thanks for reply. I was forced by my graduate project adviser. This is a part of my master's project. The problem that I am trying to solve is, to make the process of using back-sql + mysql become automatic without/less human intervention. I have done with the TEXT data, but for the binary data still no luck. But first of all, I'm looking for if the back-sql itself support storing binary data jpegPhoto, userCertificate .. in Mysql table and then retrieve those bin. data from mysql and represent it in LDAP tree or not? Hope this answer with some sense. Patrick. On Nov 15, 2007 7:28 AM, Gavin Henry <ghenry(a)suretecsystems.com&gt; wrote:

Dear all, I just did terribly posted; I didn't put openldap version... i want to slap myself..forgive me. I'm running 2.3.38 stable branch. running on Centos 5 x86. Openldap was compile from source, and definitely with --enable-sql. I run 2 identical openldap 2.3.38 servers on different vmware instance. The first machine uses bdb. I could insert the jpeg photo via gui of ldap browser. I dump data under that namespace. I saw base64 data of that jpegPhoto. Thus, does this imply that 2.3.38 honors binary data. correct me if I'm wrong. On the second machine, it is the clone of the first machine. except slapd.conf point the same namespace to back-sql. I successfully use text data such homephone, carlicense slapd can pull data from those tables in mysql as long as it is text. But come into jpegPhoto, mysql stores blob of jpegPhoto. seem like slapd can pull it out, but the same ldap browser (from apache project) said invalid image. I dump the ldif from the second machine. The base64 of the same jpegPhoto is totally different. please suggest, Patrick On Nov 15, 2007 10:04 AM, Pierangelo Masarati <ando(a)sys-net.it&gt; wrote: > Patai Sangbutsarakum wrote: > > > But first of all, I'm looking for if the back-sql itself support > > storing binary data jpegPhoto, userCertificate .. in Mysql table and > > then retrieve those bin. data > > from mysql and represent it in LDAP tree or not? > > > 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(a)sys-net.it > --------------------------------------- > > >

You are the man!.. I upgraded to 2.4.6; I inject blob of jpeg photo into the same column that 2.3.38 can't use. The ldap browser can retrieve the picture from slapd 2.4.6. I bow to your knowlege. Thanks, you save me. Patrick On Nov 15, 2007 10:47 AM, Pierangelo Masarati <ando(a)sys-net.it&gt; wrote: