Postfix Mysql Courier How To

[oliverp]

Hi guys, I have been following this tutorial about using postfix and mysql.

http://www.howtoforge.com/virtual-users-and-domains-postfix-courier-mysql-fedora8-p4
My problem is when i telnet localhost 25 i get

# telnet localhost 25
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.

and then no matter what i type nothing happens. I cannot quit, ehlo localhost or anything. other than that, the tutorial was a complete success.

[till]

Please enter:

ehlo localhost

and then hit the return key to get the smtp options listed. If you want to quit the connectione, enter:

quit

and hit return. If this all wont work, hit the keys [ctrl] + [c]

[oliverp]

Hi tim thanks but the problem is that I can't enter any commands. I get as far as above then no more. I followed the tutorial to the letter and my postfix does not respond after I telnet.

[falko]

Any errors in your mail log? What's in /etc/postfix/main.cf?

[oliverp]

hi there, my /var/log/maillog has these errors



Dec 3 18:33:35 caprice postfix/proxymap[23418]: fatal: unsupported dictionary type: mysql
Dec 3 18:33:36 caprice postfix/smtpd[5353]: warning: private/proxymap socket: service dict_proxy_open: Success
Dec 3 18:33:36 caprice postfix/master[5348]: warning: process /usr/libexec/postfix/proxymap pid 23418 exit status 1
Dec 3 18:33:36 caprice postfix/master[5348]: warning: /usr/libexec/postfix/proxymap: bad command startup -- throttling

and my main.cf says...

queue_directory = /var/spool/postfix
command_directory = /usr/sbin
daemon_directory = /usr/libexec/postfix
mail_owner = postfix
inet_interfaces = all
mydestination = mail.mydomain.com.au, localhost, localhost.localdomain
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.4.5/samples
readme_directory = /usr/share/doc/postfix-2.4.5/README_FILES
myhostname = mail.mydomain.com.au
mynetworks = 127.0.0.0/8
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_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
smtpd_enforce_tls = no
smtpd_tls_loglevel = 1
smtpd_use_tls = yes
smtpd_tls_key_file = /etc/postfix/smtpd.key
smtpd_tls_cert_file = /etc/postfix/smtpd.cert


the hostnames are in the /etc/hosts file.

postconf -m reveals

btree
cidr
environ
hash
ldap
nis
pcre
proxy
regexp
static
unix


Thanks for your help

[AceSimple]

I have the same problem...

What to do??


Thanks Marco

[falko]

Dec 3 18:33:35 caprice postfix/proxymap[23418]: fatal: unsupported dictionary type: mysql
This means that your Postfix doesn't have MySQL support. Did you see any errors when you compiled it with the quota patch?