[Dovecot] Authentication problems with mysql 5

[Gianfranco Bartolini]

> -----Original Message-----
> From: dovecot-bounces at dovecot.org 
> [mailto:dovecot-bounces at dovecot.org] On Behalf Of Dumitru Negara
> Sent: Saturday, June 17, 2006 12:30 PM

Hi Dumitru,
 
> No, it looks ok. The only thing I can suggest is to change a line in 
> dovecot-sql.conf from
> 
> user_query = SELECT maildir AS mail, 51 AS uid, 51 AS gid 
> FROM mailbox WHERE username = '%u' AND active = '1'
> 
> to
> 
> user_query = SELECT maildir AS mail, SELECT maildir, 
> CONCAT('/home/mbox',maildir) AS home, 51 AS uid, 51 AS gid 
> FROM mailbox WHERE username = '%u' AND active = '1'

Ok, thanks for your hint, now it works well with the line below:

user_query = SELECT maildir, CONCAT('/home/mbox/',maildir) AS mail, 51 AS
uid, 51 AS gid 
FROM mailbox WHERE username = '%u' AND active = '1'

I didn't realized why dovecot ignore the directory prefix, but that's it.

Thanks again for your kindly support!

Saluti
G.Bartolini
Linux User #333064