<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">Hi Alan,<br><br> 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?<br><br>rlm_sql_oracle: execute query failed
in sql_query: ORA-03113: end-of-file on communication channel
<br>Error: rlm_sql_oracle: OCI_SERVER_NOT_CONNECTED
<br><br>It might be the reason also why getting this errors because of hung request due to firewall settings?<br><br>Thanks again.<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><div class="plainMail"><br>Message: 5<br>Date: Wed, 28 Apr 2010 16:19:30 +0200<br>From: Alan DeKok <<a ymailto="mailto:aland@deployingradius.com" href="/mc/compose?to=aland@deployingradius.com">aland@deployingradius.com</a>><br>Subject: Re: Error logs on freeradius 2.1.8<br>To: FreeRadius users mailing list<br> <<a ymailto="mailto:freeradius-users@lists.freeradius.org" href="/mc/compose?to=freeradius-users@lists.freeradius.org">freeradius-users@lists.freeradius.org</a>><br>Message-ID: <<a ymailto="mailto:4BD843F2.9030803@deployingradius.com" href="/mc/compose?to=4BD843F2.9030803@deployingradius.com">4BD843F2.9030803@deployingradius.com</a>><br>Content-Type: text/plain;
charset=ISO-8859-1<br><br>Oninz Unix wrote:<br>> I know some os the thread almost similar to my problem, but let<br>> me send some logs from my freeradius logs.<br>> <br>> Tue Apr 27 17:59:44 2010 : Info: WARNING: Child is hung for request 383.<br>> Tue Apr 27 17:59:44 2010 : Info: WARNING: Child is hung for request 382.<br>> Tue Apr 27 17:59:45 2010 : Info: WARNING: Child is hung for request 379.<br>> Tue Apr 27 17:59:46 2010 : Info: WARNING: Child is hung for request 383.<br>> Tue Apr 27 17:59:48 2010 : Info: WARNING: Child is hung for request 377.<br>...<br>> Error: WARNING: Unresponsive child for request 384, in module<br>> sql2_redundant component accounting<br>...<br>> I hope you could help me were to start to debug and solve the problem.<br><br> You have a firewall between the RADIUS server and database. The<br>firewall is dropping the RADIUS -> database TCP
connections.<br><br> I have *no* idea why anyone thinks this is a good idea. The firewall<br>(if any) should be configured to allow ANY TCP (RADIUS -> DB : port).<br>But many people create rules allowing only "established" TCP<br>connections, and then the firewall helpfully loses track of which<br>sessions are established.<br><br> Stop breaking your network.<br><br> Alan DeKok.<br><br><br></div></blockquote></td></tr></table><br>