Re: freeradius with sqlite3 solving database lock issue

17 Feb 2017


      forget to point my version... FreeRADIUS Version 3.0.12

On 02/17/2017 06:14 PM, Antonio Silva wrote:
...
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@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@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