On 07/20/2010 11:31 AM, Arne K. Haje wrote:
Tirsdag 20. juli 2010 09.31.51 skrev alex :
Hi
In http://wiki.dovecot.org/Variables I found: %s service imap, pop3, smtp, deliver and that can be use in userdb and SQL query string.
How exactly can I use %s in the query string if I want for ex to disable a service (just one service - ex pop3) for a specific user.
Alex
While I've not tried it, I guess you could do something like this in the SQL query;
".. AND service=('%s' OR 'all')"
You could set the default value of service column to 'all', but set it to 'imap' for users that can only use that service.
Arne
How about "...AND %s in (services)" and the services column will be something like 'imap,pop3,smtp,deliver' => "...AND %s in (imap,pop3,smtp,deliver)" For the user that do not have , let say imap, the services will be (pop3,smtp,deliver)
Further more : the postfix server use the dovecot auth. It is possible for an account to disable the smtp auth (the user won't be able to send any emails but will be able to receive an read )?
Alex