How to configure postfix with mysql?

Electro-X · 02-16-2010, 07:37 AM

Hi
have want to create a mail server with postfix and mysql.
When i try to send mail with telnet i receive a error message :

Code:

telnet serveur2 25
Trying 127.0.0.1...
Connected to localhost.localdomain (127.0.0.1).
Escape character is '^]'.
220 serveur2.MYDOMAIN.fr ESMTP Postfix
HELO ser
250 serveur2.MYDOMAIN.fr
MAIL FROM: <root@MYDOMAIN.fr>
250 2.1.0 Ok
RCPT TO: <elec@MYDOMAIN.fr>
550 5.1.1 <elec@MYDOMAIN.fr>: Recipient address rejected: User unknown in local recipient table
421 4.4.2 serveur2.MYDOMAIN.fr Error: timeout exceeded
Connection closed by foreign host.

This is my main.cf

Code:

queue_directory = /var/spool/postfix
command_directory = /usr/sbin
daemon_directory = /usr/libexec/postfix
mail_owner = postfix
inet_interfaces = all
myhostname = serveur2.MYDOMAIN.fr
mydomain = MYDOMAIN.fr
mydestination = $myhostname, localhost.$mydomain, localhost, $mydomain
unknown_local_recipient_reject_code = 550
alias_maps = hash:/etc/aliases
alias_database = hash:/etc/aliases
debug_peer_level = 2
debugger_command =
         PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin
         xxgdb $daemon_directory/$process_name $process_id & sleep 5
sendmail_path = /usr/sbin/sendmail.postfix
newaliases_path = /usr/bin/newaliases.postfix
mailq_path = /usr/bin/mailq.postfix
setgid_group = postdrop
html_directory = no
manpage_directory = /usr/share/man
sample_directory = /usr/share/doc/postfix-2.3.3/samples
readme_directory = /usr/share/doc/postfix-2.3.3/README_FILES
virtual_alias_maps = mysql:/etc/postfix/mysql_virtual
virtual_mailbox_domains = $mydomain
virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox
virtual_mailbox_base = /home/vmail/
virtual_uid_maps = static:5000
virtual_gid_maps = static:5000
virtual_transport = virtual

in my database i have this user "elec@MYDOMAIN.fr"

Someone have a solution for my problem??

EDIT : my server use CentOS 5.4 with postfix in CentosPlus (compil with mysql and postgres support)

Sorry for my english, i'm french.

spampig · 02-16-2010, 01:42 PM

I am not sure if this is OK 'virtual_mailbox_domains = $mydomain' ?

Does:

postmap -q "elec@MYDOMAIN.fr" mysql:/etc/postfix/mysql_virtual_mailbox

work?

Is mysql getting the query?
TIP: Enable query logging in my.cnf

What are the contents of the file mysql_virtual_mailbox?

Noway2 · 02-17-2010, 05:11 AM

Looking at my postfix configuration, which uses mysql, I see a few differences: virtual_mailbox_maps = proxy:mysql:$config_directory/mysql_virtual_mailbox_maps.cf and virtual_mailbox_domains = proxy:mysql:$config_directory/mysql_virtual_domains_maps.cf

The other thing you need to look VERY closely at is what is in the .cf files, especially if you copied from a how to document. Two things I had trouble with are ` versus ' which wordpress mixes up and trailing blank spaces at the line ends.