Error logs on freeradius 2.1.8

[Oninz Unix]

Hi Alan,

        Thanks for clarification, i just want to ask if we solve this in the firewall settings, can i also solve my problem with this logs also?

rlm_sql_oracle: execute query failed 
in sql_query: ORA-03113: end-of-file on communication channel 

Error: rlm_sql_oracle: OCI_SERVER_NOT_CONNECTED


It might be the reason also why getting this errors because of hung request due to firewall settings?

Thanks again.

Message: 5
Date: Wed, 28 Apr 2010 16:19:30 +0200
From: Alan DeKok <aland at deployingradius.com>
Subject: Re: Error logs on freeradius 2.1.8
To: FreeRadius users mailing list
    <freeradius-users at lists.freeradius.org>
Message-ID: <4BD843F2.9030803 at deployingradius.com>
Content-Type: text/plain; charset=ISO-8859-1

Oninz Unix wrote:
>         I know some os the thread almost similar to my problem, but let
> me send some logs from my freeradius logs.
> 
> Tue Apr 27 17:59:44 2010 : Info: WARNING: Child is hung for request 383.
> Tue Apr 27 17:59:44 2010 : Info: WARNING: Child is hung for request 382.
> Tue Apr 27 17:59:45 2010 : Info: WARNING: Child is hung for request 379.
> Tue Apr 27 17:59:46 2010 : Info: WARNING: Child is hung for request 383.
> Tue Apr 27 17:59:48 2010 : Info: WARNING: Child is hung for request 377.
...
> Error: WARNING: Unresponsive child for request 384, in module
> sql2_redundant component accounting
...
> I hope you could help me were to start to debug and solve the problem.

  You have a firewall between the RADIUS server and database.  The
firewall is dropping the RADIUS -> database TCP connections.

  I have *no* idea why anyone thinks this is a good idea.  The firewall
(if any) should be configured to allow ANY TCP (RADIUS -> DB : port).
But many people create rules allowing only "established" TCP
connections, and then the firewall helpfully loses track of which
sessions are established.

  Stop breaking your network.

  Alan DeKok.





      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20100501/19c02204/attachment.html>