Re: Kill -HUP in debug mode eats all CPU
At Fri, 12 Dec 2003 19:24:03 +0200, ZORBADELOS KONSTANTINOS wrote: Here is the output after adding debug_level = 2 as the last line of radiusd.conf. Sorry for the delay I was off for the weekend. By the way I compiled freeradius on another SUN machine (much bigger) with gcc 2.95.3 and in the HUP signal it didn't eat the cpu (without connections to an sql database). Thanks Alan. --- Walking the entire request list --- Nothing to do. Sleeping until we see a request. Reloading configuration files. reread_config: reading radiusd.conf Config: including file: /export/home/radius/freeradius-0.9.3/BUILD/etc/raddb/proxy.conf Config: including file: /export/home/radius/freeradius-0.9.3/BUILD/etc/raddb/clients.conf Config: including file: /export/home/radius/freeradius-0.9.3/BUILD/etc/raddb/snmp.conf Config: including file: /export/home/radius/freeradius-0.9.3/BUILD/etc/raddb/oraclesql.conf main: prefix = /export/home/radius/freeradius-0.9.3/BUILD main: localstatedir = /export/home/radius/freeradius-0.9.3/BUILD/var main: logdir = /export/home/radius/freeradius-0.9.3/BUILD/var/log/radius main: libdir = /export/home/radius/freeradius-0.9.3/BUILD/lib main: radacctdir = /export/home/radius/freeradius-0.9.3/BUILD/var/log/radius/radacct main: hostname_lookups = no main: max_request_time = 30 main: cleanup_delay = 5 main: max_requests = 1024 main: delete_blocked_requests = 0 main: port = 0 main: allow_core_dumps = no main: log_stripped_names = no main: log_file = /export/home/radius/freeradius-0.9.3/BUILD/var/log/radius/radius.log main: log_auth = yes main: log_auth_badpass = no main: log_auth_goodpass = no main: pidfile = /export/home/radius/freeradius-0.9.3/BUILD/var/run/radiusd/radiusd.pid main: user = radius main: group = other main: usercollide = no main: lower_user = no main: lower_pass = no main: nospace_user = no main: nospace_pass = no main: checkrad = /export/home/radius/freeradius-0.9.3/BUILD/sbin/checkrad main: proxy_requests = yes proxy: retry_delay = 5 proxy: retry_count = 3 proxy: synchronous = yes proxy: default_fallback = yes proxy: dead_time = 120 proxy: post_proxy_authorize = no proxy: wake_all_if_all_dead = no security: max_attributes = 200 security: reject_delay = 1 security: status_server = no main: debug_level = 2 read_config_files: reading dictionary read_config_files: reading naslist Using deprecated naslist file. Support for this will go away soon. read_config_files: reading clients Using deprecated clients file. Support for this will go away soon. read_config_files: reading realms Using deprecated realms file. Support for this will go away soon. radiusd: entering modules setup rlm_sql (sql1): Closing sqlsocket 2 rlm_sql (sql1): Closing sqlsocket 1 rlm_sql (sql1): Closing sqlsocket 0 rlm_sql (sql2): Closing sqlsocket 2 rlm_sql (sql2): Closing sqlsocket 1 rlm_sql (sql2): Closing sqlsocket 0 Bus Error (core dumped) == Kostas Zorbadelos Currently at: Otenet IT Department mailto: [EMAIL PROTECTED] Out there in the darkness, out there in the night out there in the starlight, one soul burns brighter than a thousand suns. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Kill -HUP in debug mode eats all CPU
Hello to everyone. As I have seen in a previous post a bug that occasionaly crashed the server when it received a HUP signal has been fixed. After compiling the latest release (0.9.3) on a SUN Ultra 100 (Solaris 8) I noticed that when I start the server in debug mode (radiusd -X) and send it a HUP signal it says that it rereads the configuration files but it eats the CPU resources, does not serve requests and it can't receive any other signal apart from -9. I used gcc 2.95.3. In the previous release when a HUP was received (in debug mode) the server crashed always. Here is part of the output from the first HUP signal --- Walking the entire request list --- Nothing to do. Sleeping until we see a request. Reloading configuration files. reread_config: reading radiusd.conf Config: including file: /export/home/radius/freeradius-0.9.3/BUILD/etc/raddb/proxy.conf Config: including file: /export/home/radius/freeradius-0.9.3/BUILD/etc/raddb/clients.conf Config: including file: /export/home/radius/freeradius-0.9.3/BUILD/etc/raddb/snmp.conf Config: including file: /export/home/radius/freeradius-0.9.3/BUILD/etc/raddb/oraclesql.conf main: prefix = /export/home/radius/freeradius-0.9.3/BUILD main: localstatedir = /export/home/radius/freeradius-0.9.3/BUILD/var main: logdir = /export/home/radius/freeradius-0.9.3/BUILD/var/log/radius main: libdir = /export/home/radius/freeradius-0.9.3/BUILD/lib main: radacctdir = /export/home/radius/freeradius-0.9.3/BUILD/var/log/radius/radacct main: hostname_lookups = no main: max_request_time = 30 main: cleanup_delay = 5 main: max_requests = 1024 main: delete_blocked_requests = 0 main: port = 0 main: allow_core_dumps = no main: log_stripped_names = no main: log_file = /export/home/radius/freeradius-0.9.3/BUILD/var/log/radius/radius.log main: log_auth = yes main: log_auth_badpass = no main: log_auth_goodpass = no main: pidfile = /export/home/radius/freeradius-0.9.3/BUILD/var/run/radiusd/radiusd.pid main: user = radius main: group = other main: usercollide = no main: lower_user = no main: lower_pass = no main: nospace_user = no main: nospace_pass = no main: checkrad = /export/home/radius/freeradius-0.9.3/BUILD/sbin/checkrad main: proxy_requests = yes proxy: retry_delay = 5 proxy: retry_count = 3 proxy: synchronous = yes proxy: default_fallback = yes proxy: dead_time = 120 proxy: post_proxy_authorize = no proxy: wake_all_if_all_dead = no security: max_attributes = 200 security: reject_delay = 1 security: status_server = no main: debug_level = 0 read_config_files: reading dictionary read_config_files: reading naslist Using deprecated naslist file. Support for this will go away soon. read_config_files: reading clients Using deprecated clients file. Support for this will go away soon. read_config_files: reading realms Using deprecated realms file. Support for this will go away soon. For anything else you might need to trace the error let me know. == Kostas Zorbadelos Currently at: Otenet IT Department mailto: [EMAIL PROTECTED] Out there in the darkness, out there in the night out there in the starlight, one soul burns brighter than a thousand suns. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Kill -HUP in debug mode eats all CPU
Add the string debug_level = 2 as the last line of radiusd.conf At 11:24 AM 12/12/2003, you wrote: Hello to everyone. As I have seen in a previous post a bug that occasionaly crashed the server when it received a HUP signal has been fixed. After compiling the latest release (0.9.3) on a SUN Ultra 100 (Solaris 8) I noticed that when I start the server in debug mode (radiusd -X) and send it a HUP signal it says that it rereads the configuration files but it eats the CPU resources, does not serve requests and it can't receive any other signal apart from -9. I used gcc 2.95.3. In the previous release when a HUP was received (in debug mode) the server crashed always. Here is part of the output from the first HUP signal --- Walking the entire request list --- Nothing to do. Sleeping until we see a request. Reloading configuration files. reread_config: reading radiusd.conf Config: including file: /export/home/radius/freeradius-0.9.3/BUILD/etc/raddb/proxy.conf Config: including file: /export/home/radius/freeradius-0.9.3/BUILD/etc/raddb/clients.conf Config: including file: /export/home/radius/freeradius-0.9.3/BUILD/etc/raddb/snmp.conf Config: including file: /export/home/radius/freeradius-0.9.3/BUILD/etc/raddb/oraclesql.conf main: prefix = /export/home/radius/freeradius-0.9.3/BUILD main: localstatedir = /export/home/radius/freeradius-0.9.3/BUILD/var main: logdir = /export/home/radius/freeradius-0.9.3/BUILD/var/log/radius main: libdir = /export/home/radius/freeradius-0.9.3/BUILD/lib main: radacctdir = /export/home/radius/freeradius-0.9.3/BUILD/var/log/radius/radacct main: hostname_lookups = no main: max_request_time = 30 main: cleanup_delay = 5 main: max_requests = 1024 main: delete_blocked_requests = 0 main: port = 0 main: allow_core_dumps = no main: log_stripped_names = no main: log_file = /export/home/radius/freeradius-0.9.3/BUILD/var/log/radius/radius.log main: log_auth = yes main: log_auth_badpass = no main: log_auth_goodpass = no main: pidfile = /export/home/radius/freeradius-0.9.3/BUILD/var/run/radiusd/radiusd.pid main: user = radius main: group = other main: usercollide = no main: lower_user = no main: lower_pass = no main: nospace_user = no main: nospace_pass = no main: checkrad = /export/home/radius/freeradius-0.9.3/BUILD/sbin/checkrad main: proxy_requests = yes proxy: retry_delay = 5 proxy: retry_count = 3 proxy: synchronous = yes proxy: default_fallback = yes proxy: dead_time = 120 proxy: post_proxy_authorize = no proxy: wake_all_if_all_dead = no security: max_attributes = 200 security: reject_delay = 1 security: status_server = no main: debug_level = 0 read_config_files: reading dictionary read_config_files: reading naslist Using deprecated naslist file. Support for this will go away soon. read_config_files: reading clients Using deprecated clients file. Support for this will go away soon. read_config_files: reading realms Using deprecated realms file. Support for this will go away soon. For anything else you might need to trace the error let me know. == Kostas Zorbadelos Currently at: Otenet IT Department mailto: [EMAIL PROTECTED] Out there in the darkness, out there in the night out there in the starlight, one soul burns brighter than a thousand suns. - 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: Kill -HUP in debug mode eats all CPU
ZORBADELOS KONSTANTINOS [EMAIL PROTECTED] wrote: As I have seen in a previous post a bug that occasionaly crashed the server when it received a HUP signal has been fixed. After compiling the latest release (0.9.3) on a SUN Ultra 100 (Solaris 8) I noticed that when I start the server in debug mode (radiusd -X) and send it a HUP signal I'll put a fix into the latest CVS snapshot. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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
High CPU Load
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? _ How many firemen does it take to change a light bulb? Four. One to change the bulb and 3 to chop a hole in the roof. - 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
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: 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
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. 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
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
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: FreeRadius 0.8, Oracle 8.1.7. Problem with CPU load
Novoselsky Alexander wrote: May be. But OpenRADIUS and Navis Radius use simple SQL queries: SELECT password FROM users WHERE username = ?. IMNAODBA (= I am not an Oracle DBA), but I have it on reasonable authority that queries of the above form (bindable?) are cacheable by Oracle. It seems to me, in FreeRadius 0.8 SQL query is not configurable parameter. I *think* that such queries rely on a different Oracle API, in order to bind the argument values to the parameters. -- Regards, Daryl Tester, Software Wrangler and Bit Herder, IOCANE Pty. Ltd. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Re: FreeRadius 0.8, Oracle 8.1.7. Problem with CPU load
Title: RE: Re: FreeRadius 0.8, Oracle 8.1.7. Problem with CPU load
-Original Message-
From: Chris Parker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 26, 2002 7:47 PM
To: [EMAIL PROTECTED]
Maybe they cache the responses from Oracle. Look at the queries they do to Oracle, to see what's going on.
May be. But OpenRADIUS and Navis Radius use simple SQL queries: SELECT password FROM users WHERE username = ?.
It seems to me, in FreeRadius 0.8 SQL query is not configurable parameter.
But FreeRadius 0.7.1 used almost the same SQL query (it was in file sql.conf).
Nope, you can edit the queries in 'sql.conf' for all versions of FreeRADIUS.
Try editing it and see what it does to the performance. A simpler
query ( assuming properly indexed tables, etc ) should return faster.
Thank you for advice, Chris.
I tried to leave in file 'sql.conf' only 1 line with SELECT:
authorize_check_query = SELECT id,UserName,Attribute,Value,op FROM ${authcheck_table} WHERE Username = '%{SQL-User-Name}' ORDER BY id
It improved results: instead of 25-30% CPU load, now works with Oracle takes 15-20% CPU load.
May be, source of my problem was so. I filled only table 'radcheck', but left in file 'sql.conf' all SQL queries, which tried to search in empty tables.
Best regards,
Alexander Novoselsky, Programmer
E-mail: [EMAIL PROTECTED]
Re: Re: FreeRadius 0.8, Oracle 8.1.7. Problem with CPU load
Title: Re: Re: FreeRadius 0.8, Oracle 8.1.7. Problem with CPU load From: Alan DeKok [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: FreeRadius 0.8, Oracle 8.1.7. Problem with CPU load Date: Mon, 25 Nov 2002 14:52:49 -0500 Novoselsky Alexander [EMAIL PROTECTED] wrote: Results were nice. FreeRadius 0.8 gives: Work with 'users' file 270 authentications per second, Work with Oracle 8.1.7 149 authentications per second, Memory consumption 4 MB, Response time 23 msec. But I saw one problem. Total CPU load during the work with Oracle 8.1.7 is about 27%. Why is this a problem? Since you ran it with the 'users' file, and didn't have any problems with the CPU load, it's clear that any problem is related only to Oracle. Alan DeKok. I do not think, that problem is related to Oracle. Of course, work with the 'users' file makes less CPU load (3%). But in the same conditions (averaged load 50 requests/sec), the work with Oracle 8.1.7 of other RADIUS servers makes following CPU load: OpenRADIUS 0.9.4 7% Navis Radius 4.2.4 9% RAD-R 6.0 9 % Best regards, Alexander Novoselsky E-mail: [EMAIL PROTECTED]
Re: FreeRadius 0.8, Oracle 8.1.7. Problem with CPU load
Novoselsky Alexander [EMAIL PROTECTED] wrote: I do not think, that problem is related to Oracle. Of course, work with the 'users' file makes less CPU load (3%). But in the same conditions (averaged load 50 requests/sec), the work with Oracle 8.1.7 of other RADIUS servers makes following CPU load: Ah, so you had more information about *why* it was a problem, that you didn't include in your previous message. I don't understand why you would ask a question, and intentionally leave out information. OpenRADIUS 0.9.4 7% Navis Radius 4.2.49% RAD-R 6.0 9 % Maybe they cache the responses from Oracle. Look at the queries they do to Oracle, to see what's going on. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Re: FreeRadius 0.8, Oracle 8.1.7. Problem with CPU load
Title: Re: Re: FreeRadius 0.8, Oracle 8.1.7. Problem with CPU load Novoselsky Alexander [EMAIL PROTECTED] wrote: I do not think, that problem is related to Oracle. Of course, work with the 'users' file makes less CPU load (3%). But in the same conditions (averaged load 50 requests/sec), the work with Oracle 8.1.7 of other RADIUS servers makes following CPU load: Ah, so you had more information about *why* it was a problem, that you didn't include in your previous message. I don't understand why you would ask a question, and intentionally leave out information. I am sorry, that my previous posting was not comprehensive enough. But now I do not have more information about *why* it was a problem. I only have seen a situation, which is not clear for me. If I can provide any information, which useful for FreeRadius community, let me know. OpenRADIUS 0.9.4 7% Navis Radius 4.2.4 9% RAD-R 6.0 9% Maybe they cache the responses from Oracle. Look at the queries they do to Oracle, to see what's going on. May be. But OpenRADIUS and Navis Radius use simple SQL queries: SELECT password FROM users WHERE username = ?. It seems to me, in FreeRadius 0.8 SQL query is not configurable parameter. But FreeRadius 0.7.1 used almost the same SQL query (it was in file sql.conf). Best regards, Alexander Novoselsky E-mail: [EMAIL PROTECTED]
Re: Re: FreeRadius 0.8, Oracle 8.1.7. Problem with CPU load
At 07:38 PM 11/26/2002 +0200, Novoselsky Alexander wrote: OpenRADIUS 0.9.47% Navis Radius 4.2.4 9% RAD-R 6.0 9% Maybe they cache the responses from Oracle. Look at the queries they do to Oracle, to see what's going on. May be. But OpenRADIUS and Navis Radius use simple SQL queries: SELECT password FROM users WHERE username = ?. It seems to me, in FreeRadius 0.8 SQL query is not configurable parameter. But FreeRadius 0.7.1 used almost the same SQL query (it was in file sql.conf). Nope, you can edit the queries in 'sql.conf' for all versions of FreeRADIUS. Try editing it and see what it does to the performance. A simpler query ( assuming properly indexed tables, etc ) should return faster. -Chris -- \\\|||/// \ StarNet Inc. \ Chris Parker \ ~ ~ / \ WX *is* Wireless!\ Director, Engineering | @ @ |\ http://www.starnetwx.net \ (847) 963-0116 oOo---(_)---oOo--\-- \ Wholesale Internet Services - http://www.megapop.net - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
FreeRadius makes MySQL 100% CPU loading
Title: FreeRadius makes MySQL 100% CPU loading
Dear all,
When I use FreeRadius 0.5 and use MySQL module,
the CPU loading of MySQL server is extremely high.
radiusd.conf has only sql in authorize section
authorize {
sql
}
Thanks.
Patrick
Re: FreeRadius makes MySQL 100% CPU loading
My machine (a athlon 1000 with 512mb ram) begins to run slower afer two days of radius
operation... and mysql begins to take more and more cpu..
I've been using mysql on this machine for more than a year now, and this begun only
with freeradius-0.5. Now I'm using a four-days ago snapshot, and had to boot the machine
today..
--Original Message Text---
From: Patrick Chan
Date: Thu, 23 May 2002 17:33:48 +0800
FreeRadius makes MySQL 100% CPU loading
Dear all,
When I use FreeRadius 0.5 and use MySQL module,
the CPU loading of MySQL server is extremely high.
radiusd.conf has only sql in authorize section
authorize {
sql
}
Thanks.
Patrick
Asopiniõesformuladasnestee-mailsãodecaráter
exclusivamentepessoal.Minhaopiniãonãonecessariamente
representaaopiniãodomeuMotoGruponemdaempresaonde
trabalho.
MeneSakkhetur-seveh
AlexandreGanso-DiretorSteelGooseMotoGroup
6,7e8desetembro-Aniversario10anosSteelGoose-OuroBranco-MG
500FourVermelha
[EMAIL PROTECTED]
ICQ#3778773
Re: FreeRadius makes MySQL 100% CPU loading
At 06:28 PM 5/23/2002 -0300, Alexandre Strube wrote: My machine (a athlon 1000 with 512mb ram) begins to run slower afer two days of radius operation... and mysql begins to take more and more cpu.. I've been using mysql on this machine for more than a year now, and this begun only with freeradius-0.5. Now I'm using a four-days ago snapshot, and had to boot the machine today.. Most likely your mysql server/table definitions do not contain proper or sufficient indexes. The fact that it slows over time strongly indicates this. You should look at your mysql tables, and investigate creating additional indexes. Use the 'explain' function of mysql. More docs on tuning mysql available at: www.mysql.com. -Chris -- \\\|||/// \ StarNet Inc. \ Chris Parker \ ~ ~ / \ WX *is* Wireless!\ Director, Engineering | |\ http://www.starnetwx.net \ (847) 963-0116 oOo---(_)---oOo--\-- \ Wholesale Internet Services - http://www.megapop.net - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius makes MySQL 100% CPU loading
Alexandre Strube [EMAIL PROTECTED] wrote: My machine (a athlon 1000 with 512mb ram) begins to run slower afer two days of radius operation... and mysql begins to take more and more cpu.. Have you tried indexing your MySQL database? Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius makes MySQL 100% CPU loading
On Thu, 23 May 2002 16:37:09 -0500, Chris Parker wrote: At 06:28 PM 5/23/2002 -0300, Alexandre Strube wrote: My machine (a athlon 1000 with 512mb ram) begins to run slower afer two days of radius operation... and mysql begins to take more and more cpu.. I've been using mysql on this machine for more than a year now, and this begun only with freeradius-0.5. Now I'm using a four-days ago snapshot, and had to boot the machine today.. Most likely your mysql server/table definitions do not contain proper or sufficient indexes. The fact that it slows over time strongly indicates this. You should look at your mysql tables, and investigate creating additional indexes. Use the 'explain' function of mysql. More docs on tuning mysql available at: www.mysql.com. I`m using the standard radius tables as described on rlm_sql_mysql schema. And this happens only when freeradius is running on the machine. I've closed freeradius and nothing happened, inspite of intensive use of mysql thoughout the day. As opiniões formuladas neste e-mail são de caráter exclusivamente pessoal. Minha opinião não necessariamente representa a opinião do meu Moto Grupo nem da empresa onde trabalho. Mene Sakkhet ur-seveh Alexandre Ganso - Diretor Steel Goose Moto Group 6, 7 e 8 de setembro - Aniversario 10 anos Steel Goose - Ouro Branco - MG 500 Four Vermelha [EMAIL PROTECTED] ICQ# 3778773 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: CPU
On Mon, 6 May 2002 11:04:36 -0300, Rodrigo Gonzalez wrote: Means that the server is restarting all the time, isnt it? And thats explained why its taking all your cpu time... Its not a single process, but several restarts of radius server... Does it make sense for you? What´s the error when in debug mode? OS: Linux Kernel 2.2.17 Modules: SQL Top shows that is a radius daemon the one who has 99% of CPU usage It 'is not working in debug mode As opiniões formuladas neste e-mail são de caráter exclusivamente pessoal. Minha opinião não necessariamente representa a opinião do meu Moto Grupo nem da empresa onde trabalho. Mene Sakkhet ur-seveh Alexandre Ganso - Diretor Steel Goose Moto Group 500 Four Vermelha [EMAIL PROTECTED] ICQ# 3778773 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: CPU
I really don't knnow how to do this, could someone explain it? Regards. - Original Message - From: Alan DeKok [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 03, 2002 1:04 PM Subject: Re: CPU Rodrigo Gonzalez [EMAIL PROTECTED] wrote: I tried latest CVS and the CPU issue is not solved, maybe I am doing = something wrong.I test configuring delete_blocked_request yo yes and = no, but it is the sameafter 2 or 3 hours the CPU goes to 99% and I = need to restart the daemon That's bad. Can you trace it with gdb, to see what's happening? 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: CPU
OS: Linux Kernel 2.2.17 Modules: SQL Top shows that is a radius daemon the one who has 99% of CPU usage It 'is not working in debug mode Regards. - Original Message - From: Chris Parker [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 03, 2002 11:39 AM Subject: Re: CPU At 12:12 PM 5/2/2002 -0300, Rodrigo Gonzalez wrote: I tried latest CVS and the CPU issue is not solved, maybe I am doing something wrong.I test configuring delete_blocked_request yo yes and no, but it is the sameafter 2 or 3 hours the CPU goes to 99% and I need to restart the daemon What OS? Also, what modules are you using ( LDAP, SQL, ??? ). What does 'top' show. Is FreeRADIUS the cpu hog? Does it happen in debug mode? If so, what is FreeRADIUS doing when it spikes CPU ( based on debug message output ). -Chris -- \\\|||/// \ StarNet Inc. \Chris Parker \ ~ ~ / \ WX *is* Wireless!\ Director, Engineering | @ @ |\ http://www.starnetwx.net \ (847) 963-0116 oOo---(_)---oOo--\-- \ Wholesale Internet Services - http://www.megapop.net - 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: CPU
At 12:12 PM 5/2/2002 -0300, Rodrigo Gonzalez wrote: I tried latest CVS and the CPU issue is not solved, maybe I am doing something wrong.I test configuring delete_blocked_request yo yes and no, but it is the sameafter 2 or 3 hours the CPU goes to 99% and I need to restart the daemon What OS? Also, what modules are you using ( LDAP, SQL, ??? ). What does 'top' show. Is FreeRADIUS the cpu hog? Does it happen in debug mode? If so, what is FreeRADIUS doing when it spikes CPU ( based on debug message output ). -Chris -- \\\|||/// \ StarNet Inc. \Chris Parker \ ~ ~ / \ WX *is* Wireless!\ Director, Engineering | |\ http://www.starnetwx.net \ (847) 963-0116 oOo---(_)---oOo--\-- \ Wholesale Internet Services - http://www.megapop.net - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: CPU
Rodrigo Gonzalez [EMAIL PROTECTED] wrote: I tried latest CVS and the CPU issue is not solved, maybe I am doing = something wrong.I test configuring delete_blocked_request yo yes and = no, but it is the sameafter 2 or 3 hours the CPU goes to 99% and I = need to restart the daemon That's bad. Can you trace it with gdb, to see what's happening? Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re[2]: CPU
Dear Fduch the Pravking, --Tuesday, April 30, 2002, 7:49:56 PM, you wrote to [EMAIL PROTECTED]: FtP On Thu, Apr 25, 2002 at 12:10:03PM +0400, 3APA3A wrote: Dear Daniel Yeung, Have you installed 0.5 on new box or updated previous FreeRADIUS version? You have to remove older version before installing 0.5 FtP Do you have an idea about how to do it easily? FtP I mean, do I have to `rm` installed binaries manually FtP or there is some tool? rm should be enougth :) Don't forget to remove rlm_* from lib's. -- ~/ZARAZA îÕ Á × ÃÅÌÏÍ, õÉÌØÑÍ, ÚÄÅÛÎÉÊ ËÌÉÍÁÔ - ÅÖÅÌÉ ÔÏÌØËÏ ÜÔÏ ÍÏÖÎÏ ÎÁÚ×ÁÔØ ËÌÉÍÁÔÏÍ, ×ÐÏÌÎÅ ÓÎÏÓÎÙÊ. (ô×ÅÎ) - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: CPU
On Thu, Apr 25, 2002 at 12:10:03PM +0400, 3APA3A wrote: Dear Daniel Yeung, Have you installed 0.5 on new box or updated previous FreeRADIUS version? You have to remove older version before installing 0.5 Do you have an idea about how to do it easily? I mean, do I have to `rm` installed binaries manually or there is some tool? There is 'freeadius-devel' in ports collection, but it is out of date :(( Shoud I write own port? -- ~/ZARAZA îÕ Á ÔÅÐÅÒØ, õÉÌØÑÍ, ÈÏÒÏÛÅÎØËÏ ÐÏÒÁÚÍÙÓÌÉÔÅ ÎÁÄ ÄÁÎÎÙÍ ÐÉÓØÍÏÍ. (ô×ÅÎ) ïÂÑÚÁÔÅÌØÎÏ :) -- Fduch M. Pravking - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
CPU
I tried latest CVS and the CPU issue is not solved, maybe I am doing something wrong.I test configuring delete_blocked_request yo yes and no, but it is the sameafter 2 or 3 hours the CPU goes to 99% and I need to restart the daemon Regards, Rodrigo Gonzalez.
Re: CPU
Dear Daniel Yeung, Have you installed 0.5 on new box or updated previous FreeRADIUS version? You have to remove older version before installing 0.5 --Thursday, April 25, 2002, 7:46:57 AM, you wrote to [EMAIL PROTECTED]: DY I have freebsd 4.3 , freeradius 0.5 (one proxy and one authentication) with thread enabled. DY I comment out the unnecessary modules conf from radiusd.conf. DY At the first test, three RAS boxes are configured to use RADIUS proxy server. DY The cpu consumption of Radiusd process increase to 98% cpu time after 30 mins to 1 hour. DY In top, the process is constantly RUN. DY At the second test, two RAS boxes are configured to use RADIUS proxy server. DY The result is same. DY At the third test, One RAS box is connected to the proxy server initially. DY It still work fine after overnight. Then another RAS box is connected to this RADIUS proxy server. DY The cpu consumption of Radiusd process increase to 98% cpu time after 2-3 hours. DY In top, the process is constantly RUN. DY My conclusion is version 0.5 consumed more system resources. DY But I haven't idean to it turn it. Please advise. DY Daniel DY - DY List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- ~/ZARAZA Íó à òåïåðü, Óèëüÿì, õîðîøåíüêî ïîðàçìûñëèòå íàä äàííûì ïèñüìîì. (Òâåí) - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
CPU
The freeradius 0.5 is newly installed. I changed the thread pool configuration in radiusd.conf to avoid the memory leak problem. May be I am wrongly to configuration. start_servers = 5 max_servers = 400 min_spare_servers = 3 max_spare_servers = 6 max_requests_per_server = 30 The unresponsive child can not be resolved even I set delete_blocked_request=on in radiusd.conf. I have no such problem in previous version. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: CPU
Daniel Yeung [EMAIL PROTECTED] wrote: The unresponsive child can not be resolved even I set delete_blocked_request=on in radiusd.conf. I have no such problem in previous version. Try using the latest CVS. Also, try deleting all modules you're not using from radiusd.conf. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
CPU
I have freebsd 4.3 , freeradius 0.5 (one proxy and one authentication) with thread enabled. I comment out the unnecessary modules conf from radiusd.conf. At the first test, three RAS boxes are configured to use RADIUS proxy server. The cpu consumption of Radiusd process increase to 98% cpu time after 30 mins to 1 hour. In top, the process is constantly RUN. At the second test, two RAS boxes are configured to use RADIUS proxy server. The result is same. At the third test, One RAS box is connected to the proxy server initially. It still work fine after overnight. Then another RAS box is connected to this RADIUS proxy server. The cpu consumption of Radiusd process increase to 98% cpu time after 2-3 hours. In top, the process is constantly RUN. My conclusion is version 0.5 consumed more system resources. But I haven't idean to it turn it. Please advise. Daniel - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: CPU
Sounds like a memory leak, you try a malloc debugger on it ? -aaron Daniel Yeung wrote: I have freebsd 4.3 , freeradius 0.5 (one proxy and one authentication) with thread enabled. I comment out the unnecessary modules conf from radiusd.conf. At the first test, three RAS boxes are configured to use RADIUS proxy server. The cpu consumption of Radiusd process increase to 98% cpu time after 30 mins to 1 hour. In top, the process is constantly RUN. At the second test, two RAS boxes are configured to use RADIUS proxy server. The result is same. At the third test, One RAS box is connected to the proxy server initially. It still work fine after overnight. Then another RAS box is connected to this RADIUS proxy server. The cpu consumption of Radiusd process increase to 98% cpu time after 2-3 hours. In top, the process is constantly RUN. My conclusion is version 0.5 consumed more system resources. But I haven't idean to it turn it. Please advise. Daniel - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
CPU
I run freeradius 0.5 on a linux box with threads enabled. Whenever the server receives a Duplicate request the CPU goes up till the server hangs The log show this... Tue Apr 23 13:53:58 2002 : Error: Dropping duplicate authentication packet from client 2600.rosario:1645 - ID: 219 And after thie I have to restart the dameon I searched in the mailing archive but I have not found a solution... Regards, Rodrigo Gonzalez. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
CPU
I run freeradius 0.5 on a linux box with threads enabled. Whenever the server receives a Duplicate request the CPU goes up till the server hangs The log show this... Tue Apr 23 13:53:58 2002 : Error: Dropping duplicate authentication packet from client 2600.nas:1645 - ID: 219 And after thie I have to restart the dameon I searched in the mailing archive but I have not found a solution... Regards, Rodrigo Gonzalez. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
100% CPU utilization bug in FreeRadius 2001/03/10?
I'm running FreeRadius code dated 2001/03/10 which was built using /usr/ports/net/freeradius-devel on FreeBSD 4.4. The hardware is a pretty stout Athlon 850 box and it also hosts qmail. We have less than a hundred users total. After running for about two hours on average the CPU utilization from radiusd climbs to 96%+ and just stays there. The state in 'ps aux' is RUN and lsof doesn't show us anything out of the ordinary. I don't believe there is any outside interference involved. We have two RAS boxes that authenticate via radius, the server itself, and all other connections are expressly forbidden via ipf - I know about the remote root in this program. I reviewed the last few months of the mailing list, which I don't read unless I am troubleshooting, and I don't see anything similar to my problem. I just refreshed ports via cvsup and I see that FreeRadius hasn't been updated there since the 2001/03/10 code was committed. I've brought down the latest freeradius tar file and managed to get it to build on my desktop FreeBSD-4.4STABLE but it won't build properly on the production email/radius box. Before I go off on some big adventure trying to wedge this thing into running on FreeBSD is there anything I should know? -- Neal Rauhauser CCNP, CCDP phone: 402-951-6390 http://AmericanRelay.comfax : 402-951-6390 mailto:[EMAIL PROTECTED] fcc : k0bsd - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: 100% CPU utilization bug in FreeRadius 2001/03/10?
Neal Rauhauser [EMAIL PROTECTED] wrote: I'm running FreeRadius code dated 2001/03/10 Don't even bother trying to figure out what's wrong with it. Upgrade to 0.4, it contains a *huge* number of bug fixes over that version, which is nearly a year old! I've brought down the latest freeradius tar file and managed to get it to build on my desktop FreeBSD-4.4STABLE but it won't build properly on the production email/radius box. Why not? It *should* produce error messages which tell you what went wrong, any why. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Memory and CPU utilization
Alan, Is thre any modification at exec-program-wait program files in today's snapshot ? regards, Marcelo Ferreira Canbras TVA Cabo Ltda Canbras Acesso - STA Phone: +5511-4993-8728 - Original Message - From: Marcelo Ferreira [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 24, 2002 5:23 PM Subject: Re: Memory and CPU utilization No problems.. The autentication is proxy-radius and Exec-Program-Wait I also use rlm_sql_mysql module... []s Marcelo Ferreira Canbras TVA Cabo Ltda Canbras Acesso - STA Phone: +5511-4993-8728 - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 24, 2002 4:59 PM Subject: Re: Memory and CPU utilization Marcelo Ferreira [EMAIL PROTECTED] wrote: if you could (please) send me a howto I will collect the informations for you. Sorry, the details are long, and involve a lot of trial and error. If you're not a hard-core programmer, then it will be difficult to track this problem down. I'm still surprised that it happens, though. There were a few similar bugs in older releases, but those have been fixed. How are you authenticating users? Are you using 'Exec-Program' or 'Exec-Program-Wait' at all? Which modules are you using? 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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Memory and CPU utilization
Marcelo Ferreira [EMAIL PROTECTED] wrote: Is thre any modification at exec-program-wait program files in today's snapshot ? No. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Memory and CPU utilization
Alan, I'm using the freeradius-snapshot-20020124 package. is it the right one? []s Marcelo Ferreira Canbras TVA Cabo Ltda Canbras Acesso - STA Phone: +5511-4993-8728 Pager: +5511-5188-3838 cod. 158062 www.pagenet.com.br - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 24, 2002 2:26 PM Subject: Re: Memory and CPU utilization Marcelo Ferreira [EMAIL PROTECTED] wrote: Is it normal the memory utilization of all radiusd process increased = after an authentication? If you're on Linux, each thread will show up as a seperate process. However, they will all share the same memory, so it will *look* like you have 10 processes, each using 2M of RAM. In reality, you have 1 process using 2M of RAM, and 10 threads. But yes, it *is* normal to increase memory use when an authentication request comes in. The request is cached in memory for a short time, and this increased is not beeing released. It's released after 'cleanup_delay' time. other problem is that after a period of time, the process start using = 30% or more of CPU utilization even after stoping the nas request. That's a bug, too. Upgrade to the latest CVS snapshot. It contains fixes over older versions. 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: Memory and CPU utilization
Sorry Alan, I´m not that good... if you could (please) send me a howto I will collect the informations for you. []s Marcelo Ferreira Canbras TVA Cabo Ltda Canbras Acesso - STA Phone: +5511-4993-8728 Pager: +5511-5188-3838 cod. 158062 www.pagenet.com.br - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 24, 2002 2:50 PM Subject: Re: Memory and CPU utilization I'm using the freeradius-snapshot-20020124 package. is it the right one? Yes. After I sent the last email, the process begin to increase CPU utilization... 18045 radius15 0 2148 2148 1212 R98,0 0,8 7:51 radiusd That looks like a bug. Is it possible for you to track down *why* it occurs? Is there a particular kind of packet which causes the problem? If you're familiar with gdb, you can attach to the running process, and see where it's using all of its CPU time. 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
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
