Postfix error: fatal: unsupported dictionary type: mysql -- throttling
 

CENTOS5.3 - ISPCONFIG3.0.1.1

errors or warning given at syslog:

May 5 17:45:19 server postfix/master[3463]: warning: /usr/libexec/postfix/qmgr: bad command startup -- throttling
May 5 17:45:46 server postfix/smtpd[18923]: fatal: unsupported dictionary type: mysql
May 5 17:45:47 server postfix/master[3463]: warning: process /usr/libexec/postfix/smtpd pid 18923 exit status 1
May 5 17:45:47 server postfix/master[3463]: warning: /usr/libexec/postfix/smtpd: bad command startup -- throttling
May 5 17:46:19 server postfix/qmgr[18967]: fatal: unsupported dictionary type: mysql
May 5 17:46:20 server postfix/master[3463]: warning: process /usr/libexec/postfix/qmgr pid 18967 exit status 1
May 5 17:46:20 server postfix/master[3463]: warning: /usr/libexec/postfix/qmgr: bad command startup -- throttling
May 5 17:46:47 server postfix/smtpd[18978]: fatal: unsupported dictionary type: mysql
May 5 17:46:48 server postfix/master[3463]: warning: process /usr/libexec/postfix/smtpd pid 18978 exit status 1
May 5 17:46:48 server postfix/master[3463]: warning: /usr/libexec/postfix/smtpd: bad command startup -- throttling


[rooter@server ~]# postconf -n

alias_database = hash:/etc/aliases
alias_maps = hash:/etc/aliases
body_checks = regexp:/etc/postfix/body_checks
broken_sasl_auth_clients = yes
command_directory = /usr/sbin
config_directory = /etc/postfix
content_filter = amavis:[127.0.0.1]:10024
daemon_directory = /usr/libexec/postfix
debug_peer_level = 2
header_checks = regexp:/etc/postfix/header_checks
html_directory = no
inet_interfaces = all
mail_owner = postfix
mailq_path = /usr/bin/mailq.postfix
manpage_directory = /usr/share/man
mime_header_checks = regexp:/etc/postfix/mime_header_checks
mydestination = server.example.net, localhost, localhost.localdomain
myhostname = server.example.net
mynetworks = 127.0.0.0/8
nested_header_checks = regexp:/etc/postfix/nested_header_checks
newaliases_path = /usr/bin/newaliases.postfix
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
queue_directory = /var/spool/postfix
readme_directory = /usr/share/doc/postfix-2.3.3/README_FILES
receive_override_options = no_address_mappings
relay_domains = mysql:/etc/postfix/mysql-virtual_relaydomains.cf
sample_directory = /usr/share/doc/postfix-2.3.3/samples
sendmail_path = /usr/sbin/sendmail.postfix
setgid_group = postdrop
smtpd_client_restrictions = check_client_access mysql:/etc/postfix/mysql-virtual_client.cf
smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, check_recipient_access mysql:/etc/postfix/mysql-virtual_recipient.cf, reject_unauth_destination
smtpd_sasl_auth_enable = yes
smtpd_sasl_authenticated_header = yes
smtpd_sender_restrictions = check_sender_access mysql:/etc/postfix/mysql-virtual_sender.cf
smtpd_tls_cert_file = /etc/postfix/smtpd.cert
smtpd_tls_key_file = /etc/postfix/smtpd.key
smtpd_tls_security_level = may
smtpd_use_tls = yes
transport_maps = proxy:mysql:/etc/postfix/mysql-virtual_transports.cf
unknown_local_recipient_reject_code = 550
virtual_alias_domains =
virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.cf
virtual_gid_maps = static:5000
virtual_mailbox_base = /var/vmail
virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf
virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf
virtual_transport = maildrop
virtual_uid_maps = static:5000

[rooter@server ~]#

any idea why this is happening??

Thanks in advance....

carlos barrera

Centos5.3-Ispcfg3: Postfix: "fatal: unsupported dictionary type: mysql"
 

I found this from another thread.....

I'm assuming the "fatal: unsupported dictionary type: mysql" is a big part.

It means that MySQL support isn't compiled into your Postfix, so your setup cannot work.

Falko

OK but, What I have to do to compile into my Postfix??

Do I have to re install ISPconfig3 and Postfix?? ( I followed the instructions at the install file so what is wrong!!! )

Any Help .... Apreciated!!

Carlos Barrera

Please use this guide to set up the system: http://www.howtoforge.com/perfect-se....2-ispconfig-3

I don't mean to hijack this thread .. albeit and old one, but I thought the context was important. I followed your exact tutorial and I am having the same problem. Is there any way to fix this without starting from scratch?

Dave

Did you update Postfix after you used the tutorial? Because that would've removed the MySQL support in Postfix because the CentOS Postfix packages don't support MySQL.

Postfix error
 

Sorry falko, should have relied earlier. What happened was I missed the part about excluding postfix from the main repos so, when I removed postfix and then reinstalled it ... it installed the same version, without mysql support. when I figured that out, after removing postfix and reinstalling the proper version ... all was well.

Thanks for the response.

Dave

Yes, please.

Which tutorial (URL) did you follow? What's in your mail log?

This fixed the issue for me in Ubuntu 12.04: