attribute Access-Period dont work

[Sergio Diaz]

Hello Alan,


I changed the query and reboot de server and now it Works. 

Here the query: 


sqlcounter accessperiod {

                counter-name = Max-Access-Period-Never
                check-name = Access-Period
                sqlmod-inst = sql
                key = User-Name
                reset = never
                query = "SELECT IF(COUNT(radacctid>=1),(UNIX_TIMESTAMP() - IFNULL(UNIX_TIMESTAMP(AcctStartTime),0)),0) FROM radacct WHERE UserName = '%{%k}' AND AcctSessionTime >= 1 ORDER BY AcctStartTime LIMIT 1"        
        
        }


Thanks for your help.

Saludos Cordiales,



 


 Sergio Diaz
  Infraestructura TI

  01(55) 5265.0145 
  (044) 55.28.99.95.71
  sdiazf at logitel.com.mx
  www.logitel.com.mx



-----Mensaje original-----
De: Freeradius-Users [mailto:freeradius-users-bounces+sdiazf=logitel.com.mx at lists.freeradius.org] En nombre de Sergio Diaz
Enviado el: lunes, 25 de mayo de 2015 05:16 p. m.
Para: FreeRadius users mailing list
Asunto: RE: attribute Access-Period dont work

Hello Alan

I reviewed my config and don't know where is the problem. Any idea?


Saludos Cordiales,



 


 Sergio Diaz
  Infraestructura TI

  01(55) 5265.0145 
  (044) 55.28.99.95.71
  sdiazf at logitel.com.mx
  www.logitel.com.mx



-----Mensaje original-----
De: Freeradius-Users [mailto:freeradius-users-bounces+sdiazf=logitel.com.mx at lists.freeradius.org] En nombre de Alan DeKok
Enviado el: viernes, 22 de mayo de 2015 08:13 a. m.
Para: FreeRadius users mailing list
Asunto: Re: attribute Access-Period dont work

On May 21, 2015, at 9:21 PM, Sergio Diaz <sdiazf at logitel.com.mx> wrote:

> Can you tell me which lines need to fix? Only see warnings but not errors.

  Well, fix those.

  And if you read the debug output, you'll see that the SQL query doesn't return anything.  Maybe that's an issue, too?

  Alan DeKok.


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html