Hi all, @Alan: yes, I do have indexes. I still have the following issue: Fri Oct 24 18:21:33 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0 Fri Oct 24 18:21:34 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0 Fri Oct 24 18:21:35 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0 Fri Oct 24 18:21:36 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0 Fri Oct 24 18:21:37 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0 Fri Oct 24 18:21:39 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0 Fri Oct 24 18:21:42 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0 Fri Oct 24 18:21:57 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0 Fri Oct 24 18:21:58 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0 Fri Oct 24 18:21:59 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0 Fri Oct 24 18:22:00 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0 Fri Oct 24 18:22:01 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0 Fri Oct 24 18:22:02 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0 Fri Oct 24 18:22:03 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0 Fri Oct 24 18:22:04 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0 Fri Oct 24 18:22:05 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0 Fri Oct 24 18:22:07 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tri While my server seems to be OK. last pid: 18091; load avg: 0.22, 0.21, 0.23; up 44+02:44:36 18:22:33 82 processes: 81 sleeping, 1 on cpu CPU states: 96.2% idle, 2.4% user, 1.4% kernel, 0.0% iowait, 0.0% swap Memory: 8192M phys mem, 5979M free mem, 518M total swap, 518M free swap PID USERNAME LWP PRI NICE SIZE RES STATE TIME CPU COMMAND 26627 mysql 59 59 0 585M 572M sleep 499.5H 2.29% mysqld 12576 root 1 54 0 15M 12M sleep 437:52 0.57% perl 11522 root 26 59 0 33M 29M sleep 0:27 0.32% radiusd 12574 root 1 59 0 14M 11M sleep 530:58 0.04% perl It handles about 100 Interim updates per second, but my client detects something about 1000 losses per day. Where exactly does the logfile message poit to? To me it says: I did not try and therefore I did not skip anything.... While the server is workung like this, I'm able to do randamly update about 600 additional sets/s, using the statemants from dialup.conf in a perl script.... I'm afraid to check more, because it is live traffic. So I'm not sure, if it must be the database. Can set up a more detailed debug on this section? '-X' literally stops my service... Even that the log entry is marked as 'info', I'd like to understand, what's going on. Thank You. Stefan
-----Original Message----- From: freeradius-users-bounces+a.freeradius=premit.de@lists.freeradi us.org [mailto:freeradius-users-bounces+a.freeradius=premit.de@lists. freeradius.org] On Behalf Of Alan DeKok Sent: Wednesday, September 24, 2008 11:47 AM To: FreeRadius users mailing list Subject: Re: 1.Troubleshooting MySQL Connections , 2. troubleshooting possiblememory leak
Stefan A. wrote:
in my radiusd.log, I can see lots of these errors: Wed Sep 24 09:40:54 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0
Your database is probably slow. Do you have indexes?
FR is eating Memory and I do not know how to troubleshoot this. It takes about 1 MB/ Minute which was about 3.5 GB over some Days, before we rcognized this.
There were issues with older versions of the server, but 2.1.0 should be fine.
I configured the option to die a server after 500 packets, but this does not help for me.
Because it stops the *thread*, not the *server*. And all threads use the same shared memory file.
May I unconfigure radutmp? I think I do not need this.
Delete all references to it from the configuration file.
Do I really need the sqltrace-file? How my I unconfigure it? Just deleting the config line
Yes.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html