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

On Sat, Jan 29, 2011 at 9:26 PM, Eric Diaz Fernandez <eric.diaz@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