Sep 26 2008

qmgr fatal: unsupported dictionary type: mysql

Posted by alex in Errors at 12:10 AM

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.

Related posts:

  1. Fatal error: Cannot redeclare tc_post() The entire error I recieved was: Fatal error: Cannot redeclare...
  2. Timestamp support for Rails and MySQL/PostgreSQL/Oracle Troel has written a great summary of the SQL standard...
  3. The Configuration File Now Needs A Secret Passphrase (blowfish_secret) When installing phpMyAdmin to manage your MySQL database there are...
  4. autobench: Cannot find httperf in $PATH Why does autobench die out when trying to run it...
  5. Can’t locate Date/Format.pm in @INC The Perl error below was received when running vlogger on...
Tags: , , , , , ,

This entry was posted on Friday, September 26th, 2008 at 12:10 AM and is filed under Errors. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.

« 
 »
6 Responses to “qmgr fatal: unsupported dictionary type: mysql”
  1. Daniel Miguel says:
    October 2, 2009 at 8:26 PM

    Exctly the same problem I had!

    Thanks for sharing this info.

    [Reply]

    alex Reply:
    October 4th, 2009 at 5:28 AM

    Hello Daniel Miguel,

    No problem. Glad it helped out.

    Thanks.
    alex

    [Reply]

    Reply
  2. Rashid Iqbal says:
    July 26, 2010 at 1:38 AM

    Thanks Alex,

    Very helpful article

    [Reply]

    alex Reply:
    July 26th, 2010 at 5:22 PM

    Hello Rashid Iqbal,

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

    Thanks.
    alex

    [Reply]

    Reply
  3. Rashid Iqbal says:
    July 27, 2010 at 3:25 AM

    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:
    July 27th, 2010 at 11:20 AM

    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]

    Reply
  4.  
Leave a Reply

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

CAPTCHA Image
*