Great Circle Associates Majordomo-Workers
(September 2003)
 

Indexed By Date: [Previous] [Next] Indexed By Thread: [Previous] [Next]

Subject: Re: auto-generated virtual users table(s) ...
From: Brock Rozen <brozen @ torah . org>
Date: Wed, 24 Sep 2003 23:18:09 +0300 (IDT)
To: "Marc G. Fournier" <scrappy @ hub . org>
Cc: majordomo-workers @ GreatCircle . COM, mj2-dev @ csf . colorado . edu
In-reply-to: <20030924105830.I27456@ganymede.hub.org>
References: <20030924105830.I27456@ganymede.hub.org>
Reply-to: brozen @ torah . org

Hi,

We use the following crude script to take all of the Majordomo alias and
vut files, and compile them into one file that sendmail uses. That way, we
don't have to update the sendmail configuration when we add a new domain
to Majordomo.

We run this once an hour. Obviously, it can be made to do other things as
well.

In addition, the attached program apparently does what you need it to do
-- so work that in with this, and you have your solution.

---
#!/usr/bin/perl

use File::Listing;

&init;
&delete_files;
&parse_domains; # This routine will create the vut + alias files as well
&copy_files;
&alivut;

sub init {
$mj2domains_dir = "/usr/local/mj2/lists"; # Where Mj2 stores the lists/domains
$tmp_dir = "/etc/mail/mj2";
$sendmail_dir = "/etc/mail"; 	    # Where sendmail stores its files
$newaliases_exec = "/usr/sbin/newaliases"; # The location of the newaliases program
$makemap_exec = "/usr/sbin/makemap";# The location of makemap
$makemap_type = "btree";
$sendmail_vut = "virtusertable.mj"; # The location of the central vut file.
				    # It will be created under $sendmail_dir
$sendmail_aliases = "aliases.mj";   # The location of the central aliases file.
				    # It will be created under $sendmail_dir

### you shouldn't need to change anything below this line
$mj2files_dir = "$mj2domains_dir/ALIASES";
$alias_tmp = "$tmp_dir/mj-alias.new";
$vut_tmp = "$tmp_dir/mj-vut.new";
}

sub parse_domains {
for (parse_dir(`ls -l $mj2domains_dir`)) {
($domain, $type, $size, $mtime, $mode) = @$_;
&sendmail_append unless ($domain eq "ALIASES" ||
			$domain eq "LIB" ||
			$domain eq "QUEUE" ||
			$domain eq "SITE" ||
			$type ne "d");
next;
}
}


sub sendmail_append {
$alias_exec = "cat $mj2files_dir/mj-alias-$domain >> $alias_tmp";
$vut_exec = "cat $mj2files_dir/mj-vut-$domain >> $vut_tmp";
system $alias_exec;
system $vut_exec;
}

sub delete_files {
unlink "$alias_tmp";
unlink "$vut_tmp";
}

sub copy_files {
$alias_cp = "cp $alias_tmp $sendmail_dir/$sendmail_aliases";
$vut_cp = "cp $vut_tmp $sendmail_dir/$sendmail_vut";
system $alias_cp;
system $vut_cp;
}

sub alivut {
$aliases_exec = "$newaliases_exec > /dev/null";
system $aliases_exec;
$vut_exec = "$makemap_exec $makemap_type $sendmail_dir/$sendmail_vut.db < $sendmail_dir/$sendmail_vut";
system $vut_exec;
}

----

Best,

BR

On Wed, 24 Sep 2003 at 11:03, Marc G. Fournier wrote about "auto-generated...":

