<div><br></div>Guys I have a interesting issue, that I am having issues resolving, I'm pretty sure I am missing something but not sure what. <div><br></div><div>Some brief history to start with. We are an ISP migrating to a new accounting package, this accounting package has a in built radius server, and as we provide tails to other companies we are going to keep Radiator as our primary Radius server that our NAS's talk directly to, so based on realm it can hand off the requests to other radius servers or authenticate them it's self. For our primary realms we are moving the authentication to this new accounting package, so radiator will be proxying this traffic. Due to some other complications we are doing a staged migration, and have a sql field in our existing Authby statement saying if it should auth the user or reject them, based on it being 0 or 1, if 1 then the request flows through to the new accounting package via a radius proxy authby. </div>
<div><br></div><div>The issue I am having is the accounting records do not flow through, so the new accounting package does not see the start/alive/stop records which it requires.</div><div><br></div><div>We are running Radiator 4.3.1 blow is the relevant bits of the config. Can anybody point me in the right direction.</div>
<div><br></div><div>thanks in advance.</div><div><br></div><div>Simon.</div><div><br></div><div>------</div><div><br></div><div><div><div><AuthBy SQL></div><div> Identifier AuthDB</div><div> DBSource dbi:mysql:authdb:localhost:3306</div>
<div> DBUsername username</div><div> DBAuth passsword</div><div> AuthColumnDef 0, User-Password, check</div><div> AuthColumnDef 1, Service-Type, reply</div><div> AuthColumnDef 2, Framed-Protocol, reply</div>
<div> AuthColumnDef 3, Framed-MTU, reply</div><div> AuthColumnDef 4, Framed-IP-Address, reply</div><div> AuthColumnDef 5, Framed-IP-Netmask,reply</div><div> AuthColumnDef 6, Framed-Route,reply</div>
<div> AuthColumnDef 7, Framed-Route,reply</div><div> AuthColumnDef 8, Filter-Id,reply</div><div> AuthColumnDef 9, Filter-Id,reply</div><div> AuthColumnDef 10, cisco-avpair, reply</div><div> AuthColumnDef 11, cisco-avpair, reply</div>
<div> AuthColumnDef 12, cisco-avpair, reply</div><div> AuthColumnDef 13, cisco-avpair, reply</div><div> AuthSelect select PASSWORD, SERVICE_TYPE, FRAMED_PROTOCOL, FRAMED_MTU, IP_ADDRESS, NETMASK, FRAMED_ROUTE, FRAMED_ROUTE2, FILTERIN, FILTEROUT, AVPAIR1, AVPAIR2, AVPAIR3, AVPAIR4 from adslusers where '%n' LIKE CONCAT(USERNAME,'@%') and NEWACCT='0'</div>
<div> NoDefault</div><div></AuthBy></div><div><br></div><div><br></div><div><AuthBy SQL></div><div> Identifier SQLAcct</div><div> DBAuth password</div><div> DBSource dbi:mysql:SQLaccounting:localhost:3306</div>
<div> DBUsername username</div><div> AuthSelect</div><div> AccountingTable freeway_acct</div><div> AcctColumnDef USERNAME,User-Name</div><div> AcctColumnDef TIME_STAMP,Timestamp,integer</div>
<div> AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type</div><div> AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer</div><div> AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer</div><div> AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer</div>
<div> AcctColumnDef ACCTSESSIONID,Acct-Session-Id</div><div> AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer</div><div> AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause</div><div> AcctColumnDef ACCTAUTHENTIC,Acct-Authentic</div>
<div> AcctColumnDef NASIDENTIFIER,NAS-Identifier</div><div> AcctColumnDef NASIDENTIFIER,NAS-IP-Address</div><div> AcctColumnDef NASPORT,NAS-Port,integer</div><div> AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address</div>
<div> AcctColumnDef CALLERID,Calling-Station-Id</div><div> AcctColumnDef CALLEDSTATIONID,Called-Station-Id</div><div> AcctColumnDef TUNNELSEREND,Tunnel-Server-Endpoint</div><div> AcctColumnDef TUNNELCLIEND,Tunnel-Client-Endpoint</div>
<div> AcctColumnDef TUNNELTYPE,Tunnel-Type</div><div> AcctColumnDef TUNNELSERAUTH,Tunnel-Server-Auth-ID</div><div> AcctColumnDef TUNNELID,Tunnel-ID</div><div></AuthBy></div><div><br></div>
<div><AuthBy GROUP></div><div> Identifier AuthDB</div><div> AuthByPolicy ContinueAlways</div><div> AuthBy SQLAcct</div><div> AuthBy AuthDB</div><div></AuthBy></div><div><br></div><div>
<AuthBy RADIUS></div><div> Identifier NEW_ACCT</div><div> Host 10.2.2.2</div><div> LocalAddress 10.1.1.1</div><div> Secret xxxx</div><div> AuthPort 1812</div><div> AcctPort 1813</div>
<div></AuthBy></div><div><br></div><div><Handler Realm=adsl.domain.tld></div><div> AuthByPolicy ContinueWhileReject</div><div> AuthBy AuthDB</div><div> AuthBy NEW_ACCT</div><div> PacketTrace</div>
<div></Handler></div><div><br></div></div><div><br></div></div><div><br>-- <br><br>
</div>