Postfix, Courier, MySQL status=bounced
I've installed Postfix, Courier to work with MySQL and getting mail bounced error when using mailx. When i use mailx to send mail to external mail it works.
Also when when i send mail from external mail i got it back with following message
This is the mail system at host jawainc.aqoo.com.
I'm sorry to have to inform you that your message could not
be delivered to one or more recipients. It's attached below.
For further assistance, please send mail to postmaster.
If you do so, please include this problem report. You can
delete your own text from the attached returned message.
The mail system
<sales@ticketsbag.com>: mail for mail.ticketsbag.com loops back to myself
Final-Recipient: rfc822; sales@ticketsbag.com
Original-Recipient: rfc822;sales@ticketsbag.com
Action: failed
Status: 5.4.6
Diagnostic-Code: X-Postfix; mail for mail.ticketsbag.com loops back to myself</sales@ticketsbag.com>
sending mail through mails , and in /var/log/mail.log
postfix/smtp[3042]: DA14925712: to=<postmaster@ticketsbag.com>, orig_to=<root@jawainc.aqoo.com>, relay=none, delay=0.01, delays=0/0/0/0, dsn=5.4.6, status=bounced (mail for mail.ticketsbag.com loops back to myself)</root@jawainc.aqoo.com></postmaster@ticketsbag.com>
/etc/postfix/main.cf
# See /usr/share/postfix/main.cf.dist for a commented, more complete version
# Debian specific: Specifying a file name will cause the first
# line of that file to be used as the name. The Debian default
# is /etc/mailname.
#myorigin = /etc/mailname
smtpd_banner = $myhostname ESMTP $mail_name (Ubuntu)
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
readme_directory = /usr/share/doc/postfix
# TLS parameters
smtpd_tls_cert_file = /etc/postfix/smtpd.cert
smtpd_tls_key_file = /etc/postfix/smtpd.key
smtpd_use_tls = yes
smtpd_tls_session_cache_database = btree:${data_directory}/smtpd_scache
smtp_tls_session_cache_database = btree:${data_directory}/smtp_scache
# See /usr/share/doc/postfix/TLS_README.gz in the postfix-doc package for
# information on enabling SSL in the smtp client.
myhostname = jawainc.aqoo.com
alias_maps = hash:/etc/aliases
alias_database = hash:/etc/aliases
myorigin = /etc/mailname
mydestination = jawainc.aqoo.com, localhost, localhost.localdomain
relayhost =
mynetworks = 127.0.0.0/8
mailbox_size_limit = 0
recipient_delimiter = +
inet_interfaces = all
html_directory = /usr/share/doc/postfix/html
virtual_alias_domains =
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_sasl_authenticated_header = yes
smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, reject_unauth_destination
transport_maps = proxy:mysql:/etc/postfix/mysql-virtual_transports.cf
virtual_create_maildirsize = yes
virtual_maildir_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
Also by sending 1st mail it would create folder for mails in /home/vmail/ but its not creating any folder
any idea wats the problem
2 Replies
emptying the tables 'transport' and 'forwardings' in mail database fix the problem.
How can i forward mails ?
Also in ThunderBird mail client unable to send mail it gives SMTP error.
Any idea how to fix that
change /etc/postfix/sasl/smtpd.conf to
-mech_list: plain login
+mech_list: plain login pam
allow_plaintext: true
-auxprop_plugin: mysql
+auxprop_plugin: sql
+sql_engine: mysql
sql_hostnames: 127.0.0.1
sql_user: [REMOVED]
sql_passwd: [REMOVED]
sql_database: [REMOVED]
-sql_select: select password from mail_user where email = '%u'
+sql_select: select password from mail_user where login = '%u@%r'
**
remove those lines with minus sign
add lines with plus sign