Migrating from Prosody and salted SHA1 password hashes
I'm currently in the process of migrating the user base of a salted SHA1 backed Prosody to Tigase, and I'm stuck on the migration of the password hashes. Have you guys been through it?
I've been looking at the stored procedures that adds/updates users in https://repository.tigase.org/reps/tigase-server/trunk/database/postgresql-schema-4-sp.sql and your efforts regarding SCRAM https://projects.tigase.org/projects/tigase-server/repository/revisions/4bf9429209fe9f77c12c9cc510243625dc971750 and I was wondering how (if) they fit together.
What are you plans regarding supporting an user base relying on salted SHA1 hashes?
Added by Artur Hefczyc over 4 years ago
I do not know Prosody's algorithms for passwords encoding so I cannot tell you whether Tigase can support it out of the box. In some cases different passwords encoding can be entirely handled on the DB level. Have a look at the DB schema and stored procedures code with "PlainPw" in their names. You can see how password encoding is handled on the DB level. If you know Prosody algorithm then you will know if this is something that can be implemented on DB level.
Otherwise, please provide more details and someone from out team will tell you how to make it work in Tigase.