3 # $Id: svc_acct_sm.import,v 1.2 1998-12-10 07:23:18 ivan Exp $
5 # ivan@sisd.com 98-mar-9
7 # generalized svcparts ivan@sisd.com 98-mar-23
9 # You really need to enable ssh into a shell machine as this needs to rename
10 # .qmail-extension files.
12 # now an interactive script ivan@sisd.com 98-jun-30
14 # has an (untested) section for sendmail, s/warn/die/g and generates a program
15 # to run on your mail machine _later_ instead of ssh'ing for each user
16 # ivan@sisd.com 98-jul-13
18 # $Log: svc_acct_sm.import,v $
19 # Revision 1.2 1998-12-10 07:23:18 ivan
20 # use FS::Conf, need user (for datasrc)
24 use vars qw(%d_part_svc %m_part_svc);
26 use FS::UID qw(adminsuidsetup datasrc);
27 use FS::Record qw(qsearch qsearchs);
33 my $user = shift or die &usage;
36 my($spooldir)="/usr/local/etc/freeside/export.". datasrc;
46 map { $_->svcpart, $_ } qsearch('part_svc',{'svcdb'=>'svc_domain'});
48 map { $_->svcpart, $_ } qsearch('part_svc',{'svcdb'=>'svc_acct_sm'});
51 ( join "\n", map "$_: ".$d_part_svc{$_}->svc, sort keys %d_part_svc ),
52 "\n\nEnter part number for domains: ";
53 my($domain_svcpart)=&getvalue;
56 ( join "\n", map "$_: ".$m_part_svc{$_}->svc, sort keys %m_part_svc ),
57 "\n\nEnter part number for mail aliases: ";
58 my($mailalias_svcpart)=&getvalue;
61 Select your MTA from the following list.
63 print join "\n", map "$_: $mta{$_}", sort keys %mta;
67 if ( $mta{$mta} eq "qmail" ) {
70 Enter the location and name of your qmail control directory, for example
71 "mail.isp.com:/var/qmail/control"
74 my($control)=&getvalue;
75 iscp("root\@$control/rcpthosts","$spooldir/rcpthosts.import");
76 # iscp("root\@$control/recipientmap","$spooldir/recipientmap.import");
77 iscp("root\@$control/virtualdomains","$spooldir/virtualdomains.import");
79 # print "\n\n", <<END;
80 #Enter the name of the machine with your user .qmail files, for example
84 # my($shellmachine)=&getvalue;
86 } elsif ( $mta{$mta} eq "sendmail" ) {
89 Enter the location and name of your sendmail virtual user table, for example
90 "mail.isp.com:/etc/virtusertable"
93 my($virtusertable)=&getvalue;
94 iscp("root\@$virtusertable","$spooldir/virtusertable.import");
97 Enter the location and name of your sendmail.cw file, for example
98 "mail.isp.com:/etc/sendmail.cw"
101 my($sendmail_cw)=&getvalue;
102 iscp("root\@$sendmail_cw","$spooldir/sendmail.cw.import");
105 die "Unknown MTA!\n";
109 my($x)=scalar(<STDIN>);
118 $FS::svc_domain::whois_hack=1;
119 $FS::svc_acct_sm::nossh_hack=1;
121 if ( $mta{$mta} eq "qmail" ) {
122 open(RCPTHOSTS,"<$spooldir/rcpthosts.import")
123 or die "Can't open $spooldir/rcpthosts.import: $!";
124 } elsif ( $mta{$mta} eq "sendmail" ) {
125 open(RCPTHOSTS,"<$spooldir/sendmail.cw.import")
126 or die "Can't open $spooldir/sendmail.cw.import: $!";
128 die "Unknown MTA!\n";
133 while (<RCPTHOSTS>) {
136 #or do { warn "Strange rcpthosts/sendmail.cw line: $_"; next; };
137 or die "Strange rcpthosts/sendmail.cw line: $_";
140 unless ( $svc_domain = qsearchs('svc_domain', {'domain'=>$domain} ) ) {
141 $svc_domain = create FS::svc_domain ({
143 'svcpart' => $domain_svcpart,
146 my $error = $svc_domain->insert;
147 #warn $error if $error;
148 die $error if $error;
150 $svcnum{$domain}=$svc_domain->svcnum;
154 #these two loops have enough similar parts they should probably be merged
155 if ( $mta{$mta} eq "qmail" ) {
157 open(VD_FIX,">$spooldir/virtualdomains.FIX");
158 print VD_FIX "#!/usr/bin/perl\n";
160 open(VIRTUALDOMAINS,"<$spooldir/virtualdomains.import")
161 or die "Can't open $spooldir/virtualdomains.import: $!";
162 while (<VIRTUALDOMAINS>) {
164 /^\.?([\w\-\.]+):(\w+)(\-([\w\-\.]+))?$/
165 #or do { warn "Strange virtualdomains line: $_"; next; };
166 or die "Strange virtualdomains line: $_";
167 my($domain,$username,$dash_ext,$extension)=($1,$2,$3,$4);
170 my($svc_acct)=qsearchs('svc_acct',{'username'=>$username});
171 unless ( $svc_acct ) {
172 #warn "Unknown user $username in virtualdomains; skipping\n";
173 #die "Unknown user $username in virtualdomains; skipping\n";
176 if ( $domain ne $extension ) {
177 #warn "virtualdomains line $domain:$username$dash_ext changed to $domain:$username-$domain\n";
178 my($dir)=$svc_acct->dir;
179 my($qdomain)=$domain;
180 $qdomain =~ s/\./:/g; #see manpage for 'dot-qmail': EXTENSION ADDRESSES
181 #example to move .qmail files for virtual domains to their new location
183 #issh("root\@$shellmachine",'perl -e \'foreach $a (<'. $dir. '/.qmail'. $dash_ext. '-*>) { $old=$a; $a =~ s/\\.qmail'. $dash_ext. '\\-/\\.qmail\\-'. $qdomain. '\\-/; print " $old -> $a\n"; }\'');
185 #issh("root\@$shellmachine",'perl -e \'foreach $a (<'. $dir. '/.qmail'. $dash_ext. '-*>) { $old=$a; $a =~ s/\\.qmail'. $dash_ext. '\\-/\\.qmail\\-'. $qdomain. '\\-/; rename $old, $a; }\'');
187 foreach \$file (<$dir/.qmail$dash_ext-*>) {
189 \$file =~ s/\.qmail$dash_ext\-/\.qmail\-$qdomain\-/;
190 rename \$old, \$file;
195 unless ( exists $svcnum{$domain} ) {
196 my($svc_domain) = create FS::svc_domain ({
198 'svcpart' => $domain_svcpart,
201 my $error = $svc_domain->insert;
202 #warn $error if $error;
203 die $error if $error;
204 $svcnum{$domain}=$svc_domain->svcnum;
207 my($svc_acct_sm)=create FS::svc_acct_sm ({
208 'domsvc' => $svcnum{$domain},
209 'domuid' => $svc_acct->uid,
211 'svcpart' => $mailalias_svcpart,
214 $error=$svc_acct_sm->insert;
215 #warn $error if $error;
216 die $error, ", domain $domain" if $error;
218 close VIRTUALDOMAINS;
221 } elsif ( $mta{$mta} eq "sendmail" ) {
223 open(VIRTUSERTABLE,"<$spooldir/virtusertable.import")
224 or die "Can't open $spooldir/virtusertable.import: $!";
225 while (<VIRTUSERTABLE>) {
226 next if /^#/; #comments?
227 /^([\w\-\.]+)?\@([\w\-\.]+)\t([\w\-\.]+)$/
228 #or do { warn "Strange virtusertable line: $_"; next; };
229 or die "Strange virtusertable line: $_";
230 my($domuser,$domain,$username)=($1,$2,$3);
231 my($svc_acct)=qsearchs('svc_acct',{'username'=>$username});
232 unless ( $svc_acct ) {
233 #warn "Unknown user $username in virtusertable";
234 die "Unknown user $username in virtusertable";
237 my($svc_acct_sm)=create FS::svc_acct_sm ({
238 'domsvc' => $svcnum{$domain},
239 'domuid' => $svc_acct->uid,
240 'domuser' => $domuser || '*',
241 'svcpart' => $mailalias_svcpart,
244 $error=$svc_acct_sm->insert;
245 #warn $error if $error;
246 die $error if $error;
251 die "Unknown MTA!\n";
254 #open(RECIPIENTMAP,"<$spooldir/recipientmap.import");
257 print "\n\n", <<END if $mta{$mta} eq "qmail";
258 Don\'t forget to run $spooldir/virtualdomains.FIX before using
259 $spooldir/virtualdomains !
265 die "Usage:\n\n svc_acct_sm.export user\n";