Cyrus SASL SQL options

[Berger, Stefan (IT - Management)]

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?

Stefan


Andreas Winkelmann schrieb:
> Berger, Stefan (IT - Management) sagte:
> 
>> Hi Cyrus User,
>>
>> i'am running cyrus imap/sasl with postfix and MySQL for user
>> authentification for 2 years. Now, new virtual domains were added and a
>> lot of new users have to organize. I want use different mysql tables for
>> user data but there is my problem. Is it possible to tell cyrus imap and
>> sasl to look in different mysql tables? When yes, can someone post an
>> example?
> 
> Please explain, where you see the diffrence between Cyrus-Imap and
> Cyrus-SASL in accessing a MySQL-Table for "Userdata"?
> 
> Maybe you mean Postfix and Cyrus-Imapd?
> 
> Then you can separate them in sql_select in smtpd.conf and /etc/imapd.conf.
> 
> --
> Andreas

-- 
Stefan Berger

- Systemadministrator -

DIMA Systems AG
Nonnenstraße 39
04229 Leipzig

Tel.:   +49 341  2668 - 0
Fax.:   +49 341  2866 - 333
mailto: stefan.berger at dima-systems.de
         www.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.