Hello Greg -
I will need to see a complete copy of your configuration file, together
with a trace 4 debug from Radiator showing what is happening.
regards
Hugh
On Saturday, September 28, 2002, at 10:58 AM, Greg 'Rafiq' Clarkson
wrote:
> Hi everybody,
>
> I need some clarification for setting up <AuthBy SQL>. I am using
> Radiator-3.3.1. and any help will be greatly appreciated.
>
> I am experimenting with different accounting tables with different
> AcctColumnDef.
>
> The problem is that one configuration only writes records where
> "Acct-Status-Type = Start" and the other configuration only writes
> records
> where "Acct-Status-Type = Stop"!
>
> All other records are written to the FailedLog.
>
> My question is:
> Do I need to define *all* fields sent from the NAS for both Start and
> Stop
> records in the one table to successfully write the record to SQL?
>
> I thought if I didn't define the field it would drop that particular
> field
> but insert all the other fields.
>
> For example one of my configurations uses the default setup as detailed
> below:
>
> <AuthBy SQL>
> Identifier LocalDbAuth
> IgnoreAuthentication
> DBSource %{GlobalVar:dbSpec}
> DBUsername %{GlobalVar:dbUser}
> DBAuth %{GlobalVar:dbPass}
> #AccountingStartsOnly
> #AccountingStopsOnly
> HandleAcctStatusTypes Start,Stop
> DateFormat %Y-%m-%d %H:%M:%S
>
> 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 %L/detail.newdb
>
> </AuthBy SQL>
> Only "Start" records are written. And this is the record written to the
> FailedLog:
>
>
> root@echelon:radius: # head -50 detail.newdb
> Fri Sep 27 12:33:21 2002
> Acct-Session-Id = "0002BA2F"
> Framed-Protocol = PPP
> Framed-IP-Address = 203.220.179.32
> Acct-Terminate-Cause = Lost-Carrier
> Ascend-Disconnect-Cause = 816
> Ascend-Connect-Progress = prLanSessionUp
> Ascend-PreSession-Time = 21
> Ascend-Xmit-Rate = 26400
> Ascend-Data-Rate = 26400
> Acct-Session-Time = 334
> Connect-Info = "26400 V34/V42bis/LAPM (28800)"
> Acct-Input-Octets = 75662
> Acct-Output-Octets = 305795
> Ascend-Pre-Input-Octets = 118
> Ascend-Pre-Output-Octets = 114
> Acct-Input-Packets = 465
> Acct-Output-Packets = 397
> Ascend-Pre-Input-Packets = 5
> Ascend-Pre-Output-Packets = 5
> Acct-Authentic = RADIUS
> Acct-Status-Type = Stop
> NAS-Port = 7315
> Called-Station-Id = "142320198333015"
> Calling-Station-Id = "357213687"
> NAS-Port-Type = Async
> Service-Type = Framed-User
> NAS-IP-Address = 203.220.246.113
> Event-Timestamp = 1033093991
> Acct-Delay-Time = 10
> User-Name = "kph"
> Proxy-State =
> BSP2ims01-syd/
> FEDEB6CC27A3A223FA1BF8E5C5231E60B56504FF7E0D088FB185BF15044FE4
> EA88F6C7EF7E0D08AC7A5949EC0221F87B432A74AF7E1F0BF280F6CBF26276B02ECFC7B
> 4FB11
> 6B31BAE6C2D4ED6C
> Timestamp = 1033093991
>
>
>
> Whereas in a more complex setup:
>
> <AuthBy SQL>
> Identifier OldDbAuth
> IgnoreAuthentication
> DBSource %{GlobalVar:dbSpec}
> DBUsername %{GlobalVar:dbUser}
> DBAuth %{GlobalVar:dbPass}
> #AccountingStartsOnly
> #AccountingStopsOnly
> HandleAcctStatusTypes Start,Stop
> DateFormat %Y-%m-%d %H:%M:%S
>
> AccountingTable sessions
> AcctColumnDef username,User-Name
> AcctColumnDef time,Timestamp,integer-date
> AcctColumnDef calledstation,Called-Station-Id
> AcctColumnDef callingstation,Calling-Station-Id
> AcctColumnDef nas,NAS-IP-Address
> AcctColumnDef port,NAS-Port,integer
> AcctColumnDef sessionid,Acct-Session-Id
> AcctColumnDef ipaddress,Framed-IP-Address
> AcctColumnDef duration,Acct-Session-Time,integer
> AcctColumnDef upload,Acct-Input-Octets,integer
> AcctColumnDef download,Acct-Output-Octets,integer
> AcctColumnDef rx,Ascend-Xmit-Rate,integer
> AcctColumnDef tx,Ascend-Data-Rate,integer
> AcctColumnDef terminatecause,Ascend-Disconnect-Cause
> AcctColumnDef acctstatustype,Acct-Status-Type
>
> AcctFailedLogFileName %L/detail.OldDbAuth
> </AuthBy>
>
> The reverse is true. ie the Stops are written but the Starts fail.
>
> Any help will be greatly appreciated.
>
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on [EMAIL PROTECTED]
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
>
>
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
