<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix">Hallo,<br>
      <br>
      Wo und wie muss ich das machen, wenn ich es von Hand einstellen
      will?<br>
      Bin leider noch nicht all zu lange dabei und noch in der
      "Lernphase"<br>
      <br>
      Danke für die Mühe<br>
      <br>
      Thomas<br>
      <br>
      <br>
      Am 22.04.2015 um 09:32 schrieb Andreas Goetz:<br>
    </div>
    <blockquote
cite="mid:CAD+a8MjQE_ML-sxJ3NdQjJ4sWiZpciUKHCy0ba5AVjU1=2ToSg@mail.gmail.com"
      type="cite">
      <div dir="ltr">
        <div>
          <div>
            <div>> string(63) "DELETE command denied to user
              'vz'@'localhost' for table 'data'"<br>
              <br>
            </div>
            Dein vz User hat keine DELETE Rechte ->
            Installationsskript nochmal laufen lassen und die Option für
            die Rechte dabei auswählen. Oder von Hand auf der DB
            vergeben (Windows: z.B. MySQL Workbench).<br>
            <br>
          </div>
          Viele Grüße,<br>
        </div>
        Andreas<br>
        <br>
      </div>
      <div class="gmail_extra"><br>
        <div class="gmail_quote">On Wed, Apr 22, 2015 at 9:27 AM, <a
            moz-do-not-send="true" href="mailto:Heine.thomas@online.de">Heine.thomas@online.de</a>
          <span dir="ltr"><<a moz-do-not-send="true"
              href="mailto:Heine.thomas@online.de" target="_blank">Heine.thomas@online.de</a>></span>
          wrote:<br>
          <blockquote class="gmail_quote" style="margin:0 0 0
            .8ex;border-left:1px #ccc solid;padding-left:1ex">
            <div bgcolor="#FFFFFF" text="#000000">
              <div>Hallo,<br>
                <br>
                Es liegen seit Anfang April etwa 4,3 Mio Datensätze
                (ca.350MB) vor. <br>
                Ich denkejedoch, dass noch nichts da ist, was älter als
                30 Tage ist. <br>
                Aber es gibt genügend,was älter als eine Woche ist
                (Reduzierung auf 1 Datensatz/sek.).<br>
                <br>
                hab jetzt mal folgende Reduzierung eingertagen:<br>
                <br>
                (7*24*60*60) => 2, //Older than 7 Days Datapoint per
                2 sekunde<br>
                (30*24*60*60) => 30, //Older than 30 Days Datapoint
                per 30 sek<span class=""><br>
                  (6*30*24*60*60) => (1*60), //Older than 6 Month
                  Datapoint per 1 Minutes<br>
                  (365*24*60*60) => (3*60), //Older than 1 Year
                  Datapoint per 3 Minutes<br>
                  <br>
                  <br>
                </span> Hier das Ergebnis:<br>
                <br>
                04/22/15 09:23:52 - Processing Sensor ID 1...<br>
                04/22/15 09:23:52 -   Skipping compression pass for
                datapoints between 03/23/15 08:23:52 and 04/15/15
                09:23:52 using a 2 second timeframe: No Datapoints found<br>
                04/22/15 09:23:52 -   Skipping compression pass for
                datapoints between 10/24/14 09:23:52 and 03/23/15
                08:23:52 using a 30 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:52 -   Skipping compression pass for
                datapoints between 04/22/14 09:23:52 and 10/24/14
                09:23:52 using a 60 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:52 -   Skipping compression pass for
                datapoints between 04/22/15 09:23:52 and 04/22/14
                09:23:52 using a 180 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:52 - Processing Sensor ID 2...<br>
                04/22/15 09:23:52 -   Skipping compression pass for
                datapoints between 03/23/15 08:23:52 and 04/15/15
                09:23:52 using a 2 second timeframe: No Datapoints found<br>
                04/22/15 09:23:52 -   Skipping compression pass for
                datapoints between 10/24/14 09:23:52 and 03/23/15
                08:23:52 using a 30 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:52 -   Skipping compression pass for
                datapoints between 04/22/14 09:23:52 and 10/24/14
                09:23:52 using a 60 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 04/22/15 09:23:52 and 04/22/14
                09:23:52 using a 180 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:53 - Processing Sensor ID 3...<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 03/23/15 08:23:53 and 04/15/15
                09:23:53 using a 2 second timeframe: No Datapoints found<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 10/24/14 09:23:53 and 03/23/15
                08:23:53 using a 30 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 04/22/14 09:23:53 and 10/24/14
                09:23:53 using a 60 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 04/22/15 09:23:53 and 04/22/14
                09:23:53 using a 180 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:53 - Processing Sensor ID 4...<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 03/23/15 08:23:53 and 04/15/15
                09:23:53 using a 2 second timeframe: No Datapoints found<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 10/24/14 09:23:53 and 03/23/15
                08:23:53 using a 30 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 04/22/14 09:23:53 and 10/24/14
                09:23:53 using a 60 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 04/22/15 09:23:53 and 04/22/14
                09:23:53 using a 180 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:53 - Processing Sensor ID 5...<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 03/23/15 08:23:53 and 04/15/15
                09:23:53 using a 2 second timeframe: No Datapoints found<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 10/24/14 09:23:53 and 03/23/15
                08:23:53 using a 30 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 04/22/14 09:23:53 and 10/24/14
                09:23:53 using a 60 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 04/22/15 09:23:53 and 04/22/14
                09:23:53 using a 180 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:53 - Processing Sensor ID 6...<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 03/23/15 08:23:53 and 04/15/15
                09:23:53 using a 2 second timeframe: No Datapoints found<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 10/24/14 09:23:53 and 03/23/15
                08:23:53 using a 30 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 04/22/14 09:23:53 and 10/24/14
                09:23:53 using a 60 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 04/22/15 09:23:53 and 04/22/14
                09:23:53 using a 180 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:53 - Processing Sensor ID 7...<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 03/23/15 08:23:53 and 04/15/15
                09:23:53 using a 2 second timeframe: No Datapoints found<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 10/24/14 09:23:53 and 03/23/15
                08:23:53 using a 30 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 04/22/14 09:23:53 and 10/24/14
                09:23:53 using a 60 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 04/22/15 09:23:53 and 04/22/14
                09:23:53 using a 180 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:53 - Processing Sensor ID 8...<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 03/23/15 08:23:53 and 04/15/15
                09:23:53 using a 2 second timeframe: No Datapoints found<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 10/24/14 09:23:53 and 03/23/15
                08:23:53 using a 30 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 04/22/14 09:23:53 and 10/24/14
                09:23:53 using a 60 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 04/22/15 09:23:53 and 04/22/14
                09:23:53 using a 180 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:53 - Processing Sensor ID 9...<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 03/23/15 08:23:53 and 04/15/15
                09:23:53 using a 2 second timeframe: No Datapoints found<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 10/24/14 09:23:53 and 03/23/15
                08:23:53 using a 30 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 04/22/14 09:23:53 and 10/24/14
                09:23:53 using a 60 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 04/22/15 09:23:53 and 04/22/14
                09:23:53 using a 180 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:53 - Processing Sensor ID 10...<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 03/23/15 08:23:53 and 04/15/15
                09:23:53 using a 2 second timeframe: No Datapoints found<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 10/24/14 09:23:53 and 03/23/15
                08:23:53 using a 30 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 04/22/14 09:23:53 and 10/24/14
                09:23:53 using a 60 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 04/22/15 09:23:53 and 04/22/14
                09:23:53 using a 180 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:53 - Processing Sensor ID 11...<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 03/23/15 08:23:53 and 04/15/15
                09:23:53 using a 2 second timeframe: No Datapoints found<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 10/24/14 09:23:53 and 03/23/15
                08:23:53 using a 30 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 04/22/14 09:23:53 and 10/24/14
                09:23:53 using a 60 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:53 -   Skipping compression pass for
                datapoints between 04/22/15 09:23:53 and 04/22/14
                09:23:53 using a 180 second timeframe: No Datapoints
                found<br>
                04/22/15 09:23:53 - Processing Sensor ID 12...<br>
                04/22/15 09:23:53 -   Compressing datapoints between
                04/01/15 18:19:24 and 04/15/15 09:23:51 using a 2 second
                timeframe<br>
                04/22/15 09:23:53 -     Processing: 04/01/15 18:19:26 -
                04/01/15 18:19:28 (0%)...                    array(3) {<br>
                  [0]=><br>
                  string(5) "42000"<br>
                  [1]=><br>
                  int(1142)<br>
                  [2]=><br>
                  string(63) "DELETE command denied to user
                'vz'@'localhost' for table 'data'"<br>
                }<br>
                PHP Fatal error:  SQL FAILURE in /home/pi/<a
                  moz-do-not-send="true"
                  href="http://volkszaehler.org/misc/tools/vzcompress2.php"
                  target="_blank">volkszaehler.org/misc/tools/vzcompress2.php</a>
                on line 220<br>
                 <br>
                Was hab ich falsch gemacht????<br>
                <br>
                Danke Gruß Thomas
                <div>
                  <div class="h5"><br>
                    <br>
                    <br>
                    Am 22.04.2015 um 08:02 schrieb Andreas Götz:<br>
                  </div>
                </div>
              </div>
              <div>
                <div class="h5">
                  <blockquote type="cite">
                    <div>In welcher Auflösung liegen Deine Daten denn
                      vor bzw. wieviele Einträge pro Kanal hast Du in
                      welchem Zeitraum? Sieht aus als hätte vzcompress
                      nichts gefunden...</div>
                    <div><br>
                    </div>
                    <div>Viele Grüße, Andreas <br>
                      <br>
                      <br>
                    </div>
                    <div><br>
                      Am 22.04.2015 um 06:58 schrieb "<a
                        moz-do-not-send="true"
                        href="mailto:Heine.thomas@online.de"
                        target="_blank">Heine.thomas@online.de</a>" <<a
                        moz-do-not-send="true"
                        href="mailto:Heine.thomas@online.de"
                        target="_blank">Heine.thomas@online.de</a>>:<br>
                      <br>
                    </div>
                    <blockquote type="cite">
                      <div>
                        <div>Hallo zusammen,<br>
                          <br>
                          hab das VZCompress einmalig durchlaufen lassen
                          (hat etwa 17 Stunden gedauert, wie ihr seht).
                          Mit folgendem Ergebniss:<br>
                          <br>
                          ...<br>
                          ...<br>
                          ...<br>
                          04/22/15 06:42:16 -     Processing: 04/15/15
                          02:14:21 - 04/15/15 02:14:22
                          (100%)...                                                      
                          <br>
                          04/22/15 06:42:16 -     Processing: 04/15/15
                          02:14:22 - 04/15/15 02:14:23
                          (100%)...                                                      
                          <br>
                          04/22/15 06:42:16 -     Processing: 04/15/15
                          02:14:23 - 04/15/15 02:14:24
                          (100%)...                                                     
                          <br>
                          04/22/15 06:42:16 -     Removed 0 Datapoints
                          in <b>16071</b>
                          Seconds.                                                                           


                          <br>
                          04/22/15 06:42:16 -   Skipping compression
                          pass for datapoints between 10/24/14 02:14:25
                          and                                      <br>
                          03/23/15 01:14:25 using a 20 second timeframe:
                          No Datapoints found<br>
                          04/22/15 06:42:16 -   Skipping compression
                          pass for datapoints between 04/22/14 02:14:25
                          and <br>
                          10/24/14 02:14:25 using a 60 second timeframe:
                          No Datapoints found<br>
                          04/22/15 06:42:16 -   Skipping compression
                          pass for datapoints between 04/22/15 02:14:25
                          and <br>
                          04/22/14 02:14:25 using a 180 second
                          timeframe: No Datapoints found<br>
                          04/22/15 06:42:16 - Done. Purged  Datapoints
                          from 16 Channels in <b>59200</b> Seconds<br>
                          <br>
                          <br>
                          Irgendwie stimmt das aber nicht mit meiner
                          Configuration überein, oder?<br>
                          In meinem Script steht folgendes:<br>
                          <br>
                          <div>(7*24*60*60) => (1*1), //Older than 7
                            Days Datapoint per 1 sekunde<br>
                            (30*24*60*60) => (5*6), //Older than 30
                            Days Datapoint per 30 sek<br>
                            (6*30*24*60*60) => (1*60), //Older than 6
                            Month Datapoint per 1 Minutes<br>
                            (365*24*60*60) => (3*60), //Older than 1
                            Year Datapoint per 3 Minutes<br>
                            <br>
                            wo hab ich den Fehler gemacht?<br>
                            <br>
                            Danke Gruß Thomas<br>
                          </div>
                          <br>
                          <br>
                          <br>
                          Am 02.04.2015 um 10:35 schrieb Thomas Heine:<br>
                        </div>
                        <blockquote type="cite">
                          <div
                            style="font-family:Verdana;font-size:12.0px">
                            <div>Hallo,</div>
                            <div>ich muss die Datenmenge meines
                              Volkszählers verkleinern.<br>
                              Würde das gerne mit vzcompress machen.<br>
                              Ein Messpunkt/minute ist mir aber zu
                              wenig.<br>
                              Wie soll ich das skript abändern?</div>
                            <div>Ursprüngliches skript:</div>
                            <div>(7*24*60*60) => (1*60), //Older than
                              7 Days Datapoint per 1 Minute<br>
                              (30*24*60*60) => (5*60), //Older than
                              30 Days Datapoint per 5 Minutes<br>
                              (6*30*24*60*60) => (15*60), //Older
                              than 6 Month Datapoint per 15 Minutes<br>
                              (365*24*60*60) => (30*60), //Older than
                              1 Year Datapoint per 30 Minutes</div>
                            <div><br>
                              Mein script:</div>
                            <div>(7*24*60*60) => (1*1), //Older than
                              7 Days Datapoint per 1 sekunde<br>
                              (30*24*60*60) => (5*6), //Older than 30
                              Days Datapoint per 30 sek<br>
                              (6*30*24*60*60) => (1*60), //Older than
                              6 Month Datapoint per 1 Minutes<br>
                              (365*24*60*60) => (3*60), //Older than
                              1 Year Datapoint per 3 Minutes</div>
                            <div> </div>
                            <div>würde das so klappen?</div>
                            <div>Kann ich das skript irgendwie einmalig
                              aufrufen? oder macht es sinn, es<br>
                              in eine crontab zu schreiben?</div>
                            <div><br>
                              Danke für die Hilfe!</div>
                            <div>Gruß</div>
                            <div>Thomas</div>
                            <div> </div>
                          </div>
                        </blockquote>
                        <br>
                      </div>
                    </blockquote>
                  </blockquote>
                  <br>
                </div>
              </div>
            </div>
          </blockquote>
        </div>
        <br>
      </div>
    </blockquote>
    <br>
  </body>
</html>