(RADIATOR) Double Accounting Stops - How to ignore one?

Frank Danielson fdanielson at csky.com
Fri May 20 06:47:34 CDT 2005


Hugh had suggested making a unique index of ACCTSESSIONID and TIME_STAMP to
avoid this problem. You could also consider using ACCTSESSIONID and
FRAMEDIPADDRESS or NASPORT. The idea is to use the session id and another
paramter so the combined key is unlikely to be duplicated.

Hope this helps.

-Frank

-----Original Message-----
From: Kheng Teong, Lim [mailto:ktlim at uberfusion.com]
Sent: Friday, May 20, 2005 6:08 AM
To: 'Hugh Irvine'
Cc: radiator at open.com.au
Subject: RE: (RADIATOR) Double Accounting Stops - How to ignore one?


Hi Hugh,

Thanks for your post.
I thought you had mentioned that we should not make ACCTSESSIONID unique as
it will wrap-around?

>> It is not a good idea to make the index on the ACCTSESSIONID field
unique, as the values for this field will eventually wrap around and be
reused by the NAS(s). 

Thanks...

--
Warm Regards,
Kheng Teong, Lim
 
Chief Information Officer
UberFusion Sdn. Bhd.
-----------------------------------------------------------
UberFusion Sdn. Bhd.
No. 119, (3rd Floor) Jalan SS6/12,
Kelana Jaya Urban Centre,
47301 Petaling Jaya,
Selangor Darul Ehsan, MALAYSIA.
Tel: 03-7880 6580 / Fax: 03-7880 6590
http://www.uberfusion.com
------------------------------------------------------------

-----Original Message-----
From: Hugh Irvine [mailto:hugh at open.com.au] 
Sent: Friday, May 20, 2005 2:53 AM
To: ktlim at uberfusion.com
Cc: radiator at open.com.au
Subject: Re: (RADIATOR) Double Accounting Stops - How to ignore one?


Hello Lim -

You could try making a unique index on the combination of ACCTSESSIONID and
TIME_STAMP.

regards

Hugh


On 19 May 2005, at 20:05, Kheng Teong, Lim wrote:

