help with postfix and mysql (unsupported type)

kephillips
kephillips used Ask the Experts™
on
hi experts,
I had postfix working with mysql fine. I just updated my system however and I can't send email anymore. Please help

here's a bit of my maillog

May 23 14:44:15 back postfix/master[4141]: warning: /usr/libexec/postfix/qmgr: bad command startup -- throttling
May 23 14:45:07 back postfix/smtpd[6063]: fatal: unsupported dictionary type: mysql
May 23 14:45:08 back postfix/master[4141]: warning: process /usr/libexec/postfix/smtpd pid 6063 exit status 1
May 23 14:45:08 back postfix/master[4141]: warning: /usr/libexec/postfix/smtpd: bad command startup -- throttling
May 23 14:45:15 back postfix/qmgr[6066]: fatal: unsupported dictionary type: mysql
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
This is a problem with postfix. The thing is that many users don't choose to use postfix with mysql, so it comes disabled by default.
You need to get the latest source rpm and run it with -Uvh. Then go to the directory /usr/src/redhat/SPECS/and you will find the postfix file with .spec. Edit this file and at the top where it says mysql, change the value 0 to 1.
then rpm build -bb that file. Then go to /usr/src/redhat/RPMS/and find the file that was created. Run this file using -Uvh and that's it. To check that postfix has mysql compatability run postconf -m and see if mysql is in the list.
that's it. Hope this helps.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial