From: Jim Hoy (jim.hoygmail.com)
Date: Fri Apr 25 2008 - 23:55:21 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

On 4/26/08, mouss <moussnetoyen.net> wrote:
> Jim Hoy wrote:
>
> > I've been having problems with postfix + dovecot + mysql/postfixadmin
> > for a few weeks now. I would find out the main problem I had was the
> > version of Postfix I inherited was not compiled with dovecot OR mysql
> > support. I now have that rectified and I am able to send mail OUT from
> > my virtual accounts, but I am not able to receive email from the
> > outside to any of my virtual accounts. Here is my postconf -n and
> > MySQL Config files. What else would one need to help diagnose my
> > problem; I'll provide anything....
> >
> >
>
> logs showing the problem. see other comments below.
>
> >
> > broken_sasl_auth_clients = yes
> > command_directory = /usr/sbin
> > config_directory = /etc/postfix
> > daemon_directory = /usr/libexec/postfix
> > data_directory = /var/lib/postfix
> > debug_peer_level = 2
> > html_directory = no
> > inet_interfaces = all
> > mail_owner = postfix
> > mailq_path = /usr/bin/mailq
> > manpage_directory = /usr/local/man
> > mydestination = mysql:/etc/postfix/mysql_virtual_domains_maps.cf
> >
> >
>
> do not mix domain classes. mydestination is not for virtual domains. fix this.
>
>
> > [snip]
> > virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_domains_maps.cf
> >
> >
>
> you probably mean .../mysql_virtual_alias_maps.cf
>
>
> > virtual_gid_maps = static:89
> > virtual_mailbox_base = /vmail
> > 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 = 89
> > virtual_transport = virtual
> > virtual_uid_maps = static:89
> >
> >
> >
> > MySQL FILES:
> >
> > ***mysql_virtual_alias_maps.cf:***
> > user = ***
> > password = ***
> > hosts = 127.0.0.1
> > dbname = postfix
> > query = SELECT goto FROM alias WHERE address='%s'
> >
> > ***mysql_virtual_domain_maps.cf***
> > user = ***
> > password = ***
> > hosts = 127.0.0.1
> > dbname = postfix
> > query = SELECT domain FROM domain WHERE domain = '%d' and backupmx =
> > '0' and active = '1'
> >
> > ***mysql_virtual_mailbox_maps.cf***
> > user = postfix
> > password = postfix
> > hosts = 127.0.0.1
> > dbname = postfix
> > query = SELECT maildir FROM mailbox WHERE username = '%u'
> >
> >
>
> so you ignore the domain part??? if the username field contains the full mailbox name, then use '%s'. otherwise, adjust your query to use both '%u' and '%d'.
>

I think what you noticed from my postconf -n was a result of my
tinkering... It wasn't working even when configured properly...

In the query, I am using '%s' as the username is uservirtual.com.

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]