Hi everyone, 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:41 2009 : Auth: rlm_opendirectory: User <vorname_nachname> is authorized. Thu Jan 29 16:10:41 2009 : Auth: Login OK: [vorname_nachname/<no User-Password attribute>] (from client Cisco 4402 port 29 cli 00-17- F2-E8-74-76) 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) Thu Jan 29 16:10:48 2009 : Info: rlm_sql_sqlite: Opening sqlite database for #0 Thu Jan 29 16:10:48 2009 : Info: rlm_sql_sqlite: sqlite3_open() = 0 Thu Jan 29 16:10:48 2009 : Error: rlm_sql (sql): failed after re- connect Thu Jan 29 16:10:48 2009 : Error: rlm_sql (sql): Couldn't update SQL accounting ALIVE record - (null) Thu Jan 29 16:13:44 2009 : Error: rlm_radutmp: Logout entry for NAS Cisco 4402 port 29 has wrong ID Thu Jan 29 16:13:44 2009 : Info: rlm_sql_sqlite: Opening sqlite database for #4 Thu Jan 29 16:13:44 2009 : Info: rlm_sql_sqlite: sqlite3_open() = 0 Thu Jan 29 16:13:44 2009 : Error: rlm_sql (sql): failed after re- connect Thu Jan 29 16:13:44 2009 : Error: rlm_sql (sql): Couldn't update SQL accounting STOP record - (null) Thu Jan 29 16:13:50 2009 : Error: rlm_radutmp: Logout entry for NAS Cisco 4402 port 29 has wrong ID Thu Jan 29 16:13:50 2009 : Info: rlm_sql_sqlite: Opening sqlite database for #3 Thu Jan 29 16:13:50 2009 : Info: rlm_sql_sqlite: sqlite3_open() = 0 Thu Jan 29 16:13:50 2009 : Error: rlm_sql (sql): failed after re- connect Thu Jan 29 16:13:50 2009 : Error: rlm_sql (sql): Couldn't update SQL accounting STOP record - (null)
Could someone please tell me what this means? What consequences does this have? What can I do to make this baby running right? Thanks Qrt
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.
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:41 2009 : Auth: rlm_opendirectory: User <vorname_nachname> is authorized. Thu Jan 29 16:10:41 2009 : Auth: Login OK: [vorname_nachname/<no User-Password attribute>] (from client Cisco 4402 port 29 cli 00-17- F2-E8-74-76) 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)
Which message can't you understand? Ivan Kalik Kalik Informatika ISP
participants (3)
-
Alan DeKok -
qrt -
tnt＠kalik.net