Odhiambo Washington <odhia...@gmail.com>, wrote: Thank you, Sebastian. After knowing that I can use /etc/sogo/sogo.conf and > after installing sope-mysql-5.9.1, life should be a lot easier for Mark. > It's a matter of creating the VIEW to be used by SOGo for authenticating > the users from the MySQL database. > In my database I created it as follows: > USE exim4u; > CREATE VIEW sogo_auth_view AS SELECT user_id AS sogo_id, username AS > c_uid, username AS c_name, crypt AS c_password, realname AS c_cn, username > AS mail, realname AS displayName FROM users WHERE enabled='1'; > EXIT; > > The VIEW is used in sogo.conf as per the tutorial referred to before. > >
Thank you so much, Odhiambo for the idea. Two questions; 1- My password scheme in my database is BLF-CRYPT (blowfish), should I mention this for the CREATE VIEW command? (reading that you put crypt AS c_password) 2- You created "sogo_auth_view" it seems, however the tutorial you sent does it for "sogo_view", why so? Much regards, Mark.