> Hi Hugh,
>
> Thanks for your ultra-fast response and help!
> I've added exactly what you posted and its working great... There is 
> no more double deduction anymore.
>
> One slight problem tho' RADUSAGE is still getting double entries.  
> (ie. As in its still entering it twice into the table).
> Is there anyway to overcome it?
>
> Thanks lots!
>
> --
> Warm Regards,
> Kheng Teong, Lim
>
> Chief Information Officer
> UberFusion Sdn. Bhd.
> -----------------------------------------------------------
> UberFusion Sdn. Bhd.
> No. 119, (3rd Floor) Jalan SS6/12,
> Kelana Jaya Urban Centre,
> 47301 Petaling Jaya,
> Selangor Darul Ehsan, MALAYSIA.
> Tel: 03-7880 6580 / Fax: 03-7880 6590
> http://www.uberfusion.com
> ------------------------------------------------------------
>
> -----Original Message-----
> From: Hugh Irvine [mailto:hugh at open.com.au]
> Sent: Thursday, May 19, 2005 12:22 PM
> To: ktlim at uberfusion.com
> Cc: 'Frank Danielson'; radiator at open.com.au
> Subject: Re: (RADIATOR) Double Accounting Stops - How to ignore one?
>
> Hello Lim, Hello Frank -
>
> It is not a good idea to make the index on the ACCTSESSIONID field 
> unique, as the values for this field will eventually wrap around and 
> be reused by the NAS(s).
>
> As mentioned in my other mail a better approach is to add a 
> LASTACCTUPDATE field to the RADUSERS table and then do something like
> this:
>
>          AcctSQLStatement update RADUSERS set \
>              LASTACCTUPDATE = %{Timestamp}, \
>              TIMELEFT=TIMELEFT-0%{Acct-Session-Time}, \
>              OCTETSINLEFT=OCTETSINLEFT-0%{Acct-Input-Octets}, \
>              OCTETSOUTLEFT=OCTETSOUTLEFT-0%{Acct-Output-Octets}, \
>              TOTALOCTETSLEFT=TOTALOCTETSLEFT-0%{Acct-Input-Octets}, \
>              TOTALOCTETSLEFT=TOTALOCTETSLEFT-0%{Acct-Output-Octets} \
>              where USERNAME='%n' and LASTACCTUPDATE < %{Timestamp}
>
> regards
>
> Hugh
>
>
> On 19 May 2005, at 13:54, Kheng Teong, Lim wrote:
>
>
>> Hi Frank/All,
>>
>> Call me a dunce or what, but I don't know how to reverse the order of 
>> the Authby SQL statement to enable the RADUSAGE query to fire first.
>> I have already made the ACCTSESSIONID field in the RADUSAGE table 
>> unique.
>>
>> Please see below for my config file:
>>
>> Thanks in advance.
>>
>> [Radiator Config File]
>> Trace           4
>> LogDir          /var/log/radius
>> DbDir           /etc/radiator
>>
>> <Client DEFAULT>
>>         Secret  abc123
>>         DupInterval 2
>> </Client>
>>
>> <ClientListSQL>
>>         DBSource        dbi:mysql:radmin:localhost
>>         DBUsername      radmin
>>         DBAuth          test
>> </ClientListSQL>
>>
>> <Realm DEFAULT>
>>         Description     Default Realm for authenticating users
>>
>>     <AuthBy SQL>
>>         Identifier      SUBSCRIBERS
>>         DBSource        dbi:mysql:radmin:localhost
>>         DBUsername      radmin
>>         DBAuth          test
>>
>>         Description     Database to authenticate users
>>
>>         NoDefault
>>
>>         DefaultSimultaneousUse  1
>>
>>         # # Let the user in if they have any time left and set the 
>> Session-timeout to the time left
>>         #
>>         AuthSelect select PASS_WORD, STATICADDRESS, TIMELEFT, 
>> MAXLOGINS, SERVICENAME, BADLOGINS, VALIDFROM, VALIDTO, \
>>         from RADUSERS where USERNAME=%0 and TIMELEFT > 0 and 
>> VALIDFROM < %t and VALIDTO > %t \
>>         and ACCOUNTSTATUS > 0 and TOTALOCTETSLEFT > 0
>>         AuthColumnDef   0,User-Password,check
>>         AuthColumnDef   1,Framed-IP-Address,reply
>>         AuthColumnDef   2,Session-Timeout,reply
>>         AuthColumnDef   3,Simultaneous-Use,check
>>
>>         AccountingTable RADUSAGE
>>         AcctColumnDef   USERNAME,User-Name
>>         AcctColumnDef   TIME_STAMP,%b-0%{Acct-Session-Time},literal
>>         AcctColumnDef   ACCTSTATUSTYPE,Acct-Status-Type,integer
>>         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,integer
>>         AcctColumnDef   DNIS,Called-Station-Id
>>         AcctColumnDef   FRAMEDIPADDRESS,Calling-Station-Id
>>         AcctColumnDef   NASIDENTIFIER,NAS-IP-Address
>>         AcctColumnDef   NASIDENTIFIER,NAS-Identifier
>>         AcctColumnDef   NASPORT,NAS-Port,integer
>>
>>         HandleAcctStatusTypes Stop
>>
>>         AcctSQLStatement update RADUSERS set 
>> TIMELEFT=TIMELEFT-0%{Acct-Session-Time}, \
>>         OCTETSINLEFT=OCTETSINLEFT-0%{Acct-Input-Octets},
>> OCTETSOUTLEFT=OCTETSOUTLEFT-0%{Acct-Output-Octets}, \
>>         TOTALOCTETSLEFT=TOTALOCTETSLEFT-0%{Acct-Input-Octets},
>> TOTALOCTETSLEFT=TOTALOCTETSLEFT-0%{Acct-Output-Octets} \
>>         where USERNAME='%n'
>>
>>         AcctFailedLogFileName   %L/missedaccounting
>>
>>         SQLRecoveryFile         %L/sqlfailures
>>     </AuthBy>
>>
>>     <AuthLog SQL>
>>         DBSource        dbi:mysql:radmin:localhost
>>         DBUsername      radmin
>>         DBAuth          test
>>
>>         LogSuccess
>>         SuccessQuery insert into RADAUTHLOG (TIME_STAMP, USERNAME,
>> TYPE)
>> values (%t, '%n', 1)
>>         LogFailure
>>         FailureQuery insert into RADAUTHLOG (TIME_STAMP, USERNAME, 
>> TYPE,
>> REASON) values (%t, '%n', 0, %1)
>>     </AuthLog>
>>
>> </Realm>
>>
>> <SessionDatabase SQL>
>>         Identifier      SQLSESSIONDB
>>
>>         DBSource        dbi:mysql:radmin:localhost
>>         DBUsername      radmin
>>         DBAuth          test
>>         Description     SQL Session Database
>>
>>         AddQuery insert into RADONLINE (USERNAME, NASIDENTIFIER, 
>> NASPORT, ACCTSESSIONID, TIME_STAMP, \
>>         FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE) values ('%u', '% 
>> 1', %2, %3, %{Timestamp}, \
>>         '%{Calling-Station-Id}', '%{NAS-Port-Type}', '%{Service-
>> Type}')
>>
>>         DeleteQuery delete from RADONLINE where ACCTSESSIONID = %3
>>
>>         ClearNasQuery delete from RADONLINE where NASIDENTIFIER = 
>> '%0'
>>
>>         CountQuery select NASIDENTIFIER, NASPORT, ACCTSESSIONID, 
>> FRAMEDIPADDRESS from RADONLINE where username = '%u'
>> </SessionDatabase>
>>
>> [/End Configuration File]
>>
>> -----Original Message-----
>> From: owner-radiator at open.com.au [mailto:owner- radiator at open.com.au] 
>> On Behalf Of Frank Danielson
>> Sent: Wednesday, May 18, 2005 11:28 PM
>> To: ktlim at uberfusion.com; radiator at open.com.au
>> Subject: RE: (RADIATOR) Double Accounting Stops - How to ignore one?
>>
>> If you look at the Identifier in the two Stop requests the first one 
>> ahs an Identifier of 2 and the second has an Identifier of 3. What 
>> this means is that they are not retransmissions of a duplicate packet 
>> but two seperate accounting requests for the same session. This is a 
>> bug in your NAS.
>>
>> The quickest way around this that I can think of is to make a unique 
>> key of the ACCTSESSIONID in the RADUSAGE table so that a Stop record 
>> can only be recorded once for any given session. Then reverse the 
>> order of your AuthBy SQL statements so that the RADUSAGE query fires 
>> first and if it fails the RADUSERS query will not be executed. If you 
>> post your config file I'm sure someone on the list can give more 
>> specific reccomentations.
>>
>> Frank Danielson
>> Infrastructure Architect
>>
>> ClearSky Mobile Media
>> 56 E. Pine St.
>> Orlando, FL 32801
>> USA
>>
>> fdanielson at csky.com
>>
>> -----Original Message-----
>> From: Kheng Teong, Lim [mailto:ktlim at uberfusion.com]
>> Sent: Wednesday, May 18, 2005 10:33 AM
>> To: radiator at open.com.au
>> Subject: (RADIATOR) Double Accounting Stops - How to ignore one?
>>
>>
>> Somehow or rather, once in a while, we get two (double) Accounting 
>> Stops from some NASes.
>> It doesn't happen often, but when it does, it will cause problems as 
>> we're running a prepaid system that deducts time and bandwidth from 
>> the user's time/bandwidth bank.
>> Once this happens, a user's actual prepaid time/bandwidth will be 
>> double deducted.
>>
>> Is there a way to get Radiator to ignore one of the Accounting Stops?
>> If yes, how do we go about configuring Radiator to only utilize one 
>> Accounting Stop instead of both when it happens?
>>
>> Thanks in advance!
>>
>> [Extract from logfile]
>> Tue May 17 15:34:52 2005: DEBUG: Adding Clients from SQL database Tue 
>> May 17
>> 15:34:52 2005: DEBUG: Query is: 'select  NASIDENTIFIER,  SECRET, 
>> IGNOREACCTSIGNATURE,  DUPINTERVAL,  DEFAULTREALM,  NASTYPE, 
>> SNMPCOMMUNITY, LIVINGSTONOFFS,  LIVINGSTONHOLE,  
>> FRAMEDGROUPBASEADDRESS, FRAMEDGROUPMAXPORTSPERCLASSC,  
>> REWRITEUSERNAME,  NOIGNOREDUPLICATES, PREHANDLERHOOK from 
>> RADCLIENTLIST':
>>
>> Tue May 17 15:34:52 2005: DEBUG: Finished reading configuration file 
>> '/etc/radiator/radius.cfg'
>> Tue May 17 15:34:52 2005: DEBUG: Reading dictionary file 
>> '/etc/radiator/dictionary'
>> Tue May 17 15:34:52 2005: DEBUG: Creating authentication port
>> 0.0.0.0:1645
>> Tue May 17 15:34:52 2005: DEBUG: Creating accounting port
>> 0.0.0.0:1646 Tue
>> May 17 15:34:52 2005: NOTICE: Server started: Radiator 3.8 on AAAtlas 
>> Tue May 17 15:35:02 2005: DEBUG: Packet dump:
>>
>> Tue May 17 16:07:29 2005: DEBUG: Packet dump:
>> *** Received from 192.168.51.27 port 1025 ....
>> Code:       Access-Request
>> Identifier: 0
>> Authentic:
>> <142><159><176>O<127><172>M<245>B<221><31>s4<204><250><166>
>> Attributes:
>>  User-Name = "deleted"
>>  CHAP-Challenge =
>> 9<220>+<16><142>*<242><232><194>\<141><15><221><199><12><188>
>>  CHAP-Password =
>> <208><160><247><21><31><175>Nw<182><189><218><9><215><150><26>;=
>>  Calling-Station-Id = "172.16.1.14"
>>  Service-Type = Authenticate-Only
>>  NAS-Identifier = "My Unique Server Name"
>>  NAS-Port = 0
>>
>> Tue May 17 16:07:29 2005: DEBUG: Handling request with Handler 
>> 'Realm=DEFAULT'
>> Tue May 17 16:07:29 2005: DEBUG: SQLSESSIONDB Deleting session for 
>> deleted, 192.168.51.27, 0 Tue May 17 16:07:29 2005: DEBUG: do query
>> is:
>> 'delete from
>> RADONLINE where ACCTSESSIONID = NULL':
>>
>> Tue May 17 16:07:29 2005: DEBUG: Handling with Radius::AuthSQL Tue 
>> May
>> 17
>> 16:07:29 2005: DEBUG: Handling with Radius::AuthSQL: SUBSCRIBERS Tue 
>> May 17
>> 16:07:29 2005: DEBUG: Query is: 'select PASS_WORD, STATICADDRESS, 
>> TIMELEFT, MAXLOGINS, SERVICENAME, BADLOGINS, VALIDFROM, VALIDTO, 
>> VNC_PPPOE_CBQ_RX, VNC_PPPOE_CBQ_TX, VNC_PPPOE_CBQ_RX_FALLBACK, 
>> VNC_PPPOE_CBQ_TX_FALLBACK, SPLASH from RADUSERS where 
>> USERNAME='deleted' and TIMELEFT > 0 and VALIDFROM < 1116317249 and 
>> VALIDTO > 1116317249 and ACCOUNTSTATUS > 0 and TOTALOCTETSLEFT > 0':
>>
>> Tue May 17 16:07:29 2005: DEBUG: Radius::AuthSQL looks for match with 
>> deleted Tue May 17 16:07:29 2005: DEBUG: Query is: 'select 
>> NASIDENTIFIER, NASPORT, ACCTSESSIONID, FRAMEDIPADDRESS from RADONLINE 
>> where username =
>> 'deleted'':
>>
>> Tue May 17 16:07:29 2005: DEBUG: Radius::AuthSQL ACCEPT:
>> Tue May 17 16:07:29 2005: DEBUG: Access accepted for deleted Tue May
>> 17
>> 16:07:29 2005: DEBUG: do query is: 'insert into RADAUTHLOG 
>> (TIME_STAMP, USERNAME, TYPE) values (1116317249, 'deleted', 1)':
>>
>> Tue May 17 16:07:29 2005: DEBUG: Packet dump:
>> *** Sending to 192.168.51.27 port 1025 ....
>> Code:       Access-Accept
>> Identifier: 0
>> Authentic:
>> <142><159><176>O<127><172>M<245>B<221><31>s4<204><250><166>
>> Attributes:
>>  Session-Timeout = 2409993
>>  VNC-PPPoE-CBQ-RX = 512000
>>  VNC-PPPoE-CBQ-TX = 256000
>>  VNC-PPPoE-CBQ-RX-Fallback = 0
>>  VNC-PPPoE-CBQ-TX-Fallback = 0
>>  splash = 1
>>
>> Tue May 17 16:07:30 2005: DEBUG: Packet dump:
>> *** Received from 192.168.51.27 port 1025 ....
>> Code:       Accounting-Request
>> Identifier: 1
>> Authentic:  <128>"<130>Q+<188><24>Q<169>xB<154><143><146>8<228>
>> Attributes:
>>  Acct-Session-Id = "4528485e550"
>>  User-Name = "deleted"
>>  Calling-Station-Id = "172.16.1.14"
>>  Acct-Status-Type = Start
>>  Service-Type = Framed-User
>>  Framed-Protocol = PPP
>>  Acct-Authentic = RADIUS
>>  NAS-Port-Type = Async
>>  NAS-Identifier = "My Unique Server Name"
>>  NAS-Port = 0
>>  Acct-Delay-Time = 0
>>
>> Tue May 17 16:07:30 2005: DEBUG: Handling request with Handler 
>> 'Realm=DEFAULT'
>> Tue May 17 16:07:30 2005: DEBUG: SQLSESSIONDB Adding session for 
>> deleted, 192.168.51.27, 0 Tue May 17 16:07:30 2005: DEBUG: do query
>> is:
>> 'delete from
>> RADONLINE where ACCTSESSIONID = '4528485e550'':
>>
>> Tue May 17 16:07:30 2005: DEBUG: do query is: 'insert into RADONLINE 
>> (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, 
>> FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE) values ('deleted', 
>> '192.168.51.27', 0, '4528485e550', 1116317250, '172.16.1.14', 
>> 'Async',
>> 'Framed-User')':
>>
>> Tue May 17 16:07:30 2005: DEBUG: Handling with Radius::AuthSQL Tue 
>> May
>> 17 16:07:30 2005: DEBUG: Handling accounting with Radius::AuthSQL Tue 
>> May 17 16:07:30 2005: DEBUG: Accounting accepted Tue May 17 16:07:30
>> 2005:
>> DEBUG:
>> Packet dump:
>> *** Sending to 192.168.51.27 port 1025 ....
>> Code:       Accounting-Response
>> Identifier: 1
>> Authentic:  <128>"<130>Q+<188><24>Q<169>xB<154><143><146>8<228>
>> Attributes:
>>
>> Tue May 17 16:07:35 2005: DEBUG: Packet dump:
>> *** Received from 192.168.51.27 port 1025 ....
>> Code:       Accounting-Request
>> Identifier: 2
>> Authentic:  <172>j<252><18><242>b:<251><168><181>-<188>a<139>i<25>
>> Attributes:
>>  Acct-Session-Id = "4528485e550"
>>  User-Name = "deleted"
>>  Calling-Station-Id = "172.16.1.14"
>>  Acct-Status-Type = Stop
>>  Service-Type = Framed-User
>>  Framed-Protocol = PPP
>>  Acct-Authentic = RADIUS
>>  Acct-Session-Time = 5
>>  Acct-Output-Octets = 30892
>>  Acct-Input-Octets = 2913
>>  Acct-Output-Packets = 58
>>  Acct-Input-Packets = 28
>>  NAS-Port-Type = Async
>>  NAS-Identifier = "My Unique Server Name"
>>  NAS-Port = 0
>>  Acct-Delay-Time = 0
>>
>> Tue May 17 16:07:35 2005: DEBUG: Handling request with Handler 
>> 'Realm=DEFAULT'
>> Tue May 17 16:07:35 2005: DEBUG: SQLSESSIONDB Deleting session for 
>> deleted, 192.168.51.27, 0 Tue May 17 16:07:35 2005: DEBUG: do query
>> is:
>> 'delete from
>> RADONLINE where ACCTSESSIONID = '4528485e550'':
>>
>> Tue May 17 16:07:35 2005: DEBUG: Handling with Radius::AuthSQL Tue 
>> May
>> 17
>> 16:07:35 2005: DEBUG: Handling accounting with Radius::AuthSQL Tue 
>> May
>> 17
>> 16:07:35 2005: DEBUG: do query is: 'update RADUSERS set 
>> TIMELEFT=TIMELEFT-05, OCTETSINLEFT=OCTETSINLEFT-02913, 
>> OCTETSOUTLEFT=OCTETSOUTLEFT-030892,
>> TOTALOCTETSLEFT=TOTALOCTETSLEFT-02913,
>> TOTALOCTETSLEFT=TOTALOCTETSLEFT-030892 where USERNAME='deleted'':
>>
>> Tue May 17 16:07:35 2005: DEBUG: do query is: 'insert into RADUSAGE 
>> (ACCTDELAYTIME,ACCTINPUTOCTETS,ACCTOUTPUTOCTETS,ACCTSESSIONID,ACCTSES
>> S
>> IONTIM
>> E,ACCTSTATUSTYPE,FRAMEDIPADDRESS,NASIDENTIFIER,NASPORT,TIME_STAMP,USE
>> R
>> NAME)
>> values (0,2913,30892,'4528485e550',5,2,'172.16.1.14','My Unique 
>> Server
>> Name',0,1116317255-05,'deleted')':
>>
>> Tue May 17 16:07:35 2005: DEBUG: Accounting accepted Tue May 17
>> 16:07:35
>> 2005: DEBUG: Packet dump:
>> *** Sending to 192.168.51.27 port 1025 ....
>> Code:       Accounting-Response
>> Identifier: 2
>> Authentic:  <172>j<252><18><242>b:<251><168><181>-<188>a<139>i<25>
>> Attributes:
>>
>> Tue May 17 16:07:35 2005: DEBUG: Packet dump:
>> *** Received from 192.168.51.27 port 1025 ....
>> Code:       Accounting-Request
>> Identifier: 3
>> Authentic:
>> <255><162><129><215><190><24><136>$<13>0<23><144><145><217><226><244>
>> Attributes:
>>  Acct-Session-Id = "4528485e550"
>>  User-Name = "deleted"
>>  Calling-Station-Id = "172.16.1.14"
>>  Acct-Status-Type = Stop
>>  Service-Type = Framed-User
>>  Framed-Protocol = PPP
>>  Acct-Authentic = RADIUS
>>  Acct-Session-Time = 5
>>  Acct-Output-Octets = 30892
>>  Acct-Input-Octets = 2913
>>  Acct-Output-Packets = 58
>>  Acct-Input-Packets = 28
>>  NAS-Port-Type = Async
>>  NAS-Identifier = "My Unique Server Name"
>>  NAS-Port = 0
>>  Acct-Delay-Time = 0
>>
>> Tue May 17 16:07:35 2005: DEBUG: Handling request with Handler 
>> 'Realm=DEFAULT'
>> Tue May 17 16:07:35 2005: DEBUG: SQLSESSIONDB Deleting session for 
>> deleted, 192.168.51.27, 0 Tue May 17 16:07:35 2005: DEBUG: do query
>> is:
>> 'delete from
>> RADONLINE where ACCTSESSIONID = '4528485e550'':
>>
>> Tue May 17 16:07:35 2005: DEBUG: Handling with Radius::AuthSQL Tue 
>> May
>> 17
>> 16:07:35 2005: DEBUG: Handling accounting with Radius::AuthSQL Tue 
>> May
>> 17
>> 16:07:35 2005: DEBUG: do query is: 'update RADUSERS set 
>> TIMELEFT=TIMELEFT-05, OCTETSINLEFT=OCTETSINLEFT-02913, 
>> OCTETSOUTLEFT=OCTETSOUTLEFT-030892,
>> TOTALOCTETSLEFT=TOTALOCTETSLEFT-02913,
>> TOTALOCTETSLEFT=TOTALOCTETSLEFT-030892 where USERNAME='deleted'':
>>
>> Tue May 17 16:07:35 2005: DEBUG: do query is: 'insert into RADUSAGE 
>> (ACCTDELAYTIME,ACCTINPUTOCTETS,ACCTOUTPUTOCTETS,ACCTSESSIONID,ACCTSES
>> S
>> IONTIM
>> E,ACCTSTATUSTYPE,FRAMEDIPADDRESS,NASIDENTIFIER,NASPORT,TIME_STAMP,USE
>> R
>> NAME)
>> values (0,2913,30892,'4528485e550',5,2,'172.16.1.14','My Unique 
>> Server
>> Name',0,1116317255-05,'deleted')':
>>
>> Tue May 17 16:07:35 2005: DEBUG: Accounting accepted Tue May 17
>> 16:07:35
>> 2005: DEBUG: Packet dump:
>> *** Sending to 192.168.51.27 port 1025 ....
>> Code:       Accounting-Response
>> Identifier: 3
>> Authentic:
>> <255><162><129><215><190><24><136>$<13>0<23><144><145><217><226><244>
>> Attributes:
>>
>> Thanks
>>
>>  --
>> Warm Regards,
>> Kheng Teong, Lim
>>
>> Chief Technology Officer
>> Red Tree Ventures Sdn. Bhd.
>> -----------------------------------------------------------
>> Red Tree Ventures Sdn. Bhd.
>> No. 119, (3rd Floor) Jalan SS6/12,
>> Kelana Jaya Urban Centre,
>> 47301 Petaling Jaya,
>> Selangor Darul Ehsan, MALAYSIA.
>> Tel: 03-7880 6580 / Fax: 03-7880 6590 http://www.redtreeunwired.com
>> ------------------------------------------------------------
>>
>> --
>> 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.
>>
>>
>> ---
>> [This E-mail has been scanned for viruses]
>>
>> --
>> 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.
>>
>>
>
>
> NB:
>
> Have you read the reference manual ("doc/ref.html")?
> Have you searched the mailing list archive (www.open.com.au/archives/
> radiator)?
> Have you had a quick look on Google (www.google.com)?
> Have you included a copy of your configuration file (no secrets),  
> together
> with a trace 4 debug showing what is happening?
>
> --
> Radiator: the most portable, flexible and configurable RADIUS server
> anywhere. Available on *NIX, *BSD, Windows, MacOS X.
> -
> Nets: internetwork inventory and management - graphical, extensible,
> flexible with hardware, software, platform and database independence.
> -
> CATool: Private Certificate Authority for Unix and Unix-like systems.
>
>
> ---
> [This E-mail has been scanned for viruses]
>
>
>
> ---
> [This E-mail has been scanned for viruses]
>
> --
> 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.
>


NB:

Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive (www.open.com.au/archives/ 
radiator)?
Have you had a quick look on Google (www.google.com)?
Have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.


---
[This E-mail has been scanned for viruses]



---
[This E-mail has been scanned for viruses]

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

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


More information about the radiator mailing list