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
