[RADIATOR] Using FreeRadius Emulation for Accounting

[Hugh Irvine]

Hi -

In that case yes, use the AuthBy SQL and the appropriate table and fields.

Something like this:

# Handler for accounting

<Handler Request-Type = Accounting-Request>
	<AuthBy SQL>
		…..
		AccountingTable ….
		AcctColumnDef …..
		……
	</AuthBy>
	…..
</Handler>

regards

Hugh


> On 31 Jul 2019, at 08:42, Brandon Shiers <brandon.shiers at cerento.com> wrote:
> 
> Hugh,
> 
> I am use to using just AuthBySQL.  Is there anything free-radius centric I need to do or just map my fields/etc like I normally would and tell it where to write and give it the credentials?
> 
> 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.