[Mailman-Users] Postfix has problems with Mailman aliases database

[malgosia askanas (staff)]

I am installing Mailman on a machine running Postfix. I put in Postfix's
configuration file the statement

alias_maps = hash:/etc/aliases, hash:/var/chroot/htdocs/mailman/data/aliases

and ran Mailman's "genaliases" command to generate the alias database (which
now contains aliases for 2 lists). But it looks like my Postfix is choking on
Mailman's aliases. I get a steady stream of the following complaints in the
maillog:

Jun 9 12:45:20 polyhedra postfix/smtpd[16195]: fatal: open database /var/chroot/htdocs/mailman/data/aliases.db: Invalid argument
Jun 9 12:45:21 polyhedra postfix/master[301]: warning: process /usr/local/libexec/smtpd pid 16195 exit status 1
Jun 9 12:45:21 polyhedra postfix/master[301]: warning: /usr/local/libexec/smtpd: bad command startup -- throttling

Does anybody have any advice, please? I notice the following seeming mismatch,
but I don't know if it's relevant:

For the Postfix aliases database:
# file /etc/aliases.db
/etc/aliases.db: Berkeley DB (Hash, version 7, native byte-order)

For the Mailman aliases database:
# file /var/chroot/htdocs/mailman/data/aliases.db
/var/chroot/htdocs/mailman/data/aliases.db: Berkeley DB 1.85 (Hash, version 2, native byte-order)


Many thanks in advance,

-malgosia

[Kevin W. Gagel]

You haven't run the postmap command to generate the alias database.
Use the following:
postmap hash:/etc/aliases
postmap hash:/var/chroot/htdocs/mailman/data/aliases


----- Original Message Follows -----
From: "malgosia askanas (staff)" <***@panix.com>
To: mailman-***@python.org
Subject: [Mailman-Users] Postfix has problems with Mailman aliases database
Date: Wed, 9 Jun 2004 12:59:30 -0400 (EDT)

Post by malgosia askanas (staff)
I am installing Mailman on a machine running Postfix. I put in Postfix's
configuration file the statement
alias_maps = hash:/etc/aliases, hash:/var/chroot/htdocs/mailman/data/aliases
and ran Mailman's "genaliases" command to generate the alias database (which
now contains aliases for 2 lists). But it looks like my Postfix is choking on
Mailman's aliases. I get a steady stream of the following complaints in the
Jun 9 12:45:20 polyhedra postfix/smtpd[16195]: fatal: open database
/var/chroot/htdocs/mailman/data/aliases.db: Invalid argument Jun 9 12:45:21
polyhedra postfix/master[301]: warning: process /usr/local/libexec/smtpd pid
/usr/local/libexec/smtpd: bad command startup -- throttling
Does anybody have any advice, please? I notice the following seeming mismatch
# file /etc/aliases.db
/etc/aliases.db: Berkeley DB (Hash, version 7, native byte-order)
# file /var/chroot/htdocs/mailman/data/aliases.db
/var/chroot/htdocs/mailman/data/aliases.db: Berkeley DB 1.85 (Hash, version 2,
native byte-order)
Many thanks in advance,
-malgosia
------------------------------------------------------
Mailman-Users mailing list
http://mail.python.org/mailman/listinfo/mailman-users
Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py
Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/

====================
Kevin W. Gagel
Network Administrator
[phone] local 448
[phone] local 448

--------------------------------------------------------------
The College of New Caledonia, Visit us at http://www.cnc.bc.ca
Virus scanning is done on all incoming and outgoing email.
--------------------------------------------------------------

[malgosia askanas (staff)]

Post by Kevin W. Gagel
You haven't run the postmap command to generate the alias database.
postmap hash:/etc/aliases
postmap hash:/var/chroot/htdocs/mailman/data/aliases

I am sorry to say that this didn't change my situation. I did as you suggested
and then did a postfix reload, but I still get the same complaints:

Jun 9 13:28:21 polyhedra postfix/local[18087]: fatal: open database /etc/aliases.db: Invalid argument
Jun 9 13:28:22 polyhedra postfix/master[301]: warning: process /usr/local/libexec/local pid 18087 exit status 1
Jun 9 13:28:22 polyhedra postfix/master[301]: warning: /usr/local/libexec/local: bad command startup -- throttling

The two aliases files now are of the same format, both are
Berkeley DB 1.85 (Hash, version 2, native byte-order)

-malgosia

[Rob Ellis]

Post by malgosia askanas (staff)

Post by Kevin W. Gagel
You haven't run the postmap command to generate the alias database.
postmap hash:/etc/aliases
postmap hash:/var/chroot/htdocs/mailman/data/aliases

I am sorry to say that this didn't change my situation. I did as you suggested
Jun 9 13:28:21 polyhedra postfix/local[18087]: fatal: open database /etc/aliases.db: Invalid argument
Jun 9 13:28:22 polyhedra postfix/master[301]: warning: process /usr/local/libexec/local pid 18087 exit status 1
Jun 9 13:28:22 polyhedra postfix/master[301]: warning: /usr/local/libexec/local: bad command startup -- throttling
The two aliases files now are of the same format, both are
Berkeley DB 1.85 (Hash, version 2, native byte-order)

you want to use 'postalias', not 'postmap' ->

postalias hash:/etc/aliases hash:/var/chroot/htdocs/mailman/data/aliases

- rob

[djmcke]

Post by Kevin W. Gagel
You haven't run the postmap command to generate the alias database.
postmap hash:/etc/aliases
postmap hash:/var/chroot/htdocs/mailman/data/aliases

I think you need to use postalias instead of postmap.
Like this:

/usr/sbin/postalias /etc/aliases
/usr/sbin/postalias /var/chroot/htdocs/mailman/data/aliases

