subject:"\(RADIATOR\) AuthBy SQL help"

RE: (RADIATOR) AuthBy SQL help- Resolved

2002-09-29 Thread Greg 'Rafiq' Clarkson


Hi Hugh et al

Thank you for forcing me to run radiator in the foreground.

>From the errors generated I managed to fix both problems.

They were both problem with the attributes assigned to particular column's
in the database.

In my first configuration I couldn't insert 'start' records as the table
expected non-null values for fields such as 'Acct-Session-Time,
Acct-Input-Octets and Acct-Output-Octetes' which were always going to be
null for a 'start' record!

So, I had to change one column's modifier from 'not-null=true' to
'not-null=false' to fix it.

The other configuration had a similar problem which prevented the 'stop'
records being inserted.

I am only new to radiator and I am sure I will have some more questions

Regards,

Greg


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

Re: (RADIATOR) AuthBy SQL help

2002-09-28 Thread 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 .  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:
>
> 
> IdentifierLocalDbAuth
> 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
>
> 
> 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:
>
> 
> IdentifierOldDbAuth
> 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

(RADIATOR) AuthBy SQL help

2002-09-27 Thread Greg 'Rafiq' Clarkson


Hi everybody,

I need some clarification for setting up .  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:


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


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:


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


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.

RE: (RADIATOR) AuthBy SQL help- Resolved

Re: (RADIATOR) AuthBy SQL help

(RADIATOR) AuthBy SQL help

3 matches

Site Navigation

Mail list logo

Footer information