Cyrus SASL SQL options

Berger, Stefan (IT - Management) stefan.berger at
Wed Jun 28 06:09:52 EDT 2006

it is not possible to rename a mysql user table to something like
domain.tld only domain without .tld works for renaiming


Ken Murchison schrieb:
> Berger, Stefan (IT - Management) wrote:
>> 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?
> I haven't tried such a config, but if you name your tables by domain, 
> something like this might work:
> sql_select: SELECT %p FROM %r WHERE username = '%u'

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

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 mailing list