I added this lines to my postfix startup script.
So I don't need to remember to do them.



=====
Please ignore the following ad...




__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/

[malgosia askanas (staff)]

Post by djmcke
I think you need to use postalias instead of postmap.
/usr/sbin/postalias /etc/aliases
/usr/sbin/postalias /var/chroot/htdocs/mailman/data/aliases

No, that didn't do it either, I am sad to say. Postfix reloaded, but I
continue to get the same error:

Jun 9 14:05:40 polyhedra postfix/smtpd[19750]: fatal: open database /etc/aliases.db: Invalid argument
Jun 9 14:05:41 polyhedra postfix/master[301]: warning: process /usr/local/libexec/smtpd pid 19750 exit status 1
Jun 9 14:05:41 polyhedra postfix/master[301]: warning: /usr/local/libexec/smtpd: bad command startup -- throttling


-malgosia

[Ralf Hildebrandt]

Post by malgosia askanas (staff)

Post by djmcke
I think you need to use postalias instead of postmap.
/usr/sbin/postalias /etc/aliases
/usr/sbin/postalias /var/chroot/htdocs/mailman/data/aliases

No, that didn't do it either, I am sad to say. Postfix reloaded, but I
Jun 9 14:05:40 polyhedra postfix/smtpd[19750]: fatal: open database /etc/aliases.db: Invalid argument
Jun 9 14:05:41 polyhedra postfix/master[301]: warning: process /usr/local/libexec/smtpd pid 19750 exit status 1
Jun 9 14:05:41 polyhedra postfix/master[301]: warning: /usr/local/libexec/smtpd: bad command startup -- throttling

Are you sure postmap & smtpd belong together and were linked against
the same libdb? Check with ldd

[djmcke]

Post by malgosia askanas (staff)

Post by djmcke
I think you need to use postalias instead of postmap.
/usr/sbin/postalias /etc/aliases
/usr/sbin/postalias /var/chroot/htdocs/mailman/data/aliases

No, that didn't do it either, I am sad to say. Postfix reloaded, but I
Jun 9 14:05:40 polyhedra postfix/smtpd[19750]: fatal: open database /etc/aliases.db: Invalid
argument

Could this be a permission problem?
When you run postalias are you root -- or somebody who can write in /etc ?


=====
Please ignore the following ad...




__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/

[Andreas Freyvogel]

I usually just go into /etc/postfix and run 'newaliases'.

-----Original Message-----
From: mailman-users-***@python.org
[mailto:mailman-users-***@python.org]On Behalf Of malgosia askanas
(staff)
Sent: Wednesday, June 09, 2004 11:09 AM
To: djmcke
Cc: mailman-***@python.org
Subject: Re: [Mailman-Users] Postfix has problems with Mailman aliases
database

Post by djmcke
I think you need to use postalias instead of postmap.
/usr/sbin/postalias /etc/aliases
/usr/sbin/postalias /var/chroot/htdocs/mailman/data/aliases

No, that didn't do it either, I am sad to say. Postfix reloaded, but I
continue to get the same error:

Jun 9 14:05:40 polyhedra postfix/smtpd[19750]: fatal: open database
/etc/aliases.db: Invalid argument
Jun 9 14:05:41 polyhedra postfix/master[301]: warning: process
/usr/local/libexec/smtpd pid 19750 exit status 1
Jun 9 14:05:41 polyhedra postfix/master[301]: warning:
/usr/local/libexec/smtpd: bad command startup -- throttling


-malgosia

------------------------------------------------------
Mailman-Users mailing list
Mailman-***@python.org
http://mail.python.org/mailman/listinfo/mailman-users
Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py
Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/

[malgosia askanas (staff)]

Post by Ralf Hildebrandt
Are you sure postmap & smtpd belong together and were linked against
the same libdb? Check with ldd

Yup, they were both linked against /usr/lib/libc.so.12.

Post by Ralf Hildebrandt
Could this be a permission problem?
When you run postalias are you root -- or somebody who can write in /etc ?

Well, when I run it I am root. The permissions on the two files are:

-rw-r--r-- 1 root wheel 65536 Jun 9 14:15 /etc/aliases.db
-rw-r--r-- 1 mailman mailman 65536 Jun 9 14:15 /var/chroot/htdocs/mailman/data/aliases.db


-malgosia

[Luc Brouard]

Post by malgosia askanas (staff)

Post by Ralf Hildebrandt
Are you sure postmap & smtpd belong together and were linked against
the same libdb? Check with ldd

Yup, they were both linked against /usr/lib/libc.so.12.

libc has nothing to do with libdb.
Post full ldd.

Luc

[Ralf Hildebrandt]

Post by malgosia askanas (staff)

Post by Ralf Hildebrandt
Are you sure postmap & smtpd belong together and were linked against
the same libdb? Check with ldd

Yup, they were both linked against /usr/lib/libc.so.12.

libdb != libc

[malgosia askanas (staff)]

Post by Luc Brouard

Post by malgosia askanas (staff)

Post by Ralf Hildebrandt
Are you sure postmap & smtpd belong together and were linked against
the same libdb? Check with ldd

Yup, they were both linked against /usr/lib/libc.so.12.

libc has nothing to do with libdb.
Post full ldd.

It doesn't show libdb, and the reason -- as I now know -- is that libdb was
linked statically. BTW, is there an equivalent of "libdb" for static links?

But I am very happy to report that I have now fixed the Postfix problem, and
it was by virtue of this list's advice. Running "postalias" was indeed the
right thing to do, but, due to the order of things in my PATH, I was running
the wrong "postalias". Once I fixed that, my problem ended. Many thanks to
all of you.


-malgosia