---------

create noreply email id in postfixadmin mysql database

tep 1: Open the postfixadmin web interface in your browser

Step 2: Click on “Virtual list” then click on “Add Mailbox” .

Create an email id with name called noreply or donotreply .

Step 3 After creating the email id from postfix admin login into your mail server or the server where postfixadmin’s mysql server is located .

Login into mysql server

mysql -u root -p  (Here postfix is database name for postfixadmin, replace the database name as per your mysql details for postfixadmin)  mysql> use postfixadmin ;  (Replace noreply@emaildomain.com with your noreply email id)  mysql> select * from alias where address='noreply@emaildomain.com';  +------------------------------+-------------------------------+------------------+---------------------+-------------------+--------+ | address                      | goto                          | domain           | created             | modified          | active| +------------------------------+-------------------------------+------------------+---------------------+-------------------+--------+ | noreply@emaildomain.com      | noreply@emaildomain.com      | emaildomain.com | 2013-06-25 04:41:55 | 2013-06-25 04:41:55 |      1 | +-------------------------------+-------------------------------+------------------+---------------------+-------------------+--------+ 6 rows in set (0.00 sec)  mysql>mysql> update alias set goto='devnull' where address='noreply@emaildomain.com';mysql> select * from alias where address='noreply@emaildomain.com'; +--------------------------+---------+------------------+---------------------+---------------------+--------+ | address                  | goto    | domain           | created             | modified            | active | +--------------------------+---------+------------------+---------------------+---------------------+--------+ | noreply@emaildomain.com  | devnull | emaildomain.com  | 2013-06-25 04:41:55 | 2013-06-25 04:41:55 |      1 | +--------------------------+---------+------------------+---------------------+---------------------+--------+ 1 row in set (0.00 sec)   mysql> exit;

In my case,I have set alias file path in postfix main.cf . Hence I will do changes in /etc/aliases file.

Check your main.cf file of postfix and do the changes in that file.

root@mail: vi /etc/postfix/alias

alias_maps = hash:/etc/postfix/aliases

alias_database = hash:/etc/postfix/aliases

virtual_alias_maps = mysql:/etc/postfix/sql/mysql_virtual_alias_maps.cf

root@mail:/etc/postfix#

Step 4 : Edit the alias file and write down alias for devnull

vi /etc/postfix/aliases  devnull: /dev/null

Step 5: Now run the command newaliases and restart the postfix (optional)

newaliases

Step 6: Now send a test email to noreply email id. The email should go to /dev/null . Means it will not go to inbox.

Below one is the mail server log details, see in last line it will give status “delivered to file: /dev/null”

Jul 1 06:27:03 mail postfix/qmgr[17117]: DF29E60752: from=<sender@gmail.com>, size=2014, nrcpt=1 (queue active)

Jul 1 06:27:03 mail postfix/local[17130]: DF29E60752: to=<devnull@mail.emaildomain.com>, orig_to=<noreply@emaildomain.com>, relay=local, delay=3.3, delays=3.3/0/0/0, dsn=2.0.0, status=sent (delivered to file: /dev/null)

FAQ

What is /dev/null ?

In Unix-like operating systems, /dev/null or the null device is a special file that discards all data written to it but reports that the write operation succeeded. It provides no data to any process that reads from it, yielding EOF immediately 

----------