<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=""><div class="">Die SQL Statements unten zeigen, dass auch dem Raspi laut Config keine Datenbank vorhanden ist. Du willst sicher auch nicht :create, sondern :update.</div><div class=""><br class=""></div><div class="">Da Du —dump-sql angegeben hast macht das genau das: die Befehle ausgeben. Nicht mehr und nichts an der Datenbank.</div><div class=""><div><br class=""></div><div>Ich würde wie Daniel vorschlagen, bitte mal in den alten Postings zu schauen. 2x über x Postings durch den ganzen Prozess zu gehen erscheint doch ein wenig over-supported ;)</div><div class=""><br class=""></div><div class="">Viele Grüße, Andreas</div><div class=""><br class=""><blockquote type="cite" class=""><div class="">On 8. Nov 2020, at 17:32, 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="">ein</div>
<div class=""> </div>
<div class="">
<div class="">pi@raspberrypi:~ $ php /var/www/<a href="http://volkszaehler.org/bin/doctrine" class="">volkszaehler.org/bin/doctrine</a> 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=""><br class="">
ist fehlerfrei durchgelaufen. An dem aggregate-Problem ändert das leider nichts ....</div>
<div class="">Was könnte ich noch versuchen ?</div>
<div class=""> </div>
<div class="">Bevor Du fragst:</div>
<div class=""> </div>
<div class="">
<div class="">pi@raspberrypi:~ $ php /var/www/<a href="http://volkszaehler.org/bin/doctrine" class="">volkszaehler.org/bin/doctrine</a> orm:schema-tool:create --force</div>
<div class=""> <br class="">
The "--force" option does not exist. <br class="">
</div>
<div class=""><br class="">
Beste Grüße</div>
<div class=""> </div>
<div class="">JD.</div>
</div>
</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> Sunday, November 08, 2020 at 4:53 PM<br class="">
<b class="">From:</b> "Andreas Götz" <<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] Neubeginn nach Kartencrash</div>
<div name="quoted-content" class="">
<div class="">Bis Du sicher, dass Deine Zieldatwnvank auch Indizes hat? Beim Restore werden die gelöscht um nicht an temporär Fehlenden Relationen zu scheitern.
<div class=""> </div>
<div class="">Hatten wir vmtl. auch schon: das Zauberwergzeug heisst orm schema-tool. <br class="">
<div class="">Viele Grüße,
<div class="">Andreas</div>
</div>
<div class="">
<blockquote class="">Am 08.11.2020 um 16:25 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 zusammen,</div>
<div class=""> </div>
<div class="">mea culpa. Ihr hattet natürlich recht - ich musste mein Backup natürlich noch in die neu creierte Datenbank füllen.</div>
<div class="">Habe jetzt alles soweit wieder am Laufen - bis auf eine Kleinigkeit: Ich bekomme aggregate nicht zum Laufen.</div>
<div class=""> </div>
<div class="">vzlogger ist gestopt:</div>
<div class=""> </div>
<div class="">
<div class="">pi@raspberrypi:~ $ sudo systemctl status vzlogger.service<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 Sun 2020-11-08 16:16:42 CET; 5min ago<br class="">
Process: 729 ExecStart=/usr/local/bin/vzlogger -c /etc/vzlogger.conf (code=killed, signal=KILL)<br class="">
Main PID: 729 (code=killed, signal=KILL)</div>
<div class="">Nov 08 16:14:49 raspberrypi systemd[1]: Started vzlogger.<br class="">
Nov 08 16:15:01 raspberrypi systemd[1]: Stopping vzlogger...<br class="">
Nov 08 16:16:42 raspberrypi systemd[1]: vzlogger.service: State 'stop-sigterm' timed out. Killing.<br class="">
Nov 08 16:16:42 raspberrypi systemd[1]: vzlogger.service: Killing process 729 (vzlogger) with signal SIGKILL.<br class="">
Nov 08 16:16:42 raspberrypi systemd[1]: vzlogger.service: Main process exited, code=killed, status=9/KILL<br class="">
Nov 08 16:16:42 raspberrypi systemd[1]: vzlogger.service: Failed with result 'timeout'.<br class="">
Nov 08 16:16:42 raspberrypi systemd[1]: Stopped vzlogger.</div>
<div class=""> </div>
<div class="">cron ist gestopt:</div>
<div class=""> </div>
<div class="">
<div class="">pi@raspberrypi:~ $ sudo systemctl status cron.service<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: inactive (dead) since Sun 2020-11-08 16:14:56 CET; 8min ago<br class="">
Docs: man:cron(8)<br class="">
Process: 407 ExecStart=/usr/sbin/cron -f $EXTRA_OPTS (code=killed, signal=TERM)<br class="">
Main PID: 407 (code=killed, signal=TERM)</div>
<div class="">Nov 08 16:14:35 raspberrypi systemd[1]: Started Regular background program processing daemon.<br class="">
Nov 08 16:14:35 raspberrypi cron[407]: (CRON) INFO (pidfile fd = 3)<br class="">
Nov 08 16:14:35 raspberrypi cron[407]: (CRON) INFO (Running @reboot jobs)<br class="">
Nov 08 16:14:56 raspberrypi systemd[1]: Stopping Regular background program processing daemon...<br class="">
Nov 08 16:14:56 raspberrypi systemd[1]: cron.service: Main process exited, code=killed, status=15/TERM<br class="">
Nov 08 16:14:56 raspberrypi systemd[1]: cron.service: Succeeded.<br class="">
Nov 08 16:14:56 raspberrypi systemd[1]: Stopped Regular background program processing daemon.</div>
<div class=""> </div>
<div class=""> </div>
<div class="">aggregate:</div>
<div class=""> </div>
<div class="">
<div class="">php /var/www/<a href="http://volkszaehler.org/bin/aggregate" class="">volkszaehler.org/bin/aggregate</a> run -m full -l day -l hour -l minute<br class="">
Performing 'full' aggregation on 'day' level</div>
<div class=""> [>---------------------------] 0% < 1 sec/< 1 sec 0 channels</div>
<div class=""> </div>
</div>
<div class="">
<div class="">An diesem Zustand ändert sich über lange Zeit nichts.</div>
<div class=""> </div>
<div class="">Hat jemand einen Tip, woran das liegen könnte ?</div>
<div class=""> </div>
<div class="">Beste Grüße und Dank</div>
<div class=""> </div>
<div class="">JD.</div>
<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> Sunday, November 08, 2020 at 11:19 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] Neubeginn nach Kartencrash</div>
<div class="">
<div class="">
<div class="">Also mit create hast Du das Datenbankschema angelegt, das ist aber leer. Du musst auch die Daten noch reinkopieren ;)</div>
<div class=""> </div>
<div class="">Viele Grüße, Andreas </div>
<div class="">
<blockquote class="">Am 08.11.2020 um 11:05 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="">ich bin ein Stück weiter.</div>
<div class="">Ein</div>
<div class=""> </div>
<div class="">sudo apt-get install php-sqlite3</div>
<div class=""> </div>
<div class="">liess das</div>
<div class="">
<div class="">
<div class="">sudo /var/www/<a href="http://volkszaehler.org/vendor/bin/dbcopy" class="">volkszaehler.org/vendor/bin/dbcopy</a> create -c /etc/dbcopy.yaml</div>
<div class=""> </div>
<div class="">fehlerfrei durchlaufen.</div>
<div class="">Allerdings scheint mir das Wiedereinspielen der gesicherten Datenbank (natürlich mit sqlite.db3 als source) irgendwie nichts zu finden:</div>
<div class=""> </div>
<div class="">
<div class="">pi@raspberrypi:~ $ sudo /var/www/<a href="http://volkszaehler.org/vendor/bin/dbcopy" class="">volkszaehler.org/vendor/bin/dbcopy</a> copy -c /etc/dbcopy.yaml<br class="">
entities: copying 0 rows (overwrite)<br class="">
0 [>---------------------------] < 1 sec 4.0 MiB</div>
<div class="">properties: copying 0 rows (overwrite)<br class="">
0 [>---------------------------] < 1 sec 4.0 MiB</div>
<div class="">entities_in_aggregator: copying 0 rows (overwrite)<br class="">
0 [>---------------------------] < 1 sec 4.0 MiB</div>
<div class="">data: copying 0 rows (partial copy)<br class="">
0 [>---------------------------] < 1 sec 4.0 MiB</div>
<div class=""> </div>
<div class="">Hättest Du eine Idee, woran das liegen kann ?</div>
<div class="">Beste Grüße</div>
<div class=""> </div>
<div class="">JD:</div>
</div>
<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> Saturday, November 07, 2020 at 8:10 PM<br class="">
<b class="">From:</b> "Andreas Götz" <<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] Neubeginn nach Kartencrash</div>
<div class="">
<div class="">Ist ohne Deine Datei schwer zu sagen...<br class="">
<div class="">Viele Grüße,
<div class="">Andreas</div>
</div>
<div class="">
<blockquote class="">Am 07.11.2020 um 18:12 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=""> </div>
<div class=""><br class="">
Hallo zusammen,</div>
<div class=""> </div>
<div class="">da ich mir leider doch das Vorgehen vom letzten Mal nicht notiert habe, fehlt mir jetzt wieder der Einstieg.</div>
<div class="">Ich habe</div>
<div class=""> </div>
<div class="">- eine Kopie sqlite.db3 der Datenbank</div>
<div class="">- eine Kopie der vzlogger.conf</div>
<div class="">- eine Kopie der dbcopy.yaml, mir der ich die Datenbank-Kopie erstellt habe.</div>
<div class=""> </div>
<div class="">Ich habe</div>
<div class=""> </div>
<div class="">- das aktuelle VZ-Image installiert und mit Updates versehen</div>
<div class="">- die Kopie sqlite.dpb3 in das neue Home-Verzeichnis kopiert</div>
<div class="">- die gesicherte vzlogger.conf und dbcopy.yaml nach /etc kopiert.</div>
<div class=""> </div>
<div class="">Ein Aufruf von</div>
<div class=""> </div>
<div class="">sudo /var/www/<a href="http://volkszaehler.org/vendor/bin/dbcopy" class="">volkszaehler.org/vendor/bin/dbcopy</a> create -c /etc/dbcopy.yaml</div>
<div class=""> </div>
<div class="">bringt</div>
<div class=""> </div>
<div class="">
<div class="">Creating target schema<br class="">
PHP Notice: Undefined variable: schema in /home/pi/<a href="http://volkszaehler.org/vendor/andig/dbcopy/src/Command/CreateCommand.php" class="">volkszaehler.org/vendor/andig/dbcopy/src/Command/CreateCommand.php</a> on line 155<br class="">
PHP Fatal error: Uncaught Error: Call to a member function toSql() on null in /home/pi/<a href="http://volkszaehler.org/vendor/andig/dbcopy/src/Command/CreateCommand.php:155" class="">volkszaehler.org/vendor/andig/dbcopy/src/Command/CreateCommand.php:155</a><br class="">
Stack trace:<br class="">
#0 /home/pi/<a href="http://volkszaehler.org/vendor/symfony/console/Command/Command.php" class="">volkszaehler.org/vendor/symfony/console/Command/Command.php</a>(255): DatabaseCopy\Command\CreateCommand->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))<br class="">
#1 /home/pi/<a href="http://volkszaehler.org/vendor/symfony/console/Application.php" class="">volkszaehler.org/vendor/symfony/console/Application.php</a>(921): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))<br class="">
#2 /home/pi/<a href="http://volkszaehler.org/vendor/symfony/console/Application.php" class="">volkszaehler.org/vendor/symfony/console/Application.php</a>(273): Symfony\Component\Console\Application->doRunCommand(Object(DatabaseCopy\Command\CreateCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))<br class="">
#3 /home/pi/<a href="http://volkszaehler.org/vendor/symfony/console/Application.php" class="">volkszaehler.org/vendor/symfony/console/Application.php</a>(149): Symfony\Component\Console\Application->doRun(Object(Symfony\Co in /home/pi/<a href="http://volkszaehler.org/vendor/andig/dbcopy/src/Command/CreateCommand.php" class="">volkszaehler.org/vendor/andig/dbcopy/src/Command/CreateCommand.php</a> on line 155</div>
<div class=""> </div>
<div class=""> </div>
<div class="">Was mache ich denn diesmal wieder falsch ?</div>
<div class="">Beste Grüße</div>
<div class=""> </div>
<div class="">JD.</div>
</div>
</div>
</div>
</blockquote>
</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></blockquote></div><br class=""></div></body></html>