[Dovecot] Authentication problems with mysql 5

[Dumitru Negara]

Hi Gianfranco,

Gianfranco Bartolini wrote:
>> -----Original Message-----
>> From: Dumitru Negara [mailto:dumitru at itcnetworks.ro] 
>> Sent: Friday, June 16, 2006 9:40 AM
>>     
>
> Hello Dumitru,
>
>   
>> First, tell me few things:
>>
>> 1. Output of command
>> #cat /PATH/TO/POSTFIX_DIR/main.cf | grep virtual
>>     
>
> Ok
>
> ==========================
> virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf
> virtual_gid_maps = static:51
> virtual_mailbox_base = /home/mbox
> virtual_mailbox_domains = mysql:/etc/postfix/mysql_virtual_domains_maps.cf
> virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
> virtual_minimum_uid = 51
> virtual_transport = virtual
> virtual_uid_maps = static:51
> ==========================
>  
>   
>> 2. Output of command
>> #cat /PATH/TO/POSTFIXADMIN_DIR/config.inc.php | grep domain_in_mailbox
>>     
>
> ==========================
> $CONF['domain_in_mailbox'] = 'YES';
> ==========================
>
> For your information:
>
> ==========================
> server01:~ # id postfix
> uid=51(postfix) gid=51(postfix) groups=51(postfix)
> ==========================
>
> Do you think there's something wrong?
>
> Saluti
> G.Bartolini
> Linux User #333064 
>
>   
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'

Regards,
Dumitru