(RADIATOR) missing acct logs
Hugh Irvine
hugh at open.com.au
Mon Jan 16 16:57:40 CST 2006
Hello Jan -
Thanks for the information.
Radiator normally has a timeout and failure backoff time set using
the Timeout and FailureBackoffTime parameters.
The defaults for these parameters are 60 and 600 seconds respectively.
See section 5.29 in the Radiator 3.14 reference manual ("doc/ref.html").
If these parameters do not work correctly it is because the
underlying libraries do not respect the timeouts and do not fail when
a timeout occurs.
You can try adjusting the values and doing some testing.
However if you are getting the same behaviour from the SQL command
line, then it is definitely a problem in the lower level libraries.
regards
Hugh
On 16 Jan 2006, at 21:50, Jan Stanik wrote:
> 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.
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