HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)
-   -   Postfix error: fatal: unsupported dictionary type: mysql -- throttling (http://www.howtoforge.com/forums/showthread.php?t=34624)

RomaSvcs 6th May 2009 23:12

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

RomaSvcs 6th May 2009 23:42

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

falko 7th May 2009 17:43

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

filch 6th August 2010 20:28

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 7th August 2010 13:43

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 7th August 2010 22:45

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

laytone 21st November 2011 07:46

Quote:

Originally Posted by filch (Post 235745)
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 22nd November 2011 13:18

Quote:

Originally Posted by laytone (Post 267942)
Yes, please.

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

fak3r 30th November 2012 17:01

This fixed the issue for me in Ubuntu 12.04:

Code:

apt-get install postfix-mysql


All times are GMT +2. The time now is 17:54.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.