HI, 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. Any help would bee appreciated. Tks, Ademir
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
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
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@netwizard.com.br To: tnt@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: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
- 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/
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.br@lists.freeradius.org [mailto:freeradius-users-bounces+ademirk=netwizard.com.br@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@netwizard.com.br To: tnt@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: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
- 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/>
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
participants (4)
-
Ademir Klauck -
Alan Buxey -
Ivan Kalik -
Santiago Balaguer García