<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">On 5/2/17 9:11 AM, Wessel, Sebastian
wrote:<br>
</div>
<blockquote cite="mid:af8c872b0f4847d5b4f1411d94d858a3@takko.de"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.E-MailFormatvorlage17
{mso-style-type:personal-compose;
font-family:"Arial",sans-serif;
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-family:"Arial",sans-serif">Hello
everyone,<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial",sans-serif">we are
migrating from Windows DHCP to kea with mysql as DB.<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial",sans-serif">Because we
don’t want to loose all of our leases and because of a
lease-time of 2 weeks we need to translate the leases from
windows dhcp to kea.<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial",sans-serif">We are
talking about 8800 leases and 2300 scopes, so „by hand“ will
fail.<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial",sans-serif">The leases
will be exported as xml on the server and imported through a
php-script (and it will print out the scope-conf and so on)<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial",sans-serif">Kea.conf
will be ready when the leases run into the db.<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial",sans-serif">Is it a
good idea to just insert the leases into the mysql-database
(lease4) or do we have to go another way?<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
</div>
<div style="FONT-SIZE: 11pt; FONT-FAMILY: arial" align="left">
<div style="FONT-SIZE: 11pt; FONT-FAMILY: arial" align="left"><br>
Mit freundlichen Grüßen / With kind regards<br>
</div>
<br>
<div style="FONT-SIZE: 12pt; FONT-FAMILY: arial; FONT-WEIGHT:
bold" align="left">
Sebastian Wessel</div>
<div style="FONT-SIZE: 11pt; FONT-FAMILY: arial">Specialist IT
Systems</div>
<br>
<div style="FONT-SIZE: 10pt; FONT-FAMILY: arial; COLOR: #000000">__________________________________________________________________________________</div>
<br>
<div style="FONT-SIZE: 7.5pt; FONT-FAMILY: arial" align="left">Sebastian
Wessel</div>
<div style="FONT-SIZE: 7.5pt; FONT-FAMILY: arial; FONT-WEIGHT:
bold" align="left">
Takko Holding GmbH</div>
<div style="FONT-SIZE: 7.5pt; FONT-FAMILY: arial" align="left">Alfred-Krupp-Straße
21 · 48291 Telgte · Germany</div>
<div style="FONT-SIZE: 7.5pt; FONT-FAMILY: arial" align="left">T
+49 2504 923 865 · Mobile +49 152 21811579 · F +49 2504 923
797</div>
<div style="FONT-SIZE: 7.5pt; FONT-FAMILY: arial" align="left"><a class="moz-txt-link-abbreviated" href="http://www.takko.com">www.takko.com</a></div>
<div style="FONT-SIZE: 10pt; FONT-FAMILY: arial; COLOR: #000000">__________________________________________________________________________________</div>
<br>
<div style="FONT-SIZE: 7.5pt; FONT-FAMILY: arial" align="left">Bitte
prüfen Sie der Umwelt zuliebe, ob der Ausdruck dieser Mail
erforderlich ist.
<br>
<br>
<div style="FONT-SIZE: 7.5pt; FONT-FAMILY: arial" align="left">Geschäftsführer:
Ulrich Eickmann, Thomas Helmreich, Alexander Mattschull,
Arnold Mattschull<br>
Amtsgericht Münster HRB 8939<br>
Ust.-Id Nr. DE209094382
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Kea-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Kea-users@lists.isc.org">Kea-users@lists.isc.org</a>
<a class="moz-txt-link-freetext" href="https://lists.isc.org/mailman/listinfo/kea-users">https://lists.isc.org/mailman/listinfo/kea-users</a>
</pre>
</blockquote>
<p>Hello Wessel:</p>
<p>Currently Kea does not cache any lease information when you use
one of the RDBMs backends for lease storage, so you should be able
to simply insert them. The only negative effect this would have
on a running Kea is that lease statistics would be inaccurate
until Kea is told to reconfigure or recalculate statistics (see
command channel commands) or Kea is restarted. <br>
</p>
<p>Regards,</p>
<p>Thomas Markwalder</p>
<p>ISC Software Engineering<br>
</p>
</body>
</html>