radacct and db handles

[Ademir Klauck]

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