[RADIATOR] Accounting records are not written to database
rohan.henry at cwjamaica.com
rohan.henry at cwjamaica.com
Fri Nov 2 16:38:02 CDT 2012
Hugh,
After some additional advice I realize that how Radiator adds the the records makes perfect sense. Since I have the option of inserting Interim records as well.
So you can ignore.
But I would still would like to know why Simultaneous-Use or Maxsessions does not work and crash the application during my tests.
Regards,
Rohan
On Fri, 02 Nov 2012 10:24:07 -0500
<rohan.henry at cwjamaica.com> 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 <hugh at open.com.au> 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, <rohan.henry at cwjamaica.com> 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, rohan.henry at cwjamaica.com 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 at 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
>>>
>>>>>>> radiator at open.com.au
>>>
>>>>>>> http://www.open.com.au/mailman/listinfo/radiator
>>>
>>>>>>
>>>
>>>>>> --
>>>
>>>>>>
>>>
>>>>>> Hugh Irvine
>>>
>>>>>> hugh at open.com.au
>>>
>>>>>>
>>>
>>>>>> 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
>>>
>>>>> radiator at open.com.au
>>>
>>>>> http://www.open.com.au/mailman/listinfo/radiator
>>>
>>>
>>>
>>> Rohan Henry
>>>
>>> Server Administrator
>>>
>>> LIME
>>>
>>> Phone (876) 936-4819
>>>
>>> Mobile (876) 997-0729
>>>
>>> _______________________________________________
>>> radiator mailing list
>>> radiator at open.com.au
>>> http://www.open.com.au/mailman/listinfo/radiator
>>
>>
>>--
>>
>>Hugh Irvine
>>hugh at open.com.au
>>
>>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
Rohan Henry
Server Administrator
LIME
Phone (876) 936-4819
Mobile (876) 997-0729
More information about the radiator
mailing list