Cyrus SASL SQL options
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
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
Look for union or views or maybe stored procedures.
More information about the Cyrus-sasl