1.Troubleshooting MySQL Connections , 2. troubleshooting possible memory leak

[Alan DeKok]

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.