Logs from /var/log/radius/radius.log

[Fajar A. Nugraha]

On Thu, Feb 11, 2010 at 10:23 AM, muffin sk <muffinsk at 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