Freeside:1.9:Documentation:Developer/bin/freeside-sqlradius-radacctd

From Freeside
< Freeside:1.9:Documentation:Developer
Revision as of 16:56, 3 October 2007 by Ivan (talk | contribs) (import from POD)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

NAME

freeside-sqlradius-radacctd - Real-time radacct import daemon

SYNOPSIS

 freeside-sqlradius-radacctd username

DESCRIPTION

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.

username is a username added by freeside-adduser.

RADIUS DATABASE CHANGES

ALTER TABLE radacct ADD COLUMN FreesideStatus varchar(32) NULL;

If you want to ignore the existing accountg records, also do:

UPDATE radacct SET FreesideStatus = 'done' WHERE FreesideStatus IS NULL;

SEE ALSO