<div dir="ltr"><div style="font-family:arial,sans-serif;font-size:13px">There are suggestions that blocks the entry into the database via mysql. Can you advise why the blocks?</div><div style="font-family:arial,sans-serif;font-size:13px">
<br></div><div style="font-family:arial,sans-serif;font-size:13px"><a href="http://pastebin.com/XWBp6uFw" target="_blank">http://pastebin.com/XWBp6uFw</a></div><div class="gmail_extra"><br></div><div class="gmail_extra"><span style="color:rgb(80,0,80)">------------------------------</span><br style="color:rgb(80,0,80)">
<br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">Message: 4</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">Date: Fri, 25 Oct 2013 10:13:25 +0800</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">From: ????? ???????? <</span><a href="mailto:avdoshkin@gmail.com" target="_blank">avdoshkin@gmail.com</a><span style="color:rgb(80,0,80)">></span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)">To: </span><a href="mailto:freeradius-users@lists.freeradius.org" target="_blank">freeradius-users@lists.freeradius.org</a><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">Subject: dhcp</span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)">Message-ID:</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)"> <</span><a href="mailto:CAJC1y5ynL5p-wrCOjRYdC1%2BEDUwL_oGB6jmV2KibMGx0PuHEAg@mail.gmail.com" target="_blank">CAJC1y5ynL5p-wrCOjRYdC1+EDUwL_oGB6jmV2KibMGx0PuHEAg@mail.gmail.com</a><span style="color:rgb(80,0,80)">></span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)">Content-Type: text/plain; charset="iso-8859-1"</span><br style="color:rgb(80,0,80)"><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">radiusd: FreeRADIUS Version 2.2.2, for host x86_64-unknown-linux-gnu, built</span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)">on Oct 14 2013 at 22:41:53</span><br style="color:rgb(80,0,80)"><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">dhcp.conf</span><br style="color:rgb(80,0,80)"><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)">server dhcp {</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">listen {</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">type = dhcp</span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)">ipaddr = 10.0.0.249</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">port = 67</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">interface = vlan10</span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)">broadcast = yes</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">}</span><br style="color:rgb(80,0,80)"><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">dhcp DHCP-Discover {</span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)"> python</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">}</span><br style="color:rgb(80,0,80)"><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">dhcp DHCP-Request {</span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)"> python</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">}</span><br style="color:rgb(80,0,80)"><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">dhcp DHCP-Release {</span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)"> python</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">}</span><br style="color:rgb(80,0,80)"><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">dhcp DHCP-Inform {</span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)"> python</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">}</span><br style="color:rgb(80,0,80)"><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">dhcp DHCP-Decline {</span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)"> python</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">}</span><br style="color:rgb(80,0,80)"><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">}</span><br style="color:rgb(80,0,80)">
<br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">How can I fix these errors?</span><br style="color:rgb(80,0,80)"><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">Fri Oct 25 06:41:19 2013 : Error: Discarding duplicate request from client</span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)">dhcp port 67 - ID: 1235289482 due to unfinished request 1265526</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">Fri Oct 25 06:49:11 2013 : Error: Discarding duplicate request from client</span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)">dhcp port 67 - ID: 417288914 due to unfinished request 1266266</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">Fri Oct 25 06:50:53 2013 : Error: Discarding duplicate request from client</span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)">dhcp port 67 - ID: 2640071483 due to unfinished request 1266459</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">Fri Oct 25 06:52:38 2013 : Error: Discarding duplicate request from client</span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)">dhcp port 67 - ID: 1828774073 due to unfinished request 1266657</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">Fri Oct 25 06:54:33 2013 : Error: Discarding duplicate request from client</span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)">dhcp port 67 - ID: 3389080412 due to unfinished request 1266856</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">Fri Oct 25 06:58:23 2013 : Error: Discarding duplicate request from client</span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)">dhcp port 67 - ID: 2209098358 due to unfinished request 1267239</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">Fri Oct 25 07:05:03 2013 : Error: Discarding duplicate request from client</span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)">dhcp port 67 - ID: 755143304 due to unfinished request 1267952</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">Fri Oct 25 07:07:19 2013 : Error: Discarding duplicate request from client</span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)">dhcp port 67 - ID: 1691312898 due to unfinished request 1268193</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">Fri Oct 25 07:08:24 2013 : Error: Discarding duplicate request from client</span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)">dhcp port 67 - ID: 776764220 due to unfinished request 1268319</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">Fri Oct 25 07:16:21 2013 : Error: Discarding duplicate request from client</span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)">dhcp port 67 - ID: 481491101 due to unfinished request 1269360</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">-------------- next part --------------</span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)">An HTML attachment was scrubbed...</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">URL: <</span><a href="http://lists.freeradius.org/pipermail/freeradius-users/attachments/20131025/ea4c37c5/attachment-0001.html" target="_blank">http://lists.freeradius.org/pipermail/freeradius-users/attachments/20131025/ea4c37c5/attachment-0001.html</a><span style="color:rgb(80,0,80)">></span><br style="color:rgb(80,0,80)">
<br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">------------------------------</span><br style="color:rgb(80,0,80)"><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">Message: 5</span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)">Date: Thu, 24 Oct 2013 22:33:59 -0400</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">From: Alan DeKok <</span><a href="mailto:aland@deployingradius.com" target="_blank">aland@deployingradius.com</a><span style="color:rgb(80,0,80)">></span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)">To: FreeRadius users mailing list</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)"> <</span><a href="mailto:freeradius-users@lists.freeradius.org" target="_blank">freeradius-users@lists.freeradius.org</a><span style="color:rgb(80,0,80)">></span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)">Subject: Re: dhcp</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">Message-ID: <</span><a href="mailto:5269D897.1000509@deployingradius.com" target="_blank">5269D897.1000509@deployingradius.com</a><span style="color:rgb(80,0,80)">></span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)">Content-Type: text/plain; charset=UTF-8</span><br style="color:rgb(80,0,80)"><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">????? ???????? wrote:</span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)">...</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">> server dhcp {</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">> listen {</span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)">> type = dhcp</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">> ipaddr = 10.0.0.249</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">> port = 67</span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)">> interface = vlan10</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">> broadcast = yes</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">> }</span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)">></span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">> |dhcp DHCP-Discover {</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">> python</span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)">> }</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">...</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">> How can I fix these errors?</span><br style="color:rgb(80,0,80)">
<span style="color:rgb(80,0,80)">></span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">> Fri Oct 25 06:41:19 2013 : Error: Discarding duplicate request from</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">> client dhcp port 67 - ID: 1235289482 due to unfinished request 1265526</span><br style="color:rgb(80,0,80)">
<br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)"> As I told you on github, fix your python script so that it doesn't</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">break the server.</span><br style="color:rgb(80,0,80)">
<br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)"> The default dhcp configuration does NOT have this problem. You've</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">deleted that, and added your python script.</span><br style="color:rgb(80,0,80)">
<br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)"> Therefore, all of the problem is the python script. It's blocked, and</span><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)">is breaking the server.</span><br style="color:rgb(80,0,80)">
<br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)"> Don't do that.</span><br style="color:rgb(80,0,80)"><br style="color:rgb(80,0,80)"><span style="color:rgb(80,0,80)"> Alan DeKok.</span><br style="color:rgb(80,0,80)">
<br><div class="gmail_quote"><br></div>
</div></div>