[RADIATOR] Mod Authby SQL Query

[Gabe Carmichael]

Thank you sir.

On Mon, Jan 8, 2024 at 8:21 PM Hugh Irvine <hugh at irvine.com.au> wrote:

>
> Hello Gabe -
>
> Nice to hear from you - best wishes for 2024.
>
> What you show below looks correct.
>
> And as a general rule it is a good idea to run separate instances of
> Radiator for authentication and accounting, one running on port numbers
> 1645, 1812 for authentication and the other on 1646, 1813 for accounting.
>
> The authentication instance would have this in the configuration file:
>
> AuthPort  1645, 182
>
> AcctPort
>
> and the accounting instance would have this:
>
> AuthPort
>
> AcctPort  1646, 1813
>
> regards
>
> Hugh
>
>
> > On 9 Jan 2024, at 16:09, Gabe Carmichael via radiator <
> radiator at lists.open.com.au> wrote:
> >
> > Good evening,
> > I am hoping to get some help on a setup that we have had running for
> years without much trouble. All the sudden after having some issues with
> our wireless controller after updating to the latest supported firmware
> version, I am being asked to split up auth and accounting to two separate
> servers to get things resolved. The issue I am having is a timeout issue
> which we have not seen before.  I have included a redacted part of my
> config that I am wondering if I have edited correctly.
> >
> > I need to remove all the accounting input from the auth server, and just
> have it do auth. Here is what it currently is, and at the bottom what I
> think it should be. Would appreciate any and all answers.
> >
> > <AuthBy SQL>
> > Identifier Cisco
> > DBSource        dbi:mysql:radiator:x.x.x.x:3306
> > DBUsername      xxxxxx
> > DBAuth          xxxxxx
> > AuthSelect select PASSWORD from SUBSCRIBERS where USERNAME=%0
> > AuthColumnDef 0, User-Password, check
> > AccountingTable ACCOUNTING
> > AcctColumnDef USERNAME,User-Name
> > AcctColumnDef TIME_STAMP,Timestamp,integer
> > AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
> > AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer
> > AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer
> > AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
> > AcctColumnDef ACCTSESSIONID,Acct-Session-Id
> > AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer
> > AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause
> > AcctColumnDef NASIDENTIFIER,NAS-Identifier
> > AcctColumnDef NASPORT,NAS-Port,integer
> > AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
> > AcctFailedLogFileName /etc/radiator/missedaccounting
> > SQLRecoveryFile /etc/radiator/missedaccounting
> > <SessionDatabase SQL>
> > Identifier radiator
> > DBSource        dbi:mysql:radiator:x.x.x.x:3306
> > DBUsername      xxxxxx
> > DBAuth          xxxxxx
> > AddQuery insert into RADONLINE (USERNAME, ACCTSESSIONID, TIME_STAMP,
> FRAMEDIPADDRESS) values ('%u', %3, %{Timestamp}, '%{Framed-IP-Address}')
> > </SessionDataBase>
> >    </AuthBy>
> >
> >   <Handler Client-Identifier = 5520-02>
> >         SessionDatabase radiator
> >         AuthByPolicy ContinueUntilAccept
> >         AuthBy Cisco
> > </Handler>
> >
> >
> > Moded for auth only
> >
> > <AuthBy SQL>
> > Identifier Cisco
> > DBSource        dbi:mysql:radiator:x.x.x.x:3306
> > DBUsername      xxxxxx
> > DBAuth          xxxxxx
> > AuthSelect select PASSWORD from SUBSCRIBERS where USERNAME=%0
> > AuthColumnDef 0, User-Password, check
> >    </AuthBy>
> >
> >   <Handler Client-Identifier = 5520-02>
> >         AuthByPolicy ContinueUntilAccept
> >         AuthBy Cisco
> > </Handler>
> >
> >
> >
> >
> >
> > --
> > Gabe Carmichael
> > Device Management/Network/Voip Administrator
> > Lower Kuskokwim School District
> > 907-543-4860
> > LKSD Internal 4 digit dial - 4860
> > Skype: gabes72riv
> > gabe at lksd.org
> > _______________________________________________
> > radiator mailing list
> > radiator at lists.open.com.au
> > https://lists.open.com.au/mailman/listinfo/radiator
>
>
>

-- 

Gabe Carmichael
Device Management/Network/Voip Administrator
Lower Kuskokwim School District
907-543-4860
LKSD Internal 4 digit dial - 4860
Skype: gabes72riv
gabe at lksd.org <gabe_carmichael at lksd.org>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.open.com.au/pipermail/radiator/attachments/20240109/872c8297/attachment.html>