Thanks for your prompt response. Yes, convert the date format to 3 characters did help to resolve the issue but why is Radiator try to perform the convertion if the date/time format is incorrect?
On Fri, Sep 20, 2013 at 12:49 PM, Kennyen Choo <[email protected]>wrote: > Hello, > > I am using RADIATOR 4.10 on x86 linux with MySQL DB. > > I'm using Expiration attribute with format "October 20 2013 00:00:00" but > suprisingly the Radiator converted it to "1358611200" instead of the > correct value which is "1382198400". > > mysql> select from_unixtime(1358611200); > +---------------------------+ > | from_unixtime(1358611200) | > +---------------------------+ > | 2013-01-20 00:00:00 | > +---------------------------+ > > mysql> select from_unixtime(1382198400); > +---------------------------+ > | from_unixtime(1382198400) | > +---------------------------+ > | 2013-10-20 00:00:00 | > +---------------------------+ > > here's the level 4 debug log, > > Fri Sep 20 11:46:00 2013: DEBUG: Packet dump: > *** Received from xx.xx.xx.xx port 47400 .... > Code: Access-Request > Identifier: 90 > Authentic: <187>n<195><204><165>}@<151>"<163><167><207><229><27><24><198> > Attributes: > NAS-Identifier = "localdomain" > NAS-IP-Address = xx.xx.xx.xx > Message-Authenticator = > ><159>j$+<133>K<212><210><250><9><169><154><240>S<11> > Acct-Session-Id = "9649291-em1-2" > NAS-Port = 2 > NAS-Port-Type = Ethernet > Service-Type = Framed-User > Framed-Protocol = PPP > Calling-Station-Id = "f0bf975c58b2" > Called-Station-Id = "" > NAS-Port-Id = "em1" > mpd-link = "em1-2" > mpd-peer-ident = "MSRASV5.20 MSRAS-0-AGNES-VAIO > <166>Sr<140>JB<225>B<182><170><163>@<232>h<164><150>" > Tunnel-Medium-Type = 0:802 > Tunnel-Client-Endpoint = f0:bf:97:5c:58:b2 > User-Name = "[email protected]" > MS-CHAP-Challenge = <187><30>h.:<239><133><3><151><6><173>]<150> > <176><206> > MS-CHAP2-Response = > <1><0>E<134>u<238><187><172><234><30><172><253><141><205>x_<131>+<0><0><0><0><0><0><0><0><186><174><147><30>s<25>&JY<25><196>-<191><220><139><179>r<196>o{<233><193><167>l > Fri Sep 20 11:46:00 2013: DEBUG: Handling request with Handler > 'Realm=DEFAULT', Identifier '' > Fri Sep 20 11:46:00 2013: DEBUG: Deleting session for [email protected], > xx.xx.xx.xx, 2 > Fri Sep 20 11:46:00 2013: DEBUG: do query to > 'dbi:mysql:radius:xx.xx.xx.xx:3306': 'delete from ActiveSessions where > nasportid='2' and nasname='xx.xx.xx.xx'': > Fri Sep 20 11:46:00 2013: DEBUG: Handling with Radius::AuthFREERADIUSSQL: > Fri Sep 20 11:46:00 2013: DEBUG: Handling with Radius::AuthFREERADIUSSQL: > Fri Sep 20 11:46:00 2013: DEBUG: Query to > 'dbi:mysql:radius:xx.xx.xx.xx:3306': 'SELECT id, UserName, Attribute, > Value, op FROM radcheck WHERE Username=? ORDER BY id': [email protected] > Fri Sep 20 11:46:00 2013: DEBUG: Got user check row: 7323 > [email protected] xxxxxx == > Fri Sep 20 11:46:00 2013: DEBUG: Got user check row: 7325 > [email protected] October 20 2013 00:00:00 := > Fri Sep 20 11:46:00 2013: DEBUG: Query to > 'dbi:mysql:radius:xx.xx.xx.xx:3306': 'SELECT id, UserName, Attribute, > Value, op FROM radreply WHERE Username = ? ORDER BY id': [email protected] > Fri Sep 20 11:46:00 2013: DEBUG: Got user reply row: 5237 > [email protected] 10.32.0.2 := > Fri Sep 20 11:46:00 2013: DEBUG: Query to > 'dbi:mysql:radius:xx.xx.xx.xx:3306': 'SELECT > radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op > FROM radgroupcheck,radusergroup WHERE radusergroup.Username = ? AND > radusergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id': > [email protected] > Fri Sep 20 11:46:00 2013: DEBUG: Query to > 'dbi:mysql:radius:xx.xx.xx.xx:3306': 'SELECT > radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op > FROM radgroupreply,radusergroup WHERE radusergroup.Username = ? AND > radusergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id': > [email protected] > Fri Sep 20 11:46:00 2013: DEBUG: Got group reply row: 19 Prepaid Standard > Acct-Interim-Interval 60 = > Fri Sep 20 11:46:00 2013: DEBUG: Got group reply row: 21 Prepaid Standard > mpd-limit in#1=all shape 384000 += > Fri Sep 20 11:46:00 2013: DEBUG: Got group reply row: 22 Prepaid Standard > mpd-limit out#1=all shape 1024000 += > Fri Sep 20 11:46:00 2013: DEBUG: Radius::AuthFREERADIUSSQL looks for match > with [email protected] [[email protected]] > Fri Sep 20 11:46:00 2013: DEBUG: Expiration date converted to: 1358611200 > Fri Sep 20 11:46:00 2013: DEBUG: Radius::AuthFREERADIUSSQL REJECT: > Expiration date has passed: [email protected] [[email protected]] > Fri Sep 20 11:46:00 2013: DEBUG: Query to > 'dbi:mysql:radius:xx.xx.xx.xx:3306': 'SELECT id, UserName, Attribute, > Value, op FROM radcheck WHERE Username=? ORDER BY id': DEFAULT > Fri Sep 20 11:46:00 2013: DEBUG: AuthBy FREERADIUSSQL result: REJECT, > Expiration date has passed > Fri Sep 20 11:46:00 2013: INFO: Access rejected for [email protected]: > Expiration date has passed > Fri Sep 20 11:46:00 2013: DEBUG: do query to 'dbi:mysql:radius: > 192.168.66.66:3306': 'insert into radpostauth (username,reply) values(' > [email protected]','Access-Reject')': > Fri Sep 20 11:46:00 2013: DEBUG: Packet dump: > *** Sending to 210.195.155.242 port 47400 .... > Code: Access-Reject > Identifier: 90 > Authentic: h<253><25><171><164><248>|4<138>~<200><222><156><20>`<154> > Attributes: > MS-CHAP2-Success = "<1>S=DD72975DA9372B033A52115BCD039F1445C5B613" > Reply-Message = "Request Denied" > > username/password/ip addresses have been amended to protect client privacy. > > > Best Regards, > > steve >
_______________________________________________ radiator mailing list [email protected] http://www.open.com.au/mailman/listinfo/radiator
