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

Discussion in 'Installation/Configuration' started by RomaSvcs, May 6, 2009.

  1. RomaSvcs

    RomaSvcs New Member

    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
     
  2. RomaSvcs

    RomaSvcs New Member

    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
     
  3. falko

    falko Super Moderator

  4. filch

    filch New Member

    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
     
  5. falko

    falko Super Moderator

    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.
     
  6. filch

    filch New Member

    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
     
  7. laytone

    laytone New Member

    Yes, please.
     
  8. falko

    falko Super Moderator

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

    fak3r New Member

    This fixed the issue for me in Ubuntu 12.04:

    Code:
    apt-get install postfix-mysql
     

Share This Page