freeradius with sqlite3 solving database lock issue

[Antonio Silva]

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 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