<div dir="ltr">I believe that what you're trying to do is partly implemented with storing leases on MySQL databases.<br></div><div class="gmail_extra"><br><div class="gmail_quote">2016-04-13 12:11 GMT-03:00 Ryan Gray <span dir="ltr"><<a href="mailto:ryantgray@gmail.com" target="_blank">ryantgray@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_default" style="font-family:tahoma,sans-serif">Thanks for your input Patrick. I'll look into what might be helpful information from the ISC folks. I am going to put some time in up front on something that might help obfuscate leases data while keeping same-data-points randomized to the same strings (if that makes sense). As much as I would like to skip this step for the sake of diving into the development of the parser itself, I cannot make a case for sending this data out without this step or some mitigating actions to remove the risk.</div><div class="gmail_default" style="font-family:tahoma,sans-serif"><br></div><div class="gmail_default" style="font-family:tahoma,sans-serif">Thank you.</div><div class="gmail_default" style="font-family:tahoma,sans-serif"><br></div><div class="gmail_default" style="font-family:tahoma,sans-serif"><br></div><div class="gmail_default" style="font-family:tahoma,sans-serif">Regards,</div><div class="gmail_default" style="font-family:tahoma,sans-serif">Ryan Gray</div></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div class="h5">On Wed, Apr 13, 2016 at 9:48 AM, Patrick Trapp <span dir="ltr"><<a href="mailto:ptrapp@nex-tech.com" target="_blank">ptrapp@nex-tech.com</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5">
<div>
<div style="direction:ltr;font-family:Tahoma;color:#000000;font-size:10pt">It would be interesting to see if the ISC folks can provide some insight/aid to you even if they as an organization have not prioritized building the project themselves.<br>
<br>
We have a pretty simplistic analysis that I might be able to share with you, but I think your PHP classes are probably what our developers are using.<br>
<br>
I have a pretty busy leases file, I think, but I would want to obfuscate things before I gave it to "some dude on the Internet" as you so eloquently put it.<br>
<br>
Patrick<br>
<br>
<div style="font-family:Times New Roman;color:#000000;font-size:16px">
<hr>
<div style="direction:ltr"><font face="Tahoma" size="2" color="#000000"><b>From:</b> <a href="mailto:dhcp-users-bounces@lists.isc.org" target="_blank">dhcp-users-bounces@lists.isc.org</a> [<a href="mailto:dhcp-users-bounces@lists.isc.org" target="_blank">dhcp-users-bounces@lists.isc.org</a>] on behalf of Ryan Gray [<a href="mailto:ryantgray@gmail.com" target="_blank">ryantgray@gmail.com</a>]<br>
<b>Sent:</b> Wednesday, April 13, 2016 9:36 AM<br>
<b>To:</b> Users of ISC DHCP<br>
<b>Subject:</b> DHCP Leases Parser<br>
</font><br>
</div><div><div>
<div></div>
<div>
<div dir="ltr">
<div class="gmail_default" style="font-family:tahoma,sans-serif">Greetings everyone,</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif"><br>
</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif">This is one part poll, one part request. I am working on a project that necessitates analyzing the dhcpd.leases "database". For many years I have struggled with getting usable information out
of the leases database in a sane fashion. While there have been some very helpful utilities, (command line scripts, dhcpstatus.cgi, dhcpd-pools anyone?), none of them have been exactly what I was looking for and all of them are quite antiquated in regards
to what they are built with. I've had it with cobbling together nearly unacceptable solutions and am going to build an application to solve this, at the very least for myself. I've got a good start with some super helpful PHP classes that I've been working
on.</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif"><br>
</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif">Poll:</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif">If there were a service that allowed you to upload, or otherwise sync, your leases file and would give you status, statistics, and historical information, would you be interested in using it?
I am not talking about anything that is actively part of the DHCP traffic, purely a leases analyzer. Is there interest in a web based utility like this?</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif"><br>
</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif">Request:</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif">If there is interest in a service like this, it will be imperative that I gather as many example dhcpd.leases files as possible during development. I can only generate so much data locally and
I want to account for as many variables as possible. My request is that if you are interested in something like this and are able to send me any dhcpd.leases files, that would be extremely helpful. I realize that leases information might be considered too
sensitive to just send to some dude on the internet, so if anyone is interested and finds this a hurdle, I would be happy to come up with a way for us to mitigate that risk. ....perhaps a script that you can run locally to obscure sensitive data.</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif"><br>
</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif">Just putting out the feelers here. This is getting built regardless, but if there is community interest in the topic, I would be excited to work with you and to give back to a community that has
done so much for so many for so long.</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif"><br>
</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif"><br>
</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif">Regards,</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif">Ryan Gray</div>
</div>
</div>
</div></div></div>
</div>
</div>
<br></div></div>_______________________________________________<br>
dhcp-users mailing list<br>
<a href="mailto:dhcp-users@lists.isc.org" target="_blank">dhcp-users@lists.isc.org</a><br>
<a href="https://lists.isc.org/mailman/listinfo/dhcp-users" rel="noreferrer" target="_blank">https://lists.isc.org/mailman/listinfo/dhcp-users</a><br></blockquote></div><br></div>
<br>_______________________________________________<br>
dhcp-users mailing list<br>
<a href="mailto:dhcp-users@lists.isc.org">dhcp-users@lists.isc.org</a><br>
<a href="https://lists.isc.org/mailman/listinfo/dhcp-users" rel="noreferrer" target="_blank">https://lists.isc.org/mailman/listinfo/dhcp-users</a><br></blockquote></div><br></div>