blob: d6ebe5376644a59a7b8c319e6c1b7f6432d38481 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
|
#!/usr/bin/perl
use 5.010_000;
use warnings;
use strict;
=head1 NAME
fripost-adduser.pl - Add a new mailbox to the system
=head1 DESCRIPTION
This script eases the burden of adding a new user to the system.
Necessary steps to add a user to the system:
1. Create the Maildir (ensuring proper permissions)
2. Add him to the MySQL database
3. Send welcome message
4. Ensure welcome message has arrived
=cut
our $VERSION = '0.01';
use Data::Dumper;
use DateTime;
use Email::Valid;
use Fripost::Schema;
use IO::Prompt;
use Getopt::Long;
use YAML::Syck;
## Get command line options
our $conf = LoadFile('default.yml');
GetOptions(
'dbi_dsn' => \$conf->{dbi_dsn},
'admuser=s' => \$conf->{admuser},
'admpass=s' => \$conf->{admpass},
) or die "Unable to get command line options.";
# Connect to the database
my $schema = Fripost::Schema->connect(
$conf->{dbi_dsn}, $conf->{admuser}, $conf->{admpass}, {} #\%dbi_params
);
my %user;
# Get the full e-mail of the user (aka e-mail)
while (not defined $user{username}) {
$user{username} = prompt "Enter the full e-mail: ";
if (!Email::Valid->address($user{username})) {
undef $user{username};
say "This is not a vaild e-mail address. Try again."
}
}
# Full name of user
$user{name} = prompt "Full (real) name: ";
# Extrapolate domain from full e-mail
my @parts = split /\@/, $user{username};
my $username = $parts[0];
my $domain = $parts[1];
print "Username: $username\nDomain:$domain\n";
die;
# Set domain name
$user{domain} = $domain;
# Construct maildir from domain and user
$user{maildir} = "$domain/$username/Maildir";
# Set dates
my $now = DateTime->now();
$user{create_date} = $now;
$user{change_date} = $now;
$user{active} = 1;
my $user = $schema->resultset('Mailbox')->new(\%user);
# Make the insert into database
$user->insert;
=head1 AUTHOR
Stefan Kangas C<< <skangas at skangas.se> >>
=head1 COPYRIGHT
Copyright 2010 Stefan Kangas, all rights reserved.
=head1 LICENSE
This program is free software; you can redistribute it and/or modify it
under the same terms as perl itself.
=cut
|
