Hi,<div><br></div><div>We have a problem with duplicate sessions on our MikroTik wireless network with FreeRADIUS when OSPF kicks in:</div><div><br></div><div><span class="Apple-style-span" style="font-size: 13px; line-height: 18px; -webkit-border-horizontal-spacing: 5px; -webkit-border-vertical-spacing: 5px; "><font class="Apple-style-span" face="'courier new', monospace">Subscription Analysis for user@isp<br style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
2010-01-17 up to 2010-01-25<br style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "># logged in session time upload download server terminate cause callerid<br style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
1 2010-01-23 22:07:31 15 hours 6.9 MB 83.6 MB <b>192.168.199.254</b>:513 - 00:0B:6B:DB:A9:96<br style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
2 2010-01-22 22:07:30 18 hours 16.2 MB 451.1 MB <b>192.168.208.1</b>:434 - 00:0B:6B:DB:A9:96<br style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
3 2010-01-22 22:07:29 1 days 27.0 MB 0.6 GB <a href="http://192.168.199.254:434">192.168.199.254:434</a> Session-Timeout 00:0B:6B:DB:A9:96<br style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
4 2010-01-21 22:07:27 1 days 4.7 MB 65.0 MB <a href="http://192.168.199.254:386">192.168.199.254:386</a> Session-Timeout 00:0B:6B:DB:A9:96<br style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
5 2010-01-20 22:07:25 1 days 2.9 MB 45.7 MB <a href="http://192.168.199.254:331">192.168.199.254:331</a> Session-Timeout 00:0B:6B:DB:A9:96<br style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
6 2010-01-19 22:07:23 2 hours 171.3 KB 1.4 MB <a href="http://192.168.208.1:290">192.168.208.1:290</a> - 00:0B:6B:DB:A9:96<br style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
7 2010-01-19 22:07:23 1 days 2.9 MB 24.5 MB <a href="http://192.168.199.254:290">192.168.199.254:290</a> Session-Timeout 00:0B:6B:DB:A9:96<br style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
8 2010-01-18 22:07:20 1 days, 1 seconds 3.8 MB 66.2 MB <a href="http://192.168.199.254:207">192.168.199.254:207</a> Session-Timeout 00:0B:6B:DB:A9:96<br style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
9 2010-01-17 22:07:15 1 days 1.5 MB 10.0 MB <a href="http://192.168.199.254:166">192.168.199.254:166</a> Session-Timeout 00:0B:6B:DB:A9:96<br style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
10 2010-01-17 22:07:15 0 seconds 0.0 KB 0.0 KB <a href="http://192.168.208.1:166">192.168.208.1:166</a> - 00:0B:6B:DB:A9:96</font></span><br clear="all"><br></div><div>High site 1 is 192.168.199.254 and high site 2 is 192.168.208.1. As you can see it looks like FreeRADIUS counts the extra data on the dropped connection as well.</div>
<div><br></div><div>The only suggestion I have received so far is to use a product called SMRadius (<a href="http://www.smradius.org/tiki-index.php?page=Features">http://www.smradius.org/tiki-index.php?page=Features</a>) that apparently merges duplicate sessions.</div>
<div><br></div><div>But my FreeRadius installation is 7 years old and I don't want to change to another product.</div><div><br></div><div>We are using FreeRADIUS Version 1.1.7, for host x86_64-pc-linux-gnu (Ubuntu 8.04 64-bit).</div>
<div>mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (x86_64) using readline 5.2</div><div><br></div><div>Apart from that we have a pretty stock standard default installation.</div><div><br></div><div>I have heard about some other people with large MikroTik networks and OSPF and FreeRADIUS that they are having the same problem. I have also described this problem on the MikroTik forum: <a href="http://forum.mikrotik.com/viewtopic.php?f=2&t=38620">http://forum.mikrotik.com/viewtopic.php?f=2&t=38620</a></div>
<div><br></div><div>please assist urgently, this problem is leading to some difficult client service inquiries.</div><div>--------<br>Eugene van der Merwe<br>
</div>