Cyrus SASL SQL options
Andreas Winkelmann
ml at awinkelmann.de
Thu Jun 29 12:49:18 EDT 2006
Berger, Stefan (IT - Management) sagte:
Do not Top-Post.
> i use sql authentification in cyrus imap (imapd.conf) and in postfix
> (cyrus sasl in smtpd.conf). Now i want modify the select from.... entry
> because users of different virtual domains are stored in differetn in
> tables but in same database.
> In the moment imapd.conf looks so:
>
> sasl_sql_select: SELECT password FROM mailusers WHERE account = '%u@%r'
>
> table mailusers containd all valid email accountss but now i have
> 2,3,4,5 tables with email accounts. so can i make 2,3,4,5 sas_sql_select
> entries?
No, only one sql_select per Application.
But there are diffrent possible ways to solve this with SQL. But
everything depends on your mysql-Version, Structure of the Tables and so
on...
Look for union or views or maybe stored procedures.
--
Andreas
More information about the Cyrus-sasl
mailing list