[back-sql] possible?

["Patai Sangbutsarakum" <patai.s@gmail.com>]

Dear Openldaper,

I've been trying to develop a tool to automate the migration process
from ldap data in flat-file(bdb, gdbm) to back-sql (mysql).
I could successfully do it if those data is text/string, but
come to the binary; I'm kind of stuck for a while.

Is that really possible to store the jpeg/certificate data in mysql
tables, and let
the openldap retrieve those jpeg/certificate data from mysql correctly?

What did I tried?
I have the right set of tables because all those text data can be
retrieved correctly by slapd.

Then, I start using jpegPhoto as the first binary data type.
The column for jpegPhoto is defined as LONGBLOB datatype.
I tried to inject the tiny jpeg picture directly to that column by php,
and pull it back from the table. It works well picture can display.

But, with the ldapbrowser (from apache project). I can't retrieve the
data back through the ldap way (it said "invalid image").
I try to dump the data to ldif. The ldif totally different from base64
version of that picture file.
I'm so desperated right now.

Hope this make sense
Please Please suggest

Patrick