Re: Opertors Problems

15 Mar 2007


      Ok, Thanks, I confused something, because it was working and i don't have 
any external program, but now I will try to do one, Again Thanks Verry Verry 
Much

Fabián
...
From: <tnt@kalik.co.yu>
Reply-To: FreeRadius users mailing list 
<freeradius-users@lists.freeradius.org>
To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org>
Subject: Re: Opertors Problems
Date: Thu, 15 Mar 2007 21:49:37 +0100
Operator works as expected.
***
Attribute += Value
Always matches as a check item, and adds the current attribute with value
to the list of configuration items.
As a reply item, it has an identical meaning, but the attribute is added
to the reply items.
***
It adds attribute to the list not add up values. You are probably mixing
it up with computer programming operator += which adds up that way.
Ivan Kalik
Kalik Informatika ISP
Dana 15/3/2007, "Internet-Wifi Operador" <internet-wifi@hotmail.com>
pi¹e:
...
I have
in radgroupcheck
GroupName   Attribute                       op  Value
14 days        Session-Terminate           :=  1209600   (Time for 14 
days
from first connection)
in usergroup
GroupName      UserName
14 days            aaa
in radcheck
UserName      Attribute                   op  Value
aaa               UserPassword             == pepe
aaa               Session-Terminate       += 86400   (Time for 1 day to 
Add
to Session-Terminate)
@radiusd.conf
modules {
         ............
         sqlcounter sessionterminate {
                       counter-name = Session-Limit-Time
                       check-name = Session-Terminate
                       reply-name = Session-Timeout
                       sqlmod-inst = sql
                       key = User-Name
                       reset = never
                       query = "SELECT IF (UNIX_TIMESTAMP((SELECT
MIN(AcctStartTime)  FROM radacct WHERE UserName='%{%k}'))>0,
UNIX_TIMESTAMP() - UNIX_TIMESTAMP((SELECT MIN(AcctStartTime) FROM radacct
WHERE UserName='%{%k}'))),0)"
        }
        ...........
}
instantiate {
               .....
               sessionterminate
              ......
}
authorize {
             ..........
             sql
             sessionterminate
             .........
}
Ok, when send the authentication request, everything work fine but
in reply Session-Timeout = 86400 so the radius overwrite the value not 
add.
rad_recv: Access-Request packet from host 172.16.0.3:2353, id=115, 
length=44
  User-Name = "aaa1"
  User-Password = "pepe"
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql_mysql: query:  SELECT id, UserName, Attribute, Value, op
FROM radcheck           WHERE Username = 'aaa1'           ORDER BY id
rlm_sql_mysql: query:  SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op
 FROM radgroupcheck,usergroup WHERE usergroup.Username = 'aaa1' AND
usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id
rlm_sql_mysql: query:  SELECT id, UserName, Attribute, Value, op
FROM radreply           WHERE Username = 'aaa1'           ORDER BY id
rlm_sql_mysql: query:  SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op
 FROM radgroupreply,usergroup WHERE usergroup.Username = 'aaa1' AND
usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id
rlm_sql (sql): Released sql socket id: 4
radius_xlat: Running registered xlat function of module sql for string
'SELECT IF(UNIX_TIMESTAMP((SELECT MIN(AcctStartTime) FROM radacct WHERE
UserName='aaa1'))>0,(UNIX_TIMESTAMP()-UNIX_TIMESTAMP((SELECT
MIN(AcctStartTime) FROM radacct WHERE UserName='aaa1'))),0)'
rlm_sql (sql): - sql_xlat
rlm_sql (sql): Reserving sql socket id: 3
rlm_sql_mysql: query:  SELECT IF(UNIX_TIMESTAMP((SELECT 
MIN(AcctStartTime)
FROM radacct WHERE
UserName='aaa1'))>0,(UNIX_TIMESTAMP()-UNIX_TIMESTAMP((SELECT
MIN(AcctStartTime) FROM radacct WHERE UserName='aaa1'))),0)
rlm_sql (sql): - sql_xlat finished
rlm_sql (sql): Released sql socket id: 3
rlm_sql (sql): Reserving sql socket id: 2
rlm_sql_mysql: query:  SELECT COUNT(*) FROM radacct WHERE UserName='aaa1'
AND AcctStopTime = 0
rlm_sql (sql): Released sql socket id: 2
rlm_sql (sql): Processing sql_postauth
rlm_sql (sql): Reserving sql socket id: 1
rlm_sql_mysql: query:  INSERT into radpostauth (id, user, pass, reply, 
date)
values ('', 'aaa1', 'pepe', 'Access-Accept', NOW())
rlm_sql (sql): Released sql socket id: 1
Sending Access-Accept of id 115 to 172.16.0.3 port 2353
  Reply-Message += "Hola  aaa1\\r\\n"
  WISPr-Bandwidth-Max-Down := 200000
  WISPr-Bandwidth-Max-Up := 20000
  Acct-Interim-Interval := 120
  Idle-Timeout := 390
  Session-Timeout = 86400
I did that before with freeradius 1.0.2 but stop to work and I don't know
why. I install the new freeradius 1.1.5, Wow is to better and more easy, 
but
my problem continue, I guess I forget something, please if someone have 
any
idea why the operators doesn't work. Can help me?
Thanks.
Fabián Franzotti
_________________________________________________________________
With tax season right around the corner, make sure to follow these few
simple tips.
http://articles.moneycentral.msn.com/Taxes/PreparationTips/PreparationTips.a...
-
List info/subscribe/unsubscribe? See 
http://www.freeradius.org/list/users.html
_________________________________________________________________
Mortgage rates as low as 4.625% - Refinance $150,000 loan for $579 a month. 
Intro*Terms  
https://www2.nextag.com/goto.jsp?product=100000035&url=%2fst.jsp&tm=y&search...