Update: Major impact on authentication!

Guilherme Franco guilhermefranco at gmail.com
Tue Feb 13 01:36:38 CET 2007

Sorry, Mr. Nixon,

Freeradius 1.1.4 on latest RHEL AS4 x64 with rlm_sqlippool, using PostgreSQL
8.2.1 and Oracle10gR2 backends (postgresql and oracle are installed on
another machine).

radiusd.conf    : max_servers = 32
postgresql.conf: num_sql_socks = 32
oraclesql.conf  : num_sql_socks = 32

Oracle  : radcheck, radacct and radpostauth;
PGSQL: radippool.

Aside the other problems valgrind has shown (which radsqlrelay
circumvented), after some hours, freeradius start to log lots of "Info:
rlm_sqlippool: ip=[] len=0". Running the allocate-find query directly under
psql shows no problem.

Issuing "service radiusd restart" solves the problem. I did a
cron.hourlyjob with this then.

PostgreSQL have only one table "radippool" with just 28000 entries there.

As you've told that this version of rlm_sqlippool is based upon a PostgreSQL
Bug, I'm considering to update to the latest CVS head and try it with
postgresql 8.2.3 and/or Oracle 10gr2.
Thank you!


On 2/12/07, Peter Nixon <listuser at peternixon.net> wrote:

Can you please recap on your current configuration and version of FR?



On Mon 12 Feb 2007 19:10, Guilherme Franco wrote:
> Hello,
> Even with radsqlrelay working, sqlippool loses dbhandles with postgresql.
> Because of this, the cron.hourly job is still necessary...
> ------------------------------------------
> Date: Feb 8, 2007 10:40 AM
> Subject: VALGRIND: Major impact on authentication!
> To: FreeRadius users mailing list <freeradius-users at lists.freeradius.org>
> Hello Mr. Alan,
> Thank you for your concern!
> Just another message I've seen under /var/log/messages:
> kernel: radiusd[1672]: segfault at 0000000000000110 rip
> 0000002a97de2c1e rsp 0000007fbfffe340 error 4
> Gonna implement radrelay now, then! (I was holding back because I've
> seen somewhere in this mail list that it breaks simultaneous-use).
> Thanks a lot!


Peter Nixon
PGP Key: http://www.peternixon.net/public.asc
List info/subscribe/unsubscribe? See
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20070212/fa6a8ed8/attachment.html>

More information about the Freeradius-Users mailing list