<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hi,<br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On 9. Jun 2020, at 16:43, John Doe <<a href="mailto:johndoe@null.net" class="">johndoe@null.net</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class=""><div style="font-family: Verdana;font-size: 12.0px;" class=""><div class="">Hallo zusammen,</div>
<div class=""> </div>
<div class="">bevor ich jetzt wieder Mist mit der Datenbank mache, würde ich gerne hier nachfragen.</div>
<div class=""> </div>
<div class="">1. Neuer aufgesetzter VZ läuft zunächst mal wieder auf einem RPi3 wie gewünscht.</div>
<div class="">2. dbcopy läuft auch, ich kann lokal eine sqlite.db3 anlegen.</div>
<div class="">3. Da ich noch die Sicherung der alten DB habe (ebenfalls sqlite.db3), würde ich diese mit der aktuellen gerne "mergen". Kann ich das einfach doof und hoffentlich gefahrlos tun, indem ich in der dbcopy.yaml Quelle und Ziel vertausche ? Bleiben meine aktuell schon vorliegenden Daten existent ?</div></div></div></div></blockquote><div><br class=""></div>Das kannst Du auf KEINEN Fall tun:</div><div><br class=""></div><div>- es gibt keinen “merge” Prozess</div><div>- in beiden Datenbanken werden die gleichen IDs existieren</div><div>- die Entities werden bei Default Einstellungen überschrieben</div><div><br class=""></div><div>—> vmtl. Desaster</div><div><br class=""></div><div>DBCopy ist ausschließlich dafür geeignet, “linear” von einer DB in eine andere DB zu kopieren die ein Subset der identischen Daten enthält. Bei Dir scheinen aber in beiden DBs disjunkte Datenbestände zu liegen- Du wirst nicht drum herum kommen einen der DB-Stände zu opfern.</div><div><br class=""></div><div>Viele Grüße, </div><div>Andreas</div><div><br class=""><blockquote type="cite" class=""><div class=""><div class=""><div style="font-family: Verdana;font-size: 12.0px;" class="">
<div class=""> </div>
<div class="">Beste Grüße</div>
<div class=""> </div>
<div class="">JD.</div>
<div class="">
<div class="">
<div name="quote" style="margin:10px 5px 5px 10px; padding: 10px 0 10px 10px; border-left:2px solid #C3D9E5; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<div style="margin:0 0 10px 0;" class=""><b class="">Sent:</b> Tuesday, June 09, 2020 at 9:24 AM<br class="">
<b class="">From:</b> "Andreas Goetz" <<a href="mailto:cpuidle@gmail.com" class="">cpuidle@gmail.com</a>><br class="">
<b class="">To:</b> "<a href="http://volkszaehler.org" class="">volkszaehler.org</a> - users" <<a href="mailto:volkszaehler-users@demo.volkszaehler.org" class="">volkszaehler-users@demo.volkszaehler.org</a>><br class="">
<b class="">Subject:</b> Re: [vz-users] Bevorstehender Kartencrash</div>
<div name="quoted-content" class="">
<div class="">Hallo Christian,
<div class="">
<blockquote class="">
<div class="">On 8. Jun 2020, at 19:46, Christian Wimmer <<a href="mailto:christian@nega.at" onclick="parent.window.location.href='mailto:christian@nega.at'; return false;" target="_blank" class="">christian@nega.at</a>> wrote:</div>
<div class="">
<div class="WordSection1" style="page: WordSection1;font-family: Helvetica;font-size: 14.0px;font-style: normal;font-weight: normal;letter-spacing: normal;text-indent: 0.0px;text-transform: none;white-space: normal;word-spacing: 0.0px;text-decoration: none;">
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span class="">Hallo JD</span></div>
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span class=""> </span></div>
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span class="">Danke, das hört sich gut an. Ich verwende nur Sandisk.</span></div>
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span class=""> </span></div>
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span class="">Am liebsten würde ich ja die DB auf das NAS auslagern, so dass nur dort geschrieben wird.</span></div>
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span class="">Aber das liest sich alles so kompliziert.</span></div>
</div>
</div>
</blockquote>
<div class=""> </div>
Jetzt verbreitest Du aber ziemliche Panik ;)</div>
<div class=""> </div>
<div class="">Eine Datenbank auf dem NAS zu nutzen statt einer Datenbank auf dem Raspi bedeutet einfach nur die Konfigurationsdatei zu ändern (URL, User, Passwort). Wenn Du z.B. schon ein Backup auf dem NAS hättest könnte das direkt Deine “Haupt”Datenbank werden (brauchst Du dann natürlich ein neues Backup).</div>
<div class=""> </div>
<div class="">Viele Grüße, </div>
<div class="">Andreas</div>
<div class=""> </div>
<div class="">
<blockquote class="">
<div class="WordSection1" style="page: WordSection1;font-family: Helvetica;font-size: 14.0px;font-style: normal;font-weight: normal;letter-spacing: normal;text-indent: 0.0px;text-transform: none;white-space: normal;word-spacing: 0.0px;text-decoration: none;">
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""> </div>
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""> </div>
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span class=""> </span></div>
<div class="">
<div style="border-style: solid none none;border-top-width: 1.0pt;border-top-color: rgb(225,225,225);padding: 3.0pt 0.0cm 0.0cm;" class="">
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><b class=""><span class="">Von:</span></b><span class=""><span class="Apple-converted-space"> </span>volkszaehler-users <<a href="mailto:volkszaehler-users-bounces@demo.volkszaehler.org" onclick="parent.window.location.href='mailto:volkszaehler-users-bounces@demo.volkszaehler.org'; return false;" target="_blank" class="">volkszaehler-users-bounces@demo.volkszaehler.org</a>><span class="Apple-converted-space"> </span><b class="">Im Auftrag von<span class="Apple-converted-space"> </span></b>John Doe<br class="">
<b class="">Gesendet:</b><span class="Apple-converted-space"> </span>Montag, 8. Juni 2020 19:15<br class="">
<b class="">An:</b><span class="Apple-converted-space"> </span><a href="mailto:volkszaehler-users@demo.volkszaehler.org" onclick="parent.window.location.href='mailto:volkszaehler-users@demo.volkszaehler.org'; return false;" target="_blank" class="">volkszaehler-users@demo.volkszaehler.org</a><br class="">
<b class="">Betreff:</b><span class="Apple-converted-space"> </span>Re: [vz-users] Bevorstehender Kartencrash</span></div>
</div>
</div>
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""> </div>
<div class="">
<div class="">
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class="">Hallo Christian,</span></div>
</div>
<div class="">
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class=""> </span></div>
</div>
<div class="">
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class="">das hängt wohl auch von der Aggregation-Time ab. Ich glaube aber tendenziell ausgemacht zu haben, dass Sandisk-Karten bei gleicher vzlogger.conf länger halten als Transcend. Erstere lief bei mir über Jahre, letztere einige Monate bis ca. halbes Jahr.</span></div>
</div>
<div class="">
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class="">Beste Grüße</span></div>
</div>
<div class="">
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class=""> </span></div>
</div>
<div class="">
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class="">JD.</span></div>
</div>
<div class="">
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class=""> </span></div>
<div class="">
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class=""> </span></div>
<div style="border-style: none none none solid;border-left-width: 1.5pt;border-left-color: rgb(195,217,229);padding: 0.0cm 0.0cm 0.0cm 8.0pt;margin: 7.5pt 3.75pt 3.75pt 7.5pt;" class="">
<div style="margin-bottom: 7.5pt;" class="">
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><b class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class="">Sent:</span></b><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class=""> Monday, June 08, 2020 at 6:13 PM<br class="">
<b class="">From:</b> "Christian Wimmer" <<a href="mailto:christian@nega.at" onclick="parent.window.location.href='mailto:christian@nega.at'; return false;" style="color: blue;text-decoration: underline;" target="_blank" class="">christian@nega.at</a>><br class="">
<b class="">To:</b> "<a href="http://volkszaehler.org/" target="_blank" class="">volkszaehler.org</a> - users" <<a href="mailto:volkszaehler-users@demo.volkszaehler.org" onclick="parent.window.location.href='mailto:volkszaehler-users@demo.volkszaehler.org'; return false;" style="color: blue;text-decoration: underline;" target="_blank" class="">volkszaehler-users@demo.volkszaehler.org</a>><br class="">
<b class="">Subject:</b> Re: [vz-users] Bevorstehender Kartencrash</span></div>
</div>
<div class="">
<div class="">
<div class="">
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class="">Hallo</span></div>
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class=""> </span></div>
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class="">Frage zwischendurch: wie lange hält im Durchschnitt eine SD-Karte?</span></div>
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class=""> </span></div>
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class=""> </span></div>
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class=""> </span></div>
<div class="">
<div style="border-style: solid none none;border-top-width: 1.0pt;border-top-color: rgb(225,225,225);padding: 3.0pt 0.0cm 0.0cm;" class="">
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><b class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class="">Von:</span></b><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class=""><span class="Apple-converted-space"> </span>volkszaehler-users <<a href="mailto:volkszaehler-users-bounces@demo.volkszaehler.org" onclick="parent.window.location.href='mailto:volkszaehler-users-bounces@demo.volkszaehler.org'; return false;" style="color: blue;text-decoration: underline;" target="_blank" class="">volkszaehler-users-bounces@demo.volkszaehler.org</a>><span class="Apple-converted-space"> </span><b class="">Im Auftrag von<span class="Apple-converted-space"> </span></b>Andreas Goetz<br class="">
<b class="">Gesendet:</b><span class="Apple-converted-space"> </span>Montag, 8. Juni 2020 17:34<br class="">
<b class="">An:</b><span class="Apple-converted-space"> </span>volkszaehler-users <<a href="mailto:volkszaehler-users@demo.volkszaehler.org" onclick="parent.window.location.href='mailto:volkszaehler-users@demo.volkszaehler.org'; return false;" style="color: blue;text-decoration: underline;" target="_blank" class="">volkszaehler-users@demo.volkszaehler.org</a>><br class="">
<b class="">Betreff:</b><span class="Apple-converted-space"> </span>Re: [vz-users] Bevorstehender Kartencrash</span></div>
</div>
</div>
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class=""> </span></div>
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class="">Servus</span></div>
<div class="">
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><br class="">
<span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class=""> </span></div>
<blockquote style="margin-top: 5.0pt;margin-bottom: 5.0pt;" class="">
<div class="">
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class="">On 8. Jun 2020, at 16:38, Daniel Lauckner <<a href="mailto:vz@jahp.de" onclick="parent.window.location.href='mailto:vz@jahp.de'; return false;" style="color: blue;text-decoration: underline;" target="_blank" class="">vz@jahp.de</a>> wrote:</span></div>
</div>
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class=""> </span></div>
<div class="">
<div class="">
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class="">Hallo,<br class="">
<br class="">
<br class="">
am Montag, 8. Juni 2020 um 11:02 hat John Doe geschrieben:<br class="">
</span></div>
<blockquote style="margin-top: 5.0pt;margin-bottom: 5.0pt;" class="">
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class="">Gibt es ein wiki zum Docker-Image und dessen Installation ?</span></div>
</blockquote>
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><br class="">
<span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class="">Nein.</span></div>
</div>
</div>
</blockquote>
<div class="">
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class=""> </span></div>
</div>
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class="">Also “Installation” ist ja bei Docker relativ :). Wenn Du schmerzresistent bist (und es am Ende dokumentieren möchtest) lass es uns gerne zusammen ausprobieren ;). Das Image heißt volkszaehler/volkszaehler, die Oberfläche+API lauscht dann auf 8080. Die Configdatei muss nach </span><span style="font-size: 9.0pt;font-family: Consolas;color: rgb(36,41,46);background-color: white;" class="">/vz/etc/middleware.json<span class="Apple-converted-space"> </span></span><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class="">gemappt werden.</span></div>
</div>
<div class="">
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class=""> </span></div>
</div>
<div class="">
<blockquote style="margin-top: 5.0pt;margin-bottom: 5.0pt;" class="">
<div class="">
<div class="">
<blockquote style="margin-top: 5.0pt;margin-bottom: 5.0pt;" class="">
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class="">Falls ich Deinen Weg mit der Datenbank-Installation auf dem NAS<br class="">
gehe: Welche DB-Software würdest Du vorschlagen ? </span></div>
</blockquote>
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><br class="">
<span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class="">Am besten die SQL-Datenbank was das NAS anbietet.<br class="">
Üblicherweise MySQL oder MariaDB.</span></div>
</div>
</div>
</blockquote>
<div class="">
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class=""> </span></div>
</div>
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class="">…oder einfach auch einen Docker Container mit Volume Mount für die Datenablage. Normalerweise sind diese Images deutlich besser als jede NAS-gebundelte Funktionalität und bekommen auch häufigere Updates.</span></div>
</div>
<div class="">
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><br class="">
<span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class=""> </span></div>
<blockquote style="margin-top: 5.0pt;margin-bottom: 5.0pt;" class="">
<div class="">
<div class="">
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class="">Mit freundlichen Grüßen</span></div>
</div>
</div>
</blockquote>
<blockquote style="margin-top: 5.0pt;margin-bottom: 5.0pt;" class="">
<div class="">
<div class="">
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class="">Daniel</span></div>
</div>
</div>
</blockquote>
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class=""> </span></div>
</div>
<div class="">
<div style="font-size: 11.0pt;font-family: Calibri , sans-serif;" class=""><span style="font-size: 9.0pt;font-family: Verdana , sans-serif;" class="">Viele Grüße, Andreas</span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</div></div></div>
</div></blockquote></div><br class=""></body></html>