I have just tried that now and it works!! Thanks!!!! However, I find this confusing, since I use dovecot and dovecot treats my password as md5-crypt.
Allow me to also ask: Since I have isAddressBook = YES; , shouldn't SOGo populate my global addressbook by default? Mine remains empty... On 26 June 2013 20:16, Giovanni Bechis <[email protected]> wrote: > Have you tried with > "userPasswordAlgorithm = crypt;" ? > > -- msg. originale -- > Oggetto: Re: [SOGo] Re: SOGo MySQL Authentication - SOLVED > Da: Odhiambo Washington <[email protected]> > Data: 26/06/2013 18:17 > > Well when I change that to md5-crypt, with matching password, it doesn't > work. Why so? > > Either of these two don't work! > userPasswordAlgorithm = md5; > userPasswordAlgorithm = md5-crypt; > > > My VIEW looks like this: > > mysql> select * from exim4u.sogo_auth_view where c_name like '%wash%'; > > +---------+---------------------+---------------------+------------------------------------+---------------------+---------------------+--------- > ------------+ > | sogo_id | c_uid | c_name | c_password > | c_cn | mail | displayN > ame | > > +---------+---------------------+---------------------+------------------------------------+---------------------+---------------------+--------- > ------------+ > | 3 | [email protected] | Odhiambo WASHINGTON | > $1$OFb7e/vf$/FL/Q4T0LXFwaklRUzN7v. | [email protected] | > [email protected] | Odhiambo WASHINGTON | > > +---------+---------------------+---------------------+------------------------------------+---------------------+---------------------+--------- > ------------+ > > > On 26 June 2013 17:44, Giovanni Bechis <[email protected]> wrote: > > > On 06/26/13 15:32, Odhiambo Washington wrote: > > > Hello, I have changed userPasswordAlgorithm = md5; to > > userPasswordAlgorithm = none; and I was able to login! > > > > > This is because you have cleartext passwords in your database, you should > > crypt your passwords before saving into MySQL. > > Cheers > > Giovanni > > -- > > [email protected] > > https://inverse.ca/sogo/lists > > > > > > -- > Best regards, > Odhiambo WASHINGTON, > Nairobi,KE > +254733744121/+254722743223 > "I can't hear you -- I'm using the scrambler." > -- > [email protected] > https://inverse.ca/sogo/lists > > -- > [email protected] > https://inverse.ca/sogo/lists -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 "I can't hear you -- I'm using the scrambler." -- [email protected] https://inverse.ca/sogo/lists
