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