(RADIATOR) AuthBy SQL help

[Greg 'Rafiq' Clarkson]

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
EA88F6C7EF7E0D08AC7A5949EC0221F87B432A74AF7E1F0BF280F6CBF26276B02ECFC7B4FB11
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.