>
> I've been using the feature in Mj2 that auto-generates the alias and
> virtual tables for postfix when you create a new list, but due to how I
> have postfix setup, I need to append @localhost to all of the entries in
> virtual for it to work before I can 'postmap' the file ...
>
> Is there some way that I can tell majordomo2 to do this when it adds the
> entries?  The major headache is when I upgrade from CVS, and it
> regenerates the whole file ...
>
> Basically, I need to write out:
>
> # VUT entries for pgsql-announce at postgresql.org
> pgsql-announce@postgresql.org              pgsql-announce-postgresql.org
> pgsql-announce-request@postgresql.org      pgsql-announce-postgresql.org-request
> pgsql-announce-owner@postgresql.org        pgsql-announce-postgresql.org-owner
> owner-pgsql-announce@postgresql.org        owner-pgsql-announce-postgresql.org
> # End VUT entries for pgsql-announce at postgresql.org
>
> As:
>
> # VUT entries for pgsql-announce at postgresql.org
> pgsql-announce@postgresql.org              pgsql-announce-postgresql.org@localhost.postgresql.org
> pgsql-announce-request@postgresql.org      pgsql-announce-postgresql.org-request@localhost.postgresql.org
> pgsql-announce-owner@postgresql.org        pgsql-announce-postgresql.org-owner@localhost.postgresql.org
> owner-pgsql-announce@postgresql.org        owner-pgsql-announce-postgresql.org@localhost.postgresql.org
> # End VUT entries for pgsql-announce at postgresql.org
>

-- 
Brock Rozen                                        brozen@teamgenesis.com
#!/usr/bin/perl -w

# Copyright (c) 1999-2002 Gregory Neil Shapiro.  All Rights Reserved.
# 
# Redistribution and use in source and binary forms, with or without
# modification, are permitted provided that the following conditions
# are met:
#
# 1. Redistributions of source code must retain the above copyright
#    notice, this list of conditions and the following disclaimer.
# 2. Redistributions in binary form must reproduce the above copyright
#    notice, this list of conditions and the following disclaimer in the
#    documentation and/or other materials provided with the distribution.
# 3. Neither the name of the author nor the names of its contributors
#    may be used to endorse or promote products derived from this software
#    without specific prior written permission.
#
# THIS SOFTWARE IS PROVIDED BY THE AUTHOR AND CONTRIBUTORS ``AS IS'' AND
# ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
# IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
# ARE DISCLAIMED.  IN NO EVENT SHALL THE AUTHOR OR CONTRIBUTORS BE LIABLE
# FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
# DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS
# OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION)
# HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
# LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY
# OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
# SUCH DAMAGE.

# $Id: buildvirtuser,v 1.5 2002/02/08 08:10:59 gshapiro Exp $

=head1 NAME

buildvirtuser - Build virtusertable support from a directory of files

=head1 SYNOPSIS

    buildvirtuser [-f]

=head1 DESCRIPTION

buildvirtuser will build /etc/mail/virtusertable.db and /etc/mail/virthosts
based on the contents of the directory /etc/mail/virtusers/.  That
directory should contain one file per virtual domain with the filename
matching the virtual domain name and the contents containing a list of
usernames on the left and the actual address for that username on the
right.  An empty left column translates to the default for that domain.
Blank lines and lines beginning with '#' are ignored.  Occurrences of
$DOMAIN in the file are replaced by the current domain being processed.
Occurrences of $LHS in the right hand side are replaced by the address on
the left hand side.

The -f option forces the database to be rebuilt regardless of whether
any file changes were detected.

=head1 CONFIGURATION

