Thank you sir. On Mon, Jan 8, 2024 at 8:21 PM Hugh Irvine <h...@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@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 > > g...@lksd.org > > _______________________________________________ > > radiator mailing list > > radiator@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 g...@lksd.org <gabe_carmich...@lksd.org>
_______________________________________________ radiator mailing list radiator@lists.open.com.au https://lists.open.com.au/mailman/listinfo/radiator