Linux - Server This forum is for the discussion of Linux Software used in a server related context. |
Notices |
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Are you new to LinuxQuestions.org? Visit the following links:
Site Howto |
Site FAQ |
Sitemap |
Register Now
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
|
 |
05-26-2011, 07:04 AM
|
#1
|
Member
Registered: Dec 2006
Posts: 37
Rep:
|
Postfix updated by CentOS and doesn't support MySQL anymore
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
|
|
|
05-26-2011, 10:59 AM
|
#2
|
Senior Member
Registered: Dec 2003
Location: phnom penh
Distribution: Fedora
Posts: 1,625
Rep: 
|
1. remove the installed 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
|
|
1 members found this post helpful.
|
05-27-2011, 07:17 AM
|
#3
|
Member
Registered: Dec 2006
Posts: 37
Original Poster
Rep:
|
It helped, but there are still issues
Hi Berhanie,
I followed your instructions below:
Quote:
Originally Posted by Berhanie
1. remove the installed 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
|
|
|
05-27-2011, 09:30 AM
|
#4
|
Senior Member
Registered: Dec 2003
Location: phnom penh
Distribution: Fedora
Posts: 1,625
Rep: 
|
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
|
|
|
05-27-2011, 09:49 AM
|
#5
|
Member
Registered: Dec 2006
Posts: 37
Original Poster
Rep:
|
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.
|
|
|
05-27-2011, 09:52 AM
|
#6
|
Senior Member
Registered: Dec 2003
Location: phnom penh
Distribution: Fedora
Posts: 1,625
Rep: 
|
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
|
|
|
05-27-2011, 10:23 AM
|
#7
|
Member
Registered: Dec 2006
Posts: 37
Original Poster
Rep:
|
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!!!!!
|
|
|
05-27-2011, 11:23 AM
|
#8
|
Senior Member
Registered: Dec 2003
Location: phnom penh
Distribution: Fedora
Posts: 1,625
Rep: 
|
no problem. good job, david.
|
|
|
All times are GMT -5. The time now is 04:45 AM.
|
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.
|
Latest Threads
LQ News
|
|