[SOGo] password hashes w crypt-md5 + salt in (My)SQL db in sogo 2.0?

2012-06-14 Thread Andreas Balg

Oncew more trying to integrate SOGo with ISPConfig 3 managed accounts and mailboxes.

Ive found various mails regarding the support of crypt-md5 password hashes in SQL databases
(as used by ISPConfig 3 for mail users) so what is the current status of crypt-md with SQLdbs in sogo 2.0 ?

Did anybody figure out how to automate a synchronisation or configure sogo to use an SQL-View
directly with the database from ISPConfig 3 to authenticate users?

How may we authenticate users against that DB?

cheers
Andreas Balg



Re: [SOGo] password hashes w crypt-md5 + salt in (My)SQL db in sogo 2.0?

2012-06-14 Thread Hans de Groot

Hi,

I do know one thing, the documentation states to use crypt-md5 but it should be md5-crypt as authentication method. ie:

 keyuserPasswordAlgorithm/key
 stringmd5-crypt/string

I made a view to my own user table in an other database and that works. So I gues that a view to an ISPConfig database should work too.

Hans de Groot



On Thursday, June 14, 2012 13:00 CEST, Andreas Balg a.b...@xincs.eu wrote:


	
	Oncew more trying to integrate SOGo with ISPConfig 3 managed accounts and mailboxes.
	
	Ive found various mails regarding the support of crypt-md5 password hashes in SQL databases
	(as used by ISPConfig 3 for mail users) so what is the current status of crypt-md with SQLdbs in sogo 2.0 ?
	
	Did anybody figure out how to automate a synchronisation or configure sogo to use an SQL-View
	directly with the database from ISPConfig 3 to authenticate users?
	
	How may we authenticate users against that DB?
	
	cheers
	Andreas Balg