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 <[email protected]> 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) > [email protected] > > > > > > > > > > > > > > -----Original Message----- > From: Hugh Irvine > Sent: Tuesday, July 30, 2019 4:41 PM > To: Brandon Shiers <[email protected]> > Cc: [email protected] > 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 <[email protected]> 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 >> [email protected] >> https://lists.open.com.au/mailman/listinfo/radiator > > > -- > > Hugh Irvine > [email protected] > > 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 [email protected] 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. _______________________________________________ radiator mailing list [email protected] https://lists.open.com.au/mailman/listinfo/radiator
