<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class="">Hi,</div><div class=""><br class=""></div><div class="">danke für deinen Tipp mit mysqldump. hat einwandfrei funktioniert und ist auch kein Problem</div><div class=""><br class=""></div><div class="">
<p style="margin-bottom: 0cm" class=""><font color="#000000" class="">mysqldump
-u root -p volkszaehler > sicherung.sql</font></p><div class="">Backup auf dem RPI erstellen</div>
<p style="margin-bottom: 0cm" class="">mysql -u root -p volkszaehler < sicherung.sql<font color="#000000" class=""><font class=""> </font></font>
</p></div><div class="">auf der Synology zurückspielen</div><div class=""><br class=""></div><div class="">DANKE</div><div class=""><br class=""></div><div class="">Daniel</div><div class=""><br class=""></div><div class=""><br class=""></div><br class=""><div><blockquote type="cite" class=""><div class="">Am 14.02.2016 um 11:39 schrieb Christian Schnellrieder <<a href="mailto:schnellrieder.cs@gmail.com" class="">schnellrieder.cs@gmail.com</a>>:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">Hallo:<div class=""><br class=""></div><div class=""><span style="font-size:13px;line-height:19.5px" class="">>Wie bekomme ich es hin damit er die Tabellen selbst anlegt oder muss >ich das alles händigt erledigen?</span></div><div class=""><br class=""></div><div class=""><span style="line-height:19.5px" class="">Ich hab die Datenbank auch umgesiedelt und hab einfach per mysqldump die gesamte Datenbank übertragen.</span></div><div class=""><span style="line-height:19.5px" class=""><br class=""></span></div><div class=""><span style="line-height:19.5px" class=""><br class=""></span></div><div class=""><span style="line-height:19.5px" class="">Grüße</span></div><div class=""><span style="line-height:19.5px" class=""><br class=""></span><div class="gmail_quote"><div dir="ltr" class="">Marius Tarlowski <<a href="mailto:marius@tarlowski.de" target="_blank" class="">marius@tarlowski.de</a>> schrieb am So., 14. Feb. 2016 um 11:31 Uhr:<br class=""></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><p dir="ltr" class="">Na gar nicht. Der vz logger kann keine Tabellen erstellen. <br class="">
Wozu auch? </p><p dir="ltr" class="">Du findest das Layout im Wiki unter Installation der middleware. Unter manuelle Installation </p><p dir="ltr" class="">Mfg, Marius Tarlowski<br class="">
(über mein Android geschrieben) </p>
<div class="gmail_quote">Am 14.02.2016 11:10 schrieb "News" <<a href="mailto:news@spider-wolf.de" target="_blank" class="">news@spider-wolf.de</a>>:<br type="attribution" class=""><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word" class="">Hallo,<div class=""><br class=""></div><div class="">ich habe meinem Volkszähler am laufen und wollte nun die Datenbank auf meiner Synology benutzten. </div><div class=""><br class=""></div><div class="">Hierzu habe ich folgende dinge gemacht:</div><div class="">- MariaDB und myphpadmin auf der Synology installiert</div><div class="">- auf myphpadmin eingeloggt und eine Datenbank „Volkszähler“ erstellt und dort einen Benutzer erstellt der auf diese Datenbank volle Zugriffsrechte hat </div><div class="">- in der Datei /var/www/<a href="http://volkszaehler.org/etc/volkszaehler.php.conf" target="_blank" class="">volkszaehler.org/etc/volkszaehler.php.conf</a> folgende Sachen geändert</div><div class=""><br class=""></div><div class="">Benutzer und Passwort natürlich geändert (:</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class=""> * PDO driver for Doctrine DBAL</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class=""> *</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class=""> * See Doctrine doc for details: <a href="http://www.doctrine-project.org/projects/dbal/2.0/docs/reference/configuration/en#getting-a-connection:driver" target="_blank" class="">http://www.doctrine-project.org/projects/dbal/2.0/docs/reference/configuration/en#getting-a-connection:driver</a></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class=""> */</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)" class="">$config['db']['driver'] = 'pdo_mysql';</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0);min-height:15px" class=""><br class=""></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class="">/**</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class=""> * Hostname of database server</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class=""> *</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class=""> * Use 'localhost' for the machine your webserver is running on.</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class=""> * See Doctrine doc for details: <a href="http://www.doctrine-project.org/projects/dbal/2.0/docs/reference/configuration/en" target="_blank" class="">http://www.doctrine-project.org/projects/dbal/2.0/docs/reference/configuration/en</a></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class=""> */</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)" class="">$config['db']['host'] = '192.168.0.100';</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0);min-height:15px" class=""><br class=""></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class="">/**</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class=""> * Username for the database server</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class=""> *</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class=""> * See Doctrine doc for details: <a href="http://www.doctrine-project.org/projects/dbal/2.0/docs/reference/configuration/en" target="_blank" class="">http://www.doctrine-project.org/projects/dbal/2.0/docs/reference/configuration/en</a></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class=""> */</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)" class="">$config['db']['user'] = ‚USER';</div><div class=""><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class="">**</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class=""> * Password for the database server</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class=""> *</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class=""> * See Doctrine doc for details: <a href="http://www.doctrine-project.org/projects/dbal/2.0/docs/reference/configuration/en" target="_blank" class="">http://www.doctrine-project.org/projects/dbal/2.0/docs/reference/configuration/en</a></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class=""> */</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)" class="">$config['db']['password'] = ‚PASSWORD';</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0);min-height:15px" class=""><br class=""></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class="">/**</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class=""> * @var string database name</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class=""> *</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class=""> * See Doctrine doc for details: <a href="http://www.doctrine-project.org/projects/dbal/2.0/docs/reference/configuration/en" target="_blank" class="">http://www.doctrine-project.org/projects/dbal/2.0/docs/reference/configuration/en</a></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class=""> */</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)" class="">$config['db']['dbname'] = 'Volkszaehler';</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0);min-height:15px" class=""><br class=""></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class="">/**</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class=""> * @var database connection encoding - should not be changed</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class=""> *</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class=""> * See <a href="http://stackoverflow.com/questions/13399912/symfony2-charset-for-queries-parameters" target="_blank" class="">http://stackoverflow.com/questions/13399912/symfony2-charset-for-queries-parameters</a></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(83,48,225);background-color:rgb(0,0,0)" class=""> */</div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0)" class="">$config['db']['charset'] = 'UTF8';</div></div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">in der vzlogger.log bekomme ich folgende Meldung</div><div class=""><div class="">[[Feb 14 10:59:26][s0] Reading S0 - returning 2 readings (n=1 n_neg = 0)</div><div class="">[Feb 14 10:59:26][mtr0] Got 2 new readings from meter:</div><div class="">[Feb 14 10:59:26][mtr0] Reading: id=Power/StringItentifier: value=262.62 ts=1455443966918</div><div class="">[Feb 14 10:59:26][mtr0] Reading: id=Impulse/StringItentifier: value=1.00 ts=1455443966918</div><div class="">[Feb 14 10:59:26][chn0] Adding reading to queue (value=1.00 ts=1455443966918)</div><div class="">[Feb 14 10:59:26][SUM] 1.000000 @ 1455443966918</div><div class="">[Feb 14 10:59:26][SUM] RESULT 1.000000 @ 1455443966918</div><div class="">[Feb 14 10:59:26][chn0] ==> number of tuples: 1</div><div class="">[Feb 14 10:59:26][chn0] compare: 1455443953210 1455443966918</div><div class="">[Feb 14 10:59:26][chn0] JSON request body: [ [ 1455443966918, 1 ] ]</div><div class="">[Feb 14 10:59:26][chn0] CURL: Hostname was found in DNS cache</div><div class="">[Feb 14 10:59:26][chn0] CURL: Trying 127.0.0.1...</div><div class="">[Feb 14 10:59:26][chn0] CURL: Connected to 127.0.0.1 (127.0.0.1) port 80 (#39)</div><div class="">[Feb 14 10:59:26][chn0] Buffer dump (size=0): {}</div><div class="">[Feb 14 10:59:26][chn0] CURL: Sent 24 bytes.. </div><div class="">[Feb 14 10:59:26][chn0] CURL: Sent '[ [ 1455443966918, 1 ] ]' bytes</div><div class="">[Feb 14 10:59:26][chn0] CURL: upload completely sent off: 24 out of 24 bytes</div><div class="">[Feb 14 10:59:27][chn0] CURL: HTTP 1.0, assume close after body</div><div class="">[Feb 14 10:59:27][S0] MeterS0:HWIF_GPIO:first poll returned 0</div><div class="">[Feb 14 10:59:27][chn0] CURL: Received 598 bytes</div><div class=""><font color="#ff2600" class="">[Feb 14 10:59:27][chn0] CURL: Received '{"version":"0.3","exception":{"message":"An exception occurred while executing </font></div><div class=""><font color="#ff2600" class="">'SELECT e0_.id AS id0, e0_.uuid AS uuid1, e0_.type AS type2, p1_.id AS id3, p1_.pkey AS pkey4, p1_.value AS value5, </font></div><div class=""><font color="#ff2600" class="">e0_.class AS class6, p1_.entity_id AS entity_id7 FROM entities e0_ LEFT JOIN properties p1_ ON e0_.id = p1_.entity_id </font></div><div class=""><font color="#ff2600" class="">WHERE (e0_.uuid = ?) AND e0_.class IN ('channel', 'aggregator') ORDER BY p1_.pkey ASC' with params </font></div><div class=""><font color="#ff2600" class="">[\"bb9dd5f0-d267-11e5-8d0c-5bb1b6a29b44\"]:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table </font></div><div class=""><font color="#ff2600" class="">'Volkszaehler.entities' doesn't exist","type":"TableNotFoundException","code":0}}' bytes</font></div><div class="">[Feb 14 10:59:27][chn0] CURL: Closing connection 39</div><div class="">[Feb 14 10:59:27][chn0] CURL Request succeeded with code: 200</div><div class="">[Feb 14 10:59:27][S0] MeterS0:HWIF_GPIO:first poll returned 0</div><div class="">[Feb 14 10:59:27][S0] MeterS0:HWIF_GPIO:first poll returned 0</div><div class="">[Feb 14 10:59:28][S0] MeterS0:HWIF_GPIO:first poll returned 0</div><div class="">[Feb 14 10:59:28][S0] MeterS0:HWIF_GPIO:first poll returned 0</div><div class="">[Feb 14 10:59:28][S0] MeterS0:HWIF_GPIO:first poll returned 0</div><div class="">[Feb 14 10:59:29][S0] MeterS0:HWIF_GPIO:first poll returned 0</div><div class="">[Feb 14 10:59:29][S0] MeterS0:HWIF_GPIO:first poll returned 0</div><div class="">[Feb 14 10:59:29][S0] MeterS0:HWIF_GPIO:first poll returned 0</div><div class="">[Feb 14 10:59:30][S0] MeterS0:HWIF_GPIO:first poll returned 0</div><div class="">[Feb 14 10:59:30][S0] MeterS0:HWIF_GPIO:first poll returned 0</div><div class="">[Feb 14 10:59:30][S0] MeterS0:HWIF_GPIO:first poll returned 0</div><div class="">[Feb 14 10:59:31][S0] MeterS0:HWIF_GPIO:first poll returned 0</div><div class="">[Feb 14 10:59:31][S0] MeterS0:HWIF_GPIO:first poll returned 0</div><div class="">[Feb 14 10:59:31][S0] MeterS0:HWIF_GPIO:first poll returned 0</div><div class="">[Feb 14 10:59:32][S0] MeterS0:HWIF_GPIO:first poll returned 0</div><div class="">[Feb 14 10:59:32][S0] MeterS0:HWIF_GPIO:first poll returned 0</div><div class="">[Feb 14 10:59:32][S0] MeterS0:HWIF_GPIO:first poll returned 0</div></div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">Wie bekomme ich es hin damit er die Tabellen selbst anlegt oder muss ich das alles händigt erledigen?</div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">Danke</div><div class=""><br class=""></div><div class="">Daniel</div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div></div></blockquote></div>
</blockquote></div></div></div>
</div></blockquote></div><br class=""></body></html>