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
...
--
Date: Feb 8, 2007 10:40 AM
Subject: VALGRIND: Major impact on authentication!
To: FreeRadius users mailing list freeradius-users@lists.freeradius.org
Hello Mr. Alan,
Thank you for your concern!
Just another message I've seen under /var/log/messages
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
On Thu 08 Feb 2007 05:54, Guilherme Franco wrote:
Hi,
I did run valgrind radiusd -xxx at Wed Feb 7 19:15:08 2007 and at
Wed Feb 7 20:59:04 2007 radiusd DIED.
Afterwards, service radius restart would not work and of lots of
Error: Internal error processing module entry, Error:
Hello,
Thank you for the consulting offer Mr. Peter but, as you told, there
seems to be some bugs in the rlm_sql oracle driver.
As everything was good before and now it's breaking, the most probable
cause is the increase in the number of auth users, which brings lots
of acct (0 users in
Guilherme Franco wrote:
As everything was good before and now it's breaking, the most probable
cause is the increase in the number of auth users, which brings lots
of acct (0 users in September 2006 and now with 4000 online users
pumping radacct). The oracle tables are well indexed so the
Hello Mr. Alan,
Thank you for your concern!
Just another message I've seen under /var/log/messages:
kernel: radiusd[1672]: segfault at 0110 rip
002a97de2c1e rsp 007fbfffe340 error 4
Gonna implement radrelay now, then! (I was holding back because I've
seen somewhere in this
Hello,
Of course, I can test sqlippool with Oracle. I just need to do it after
midnight because the earlier problems with Freeradius were so dramatic
that I've received orders to remove freeradius and install some commercial
software. Also, those tests would need to be synthetic ones, since the
Hi,
I did run valgrind radiusd -xxx at Wed Feb 7 19:15:08 2007 and at
Wed Feb 7 20:59:04 2007 radiusd DIED.
Afterwards, service radius restart would not work and of lots of
Error: Internal error processing module entry, Error:
rlm_sql_oracle: fetch failed in sql_fetch_row: ORA-24338: statement
Kenneth Marshall wrote:
Mr. Franco,
I have not looked at the DB connection code, but is there a connection
timer on the DB connection. That is, does the connection get dropped
No
If the latter, the problem could be that the long running connections
are not allowing the indexes and table
Hello,
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
Guilherme Franco wrote:
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:5 - ID: 115
due to unfinished request 32
Info: The maximum number of threads (32) are active, cannot spawn
On Tue, Feb 06, 2007 at 09:14:47AM +, Phil Mayers wrote:
Kenneth Marshall wrote:
Mr. Franco,
I have not looked at the DB connection code, but is there a connection
timer on the DB connection. That is, does the connection get dropped
No
If the latter, the problem could be that
Thanks Mr. DeKok,
I've already downloaded valgrind, just need to setup everything in a
time where the user won't suffer from the downtime.
Mr. Marshall, the only transaction is in rlm_sqlippool.
Thanks.
On 2/6/07, Alan DeKok [EMAIL PROTECTED] wrote:
Guilherme Franco wrote:
Also, it's
On Tue 06 Feb 2007 15:27, Alan DeKok wrote:
Guilherme Franco wrote:
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:5 - ID: 115
due to unfinished request 32
Info: The maximum
Hello Mr. Nixon!
No, the radius server and the DB server are connected in the same
switch, using gigabit UTP, resulting in 0.090ms RTT.
The proxy server is also directly connected to this switch.
I've been using CVS builds mainly because the rlm_sqlippool was under
development with constant
On Tue 06 Feb 2007 18:40, Guilherme Franco wrote:
Hello Mr. Nixon!
No, the radius server and the DB server are connected in the same
switch, using gigabit UTP, resulting in 0.090ms RTT.
The proxy server is also directly connected to this switch.
I've been using CVS builds mainly because
Mr. Peter,
On 2/6/07, Peter Nixon [EMAIL PROTECTED] wrote:
OK. Well we have added a few more things this week. The last commit was just
over an hour ago for:
http://bugs.freeradius.org/show_bug.cgi?id=414
Yes, I've been watching the progress in Automatic report from sources
(radiusd) in the
On Tue 06 Feb 2007 21:35, Guilherme Franco wrote:
Mr. Peter,
On 2/6/07, Peter Nixon [EMAIL PROTECTED] wrote:
OK. Well we have added a few more things this week. The last commit was
just over an hour ago for:
http://bugs.freeradius.org/show_bug.cgi?id=414
Yes, I've been watching the
Guilherme Franco wrote:
Freeradius 1.1.4 is randomly losing connection to both databases and
it's causing total loss in the authentication process:
The messages you posted show it's NOT losing connection to the database.
Info: rlm_sql (sql): There are no DB handles to use! skipped 0,
Hi,
Freeradius 1.1.4 is randomly losing connection to both databases and it's
causing total loss in the authentication process:
Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to
connect 0
Info: rlm_sql (sql_postgresql): There are no DB handles to use! skipped 0,
tried to
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
Hello,
Thank you all for your prompt answers!
The database takes between 15ms and 40ms to answer to freeradius and has
only 40.000 entries there, so it isn't big.
PostgreSQL is updated to it's latest version and vaccum runs every night.
The queries are from sqlippool.conf, so...
Thanks!
-
Guilherme Franco wrote:
The database takes between 15ms and 40ms to answer to freeradius
Sometimes it takes a LOT longer than that.
Find out why.
Alan DeKok.
--
http://deployingradius.com - The web site of the book
http://deployingradius.com/blog/ - The blog
-
List
Alan DeKok wrote:
As this is random, it's hard to debug, but at the same time freeradius
loses the connection, several other applications can successfully
connect/ maintain previous established connections to the databases.
FreeRADIUS is NOT losing its connection to the DB. If you think
Hello,
Considering that all things indicate that there might be a problem with the
DB, I did some tweaks in PostgreSQL and took off the cron.hourly job.
Gonna watch out for problems then, thanks!
-
Hi,
Freeradius 1.1.4 is randomly
I'm testing PostgreSQL performance with various tools.
Thanks!
On 2/5/07, Dennis Skinner [EMAIL PROTECTED] wrote:
Alan DeKok wrote:
As this is random, it's hard to debug, but at the same time freeradius
loses the connection, several other applications can successfully
connect/ maintain
Mr. Franco,
I have not looked at the DB connection code, but is there a connection
timer on the DB connection. That is, does the connection get dropped
and restarted occasionally or does it persist until the connection dies?
If the latter, the problem could be that the long running connections
On Mon 05 Feb 2007 13:05, [EMAIL PROTECTED] 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
On Mon 05 Feb 2007 23:03, Guilherme Franco wrote:
Sorry Mr. Geoffroy, your message arrived only now in my e-mail.
Somehow, every list message takes a large amount of time to come into my
e-mail.
I am also have big delays on some emails from the list (Up to 5 days!) while
others arrive within
30 matches
Mail list logo