<quote who="Patai Sangbutsarakum"> <snip>
Hope this make sense Please Please suggest
I suggest you try to explain to problem you are trying to solve here. Why do you need the sql backend to start with? It's usually the very last option to chose, where you are forced due to legacy applications and many other reasons.
Gavin.
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@suretecsystems.com wrote:
<quote who="Patai Sangbutsarakum"> <snip>
Hope this make sense Please Please suggest
I suggest you try to explain to problem you are trying to solve here. Why do you need the sql backend to start with? It's usually the very last option to chose, where you are forced due to legacy applications and many other reasons.
Gavin.
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?
What version of OpenLDAP are you using? AFAIK, only OpenLDAP 2.4 honors binary values.
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 ---------------------------------------
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.
What version of OpenLDAP are you using? AFAIK, only OpenLDAP 2.4 honors binary values.
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@sys-net.it 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?
What version of OpenLDAP are you using? AFAIK, only OpenLDAP 2.4 honors binary values.
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
Patai Sangbutsarakum wrote:
What version of OpenLDAP are you using? AFAIK, only OpenLDAP 2.4 honors binary values.
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.
Sorry, I meant: only OpenLDAP 2.4 honors binary files in back-sql. Of course OpenLDAP honors binary files since 1.0.
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 ---------------------------------------
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@sys-net.it wrote:
Patai Sangbutsarakum wrote:
What version of OpenLDAP are you using? AFAIK, only OpenLDAP 2.4 honors binary values.
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.
Sorry, I meant: only OpenLDAP 2.4 honors binary files in back-sql. Of course OpenLDAP honors binary files since 1.0.
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
Patai Sangbutsarakum wrote:
You are the man!..
... who implemented it.
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.
You're welcome.
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 ---------------------------------------
openldap-software@openldap.org
-
Gavin Henry -
Patai Sangbutsarakum -
Pierangelo Masarati