Hi all, Thank you for your useful advises. I found the problem is mailbox and maildir ( just / in maildir database record).
Thank again for your help. On Wed, Jun 30, 2010 at 8:50 AM, Makara <chanmak...@gmail.com> wrote: > Hi All, > > Thank for your reply, I have fixed the path problem but I still have the > problem something like the log > > I use query 2 > > log file: > > Jun 30 08:48:32 centos-vm postfix/virtual[16725]: E66D137ACE: to=< > mak...@khmerict.com>, relay=virtual, delay=0.08, delays=0.06/0.01/0/0.01, > dsn=4.2.0, status=deferred (delivery failed to mailbox /home/vmail/ > khmerict.com/makara: unable to create lock file /home/vmail/ > khmerict.com/makara.lock: No such file or directory) > > > I read the instruction as advise > http://www.pubbs.net/200909/postfix/114776-postfixvirtual-still-not-working.html > so I create khmerict.com folder in /home/vmail/khmerict.com/. > > > -----------It work fine-------------------- > > > but I still wonder with the queries: > > [r...@centos-vm vmail]# cat /etc/postfix/mysql-virtual-mailbox-maps.cf > 1/ #query = SELECT > CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') > FROM mailbox WHERE email='%s' AND active=1 > > 2/ query = SELECT maildir FROM mailbox WHERE email='%s' AND active=1. > > If I use query 1 I don't need to create domain folder in > /home/vmail/<domain> but with query 2 I have to create /home/vmail/<domain> > > Even I can fix the problem but I still hope someone will explain me about > this case > > > -- > The person who loves others will also be loved. > -- The person who loves others will also be loved.
