[Dovecot] Wrong MySQL sintax, I can't login

Pablo boinker at gmail.com
Tue Aug 31 10:15:43 EEST 2010


Argh!

Two days looking at it...

Thank you very much Alec, and sorry :-(

2010/8/31 A.L.E.C <alec at alec.pl>:
> On 31.08.2010 08:42, Pablo wrote:
>
>> driver=mysql
>> connect = host=localhost dbname=postfix user=postfix password=xxxxxx
>> default_pass_scheme = CRYPT
>> password_query = SELECT password FROM mailbox WHERE username = '%u'
>> user_query = SELECT maildir, 1001 AS uid, 1001 AS gid FROM mailbox
>> WHERE username = '%u
>                    ^^^^
>
> No closing apostrophe here.
>
> --
> Aleksander 'A.L.E.C' Machniak http://alec.pl gg:2275252
> LAN Management System Developer http://lms.org.pl
> Roundcube Webmail Developer http://roundcube.net
>


More information about the dovecot mailing list