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
> 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.
>
>
> Identifier Cisco
> DBSourcedbi:mysql:radiator:x.x.x.x:3306
> DBUsername xx
> DBAuth xx
> 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
>
> Identifier radiator
> DBSourcedbi:mysql:radiator:x.x.x.x:3306
> DBUsername xx
> DBAuth xx
> AddQuery insert into RADONLINE (USERNAME, ACCTSESSIONID, TIME_STAMP,
> FRAMEDIPADDRESS) values ('%u', %3, %{Timestamp}, '%{Framed-IP-Address}')
>
>
>
>
> SessionDatabase radiator
> AuthByPolicy ContinueUntilAccept
> AuthBy Cisco
>
>
>
> Moded for auth only
>
>
> Identifier Cisco
> DBSourcedbi:mysql:radiator:x.x.x.x:3306
> DBUsername xx
> DBAuth xx
> AuthSelect select PASSWORD from SUBSCRIBERS where USERNAME=%0
> AuthColumnDef 0, User-Password, check
>
>
>
> AuthByPolicy ContinueUntilAccept
> AuthBy Cisco
>
>
>
>
>
>
> --
> Gabe Carmichael
> Device Management/Network/Voip Administrator
> Lower Kuskokwim School District
> 907-543-4860
> LKSD Internal 4 digit dial - 4860
> Skype: gabes72riv
> g...@lksd.org
> ___
> radiator mailing list
> radiator@lists.open.com.au
> https://lists.open.com.au/mailman/listinfo/radiator
___
radiator mailing list
radiator@lists.open.com.au
https://lists.open.com.au/mailman/listinfo/radiator
