[Dovecot] sql : uid, gid, home ignored ?

[Nick Edwards]

On Sat, Jan 29, 2011 at 9:26 PM, Eric Diaz Fernandez <eric.diaz at skynet.be>wrote:

> Hello,
>
> I'm trying to setup a dovecot imap server.
>
> version is 2.0.9
> I've setup a mysql database using:
>
> user_query = \
>    SELECT home, uid, gid, home as userdb_home, uid as userdb_uid, gid as
> userdb_gid, \
>    FROM user WHERE username = '%n' AND domain = '%d' AND active = 'Y'
>
>

Your SQL statement is incorrect, try:

user_query =  SELECT userdb_home as home, userdb_uid as uid, userdb_gid as
gid, \
   FROM user WHERE username = '%n' AND domain = '%d' AND active = 'Y'



nick