(no subject)

[benodilo at free.fr]

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:


[root at fedora ~]# 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)