(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@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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.