Hi Arran,

Now I fixed the issue, the wrong datetime in acctstarttime (1970-01-08 17:24:02) was due to wrong date set in my NAS. I got both acctstarttime and acctstoptime working fine after correcting date in my NAS.

Thanks for your help.

Akash

On 2014-12-22 10:06, Akash wrote:

Thanks, yes I have changed that to mysql, but still my acctstartime is showing something like: 1970-01-08 17:24:02

I found a line in debug output as:

Received Accounting-Request Id 32 from 202.52.245.173:52738 to 202.52.245.172:1813 length 182
(3)   Service-Type = Framed-User
(3)   Framed-Protocol = PPP
(3)   NAS-Port = 15728643
(3)   NAS-Port-Type = Ethernet
(3)   User-Name = 'akash'
(3)   Calling-Station-Id = '00:0F:38:6B:45:D4'
(3)   Called-Station-Id = 'PPPoE_B'
(3)   NAS-Port-Id = 'PPP'
(3)   Acct-Session-Id = '81100003'
(3)   Framed-IP-Address = 10.20.10.254
(3)   Acct-Authentic = RADIUS
(3)   Event-Timestamp = 'Jan  8 1970 17:29:02 IST'
(3)   Acct-Session-Time = 300
(3)   Acct-Input-Octets = 64648
(3)   Acct-Input-Gigawords = 0
(3)   Acct-Input-Packets = 627
(3)   Acct-Output-Octets = 611423
(3)   Acct-Output-Gigawords = 0
(3)   Acct-Output-Packets = 646
(3)   Acct-Status-Type = Interim-Update
(3)   NAS-Identifier = 'MikroTik'
(3)   Acct-Delay-Time = 0
--------------------------------------

On 2014-12-22 09:04, Arran Cudbard-Bell wrote:

On 21 Dec 2014, at 21:55, Akash <akash@satelinknepal.com.np> wrote: Please check the radiusd -X output

You've got the query dialect set to sqlite instead of mysql.

-Arran

Arran Cudbard-Bell <a.cudbardb@freeradius.org>
FreeRADIUS development team

FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2

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

 

 

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