Hi Patrick, thanks for your reply. Yes, I also thought about that. However, I'm
not sure whether postgres is really a good source for authentication. I think,
postgres is more designed as a relational database than a password storage,
whilst the saslauthdb's only purpose is storing passwords. In practice, when I
insert the entries into the postgres database with "insert into ... md5('...')
..." the passwords are shown on the screen in clear and saved in the history
file. That's why I would prefer using a password storage (saslauthdb) for
passwords. ;) Thanks, Mirko ============================= Patrick wrote: Mirko,
* [email protected] : > Hello community, for some reasons the mail I sent some
hours ago did not > make it neither to me nor to the archive. So I assume that
it got lost > somewhere and send it again this way. I apologize if my mail just
was stuck > somewhere. Here is the mail again: > Hello community, > > I am
currently > setting up a SOGo installation for a small company. At least the
mail > functionality is working so far for now, so that I came to setting up
all > the accounts. > > My exim and cyrus are configured to auth against SASL >
(backend: saslauthdb), whilst SOGo auths against a postgres db. >
Unfortunately, I didn't figure out how SOGo could auth against SASL which >
would save me adding each user twice. > > So my questions: Does SOGo support >
SASL? What would you prefer instead? > > Thanks > > Mirko have you considered
doing it the other way around using PostgreSQL as auth backend for SASL (and
letting exim and cyrus SASL auth against a PostgreSQL DB)? Something along
these lines: # GENERIC options pwcheck_method: auxprop auxprop_plugin: sql
mech_list: plain login cram-md5 digest-md5 # SQL auxprop plugin options
sql_engine: pgsql sql_hostnames: 127.0.0.1 sql_user: username sql_passwd:
secret sql_database: company sql_select: SELECT password FROM users WHERE user
= ´%...@´%r´ p...@rick -- state of mind Digitale Kommunikation
http://www.state-of-mind.de Franziskanerstraße 15 Telefon +49 89 3090 4664
81669 München Telefax +49 89 3090 4666 Amtsgericht München
Partnerschaftsregister PR 563
___________________________________________________________
WEB.DE DSL SOMMER-SPECIAL: Surf & Phone Flat 16.000 für
nur 19,99 €/mtl.!* http://produkte.web.de/go/DSL-Doppel-Flatrate/2
--
[email protected]
https://inverse.ca/sogo/lists
--
[email protected]
https://inverse.ca/sogo/lists
