Cyrus SASL SQL options
Berger, Stefan (IT - Management)
stefan.berger at dima-systems.com
Fri Jun 30 02:43:46 EDT 2006
So, when there are so many possibilities, can someone post one or two of
Andreas Winkelmann schrieb:
> 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.
- Systemadministrator -
DIMA Systems AG
Tel.: +49 341 2668 - 0
Fax.: +49 341 2866 - 333
mailto: stefan.berger at dima-systems.de
This e-mail may contain information that is privileged and confidential.
The information is intended only for the use of the addressee. If you
are not the intended recipient, you are hereby notified that any
dissemination of this communication is strictly prohibited and may be
unlawful. If you have received this e-mail in error, please notify DIMA
Systems AG immediately and erase all copies of the message.
More information about the Cyrus-sasl