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.
- Litespeed PHP Build: Configure: Error: Wrong MySQL Library Version Or Lib Not Found Another error I ran into while attempting to build PHP...
- Extra SPAM Protection For ISPConfig Running Postfix This article was written to create an easy step to...
- conftest.c:1:19: error: mysql.h: No such file or directory You may receive the above error in the mkmf.log file...
- Install The EPEL Repository On CentOS Linux 5.X, EPEL Repo Installing the EPEL repository on CentOS Linux is easy to...
- Compiling PHP with Litespeed: configure: error: wrong mysql library version or lib not found Another error during an attempt to compile PHP via the...
Tags: CentOS, ISPConfig, mysql, postfix, RPM, source, yum
Entries (RSS)
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]
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]
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]