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

[RomaSvcs]

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

[RomaSvcs]

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

[falko]

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

[filch]

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

[falko]

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.

[filch]

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

[laytone]

Originally Posted by filch

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

Yes, please.

[falko]

Originally Posted by laytone

Yes, please.

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

[fak3r]

This fixed the issue for me in Ubuntu 12.04:

apt-get install postfix-mysql