Again: Major impact on authentication!
guilhermefranco at gmail.com
Tue Feb 6 14:03:42 CET 2007
Thanks to everyone!
I'm using Oracle just for radcheck/radacct and PostgreSQL for radippool only.
No, Mr. Peter, no one is using dial-up admin nor anything alike when
the problem occurs, just pure auth (without acct).
I've disabled the cron.hourly job and the problem appeared again after
some hours. A simple radiusd restart solves the problem. As this
causes impact, I can't afford to do this all the time just to debug,
but I think I gonna run a script to capture all the radiusd -xxx
messages, so when the behaviour starts, I can see what's happening.
Also, it's important to note that this server is the proxy radius and
those error messages appear:
Error: Discarding duplicate request from client ERX-1:50000 - ID: 115
due to unfinished request 32
Info: The maximum number of threads (32) are active, cannot spawn new
thread to handle request
Error: WARNING: Unresponsive child (id 1315006816) for request 105
Error: rlm_sql (sql) in sql_accounting: stop packet with zero session
length. [user 'joe.black at foo.com', nas '10.10.2.1']
Error: Internal error processing module entry
On 2/6/07, Peter Nixon <listuser at peternixon.net> wrote:
> On Mon 05 Feb 2007 13:05, A.L.M.Buxey at lboro.ac.uk wrote:
> > Hi,
> > > Freeradius 1.1.4 is randomly losing connection to both databases and
> > > it's causing total loss in the authentication process:
> > from a historical perspective you may find that is wasnt the 1.1.4 upgrade
> > that has broken things - your database may have finally become too big and
> > unwieldy. this has certainly been the case in many such cases. I would
> > check how long your database queries/inserts are taking. perhaps
> > vacuum/optimise the tables, move/drop older entries, create better KEYs
> > for the purposes you need.
> The _random_ problems don't coincide with a user running a usage report from
> a web interface by any chance do they??
> Peter Nixon
> PGP Key: http://www.peternixon.net/public.asc
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
More information about the Freeradius-Users