X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=bin%2Fsqlradius.import;h=69361e8648f327b58d1060e8a4f772f5ec229e16;hp=587d828e43e20dde81e70ac74f721df5b015679b;hb=01776c9e52c63662403dcb19155ffe3bc8a035ee;hpb=59eec66f424ee1a5e25b2d5853dbe505581b9a07 diff --git a/bin/sqlradius.import b/bin/sqlradius.import old mode 100644 new mode 100755 index 587d828e4..69361e864 --- a/bin/sqlradius.import +++ b/bin/sqlradius.import @@ -3,7 +3,7 @@ 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); @@ -74,8 +74,8 @@ print "\n\n"; ### -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; @@ -116,8 +116,8 @@ while ( defined ( $row = $sth->fetchrow_arrayref ) ) { $rc_sth->execute($r_username, $realm) or die $rc_sth->errstr; foreach my $rc_row ( @{$rc_sth->fetchall_arrayref} ) { - my($attribute, $value, $name, $groupname) = @$row; - if ( $attribute =~ /^(Crypt-)?Password$/ ) { + my($attribute, $value, $name, $groupname) = @$rc_row; + if ( $attribute =~ /^((User|Crypt)-)?Password$/ ) { $password = $value; $finger = $name; $group = $groupname;