RE: radacct and db handles
OK,
This Reply-Msg doesnt 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...@lists.freeradius.org
[mailto:freeradius-users-bounces+ademirk=netwizard.com...@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: adem...@netwizard.com.br
> To: t...@kalik.net; freeradius-users@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:t...@kalik.net]
> Sent: quinta-feira, 22 de outubro de 2009 21:22
> To: adem...@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/>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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: adem...@netwizard.com.br
> To: t...@kalik.net; freeradius-users@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:t...@kalik.net]
> Sent: quinta-feira, 22 de outubro de 2009 21:22
> To: adem...@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/-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: radacct and db handles
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:t...@kalik.net]
Sent: quinta-feira, 22 de outubro de 2009 21:22
To: adem...@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
Re: radacct and db handles
Hi, > 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. indexing speeds up queries but slows down inserts/updates. if you do live inserts/updates of accouting records into mysql then the accounting threads are goign to be blocking up the system. either fix this by moving to a better DB system - eg postgresql ;-) - or by moving to using buffered-sql virtual server for your accounting (fairly trivial...configure the buffered-sql virtual server, soft link it into sites-enabled and then change calls to 'sql' in your accounting sections of main virtual server to be 'detail'. tada! alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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
