Virtual Users And Domains With Postfix, Courier And MySQL

[Anne_Kleyheeg]

/etc/postfix/main.cf

# 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 = ansmeijlink.nl
alias_maps = hash:/etc/aliases
alias_database = hash:/etc/aliases
myorigin = /etc/mailname
mydestination = ansmeijlink.nl, localhost
relayhost =
mynetworks = 127.0.0.0/8
mailbox_command = procmail -a "$EXTENSION"
mailbox_size_limit = 0
recipient_delimiter = +
inet_interfaces = all
virtual_alias_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf
virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.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 $virtual_mailbox_domains $relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps $recipient_canonical_maps $relocated_maps $transport_maps $mynetworks $virtual_mailbox_limit_maps
content_filter = amavis:[127.0.0.1]:10024
receive_override_options = no_address_mappings



Database = Mail
Table = Domains
Record = ansmeijlink.nl

[falko]

Originally Posted by Anne_Kleyheeg

/etc/postfix/main.cf

# 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 = ansmeijlink.nl
alias_maps = hash:/etc/aliases
alias_database = hash:/etc/aliases
myorigin = /etc/mailname
mydestination = ansmeijlink.nl, localhost
relayhost =
mynetworks = 127.0.0.0/8
mailbox_command = procmail -a "$EXTENSION"
mailbox_size_limit = 0
recipient_delimiter = +
inet_interfaces = all
virtual_alias_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf
virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.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 $virtual_mailbox_domains $relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps $recipient_canonical_maps $relocated_maps $transport_maps $mynetworks $virtual_mailbox_limit_maps
content_filter = amavis:[127.0.0.1]:10024
receive_override_options = no_address_mappings



Database = Mail
Table = Domains
Record = ansmeijlink.nl

You have ansmeijlink.nl in the domains table AND in the mydestination line! This doesn't work. You can list it either in the domains table or in mydestination, but not in both.

[Anne_Kleyheeg]

I have still 2 errors in my mail.log

Sep 25 14:32:57 localhost imaplogin: chdir ansmeijlink.nl/root/: No such file or directory
and
Sep 25 14:24:27 localhost postfix/qmgr[8977]: 079332F80DD: to=<root@ansmeijlink.nl>, relay=none, delay=1421, status=deferred (delivery temporarily suspended: connect to mail.ansmeijlink.nl[80.100.230.149]: Connection refused)

[Tr!n!Ty]

yes falko the user exist in the users table

[Tr!n!Ty]

falko i find the probleme i forget the postconf -e 'virtual_alias_domains ='
Now all work fine =)

[Tr!n!Ty]

oh noo i have a probleme with smtp SASL

Sep 26 14:31:18 sd-4319 postfix/smtpd[28068]: warning: SASL authentication failure: Password verification failed
Sep 26 14:31:18 sd-4319 postfix/smtpd[28068]: warning: unknown[x.x.x.x]: SASL PLAIN authentication failed
Sep 26 14:31:18 sd-4319 postfix/smtpd[28068]: warning: unknown[x.x.x.x]: SASL LOGIN authentication failed

I test to copy smtp.conf to /usr/lib/sasl2/
but in the smtp.conf there a files directory i havent it (/var/spool/authdaemon/socket)

pwcheck_method: authdaemond
log_level: 3
mech_list: PLAIN LOGIN
authdaemond_path:/var/spool/authdaemon/socket

thanks f or help

[falko]

Originally Posted by Tr!n!Ty

oh noo i have a probleme with smtp SASL

What's in /etc/default/saslauthd, /etc/pam.d/smtp, and /etc/postfix/sasl/smtpd.conf? Please compare those files with the ones from the tutorial.

[falko]

Originally Posted by Anne_Kleyheeg

I have still 2 errors in my mail.log

Sep 25 14:32:57 localhost imaplogin: chdir ansmeijlink.nl/root/: No such file or directory
and
Sep 25 14:24:27 localhost postfix/qmgr[8977]: 079332F80DD: to=<root@ansmeijlink.nl>, relay=none, delay=1421, status=deferred (delivery temporarily suspended: connect to mail.ansmeijlink.nl[80.100.230.149]: Connection refused)

Please open a new thread for this, otherwise this one will become too confusing.

[Tr!n!Ty]

In /etc/default/saslauthd

START=yes
MECHANISMS="pam"
PARAMS="-m /var/spool/postfix/var/run/saslauthd -r"

In /etc/pam.d/smtp

auth required pam_mysql.so user=mail_admin passwd=mysql_password host=127.0.0.1 db=mail table=users usercolumn=email passwdcolumn=password crypt=1
account sufficient pam_mysql.so user=mail_admin passwd=mysql_password host=127.0.0.1 db=mail table=users usercolumn=email passwdcolumn=password crypt=1

in /etc/postfix/sasl/smtpd.conf

pweck_method: saslauthd
mech_list: plain login
allow_plaintext: true
auxprop_plugin: mysql
sql_hostnames: 127.0.0.1
sql_user: mail_admin
sql_passwd: mysql_password
sql_database: mail
sql_select: select password from users where email = '%u'

[falko]

Looks ok. Are you sure you use the correct username (must be an email address) and password?