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