[RADIATOR] Accounting records are not written to database

[Hugh Irvine]

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.