[Deploying Sakai] Migrating user passwords from MySQL to OpenLDAP

[Steve Swinsburg]

Hi Fernando,

The passwords in the DB are not reversible, so you'd either need to transfer them in their current form, if that is suitable, or get users to re-enter them in the new system.

Older versions were just MD5 hashed. Newer passwords are salted and hashed. 

Check PasswordService in the kernel.
eg
http://source.sakaiproject.org/release/kernel/1.3.0-b01/xref/org/sakaiproject/user/impl/PasswordService.html

cheers,
Steve


On 07/11/2012, at 12:23 PM, Fernando Laudares Camargos <fernando at revolutionlinux.com> wrote:

> Hello,
> 
> we've got a Sakai server that is configured to be used with a MySQL database. We want to export the user's data to and LDAP server. What would be the correct way to migrate the password present in the table SAKAI_USER to the LDAP userPassword parameter conserving a compatible format ? 
> 
> In other words, how the user password in encrypted before being registered in the MySQL database ?
> 
> Thank you for your attention,
> -- 
> Fernando Laudares Camargos
>     Révolution Linux
> http://www.revolutionlinux.com
> ---------------------------------------
> * Tout opinion et prise de position exprimée dans ce message est celle
> de son auteur et pas nécessairement celle de Révolution Linux.
> ** Any views and opinion presented in this e-mail are solely those of
> the author and do not necessarily represent those of Révolution Linux.
> _______________________________________________
> production mailing list
> production at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/production
> 
> TO UNSUBSCRIBE: send email to production-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"