rlm_sql errors

[Alan DeKok]

qrt wrote:
> I use freeradius  (FreeRADIUS Version 1.1.4, with security changes
> through 1.1.7, for host apple.com, built on Sep 23 2007 at 22:52:08) on
> Mac OS X Server 10.5.6.
> 
> My problem is that I get messages that I do not understand in the log file
> It looks like this:
...
>> /Thu Jan 29 16:10:42 2009 : Info: rlm_sql_sqlite: Opening sqlite
>> database for #1/
>> /Thu Jan 29 16:10:42 2009 : Info: rlm_sql_sqlite: sqlite3_open() = 0 /
>> /Thu Jan 29 16:10:42 2009 : Error: rlm_sql (sql): failed after re-connect/
>> /Thu Jan 29 16:10:42 2009 : Error: rlm_sql (sql): Couldn't update SQL
>> accounting ALIVE record - (null)/

  You have configured "sql" in the "accounting" section.  Don't do that.
 The sqlite driver included by Apple doesn't support accounting packets.

> Could someone please tell me what this means?
> What consequences does this have?
> What can I do to make this baby running right?

  Don't use sqlite as a database for accounting.  There is *no*
documentation that says it can be used for accounting... because it
can't be used for accounting.

  Alan DeKok.