Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs

[Rocky]

My main.cf looks like this:

# See /usr/share/postfix/main.cf.dist for a commented, more complete version

smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)
biff = no

# appending .domain is the MUA's job.
append_dot_mydomain = no

# Uncomment the next line to generate "delayed mail" warnings
#delay_warning_time = 4h

myhostname = server1.mcrirents.org
alias_maps = hash:/etc/aliases
alias_database = hash:/etc/aliases
myorigin = /etc/mailname
mydestination = server1.mcrirents.org, localhost, localhost.localdomain
relayhost =
mynetworks = 127.0.0.0/8
mailbox_command = procmail -a "$EXTENSION"
mailbox_size_limit = 0
recipient_delimiter = +
inet_interfaces = all
virtual_alias_domains =
virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, proxy:mysql:/etc/postfix/mysql-virtual_email2emai
l.cf
virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf
virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf
virtual_mailbox_base = /home/vmail
virtual_uid_maps = static:5000
virtual_gid_maps = static:5000
smtpd_sasl_auth_enable = yes
broken_sasl_auth_clients = yes
smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, reject_unauth_destination
smtpd_use_tls = yes
smtpd_tls_cert_file = /etc/postfix/smtpd.cert
smtpd_tls_key_file = /etc/postfix/smtpd.key
transport_maps = proxy:mysql:/etc/postfix/mysql-virtual_transports.cf
virtual_create_maildirsize = yes
virtual_mailbox_extended = yes
virtual_mailbox_limit_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailbox_limit_maps.cf
virtual_mailbox_limit_override = yes
virtual_maildir_limit_message = "The user you are trying to reach is over quota."
virtual_overquota_bounce = yes
proxy_read_maps = $local_recipient_maps $mydestination $virtual_alias_maps $virtual_alias_domains $virtual_mailbox_maps $virt
ual_mailbox_domains $relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps $recipient_canonical_maps $re
located_maps $transport_maps $mynetworks $virtual_mailbox_limit_maps
content_filter = amavis:[127.0.0.1]:10024
receive_override_options = no_address_mappings

[falko]

Ok, I guess these linebreaks are only in this forum, not in your file:

Originally Posted by Rocky

proxy_read_maps = $local_recipient_maps $mydestination $virtual_alias_maps $virtual_alias_domains $virtual_mailbox_maps $virt
ual_mailbox_domains $relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps $recipient_canonical_maps $re
located_maps $transport_maps $mynetworks $virtual_mailbox_limit_maps

What's in /etc/postfix/mysql-virtual_transports.cf?
Also, can you try to comment out

receive_override_options = no_address_mappings

in /etc/postfix/main.cf and restart Postfix?

[Rocky]

My mysql-virtual_transports.cf looks like this:

user = mail_admin
password = xxxxxxx
dbname = mail
table = transport
select_field = transport
where_field = domain
hosts = 127.0.0.1

I tried to comment out 'receive_override_options = no_address_mappings' but received the following:
Permanent Failure: 550_<malli@mcrirents.com>:_Recipient_address_rejec ted:_User_unknown_in_virtual_mailbox_table

[falko]

Can you double-check all your configuration files and compare them with the ones from the tutorial? Maybe you have a typo or something like this somewhere...

[Rocky]

I've compared my 6 config files and all seems correct. I did copy and paste the config information. I don't know what else could be wrong.

[Rocky]

Would it be better for me just to create all the mail users manually? Also, how do I lower the lever of spam identification?

[falko]

Originally Posted by Rocky

Would it be better for me just to create all the mail users manually?

You mean on the command line, without tools as phpMyAdmin? That makes no difference.

Originally Posted by Rocky

Also, how do I lower the lever of spam identification?

You can change that in the amavisd configuration file /etc/amavisd.conf, towards the end. Restart amavisd afterwards.

[Rocky]

What i meant was since the virtual setup is not allowing mails to pass through without the users being created, should i create the users or would it be better to try a re-install?

My setup is as follows:
Hosting domain is domainC
I have domainA entered in the domian table
I have smtp:[192.168.0.xx] entered in the transport table

If i didn't create the virtual users, shouldn't the server catch mails going to domainA and pass it over to my exchange? Or does it only work if the users are added to the virtual table?

[falko]

The transports worked for me without users being created...

[Rocky]

Falko I know that I'm being a pain about this setup but I really would like to implement this in my organizaton.

I reloaded the server and tried the following config:
Domain = domainA
Transport = domainA -> smtp:[192.168.0.xx]
This produced the error, the user does not exist in the virtual user table.

I then tried:
Domain = domainA
Transport = domainA -> smtp:[192.168.0.xx]
Forwarding = @domainA -> @domainA
This config allowed mails to be filtered and passed to my exchange without creating the users.

I checked my confiuration thorougly and every setting/configuraton seems correct. The question is, would my second configuration work without causing any problems?

I will eventually be filtering mails for domainA and domainB which will then be routed to my exchange server through the transport.

I was able to figure out how to change the spamassassin level check, thanks to you.