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...