<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="">Servus,<div class=""><br class=""><div><blockquote type="cite" class=""><div class="">On 6 Dec 2016, at 21:31, Theo <<a href="mailto:geocaching.theo@me.com" class="">geocaching.theo@me.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; " class="">Hi,<div class=""><br class=""></div><div class="">also ich hab die dbcopy.json um die drei zeilen erleichtert und habe dbcopy upgedatet. Hab ich doch mit sudo git pull richtig gemacht, oder? </div></div></div></blockquote><div><br class=""></div>git pull sollte reichen. Davon ab- wie gesagt gibt es schon ein dbcopy im vz Ordner. Dann reicht composer update.</div><div><br class=""><blockquote type="cite" class=""><div class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; " class=""><div class="">composer sagte mir das nix zum installieren oder updaten da ist.</div></div></div></blockquote><div><br class=""></div>Wenn du’s im dbcopy Ordner ausführst, ja. Im vz Ordner hätte das geklappt.</div><div><br class=""><blockquote type="cite" class=""><div class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; " class=""><div class=""><br class=""></div><div class="">Aber ein erneutes erstellen der Zieldatenbank führte zu folgendem:</div><div class=""><br class=""></div><div class=""><div class="">pi@raspberrypi:/var/www/<a href="http://volkszaehler.org/vendor/andig/dbcopy" class="">volkszaehler.org/vendor/andig/dbcopy</a> $ /var/www/<a href="http://volkszaehler.org/vendor/bin/dbcopy.php" class="">volkszaehler.org/vendor/bin/dbcopy.php</a> create -c /etc/dbcopy.json</div><div class="">Creating target schema</div><div class="">Creating tables</div><div class="">Updating schema assets for target platform compatibility: sqlite</div><div class="">table: aggregate</div><div class="">table: data</div><div class="">table: entities</div><div class="">table: entities_in_aggregator</div><div class="">table: properties</div><div class="">CREATE TABLE aggregate (id INTEGER NOT NULL, channel_id INTEGER NOT NULL, type BOOLEAN NOT NULL, timestamp BIGINT NOT NULL, value DOUBLE PRECISION NOT NULL, count INTEGER NOT NULL, PRIMARY KEY(id))</div><div class="">CREATE UNIQUE INDEX ts_uniq ON aggregate (channel_id, type, timestamp)</div><div class="">CREATE TABLE data (id INTEGER NOT NULL, channel_id INTEGER DEFAULT NULL, timestamp BIGINT NOT NULL, value DOUBLE PRECISION NOT NULL, PRIMARY KEY(id), CONSTRAINT FK_ADF3F36372F5A1AA FOREIGN KEY (channel_id) REFERENCES entities (id) NOT DEFERRABLE INITIALLY IMMEDIATE)</div><div class="">CREATE UNIQUE INDEX data_unique ON data (channel_id, timestamp)</div><div class="">CREATE INDEX IDX_ADF3F36372F5A1AA ON data (channel_id)</div><div class="">CREATE TABLE entities (id INTEGER NOT NULL, uuid VARCHAR(36) NOT NULL, type VARCHAR(255) NOT NULL, class VARCHAR(255) NOT NULL, PRIMARY KEY(id))</div><div class="">CREATE UNIQUE INDEX UNIQ_50EC64E5D17F50A6 ON entities (uuid)</div><div class="">CREATE TABLE entities_in_aggregator (parent_id INTEGER NOT NULL, child_id INTEGER NOT NULL, PRIMARY KEY(parent_id, child_id), CONSTRAINT FK_2BD88468727ACA70 FOREIGN KEY (parent_id) REFERENCES entities (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_2BD88468DD62C21B FOREIGN KEY (child_id) REFERENCES entities (id) NOT DEFERRABLE INITIALLY IMMEDIATE)</div><div class="">CREATE INDEX IDX_2BD88468727ACA70 ON entities_in_aggregator (parent_id)</div><div class="">CREATE INDEX IDX_2BD88468DD62C21B ON entities_in_aggregator (child_id)</div><div class="">CREATE TABLE properties (id INTEGER NOT NULL, entity_id INTEGER DEFAULT NULL, pkey VARCHAR(255) NOT NULL, value CLOB NOT NULL, PRIMARY KEY(id), CONSTRAINT FK_87C331C781257D5D FOREIGN KEY (entity_id) REFERENCES entities (id) NOT DEFERRABLE INITIALLY IMMEDIATE)</div><div class="">CREATE UNIQUE INDEX property_unique ON properties (entity_id, pkey)</div><div class="">CREATE INDEX IDX_87C331C781257D5D ON properties (entity_id)</div><div class=""> </div><div class=""> [Doctrine\DBAL\Exception\ReadOnlyException] </div><div class=""> An exception occurred while executing 'CREATE TABLE aggregate (id INTEGER NO </div><div class=""> T NULL, channel_id INTEGER NOT NULL, type BOOLEAN NOT NULL, timestamp BIGINT </div><div class=""> NOT NULL, value DOUBLE PRECISION NOT NULL, count INTEGER NOT NULL, PRIMARY </div><div class=""> KEY(id))': </div><div class=""> SQLSTATE[HY000]: General error: 8 attempt to write a readonly database </div><div class=""> </div><div class=""><br class=""></div><div class=""> </div><div class=""> [Doctrine\DBAL\Driver\PDOException] </div><div class=""> SQLSTATE[HY000]: General error: 8 attempt to write a readonly database </div><div class=""> </div><div class=""><br class=""></div><div class=""> </div><div class=""> [PDOException] </div><div class=""> SQLSTATE[HY000]: General error: 8 attempt to write a readonly database </div><div class=""> </div><div class=""><br class=""></div><div class="">scheinbar ist die zieldatenbank readonly. Aber wo und wie kann ich das fixen?</div></div></div></div></blockquote><div><br class=""></div>Wo liegt denn die Datei? Was greift parallel darauf zu? Welche Rechte haben Datei und Du? Aus Versehen beim ersten mal als root erstellt?</div><div><br class=""></div><div>Suche erstmal nach den logischen Ursachen für eine nicht schreibbare Datei ;)</div><div><br class=""></div><div>Viele Grüße, Andreas</div><div><br class=""><blockquote type="cite" class=""><div class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; " class=""><div class=""><div class=""><br class=""></div><div class="">Gruß Tobias</div><div class=""><div class="">Am 06.12.2016 um 19:26 schrieb Andreas Goetz:</div><br class="Apple-interchange-newline"><blockquote type="cite" class=""><div dir="ltr" class=""><div class=""><div class="">Deine Config funktioniert genau so. Auf der SQlite Seite kannst Du Dir die Punkte sparen:<br class=""><br class=""><div style="margin:0px;font:12px helvetica" class=""> "host": "localhost",</div><div style="margin:0px;font:12px helvetica" class=""> "user": "vz",</div><div style="margin:0px;font:12px helvetica" class=""> "password": "xxx"</div><br class=""><br class="">Leider gabs einen Fehler in dbcopy, den hab ich gerade gefixt.<br class=""><br class=""></div>Viele Grüße,<br class=""></div>Andreas<br class=""><br class=""></div><div class="gmail_extra"><br class=""><div class="gmail_quote">2016-12-06 18:26 GMT+01:00 Theo <span dir="ltr" class=""><<a href="mailto:geocaching.theo@me.com" target="_blank" class="">geocaching.theo@me.com</a>></span>:<br 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="">genau das ist es ja was ich wissen will, habe doch jetzt mehrfach geschrieben das ich nicht weiß was ich bei path angeben muss.</div><div class=""><br class=""></div><div class="">Aber hier ist nochmal die komplette dbcopy.json </div><div class=""><br class=""></div><div class=""><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class="">{</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> "source": {</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> // source database connection</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> "driver": "pdo_mysql",</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> "host": "localhost",</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> "user": "vz",</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> "password": "xxx",</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> "dbname": "volkszaehler"</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> },</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> "target": {</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> // target database connection</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> "driver": "pdo_sqlite",</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> "path": "sqlite.db3", // path is only used if driver =$</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> "host": "localhost",</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> "user": "vz",</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> "password": "xxx"</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> // "dbname": "backup"</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> },</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> "tables": [</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> // table configuration (optional)</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> // ------------------------------</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> // table name</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> // tables will be processed in the order they are m$</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> // - foreign keys on target will be dropped</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> // - if a table is not listed here, it will not be $</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> // transfer mode</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> // skip: table will not be copied</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> // copy: entire table will be truncated o$</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> // pk: selective copy by primar$</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> // will be copied f$</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> {</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> "name": "entities",</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> "mode": "copy"</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> }, {</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> "name": "properties",</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> "mode": "copy"</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> }, {</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> "name": "entities_in_aggregator",</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> "mode": "copy"</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> }, {</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> "name": "data",</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> <span class="m_4576883737686655469Apple-tab-span" style="white-space:pre-wrap"> </span> "mode": "pk"</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> }, {</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> "name": "aggregate",</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> "mode": "skip"</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> }</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""> ]</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class="">}</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""><br class=""></div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class="">ein andere Problem das ich habe, ich wollte für die Zukunft composer global aufrufbar machen, damit mir das gezuchtel erspart bleibt. dazu hab ich wie auf <span class="m_4576883737686655469Apple-style-span" style="font-size: 14px;"><a href="https://getcomposer.org/doc/00-intro.md#globally" target="_blank" class="">https://getcomposer.org/<wbr class="">doc/00-intro.md#globally</a> <wbr class="">beschrieben die copmposer.phar in den Ordner /usr/local/bin/ verschoben. Aber wenn ich dann z.b. bei /var/www/<a href="http://voklszaehler.org/vendor/andig/dbcopy" target="_blank" class="">voklszaehler.org/<wbr class="">vendor/andig/dbcopy</a> composer aufrufen möchte mit z.b. composer update, bekomme ich die Meldung -bash: composer: command not found</span></div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""><font class="m_4576883737686655469Apple-style-span" size="3"><br class=""></font></div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class=""><br class=""></div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica" class="">Gruß Tobias</div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica;min-height:14px" class=""><br class=""></div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica;min-height:14px" class=""><br class=""></div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica;min-height:14px" class=""><br class=""></div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica;min-height:14px" class=""><br class=""></div></div><div class=""><div class="h5"><div class=""><br class=""></div><div class=""><br class=""><div class=""><div class="">Am 06.12.2016 um 18:08 schrieb Andreas Götz:</div><br class="m_4576883737686655469Apple-interchange-newline"><blockquote type="cite" class=""><div dir="auto" class=""><div class="">Statt Rätselraten wäre die Config hilfreich. Hast Du target auf sqlite geändert? Den Pfad zur Datenbankdatei (path) konfiguriert?<br class=""><br class="">Viele Grüße,<div class="">Andreas</div></div><div class=""><br class="">Am 06.12.2016 um 16:17 schrieb Theo <<a href="mailto:geocaching.theo@me.com" target="_blank" class="">geocaching.theo@me.com</a>>:<br class=""><br class=""></div><blockquote type="cite" class=""><div class=""><div class=""></div><div class="">Hallo Andreas,</div><div class=""><br class=""></div><div class="">Tja so selbsterklärend ist es für mich dann doch nicht. Der source part ist klar. Da muss ich nur den user und das passwort auf das meiner vz installation. Bei target weiß ich es eben nicht was ich da ändern/konfigurieren muss. </div><div class=""><br class=""></div><div class="">Bzw wird mit dem create befehl eine datenbank erstellt oder wird in einer vorher erstellten Datenbank die tabellenstruktur erstellt?</div><div class=""><br class=""></div><div class="">Bei ersterem, wo wird die erstellte datenbankdatei gespeichert, bzw wie kann man den speicherort anpassen. Bei zweiterem, wie erstelle ich vorher eine Datenbank?</div><div class=""><br class=""></div><div class="">Und ja die php sqlit extrnsion hab ich mit </div><div class=""><br class=""></div><div class="">Sudo apt-get install sqlite3 php5-sqlite installiert. So wie es im wiki steht. </div><div class=""><br class=""></div><div class="">ich hab jetzt mal sowohl bei source als auch bei target die parameter user und password gesetzt, bei source auf die von der volkszaehler datenbank, bei target hab ich die selben genommen, alles andere hab ich gleich gelassen. Dann hab ich folgendes ausgeführt:</div><div class=""><br class=""></div><div class=""><pre class="m_4576883737686655469code" style="margin-top:0px;margin-bottom:1.4em;padding:0.7em 1em;font-family:Consolas,'Andale Mono WT','Andale Mono','Bitstream Vera Sans Mono','Nimbus Mono L',Monaco,'Courier New',monospace;font-size:14px;direction:ltr;background-color:rgb(251,250,249);color:rgb(51,51,51);border-top-left-radius:2px;border-top-right-radius:2px;border-bottom-right-radius:2px;border-bottom-left-radius:2px;overflow:auto;word-wrap:normal;border:1px solid rgb(204,204,204)">/var/www/<a href="http://volkszaehler.org/vendor/bin/dbcopy.php" target="_blank" class="">volkszaehler.org/<wbr class="">vendor/bin/dbcopy.php</a> create -c /etc/dbcopy.json</pre><div class="">und folgende fehlermeldung bekommen:</div></div><div class=""><br class=""></div><div class=""><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font-size:10px;font-family:Monaco;color:rgb(191,191,191);background-color:rgb(153,18,0);min-height:14px" class=""> <br class="m_4576883737686655469webkit-block-placeholder"></div><div style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(191,191,191);background-color:rgb(153,18,0)" class=""> [Doctrine\DBAL\Exception\<wbr class="">ConnectionException] </div><div style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(191,191,191);background-color:rgb(153,18,0)" class=""> An exception occured in driver: SQLSTATE[HY000] [14] unable to open databas </div><div style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(191,191,191);background-color:rgb(153,18,0)" class=""> e file </div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font-size:10px;font-family:Monaco;color:rgb(191,191,191);background-color:rgb(153,18,0);min-height:14px" class=""> <br class="m_4576883737686655469webkit-block-placeholder"></div><div style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0);min-height:14px" class=""><br class=""></div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font-size:10px;font-family:Monaco;color:rgb(191,191,191);background-color:rgb(153,18,0);min-height:14px" class=""> <br class="m_4576883737686655469webkit-block-placeholder"></div><div style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(191,191,191);background-color:rgb(153,18,0)" class=""> [Doctrine\DBAL\Driver\<wbr class="">PDOException] </div><div style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(191,191,191);background-color:rgb(153,18,0)" class=""> SQLSTATE[HY000] [14] unable to open database file </div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font-size:10px;font-family:Monaco;color:rgb(191,191,191);background-color:rgb(153,18,0);min-height:14px" class=""> <br class="m_4576883737686655469webkit-block-placeholder"></div><div style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0);min-height:14px" class=""><br class=""></div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font-size:10px;font-family:Monaco;color:rgb(191,191,191);background-color:rgb(153,18,0);min-height:14px" class=""> <br class="m_4576883737686655469webkit-block-placeholder"></div><div style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(191,191,191);background-color:rgb(153,18,0)" class=""> [PDOException] </div><div style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(191,191,191);background-color:rgb(153,18,0)" class=""> SQLSTATE[HY000] [14] unable to open database file </div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font-size:10px;font-family:Monaco;color:rgb(191,191,191);background-color:rgb(153,18,0);min-height:14px" class=""> <br class="m_4576883737686655469webkit-block-placeholder"></div><div style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0);min-height:14px" class=""><br class=""></div><div style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(52,189,38);background-color:rgb(0,0,0)" class="">create [-c|--config CONFIG]</div><div style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0);min-height:14px" class=""><br class=""></div></div><div class=""><br class=""></div><div class="">dann hab ich den befehl nochmal mit sudo vorangestellt getestet, weil ich dachte er könnte die database nicht öffnen, weil die recht fehlen. dann kam aber folgende Fehlermeldung:</div><div class=""><br class=""></div><div class=""><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font-size:10px;font-family:Monaco;color:rgb(191,191,191);background-color:rgb(153,18,0);min-height:14px" class=""> <br class="m_4576883737686655469webkit-block-placeholder"></div><div style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(191,191,191);background-color:rgb(153,18,0)" class=""> [Doctrine\DBAL\Exception\<wbr class="">SyntaxErrorException] </div><div style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(191,191,191);background-color:rgb(153,18,0)" class=""> An exception occurred while executing 'SET NAMES utf8': </div><div style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(191,191,191);background-color:rgb(153,18,0)" class=""> SQLSTATE[HY000]: General error: 1 near "SET": syntax error </div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font-size:10px;font-family:Monaco;color:rgb(191,191,191);background-color:rgb(153,18,0);min-height:14px" class=""> <br class="m_4576883737686655469webkit-block-placeholder"></div><div style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0);min-height:14px" class=""><br class=""></div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font-size:10px;font-family:Monaco;color:rgb(191,191,191);background-color:rgb(153,18,0);min-height:14px" class=""> <br class="m_4576883737686655469webkit-block-placeholder"></div><div style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(191,191,191);background-color:rgb(153,18,0)" class=""> [Doctrine\DBAL\Driver\<wbr class="">PDOException] </div><div style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(191,191,191);background-color:rgb(153,18,0)" class=""> SQLSTATE[HY000]: General error: 1 near "SET": syntax error </div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font-size:10px;font-family:Monaco;color:rgb(191,191,191);background-color:rgb(153,18,0);min-height:14px" class=""> <br class="m_4576883737686655469webkit-block-placeholder"></div><div style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(245,245,245);background-color:rgb(0,0,0);min-height:14px" class=""><br class=""></div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font-size:10px;font-family:Monaco;color:rgb(191,191,191);background-color:rgb(153,18,0);min-height:14px" class=""> <br class="m_4576883737686655469webkit-block-placeholder"></div><div style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(191,191,191);background-color:rgb(153,18,0)" class=""> [PDOException] </div><div style="margin:0px;font-size:10px;font-family:Monaco;color:rgb(191,191,191);background-color:rgb(153,18,0)" class=""> SQLSTATE[HY000]: General error: 1 near "SET": syntax error </div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font-size:10px;font-family:Monaco;color:rgb(191,191,191);background-color:rgb(153,18,0);min-height:14px" class=""> <br class="m_4576883737686655469webkit-block-placeholder"></div></div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">Also was hab ich falsch gemacht? </div><div class=""><br class=""></div><div class=""><br class="">Am 06.12.2016 um 15:42 schrieb Andreas Goetz <<a href="mailto:cpuidle@gmail.com" target="_blank" class="">cpuidle@gmail.com</a>>:<br class=""><br class=""></div><blockquote type="cite" class=""><div dir="ltr" class="">Servus,<br class=""><div class="gmail_extra"><br class=""><div class="gmail_quote">2016-12-06 13:57 GMT+01:00 Theo <span dir="ltr" class=""><<a href="mailto:geocaching.theo@me.com" target="_blank" class="">geocaching.theo@me.com</a>></span>:<br class=""><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hallo Daniel,<br class="">
<br class="">
Ja die wikiseite kenn ich, nach dieser hab ich ja bisher versucht zu arbeiten. Aber diese schweigt sich leider über den part Dbcopy.json aus. Nur das man eine kopie derselben verwenden soll.<br class=""></blockquote><div class=""><br class=""></div><div class="">Die sollte eigentlich selbsterklärend sein.<br class=""> <br class=""></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br class="">
Mein Plan war es jetzt ein backup als sqlite datenbank auf dem gleichen raspi zu erstellen.</blockquote><div class=""><br class=""></div><div class="">Kannst Du machen.<br class=""> <br class=""></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> Sqlite3 hab ich nach der wikiseite installiert. </blockquote><div class=""><br class=""></div><div class="">D.h. die PHP Sqlite Extension ist installiert?<br class=""> <br class=""></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Und dann die entstandene datenbank datei zusätzlich auf dem speicher der fritzbox zu sichern. Ich hab sonst kein zusätzliches system auf dem ne Datenbank laufen könnte. </blockquote><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br class="">
Mir ist halt nicht ganz klar wo die Datenbank, wenn ich eine erstelle, abgespeichert wird.<br class=""></blockquote><div class=""><br class=""></div><div class="">Ich verstehe Deine Frage nciht. Eine SQlite Datenbank ist eine Datei, nicht mehr und nicht weniger. Wenn Du die Date kpiert hast ist die "Datenbank" da. Was soll da irgendwo laufen???? Du hast ja keinen zweiten VZ isntalliert sondern nur ein Backup gemacht? <br class=""><br class=""></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br class="">
Tobias<br class=""></blockquote><div class=""><br class=""></div><div class="">Viele Grüße,<br class=""></div><div class="">Andreas<br class=""> <br class=""></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="m_4576883737686655469HOEnZb"><div class="m_4576883737686655469h5"><br class="">
> Am 06.12.2016 um 11:50 schrieb Daniel Lauckner <<a href="mailto:vz@jahp.de" target="_blank" class="">vz@jahp.de</a>>:<br class="">
><br class="">
> Hallo Theo,<br class="">
><br class="">
><br class="">
> schon die Wikiseite entdeckt?<br class="">
> <a href="http://wiki.volkszaehler.org/software/tools/dbcopy" rel="noreferrer" target="_blank" class="">http://wiki.volkszaehler.org/s<wbr class="">oftware/tools/dbcopy</a><br class="">
><br class="">
><br class="">
> mfg Daniel<br class="">
><br class="">
</div></div></blockquote></div><br class=""></div></div>
</blockquote></div></blockquote></div></blockquote></div><br class=""></div></div></div></div></blockquote></div><br class=""></div>
</blockquote></div><br class=""></div></div></div></blockquote></div><br class=""></div></body></html>