freeradius with sqlite3 solving database lock issue

[Antonio Silva]

Alan, thanks for the reply.

i'll try that version.

As for the option to have only one writer, i tried that by  changing the 
sql pool definition to start=min=max=1.... but i didn't change the 
thread pool... so i should set the thread pool to 1 as well?


Regards,
António

On 02/17/2017 07:12 PM, Alan DeKok wrote:
> 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.
>
>
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html