(RADIATOR) missing acct logs

[Hugh Irvine]

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.

Could you also send us a copy of the last part of the trace 4 debug  
showing where the processing stopped.

It sounds like a problem with the DBI/DBD-Oracle/Oracle installation  
- possibly an Oracle library problem.

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.