[SOLVED] Postfix updated by CentOS and doesn't support MySQL anymore

dstu · 05-26-2011, 06:04 AM

Hello,

I have to start by saying that my Linux compiling capabilities are very limited.

I updated my CentOS recently, and since, my Postfix no longer supports MySQL tables and all the emails are stuck in the queue.

I searched my forums and sites for a simple solution for it, but didn't find something clear and easy for newbies like me.

I don't want my config files to get lost and of course, the emails, virtual tables and mysql data to be restored.

Can anyone help?

Thanks a lot.

David

Berhanie · 05-26-2011, 09:59 AM

1. remove the installed postfix:

Code:

yum remove postfix

2. make sure this doesn't happend again by editing /etc/yum.repos.d/CentOS-Base.repo:

Code:

[base]
name=CentOS-$releasever - Base
...
exclude=postfix*

#released updates 
[updates]
name=CentOS-$releasever - Updates
...
exclude=postfix*

3. install postfix from the centosplus repo. it understands mysql:

Code:

yum --enablerepo=centosplus install postfix

dstu · 05-27-2011, 06:17 AM

Hi Berhanie,

I followed your instructions below:

Quote:

Originally Posted by Berhanie

1. remove the installed postfix:

Code:

yum remove postfix

2. make sure this doesn't happend again by editing /etc/yum.repos.d/CentOS-Base.repo:

Code:

[base]
name=CentOS-$releasever - Base
...
exclude=postfix*

#released updates 
[updates]
name=CentOS-$releasever - Updates
...
exclude=postfix*

3. install postfix from the centosplus repo. it understands mysql:

Code:

yum --enablerepo=centosplus install postfix

Now outgoing messages that were stuck in queue were delivered, but incoming messages to our domains are still in queue.

This is what I get in the error log:

Code:

May 27 14:07:31 sip postfix/proxymap[2179]: fatal: unsupported dictionary type: mysql
May 27 14:07:32 sip postfix/smtpd[1911]: warning: premature end-of-input on private/proxymap socket while reading input attribute name
May 27 14:07:32 sip postfix/trivial-rewrite[1821]: warning: premature end-of-input on private/proxymap socket while reading input attribute name
May 27 14:07:32 sip postfix/smtpd[1911]: warning: private/proxymap socket: service dict_proxy_open: Connection reset by peer
May 27 14:07:32 sip postfix/trivial-rewrite[1821]: warning: private/proxymap socket: service dict_proxy_open: Success
May 27 14:07:32 sip postfix/master[1759]: warning: process /usr/libexec/postfix/proxymap pid 2179 exit status 1
May 27 14:07:32 sip postfix/master[1759]: warning: /usr/libexec/postfix/proxymap: bad command startup -- throttling
May 27 14:08:32 sip postfix/proxymap[2183]: fatal: unsupported dictionary type: mysql
May 27 14:08:33 sip postfix/trivial-rewrite[1821]: warning: premature end-of-input on private/proxymap socket while reading input attribute name
May 27 14:08:33 sip postfix/smtpd[1911]: warning: premature end-of-input on private/proxymap socket while reading input attribute name
May 27 14:08:33 sip postfix/smtpd[1911]: warning: private/proxymap socket: service dict_proxy_open: Success
May 27 14:08:33 sip postfix/trivial-rewrite[1821]: warning: private/proxymap socket: service dict_proxy_open: Connection reset by peer
May 27 14:08:33 sip postfix/master[1759]: warning: process /usr/libexec/postfix/proxymap pid 2183 exit status 1
May 27 14:08:33 sip postfix/master[1759]: warning: /usr/libexec/postfix/proxymap: bad command startup -- throttling
May 27 14:08:33 sip dovecot: auth-worker(default): mysql: Connected to 127.0.0.1 (postfix)

Any idea?

Thanks,

David

Berhanie · 05-27-2011, 08:30 AM

compare with mine. post your output for comparison:

Code:

[root@host ~]# cat /etc/redhat-release
CentOS release 5.4 (Final)
[root@host ~]# postconf -m
btree
cidr
environ
hash
ldap
mysql
nis
pcre
pgsql
proxy
regexp
static
unix
[root@host ~]# rpm -q postfix
postfix-2.3.3-2.1.centos.mysql_pgsql

dstu · 05-27-2011, 08:49 AM

Quote:

Originally Posted by Berhanie

compare with mine. post your output for comparison:

Code:

[root@host ~]# cat /etc/redhat-release
CentOS release 5.4 (Final)
[root@host ~]# postconf -m
btree
cidr
environ
hash
ldap
mysql
nis
pcre
pgsql
proxy
regexp
static
unix
[root@host ~]# rpm -q postfix
postfix-2.3.3-2.1.centos.mysql_pgsql

This is mine:

Code:

[root@sip ~]# cat /etc/redhat-release
CentOS release 5.6 (Final)
[root@sip ~]# postconf -m
btree
cidr
environ
hash
ldap
nis
pcre
proxy
regexp
static
unix
[root@sip ~]# rpm -q postfix
postfix-2.3.3-2.2.el5_6

MySQL is missing from the postconf. How do I enable it? It makes sense that outgoing emails work now, but incoming doesn't recognize the destinations, as the domains and mailboxes are listed in the db.

Berhanie · 05-27-2011, 08:52 AM

ok, the postfix you're running did not come from centosplus. something went wrong with
step2, above. please cut and paste /etc/yum.repos.d/CentOS-Base.repo

dstu · 05-27-2011, 09:23 AM

Quote:

Originally Posted by Berhanie

ok, the postfix you're running did not come from centosplus. something went wrong with
step2, above. please cut and paste /etc/yum.repos.d/CentOS-Base.repo

You're right. I probably didn't save the changes. I ran the whole thing again and everything works just fine. messages are coming and going

Thanks a lot for your help!!!!!

Berhanie · 05-27-2011, 10:23 AM

no problem. good job, david.