[Dovecot] about variables SOLVED

[alex]

On 07/20/2010 03:36 PM, alex wrote:
> 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

For whom may be interested, I've manage to come with a configuration for 
case when you wanna disable a service (pop/imap/smtp) for a certain user.
The password_query look like this:

SELECT crypt AS password FROM users WHERE email = '%u' AND \
		  (('%s' = 'imap' AND disableimap = '0')  OR \
		  ('%s' = 'pop3' AND disablepop3 = '0') OR \
		  ('%s' = 'smtp' AND smtpaccess = 'Y'))

or like this :

SELECT crypt AS password FROM users WHERE \
  		email = '%u' AND '%s' = 'imap' AND disableimap = '0' \
		UNION SELECT crypt AS password FROM users WHERE \
		email = '%u' AND '%s' = 'pop3' AND disablepop3 = '0' \
		UNION SELECT crypt AS password FROM users WHERE \
		email = '%u' AND '%s' = 'smtp' AND smtpaccess = '0'

Alex