Postfix : error: unsupported dictionary type: mysql

I've a problem w/ postfix

problem:

# tail -f /var/log/mail.err
Aug 20 17:57:50 myserver postfix/smtpd[8243]: error: unsupported dictionary type: mysql
Aug 20 17:57:50 myserver postfix/smtpd[8243]: error: unsupported dictionary type: mysql
Aug 20 17:58:05 myserver postfix/smtpd[8244]: error: unsupported dictionary type: mysql
Aug 20 17:58:05 myserver postfix/smtpd[8244]: error: unsupported dictionary type: mysql
Aug 20 18:00:38 myserver postfix/smtpd[8277]: error: unsupported dictionary type: mysql
Aug 20 18:00:38 myserver postfix/smtpd[8277]: error: unsupported dictionary type: mysql
Aug 20 18:03:32 myserver postfix/smtpd[8320]: error: unsupported dictionary type: mysql
Aug 20 18:03:32 myserver postfix/smtpd[8320]: error: unsupported dictionary type: mysql
Aug 20 18:03:33 myserver postfix/trivial-rewrite[8322]: error: unsupported dictionary type: mysql
Aug 20 18:03:33 myserver postfix/trivial-rewrite[8322]: error: unsupported dictionary type: mysql

idea?


Solution 1:

[SOLVED] This fixed the issue for me in Ubuntu 14.04:

sudo apt-get install postfix-mysql

Solution 2:

  1. Check output of postconf -m. It will look like this:

    root@ds94:/usr/local/etc/postfix # postconf -m
    btree
    cidr
    environ
    fail
    hash
    internal
    memcache
    mysql
    pcre
    proxy
    regexp
    socketmap
    static
    tcp
    texthash
    unix
    
  2. If in output of postconf there isn't mysql string, it means that postfix is built without mysql support. To resolve it install postfix-mysql package.

Solution 3:

Check if installed: dpkg -s postfix-mysql

if not install sudo apt-get -y install postfix-mysql

Problem solved.