TOP-Post?
So, when there are so many possibilities, can someone post one or two of
them?
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
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
--
Stefan Berger
- Systemadministrator -
DIMA Systems AG
Nonnenstraße 39
04229 Leipzig
Tel.: +49 341 2668 - 0
Fax.: +49 341 2866 - 333
mailto: stefan.berger@xxxxxxxxxxxxxxx
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.
