dovecot - Jan 2011 - sql : uid, gid, home ignored ?

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'

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

(I get the information with and without the userdb_ prefix since I was not sure
what was needed)

When I login, I see the password_query in the debug log and it says:

client out: OK 1 user=theuser home=/home/theuser uid=1000 gid=1000
master in: REQUEST 547880961 10068 1 e6...(hexadecimal stuff)
master out: USER 547880961 theuser

But in the mail.err log i see:
dovecot: imap(theuser): Error: user theuser: Couldn't drop privileges: User
is missing UID (see mail_uid setting)
dovecot: imap(theuser): Error: Internal error occurred.  Refer to server log for
more information.

The same two lines are also displayed in mail.info and mail.log

Further testing (setting mail_uid & mail_gid to a nobody) shown that the
home setting was ignored too.

The sql example says that uid and gid are supposed to be an override of the
mail_uid and mail_gid settings.
Any idea of why the columns are ignored ?

Thanks in advance,


Eric

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

> >
> >    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
>
(I sent the first mail with an address not registred with the mailing list)

Thank you Nick, but it didn't changed a thing. (I guess dovecots ignores  
columns with unknown names)

When I connect I still get:

==> mail.err <=Jan 30 11:06:12 mail.mysite.com dovecot: imap(theuser):
Error: user
theuser: Couldn't drop privileges: User is missing UID (see mail_uid  
setting)
Jan 30 11:06:12 mail.mysite.com dovecot: imap(theuser): Error: Internal  
error occurred. Refer to server log for more information.

==> mail.info <=Jan 30 11:06:12 mail.mysite.com dovecot: imap-login:
Login:
user=<theuser>, method=PLAIN, rip=1.2.3.4, lip=5.6.7.8, mpid=9298, TLS
Jan 30 11:06:12 mail.mysite.com dovecot: imap(theuser): Error: user  
theuser: Couldn't drop privileges: User is missing UID (see mail_uid  
setting)
Jan 30 11:06:12 mail.mysite.com dovecot: imap(theuser): Error: Internal  
error occurred. Refer to server log for more information.

==> mail.log <=Jan 30 11:06:12 mail.mysite.com dovecot: imap-login: Login:
user=<theuser>, method=PLAIN, rip=1.2.3.4, lip=5.6.7.8, mpid=9298, TLS
Jan 30 11:06:12 mail.mysite.com dovecot: imap(theuser): Error: user  
theuser: Couldn't drop privileges: User is missing UID (see mail_uid  
setting)
Jan 30 11:06:12 mail.mysite.com dovecot: imap(theuser): Error: Internal  
error occurred. Refer to server log for more information.

==> mail.warn <=Jan 30 11:06:12 mail.mysite.com dovecot: imap(theuser):
Error: user
theuser: Couldn't drop privileges: User is missing UID (see mail_uid  
setting)
Jan 30 11:06:12 mail.mysite.com dovecot: imap(theuser): Error: Internal  
error occurred. Refer to server log for more information.

==> dovecot-debug.log <=2011-01-30 11:06:12auth: Debug: client in: AUTH 1 
PLAIN
service=imap    secured lip=5.6.7.8        rip=1.2.3.4       
lport=143       rport9863
2011-01-30 11:06:12auth: Debug: client out: CONT        1
2011-01-30 11:06:12auth: Debug: client in: CONT 1        
AGh1cnJpY2FuZQBka3NtdDExJA=2011-01-30 11:06:12auth: Debug: sql(theuser at
mysite.com,1.2.3.4): query:
SELECT username AS user, password, home AS userdb_home, uid AS userdb_uid,  
id AS userdb_gid, home, uid, gid FROM user WHERE username = 'theuser'
AND
domain = 'mysite.com' AND active = 'Y'
2011-01-30 11:06:12auth: Debug: auth(theuser at mysite.com,1.2.3.4): username  
changed theuser at mysite.com -> theuser
2011-01-30 11:06:12auth: Debug: auth(theuser at mysite.com,1.2.3.4): username  
changed theuser at mysite.com -> theuser
2011-01-30 11:06:12auth: Debug: client out: OK  1       user=theuser   
home=/home/theuser    uid=2000        gid=1000
2011-01-30 11:06:12auth: Debug: master in: REQUEST      1628045313       
9246    1       926873f8d25265e8b06ad56f5ac8ba9d
2011-01-30 11:06:12auth: Debug: master out: USER        1628045313       
theuser

The debug shows the right home, uid, gid for the user but it seems it does  
not cares about that afterwards.

The error only disappears when I set the global mail_uid and mail_gid but  
that's not what I need.  I need to be able to use a specific uid/gid/home  
for each account.

Weird.

Regards,

Eric