radacct and db handles

[Ademir Klauck]

OK,

 

This ‘Reply-Msg’ doesn’t matter, the real issue is the db handles message.

I could solve this, by setting the db sessions like the number of NAS (45).

 

From: freeradius-users-bounces+ademirk=netwizard.com.br at lists.freeradius.org
[mailto:freeradius-users-bounces+ademirk=netwizard.com.br at lists.freeradius.o
rg] On Behalf Of Santiago Balaguer García
Sent: terça-feira, 27 de outubro de 2009 06:08
To: Lista de correo RADIUS
Subject: RE: radacct and db handles

 

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

  _____  

Todo el espacio y cuidado que merecen tus fotos digitales lo tienes en
Windows Live Fotos. ¡Pruébalo! <http://www.vivelive.com/compartirfotos/>  

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20091027/cb9beda0/attachment.html>