radacct and db handles

[Santiago Balaguer García]

The problem is 'Reply-Msg' attribute is not recognized by the radius server becasuse it is a specific  vendor attribute.

Try to find the specific dictionary.
 
> From: ademirk at netwizard.com.br
> To: tnt at kalik.net; freeradius-users at lists.freeradius.org
> Subject: RE: radacct and db handles
> Date: Fri, 23 Oct 2009 12:34:05 -0200
> 
> 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 at kalik.net] 
> Sent: quinta-feira, 22 de outubro de 2009 21:22
> To: ademirk at 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
> 
> 
> 
> 
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
 		 	   		  
_________________________________________________________________
Infórmate, mantente en contacto y encuéntralo todo, a la vez. Con la nueva Toolbar de MSN  nunca has tenido tantas ventajas en tan poco espacio. 
http://toolbar.es.msn.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20091027/86846141/attachment.html>