3 # $Id: svc_acct.import,v 1.5 1999-03-25 08:42:19 ivan Exp $
5 # ivan@sisd.com 98-mar-9
7 # changed 'password' field to '_password' because PgSQL 6.3 reserves this word
8 # bmccane@maxbaud.net 98-Apr-3
10 # generalized svcparts (still needs radius import) ivan@sisd.com 98-mar-23
12 # radius import, now an interactive script. still needs erpcd import?
13 # ivan@sisd.com 98-jun-24
15 # arbitrary radius attributes ivan@sisd.com 98-aug-9
17 # don't import /var/spool/freeside/conf/shells! ivan@sisd.com 98-aug-13
19 # $Log: svc_acct.import,v $
20 # Revision 1.5 1999-03-25 08:42:19 ivan
21 # import stuff uses Term::Query and spits out (some kinds of) nonsensical input
23 # Revision 1.4 1999/03/24 00:43:38 ivan
24 # die if no relevant services
26 # Revision 1.3 1998/12/10 07:23:16 ivan
27 # use FS::Conf, need user (for datasrc)
29 # Revision 1.2 1998/10/13 12:07:51 ivan
30 # Assigns password from the shadow file for RADIUS password "UNIX"
34 use vars qw(%part_svc);
36 use Term::Query qw(query);
38 use FS::UID qw(adminsuidsetup datasrc);
39 use FS::Record qw(qsearch);
43 my $user = shift or die &usage;
46 my($spooldir)="/usr/local/etc/freeside/export.". datasrc;
48 $FS::svc_acct::nossh_hack = 1;
52 %part_svc=map { $_->svcpart, $_ } qsearch('part_svc',{'svcdb'=>'svc_acct'});
54 die "No services with svcdb svc_acct!\n" unless %part_svc;
56 print "\n\n", &menu_svc, "\n", <<END;
57 Most accounts probably have entries in passwd and users (with Port-Limit
60 my($ppp_svcpart)=&getpart;
62 print "\n\n", &menu_svc, "\n", <<END;
63 Some accounts have entries in passwd and users, but with Port-Limit 2 (or
66 my($isdn_svcpart)=&getpart;
68 print "\n\n", &menu_svc, "\n", <<END;
69 Some accounts might have entries in users only (Port-Limit 1)
71 my($oppp_svcpart)=&getpart;
73 print "\n\n", &menu_svc, "\n", <<END;
74 Some accounts might have entries in users only (Port-Limit >= 2)
76 my($oisdn_svcpart)=&getpart;
78 print "\n\n", &menu_svc, "\n", <<END;
79 POP mail accounts have entries in passwd only, and have a particular shell.
81 my($pop_shell)=&getvalue("Enter that shell:");
82 my($popmail_svcpart)=&getpart;
84 print "\n\n", &menu_svc, "\n", <<END;
85 Everything else in passwd is a shell account.
87 my($shell_svcpart)=&getpart;
90 Enter the location and name of your _user_ passwd file, for example
91 "mail.isp.com:/etc/passwd" or "nis.isp.com:/etc/global/passwd"
93 my($loc_passwd)=&getvalue(":");
94 iscp("root\@$loc_passwd", "$spooldir/passwd.import");
97 Enter the location and name of your _user_ shadow file, for example
98 "mail.isp.com:/etc/shadow" or "bsd.isp.com:/etc/master.passwd"
100 my($loc_shadow)=&getvalue(":");
101 iscp("root\@$loc_shadow", "$spooldir/shadow.import");
104 Enter the location and name of your radius "users" file, for example
105 "radius.isp.com:/etc/raddb/users"
107 my($loc_users)=&getvalue(":");
108 iscp("root\@$loc_users", "$spooldir/users.import");
111 ( join "\n", map "$_: ".$part_svc{$_}->svc, sort keys %part_svc ). "\n";
114 $^W=0; # Term::Query isn't -w-safe
115 query "Enter part number:", 'irk', [ keys %part_svc ];
120 $^W=0; # Term::Query isn't -w-safe
129 open(PASSWD,"<$spooldir/passwd.import");
130 open(SHADOW,"<$spooldir/shadow.import");
131 open(USERS,"<$spooldir/users.import");
133 my(%upassword,%ip,%allparam);
134 my(%param,$username);
139 /^(\w+)\s+Password\s+=\s+"([^"]+)"(,\s+Expiration\s+=\s+"([^"]*")\s*)?$/
140 or die "1Unexpected line in users.import: $_";
141 my($password,$expiration);
142 ($username,$password,$expiration)=(lc($1),$2,$4);
143 $password = '' if $password eq 'UNIX';
144 $upassword{$username}=$password;
147 die "2Unexpected line in users.import: $_";
152 $ip{$username}=$param{'radius_Framed_IP_Address'}||'0e0';
153 delete $param{'radius_Framed_IP_Address'};
154 $allparam{$username}={ %param };
156 } elsif ( /^\s+([\w\-]+)\s=\s"?([\w\.\-\s]+)"?,?\s*$/ ) {
157 my($attribute,$value)=($1,$2);
158 $attribute =~ s/\-/_/g;
159 $param{'radius_'.$attribute}=$value;
161 die "3Unexpected line in users.import: $_";
165 #? incase there isn't a terminating blank line ?
166 $ip{$username}=$param{'radius_Framed_IP_Address'}||'0e0';
167 delete $param{'radius_Framed_IP_Address'};
168 $allparam{$username}={ %param };
173 my($username,$password)=split(/:/);
174 $password{$username}=$password;
179 my($username,$x,$uid,$gid,$finger,$dir,$shell)=split(/:/);
180 my($password)=$upassword{$username} || $password{$username};
182 my($maxb)=${$allparam{$username}}{'radius_Port_Limit'};
184 if ( exists $upassword{$username} ) {
186 $svcpart = $isdn_svcpart
187 } elsif ( ! $maxb || $maxb == 1 ) {
188 $svcpart = $ppp_svcpart
190 die "Illegal Port-Limit in users ($username)!\n";
192 } elsif ( $shell eq $pop_shell ) {
193 $svcpart = $popmail_svcpart;
195 $svcpart = $shell_svcpart;
198 my($svc_acct) = new FS::svc_acct ({
199 'svcpart' => $svcpart,
200 'username' => $username,
201 'password' => $password,
207 'slipip' => $ip{$username},
208 %{$allparam{$username}},
211 $error=$svc_acct->insert;
212 die $error if $error;
214 delete $allparam{$username};
215 delete $upassword{$username};
219 foreach $username ( keys %upassword ) {
220 my($password)=$upassword{$username};
222 my($maxb)=${$allparam{$username}}{'radius_Port_Limit'} || 0;
225 $svcpart = $oisdn_svcpart
226 } elsif ( ! $maxb || $maxb == 1 ) {
227 $svcpart = $oppp_svcpart
229 die "Illegal Port-Limit in users!\n";
232 my($svc_acct) = new FS::svc_acct ({
233 'svcpart' => $svcpart,
234 'username' => $username,
235 'password' => $password,
236 'slipip' => $ip{$username},
237 %{$allparam{$username}},
240 $error=$svc_acct->insert;
241 die $error, if $error;
243 delete $allparam{$username};
244 delete $upassword{$username};
250 die "Usage:\n\n svc_acct.export user\n";