SQLite sql: ERROR: Hit reconnection limit

[Carlito Nueno]

Hi Alan,

Only FreeRADIUS is reading and writing to the database. Do you think,
FreeRADIUS is not able to connect to SQL database since it's outside the
container. I am doing this to expose host db file to FR container:
Dockerfile:
VOLUME /opt/db/

Running container by:
docker run --name radiustest -p 1813:1813/udp -p 1812:1812/udp -v
/home/cn/radius/db:/opt/db -t -d baseradius -X

Thanks

On Thu, Jan 17, 2019 at 7:42 PM Alan DeKok <aland at deployingradius.com>
wrote:

> On Jan 17, 2019, at 10:32 PM, Carlito Nueno <carlitonueno at gmail.com>
> wrote:
> > I am running FreeRadius in a docker container and am sharing radius.db
> file
> > from the host (outside the container) with FreeRadius inside the
> container.
> > The database file is located and accessed by FreeRadius from
> > "/opt/db/radius.db". I am also trying to use tunnel-password.
>
>   sqlite is an embedded database.  It can only have one writer at a time.
>
>   If you want multiple writers to the same SQL database, use a database
> which supports multiple writers.
>
> > (0) sql: ERROR: Hit reconnection limit
>
>   That error is from FreeRADIUS.  It tries multiple times to write the
> data to SQL.  If FreeRADIUS can't connect to the SQL database after
> multiple retries, it prints that message.
>
>   Use a database that supports multiple writers.  Or, if you need to use
> sqlite, ensure that only FreeRADIUS is using the DB.
>
>   Alan DeKok.
>
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html