21 Feb
2009
21 Feb
'09
12:13 a.m.
On Wed, 2009-02-18 at 10:47 -0800, Morton.Trust wrote:
Hello,
I have installed dovecot with MySQL in which the users are stored. Now I want to separate IMAP-Users from POP3-Users. So I added two columns to the user table (imap / pop3) which indicates, whether the user has access to IMAP or not.
In order to get dovecot recognizing this separation I put the auth-config into the two protocol-sections and wrote two different dovecot-sql.conf-files. In the dovecot-sql-pop3.conf the query searches for pop3=1 and in the dovecot-sql-imap.conf it searches for imap=1.
That doesn't work. But luckily for you, there's a simple way to implement this: Replace the imap=1 or pop3=1 with %s=1. %s gets expanded to imap or pop3.