freeradius 2.1.1 and postgres communication problem

[m.tarquini at 4it.it]

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! 


--
This message was sent on behalf of m.tarquini at 4it.it at openSubscriber.com
http://www.opensubscriber.com/messages/freeradius-users@lists.freeradius.org/topic.html