(RADIATOR) backoff timer

[Hugh Irvine]

Hello Carlos -

What you see below is normal, as Radiator continues to process RADIUS  
requests and log the debug messages.

You will see this message which indicates there has been a problem  
accessing the database:

> Dec 4 13:43:25 radius011 radiusd[2608]: Could not connect to any  
> SQL database. Request is ignored. Backing off for 30 seconds

so all accesses to the database for 30 seconds will be ignored...

Radiator will attempt to contact the database again after the expiry  
of the backoff period.

regards

Hugh


On 6 Dec 2007, at 01:28, onrubia carlos wrote:

> Hello,
>
> I have tested the working of the backoff timer parameter in the  
> configuration file when the radonline server is not
> available.
> It works (during X seconds, no requests are sent to the radonline  
> server).
>
> But strange situation, in the detaille log, the access to radonline  
> are still present (see log here below)...so my questions are:
>
> - is this situation normal?
> - how can I make the difference between this "non access" and a  
> real access?
>
> Thanks for your feedback,
>
> Carlos,
>
> Dec 4 13:43:25 radius011 radiusd[2608]: Rewrote user name to
>
> fa051981 at skynet.be
> Dec 4 13:43:25 radius011 radiusd[2608]: Handling request with  
> Handler 'SkyHandler = skynet'
> Dec 4 13:43:25 radius011 radiusd[2608]: Rewrote user name to fa051981
> Dec 4 13:43:25 radius011 radiusd[2608]: SkynetOnline Adding session  
> for fa051981 at skynet.be, 195.238.1.123, 4124255
> Dec 4 13:43:25 radius011 radiusd[2608]: Could not connect to SQL  
> database with DBI->connect dbi:Oracle: RADONL.SKYNET.BE, radius,  
> kerguelen: ORA-01034: ORACLE not available ORA-27101: shared memory  
> realm does not exist Linux Error: 2: No such file or directory (DBD  
> ERROR: OCISessionBegin)
> Dec 4 13:43:25 radius011 radiusd[2608]: Could not connect to SQL  
> database with DBI->connect dbi:Oracle:RADONL2.SKYNET.BE, radius,  
> kerguelen: ORA-01034: ORACLE not available ORA-27101: shared memory  
> realm does not exist Linux Error: 2: No such file or directory (DBD  
> ERROR: OCISessionBegin)
> Dec 4 13:43:25 radius011 radiusd[2608]: Could not connect to any  
> SQL database. Request is ignored. Backing off for 30 seconds
> Dec 4 13:43:25 radius011 radiusd[2608]: do query is: 'DELETE FROM  
> onlineusers WHERE nasidport=' 195.238.1.123 4124255'':
> Dec 4 13:43:25 radius011 radiusd[2608]: do query is: 'INSERT into  
> onlineusers (login, nas_id, session_id, time_stamp, framed_ip,  
> nas_port_type, service_type, called_id, caller_id, nasidport,  
> radsrv, status_type, radtype, cnx_type) VALUES ('fa051981', '  
> 195.238.1.123', '04122007-134255', (to_date('01-JAN-1970','DD-MON- 
> YYYY')+1196772205/86400), '4.12.42.19', 'Virtual', 'Framed-User',  
> 'bob', 'bob', ' 195.238.1.123 4124255',  
> 'radius011.isp.belgacom.be', 'Alive', 4, 'user-speed-go')':
> Dec 4 13:43:25 radius011 radiusd[2608]: Handling with Radius::AuthSQL
> Dec 4 13:43:25 radius011 radiusd[2608]: Handling accounting with  
> Radius::AuthSQL
> Dec 4 13:43:25 radius011 radiusd[2608]: do query is: 'INSERT INTO  
> acct  
> (caller_id,coninfo,duration,framed_ip,in_bytes,login,nas_id,nas_ip,nas 
> _port,nas_port_type,out_bytes,rbit,session_id,status_type,time_stamp)  
> VALUES ('bob','user-speed-go',30,' 4.12.42.19', 
> 36000000,'fa051981','BAS-LALONDE','195.238.1.123',4124255,'Virtual', 
> 36000000,4,'04122007-134255','Alive',1196772205)':
> Dec 4 13:43:25 radius011 radiusd[2608]: Accounting accepted
> Dec 4 13:43:25 radius011 radiusd[2608]: Packet dump: *** Sending to  
> 195.238.1.123 port 35116 .... Packet length = 20 05 84 00 14 c2 23  
> 30 ed 2e 73 f5 32 e3 33 55 eb 00 cb 3c 1d Code: Accounting-Response  
> Identifier: 132 Authentic: <5><7>D<5><233><252>B) 
> B1"<146>e<173><139><187> Attributes:



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?
Have you checked the RadiusExpert wiki:
http://www.open.com.au/wiki/index.php/Main_Page

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
Includes support for reliable RADIUS transport (RadSec),
and DIAMETER translation agent.
-
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.