<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 JD,<br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On 10. Jun 2020, at 18:29, 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 Andreas,</div>
<div class=""> </div>
<div class="">nach dem Neuaufsetzten hatte ich in der vzlogger.conf die UIDs eingetragen, die mir nach dem Neu-Anlegen der Kanäle im Web-Frontend angezeigt wurden.</div>
<div class="">Nach dem heutigen restore haten diese andere UIDs (verifiziert durch das "i”). </div></div></div></div></blockquote><div><br class=""></div>Dann ist es klar: Du hast *neue* Kanäle angelegt und in die vzlogger.conf eingetragen. Anschließend hattest Du alles gelöscht und die *alten* Kanäle restored, die vzlogger war aber noch die alte. Zwei Schritte zuviel ;)</div><div><br class=""><blockquote type="cite" class=""><div class=""><div class=""><div style="font-family: Verdana;font-size: 12.0px;" class=""><div class="">Nachdem ich diese in der vzlogger.conf eingetragen hatte, lief alles auf Anhieb.</div>
<div class="">Aber egal, Hauptsache es läuft wieder. Erstaunlicherweise hat sich gezeigt, dass die letzten Eiträge aus der DB vom 06.06. spät Abends sind, der Raspi aber zumindest bis zum Morgen des 07.06. in Kontakt mit der Firewall stand.</div>
<div class="">Das wiki für meinen Teil der letzten Tage übernehme ich gerne. Was genau muss ich (neben der Prosa) dafür tun ?</div></div></div></div></blockquote><div><br class=""></div>Da müssen die Experten helfen- eigentlich nur den richtigen Platz im Wiki suchen und dann strukturiert dokumentieren:</div><div>- welches Problem soll gelöst werden?</div><div>- aus welchen Schritten besteht die Lösung?</div><div>- wie sehen die Schritte im Einzelnen aus?</div><div>- welche Werkzeuge kommen jeweils zum Einsatz wenn man auf Probleme stößt?</div><div><br class=""><blockquote type="cite" class=""><div class=""><div style="font-family: Verdana;font-size: 12.0px;" class="">
<div class="">Beste Grüße </div>
<div class="">JD.</div></div></div></blockquote><div><br class=""></div>Schönen Abend und Viele Grüße, Andreas</div><div><br class=""><blockquote type="cite" class=""><div class=""><div style="font-family: Verdana;font-size: 12.0px;" class="">
<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> Wednesday, June 10, 2020 at 5:07 PM<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="">
<div class="">Das ist auch schwer zu glauben. Die UUIDs stehen in der Datenbank, die können nicht spontan nicht mehr passen. Wenn sie das tun dann hast Du vmtl. eine falsche vzlogger.conf zurück gespielt?</div>
<div class=""> </div>
<div class="">Nachdem wir das jetzt mit allen Stolperfallen durchgespielt haben- hättest Du evtl. Lust den Prozess des Restore vielleicht nochmal für‘s Wiki zu dokumentieren? Umzug auf ein NAS wäre dann in analoger Form möglich, Docker kann zusätzlich umgesetzt werden.</div>
<div class=""> </div>
<div class="">Viele Grüße, </div>
<div class="">Andreas</div>
<div class="">
<blockquote class="">Am 10.06.2020 um 17:01 schrieb John Doe <<a href="mailto:johndoe@null.net" class="">johndoe@null.net</a>>:<br class="">
</blockquote>
</div>
<blockquote class="">
<div class="">
<div style="font-family: Verdana;font-size: 12.0px;" class="">
<div class="">Hallo Andreas,</div>
<div class=""> </div>
<div class="">erstmal Danke für Deine Leidensfäfigkeit!</div>
<div class="">Ich hab' den Fehler gefunden - die UIDs in der vzlogger.conf passten nicht mehr.</div>
<div class="">Jetzt läuft alles bestens.</div>
<div class="">Ich werde mal darüber nachdenken, das Ganze etwas ausfallsicherer zu machen.</div>
<div class="">Allerdings sehe ich aktuell noch keinen Mehrwert darin, den Raspi von einer SSD booten zu lassen und das Ganze dann auf diesem Wege auszulagern, da dieser Verbund wiederum natürlich mehr Strom verbraucht ...</div>
<div class="">Nochmal Danke für Deine Bemühungen!</div>
<div class="">Beste Grüße</div>
<div class=""> </div>
<div class="">JD.</div>
<div class="">
<div class="">
<div style="margin: 10.0px 5.0px 5.0px 10.0px;padding: 10.0px 0 10.0px 10.0px;border-left: 2.0px solid rgb(195,217,229);" class="">
<div style="margin: 0 0 10.0px 0;" class=""><b class="">Sent:</b> Wednesday, June 10, 2020 at 4:56 PM<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 class="">
<div class="">
<div class="">Erstmal Glückwunsch!</div>
<div class=""> </div>
<div class="">Ich würde ja die gleiche Frage stellen wie immer: was steht im Logfile? In diesem Falle also dem von vzlogger?</div>
<div class=""> </div>
<div class="">Wenn da nix drin steht: kannst Du das Volkszähler API im Browser aufrufen?</div>
<div class=""> </div>
<div class="">Viele Grüße, Andreas</div>
<div class=""> </div>
<div class="">
<blockquote class="">Am 10.06.2020 um 16:37 schrieb John Doe <<a href="mailto:johndoe@null.net" class="">johndoe@null.net</a>>:<br class="">
</blockquote>
</div>
<blockquote class="">
<div class="">
<div style="font-family: Verdana;font-size: 12.0px;" class="">
<div class="">Hallo Andreas,</div>
<div class="">das war 's:</div>
<div class=""> </div>
<div class="">Ein</div>
<div class=""> </div>
<div class="">/etc/init.d/cron stop</div>
<div class=""> </div>
<div class="">hat es ermöglicht, das der restore fehlerfrei durchgelaufen ist.</div>
<div class="">Im Webfrontend ist alles da - bis auf das Problemchen, das keine aktuellen Werte mehr ankommen ...</div>
<div class="">Der cronjob und der vzlogger laufen:</div>
<div class=""> </div>
<div class="">
<div class="">pi@raspberrypi:~ $ /etc/init.d/cron status<br class="">
● cron.service - Regular background program processing daemon<br class="">
Loaded: loaded (/lib/systemd/system/cron.service; enabled; vendor preset: enabled)<br class="">
Active: active (running) since Wed 2020-06-10 16:28:20 CEST; 8min ago<br class="">
Docs: man:cron(8)<br class="">
Main PID: 410 (cron)<br class="">
Tasks: 4 (limit: 2068)<br class="">
CGroup: /system.slice/cron.service<br class="">
├─ 410 /usr/sbin/cron -f<br class="">
├─1043 /usr/sbin/CRON -f<br class="">
├─1047 /bin/sh -c php /var/www/<a href="http://volkszaehler.org/bin/aggregate" class="">volkszaehler.org/bin/aggregate</a> run -m delta -l minute >/dev/null<br class="">
└─1048 php /var/www/<a href="http://volkszaehler.org/bin/aggregate" class="">volkszaehler.org/bin/aggregate</a> run -m delta -l minute</div>
<div class="">Jun 10 16:28:20 raspberrypi systemd[1]: Started Regular background program processing daemon.<br class="">
Jun 10 16:28:20 raspberrypi cron[410]: (CRON) INFO (pidfile fd = 3)<br class="">
Jun 10 16:28:20 raspberrypi cron[410]: (CRON) INFO (Running @reboot jobs)<br class="">
Jun 10 16:30:01 raspberrypi CRON[1043]: pam_unix(cron:session): session opened for user pi by (uid=0)<br class="">
Jun 10 16:30:01 raspberrypi CRON[1047]: (pi) CMD (php /var/www/<a href="http://volkszaehler.org/bin/aggregate" class="">volkszaehler.org/bin/aggregate</a> run -m delta -l minute >/dev/null)</div>
<div class=""> </div>
<div class="">
<div class="">pi@raspberrypi:~ $ sudo systemctl status vzlogger<br class="">
● vzlogger.service - vzlogger<br class="">
Loaded: loaded (/etc/systemd/system/vzlogger.service; enabled; vendor preset: enabled)<br class="">
Active: active (running) since Wed 2020-06-10 16:28:35 CEST; 8min ago<br class="">
Main PID: 738 (vzlogger)<br class="">
Tasks: 5 (limit: 2068)<br class="">
CGroup: /system.slice/vzlogger.service<br class="">
└─738 /usr/local/bin/vzlogger -c /etc/vzlogger.conf</div>
<div class="">Jun 10 16:28:35 raspberrypi systemd[1]: Started vzlogger.</div>
<div class=""> </div>
<div class="">Hättest Du eine Idee, woran das liegen kann ?</div>
<div class="">Grüße</div>
<div class=""> </div>
<div class="">JD.</div>
</div>
<div class=""> </div>
</div>
<div class=""> </div>
<div class=""> </div>
<div class="">
<div class="">
<div style="margin: 10.0px 5.0px 5.0px 10.0px;padding: 10.0px 0 10.0px 10.0px;border-left: 2.0px solid rgb(195,217,229);" class="">
<div style="margin: 0 0 10.0px 0;" class=""><b class="">Sent:</b> Wednesday, June 10, 2020 at 1:31 PM<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 class="">
<div class="">Moment- mir kommt noch ein Gedanke. Kann es sein, dass bei Dir auch der cron-Job für die Aggretation noch aktiv ist? Da dieser auch Massendatenoperationen mit der `data` Tabelle macht darf der auch nicht laufen!
<div class=""> </div>
<div class="">Bei Dir scheinen definitiv >1 Prozess auf der Datenbank rumzudaddeln die sich dann (“deadlock”) ins Gehege kommen. Es sollte *nur* der Restore laufen!</div>
<div class=""> </div>
<div class="">Viele Grüße, </div>
<div class="">Andreas</div>
<div class="">
<div class="">
<blockquote class="">
<div class="">On 10. Jun 2020, at 13:28, Andreas Goetz <<a href="mailto:cpuidle@gmail.com" onclick="parent.window.location.href='mailto:cpuidle@gmail.com'; return false;" target="_blank" class="">cpuidle@gmail.com</a>> wrote:</div>
<div class="">
<div class="">Womit bricht es ab? gleicher Fehler?
<div class=""> </div>
<div class="">Wenn Dein vzlogger gestoppt ist dann starte den Kopiervorgang- wie ich geschrieben hatte- einfach neu. Der geht an der letzten Stelle wieder los. Wenn Du jedesmal zwischendurch ohne Not die Datenbank platt machst wird das natürlich nichts :O</div>
<div class=""> </div>
<div class="">Viele Grüße, Andreas</div>
<div class="">
<div class="">
<blockquote class="">
<div class="">On 10. Jun 2020, at 13:26, John Doe <<a href="mailto:johndoe@null.net" onclick="parent.window.location.href='mailto:johndoe@null.net'; return false;" target="_blank" class="">johndoe@null.net</a>> wrote:</div>
<div class="">
<div class="">
<div style="font-family: Verdana;font-size: 12.0px;" class="">
<div class="">Hallo Andreas,</div>
<div class=""> </div>
<div class="">ich habe jetzt einige Male "von vorne begonnen":</div>
<div class=""> </div>
<div class="">pi@raspberrypi:~ $ bin/doctrine orm:schema-tool:drop --force</div>
<div class="">pi@raspberrypi:~ $ bin/doctrine orm:schema-tool:create</div>
<div class="">pi@raspberrypi:~ $ bin/doctrine orm:schema-tool:create --dump-sql</div>
<div class=""> </div>
<div class="">
<div class="">pi@raspberrypi:~ $ sudo /var/www/<a href="http://volkszaehler.org/vendor/bin/dbcopy" target="_blank" class="">volkszaehler.org/vendor/bin/dbcopy</a> copy -c /etc/dbcopy.yaml</div>
<div class=""> </div>
<div class="">Das Kopieren von data bricht immer wieder an zufälligen Stellen ab, beim letzten Mal nach ca. 1500000/29000000 rows.</div>
<div class=""> </div>
<div class="">vzlogger ist sicher gestopt:</div>
<div class=""> </div>
<div class="">
<div class="">pi@raspberrypi:~ $ sudo systemctl status vzlogger<br class="">
● vzlogger.service - vzlogger<br class="">
Loaded: loaded (/etc/systemd/system/vzlogger.service; enabled; vendor preset: enabled)<br class="">
Active: failed (Result: timeout) since Wed 2020-06-10 12:22:05 CEST; 1h 3min ago<br class="">
Main PID: 750 (code=killed, signal=KILL)</div>
<div class=""> </div>
</div>
<div class=""> </div>
<div class="">Ich probiere das Ganze heute abend nochmal und berichte dann wieder.</div>
<div class="">Grüße</div>
<div class=""> </div>
<div class="">JD.</div>
</div>
<div class="">
<div class="">
<div style="margin: 10.0px 5.0px 5.0px 10.0px;padding: 10.0px 0 10.0px 10.0px;border-left: 2.0px solid rgb(195,217,229);" class="">
<div style="margin: 0 0 10.0px 0;" class=""><b class="">Sent:</b> Wednesday, June 10, 2020 at 12:34 PM<br class="">
<b class="">From:</b> "Andreas Goetz" <<a href="mailto:cpuidle@gmail.com" onclick="parent.window.location.href='mailto:cpuidle@gmail.com'; return false;" target="_blank" class="">cpuidle@gmail.com</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;" target="_blank" class="">volkszaehler-users@demo.volkszaehler.org</a>><br class="">
<b class="">Subject:</b> Re: [vz-users] Bevorstehender Kartencrash</div>
<div class="">
<div class="">Hi JD,
<div class=""> </div>
<div class="">hast Du die Datenbank wieder leer gemacht? Falls nein droht Dir inkonsistenter Stand oder schlimmstenfalls Abbruch des Restores….</div>
<div class=""> </div>
<div class="">Falls Du es laufen lassen willst und es dann doch noch abbrechen sollte weisst Du was zu tun ist: die Datenbank komplett wieder abräumen kann auch </div>
<div class=""> </div>
<div class=""> bin/doctrine orm:schema-tool:drop</div>
<div class=""> </div>
<div class="">Viele Grüße, </div>
<div class="">Andreas</div>
<div class="">
<div class="">
<blockquote class="">
<div class="">On 10. Jun 2020, at 12:28, John Doe <<a href="mailto:johndoe@null.net" onclick="parent.window.location.href='mailto:johndoe@null.net'; return false;" target="_blank" class="">johndoe@null.net</a>> wrote:</div>
<div class="">
<div class="">
<div style="font-family: Verdana;font-size: 12.0px;" class="">
<div class="">Hallo Andreas,</div>
<div class=""> </div>
<div class="">Du hattest irgendwie recht: Ich hatte zwar ein</div>
<div class=""> </div>
<div class="">
<div class="">sudo systemctl status vzlogger</div>
<div class=""> </div>
<div class="">vor dem restore spendiert, allerdings schien der Dienst sich noch in einem Zombizustand zu befinden:</div>
<div class=""> </div>
<div class="">
<div class="">pi@raspberrypi:~ $ sudo systemctl status vzlogger<br class="">
● vzlogger.service - vzlogger<br class="">
Loaded: loaded (/etc/systemd/system/vzlogger.service; enabled; vendor preset: enabled)<br class="">
Active: deactivating (stop-sigterm) since Wed 2020-06-10 12:20:24 CEST; 1min 38s ago<br class="">
Main PID: 750 (vzlogger)<br class="">
Tasks: 1 (limit: 2068)<br class="">
CGroup: /system.slice/vzlogger.service<br class="">
└─750 /usr/local/bin/vzlogger -c /etc/vzlogger.conf</div>
<div class="">Jun 10 12:20:10 raspberrypi systemd[1]: Started vzlogger.<br class="">
Jun 10 12:20:24 raspberrypi systemd[1]: Stopping vzlogger...</div>
<div class=""> </div>
</div>
<div class=""> </div>
<div class="">Ich habe rebootet, gecheckt:</div>
<div class=""> </div>
<div class="">
<div class="">pi@raspberrypi:~ $ sudo systemctl stop vzlogger</div>
<div class=""> </div>
<div class="">Und den restore nochmal angeworfen. Aktuell läuft er noch, ich melde moich wieder.</div>
<div class="">Beste Grüße</div>
<div class=""> </div>
<div class="">JD.</div>
</div>
</div>
<div class="">
<div class="">
<div style="margin: 10.0px 5.0px 5.0px 10.0px;padding: 10.0px 0 10.0px 10.0px;border-left: 2.0px solid rgb(195,217,229);" class="">
<div style="margin: 0 0 10.0px 0;" class=""><b class="">Sent:</b> Wednesday, June 10, 2020 at 12:03 PM<br class="">
<b class="">From:</b> "Andreas Goetz" <<a href="mailto:cpuidle@gmail.com" onclick="parent.window.location.href='mailto:cpuidle@gmail.com'; return false;" target="_blank" class="">cpuidle@gmail.com</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;" target="_blank" class="">volkszaehler-users@demo.volkszaehler.org</a>><br class="">
<b class="">Subject:</b> Re: [vz-users] Bevorstehender Kartencrash</div>
<div class="">
<div class="">
<div class="">In dem Fall kannst Du den Restore Prozess einfach nochmal anstarten. Die große Tabelle ist data, die wird dann nur schrittweise kopiert.</div>
<div class=""> </div>
<div class="">Aber zur Sicherheit: Du hast nicht noch parallel vzlogger gegen die neue (Ziel-)Datenbank laufen? Es wundert mich doch sehr dass es da einen Deadlock in MySQL gibt.</div>
<div class=""> </div>
<div class="">Viele Grüße, </div>
<div class="">Andreas</div>
<div class=""> </div>
<div class="">
<blockquote class="">Am 10.06.2020 um 11:52 schrieb John Doe <<a href="mailto:johndoe@null.net" onclick="parent.window.location.href='mailto:johndoe@null.net'; return false;" target="_blank" class="">johndoe@null.net</a>>:<br class="">
</blockquote>
</div>
<blockquote class="">
<div class="">
<div style="font-family: Verdana;font-size: 12.0px;" class="">
<div class="">Schade, zu früh gefreut:</div>
<div class=""> </div>
<div class="">
<div class="">data: copying 29003424 rows (partial copy)<br class="">
[>---------------------------] 2% 3 mins/2 hrs 629000 rows<br class="">
In AbstractMySQLDriver.php line 34:<br class="">
<br class="">
An exception occurred while executing 'INSERT INTO `data` (`id`,`channel_id`,`timestamp`,`value`) VALUES (?,?,?,?)' with params [ <br class="">
"629070", "1", "1560170157864", "52342.2111"]: <br class="">
<br class="">
SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction <br class="">
</div>
<div class="">In PDOStatement.php line 119:<br class="">
<br class="">
SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction <br class="">
</div>
<div class="">In PDOStatement.php line 117:<br class="">
<br class="">
SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction <br class="">
</div>
<div class="">copy [-c|--config CONFIG] [-b|--batch BATCH] [-k|--keep-constraints] [--] [<tables>...]</div>
<div class=""> </div>
<div class="">Grüße</div>
<div class=""> </div>
<div class="">JD.</div>
</div>
<div class="">
<div class="">
<div style="margin: 10.0px 5.0px 5.0px 10.0px;padding: 10.0px 0 10.0px 10.0px;border-left: 2.0px solid rgb(195,217,229);" class="">
<div style="margin: 0 0 10.0px 0;" class=""><b class="">Sent:</b> Wednesday, June 10, 2020 at 11:49 AM<br class="">
<b class="">From:</b> "John Doe" <<a href="mailto:johndoe@null.net" onclick="parent.window.location.href='mailto:johndoe@null.net'; return false;" target="_blank" class="">johndoe@null.net</a>><br class="">
<b class="">To:</b> <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="">Subject:</b> Re: [vz-users] Bevorstehender Kartencrash</div>
<div class="">
<div style="font-family: Verdana;font-size: 12.0px;" class="">
<div class="">Hallo Andreas,</div>
<div class=""> </div>
<div class="">das sieht besser aus:</div>
<div class=""> </div>
<div class="">
<div class="">pi@raspberrypi:~/<a href="http://volkszaehler.org/" target="_blank" class="">volkszaehler.org</a> $ bin/doctrine orm:schema-tool:create</div>
<div class=""> ! <br class="">
! [CAUTION] This operation should not be executed in a production environment! <br class="">
! </div>
<div class=""> Creating database schema...</div>
<div class=""> <br class="">
[OK] Database schema created successfully! </div>
<div class=""> </div>
<div class="">Aktuell wird die Datenbank kopiert, daher melde ich mich in zwei Stunden mit dem Ergebnis.</div>
<div class="">Bis dahin erst mal tausend Dank !</div>
<div class="">Grüße</div>
<div class=""> </div>
<div class="">JD.</div>
</div>
<div class="">
<div class="">
<div style="margin: 10.0px 5.0px 5.0px 10.0px;padding: 10.0px 0 10.0px 10.0px;border-left: 2.0px solid rgb(195,217,229);" class="">
<div style="margin: 0 0 10.0px 0;" class=""><b class="">Sent:</b> Wednesday, June 10, 2020 at 11:34 AM<br class="">
<b class="">From:</b> "Andreas Goetz" <<a href="mailto:cpuidle@gmail.com" onclick="parent.window.location.href='mailto:cpuidle@gmail.com'; return false;" target="_blank" class="">cpuidle@gmail.com</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;" target="_blank" class="">volkszaehler-users@demo.volkszaehler.org</a>><br class="">
<b class="">Subject:</b> Re: [vz-users] Bevorstehender Kartencrash</div>
<div class="">
<div class="">OK, dann ohne das —force. Alternativ kannst Du auch (falls das Schema in Teilen existiert) ein inkrementelles Update machen:
<div class=""> </div>
<div class="">bin/doctrine orm:schema-tool:update
<div class=""> </div>
<div class="">Viele Grüße, Andreas</div>
<div class="">
<blockquote class="">
<div class="">On 10. Jun 2020, at 11:20, John Doe <<a href="mailto:johndoe@null.net" onclick="parent.window.location.href='mailto:johndoe@null.net'; return false;" target="_blank" class="">johndoe@null.net</a>> wrote:</div>
<div class="">
<div class="">
<div style="font-family: Verdana;font-size: 12.0px;" class="">
<div class="">Hallo Andreas,</div>
<div class=""> </div>
<div class="">gerne:</div>
<div class=""> </div>
<div class="">
<div class="">pi@raspberrypi:~/<a href="http://volkszaehler.org/" target="_blank" class="">volkszaehler.org</a> $ bin/doctrine orm:schema-tool:create --dump-sql</div>
<div class=""> The following SQL statements will be executed:</div>
<div class=""> CREATE TABLE aggregate (id INT AUTO_INCREMENT NOT NULL, channel_id INT DEFAULT NULL, type SMALLINT NOT NULL, timestamp BIGINT NOT NULL, value DOUBLE PRECISION NOT NULL, count INT NOT NULL, INDEX IDX_B77949FF72F5A1AA (channel_id), UNIQUE INDEX aggregate_unique (channel_id, type, timestamp), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;<br class="">
CREATE TABLE entities (id INT AUTO_INCREMENT NOT NULL, uuid VARCHAR(36) NOT NULL, type VARCHAR(255) NOT NULL, class VARCHAR(255) NOT NULL, UNIQUE INDEX UNIQ_50EC64E5D17F50A6 (uuid), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;<br class="">
CREATE TABLE entities_in_aggregator (parent_id INT NOT NULL, child_id INT NOT NULL, INDEX IDX_2BD88468727ACA70 (parent_id), INDEX IDX_2BD88468DD62C21B (child_id), PRIMARY KEY(parent_id, child_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;<br class="">
CREATE TABLE properties (id INT AUTO_INCREMENT NOT NULL, entity_id INT DEFAULT NULL, pkey VARCHAR(255) NOT NULL, value LONGTEXT NOT NULL, INDEX IDX_87C331C781257D5D (entity_id), UNIQUE INDEX property_unique (entity_id, pkey), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;<br class="">
CREATE TABLE data (id INT AUTO_INCREMENT NOT NULL, channel_id INT DEFAULT NULL, timestamp BIGINT NOT NULL, value DOUBLE PRECISION NOT NULL, INDEX IDX_ADF3F36372F5A1AA (channel_id), UNIQUE INDEX data_unique (channel_id, timestamp), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;<br class="">
ALTER TABLE aggregate ADD CONSTRAINT FK_B77949FF72F5A1AA FOREIGN KEY (channel_id) REFERENCES entities (id);<br class="">
ALTER TABLE entities_in_aggregator ADD CONSTRAINT FK_2BD88468727ACA70 FOREIGN KEY (parent_id) REFERENCES entities (id);<br class="">
ALTER TABLE entities_in_aggregator ADD CONSTRAINT FK_2BD88468DD62C21B FOREIGN KEY (child_id) REFERENCES entities (id);<br class="">
ALTER TABLE properties ADD CONSTRAINT FK_87C331C781257D5D FOREIGN KEY (entity_id) REFERENCES entities (id);<br class="">
ALTER TABLE data ADD CONSTRAINT FK_ADF3F36372F5A1AA FOREIGN KEY (channel_id) REFERENCES entities (id);</div>
<div class=""> </div>
<div class=""> </div>
<div class="">
<div class="">pi@raspberrypi:~/<a href="http://volkszaehler.org/" target="_blank" class="">volkszaehler.org</a> $ bin/doctrine orm:schema-tool:create —force</div>
<div class=""> <br class="">
Too many arguments, expected arguments "command". <br class="">
</div>
<div class="">orm:schema-tool:create [--dump-sql]</div>
<div class=""> </div>
<div class="">Grüße</div>
<div class=""> </div>
<div class="">JD.</div>
</div>
<div class=""> </div>
</div>
<div class="">
<div class="">
<div style="margin: 10.0px 5.0px 5.0px 10.0px;padding: 10.0px 0 10.0px 10.0px;border-left: 2.0px solid rgb(195,217,229);" class="">
<div style="margin: 0 0 10.0px 0;" class=""><b class="">Sent:</b> Wednesday, June 10, 2020 at 10:48 AM<br class="">
<b class="">From:</b> "Andreas Goetz" <<a href="mailto:cpuidle@gmail.com" onclick="parent.window.location.href='mailto:cpuidle@gmail.com'; return false;" target="_blank" class="">cpuidle@gmail.com</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;" target="_blank" class="">volkszaehler-users@demo.volkszaehler.org</a>><br class="">
<b class="">Subject:</b> Re: [vz-users] Bevorstehender Kartencrash</div>
<div class="">
<div class="">Mhhm, alles sehr merkwürdig. Versuch bitte nochmal das Schema im Ziel anzulegen:
<div class=""> </div>
<div class="">bin/<span style="font-family: Verdana;font-size: 12.0px;" class="">doctrine orm:schema-tool:create --dump-sql </span></div>
<div class=""> </div>
<div class=""><font face="Verdana" class=""><span style="font-size: 12.0px;" class="">Output bitte zeigen. Dann:</span></font></div>
<div class=""> </div>
<div class="">bin/<font face="Verdana" class=""><span style="font-size: 12.0px;" class="">doctrine orm:schema-tool:create —force</span></font></div>
<div class=""> </div>
<div class=""><font face="Verdana" class=""><span style="font-size: 12.0px;" class="">zum anlegen.</span></font></div>
<div class=""> </div>
<div class=""><font face="Verdana" class=""><span style="font-size: 12.0px;" class="">Vielen Dank, Andreas</span></font></div>
<div class="">
<div class="">
<div class="">
<blockquote class="">
<div class="">On 10. Jun 2020, at 10:44, John Doe <<a href="mailto:johndoe@null.net" onclick="parent.window.location.href='mailto:johndoe@null.net'; return false;" target="_blank" class="">johndoe@null.net</a>> wrote:</div>
<div class="">
<div class="">
<div style="font-family: Verdana;font-size: 12.0px;" class="">
<div class="">Hallo Andreas,</div>
<div class=""> </div>
<div class="">
<div class="">das scheint zunächst zu klappen:</div>
<div class=""> </div>
<div class="">pi@raspberrypi:~ $ /var/www/<a href="http://volkszaehler.org/vendor/bin/dbcopy" target="_blank" class="">volkszaehler.org/vendor/bin/dbcopy</a> create -c /etc/dbcopy.yaml<br class="">
Creating target schema<br class="">
Creating tables<br class="">
Updating schema assets for target platform compatibility: sqlite</div>
<div class=""> </div>
<div class="">Die dbcopy.yaml:</div>
<div class=""> </div>
<div class="">
<div class=""># DATABASE DEFINITION<br class="">
source:<br class="">
driver: pdo_mysql<br class="">
host: localhost<br class="">
user: vz<br class="">
password: demo<br class="">
dbname: volkszaehler</div>
<div class="">target:<br class="">
driver: pdo_sqlite<br class="">
host: localhost<br class="">
user: root<br class="">
password: raspberry<br class="">
dbname: volkszaehler_backup<br class="">
path: sqlite.db3 # path is only used if driver = pdo_sqlite<br class="">
<br class="">
# influxdb target database connection<br class="">
influx:<br class="">
dsn: <a class="">influxdb://localhost:8086</a><br class="">
dbname: volkszaehler<br class="">
measurement: data<br class="">
<br class="">
# TABLE DEFINITION<br class="">
# ----------------<br class="">
# tables will be processed in the order they are mentioned:<br class="">
# - foreign keys on target will be dropped<br class="">
# - if a table is not listed here, it will not be touched<br class="">
# transfer mode<br class="">
# skip: table will not be copied<br class="">
# copy: entire table will be truncated on target and copied from source<br class="">
# pk: selective copy by primary key. only data not present on target<br class="">
# will be copied from source.<br class="">
tables:<br class="">
entities: copy<br class="">
properties: copy<br class="">
entities_in_aggregator: copy<br class="">
data: pk<br class="">
aggregate: skip</div>
<div class=""> </div>
<div class="">Bei Vertauschung von sorec und target passiert leider das:</div>
<div class=""> </div>
<div class="">
<div class="">pi@raspberrypi:~ $ /var/www/<a href="http://volkszaehler.org/vendor/bin/dbcopy" target="_blank" class="">volkszaehler.org/vendor/bin/dbcopy</a> copy -c /etc/dbcopy.yaml</div>
<div class="">In CopyCommand.php line 49:<br class="">
<br class="">
Table entities doesn't exist.To create the schema run <br class="">
<br class="">
doctrine.php orm:schema-tool:create --dump-sql <br class="">
</div>
<div class="">copy [-c|--config CONFIG] [-b|--batch BATCH] [-k|--keep-constraints] [--] [<tables>...]</div>
<div class=""> </div>
<div class="">Hättest Du noch einen Tip, oder ist mein Backup verloren ?</div>
<div class="">Grüße</div>
<div class=""> </div>
<div class="">JD.</div>
</div>
</div>
</div>
<div class="">
<div class="">
<div style="margin: 10.0px 5.0px 5.0px 10.0px;padding: 10.0px 0 10.0px 10.0px;border-left: 2.0px solid rgb(195,217,229);" class="">
<div style="margin: 0 0 10.0px 0;" class=""><b class="">Sent:</b> Wednesday, June 10, 2020 at 10:35 AM<br class="">
<b class="">From:</b> "Andreas Goetz" <<a href="mailto:cpuidle@gmail.com" onclick="parent.window.location.href='mailto:cpuidle@gmail.com'; return false;" target="_blank" class="">cpuidle@gmail.com</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;" target="_blank" class="">volkszaehler-users@demo.volkszaehler.org</a>><br class="">
<b class="">Subject:</b> Re: [vz-users] Bevorstehender Kartencrash</div>
<div class="">
<div class="">Klar:
<div class=""> </div>
<div class="">
<div class="">❯ ./vendor/bin/dbcopy </div>
<div class="">Database backup tool</div>
<div class=""> </div>
<div class="">Usage:</div>
<div class=""> command [options] [arguments]</div>
<div class=""> </div>
<div class="">Options:</div>
<div class=""> -h, --help Display this help message.</div>
<div class=""> </div>
<div class="">Available commands:</div>
<div class=""> clear Clear target tables</div>
<div class=""> copy Run copy</div>
<div class=""> create Create target schema</div>
<div class=""> drop Drop target schema</div>
<div class=""> help Displays help for a command</div>
<div class=""> influx Copy data to InfluxDB</div>
<div class=""> list Lists commands</div>
<div class=""> </div>
<div class="">create wäre in diesem Fall das Kommando der Wahl!</div>
<div class=""> </div>
<div class="">Viele Grüße, Andreas</div>
<div class="">
<blockquote class="">
<div class="">On 10. Jun 2020, at 09:52, John Doe <<a href="mailto:johndoe@null.net" onclick="parent.window.location.href='mailto:johndoe@null.net'; return false;" target="_blank" class="">johndoe@null.net</a>> wrote:</div>
<div class="">
<div class="">
<div style="font-family: Verdana;font-size: 12.0px;" class="">
<div class="">Hallo zusammen,</div>
<div class=""> </div>
<div class="">ein</div>
<div class=""> </div>
<div class="">DROP DATABASE volkszaehler;</div>
<div class="">CREATE DATABASE volkszaehler;</div>
<div class=""> </div>
<div class="">hat nun leider zur Folge, das nach dem Wiederherstellen meines Backups mit</div>
<div class=""> </div>
<div class="">sudo /var/www/<a href="http://volkszaehler.org/vendor/bin/dbcopy" target="_blank" class="">volkszaehler.org/vendor/bin/dbcopy</a> copy -c /etc/dbcopy.yaml</div>
<div class=""> </div>
<div class="">meine Kanäle weg sind.</div>
<div class="">Hat noch jemand einen Tip, wie ich meine alten Daten wieder herstellen kann ?</div>
<div class="">Beste Grüße</div>
<div class=""> </div>
<div class="">JD.</div>
<div class=""> </div>
<div class=""> </div>
<div class="">
<div class="">
<div style="margin: 10.0px 5.0px 5.0px 10.0px;padding: 10.0px 0 10.0px 10.0px;border-left: 2.0px solid rgb(195,217,229);" class="">
<div style="margin: 0 0 10.0px 0;" class=""><b class="">Sent:</b> Tuesday, June 09, 2020 at 7:07 PM<br class="">
<b class="">From:</b> "Andreas Goetz" <<a href="mailto:cpuidle@gmail.com" onclick="parent.window.location.href='mailto:cpuidle@gmail.com'; return false;" target="_blank" class="">cpuidle@gmail.com</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;" target="_blank" class="">volkszaehler-users@demo.volkszaehler.org</a>><br class="">
<b class="">Subject:</b> Re: [vz-users] Bevorstehender Kartencrash</div>
<div class="">
<div class="">
<div class="">Sieht aus als wären die Daten schon vorhanden (duplicate key)- hattest Du die Zieldatenbank denn wieder leer gemacht?</div>
<div class=""> </div>
<div class="">Viele Grüße, Andreas </div>
<div class="">
<blockquote class="">Am 09.06.2020 um 19:02 schrieb John Doe <<a href="mailto:johndoe@null.net" onclick="parent.window.location.href='mailto:johndoe@null.net'; return false;" target="_blank" class="">johndoe@null.net</a>>:<br class="">
</blockquote>
</div>
<blockquote class="">
<div class="">
<div style="font-family: Verdana;font-size: 12.0px;" class="">
<div class="">Hallo Andreas,</div>
<div class=""> </div>
<div class="">es scheint prinzipiell am User, unabhängig vom PW zu liegen:</div>
<div class=""> </div>
<div class="">
<div class="">mysql -u root -h localhost volkszaehler<br class="">
ERROR 1698 (28000): Access denied for user 'root'@'localhost'</div>
<div class=""> </div>
<div class="">127.0.0.1 führt zum gleichen Ergebnis.</div>
<div class="">Mit</div>
<div class=""> </div>
<div class="">sudo mysql -u root -h localhost volkszaehler</div>
<div class=""> </div>
<div class="">klappt das Ganze. Leider hängt es nun hier:</div>
<div class=""> </div>
<div class="">
<div class="">data: copying 28925979 rows (partial copy)<br class="">
[>---------------------------] 0% < 1 sec/< 1 sec 0 rows<br class="">
In AbstractMySQLDriver.php line 55:<br class="">
<br class="">
An exception occurred while executing 'INSERT INTO `data` (`id`,`channel_id`,`timestamp`,`value`) VALUES (?, <br class="">
?,?,?)' with params ["77446", "1", "1559552806523", "52268.478"]: <br class="">
<br class="">
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '77446' for key 'PRIMARY' <br class="">
</div>
<div class="">In PDOStatement.php line 119:<br class="">
<br class="">
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '77446' for key 'PRIMARY' <br class="">
</div>
<div class="">In PDOStatement.php line 117:<br class="">
<br class="">
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '77446' for key 'PRIMARY' <br class="">
</div>
<div class="">copy [-c|--config CONFIG] [-b|--batch BATCH] [-k|--keep-constraints] [--] [<tables>...]</div>
<div class=""> </div>
<div class="">Grüße</div>
<div class=""> </div>
<div class="">JD.</div>
</div>
<div class=""> </div>
</div>
<div class="">
<div class="">
<div style="margin: 10.0px 5.0px 5.0px 10.0px;padding: 10.0px 0 10.0px 10.0px;border-left: 2.0px solid rgb(195,217,229);" class="">
<div style="margin: 0 0 10.0px 0;" class=""><b class="">Sent:</b> Tuesday, June 09, 2020 at 6:07 PM<br class="">
<b class="">From:</b> "Andreas Goetz" <<a href="mailto:cpuidle@gmail.com" onclick="parent.window.location.href='mailto:cpuidle@gmail.com'; return false;" target="_blank" class="">cpuidle@gmail.com</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;" target="_blank" class="">volkszaehler-users@demo.volkszaehler.org</a>><br class="">
<b class="">Subject:</b> Re: [vz-users] Bevorstehender Kartencrash</div>
<div class="">
<div class="">
<div class="">
<blockquote class="">
<div class="">On 9. Jun 2020, at 17:28, John Doe <<a href="mailto:johndoe@null.net" onclick="parent.window.location.href='mailto:johndoe@null.net'; return false;" target="_blank" class="">johndoe@null.net</a>> wrote:</div>
<div class="">
<div class="">
<div style="font-family: Verdana;font-size: 12.0px;" class="">
<div class="">Hallo Andreas,</div>
<div class=""> </div>
<div class="">das klappt nicht:</div>
<div class=""> </div>
<div class="">
<div class="">pi@raspberrypi:~ $ /var/www/<a href="http://volkszaehler.org/vendor/bin/dbcopy" target="_blank" class="">volkszaehler.org/vendor/bin/dbcopy</a> copy -c /etc/dbcopy.yaml</div>
<div class="">In AbstractMySQLDriver.php line 106:<br class="">
<br class="">
An exception occurred in driver: SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' <br class="">
</div>
<div class="">In PDOConnection.php line 31:<br class="">
<br class="">
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' <br class="">
</div>
<div class="">In PDOConnection.php line 27:<br class="">
<br class="">
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' <br class="">
</div>
<div class="">copy [-c|--config CONFIG] [-b|--batch BATCH] [-k|--keep-constraints] [--] [<tables>...]</div>
<div class=""> </div>
<div class=""> </div>
<div class="">Ich bin mir hundertprozentig sicher, dass die user/pw-Kombi stimmt ...</div>
</div>
</div>
</div>
</div>
</blockquote>
<div class=""> </div>
Das ist…. sehr unwahrscheinlich. Was passiert denn beim Login auf der Kommandozeile mit der gleichen Kombination (<a href="https://stackoverflow.com/questions/5131931/connecting-to-mysql-from-the-command-line" target="_blank" class="">https://stackoverflow.com/questions/5131931/connecting-to-mysql-from-the-command-line</a>)?</div>
<div class=""> </div>
<div class="">Evtl. liegt es auch an <a href="https://github.com/volkszaehler/volkszaehler.org/pull/799" target="_blank" class="">https://github.com/volkszaehler/volkszaehler.org/pull/799</a>? </div>
<div class=""> </div>
<div class="">Viele Grüße, Andreas</div>
<div class="">
<blockquote class="">
<div class="">
<div class="">
<div style="font-family: Verdana;font-size: 12.0px;" class="">
<div class="">
<div class="">Grüße</div>
<div class=""> </div>
<div class="">JD.</div>
</div>
<div class="">
<div class="">
<div style="margin: 10.0px 5.0px 5.0px 10.0px;padding: 10.0px 0 10.0px 10.0px;border-left: 2.0px solid rgb(195,217,229);" class="">
<div style="margin: 0 0 10.0px 0;" class=""><b class="">Sent:</b> Tuesday, June 09, 2020 at 5:18 PM<br class="">
<b class="">From:</b> "Andreas Goetz" <<a href="mailto:cpuidle@gmail.com" onclick="parent.window.location.href='mailto:cpuidle@gmail.com'; return false;" target="_blank" class="">cpuidle@gmail.com</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;" target="_blank" class="">volkszaehler-users@demo.volkszaehler.org</a>><br class="">
<b class="">Subject:</b> Re: [vz-users] Bevorstehender Kartencrash</div>
<div class="">
<div class="">Sieht nicht offensichtlich falsch aus. Falls sie im Backup ist könntest Du auch noch die aggregate Tabelle kopieren, anderenfalls müsstest Du die im Ziel neu erstellen, sinnigerweise bevor Du Aggregation wieder einschaltest (sonst könnten sich die SQL Queries dazu aufstapeln).
<div class=""> </div>
<div class="">Viele Grüße, Andreas</div>
<div class="">
<div class="">
<blockquote class="">
<div class="">On 9. Jun 2020, at 17:13, John Doe <<a href="mailto:johndoe@null.net" onclick="parent.window.location.href='mailto:johndoe@null.net'; return false;" target="_blank" class="">johndoe@null.net</a>> wrote:</div>
<div class="">
<div class="">
<div style="font-family: Verdana;font-size: 12.0px;" class="">
<div class="">Okay, letzte Frage: Passt das so, bevor ich starte?</div>
<div class=""> </div>
<div class="">
<div class=""># DATABASE DEFINITION<br class="">
source:<br class="">
#driver: pdo_mysql<br class="">
driver: pdo_sqlite<br class="">
#host: localhost<br class="">
#user: vz<br class="">
#password: demo<br class="">
#dbname: volkszaehler<br class="">
path: sqlite.db3<br class="">
target:<br class="">
driver: pdo_mysql<br class="">
host: localhost<br class="">
user: root<br class="">
password: raspberry<br class="">
dbname: volkszaehler<br class="">
#path: sqlite.db3 # path is only used if driver = pdo_sqlite</div>
<div class=""># influxdb target database connection<br class="">
influx:<br class="">
dsn: <a class="">influxdb://localhost:8086</a><br class="">
dbname: volkszaehler<br class="">
measurement: data</div>
<div class=""># TABLE DEFINITION<br class="">
# ----------------<br class="">
# tables will be processed in the order they are mentioned:<br class="">
# - foreign keys on target will be dropped<br class="">
# - if a table is not listed here, it will not be touched<br class="">
# transfer mode<br class="">
# skip: table will not be copied<br class="">
# copy: entire table will be truncated on target and copied from source<br class="">
# pk: selective copy by primary key. only data not present on target<br class="">
# will be copied from source.<br class="">
tables:<br class="">
entities: copy<br class="">
properties: copy<br class="">
entities_in_aggregator: copy<br class="">
data: pk<br class="">
aggregate: skip</div>
<div class=""> </div>
<div class=""> </div>
<div class="">Beste Grüße</div>
<div class=""> </div>
<div class="">JD.</div>
</div>
<div class="">
<div class="">
<div style="margin: 10.0px 5.0px 5.0px 10.0px;padding: 10.0px 0 10.0px 10.0px;border-left: 2.0px solid rgb(195,217,229);" class="">
<div style="margin: 0 0 10.0px 0;" class=""><b class="">Sent:</b> Tuesday, June 09, 2020 at 5:02 PM<br class="">
<b class="">From:</b> "Andreas Goetz" <<a href="mailto:cpuidle@gmail.com" onclick="parent.window.location.href='mailto:cpuidle@gmail.com'; return false;" target="_blank" class="">cpuidle@gmail.com</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;" target="_blank" class="">volkszaehler-users@demo.volkszaehler.org</a>><br class="">
<b class="">Subject:</b> Re: [vz-users] Bevorstehender Kartencrash</div>
<div class="">
<div class="">
<div class="">Ja genau- und mach auch von der „neuen“ Quelle vorher noch ein Backup! Better be safe than sorry...</div>
<div class=""> </div>
<div class="">Viele Grüße, Andreas</div>
<div class=""> </div>
<div class="">
<blockquote class="">Am 09.06.2020 um 17:00 schrieb John Doe <<a href="mailto:johndoe@null.net" onclick="parent.window.location.href='mailto:johndoe@null.net'; return false;" target="_blank" class="">johndoe@null.net</a>>:<br class="">
</blockquote>
</div>
<blockquote class="">
<div class="">
<div style="font-family: Verdana;font-size: 12.0px;" class="">
<div class="">Hallo Andreas,</div>
<div class=""> </div>
<div class="">danke für die schnelle Reaktion.</div>
<div class="">Dann opfere ich logischerweise den kleineren Datensatz.</div>
<div class="">Die GrundIdee mit dem Vertauschen von Quelle und Ziel klappt aber dann ?</div>
<div class="">Beste Grüße</div>
<div class=""> </div>
<div class="">JD.</div>
<div class="">
<div class="">
<div style="margin: 10.0px 5.0px 5.0px 10.0px;padding: 10.0px 0 10.0px 10.0px;border-left: 2.0px solid rgb(195,217,229);" class="">
<div style="margin: 0 0 10.0px 0;" class=""><b class="">Sent:</b> Tuesday, June 09, 2020 at 4:46 PM<br class="">
<b class="">From:</b> "Andreas Goetz" <<a href="mailto:cpuidle@gmail.com" onclick="parent.window.location.href='mailto:cpuidle@gmail.com'; return false;" target="_blank" class="">cpuidle@gmail.com</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;" target="_blank" class="">volkszaehler-users@demo.volkszaehler.org</a>><br class="">
<b class="">Subject:</b> Re: [vz-users] Bevorstehender Kartencrash</div>
<div class="">
<div class="">Hi,
<div class="">
<blockquote class="">
<div class="">On 9. Jun 2020, at 16:43, John Doe <<a href="mailto:johndoe@null.net" onclick="parent.window.location.href='mailto:johndoe@null.net'; return false;" target="_blank" class="">johndoe@null.net</a>> wrote:</div>
<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 class=""> </div>
Das kannst Du auf KEINEN Fall tun:</div>
<div class=""> </div>
<div class="">- es gibt keinen “merge” Prozess</div>
<div class="">- in beiden Datenbanken werden die gleichen IDs existieren</div>
<div class="">- die Entities werden bei Default Einstellungen überschrieben</div>
<div class=""> </div>
<div class="">—> vmtl. Desaster</div>
<div class=""> </div>
<div class="">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 class=""> </div>
<div class="">Viele Grüße, </div>
<div class="">Andreas</div>
<div class="">
<blockquote 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 style="margin: 10.0px 5.0px 5.0px 10.0px;padding: 10.0px 0 10.0px 10.0px;border-left: 2.0px solid rgb(195,217,229);" class="">
<div style="margin: 0 0 10.0px 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" onclick="parent.window.location.href='mailto:cpuidle@gmail.com'; return false;" target="_blank" class="">cpuidle@gmail.com</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;" target="_blank" class="">volkszaehler-users@demo.volkszaehler.org</a>><br class="">
<b class="">Subject:</b> Re: [vz-users] Bevorstehender Kartencrash</div>
<div 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>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div></div></div>
</blockquote></div><br class=""></body></html>