(RADIATOR) missing acct logs
Jan Stanik
bjstanik at in.nextra.sk
Mon Jan 16 04:50:38 CST 2006
Hugh Irvine wrote:
>
> Hello Jan -
>
> Can you please tell us what hardware/software platform you are running
> on, what version of Perl, what version of Radiator, and what versions of
> DBI/DBD-Oracle and Oracle database and client libraries.
>
Hi Hugh,
hw platform is Intel XEON CPU 2.40GHz, 1GB RAM
OS: Gentoo kernel 2.6.11, perl v5.8.6, Radiator 3.13, Oracle db
9.2.4.5, oracle client 10.1.0.3, DBI 1.48, DBD Oracle 1.16.
> Could you also send us a copy of the last part of the trace 4 debug
> showing where the processing stopped.
I'm sorry I haven't had this log longer but there was nothing special
in it. The last record was sql command - insert to database.
>
> It sounds like a problem with the DBI/DBD-Oracle/Oracle installation -
> possibly an Oracle library problem.
I think the problem was that insert command was running long time. The
same situation appeared when I tried to run insert from sql console
(from different server and os platform).
The question is why Radiator did not drop inserting after some timeout.
Regards
Jan
>
> regards
>
> Hugh
>
>
> On 13 Jan 2006, at 21:08, Jan Stanik wrote:
>
>> Hi all,
>>
>> Last night we had strange problem with Radiator. Accounting table in
>> the database was locked and Radiator could not insert accounting logs
>> to it. It hung on the first insert command and was waiting and
>> waiting...
>>
>> What's strange that no other logs where created - no misaccounting
>> logs, no error logs. Radiator didn't get time out.
>> There was no problem to connect to acct port and send new accounting
>> data but nothing was recorded.
>>
>> We lost all accounting logs for one day so I need to understand
>> what's happened to avoid this problem in the future.
>>
>> Thank you for your help.
>>
>> Jan
>>
>> Database backend is Oracle.
>>
>> Bellow is part of acct config file:
>> # Run in the foreground
>> #Foreground
>>
>> # Log to stdout
>> #LogStdout
>>
>> # Do not log to file
>> LogFile
>> #LogFile %L/logfile-acct-debug-%Y%m
>>
>> # Trace Level
>> #
>> # 0 ERR. Error conditions. Serious and unexpected failures
>> # 1 WARNING. Warning conditions. Unexpected failures
>> # 2 NOTICE. Normal but significant conditions.
>> # 3 INFO. Informational messages.
>> # 4 DEBUG. Debugging messages.
>> # 5 Incoming raw packet dumps in hexadecimal.
>> Trace 4
>>
>> # Listen for authentication requests on port 1812 as per RFC 2138
>> AuthPort
>> AcctPort 1646
>>
>> # Don't bind Auth port
>> AuthPort
>>
>> # Put log files in
>> LogDir /opt/radiator/log/dial
>>
>> #DB Directory
>> DbDir /opt/radiator/etc
>>
>> # Dictionary file is in the current directory
>> DictionaryFile /opt/radiator/etc/dictionary
>>
>> # My global parametres
>>
>> DefineGlobalVar OraName1 auth.nx
>> DefineGlobalVar OraUser1 radiator
>> DefineGlobalVar OraPass1 xxxxxxxxxx
>>
>> DefineGlobalVar OraName2 nike.nx
>> DefineGlobalVar OraUser2 accountlog
>> DefineGlobalVar OraPass2 xxxxxxxxxx
>>
>>
>> #--------------------- Marta ADSL
>> <AuthBy SQL>
>> Identifier MartaADSL
>> NoDefault
>> DBSource dbi:Oracle:%{GlobalVar:OraName2}
>> DBUsername %{GlobalVar:OraUser2}
>> DBAuth %{GlobalVar:OraPass2}
>> FailureBackoffTime 180
>>
>> DateFormat to_date('%x %X', 'MM/DD/YY HH24:MI:SS')
>> AccountingTable accountlog.radius_calls_marta_adsl
>>
>> AcctColumnDef USER_NAME,User-Name
>> AcctColumnDef NAS_IDENTIFIER,NAS-IP-Address
>> AcctColumnDef NAS_PORT,NAS-Port
>> # AcctColumnDef NAS_PORT,Cisco-NAS-Port
>> AcctColumnDef ACCT_SESSION_ID,Acct-Session-Id
>> AcctColumnDef NAS_PORT_TYPE,NAS-Port-Type, integer
>> AcctColumnDef ACCT_STATUS_TYPE,Acct-Status-Type,integer
>> AcctColumnDef ACCT_SESSION_TIME,Acct-Session-Time,integer
>> # AcctColumnDef ACCT_AUTHENTIC,Acct-Authentic
>> AcctColumnDef ACCT_INPUT_OCTETS,Acct-Input-Octets, integer
>> AcctColumnDef ACCT_INPUT_GIGAWORDS,Acct-Input-Gigawords,
>> integer
>> AcctColumnDef ACCT_OUTPUT_OCTETS,Acct-Output-Octets, integer
>> AcctColumnDef ACCT_OUTPUT_GIGAWORDS,Acct-Output-Gigawords,
>> integer
>> AcctColumnDef ACCT_TERMINATE_CAUSE,Acct-Terminate-Cause,
>> integer
>> # AcctColumnDef SERVICE_TYPE,Service-Type
>> # AcctColumnDef FRAMED_PROTOCOL,Framed-Protocol
>> AcctColumnDef FRAMED_IP,Framed-IP-Address
>> # AcctColumnDef ACCT_DELAY_TIME,Acct-Delay-Time,integer
>> # AcctColumnDef ACCT_INPUT_PACKETS,Acct-Input-Packets, integer
>> # AcctColumnDef ACCT_OUTPUT_PACKETS,Acct-Output-Packets, integer
>> # AcctColumnDef CALLED_STATION_ID,Called-Station-Id
>> AcctColumnDef CALLING_STATION_ID,Calling-Station-Id
>> AcctColumnDef ETHERNET,Ethernet
>> # AcctColumnDef TIMESTAMP,Timestamp
>> AcctColumnDef CALL_DATE,Timestamp,formatted-date,to_date\
>> ('%e %m %Y %H:%M:%S', 'DD MM YYYY HH24:MI:SS')
>>
>> AcctFailedLogFileName %L/missacct_marta_adsl_%Y%m%d
>> </AuthBy>
>>
>> #--------------------- (prepaid) MARTA ADSL
>> <Handler Class=/^200.+$/>
>> SessionDatabase SDNull
>> AuthByPolicy else
>> AuthBy NewADSL
>> AuthBy WriteToAdslDB
>> AuthBy SessionDB
>> AuthBy MartaADSL
>> AcctLogFileName %L/acct_adsl_marta_%Y%m%d
>> </Handler>
>>
>> --
>> 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.
>
>
--
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