1 .Maybe max_connections in the MySQL config file should also be increased and Mysql be restarted. 2. No idea except upgrading. Norbert Wegener Stefan A. schrieb:
Gurus,
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 Wed Sep 24 09:40:55 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0 Wed Sep 24 09:40:56 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0 Wed Sep 24 09:40:57 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0 Wed Sep 24 09:40:58 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0 Wed Sep 24 09:41:01 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0 Wed Sep 24 09:48:00 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0 Wed Sep 24 09:48:01 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0 Wed Sep 24 09:48:02 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0 Wed Sep 24 09:48:03 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0 Wed Sep 24 09:48:04 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0 Wed Sep 24 09:49:37 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0 Wed Sep 24 09:49:38 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0 Wed Sep 24 09:51:39 2008 : Info: rlm_sql (sql_accounting): There are no DB handles to use! skipped 0, tried to connect 0
I thougt, giving the system more DB connections and lowering the retry delay should help. It did, and I now get only about 50% of the errors. But what would be a reasonable value for this?
'sql_accounting' is configured: sql sql_accounting{ database = "mysql" driver = "rlm_sql_${database}" server = "db-master" port="3306" login = "yyyyy" password = "xxxxx" radius_db = "radius_te" acct_table1 = "radacct" acct_table2 = "radacct" postauth_table = "radpostauth" authcheck_table = "radcheck" authreply_table = "radreply" groupcheck_table = "radgroupcheck" groupreply_table = "radgroupreply" usergroup_table = "radusergroup" deletestalesessions = yes sqltrace = yes sqltracefile = ${logdir}/sqltrace.sql num_sql_socks = 8 connect_failure_retry_delay = 30 #readclients = yes nas_table = "nas" $INCLUDE sql/${database}/dialup.conf }
An other issue: 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. I configured the option to die a server after 500 packets, but this does not help for me. Do I have to restart the server from time to time? How may I troubleshoot this?
May I unconfigure radutmp? I think I do not need this. Do I really need the sqltrace-file? How my I unconfigure it? Just deleting the config line
My system runs FR 2.0.5 on Solaris 10 using MySQL 5.0.51a
Any Ideas?
Thank You. Regards Stefan
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html