3 usage: ../fyvzl [<options>] <database-file> <action> <arg>...
8 -C (show comments in output)
10 options for alphanum generation
11 -l<minrandlength> (for create/choose alphanum, minimum randlength)
12 options for wordlist generation
13 -Wf<wordlist> (switches generation method to wordlist)
14 -WF<min-word-list-len> } (for wordlist generation
15 -Wl<min-num-words> } method only)
16 -WL<min-max-mean-word-len> }
17 -Wd<permitted-delimiter-chars> } (first char is default; comma = none)
19 our $usage2 = <<'END';
21 create [<genopts>] [<redirect>] [#<comment>] (default redirect is username)
22 choose [<genopts>] [<redirect>] [#<comment>] (interactively allocate)
23 update <addr> [<redirect>] [#<comment>]
25 list [-a] (-a also lists aliases set to reject)
27 empty string for redirect means reject
28 remember to quote comments (to protect # from your shell)
30 our $usage3 = <<'END';
33 insert-exact <addr> <user> <redirect> <comment>
35 enable-user|disable-user <user>
36 default generation method is alphanum
38 our %usage_genopts = (
40 -l<randlength> (number of letters+digits)
43 -l<num-words> (number of words in output)
44 -d<delim-char> (delimiter character, "," means none)
45 -F<max-dict-size> (pick from up to <dictsize> different words, 0 means all)
46 -m<max-addr-len> (restrict total length of generated addrs, 0 = unlimited)
56 our $maxperuser = 10000;
63 our $genmethod = 'alphanum';
67 our $minrandlength = 6;
68 our $maxrandlength = 100;
75 our $minwordlistlen = 1000;
76 our $minmaxmeanwordlen = 6.2;
78 our $maxnumwords = 10;
79 our $worddelims = '.-_,';
83 our $wordlistlen = 3000;
84 our $maxdomainlen = 40;
87 die "too few arguments\n" unless @ARGV;
89 die "option in wrong place on command line\n" if $v =~ m/^-/;
93 sub addr2localpart ($) {
95 return $addr if $addr !~ m/\@/;
96 die "address not in correct domain (\@$dom)\n" unless $' eq $dom; #';
100 sub nextarg_addr () {
101 return addr2localpart nextarg;
105 die "too many arguments\n" if @ARGV;
111 $dis_q ||= $dbh->prepare("SELECT * FROM disabled_users WHERE user=?");
113 my $row = $dis_q->fetchrow_arrayref();
120 if (!defined $last_u or $last_u ne $u) {
121 print "# user $u ".(isdisabled($u) ? 'disabled' : 'enabled')."\n";
128 my $u = $row->{'user'};
130 my $pa = $row->{'localpart'};
131 $pa .= '@'.$dom if defined $dom;
132 if (length $row->{'redirect'}) {
133 print "$pa: $row->{'redirect'}" or die $!;
135 print "# reject $pa" or die $!;
137 if ($showcomment || !$priv) {
138 print " #$row->{'comment'}" or die $!;
140 print "\n" or die $!;
147 read(R, $ch, 1) == 1 or die $!;
150 next unless $o-$v+$lim < 256;
151 # print STDERR "goodrand($lim)=$v\n";
158 if (defined $$ref && $$ref =~ m/[^\041-\177]/) {
159 die "bad characters in redirection target\n";
161 if (defined $$ref && length $$ref && $$ref !~ m/\@/) {
162 die "unqualified redirection target\n" unless defined $qualdom;
163 $$ref .= '@'.$qualdom;
170 "INSERT INTO addrs (".
171 (join ",", sort keys %$row).
173 (join ",", map { "?" } sort keys %$row).
175 $dbh->do($stmt, {}, map { $row->{$_} } sort keys %$row);
183 my $f = (s/^\#// ? 'comment' : 'redirect');
184 die "$f supplied twice\n" if exists $row->{$f};
187 foreach my $f (keys %$defrow) {
188 next if defined $row->{$f};
189 $row->{$f} = $defrow->{$f};
191 qualify $row->{'redirect'};
195 sub local_part_inuse ($) {
197 our $checkexist_q ||=
198 $dbh->prepare("SELECT localpart FROM addrs WHERE localpart=?");
199 $checkexist_q->execute($s);
200 my $row = $checkexist_q->fetchrow_arrayref();
204 sub gen_local_part_alphanum {
205 my $s = chr(ord('a')+goodrand(26));
206 while (length $s < $randlength) {
207 my $v = goodrand(36);
215 sub generate_local_part () {
218 { no strict qw(refs); $s = &{"gen_local_part_$genmethod"}; }
219 # print STDERR "$s\n";
220 last if !local_part_inuse($s);
225 sub prepare_create () {
226 my $countq = $dbh->prepare("SELECT count(*) FROM addrs WHERE user=?");
227 $countq->execute($user);
228 my ($count) = $countq->fetchrow_array();
229 die unless defined $count;
230 die "too many aliases for this user\n" if $count >= $maxperuser;
231 open R, "/dev/urandom" or die $!;
235 sub genopt_alphanum {
239 die "length out of range $minrandlength..$maxrandlength\n"
240 unless ($minrandlength<=$randlength &&
241 $randlength<=$maxrandlength);
243 die "unknown alphanumeric generation option\n";
247 sub gendefaults_alphanum {
248 $randlength ||= $minrandlength;
251 sub gen_local_part_wordlist {
252 my @cmd = (qw(random-word), "-f$wordlist","-n$numwords");
253 push @cmd, "-F$wordlistlen" if $wordlistlen < 1e9;
255 open P, "-|", @cmd or die $!;
257 $!=0; $?=0; close P or die "$? $!";
259 $s =~ s/ /$worddelim/g;
260 my $efflen = length $s;
261 $efflen += 1 + length($dom) if defined $dom;
262 return $s if $efflen <= $maxdomainlen;
266 sub genopt_wordlist {
270 die "length out of range $minnumwords..$maxnumwords\n"
271 unless ($minnumwords<=$numwords &&
272 $numwords<=$maxnumwords);
273 } elsif (m/^-d(.)$/) {
275 die "word delimiter must be one of \`$worddelims'\n"
276 unless grep { $worddelim eq $_ } split //, $worddelims;
277 } elsif (m/^-F(\d+)$/) {
278 $wordlistlen = $1 ? 0+$1 : 1e9;
279 die "requested dictionary size too small\n"
280 unless $wordlistlen >= $minwordlistlen;
281 } elsif (m/^-m(\d+)$/) {
282 $maxdomainlen = $1 ? 0+$1 : 1e9;
284 die "unknown wordlist generation option\n";
288 sub gendefaults_wordlist {
289 $numwords ||= $minnumwords;
290 $worddelim = substr($worddelims,0,1) unless defined $worddelim;
291 $worddelim = '' if $worddelim eq ',';
292 my $expectedmindomlen =
293 (defined $dom ? (1 + length $dom) : 0) # @domain.name
294 + $minmaxmeanwordlen * $numwords # some words
295 + (length $worddelim) * ($numwords-1); # delimiters
296 die "assuming lowest reasonable mean word length $minmaxmeanwordlen".
297 " addrs would be $expectedmindomlen long but".
298 " maximum length is set to $maxdomainlen (use different -m?)\n"
299 if $expectedmindomlen > $maxdomainlen;
303 while (@ARGV && $ARGV[0] =~ m/^-/) {
304 my $arg = shift @ARGV;
305 last if $arg =~ m/^--?$/;
306 { no strict qw(refs); &{"genopt_$genmethod"}($arg); }
308 { no strict qw(refs); &{"gendefaults_$genmethod"}(); }
313 my $newrow = rhsargs({'redirect'=>$user, 'comment'=>''});
315 $newrow->{'user'} = $user;
316 $newrow->{'localpart'} = generate_local_part();
325 my $template = rhsargs({'redirect'=>$user, 'comment'=>''});
326 $template->{'user'} = $user;
330 while (keys %s < 10) {
331 my $s = generate_local_part();
334 print "\@$dom" or die $! if $dom;
335 print "\n" or die $!;
338 print "# ready - enter addrs or local-parts to create,".
339 " then \`.' on a line by itself\n"
347 $s = addr2localpart $_;
348 $s{$s} or die "not an (as-yet-unused) suggestion\n";
350 die "just taken in the meantime (bad luck!)\n"
351 if local_part_inuse $s;
354 my $newrow = { %$template, 'localpart' => $s };
360 print "! error: $@" or die $!;
366 my ($localpart) = @_;
367 our $row_q ||= $dbh->prepare("SELECT * FROM addrs WHERE localpart=?");
368 $row_q->execute($localpart);
369 return $row_q->fetchrow_hashref();
373 my ($localpart) = @_;
374 my $q = $dbh->prepare("SELECT * FROM addrs WHERE localpart=?");
375 my $row = selectrow $localpart;
376 die "unknown localpart\n" unless defined $row;
377 die "not owned by you\n" unless $priv || $row->{user} eq $user;
382 my $localpart = nextarg_addr;
383 my $updrow = rhsargs({});
385 begin_row($localpart);
386 foreach my $f (qw(redirect comment)) {
387 my $v = $updrow->{$f};
388 next unless defined $v;
389 $dbh->do("UPDATE addrs SET $f=? WHERE localpart=?",
392 my $row = selectrow $localpart;
398 my $localpart = nextarg_addr;
400 my $row = begin_row($localpart);
406 while (my $row = $q->fetchrow_hashref()) {
415 last unless $ARGV[0] =~ m/^-/;
421 die "unknown option to list \`$_'\n";
425 my $q = "SELECT * FROM addrs WHERE user=?";
426 $q .= " AND NOT redirect = ''" unless $listall;
427 $q .= " ORDER BY localpart";
428 $q = $dbh->prepare($q);
433 sub action_list_user {
440 sub action_list_all {
443 my $q = $dbh->prepare("SELECT * FROM addrs".
444 " ORDER BY user, localpart");
449 sub action_insert_exact {
452 $row->{'localpart'} = nextarg_addr;
453 $row->{'user'} = $user = nextarg;
454 $row->{'redirect'} = nextarg;
455 $row->{'comment'} = nextarg;
463 my $localpart = nextarg_addr;
464 my $newuser = nextarg;
466 begin_row($localpart);
467 $dbh->do('UPDATE addrs SET user=? WHERE localpart=?',
468 {}, $newuser, $localpart);
472 sub action_enable_user {
476 $dbh->do('DELETE FROM disabled_users WHERE user=?',{},$user);
480 sub action_disable_user {
484 $dbh->do('INSERT INTO disabled_users VALUES user (?)',{},$user);
488 sub action_list_actions {
489 print $usage2 or die $!;
490 print "genopts\n" or die $!;
491 print $usage_genopts{$genmethod} or die $!;
495 last unless $ARGV[0] =~ m/^-/;
502 } elsif (s/^-m(\d+)$//) {
504 } elsif (s/^-d(\S+)$//) {
506 } elsif (s/^-q(\S+)$//) {
508 } elsif (s/^-Wf(\S+)$//) {
510 $genmethod = 'wordlist';
511 } elsif (s/^-WF(\d+)$//) {
512 $minwordlistlen = $1;
513 } elsif (s/^-Wl(\d+)$//) {
515 } elsif (s/^-WL([0-9.]+)$//) {
516 $minmaxmeanwordlen = $1;
520 print $usage1.$usage2.$usage3 or die $!;
521 foreach my $meth (qw(alphanum wordlist)) {
522 print "genopts for $meth generation method\n" or die $!;
523 print $usage_genopts{$meth} or die $!;
527 die "unknown option \`$_'\n";
532 my $dbfile = nextarg();
534 if (defined $ENV{'USERV_USER'}) {
536 $user = $ENV{'USERV_USER'};
539 $user = ((getpwuid $<)[0]) or die;
542 $usage2 .= defined $dom
543 ? "addr may be a local part, implicitly qualified with \@$dom\n"
544 : "addr must be a local part (only)\n";
545 $usage2 .= "redirect is implicitly qualified with \@$qualdom".
549 $dbh = DBI->connect("dbi:SQLite:dbname=$dbfile","","",
550 { PrintError => 0, AutoCommit => 0, RaiseError => 1 })
553 my $action = nextarg();
555 { no strict qw(refs); &{"action_$action"}(); }