[freeside] Importing & access to radius usage info within Freeside

The Salisburys rojee at bigpond.net.au
Wed Jun 16 03:56:55 PDT 2004


As freeside folks say adfinitum

don't use mysql 

Sorry for bad news
Roger



----- Original Message ----- 
From: <rls-freeside at powerband.net.au>
To: <ivan-freeside at sisd.com>
Sent: Wednesday, June 16, 2004 8:50 PM
Subject: [freeside] Importing & access to radius usage info within Freeside


> Hello,
> 
> In evaluating Freeside for our ISP, we've come up against
> a problem of identifying the processes & actions required to
> load or access radius-based "data usage" (ie: "AcctOutputOctets"
> & "AcctInputOctets") information for our user accounts in Freeside.
> 
> We've read the FAQs, RTFM'd & extensively searched the
> Mailing List & though there's a couple of entries about it,
> we can't identify the exact process required for Freeside to
> be able to access our radacct DBs (mySQL radius db's populated
> by Freeradius). We've also seen the entry in Radiator's FAQ
> about Freeside, which isn't encouraging (on the face of it),
> but if Radiator is better/best for use with Freeside
> than Freeradius, then please advise..
> 
> Our installation is using the following s/ware systems
> with Freeside:
> 
> FreeBSD 4.9
> FreeRADIUS 0.9.3 using
> mySQL 4.0.17 for radacct DB logging
> (we've installed both Freeside 1.4.1 & 1.5.0pre4)
> Perl 5.8.3 & all req'd Perl modules (notably CGI.pm 2.81,
> which we had to degrade to from 5.8.3's default installed 3.01)
> Apache 1.3.29 with mod_perl 1.29
> 
> We've configured services of the svc_acct type
> with an "sqlradius" export selected & setup packages
> with the "sqlradacct_hour" plan set & the Price Plan
> for these packages set to the "Base charge + charge per-hour
> (and for data) from an external sqlradius radacct table".
> When customers are added with these packages we can see
> 0 input & output usage in their Account View, but there is
> Online time usage information (though currently incorrect
> - we're still working on that one) displayed in the Acct View
> for these customers.
> 
> We note the "attribute_since_sqlradacct" function
> in cust_svc.pm (in 1.4.1) & the use of it for AcctOutputOctets
> & AcctInputOctets in view/svc_acct.cgi & edit/part_pkg.cgi
> for the 'sqlradacct_hour' plan, but where is the actual
> data imported into or read or processed by freeside on a regular
> or billing basis? (as opposed to a view basis)
> Is it freeside-daily, which we're running daily by cron & which
> is running fine for other acct types?
> -daily has & does process this sample customer, but is just
> listing the base monthly amount for the package, which includes
> data usage charging over a set amount of "output megabytes included".
> We believe that the 'session server' & thus the
> freeside-sqlradius-radacctd, freeradius-login & freeside_logout
> scripts & radiusd hooks are no longer used.. (?)
> 
> Apologies for any lack-of-clue shown here & in all other
> ways we're very impressed with Freeside. Kudos to Ivan & the
> other contributors to the system!
> 
> Regards & many thanks,
> Richard.
> 




More information about the freeside-users mailing list