problem receiving mail dovecot (unknown user)

Hello,

i have problem receiving mail if i use dovecot-sql.conf as it comes, i.e.:

Code:

user_query = SELECT email as user, maildir as home, CONCAT('maildir:', maildir, '/Maildir') as mail, uid, gid, CONCAT('*:storage=', quota, 'B') AS quota_rule, CONCAT(maildir, '/.sieve') as sieve FROM mail_user WHERE (login = '%u' OR email = '%u') AND `[I][B]disable%Ls[/B][/I]` = 'n'

until i change `disable%Ls` to disablesmtp (or disablepop3, etc.) it won't work.

 

http://www.howtoforge.com/forums/showthread.php?t=59125

 

oh, i see, i had to remove backticks around disable%Ls.