[Bug 627632] New: database /etc/postfix/virtual.db is older than source file /etc/postfix/virtual
http://bugzilla.novell.com/show_bug.cgi?id=627632 http://bugzilla.novell.com/show_bug.cgi?id=627632#c0 Summary: database /etc/postfix/virtual.db is older than source file /etc/postfix/virtual Classification: openSUSE Product: openSUSE 11.3 Version: Final Platform: i586 OS/Version: Other Status: NEW Severity: Major Priority: P5 - None Component: Update Problems AssignedTo: bnc-team-screening@forge.provo.novell.com ReportedBy: koenig@linux.de QAContact: jsrain@novell.com Found By: --- Blocker: --- after update from 11.1 to 11.3 all *.db files from postfix did not get updated and are out of date: # ll -tr *.db access canonical relay_ccerts relocated sasl_passwd sender_canonical transport virtual -rw-r--r-- 30 root root 12288 Jan 3 2009 virtual.db -rw-r--r-- 30 root root 12288 Jan 3 2009 transport.db -rw-r--r-- 30 root root 12288 Jan 3 2009 access.db -rw-r--r-- 30 root root 12288 Jan 3 2009 sender_canonical.db -rw------- 30 root root 12288 Jan 3 2009 sasl_passwd.db -rw-r--r-- 30 root root 12288 Jan 3 2009 relocated.db -rw-r--r-- 30 root root 12288 Jan 3 2009 relay_ccerts.db -rw-r--r-- 30 root root 12288 Jan 3 2009 canonical.db -rw-r--r-- 5 root root 12494 Jul 19 10:20 virtual -rw-r--r-- 5 root root 12549 Jul 19 10:20 transport -rw-r--r-- 5 root root 6816 Jul 19 10:20 relocated -rw-r--r-- 5 root root 11681 Jul 19 10:20 canonical -rw-r--r-- 5 root root 20695 Jul 19 10:20 access -rw-r--r-- 5 root root 412 Jul 19 10:20 sender_canonical -rw------- 5 root root 172 Jul 19 10:20 sasl_passwd -rw-r--r-- 5 root root 199 Jul 19 10:20 relay_ccerts which generates tons of syslog messages: # grep -c "is older than source file" /var/log/mail 6518 SuSEconfig should update those *.db files, isn't it ? -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=627632
http://bugzilla.novell.com/show_bug.cgi?id=627632#c
yang xiaoyu
http://bugzilla.novell.com/show_bug.cgi?id=627632
http://bugzilla.novell.com/show_bug.cgi?id=627632#c
Peter Varkoly
http://bugzilla.novell.com/show_bug.cgi?id=627632
http://bugzilla.novell.com/show_bug.cgi?id=627632#c1
Peter Varkoly
http://bugzilla.novell.com/show_bug.cgi?id=627632
http://bugzilla.novell.com/show_bug.cgi?id=627632#c2
Harald Koenig
Please execute SuSEconfig -module postfix as user root and send me the output.
root # SuSEconfig -module postfix Starting SuSEconfig, the SuSE Configuration Tool... Running module postfix only Reading /etc/sysconfig and updating the system... Executing /sbin/conf.d/SuSEconfig.postfix... Setting up procmail as MDA... Setting up medium SPAM protection... ATTENTION: You have modified /etc/postfix/main.cf. Leaving it untouched... You can find my version in /etc/postfix/main.cf.SuSEconfig... rebuilding /etc/postfix/relay.db Finished. root # ll -tr /etc/postfix/*db -rw-r--r-- 1 root root 12288 Aug 2 22:57 /etc/postfix/virtual.db -rw-r--r-- 1 root root 12288 Aug 2 22:58 /etc/postfix/canonical.db -rw-r--r-- 1 root root 12288 Aug 2 22:58 /etc/postfix/access.db -rw-r--r-- 1 root root 12288 Aug 2 23:01 /etc/postfix/relay_ccerts.db -rw-r--r-- 1 root root 12288 Aug 2 23:01 /etc/postfix/relocated.db -rw------- 1 root root 12288 Aug 2 23:01 /etc/postfix/sasl_passwd.db -rw-r--r-- 1 root root 12288 Aug 2 23:01 /etc/postfix/sender_canonical.db -rw-r--r-- 1 root root 12288 Aug 2 23:01 /etc/postfix/transport.db -rw-r--r-- 1 root root 12288 Aug 11 15:45 /etc/postfix/relay.db root #
I need furthermore the content of the variable POSTFIX_UPDATE_MAPS and POSTFIX_MAP_LIST in the file /etc/sysconfig/postfix
root # egrep 'POSTFIX_UPDATE_MAPS|POSTFIX_MAP_LIST' /etc/sysconfig/postfix POSTFIX_UPDATE_MAPS=yes -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=627632
http://bugzilla.novell.com/show_bug.cgi?id=627632#c3
--- Comment #3 from Harald Koenig
inet_interfaces = t2,localhost
this is why main.cf did not get updated. so why this manual change ? /etc/sysconfig/postfix claims # Comma separated list of IP's # NOTE: If not set, LISTEN on all interfaces # POSTFIX_LISTEN="" but in main.cf.SuSEconfig I find inet_interfaces = localhost because SMTPD_LISTEN_REMOTE is not set -- and it's not the the sysconfig/postfix template file (know this now from SuSEconfig.postfix) but you have to look into /etc/sysconfig/mail :-( now with SMTPD_LISTEN_REMOTE="yes" in sysconfig/mail (and optionally POSTFIX_LISTEN="t2,localhost" in sysconfig/postfix) I can do mv /etc/postfix/main.cf.SuSEconfig /etc/postfix/main.cf an now update_db works fine again... finally I've checked the backup from the 11.1 system before updating: in 11.1 I had /etc/sysconfig/mail:SMTPD_LISTEN_REMOTE="yes" so start of the problem was that 11.1->11.3 update changed/cleared SMTPD_LISTEN_REMOTE in mail setup :-( /var/log/zypp/history only says # 2010-07-28 08:24:19 postfix-2.7.1-2.1.1.i586.rpm installed ok # Additional rpm output: # Updating etc/sysconfig/postfix... # Updating etc/sysconfig/mail... # both templates for SMTPD_LISTEN_REMOTE are set to "no" : # grep SMTPD_LISTEN_REMOTE /var/adm/fillup-templates/sysconfig.mail* /var/adm/fillup-templates/sysconfig.mail:SMTPD_LISTEN_REMOTE="no" /var/adm/fillup-templates/sysconfig.mail-postfix:SMTPD_LISTEN_REMOTE="no" so why/where did SMTPD_LISTEN_REMOTE get "updated" from "yes" to "" ?? -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=627632
http://bugzilla.novell.com/show_bug.cgi?id=627632#c4
Peter Varkoly
more details when reading SuSEconfig.postfix and /etc/sysconfig/postfix :
# diff /etc/postfix/main.cf.SuSEconfig /etc/postfix/main.cf 549c549 < inet_interfaces = localhost ---
inet_interfaces = t2,localhost
this is why main.cf did not get updated. so why this manual change ?
/etc/sysconfig/postfix claims
# Comma separated list of IP's # NOTE: If not set, LISTEN on all interfaces # POSTFIX_LISTEN=""
but in main.cf.SuSEconfig I find
inet_interfaces = localhost it is ok. localhost is not remote.
because SMTPD_LISTEN_REMOTE is not set -- and it's not the the sysconfig/postfix template file (know this now from SuSEconfig.postfix) but you have to look into /etc/sysconfig/mail :-(
now with SMTPD_LISTEN_REMOTE="yes" in sysconfig/mail (and optionally POSTFIX_LISTEN="t2,localhost" in sysconfig/postfix) I can do
mv /etc/postfix/main.cf.SuSEconfig /etc/postfix/main.cf
an now update_db works fine again...
finally I've checked the backup from the 11.1 system before updating: in 11.1 I had /etc/sysconfig/mail:SMTPD_LISTEN_REMOTE="yes"
so start of the problem was that 11.1->11.3 update changed/cleared SMTPD_LISTEN_REMOTE in mail setup :-(
/var/log/zypp/history only says # 2010-07-28 08:24:19 postfix-2.7.1-2.1.1.i586.rpm installed ok # Additional rpm output: # Updating etc/sysconfig/postfix... # Updating etc/sysconfig/mail... #
both templates for SMTPD_LISTEN_REMOTE are set to "no" :
# grep SMTPD_LISTEN_REMOTE /var/adm/fillup-templates/sysconfig.mail* /var/adm/fillup-templates/sysconfig.mail:SMTPD_LISTEN_REMOTE="no" /var/adm/fillup-templates/sysconfig.mail-postfix:SMTPD_LISTEN_REMOTE="no"
so why/where did SMTPD_LISTEN_REMOTE get "updated" from "yes" to "" ??
We have had a security issue, and this was the simplest way to solve it. But for 11.3 we do not really need it. Sorry. -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=627632
http://bugzilla.novell.com/show_bug.cgi?id=627632#c5
--- Comment #5 from Harald Koenig
so why/where did SMTPD_LISTEN_REMOTE get "updated" from "yes" to "" ??
We have had a security issue, and this was the simplest way to solve it. But for 11.3 we do not really need it. Sorry.
this "way" broke my mail gateway by not accepting intranet mails anymore :-( it's not (yet) documented in the release notes (not that would have read it there;). is the old value of SMTPD_LISTEN_REMOTE still available after update in any *.rpmsave/*.rpmorig file or similar ? if there is any chance that a postfix/mail update rpm to "fix" this setup change and revert to the opriginal setting of SMTPD_LISTEN_REMOTE then you really should do so. if not, at least put a big warning in the relnotes for updaters (just in case they might read the docs;), please! -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=627632
https://bugzilla.novell.com/show_bug.cgi?id=627632#c6
Swamp Workflow Management
https://bugzilla.novell.com/show_bug.cgi?id=627632
https://bugzilla.novell.com/show_bug.cgi?id=627632#c7
Dirk Mueller
https://bugzilla.novell.com/show_bug.cgi?id=627632
https://bugzilla.novell.com/show_bug.cgi?id=627632#c9
Swamp Workflow Management
https://bugzilla.novell.com/show_bug.cgi?id=627632
https://bugzilla.novell.com/show_bug.cgi?id=627632#c
Swamp Workflow Management
participants (1)
-
bugzilla_noreply＠novell.com