Linode Forum
https://forum.linode.com/

Postfix, Courier, MySQL status=bounced
https://forum.linode.com/viewtopic.php?f=11&t=8400
Page 1 of 1

Author:  jawainc [ Wed Feb 08, 2012 12:50 pm ]
Post subject:  Postfix, Courier, MySQL status=bounced

Hi,
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

Code:
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



sending mail through mails , and in /var/log/mail.log

Code:
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)



/etc/postfix/main.cf

Code:
# 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

Author:  jawainc [ Wed Feb 08, 2012 6:01 pm ]
Post subject: 

OK... got it working

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

Author:  jawainc [ Wed Feb 08, 2012 7:17 pm ]
Post subject: 

OK.. SMTP problem solved

change /etc/postfix/sasl/smtpd.conf to

Code:
-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

Page 1 of 1 All times are UTC-04:00
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/