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


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" <[EMAIL PROTECTED]>

>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)
>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,
>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, 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
>  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
>  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
>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
>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 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?
>Fabián Franzotti
>With tax season right around the corner, make sure to follow these few
>simple tips.

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=mortgage_text_links_88_h27f6&disc=y&vers=743&s=4056&p=5117

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

Reply via email to