use strict;
use vars qw(%part_svc %domain_part_svc);
#use Date::Parse;
-use DBI;
+use FS::DBI;
use Term::Query qw(query);
use FS::UID qw(adminsuidsetup); #datasrc
use FS::Record qw(qsearch qsearchs);
###
-my $dbh = DBI->connect( $datasrc, $db_user, $db_pass )
- or die $DBI::errstr;
+my $dbh = FS::DBI->connect( $datasrc, $db_user, $db_pass )
+ or die $FS::DBI::errstr;
my $sth = $dbh->prepare('SELECT DISTINCT UserName, Realm FROM radcheck')
or die $dbh->errstr;
}
}
- my( $password, $finger, $group ) = ( '', '', '' );
+ #my( $password, $finger, $group ) = ( '', '', '' );
+ my( $password, $group ) = ( '', '', '' );
my $rc_sth = $dbh->prepare(
'SELECT Attribute, Value, Name, GroupName'.
foreach my $rc_row ( @{$rc_sth->fetchall_arrayref} ) {
my($attribute, $value, $name, $groupname) = @$rc_row;
- if ( $attribute =~ /^(Crypt-)?Password$/ ) {
+ if ( $attribute =~ /^((Crypt|User)-)?Password$/ ) {
$password = $value;
- $finger = $name;
+ #$finger = $name;
$group = $groupname;
} else {
#handle other params!
qsearch('svc_acct', { 'username' => $username,
'domsvc' => $svc_domain->svcnum, } );
- print "$r_username / $realm: $password / $finger: ";
+ #print "$r_username / $realm: $password / $finger: ";
+ print "$r_username / $realm: $password: ";
if ( scalar(@svc_acct) == 0 ) {
print "not found\n";
next;
print "multiple matches found?!?!\n";
next;
} else {
- print "correcting password and name\n";
+ #print "correcting password and name\n";
+ print "correcting password\n";
}
my $svc_acct = $svc_acct[0];
- my $new = new FS::svc_acct { $svc_acct->hash, '_password' => $password, 'finger' => $finger };
+ #my $new = new FS::svc_acct { $svc_acct->hash, '_password' => $password, 'finger' => $finger };
+ my $new = new FS::svc_acct { $svc_acct->hash, '_password' => $password };
my $error = $new->replace($svc_acct);
#my $error = $new->check;
die "$r_username / $realm: $error" if $error;
}
sub usage {
- die "Usage:\n\n sqlradius.import user\n";
+ die "Usage:\n\n sqlradius.reimport user\n";
}