Cyrus SASL SQL options

Andreas Winkelmann ml at
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

Look for union or views or maybe stored procedures.


More information about the Cyrus-sasl mailing list