RE: Freeradius2 and sqlite

1 Sep 2013

      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@lists.freeradius.org
[mailto:freeradius-users-bounces+nongdung=gmail.com@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@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@freeradius.org> FreeRADIUS Development Team

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