freeradius with sqlite3 solving database lock issue

[Antonio Silva]

Hi,

What are the best options to configure sqlite3 sql with freeradius?

i'm having some lock errors followed by  "ERROR: Hit reconnection limit"

I tried to set the pool to only 1 server, since its a file db, but them 
i got the error "max connections2 when connecting two users at the same 
time.


Right now i use:
....
thread pool {
     start_servers = 5
     max_servers = 25
     min_spare_servers = 3
     max_spare_servers = 10
     max_requests_per_server = 1024
     auto_limit_acct = yes
}


sql {
     driver = "rlm_sql_sqlite"
     sqlite {
         filename = "radius.db"
         busy_timeout = 200
     }
     dialect = "sqlite"
     delete_stale_sessions = yes
     pool {
         start = ${thread[pool].start_servers}
         min = ${thread[pool].min_spare_servers}
         max = ${thread[pool].max_servers}
         spare = ${thread[pool].max_spare_servers}
         uses = 0
         retry_delay = 30
         lifetime = 0
         idle_timeout = 60
     }
...


The errors  are:

Feb 12 17:41:08 PC radiusd[18187]: (2038) Login OK: 
[402 at cm.com/<CHAP-Password>] (from client nas01 port 17 cli 
30-10-E4-66-1A-CF)
Feb 12 17:41:58 PC radiusd[18187]: (2042)     ERROR: Error fetching row
Feb 12 17:41:58 PC radiusd[18187]: (2042)     ERROR: rlm_sql_sqlite: 
database is locked
Feb 12 17:41:58 PC radiusd[18187]: (2042)     ERROR: SQL query failed: 
server error
Feb 12 17:41:58 PC radiusd[18187]: (2041) Login OK: 
[402 at cm.com/<CHAP-Password>] (from client nas01 port 14 cli 
F4-37-B7-E0-66-DF)
Feb 12 17:41:59 PC radiusd[18187]: (2042) sql: ERROR: Error fetching row
Feb 12 17:41:59 PC radiusd[18187]: (2042) sql: ERROR: rlm_sql_sqlite: 
database is locked
...
Feb 12 17:56:39 PC radiusd[18187]: (2125) sql: ERROR: Hit reconnection limit


You can check the entire log in http://pastebin.com/fXuZVU93


Thanks,

-- 

Saludos / Regards / Cumprimentos,
António silva