Makara a écrit :
> Hi All,
>
> I try to configure postfix virtual user with mysql. I got the problem
> log below
>
> Jun 29 14:47:48 centos-vm postfix/virtual[4714]: A043137ACA:
> to=<mak...@khmerict.com <mailto:mak...@khmerict.com>>, relay=virtual,
> delay=305, delays=304/1/0/0.02, dsn=4.2.0, status=deferred (delivery
> failed to mailbox /home/vmail//home/vmail/khmerict.com/makara
> <http://khmerict.com/makara>: unable to create lock file
> /home/vmail//home/vmail/khmerict.com/makara.lock
> <http://khmerict.com/makara.lock>: No such file or directory)
>
oh please, with gmail, click on the "text" button" (while I only see
your <http...> silly things, some readers here will only see that. which
makes your message unreadable for these guys).
does /home/vmail/home/vmail/khmerict.com/ exist as a directory? the fact
that "/home/vmail" is repeated indicated an issue. make sure your maps
return a relative directory or set
virtual_mailbox_base = /
> I found that the problem is because of the file
>
> [snip]
> 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
>
>
> but I still understand what is the different the query 1 and query 2
> return the same result.
If you think they return the same result, yet you think one works and
the other does not, then you need some tea.
please copy-paste the results of each query here. note that a slash
('/') changes a lot of things.
> [snip]
