<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
The problem is 'Reply-Msg' attribute is not recognized by the radius server becasuse it is a specific vendor attribute.<BR>
Try to find the specific dictionary.<BR> <BR>> From: ademirk@netwizard.com.br<BR>> To: tnt@kalik.net; freeradius-users@lists.freeradius.org<BR>> Subject: RE: radacct and db handles<BR>> Date: Fri, 23 Oct 2009 12:34:05 -0200<BR>> <BR>> Hi Ivan,<BR>> <BR>> 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:<BR>> <BR>> [sql] expand: SELECT id, username, attribute, value, op FROM radrepl<BR>> y WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT<BR>> id, username, attribute, value, op FROM radreply WHERE usern<BR>> ame = 'alexandre' ORDER BY id<BR>> [sql] expand: SELECT groupname FROM radusergroup WHERE use<BR>> rname = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname<BR>> FROM radusergroup WHERE username = 'alexandre' ORDER BY<BR>> priority<BR>> [sql] expand: SELECT id, groupname, attribute, Value, op F<BR>> ROM radgroupcheck WHERE groupname = '%{Sql-Group}' ORDER BY<BR>> id -> SELECT id, groupname, attribute, Value, op FROM radgro<BR>> upcheck WHERE groupname = 'SUSPENSO' ORDER BY id<BR>> rlm_sql: Failed to create the pair: Invalid octet string "Conta Suspensa. Entre<BR>> em contato com o setor financeiro." for attribute name "Reply-Msg"<BR>> rlm_sql (sql): Error getting data from database<BR>> [sql] Error retrieving check pairs for group SUSPENSO<BR>> [sql] Error processing groups; rejecting user<BR>> rlm_sql (sql): Released sql socket id: 2<BR>> ++[sql] returns fail<BR>> <BR>> -----Original Message-----<BR>> From: Ivan Kalik [mailto:tnt@kalik.net] <BR>> Sent: quinta-feira, 22 de outubro de 2009 21:22<BR>> To: ademirk@netwizard.com.br; FreeRadius users mailing list<BR>> Subject: Re: radacct and db handles<BR>> <BR>> > I'm installed freeradius with daloradius in a FC11 box, everything new.<BR>> > After some corrections everything is working, but in radius.log I receive<BR>> > constantly the error message below:<BR>> > Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to<BR>> > connect 0<BR>> ><BR>> > I checked my radius db and radacct table and there are many indexed and<BR>> > nothing I could found is the problem. It only append when I enable radius<BR>> > accounting in SQL.<BR>> <BR>> Run server in debug mode and see which queries are failing.<BR>> <BR>> Ivan Kalik<BR>> Kalik Informatika ISP<BR>> <BR>> <BR>> <BR>> <BR>> -<BR>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html<BR> <br /><hr />Todo el espacio y cuidado que merecen tus fotos digitales lo tienes en Windows Live Fotos. <a href='http://www.vivelive.com/compartirfotos/' target='_new'>¡Pruébalo! </a></body>
</html>