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....@lists.freeradius.org [mailto:freeradius-users-bounces+nongdung=gmail....@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" <nongd...@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.cudba...@freeradius.org> FreeRADIUS Development Team - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html