Freeradius2 and sqlite

[Nong NgocDung]

Dear Arran,

Finally, I could connect freeradius2 to sqlite on OpenWrt, but the config
item "filename" does not affect:
sql {
	database = 'sqlite'

	filename = '<path to sqlite file>'
}

It always connects to a sqlite database with the name of
"sqlite_radius_client_database" under /etc/freeradius2 folder.
Do you know how to customize this database file? For example, If I want
connect to myproject.db


Thank you,
NgocDung Nong

-----Original Message-----
From: freeradius-users-bounces+nongdung=gmail.com at lists.freeradius.org
[mailto:freeradius-users-bounces+nongdung=gmail.com at lists.freeradius.org] On
Behalf Of Arran Cudbard-Bell
Sent: Saturday, August 31, 2013 10:28 PM
To: FreeRadius users mailing list
Subject: Re: Freeradius2 and sqlite


On 31 Aug 2013, at 16:10, "Nong NgocDung" <nongdung at gmail.com> wrote:

> Hi Arran,
> 
> In sql.conf as follow:
> 
> ------------------------------------------------------------
> sql {
>        #
>        #  Set the database to one of:
>        #
>        #       mysql, mssql, oracle, postgresql
>        #
>        database = "mysql"
> 
>        #
>        #  Which FreeRADIUS driver to use.
>        #
>        driver = "rlm_sql_${database}"
> 
>        # Connection info:
>        server = "localhost"
> .....................
> }
> ----------------------------------------------------------------
> 
> 
> Where should I declare the connection to sqlite file?

With the 'filename' config item, and you need to set database to 'sqlite'

sql {
	database = 'sqlite'

	filename = '<path to sqlite file>'
}

It's done properly in 3.0. It's sort of hacked into 2.x.x.

Arran Cudbard-Bell <a.cudbardb at freeradius.org> FreeRADIUS Development Team

-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html