[RADIATOR] Accounting records are not written to database

[rohan.henry at cwjamaica.com]

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