Hugh,
re: server crash see config and log files attached.
Rohan
On Sat, 3 Nov 2012 09:06:44 +1100
Hugh Irvine <[email protected]> wrote:
>
>Hello Rohan -
>
>The easiest way to do this is to store only the Stop records, and calculate
>the start time from the attributes present in the accounting stop request.
>
>Something like this (the value is in epoch seconds):
>
> Timestamp - Acct-Session-Time - Acct-Delay-Time
>
>For the crash I will need to see the logfile that immediately precedes it
>together with the configuration file you are using.
>
>regards
>
>Hugh
>
>
>On 3 Nov 2012, at 02:24, <[email protected]> wrote:
>
>> Hugh,
>>
>> Now that records are being written to the database, I want a single record
>> per session that includes both Stop and Start times like below.
>>
>> User_Name, NAS_IP_Address, NAS_Port, Framed_IP_Address, Acct_Start_Time,
>> Acct_Stop_Time, Acct_Session_ID
>> jwilliams12 208.138.43.123 805306450 72.27.33.224 Nov 2, 2012 12:21:04 AM
>> Nov 2, 2012 1:21:16 AM, erx TenGigabitEthernet 3/0/0.37:123-82:1830880926
>>
>> So the record is added to the accounting database at the end of a session
>> and includes both Stop and Start times.
>>
>> Added to that is the issue I have where Radiator crashes when I try to use
>> the Simultaneous-Use features.
>>
>> Thanks.
>>
>> On Fri, 2 Nov 2012 17:46:58 +1100
>> Hugh Irvine <[email protected]> wrote:
>>>
>>> Hello Rohan -
>>>
>>> Can you please explain exactly what you are trying to do?
>>>
>>> It is normal for you to get two records in your accounting table, as that
>>> is what you have configured.
>>>
>>> If you can tell us what you are trying to achieve we will be able to make
>>> sensible suggestions.
>>>
>>> regards
>>>
>>> Hugh
>>>
>>>
>>> On 2 Nov 2012, at 09:38, <[email protected]> wrote:
>>>
>>>> Thanks Michael,
>>>>
>>>>
>>>>
>>>> I was able to go further with the advice using the AuthByPolicy and AuthBy
>>>> GROUP under the existing Handler. Only that two records are added to my
>>>> accounting database for a single session - one at Start and one at Stop.
>>>>
>>>> <Handler NAS-Identifier="Juniper_E320_2">
>>>> AddToRequest SERVICESTATUS = ACTIVE
>>>> SessionDatabase SQLSDB
>>>> # MaxSessions 1
>>>> RejectHasReason
>>>>
>>>> AuthByPolicy ContinueAlways
>>>> AuthBy SQLAccounting
>>>> <AuthBy GROUP>
>>>> AuthByPolicy ContinueWhileIgnore
>>>> AuthBy xDSL
>>>> </AuthBy>
>>>>
>>>>
>>>> Regards,
>>>>
>>>> Rohan
>>>>
>>>>
>>>>
>>>> On Thu, 01 Nov 2012 17:45:18 -0400
>>>>
>>>> Michael wrote:
>>>>
>>>>> Looks like your "AuthBy xDSL" is accepting, therefore since the default
>>>>> AuthByPolicy is ContinueWhileIgnore, it will stop at the xDSL authby and
>>>>> the "AuthBy SQLAccounting" is not processed.
>>>>
>>>>>
>>>>
>>>>> I personally handle accounting in a separate handler. To me, handling
>>>>> accounting and authorization in the same handler is tricky.
>>>>
>>>>>
>>>>
>>>>>
>>>>
>>>>>
>>>>
>>>>> Michael
>>>>
>>>>>
>>>>
>>>>>
>>>>
>>>>>
>>>>
>>>>>
>>>>
>>>>> On 01/11/12 05:07 PM, [email protected] wrote:
>>>>
>>>>>> Hugh,
>>>>
>>>>>>
>>>>
>>>>>> Config and logs attached.
>>>>
>>>>>>
>>>>
>>>>>>
>>>>
>>>>>> And the application crashed when testing Simultaneous-Use for both
>>>>>> configurations below.
>>>>
>>>>>>
>>>>
>>>>>> In my AuthBy config:
>>>>
>>>>>> "DefaultSimultaneousUse 1" With "AuthAttrDef
>>>>>> Simultaneous-Use,Simultaneous-Use,check"
>>>>
>>>>>>
>>>>
>>>>>> Or
>>>>
>>>>>>
>>>>
>>>>>> In my Handler:
>>>>
>>>>>> MaxSessions 1
>>>>
>>>>>>
>>>>
>>>>>>
>>>>
>>>>>>
>>>>
>>>>>> On Fri, 2 Nov 2012 07:19:09 +1100
>>>>
>>>>>> Hugh Irvine wrote:
>>>>
>>>>>>> Hello Rohan -
>>>>
>>>>>>>
>>>>
>>>>>>> We will need to see the configuration file (no secrets) together with a
>>>>>>> trace 4 debug showing what is happening.
>>>>
>>>>>>>
>>>>
>>>>>>> regards
>>>>
>>>>>>>
>>>>
>>>>>>> Hugh
>>>>
>>>>>>>
>>>>
>>>>>>>
>>>>
>>>>>>> On 2 Nov 2012, at 05:53, wrote:
>>>>
>>>>>>>
>>>>
>>>>>>>> Hello,
>>>>
>>>>>>>>
>>>>
>>>>>>>> Why doesn't the following work?
>>>>
>>>>>>>>
>>>>
>>>>>>>>
>>>>
>>>>>>>> Identifier SQLAccounting
>>>>
>>>>>>>> DBSource dbi:mysql:inetdb_test
>>>>
>>>>>>>> DBUsername inet
>>>>
>>>>>>>> DBAuth inet@inetdb
>>>>
>>>>>>>> #Disable SQL authentication
>>>>
>>>>>>>> AuthSelect
>>>>
>>>>>>>> HandleAcctStatusTypes Start,Stop
>>>>
>>>>>>>> AccountingTable ARCH_ACCOUNTING
>>>>
>>>>>>>> AcctColumnDef USER_NAME,User-Name
>>>>
>>>>>>>> AcctColumnDef ACCT_START_TIME,Timestamp,integer
>>>>
>>>>>>>> AcctColumnDef ACCT_STOP_TIME,Timestamp,integer
>>>>
>>>>>>>> AcctColumnDef ACCT_STATUS_TYPE,Acct-Status-Type,integer
>>>>
>>>>>>>> AcctColumnDef ACCT_DELAY_TIME,Acct-Delay-Time,integer
>>>>
>>>>>>>> AcctColumnDef ACCT_INPUT_OCTETS,Acct-Input-Octets,integer
>>>>
>>>>>>>> AcctColumnDef ACCT_OUTPUT_OCTETS,Acct-Output-Octets,integer
>>>>
>>>>>>>> AcctColumnDef ACCT_SESSION_ID,Acct-Session-Id
>>>>
>>>>>>>> AcctColumnDef ACCT_SESSION_TIME,Acct-Session-Time,integer
>>>>
>>>>>>>> AcctColumnDef ACCT_TERMINATE_CAUSE,Acct-Terminate-Cause,integer
>>>>
>>>>>>>> AcctColumnDef FRAMED_IP_ADDRESS,Framed-IP-Address
>>>>
>>>>>>>> AcctColumnDef NAS_IDENTIFIER,NAS-Identifier
>>>>
>>>>>>>> AcctColumnDef NAS_PORT,NAS-Port,integer
>>>>
>>>>>>>> AcctColumnDef CALLED_STATION_ID,Called-Station-Id
>>>>
>>>>>>>> AcctColumnDef CALLING_STATION_ID,Calling-Station-Id
>>>>
>>>>>>>> SQLRecoveryFile %L/sqlaccounting.sql
>>>>
>>>>>>>>
>>>>
>>>>>>>>
>>>>
>>>>>>>> Specifying the following in my Handler does not work. I don't even see
>>>>>>>> any trace in my logs set at level 4 or 5.
>>>>
>>>>>>>> AuthBy SQLAccounting
>>>>
>>>>>>>>
>>>>
>>>>>>>> However my sessions database work with the following.
>>>>
>>>>>>>> SessionDatabase SQLSDB
>>>>
>>>>>>>>
>>>>
>>>>>>>> Thanks much.
>>>>
>>>>>>>>
>>>>
>>>>>>>> Regards,
>>>>
>>>>>>>> Rohan
>>>>
>>>>>>>> _______________________________________________
>>>>
>>>>>>>> radiator mailing list
>>>>
>>>>>>>> [email protected]
>>>>
>>>>>>>> http://www.open.com.au/mailman/listinfo/radiator
>>>>
>>>>>>>
>>>>
>>>>>>> --
>>>>
>>>>>>>
>>>>
>>>>>>> Hugh Irvine
>>>>
>>>>>>> [email protected]
>>>>
>>>>>>>
>>>>
>>>>>>> Radiator: the most portable, flexible and configurable RADIUS server
>>>>
>>>>>>> anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
>>>>
>>>>>>> Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS,
>>>>
>>>>>>> TTLS, PEAP, TNC, WiMAX, RSA, Vasco, Yubikey, MOTP, HOTP, TOTP,
>>>>
>>>>>>> DIAMETER etc.
>>>>
>>>>>>> Full source on Unix, Windows, MacOSX, Solaris, VMS, NetWare etc.
>>>>
>>>>>>>
>>>>
>>>>>> Rohan Henry
>>>>
>>>>>> Server Administrator
>>>>
>>>>>> LIME
>>>>
>>>>>> Phone (876) 936-4819
>>>>
>>>>>> Mobile (876) 997-0729
>>>>
>>>>>>
>>>>
>>>>>>
>>>>
>>>>>> _______________________________________________
>>>>
>>>>>> radiator mailing list
>>>>
>>>>>> [email protected]
>>>>
>>>>>> http://www.open.com.au/mailman/listinfo/radiator
>>>>
>>>>
>>>>
>>>> Rohan Henry
>>>>
>>>> Server Administrator
>>>>
>>>> LIME
>>>>
>>>> Phone (876) 936-4819
>>>>
>>>> Mobile (876) 997-0729
>>>>
>>>> _______________________________________________
>>>> radiator mailing list
>>>> [email protected]
>>>> http://www.open.com.au/mailman/listinfo/radiator
>>>
>>>
>>> --
>>>
>>> Hugh Irvine
>>> [email protected]
>>>
>>> Radiator: the most portable, flexible and configurable RADIUS server
>>> anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
>>> Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS,
>>> TTLS, PEAP, TNC, WiMAX, RSA, Vasco, Yubikey, MOTP, HOTP, TOTP,
>>> DIAMETER etc.
>>> Full source on Unix, Windows, MacOSX, Solaris, VMS, NetWare etc.
>>>
>>
>> Rohan Henry
>> Server Administrator
>> LIME
>> Phone (876) 936-4819
>> Mobile (876) 997-0729
>> _______________________________________________
>> radiator mailing list
>> [email protected]
>> http://www.open.com.au/mailman/listinfo/radiator
>
>
>--
>
>Hugh Irvine
>[email protected]
>
>Radiator: the most portable, flexible and configurable RADIUS server
>anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
>Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS,
>TTLS, PEAP, TNC, WiMAX, RSA, Vasco, Yubikey, MOTP, HOTP, TOTP,
>DIAMETER etc.
>Full source on Unix, Windows, MacOSX, Solaris, VMS, NetWare etc.
>
Rohan Henry
Server Administrator
LIME
Phone (876) 936-4819
Mobile (876) 997-0729
# radius.cfg
#
# Example Radiator configuration file.
# This very simple file will allow you to get started with
# a simple system. You can then add and change features.
# We suggest you start simple, prove to yourself that it
# works and then develop a more complicated configuration as required.
#
# This example will authenticate from a standard users file in
# DbDir/users and log accounting to LogDir/detail.
#
# It will accept requests from any client and try to handle request
# for any realm.
#
# You should consider this file to be a starting point only
# $Id: linux-radius.cfg,v 1.3 2002/03/24 23:07:49 mikem Exp $
#Foreground
#LogStdout
LogDir /var/log/radius
DbDir /etc/radiator
# Use a low trace level in production systems. Increase
# it to 4 or 5 for debugging, or use the -trace flag to radiusd
Trace 5
AuthPort 1645,1812
AcctPort 1646,1813
# You will probably want to add other Clients to suit your site,
# one for each NAS you want to work with
#<Client DEFAULT>
# Secret ******
# DupInterval 0
#</Client>
<Client localhost>
Secret ******
DupInterval 0
</Client>
<Client *.*.*.*>
Secret *****
DupInterval 0
</Client>
<Client *.*.*.*>
Secret ******
DupInterval 0
</Client>
#<Realm DEFAULT>
# <AuthBy FILE>
# Filename %D/users
# </AuthBy>
# # Log accounting to a detail file
# AcctLogFileName %L/detail
#</Realm>
<AuthLog FILE>
Identifier myauthlogger
Filename %L/authlog
LogSuccess 3
LogFailure 3
</AuthLog>
#<AuthBy INTERNAL>
# Identifier InvalidUsers
# AuthResult ACCEPT
# AcctResult ACCEPT
#</AuthBy>
#Authenticates broadband users
<AuthBy LDAP2>
Identifier xDSL
Host ******
AuthDN cn=directory manager
AuthPassword ******
BaseDN %0=%1,ou=IPCustomers,o=domain.com
Scope onelevel
UsernameAttr uid
PasswordAttr userPassword
SearchFilter (|(packagename=Wireless*)(packagename=ADSL*))
# DefaultSimultaneousUse 1
AuthAttrDef servicestatus,SERVICESTATUS,check
# AuthAttrDef packagename,PACKAGENAME,request
# AuthAttrDef ipaddress,ipaddress,reply
AuthAttrDef Simultaneous-Use,Simultaneous-Use,check
# AuthAttrDef NAS-Port-Type,NAS-Port-Type,check
# AuthAttrDef Calling-Station-Id,Calling-Station-Id,check
# AuthAttrDef Called-Station-Id,Called-Station-Id,check
# AuthAttrDef NAS-IP-Address,NAS-IP-Address,check
# AuthAttrDef Framed-Address,Framed-Address,reply
# AuthAttrDef Session-Timeout,Session-Timeout,reply
# AuthAttrDef Port-Limit,Port-Limit,reply
# AuthAttrDef Framed-Pool,Framed-Pool,reply
# AuthAttrDef Framed-Route,Framed-Route,reply
Debug 255
#ServerChecksPassword
NoDefault
AddToReply Class = %{User-Name}
</AuthBy>
#Authenticates DIALUP users
<AuthBy LDAP2>
Identifier DIALUP
Host olympias1 socrates
AuthDN cn=directory manager
AuthPassword *******
BaseDN %0=%1,ou=IPCustomers,o=domain.com
# SearchFilter (%0=%1)
Scope onelevel
UsernameAttr uid
PasswordAttr userPassword
SearchFilter (packagename=Voyageur*)
AuthAttrDef servicestatus,SERVICESTATUS,check
# AuthAttrDef packagename,PACKAGENAME,request
# AuthAttrDef ipaddress,ipaddress,reply
# AuthAttrDef Simultaneous-Use,Simultaneous-Use,check
# AuthAttrDef NAS-Port-Type,NAS-Port-Type,check
# AuthAttrDef Calling-Station-Id,Calling-Station-Id,check
# AuthAttrDef Called-Station-Id,Called-Station-Id,check
# AuthAttrDef NAS-IP-Address,NAS-IP-Address,check
# AuthAttrDef Framed-Address,Framed-Address,reply
# AuthAttrDef Session-Timeout,Session-Timeout,reply
# AuthAttrDef Port-Limit,Port-Limit,reply
# AuthAttrDef Framed-Pool,Framed-Pool,reply
# AuthAttrDef Framed-Route,Framed-Route,reply
Debug 255
#ServerChecksPassword
NoDefault
# AddToReply Class = %{User-Name}
</AuthBy>
<SessionDatabase SQL>
Identifier SQLSDB
DBSource dbi:mysql:inetdb_test
DBUsername ******
DBAuth ******
AddQuery insert into ACTIVE_SESSIONS \
(USER_NAME,NAS_IP_ADDRESS,NAS_PORT,NAS_PORT_ID,ACCT_SESSION_ID,ACCT_START_TIME,FRAMED_IP_ADDRESS,
\
NAS_PORT_TYPE,SERVICE_TYPE) \
values \
('%U','%{NAS-IP-Address}','%{NAS-Port}','%{NAS-Port-Id}','%{Acct-Session-Id}','%A',
\
'%{Framed-IP-Address}','%{NAS-Port-Type}','%{Service-Type}')
DeleteQuery delete from ACTIVE_SESSIONS where USER_NAME='%U' and
NAS_IP_ADDRESS='%{NAS-IP-Address}' and NAS_PORT_ID='%{NAS-Port-Id}'
CountQuery select
NAS_IP_ADDRESS='%{NAS-IP-Address}',NAS_PORT_ID='%{NAS-Port-Id}',ACCT_SESSION_ID='%{Acct-Session-Id}'
from ACTIVE_SESSIONS where USER_NAME='%U'
</SessionDatabase>
<AuthBy SQL>
Identifier SQLAccounting
DBSource dbi:mysql:inetdb_test
DBUsername ******
DBAuth ******
#Disable SQL authentication
#AuthSelect
HandleAcctStatusTypes Start,Stop
AccountingTable ARCH_ACCOUNTING
AcctColumnDef USER_NAME,User-Name
AcctColumnDef ACCT_START_TIME,Timestamp,integer
AcctColumnDef ACCT_STOP_TIME,Timestamp,integer
AcctColumnDef ACCT_STATUS_TYPE,Acct-Status-Type,integer
AcctColumnDef ACCT_DELAY_TIME,Acct-Delay-Time,integer
AcctColumnDef ACCT_INPUT_OCTETS,Acct-Input-Octets,integer
AcctColumnDef ACCT_OUTPUT_OCTETS,Acct-Output-Octets,integer
AcctColumnDef ACCT_SESSION_ID,Acct-Session-Id
AcctColumnDef ACCT_SESSION_TIME,Acct-Session-Time,integer
AcctColumnDef ACCT_TERMINATE_CAUSE,Acct-Terminate-Cause,integer
AcctColumnDef FRAMED_IP_ADDRESS,Framed-IP-Address
AcctColumnDef NAS_IDENTIFIER,NAS-Identifier
AcctColumnDef NAS_PORT,NAS-Port,integer
AcctColumnDef CALLED_STATION_ID,Called-Station-Id
AcctColumnDef CALLING_STATION_ID,Calling-Station-Id
SQLRecoveryFile %L/sqlaccounting.sql
</AuthBy>
<AuthBy SQL>
Identifier SQLStop
DBSource dbi:mysql:inetdb_test
DBUsername ******
DBAuth ******
# Disable SQL authentication
AuthSelect
HandleAcctStatusTypes Stop
AccountingTable ARCH_ACCOUNTING
AcctColumnDef USER_NAME,User-Name
# AcctColumnDef ACCT_START_TIME,Timestamp,integer-date
AcctColumnDef ACCT_START_TIME,%b-0%{Acct-Session-Time},literal
AcctColumnDef ACCT_STOP_TIME,Timestamp,integer-date
AcctColumnDef ACCT_STATUS_TYPE,Acct-Status-Type,integer
AcctColumnDef ACCT_DELAY_TIME,Acct-Delay-Time,integer
AcctColumnDef ACCT_INPUT_OCTETS,Acct-Input-Octets,integer
AcctColumnDef ACCT_OUTPUT_OCTETS,Acct-Output-Octets,integer
AcctColumnDef ACCT_SESSION_ID,Acct-Session-Id
AcctColumnDef ACCT_SESSION_TIME,Acct-Session-Time,integer
AcctColumnDef ACCT_TERMINATE_CAUSE,Acct-Terminate-Cause,integer
AcctColumnDef FRAMED_IP_ADDRESS,Framed-IP-Address
AcctColumnDef NASIDENTIFIER,NAS-Identifier
AcctColumnDef NAS_PORT,NAS-Port,integer
AcctColumnDef CALLED_STATION_ID,Called-Station-Id
AcctColumnDef CALLING_STATION_ID,Calling-Station-Id
SQLRecoveryFile %L/sqlaccounting.sql
</AuthBy>
<Handler NAS-Identifier="Juniper_E320_1">
AddToRequest SERVICESTATUS = ACTIVE
# AuthBy DIALUP
AuthBy xDSL
SessionDatabase SQLSDB
# MaxSessions 1
AuthBy SQLAccounting
RejectHasReason
# Log authentication success and failure to the a file
AuthLog myauthlogger
# Log accounting to a detail file
AcctLogFileName %L/detail
# PostSearchHook sub {print "PostSearchHook @_\n";\
# my $attr = $_[3]->get('packagename');\
# print "get attribute $attr\n";}
</Handler>
<Handler NAS-Identifier="Juniper_E320_2">
AddToRequest SERVICESTATUS = ACTIVE
SessionDatabase SQLSDB
MaxSessions 1
RejectHasReason
#AuthByPolicy ContinueAlways
# AuthBy SQLAccounting
# <AuthBy GROUP>
# AuthByPolicy ContinueWhileAccept
# <AuthBy GROUP>
# AuthByPolicy ContinueWhileIgnore
# AuthBy xDSL
# </AuthBy>
# </AuthBy>
AuthByPolicy ContinueAlways
AuthBy SQLStop
AuthBy xDSL
# Log authentication success and failure to the a file
AuthLog myauthlogger
# Log accounting to a detail file
AcctLogFileName %L/detail
# PostSearchHook sub {print "PostSearchHook @_\n";\
# my $attr = $_[3]->get('packagename');\
# print "get attribute $attr\n";}
</Handler>
Mon Nov 5 16:49:28 2012: DEBUG: Packet dump:
*** Received from 208.138.43.125 port 50000 ....
Packet length = 281
01 69 01 19 13 f0 1b 7c 28 97 25 fe 06 3c 4b c1
64 7b 6f c7 02 12 da a7 64 5d 46 7a 48 dc c5 c4
5c cd 47 5b 88 38 01 0f 66 72 69 74 7a 73 61 6d
75 65 6c 73 31 2c 38 65 72 78 20 54 65 6e 47 69
67 61 62 69 74 45 74 68 65 72 6e 65 74 20 33 2f
30 2f 30 2e 39 34 31 30 30 35 3a 39 34 2d 31 30
30 35 3a 31 38 33 31 34 39 31 38 33 35 06 06 00
00 00 02 07 06 00 00 00 01 1a 1f 00 00 13 0a 18
19 70 70 70 6f 65 20 30 30 3a 39 30 3a 64 30 3a
33 30 3a 33 65 3a 37 63 1f 36 23 4a 75 6e 69 70
65 72 5f 45 33 32 30 5f 32 23 4c 69 6e 6b 20 54
6f 20 43 61 72 6c 2d 4d 50 4c 53 5f 50 45 2d 4e
6f 64 65 2d 35 2f 32 2f 32 23 31 30 30 35 3d 06
00 00 00 0f 05 06 30 00 03 ed 57 29 54 65 6e 47
69 67 61 62 69 74 45 74 68 65 72 6e 65 74 20 33
2f 30 2f 30 2e 39 34 31 30 30 35 3a 39 34 2d 31
30 30 35 04 06 d0 8a 2b 7d 20 10 4a 75 6e 69 70
65 72 5f 45 33 32 30 5f 32
Code: Access-Request
Identifier: 105
Authentic: <19><240><27>|(<151>%<254><6><K<193>d{o<199>
Attributes:
User-Password = <218><167>d]FzH<220><197><196>\<205>G[<136>8
User-Name = "fritzsamuels1"
Acct-Session-Id = "erx TenGigabitEthernet
3/0/0.941005:94-1005:1831491835"
Service-Type = Framed-User
Framed-Protocol = PPP
Unisphere-Pppoe-Description = "pppoe 00:90:d0:30:3e:7c"
Calling-Station-Id = "#Juniper_E320_2#Link To
Carl-MPLS_PE-Node-5/2/2#1005"
NAS-Port-Type = Ethernet
NAS-Port = 805307373
NAS-Port-Id = "TenGigabitEthernet 3/0/0.941005:94-1005"
NAS-IP-Address = 208.138.43.125
NAS-Identifier = "Juniper_E320_2"
Mon Nov 5 16:49:28 2012: DEBUG: Handling request with Handler
'NAS-Identifier="Juniper_E320_2"'
Mon Nov 5 16:49:28 2012: DEBUG: SQLSDB Deleting session for fritzsamuels1,
208.138.43.125, 805307373
Mon Nov 5 16:49:28 2012: DEBUG: do query is: 'delete from ACTIVE_SESSIONS
where USER_NAME='fritzsamuels1' and NAS_IP_ADDRESS='208.138.43.125' and
NAS_PORT_ID='TenGigabitEthernet 3/0/0.941005:94-1005'':
Mon Nov 5 16:49:28 2012: DEBUG: Query is: 'select
NAS_IP_ADDRESS='208.138.43.125',NAS_PORT_ID='TenGigabitEthernet
3/0/0.941005:94-1005',ACCT_SESSION_ID='erx TenGigabitEthernet
3/0/0.941005:94-1005:1831491835' from ACTIVE_SESSIONS where
USER_NAME='fritzsamuels1'':
_______________________________________________
radiator mailing list
[email protected]
http://www.open.com.au/mailman/listinfo/radiator
