On Feb 17, 2017, at 12:14 PM, Antonio Silva <asilva@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@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
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.