Hi, My freeradius work fine (freeradius in server 1 + Mysql in server 2). But i have errors in my logs(see bottom LOGS 1) and all solutions i try don't solve this. I have : -Increase the number of sql connections to 10 --> num_sql_socks = 10 -Increase the time to wait before cleaning up a reply --> cleanup_delay = 8 -Verify if the index are in the good collums(charte_valide is as custom for a php application) : Requete: EXPLAIN SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = 'ben' AND charte_valide = 'o' ORDER BY id Result : +----+-------------+----------+------+------------------------+----------+---------+-------+------+-----------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+----------+------+------------------------+----------+---------+-------+------+-----------------------------+ | 1 | SIMPLE | radcheck | ref | UserName,charte_valide | UserName | 66 | const | 1 | Using where; Using filesort | +----+-------------+----------+------+------------------------+----------+---------+-------+------+-----------------------------+
The NAS is a ISA SERVER and the students use a navigator without tab so isa server send too much querys to freeradius (see bottom LOGS 2)... And I don't see à otion in ISA server for caching the querys. What can i try more ? I have only one Nas in this time and i have used all ideas. I will add more NAs in the future so this little problem can will be a big problem... Your solutions are welcomes ! Best regards. LOGS 1: [EMAIL PROTECTED] ~]# cat /var/log/radius/radius.log | grep "DB" Wed Nov 1 15:04:59 2006 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Wed Nov 1 19:28:27 2006 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Wed Nov 1 19:28:27 2006 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Wed Nov 1 20:56:27 2006 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Wed Nov 1 20:56:27 2006 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Thu Nov 2 00:08:01 2006 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Thu Nov 2 00:08:01 2006 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Thu Nov 2 02:01:29 2006 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Thu Nov 2 09:30:32 2006 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Thu Nov 2 09:30:40 2006 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Thu Nov 2 09:30:40 2006 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Thu Nov 2 11:01:09 2006 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Thu Nov 2 11:01:09 2006 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Thu Nov 2 11:02:53 2006 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 LOGS 2 : Thu Nov 2 11:56:47 2006 : Auth: Login OK: [reda.achour] (from client isaserver2 port 1238761472) Thu Nov 2 11:56:47 2006 : Auth: Login OK: [reda.achour] (from client isaserver2 port 1238827008) Thu Nov 2 11:56:47 2006 : Auth: Login OK: [reda.achour] (from client isaserver2 port 1238919533) Thu Nov 2 11:56:47 2006 : Auth: Login OK: [reda.achour] (from client isaserver2 port 1238958080) Thu Nov 2 11:56:47 2006 : Auth: Login OK: [reda.achour] (from client isaserver2 port 1239023616) Thu Nov 2 11:56:47 2006 : Auth: Login OK: [reda.achour] (from client isaserver2 port 1239089152) Thu Nov 2 11:56:47 2006 : Auth: Login OK: [reda.achour] (from client isaserver2 port 1239154688) Thu Nov 2 11:56:47 2006 : Auth: Login OK: [reda.achour] (from client isaserver2 port 1239220224) Thu Nov 2 11:56:47 2006 : Auth: Login OK: [reda.achour] (from client isaserver2 port 1239416832) Thu Nov 2 11:56:47 2006 : Auth: Login OK: [reda.achour] (from client isaserver2 port 1239482368) Thu Nov 2 11:56:48 2006 : Auth: Login OK: [reda.achour] (from client isaserver2 port 1239678976) Thu Nov 2 11:56:48 2006 : Auth: Login OK: [reda.achour] (from client isaserver2 port 1239744512) Thu Nov 2 11:56:49 2006 : Auth: Login OK: [reda.achour] (from client isaserver2 port 1239860756) Thu Nov 2 11:56:49 2006 : Auth: Login OK: [reda.achour] (from client isaserver2 port 1239906816) Thu Nov 2 11:56:49 2006 : Auth: Login OK: [reda.achour] (from client isaserver2 port 1239941120) Thu Nov 2 11:56:49 2006 : Auth: Login OK: [reda.achour] (from client isaserver2 port 1240006656) Thu Nov 2 11:56:49 2006 : Auth: Login OK: [reda.achour] (from client isaserver2 port 1240072192) - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
