<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<meta content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
@font-face
{font-family:Consolas}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
pre
{margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New"}
p.msonormal0, li.msonormal0, div.msonormal0
{margin-right:0in;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif}
span.EmailStyle18
{font-family:"Calibri",sans-serif;
color:#1F497D}
span.HTMLPreformattedChar
{font-family:Consolas}
span.EmailStyle21
{font-family:"Calibri",sans-serif;
color:#1F497D}
.MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:70.85pt 56.7pt 56.7pt 56.7pt}
div.WordSection1
{}
-->
</style>
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div id="nine_body_n183662-a5869" class="nine_body" dir="auto" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12.0pt; line-height:1.3; color:#1F497D">
<div class="nine-pg" dir="auto">Scusa no non va bene.</div>
<div class="nine-pg" dir="auto">Lo start ti arriva dopo...</div>
<div class="nine-pg" dir="auto"><br>
</div>
<div class="nine-pg blank sign" dir="auto"><br>
</div>
<div id="nine-sign-n183662-a5869" class="nine_signature" dir="auto">
<div class="nine-pg" dir="auto">Sent from <a href="http://www.9folders.com/" style="text-decoration:none; color:#009BDF">
Nine</a></div>
</div>
</div>
<div class="quoted_output_body">
<div id="quoted_header_n183662-a5869" class="quoted_header_editor fold" dir="auto">
<hr style="border:none; height:1px; color:#E1E1E1; background-color:#E1E1E1">
<div dir="auto" style="border:none; padding:3.0pt 0cm 0cm 0cm"><span style="font-size:11.0pt; font-family:Calibri,Arial,Helvetica,sans-serif"><b>Da:</b> Brian Turnbow via itnog <itnog@lists.itnog.it><br>
<b>Inviato:</b> giovedì 22 settembre 2022 19:03<br>
<b>A:</b> Matteo Sgalaberni<br>
<b>Cc:</b> itnog<br>
<b>Oggetto:</b> Re: [ITNOG] sqlippool freeradius<br>
</span></div>
</div>
<br type="attribution">
</div>
<div>
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">Ciao Matteo,</span><span style="color:black"></span></p>
<p class="MsoNormal"><span lang="IT" style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">Ma sei sicuro che sono in “inverse order”?
</span><span style="color:black"></span></p>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Arial",sans-serif; color:black">Ciao Brian!</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Arial",sans-serif; color:black"> </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Arial",sans-serif; color:black">Sì sono sicuro. Per ordine inverso intendo che arriva prima lo start della nuova connessione e poi lo stop della vecchia. L'ho osservato, fatto debug lato radius
e dump traffico di rete. Si tratta di millisecondi ma si genera questo effetto:</span></p>
</div>
<div>
<pre style="white-space:pre-wrap; orphans:2; text-align:start; widows:2; word-spacing:0px"><span style="color:black">1) Access_Request -> allocate_find (find the same ip to the same user) + allocate_update (assign same ip, renew lease) </span></pre>
<pre><span style="color:black">2) Accounting-Request Stop -> allocate_free (clear ip</span><span style="color:#1F497D"></span></pre>
<pre><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></pre>
<pre><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></pre>
<pre><span lang="IT" style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">Ho capito adesso.</span></pre>
<pre><span lang="IT" style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">L’unica cosa che mi viene in mente e di aggiungere il session ID in DB dei IP quando arriva lo start accounting.</span></pre>
<pre><span lang="IT" style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">E fare un compare quando arrivo lo stop , se matcha bene se no non cancella </span></pre>
<pre><span lang="IT" style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></pre>
<pre><span lang="IT" style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:#1F497D">Brian</span></pre>
</div>
</div>
</div>
</div>
</body>
</html>