On Thu, Feb 11, 2010 at 10:23 AM, muffin sk <muffi...@gmail.com> wrote: > Can you briefly explain the > meaning for each line below if that doesn't cost much of your time? I
Which part are you having trouble with? > Thu Feb 11 05:53:24 2010 : Info: rlm_sql (sql): There are no DB > handles to use! skipped 0, tried to connect 0 usually this means the db is dead, or unresponsive, such that radiusd can't find a DB handle it can use > Thu Feb 11 05:53:25 2010 : Error: WARNING: Unresponsive child (id > 1241577792) for request 123582 (in component accounting module > rlm_sql) ... which can happen if (for example) you have millions of records in radacct, with non-optimum DB settings, and insert/updating a record takes a loooooooong time. > --- > Thu Feb 11 06:26:21 2010 : Error: rlm_sql_mysql: Cannot store result > Thu Feb 11 06:26:21 2010 : Error: rlm_sql_mysql: MySQL error 'Column > 'UserName' cannot be null' > Thu Feb 11 09:03:25 2010 : Error: rlm_sql (sql): Couldn't update SQL > accounting STOP record - Column 'UserName' cannot be null As the message said : "Column 'UserName' cannot be null". What does your acct stop query look like? -- Fajar - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html