[RADIATOR] Using FreeRadius Emulation for Accounting

Hugh Irvine hugh at open.com.au
Wed Jul 31 22:28:50 UTC 2019


Hi Brandon -

Yes correct - if you need to you can alter the queries as you’ve listed.

regards

Hugh

> On 31 Jul 2019, at 23:32, Brandon Shiers <brandon.shiers at cerento.com> wrote:
> 
> If I wanted to use the AuthByFreeRadiusSQL since my authorization handler for this particular service uses it, I presume all I'd need to do is the following:
> 
> <Handler Client-Identifier=Fast-Fiber>
> <AuthBy FREERADIUSSQL>
>  Identifier Fast-Fiber
>  DBSource dbi:mysql:hostname=localhost;database=foo
>  DBUsername foo
>  DBAuth bar
>  FailureBackoffTime 5
>  Timeout 30
> </AuthBy>
> </Handler>
> 
> 
> From looking at the manual it looks like specifying the AcctOnoffQuery, AccountStartQuery,AcctStartQueryAlt,AcctUpdateQuery,AcctUpdateQueryAlt,AcctStopQuery,AcctStopQueryAlt are all optional, I'm presuming if I don't specify anything there the server would use the standard queries that say come in the dialup.conf file with a standard Freeradius install, is that correct, much like setting up authentication does?
> 
> Thanks,
> Brandon Shiers, RF Engineer
> 937 West Main Street
> Riverton, WY 82501
> 307.857.6704 (o)
> 307.840.2366 (c)
> 307.856.1499 (f)
> brandon.shiers at cerento.com
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> -----Original Message-----
> From: Hugh Irvine 
> Sent: Tuesday, July 30, 2019 4:41 PM
> To: Brandon Shiers <brandon.shiers at wyoming.com>
> Cc: radiator at lists.open.com.au
> Subject: Re: [RADIATOR] Using FreeRadius Emulation for Accounting
> 
> 
> Hello Brandon -
> 
> If you are using a FreeRadius SQL database you can use the AuthBy FREERADIUSSQL clause.
> 
> See section 3.81 in the Radiator-4.23 reference manual (“doc/ref.pdf”).
> 
> There is also an example in “goodies/freeradiussql.cfg”.
> 
> Typically you would do something like this:
> 
> …….
> 
> # Handler to process accounting requests
> 
> <Handler Request-Type = Accounting-Request>
> 	<AuthBy FREERADIUSSQL>
> 		…..
> 	</AuthBy>
> 	…..
> </Handler>
> 
> # the rest of your Handlers for authentication
> 
> …...
> 
> Let me know if you have any further questions.
> 
> regards
> 
> Hugh
> 
> 
>> On 31 Jul 2019, at 02:24, Brandon Shiers <brandon.shiers at wyoming.com> wrote:
>> 
>> Looking through the documentation and the goodies directory, I don't see a real good example of how do do the accounting setup and write to my accounting database.  Any suggestions or real-world examples?  I do have devices that will send interim updates so I will need the capability to account for that.  
>> _______________________________________________
>> radiator mailing list
>> radiator at lists.open.com.au
>> https://lists.open.com.au/mailman/listinfo/radiator
> 
> 
> --
> 
> Hugh Irvine
> hugh at open.com.au
> 
> Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, TTLS, PEAP, TNC, WiMAX, RSA, Vasco, Yubikey, MOTP, HOTP, TOTP, DIAMETER, SIM, etc. 
> Full source on Unix, Linux, Windows, macOS, Solaris, VMS, NetWare etc.
> 


--

Hugh Irvine
hugh at open.com.au

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, 
TTLS, PEAP, TNC, WiMAX, RSA, Vasco, Yubikey, MOTP, HOTP, TOTP,
DIAMETER, SIM, etc. 
Full source on Unix, Linux, Windows, macOS, Solaris, VMS, NetWare etc.



More information about the radiator mailing list