In order to function properly, sendmail must be configured to use these
files with:

	FEATURE(`virtusertable')dnl
	VIRTUSER_DOMAIN_FILE(`/etc/mail/virthosts')dnl

If a new domain is added (i.e., by adding a new file to
/etc/mail/virtusers/), the sendmail daemon must be restarted for the change
to take affect.

=head1 EXAMPLES

Here are some example files from the /etc/mail/virtusers/ directory:

=head2 /etc/mail/virtusers/bsdunix.org:

 # Services
 MAILER-DAEMON	gshapiro+bounce.$DOMAIN@gshapiro.net
 postmaster	gshapiro+$LHS.$DOMAIN@gshapiro.net
 webmaster	gshapiro+$LHS.$DOMAIN@gshapiro.net
 
 # Defaults
 		error:nouser No such user
 
 # Users
 gshapiro	gshapiro+$DOMAIN@gshapiro.net
 bob		robert@smtp.org

=head2 /etc/mail/virtusers/smtp.org:

 # Defaults
 		gshapiro+$DOMAIN@gshapiro.net
 
 # Users
 john		john@wookie.org
 nancy		n@milter.com

=head1 AUTHOR

Gregory Neil Shapiro E<lt>F<gshapiro@gshapiro.net>E<gt>

=cut

use strict;
use Getopt::Std;

my $makemap = "/usr/sbin/makemap";
my $dbtype = "hash";
my $maildir = "/etc/mail";
my $virthosts = "$maildir/virthosts";
my $newvirthosts = "$maildir/virthosts.new";
my $virts = "$maildir/virtusers";
my $newvirt = "$maildir/virtusertable.new.db";
my $virt = "$maildir/virtusertable.db";
my %virt = ();
my $newest = 0;
my ($lhs, $domain, $key, $value);
my $opts = {};

getopts('f', $opts) || die "Usage: $0 [-f]\n";

opendir(VIRTS, $virts) || die "Could not open directory $virts: $!\n";
my @virts = grep { -f "$virts/$_" } readdir(VIRTS);
closedir(VIRTS) || die "Could not close directory $virts: $!\n";

foreach $domain (@virts)
{
	open(DOMAIN, "$virts/$domain") || die "Could not open file $virts/$domain: $!\n";
	my $line = 0;
	my $mtime = (stat(DOMAIN))[9] || 0;
	if ($mtime > $newest)
	{
		$newest = $mtime;
	}
LINE:	while (<DOMAIN>)
	{
		chomp;
		$line++;
		next LINE if /^#/;
		next LINE if /^$/;
		if (m/^([^\t ]*)[\t ]+(.*)$/)
		{
			if (defined($1))
			{
				$lhs = "$1";
				$key = "$1\@$domain";
			}
			else
			{
				$lhs = "";
				$key = "\@$domain";
			}
			$value = $2;
		}
		else
		{
			die "Bogus line $line in $virts/$domain\n";
		}

		# Variable subsitution
		$key =~ s/\$DOMAIN/$domain/g;
		$value =~ s/\$DOMAIN/$domain/g;
		$value =~ s/\$LHS/$lhs/g;
		$virt{$key} = $value;
	}
	close(DOMAIN) || die "Could not close $virts/$domain: $!\n";
}

my $virtmtime = (stat($virt))[9] || 0;
if ($opts->{f} || $virtmtime < $newest)
{
	print STDOUT "Rebuilding $virt\n";
# logger -s -t ${prog} -p mail.info "Rebuilding ${basedir}/virtusertable"
	open(MAKEMAP, "|$makemap $dbtype $newvirt") || die "Could not start makemap: $!\n";
	foreach $key (keys %virt)
	{
		print MAKEMAP "$key\t\t$virt{$key}\n";
	}
	close(MAKEMAP) || die "Could not close makemap ($?): $!\n";
	rename($newvirt, $virt) || die "Could not rename $newvirt to $virt: $!\n";

	open(VIRTHOST, ">$newvirthosts") || die "Could not open file $newvirthosts: $!\n";
	foreach $domain (sort @virts)
	{
		print VIRTHOST "$domain\n";
	}
	close(VIRTHOST) || die "Could not close $newvirthosts: $!\n";
	rename($newvirthosts, $virthosts) || die "Could not rename $newvirthosts to $virthosts: $!\n";
}
exit 0;

References:
Indexed By Date Previous: 'k, lack of delivery problem ... message disappears into ether ...
From: "Marc G. Fournier" <scrappy@hub.org>
Next: Re: 'k, lack of delivery problem ... message disappears into ether
From: Daniel Liston <dliston@sonny.org>
Indexed By Thread Previous: auto-generated virtual users table(s) ...
From: "Marc G. Fournier" <scrappy@hub.org>
Next: 'k, lack of delivery problem ... message disappears into ether ...
From: "Marc G. Fournier" <scrappy@hub.org>

Google
 
Search Internet Search www.greatcircle.com