<html><body><div style="color:#000; background-color:#fff; font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:10pt"><div style="font-family: Courier New, courier, monaco, monospace, sans-serif; font-size: 10pt;"><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"><span>Hi Fajar, I Couldn't solve the problem yet... but I ran the Radius in debug mode, and I tried to disconnect my connection to see what are happening, as I couldn't find, I'll post it here. <br></span><div id="yiv1037353948"><div><div style="color:#000;background-color:#fff;font-family:times new roman, new york, times, serif;font-size:12pt;"><div><br><span></span></div><div><span>Thanks for the help.</span></div><div><br><span></span></div><div style="font-family:Courier New, courier, monaco, monospace, sans-serif;"><font size="2"><span>rad_recv: Accounting-Request packet from host XXX.XX.X.XXX:37121, id=232,
length=268<br> Service-Type = Framed-User<br> Framed-Protocol = PPP<br> NAS-Port = 115296<br> NAS-Port-Type = Ethernet<br> User-Name =
"email@domain.com.br"<br> Calling-Station-Id = "00:15:6D:E6:94:DB"<br> Called-Station-Id = "pppoe-wip2"<br> NAS-Port-Id = "WIP2"<br> MS-CHAP-Domain = "domain.com.br"<br> Acct-Session-Id = "81514b64"<br> Framed-IP-Address = xxx.xx.X.XX<br> Acct-Authentic = RADIUS<br> Event-Timestamp = "Feb 17 2012 13:44:23 BRST"<br> Acct-Session-Time = 79376<br> Acct-Input-Octets = 158226957<br> Acct-Input-Gigawords = 0<br> Acct-Input-Packets =
1112930<br> Acct-Output-Octets = 854637707<br> Acct-Output-Gigawords = 0<br> Acct-Output-Packets = 1115931<br> Acct-Status-Type = Stop<br> Acct-Terminate-Cause = NAS-Request<br> NAS-Identifier = "PPPoE-AND WIP2"<br> Acct-Delay-Time = 0<br> Mikrotik-Realm = "domain.com.br"<br> NAS-IP-Address = xxx.xx.x.xx</span></font></div><div style="font-family:Courier New, courier, monaco, monospace, sans-serif;"><font size="2">Processing the preacct section of radiusd.conf<br>modcall: entering group preacct for request 43<br> modcall[preacct]: module "preprocess" returns noop for request
43<br>rlm_acct_unique: Hashing 'NAS-Port = 115296,Client-IP-Address = xxx.xx.x.xx,NAS-IP-Address = xxx.xx.x.xxx,Acct-Session-Id = "81514b64",User-Name = "email@domain.com.br"'<br>rlm_acct_unique: Acct-Unique-Session-ID = "4bc00ddcf558a324".<br> modcall[preacct]: module "acct_unique" returns ok for request 43<br> rlm_realm: Looking up realm "domain.com.br" for User-Name = "email@domain.com.br"<br> rlm_realm: No such realm "domain.com.br"<br> modcall[preacct]: module "suffix" returns noop for request 43<br> modcall[preacct]: module "files" returns noop for request 43<br>modcall: leaving group preacct (returns ok) for request 43<br> Processing the accounting section of radiusd.conf<br>modcall: entering group accounting for request 43<br>radius_xlat: '/var/log/radacct/xxx.xx.x.xx/detail-20120217'<br>rlm_detail: /var/log/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to
/var/log/radacct/xxx.xx.x.xx/detail-20120217<br> modcall[accounting]: module "detail" returns ok for request 43<br> modcall[accounting]: module "unix" returns fail for request 43<br>modcall: leaving group accounting (returns fail) for request 43<br>Finished request 43<br>Going to the next request</font></div><div><br></div><div><br></div><div>And the sqltrace, the only information with acct-stop-time is this:</div><div style="font-family:Courier New, courier, monaco, monospace, sans-serif;"><font size="2"><br></font></div><div style="font-family:Courier New, courier, monaco, monospace, sans-serif;"><font size="2">UPDATE <br> radacct <br>SET <br> AcctStopTime='2012-02-10 17:43:19', <br> AcctSessionTime=unix_timestamp('2012-02-10 17:43:19') - unix_timestamp(AcctStartTime), <br> AcctTerminateCause='', <br> AcctStopDelay = '0' <br>WHERE
<br>
AcctSessionTime=0 <br>AND <br> AcctStopTime=0 <br>AND <br> NASIPAddress= 'xxx.xx.x.xx' <br>AND <br> AcctStartTime <= '2012-02-10 17:43:19';<br></font></div><div><br></div><div><br></div><div>both were not collected from the same time.<br><span></span></div><div><br><span></span></div><div><br><span></span></div><div><span><br></span></div><div><br></div> <div style="font-family:times new roman, new york, times, serif;font-size:12pt;"> <div style="font-family:times new roman, new york, times, serif;font-size:12pt;"> <div dir="ltr"> <font face="Arial" size="2"> <hr size="1"> <b><span style="font-weight:bold;">De:</span></b> Fajar A. Nugraha <list@fajar.net><br> <b><span style="font-weight:bold;">Para:</span></b> Rodrigo Yoshioka <ro_yoshioka2002@yahoo.com.br>; FreeRadius users mailing list <freeradius-users@lists.freeradius.org> <br> <b><span style="
font-weight:bold;">Enviadas:</span></b> Terįa-feira, 7 de Fevereiro de 2012 14:00<br> <b><span style="font-weight:bold;">Assunto:</span></b> Re: Freeradius doesn't record acct-stop-time.<br> </font> </div> <br>On Tue, Feb 7, 2012 at 10:48 PM, Rodrigo Yoshioka<br><<a rel="nofollow" ymailto="mailto:ro_yoshioka2002@yahoo.com.br" target="_blank" href="mailto:ro_yoshioka2002@yahoo.com.br">ro_yoshioka2002@yahoo.com.br</a>> wrote:<br>> Hi...<br>><br>> My freeradius are recording in mysql all sessions about start connection,<br>> but it didnīt finish it. when a device is logged out it remain connected at<br>> mysql, doing my proprietary CRM mistake to return connection data.<br>><br>> Checking detailed log, its registering start connection and stop connection,<br>> the problem is just in mysql... It is probably a configuration that I should<br>> enable, but I donīt know wich. Can anyone help me.?<br><br>Did it suddenly stopped
working, or did it never worked at
all?<br><br>Enabling sql in accounting section should handle accounting packets.<br>If you're having problems, running it in debug mode (or enabling<br>sqltrace) might help you find out what queries are being executed, and<br>why they fail (if that's indeed the cause).<br><br>-- <br>Fajar<br><br><br> </div> </div> </div></div></div><br><br> </div> </div> </div></body></html>