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 <[EMAIL PROTECTED]> 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 <[email protected]> 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
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
