X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2Fbin%2Ffreeside-sqlradius-radacctd;h=7b2d04dc7348977be8e5dfd512ed1e7d6f9b3eea;hp=bf415961cb7cf3f61d764c54e86791cc707b8f90;hb=ac8410cdb67639afeb84c84e975fffadf3e6cce1;hpb=7422aa77086326ba1e6032150ce5704d1003ea6f diff --git a/FS/bin/freeside-sqlradius-radacctd b/FS/bin/freeside-sqlradius-radacctd index bf415961c..7b2d04dc7 100644 --- a/FS/bin/freeside-sqlradius-radacctd +++ b/FS/bin/freeside-sqlradius-radacctd @@ -9,6 +9,7 @@ use FS::Daemon qw(daemonize1 drop_root logfile daemonize2 sigint sigterm); use FS::UID qw(adminsuidsetup); #forksuidsetup driver_name dbh myconnect); use FS::Record qw(qsearch); # qsearchs); use FS::part_export; +use FS::part_export::sqlradius; #use FS::svc_acct; #use FS::cust_svc; @@ -23,26 +24,16 @@ drop_root(); adminsuidsetup $user; -logfile( "%%%FREESIDE_CONF%%%/sqlradius-radacctd-log.". $FS::UID::datasrc ); +logfile( "%%%FREESIDE_LOG%%%/sqlradius-radacctd-log.". $FS::UID::datasrc ); daemonize2(); #-- -#don't just look for ->can('usage_sessions'), we're sqlradius-specific -# (radiator is supposed to be setup with a radacct table) +my @part_export = FS::part_export::sqlradius->all_sqlradius_withaccounting(); -@part_export = - qsearch('part_export', { 'exporttype' => 'sqlradius' } ); -push @part_export, - qsearch('part_export', { 'exporttype' => 'sqlradius_withdomain' } ); -push @part_export, - qsearch('part_export', { 'exporttype' => 'radiator' } ); - -@part_export = grep { ! $_->option('ignore_accounting') } @part_export; - -die "no sqlradius, sqlradius_withdomain or radiator exports without". - " ignore_accounting" +die "no sqlradius, sqlradius_withdomain, radiator or phone_sqlradius exports". + " without ignore_accounting" unless @part_export; while (1) { @@ -64,7 +55,7 @@ while (1) { adminsuidsetup($user); #get our own db handle until ( sigint || sigterm ) { - $part_export->update_svc_acct(); + $part_export->update_svc(); sleep 1; } @@ -129,13 +120,17 @@ freeside-sqlradius-radacctd - Real-time radacct import daemon Imports records from an the SQL radacct tables of all sqlradius, sqlradius_withdomain and radiator exports (except those with the -ignore_accounting flag) and updates the svc_acct.seconds for each account. -Runs as a daemon and updates the database in real-time. +ignore_accounting flag) and updates the following fields in svc_acct (see +L) for each account: last_login, last_logout, seconds, +upbytes, downbytes, totalbytes. Runs as a daemon and updates the database +in real-time. B is a username added by freeside-adduser. =head1 RADIUS DATABASE CHANGES +In 1.7.4+, freeside-upgrade should have taken care of these changes already. + ALTER TABLE radacct ADD COLUMN FreesideStatus varchar(32) NULL; If you want to ignore the existing accountg records, also do: