Re: High CPU load
On Tue August 26 2003 10:53, Costas Christonis wrote: > Hi to all, > > > We were trying to install freeradius 0.9 but the linux machine had high > cpu load (over 90%) when we were strting ridusd deamon. Does anyone had the > same problem ? With version 0.8 we had no problem... More info please... What modules? What load? What Linux? Is there a DB backend? etc etc.. -- 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
Re: High CPU Load
On Wed, May 28, 2003 at 04:03:43PM -0400, Jeff Sullivan wrote:
> Wed May 28 16:01:01 2003 : Error: rlm_sql (sql): Couldn't update SQL
> accounting STOP record - ERROR: pg_atoi: zero-length string
I believe It's trying to put absent attribute into integer
field (Acct-Session-Time, Acct-Input-Octets, etc),
which is xlat'ed as empty string (bug?).
Try using AcctSessionTime = '%{Acct-Session-Time:-0}'
or AcctSessionTime = %{Acct-Session-Time:-NULL}
or AcctSessionTime = NULLIF('%{Acct-Session-Time}', '')
in update query.
This becomes a FAQ...
--
Fduch M. Pravking
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: High CPU Load
"Jeff Sullivan" <[EMAIL PROTECTED]> wrote: > Also, these start showing up in the radius.log > > Wed May 28 16:01:01 2003 : Error: rlm_sql (sql): failed after re-connect > Wed May 28 16:01:01 2003 : Error: rlm_sql (sql): Couldn't update SQL > accounting STOP record - ERROR: pg_atoi: zero-length string Hmm... try the latest CVS snapshot. It has a number of issues fixed with SQL qeueries, and PostgreSQL specifically. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: High CPU Load
"Jeff Sullivan" <[EMAIL PROTECTED]> wrote: > My accounting is going to postgres. > So... see how long the postgres queries take. > See if the postgres server is running on the same machine as freeradius. Postgres and freeradius is on the same machine.. > See if the postgres process is using all of the CPU. Radiusd is the hog of the system. > Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: High CPU Load
Also, these start showing up in the radius.log Wed May 28 16:01:01 2003 : Error: rlm_sql (sql): failed after re-connect Wed May 28 16:01:01 2003 : Error: rlm_sql (sql): Couldn't update SQL accounting STOP record - ERROR: pg_atoi: zero-length string -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alan DeKok Sent: Wednesday, May 28, 2003 3:49 PM To: [EMAIL PROTECTED] Subject: Re: High CPU Load "Jeff Sullivan" <[EMAIL PROTECTED]> wrote: > When I do authentication only, the cpu is almost idle. > After starting accounting about 15 minutes lapses before > cpu usage starts to peg... > > Any ideas? What are you doing with the accounting packets? detail? SQL? Anything else? The thing processing the accounting packets is the one using the CPU, obviously. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: High CPU Load
"Jeff Sullivan" <[EMAIL PROTECTED]> wrote: > My accounting is going to postgres. So... see how long the postgres queries take. See if the postgres server is running on the same machine as freeradius. See if the postgres process is using all of the CPU. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: High CPU Load
My accounting is going to postgres. I have 4 client usrhipers with 345 modems total. Jeff -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alan DeKok Sent: Wednesday, May 28, 2003 3:49 PM To: [EMAIL PROTECTED] Subject: Re: High CPU Load "Jeff Sullivan" <[EMAIL PROTECTED]> wrote: > When I do authentication only, the cpu is almost idle. > After starting accounting about 15 minutes lapses before > cpu usage starts to peg... > > Any ideas? What are you doing with the accounting packets? detail? SQL? Anything else? The thing processing the accounting packets is the one using the CPU, obviously. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: High CPU Load
"Jeff Sullivan" <[EMAIL PROTECTED]> wrote: > When I do authentication only, the cpu is almost idle. > After starting accounting about 15 minutes lapses before > cpu usage starts to peg... > > Any ideas? What are you doing with the accounting packets? detail? SQL? Anything else? The thing processing the accounting packets is the one using the CPU, obviously. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: High CPU Load
Hi alan I have upgraded to the latest Snapshot, the CPU issue was solved But still, there is something wrong with accounting through proxy. And here I mean accounting to another radius machine, it does not work..., I just don't see the sessions. Until I add the line I mentioned in my last email, it works Ps. I found it in the users mailing list.. Cheers -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, September 27, 2001 5:23 PM To: [EMAIL PROTECTED] Subject: Re: High CPU Load "Mustafa N. Deeb" <[EMAIL PROTECTED]> wrote: > I have moved 10 access servers today to FreeRadius, everything seems to > be fine > > But the more access servers I add, the higher CPU gets > > Radius.log is full of these entries, it says authentication, but 1646 is > the accounting port > > Thu Sep 27 09:08:32 2001 : Error: Dropping conflicting authentication > packet from client XXX:1646 - ID: 183 Yes. Upgrade to the latest CVS snapshot. There's at least a work-around for this problem. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: High CPU Load
"Mustafa N. Deeb" <[EMAIL PROTECTED]> wrote: > I have moved 10 access servers today to FreeRadius, everything seems to > be fine > > But the more access servers I add, the higher CPU gets > > Radius.log is full of these entries, it says authentication, but 1646 is > the accounting port > > Thu Sep 27 09:08:32 2001 : Error: Dropping conflicting authentication > packet from client XXX:1646 - ID: 183 Yes. Upgrade to the latest CVS snapshot. There's at least a work-around for this problem. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
