Postfix : error: unsupported dictionary type: mysql

Question

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?

almost-duplicate question for pcre: https://serverfault.com/q/972173/250204 — anx, Aug 03 '19 at 18:20

score 24 · Accepted Answer · answered Aug 20 '14 at 16:10

24

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

sudo apt-get install postfix-mysql

answered Aug 20 '14 at 16:10

flavio.troja

706
2
5
11

`sudo pacman -S postfix-mysql` - For the record, this same package was also the solution on Arch – Jesse יִשַׁי Apr 29 '21 at 07:26

score 13 · Answer 2 · edited Sep 02 '15 at 23:48

13

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

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.

edited Sep 02 '15 at 23:48

masegaloeh

17,978
9
56
104

answered Sep 02 '15 at 22:26

George Gaál

470
3
8

score 2 · Answer 3 · answered Mar 15 '15 at 02:10

2

Check if installed: dpkg -s postfix-mysql

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

Problem solved.

answered Mar 15 '15 at 02:10

beater

29
1

5

funny fact, I have it installed and still that error – John Dec 05 '17 at 02:32
1

Try adding `mysql /usr/lib/postfix/postfix-mysql.so.1.0.1 dict_mysql_open` to `/etc/postfix/dynamicmaps.cf` and do a postfix reload – Guido Goluke Sep 30 '21 at 12:22
@GuidoGoluke Thanks a million! That's exactly what I needed to fix my borked machine! – pkSML Mar 10 '22 at 04:10

Postfix : error: unsupported dictionary type: mysql

3 Answers3