freeradius with sqlite3 solving database lock issue

[Alan DeKok]

On Feb 17, 2017, at 12:14 PM, Antonio Silva <asilva at wirelessmundi.com> wrote:
> What are the best options to configure sqlite3 sql with freeradius?

  It should just work.

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

  The issue there is that sqlite can only have one writer at a time.  So if you want multiple writers... you really need to use a different database.

> 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

  I think that was fixed in the v3.0.x branch.  Please try that:

https://github.com/FreeRADIUS/freeradius-server/archive/v3.0.x.zip

  Alan DeKok.