(RADIATOR) AuthBy SQL help

[Hugh Irvine]

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 at 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 radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' 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 radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.