Hi Ivan, I run Server with "radiusd -X > log" and could'n found the same error in log. The only sql fail I found is a Msg reply field: [sql] expand: SELECT id, username, attribute, value, op FROM radrepl y WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radreply WHERE usern ame = 'alexandre' ORDER BY id [sql] expand: SELECT groupname FROM radusergroup WHERE use rname = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup WHERE username = 'alexandre' ORDER BY priority [sql] expand: SELECT id, groupname, attribute, Value, op F ROM radgroupcheck WHERE groupname = '%{Sql-Group}' ORDER BY id -> SELECT id, groupname, attribute, Value, op FROM radgro upcheck WHERE groupname = 'SUSPENSO' ORDER BY id rlm_sql: Failed to create the pair: Invalid octet string "Conta Suspensa. Entre em contato com o setor financeiro." for attribute name "Reply-Msg" rlm_sql (sql): Error getting data from database [sql] Error retrieving check pairs for group SUSPENSO [sql] Error processing groups; rejecting user rlm_sql (sql): Released sql socket id: 2 ++[sql] returns fail -----Original Message----- From: Ivan Kalik [mailto:tnt@kalik.net] Sent: quinta-feira, 22 de outubro de 2009 21:22 To: ademirk@netwizard.com.br; FreeRadius users mailing list Subject: Re: radacct and db handles
I'm installed freeradius with daloradius in a FC11 box, everything new. After some corrections everything is working, but in radius.log I receive constantly the error message below: Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
I checked my radius db and radacct table and there are many indexed and nothing I could found is the problem. It only append when I enable radius accounting in SQL.
Run server in debug mode and see which queries are failing. Ivan Kalik Kalik Informatika ISP