I noticed this error during an ISPConfig on CentOS 5.2 install and realized I had installed postfix without MySQL support. After looking around for a bit I was unable to locate a yum repository that included a postfix package with MySQL support built in so I decided to download the source RPM and install by modifying the SPEC file. Below are step by step instructions of what to do.

1. Remove postfix: rpm -e –nodeps postfix
2. Download the src RPM here. Located in the following directory: /centos/5.2/os/SRPMS/
cd /usr/local/src
Example: wget http://mirror.mojohost.com/centos/5.2/os/SRPMS/postfix-2.3.3-2.src.rpm 
3. Install source RPM: rpm -i postfix-2.3.3-2.src.rpm # Install the Source RPM
4. Edit File: cd /usr/src/redhat/SPECS
Edit postfix.spec: %define MYSQL 0  to  %define MYSQL 1
5. Install Packages: yum install pcre-devel mysql-devel 
6. Build The RPM: rpmbuild -ba postfix.spec (You will see lots of warnings, enjoy.)
7. Install new RPM: cd /usr/src/redhat/RPMS; rpm -i postfix-2.3.3-2.i386.rpm

That should do the trick. If you are like me and happened to be in the middle of installing ISPConfig then you will have a bunch of configuration changes to add back in for postfix.

DeliciousStumbleUponDiggTwitterFacebookRedditLinkedInEmail
Tags: , , , , , ,
6 Responses to “qmgr fatal: unsupported dictionary type: mysql”
  1. Daniel Miguel says:

    Exctly the same problem I had!

    Thanks for sharing this info.

    [Reply]

    alex Reply:

    Hello Daniel Miguel,

    No problem. Glad it helped out.

    Thanks.
    alex

    [Reply]

  2. Rashid Iqbal says:

    Thanks Alex,

    Very helpful article

    [Reply]

    alex Reply:

    Hello Rashid Iqbal,

    No problem at all. Thanks for taking the time to leave feedback.

    Thanks.
    alex

    [Reply]

  3. Rashid Iqbal says:

    Dear Alex
    After resolving this issue I am facing new issue that I isntall the postfixadmin but when I tried to login he give me error e.g

    Invalid query: the postfix.admin doesn’t exist.

    how to resolve this issue.
    Regards,

    Rashid

    [Reply]

    alex Reply:

    Hello Rashid,

    Since it is not related to this article feel free to post this question on Engage instead of in the comments of this article.

    Thanks.
    alex

    [Reply]

  4.  
Leave a Reply

*Type the letter/number combination in the abvoe field before clicking submit.

*