Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

postfix virtual user problem

500 views
Skip to first unread message

Makara

unread,
Jun 29, 2010, 4:04:34 AM6/29/10
to
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>, 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: unable to create lock file /home/vmail//home/vmail/khmerict.com/makara.lock: No such file or directory)

I found that the problem is because of the file 

[root@centos-vm vmail]# cat /etc/postfix/mysql-virtual-mailbox-maps.cf 
hosts    = localhost
dbname   = postfix
user     = postfixuser
password = xxxxxx

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.

Why query 2 doesn't work, could anyone kindly explain me why?


The main.cf file

[root@centos-vm vmail]# cat /etc/postfix/main.cf

myhostname      = mail.khmerict.com
mydomain        = khmerict.com
mynetworks      = 192.168.0.0/24, 10.10.10.0/24
mydestination   = $myhostname, localhost.$mydomain, localhost

home_mailbox    = Maildir/


### Virtual mailbox config

virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf
virtual_mailbox_maps    = proxy:mysql:/etc/postfix/mysql-virtual-mailbox-maps.cf
virtual_mailbox_base   = /home/vmail
virtual_mailbox_limit   = 20480000
virtual_uid_maps = static:101
virtual_gid_maps = static:102
virtual_transport = virtual
 
--
The person who loves others will also be loved.

mouss

unread,
Jun 29, 2010, 8:06:52 PM6/29/10
to
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]

Makara

unread,
Jun 29, 2010, 9:50:51 PM6/29/10
to
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)


so I create khmerict.com folder in /home/vmail/khmerict.com/. 


-----------It work fine--------------------


but I still wonder with the queries:

[root@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

Makara

unread,
Jun 30, 2010, 12:45:55 AM6/30/10
to
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.

mouss

unread,
Jun 30, 2010, 6:37:41 PM6/30/10
to
Makara a écrit :

> Hi all,
>
> Thank you for your useful advises. I found the problem is mailbox and
> maildir ( just / in maildir database record).
>

If I understand it, it was a lackig slash, right?
(I personally don't like the slash convention. I would prefer a
type:path syntax. I mean maildir:/foo/bar and mailbox:/foo/bar...).

> Thank again for your help.

you're welcome. if you find it nice to see people help you, I find it
great to see nice people we can help (and who actually help "indirectly").

0 new messages