<html><body><div style="font-family: 'verdana'; font-size: 12px; color: #000;"><span style="background-color: #ffffff;">Hallo Alex,</span></div>
<div style="font-family: 'verdana'; font-size: 12px; color: #000;"><span style="background-color: #ffffff;"> </span></div>
<div style="font-family: 'verdana'; font-size: 12px; color: #000;"><span style="background-color: #ffffff;">hier zur Sicherheit mal die dbcopy.yaml:</span></div>
<div style="font-family: 'verdana'; font-size: 12px; color: #000;"><span style="background-color: #ffffff;"> </span></div>
<div style="font-family: 'verdana'; font-size: 12px; color: #000;">
<div># DATABASE DEFINITION<br>target:<br>DATABASE DEFINITION<br>target:<br> driver: pdo_mysql<br> host: localhost<br> user: root<br> password: demo<br> dbname: volkszaehler</div>
<div>source:<br> driver: pdo_sqlite<br> host: localhost<br> user: root<br> password: raspberry<br> dbname: volkszaehler_backup<br> path: /home/pi/sqlite.db3 # path is only used if driver = pdo_sqlite</div>
<div># influxdb target database connection<br>influx:<br> dsn: influxdb://localhost:8086<br> dbname: volkszaehler<br> measurement: data</div>
<div># TABLE DEFINITION<br># ----------------<br># tables will be processed in the order they are mentioned:<br># - foreign keys on target will be dropped<br># - if a table is not listed here, it will not be touched<br># transfer mode<br># skip: table will not be copied<br># copy: entire table will be truncated on target and copied from source<br># pk: selective copy by primary key. only data not present on target<br># will be copied from source.<br>tables:<br> entities: copy<br> properties: copy<br> entities_in_aggregator: copy<br> data: pk<br> aggregate: skip<br> driver: pdo_mysql</div>
<div style="font-family: 'verdana'; font-size: 12px; color: #000000;"> </div>
<div style="font-family: 'verdana'; font-size: 12px; color: #000000;">Grüße</div>
<div style="font-family: 'verdana'; font-size: 12px; color: #000000;"> </div>
<div style="font-family: 'verdana'; font-size: 12px; color: #000000;">JD.</div>
</div>
<div id="sub-body-container" style="margin: 10px 5px 5px 10px; padding: 10px 0px 10px 10px; border-left: 2px solid rgb(195, 217, 229);">
<div style="margin: 0px 0px 10px;">
<div><strong>Sent: </strong>Wednesday, September 16, 2026 at 12:19 PM</div>
<div><strong>From: </strong>Alex <trabant@ewe.net></div>
<div><strong>To: </strong>"volkszaehler.org - users" <volkszaehler-users@demo.volkszaehler.org></div>
<div><strong>Subject: </strong>Re: [vz-users] Evtl Fehler bei dbcopy</div>
</div>
<div>Moin,</div>
<div> </div>
<div>bist Du sicher, dass im benannten /etc/dbcopy.yaml der korrekte Pfad für die SqLite Datei steht? Die andere Datei (/media/backup/...) hat auch ein altes Datum?</div>
<div> </div>
<div>On Wed, 2026-09-16 at 09:42 +0000, John Doe wrote:</div>
<blockquote style="margin: 0 0 0 0.8ex; border-left: 2.0px rgb(114,159,207) solid; padding-left: 1.0ex;">
<div style="font-family: verdana; font-size: 12.0px; color: #000000;"><span style="background-color: #ffffff;">Hallo zusammen,</span></div>
<div style="font-family: verdana; font-size: 12.0px; color: #000000;"><span style="background-color: #ffffff;"> </span></div>
<div style="font-family: verdana; font-size: 12.0px; color: #000000;"><span style="background-color: #ffffff;">Ausgangslage: Älterer vz auf Raspi 4, System auf USB-SSD:</span></div>
<div style="font-family: verdana; font-size: 12.0px; color: #000000;"><span style="background-color: #ffffff;"> </span></div>
<div style="font-family: verdana; font-size: 12.0px; color: #000000;"><span style="background-color: #ffffff;">vzlogger -V <br>0.8.0 <br> based on git version: heads/master-0-g033de9dc7d <br> last commit date: Wed, 10 Feb 2021 14:44:17 +0100 <br></span></div>
<div style="font-family: verdana; font-size: 12.0px; color: #000000;"><span style="background-color: #ffffff;"> </span></div>
<div style="font-family: verdana; font-size: 12.0px; color: #000000;"><span style="background-color: #ffffff;">Heute habe ich festgestellt, dass seit einiger Zeit das Backup via dbcopy auf ein NAS über eine CIFS-Freigabe evtl. nicht mehr funktioniert, da die erstellte(n) sqlite.bd3 Zeitstempel aus Mai 2024 haben. Der vzlogger läuft normal und aggregiert Werte. Die Ausgabe von dbcopy:</span></div>
<div style="font-family: verdana; font-size: 12.0px; color: #000000;"><span style="background-color: #ffffff;"><span style="background-color: #ffffff;"> </span></span></div>
<div style="font-family: verdana; font-size: 12.0px; color: #000000;">
<div style="font-family: verdana; font-size: 12.0px; color: #000000;">sudo /var/www/volkszaehler.org/vendor/bin/dbcopy copy -c /etc/dbcopy.yaml <br>[ ... ]</div>
</div>
</blockquote>
<div> </div>
<div> </div>
</div></body></html>