<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN">
<html><body style='font-size: 10pt; font-family: Verdana,Geneva,sans-serif'>
<p>Hi Arran,</p>
<p>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.</p>
<p>Thanks for your help.</p>
<p>Akash</p>
<p>On 2014-12-22 10:06, Akash wrote:</p>
<blockquote type="cite" style="padding-left:5px; border-left:#1010ff 2px solid; margin-left:5px"><!-- html ignored --><!-- head ignored --><!-- meta ignored -->
<p>Thanks, yes I have changed that to mysql, but still my acctstartime is showing something like: 1970-01-08 17:24:02</p>
<p>I found a line in debug output as:</p>
<p>Received Accounting-Request Id 32 from 202.52.245.173:52738 to 202.52.245.172:1813 length 182<br />(3) Service-Type = Framed-User<br />(3) Framed-Protocol = PPP<br />(3) NAS-Port = 15728643<br />(3) NAS-Port-Type = Ethernet<br />(3) User-Name = 'akash'<br />(3) Calling-Station-Id = '00:0F:38:6B:45:D4'<br />(3) Called-Station-Id = 'PPPoE_B'<br />(3) NAS-Port-Id = 'PPP'<br />(3) Acct-Session-Id = '81100003'<br />(3) Framed-IP-Address = 10.20.10.254<br />(3) Acct-Authentic = RADIUS<br /><strong>(3) Event-Timestamp = 'Jan 8 1970 17:29:02 IST'</strong><br />(3) Acct-Session-Time = 300<br />(3) Acct-Input-Octets = 64648<br />(3) Acct-Input-Gigawords = 0<br />(3) Acct-Input-Packets = 627<br />(3) Acct-Output-Octets = 611423<br />(3) Acct-Output-Gigawords = 0<br />(3) Acct-Output-Packets = 646<br />(3) Acct-Status-Type = Interim-Update<br />(3) NAS-Identifier = 'MikroTik'<br />(3) Acct-Delay-Time = 0<br />--------------------------------------</p>
<p>On 2014-12-22 09:04, Arran Cudbard-Bell wrote:</p>
<blockquote style="padding-left: 5px; border-left: #1010ff 2px solid; margin-left: 5px;"><!-- node type 8 --><!-- node type 8 --><!-- node type 8 -->
<blockquote style="padding-left: 5px; border-left: #1010ff 2px solid; margin-left: 5px;">On 21 Dec 2014, at 21:55, Akash <<a href="mailto:akash@satelinknepal.com.np">akash@satelinknepal.com.np</a>> wrote: Please check the radiusd -X output</blockquote>
<pre>You've got the query dialect set to sqlite instead of mysql.
-Arran
Arran Cudbard-Bell <<a href="mailto:a.cudbardb@freeradius.org">a.cudbardb@freeradius.org</a>>
FreeRADIUS development team
FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2
-
List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a>
</pre>
</blockquote>
<p> </p>
<div> </div>
<!-- html ignored --><br />
<pre>-
List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a>
</pre>
</blockquote>
<p> </p>
<div> </div>
</body></html>