Update: Major impact on authentication!

[Guilherme Franco]

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:
Guilherme

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

Regards

Peter


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