Postgress SQL connections

[Massimiliano Tarquini]

Hi all,
i’m sperimenting a strange problem using freeradius.

We have a full installation on freeradius 2.1.1 using postgreSql 8.1 running
onto 2 different machines.
The auth work fine 8we have tested it for two days with a killer script that
tests in continuously) but if the proxy stops sending auth requests for a
few minutes (sometimes 15, sometimes 40), at the first request freeradius
start malefunctioning.
Following the log content

----------------------------------------------------------------------------
--------------------------------
Sat Dec 13 16:19:38 2008 : Error: Discarding duplicate request from client
csnradpvip port 1814 - ID: 28 due to unfinished request 11657
Sat Dec 13 16:19:41 2008 : Error: Discarding duplicate request from client
csnradpvip port 1814 - ID: 28 due to unfinished request 11657
Sat Dec 13 16:19:44 2008 : Error: Discarding duplicate request from client
csnradpvip port 1814 - ID: 28 due to unfinished request 11657
Sat Dec 13 16:19:47 2008 : Error: Discarding duplicate request from client
csnradpvip port 1814 - ID: 28 due to unfinished request 11657
Sat Dec 13 16:19:50 2008 : Error: Discarding duplicate request from client
csnradpvip port 1814 - ID: 28 due to unfinished request 11657
Sat Dec 13 16:19:53 2008 : Error: Discarding duplicate request from client
csnradpvip port 1814 - ID: 28 due to unfinished request 11657
Sat Dec 13 16:20:01 2008 : Error: WARNING: Unresponsive child for request
11657, in module sql component authorize
Sat Dec 13 16:20:07 2008 : Info: rlm_sql (sql): There are no DB handles to
use! skipped 0, tried to connect 0
Sat Dec 13 16:20:13 2008 : Info: rlm_sql (sql): There are no DB handles to
use! skipped 0, tried to connect 0
Sat Dec 13 16:20:19 2008 : Info: rlm_sql (sql): There are no DB handles to
use! skipped 0, tried to connect 0
Sat Dec 13 16:20:25 2008 : Info: rlm_sql (sql): There are no DB handles to
use! skipped 0, tried to connect 0
Sat Dec 13 16:20:31 2008 : Info: rlm_sql (sql): There are no DB handles to
use! skipped 0, tried to connect 0
Sat Dec 13 16:20:37 2008 : Info: rlm_sql (sql): There are no DB handles to
use! skipped 0, tried to connect 0
Sat Dec 13 16:20:43 2008 : Info: rlm_sql (sql): There are no DB handles to
use! skipped 0, tried to connect 0
Sat Dec 13 16:20:49 2008 : Error: Received conflicting packet from client
csnradpvip port 1814 - ID: 90 due to unfinished request 11627.  Giving up on
old request.
Sat Dec 13 16:20:49 2008 : Info: rlm_sql (sql): There are no DB handles to
use! skipped 0, tried to connect 0
Sat Dec 13 16:20:55 2008 : Info: rlm_sql (sql): There are no DB handles to
use! skipped 0, tried to connect 0
Sat Dec 13 16:21:01 2008 : Info: rlm_sql (sql): There are no DB handles to
use! skipped 0, tried to connect 0
Sat Dec 13 16:21:07 2008 : Info: rlm_sql (sql): There are no DB handles to
use! skipped 0, tried to connect 0
----------------------------------------------------------------------------
----------------------------------

Which is really strange is that the connections to the database are up and
the database works fine.
After some retry the radius crash.
We tried to schedule a -HUP signal every 5 minutes, but it has non effect.

Please help me! 



4IT S.r.l.
Massimiliano Tarquini | Amministratore unico

---------------------------------------------------------

Via Udine 30-36, 00161 Roma 

Phone +39 06 97601680

Mobile +39 392 9660669

Fax +39 06 97601683

m.tarquini at 4it.it
www.4it.it
“Il presente messaggio e gli eventuali allegati sono di natura
confidenziale.  Qualora vi fosse pervenuto per
errore, vi preghiamo di cancellarlo immediatamente dal vostro sistema e di
avvisare il mittente. Grazie.”
“This electronic mail transmission and any accompanying attachments contain
confidential information. If you
have received this communication in error, please immediately delete the
E-mail and either notify the sender. 
Thank you.”