Hello, I'm using freeradius 1.1.7 with sql server 2005, the problem is that I don't find all accounting in database, freeradius doesn't send ack for all accounting tickets (it sends 300 for 4000 tickets from 10 NAS), can you tell me what is the prob? here is a part of my radiusd.conf: max_request_time = 120 max_requests = 10000 start_servers = 10 max_servers = 50 min_spare_servers = 10 max_spare_servers = 30 num_sql_socks = 40 I find these error in the radius.log : Dropping conflicting packet from client myclient1 - ID: 45 due to unfinished request 1 ..... Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 (I use 40 handles ) .... CPU use: 100 % can you help me plz? thanks in advance _____________________________________________________________________________ Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail http://mail.yahoo.fr
hi, your database is too slow to handle all the accounting in real time. hence the error messages. hence the lack of accounting either speed the DB up - and/or add more handles - or move to putting the details in in 'after real time' - eg with SQL-Relay - putting them into a file then using the sql-relay script to put them into the DB - therefore the process wont wait at the accounting stage. alan
participants (2)
-
A.Dupont -
A.L.M.Buxey＠lboro.ac.uk