Transfer passwords from sql'ed instance to ldap'ed instance

[ulysse68]

Hi!

I installed a new instance of eGroupWare on a new server, and wanted to manage the accounts through LDAP. Everything worked fine during the install. Now, I’d like to transfer the accounts from the old server (SQL accounts) to the new one.

I can write LDIF files from the export format, and import the accounts in my LDAP, but passwords don’t work. I made sure the format was in both cases defined as “md5”, but passwords look still different. For example, if I define the password “123456” in SQL, the md5 result is “e10adc3949ba59abbe56e057f20f883e”. But with my LDAP “md5” account, the same “123456” password is stored as “e21kNX00UXJjT1VtNldhdStWdUJYOGcrSVBnPT0=” (as I read it with slapcat).

Of course, when I transfer the accounts from SQL to LDAP, passwords don’t work anymore.

Any idea? Thanks!

[Ralf_Becker_Stylite]

Hi!

I installed a new instance of eGroupWare on a new server, and wanted to
manage the accounts through LDAP. Everything worked fine during the install.
Now, I’d like to transfer the accounts from the old server (SQL accounts) to
the new one.

I can write LDIF files from the export format, and import the accounts in my
LDAP, but passwords don’t work. I made sure the format was in both cases
defined as “md5”, but passwords look still different. For example, if I
define the password “123456” in SQL, the md5 result is
"e10adc3949ba59abbe56e057f20f883e". But with my LDAP “md5” account, the same
"123456" password is stored as “e21kNX00UXJjT1VtNldhdStWdUJYOGcrSVBnPT0=”
(as I read it with slapcat).

Of course, when I transfer the accounts from SQL to LDAP, passwords don’t
work anymore.

Why do it so complicated by hand?

If you have a working SQL install, just go to setup, add your LDAP
details and let EGroupware transfer the accounts to LDAP.

Ralf

Ralf Becker
Director Software Development

Stylite AG

Morschheimer Strasse 15 | Tel. +49 6352 70629 0
D-67292 Kirchheimbolanden | Fax. +49 6352 70629 30

Email: rb@stylite.de

www.stylite.de | www.egroupware.org

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer

VAT DE214280951 | Registered HRB 31158 Kaiserslautern Germany

---

Live Security Virtual Conference
Exclusive live event will cover all the ways today’s security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/

---

eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users

[ulysse68]

Why? Mmh… because I didn’t think of it – thanks for the hint!

So it means I just transfer the accounts in the table egw_accounts, and both LDAP and SQL accounts are recognized? I’ll try it next week…

Thanks again!