<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    OK... ist Müll.... ich verscuhe es gerade zu löschen.... warum geht
    es nicht<br>
    <br>
    pi@pi-volk:~ $ vzclient -u f83ac920-fb68-11e6-ac39-053972a0aad0
    delete channel<br>
    {"version":"0.3","exception":{"message":"An exception occurred while
    executing 'DELETE FROM data WHERE channel_id = ?' with params
    [14]:\n\nSQLSTATE[42000]: Syntax error or access violation: 1142
    DELETE command denied to user 'vz'@'localhost' for table
    'data'","type":"ConnectionException","code":0}}<br>
    <br>
    <br>
    <br>
    <div class="moz-cite-prefix">Am 05.03.2017 um 15:16 schrieb Frank
      Richter:<br>
    </div>
    <blockquote
cite="mid:CAD+U_OC_C05i1Qk7VFRcdktMNNWVURRgvawWwS+zX=3uq5r8bg@mail.gmail.com"
      type="cite">
      <p dir="ltr">12,7kW ist kein Zählerstand, sondern eine Leistung.
        Ein Zählerstand wird in kWh gemessen. Du meinst, dein Zähler
        zeigt gerade ca. 12700 kWh? Bei 1.8.0? </p>
      <div class="gmail_quote">Am 05.03.2017 15:12 schrieb "Sascha
        Koszowyj" <<a moz-do-not-send="true"
          href="mailto:saschakoszowyj@arcor.de">saschakoszowyj@arcor.de</a>>:<br
          type="attribution">
        <blockquote class="gmail_quote" style="margin:0 0 0
          .8ex;border-left:1px #ccc solid;padding-left:1ex">
          <div bgcolor="#FFFFFF" text="#000000"> Hi Frank,<br>
            Hi Daniel,<br>
            <br>
            Da habe ich nur die Daten aus dem VT Logger reinkopiert.<br>
            ja, dass script um dann den gesamtverbrauch auszurechnen
            hatte  ich auch schon mal laufen.....  <br>
            <br>
            Wenn ich Euch richtig verstehe, sagt Ihr der "schwarze"
            Stromzähler ist falsch, richtig?<br>
            Komisch, aber mein mometaner "GesamtZählerstand" ist doch
            12.7 kW. Dann ist dass wohl Zufall... also ist dass
            Datenmüll, richtig?<br>
            <br>
            also können diese Zeilen raus...<br>
            <br>
            <span> {</span><br>
            <span>                         "uuid" :
              "f83ac920-fb68-11e6-ac39-</span><span>05397<wbr>2a0aad0",</span><br>
            <span>                         "middleware" : </span><a
              moz-do-not-send="true"
class="m_-3324749454392833913m_-450724982062542007m_6014629221647702030m_-8902133529873183534m_7468149731825935330m_7621092446018770980gmail-m_4821294497429123512moz-txt-link-rfc2396E"
              href="http://localhost/middleware.php" target="_blank">"http://localhost/middleware<wbr>.php"</a><span>,</span><br>
            <span>                         "identifier" :
              "1-0:1.8.0*255", /* Summe  */</span>
            <div>                         "aggmode": "MAX"<br>
              <span>                         }, {<br>
                <br>
                Und wie lese ich den Zählerstand aus?<br>
                <br>
                VG<br>
                Sascha<br>
              </span></div>
            <br>
            <br>
            <br>
            <br>
            <br>
            <div class="m_-3324749454392833913moz-cite-prefix">Am
              05.03.2017 um 14:56 schrieb Frank Richter:<br>
            </div>
            <blockquote type="cite">
              <p dir="ltr">Hallo Sascha,</p>
              <p dir="ltr">der Text im Bild ist nicht lesbar, aber auf
                jeden Fall ist dein schwarzer Kanal Unfug. Das Frontend
                ist dazu da Leistung darzustellen, keine absoluten
                Zählerstände. Du loggst hier Zählerstände in einen
                Leistungswert-Kanal und hast offensichtlich auch die
                Achsenzuordung verbogen. Weg mit dem Kanal...<br>
                Wenn du den Zählerstand ablesen wissen willst, kannst du
                bei den anderen beiden Kanälen in den Eigenschaften
                einen Initialverbrauch angeben, dann kriegst du ne
                zusätzliche Spalte "Gesamtverbrauch" in der Tabelle.<br>
                Dass dein Zähler tatsächlich eine "Summe" ausgibt,
                bezweifle ich weiterhin, das müsste man via vzlogger-Log
                prüfen.</p>
              <p dir="ltr">Grüße<br>
                Frank</p>
              <div class="gmail_quote">Am 05.03.2017 14:42 schrieb
                "Sascha Koszowyj" <<a moz-do-not-send="true"
                  href="mailto:saschakoszowyj@arcor.de" target="_blank">saschakoszowyj@arcor.de</a>>:<br
                  type="attribution">
                <blockquote class="gmail_quote" style="margin:0 0 0
                  .8ex;border-left:1px #ccc solid;padding-left:1ex">
                  <div bgcolor="#FFFFFF" text="#000000"> Hi Frank,<br>
                    <br>
                    hier die Dastellung... habe es jetzt auf alle 15
                    Sek. eingestellt....<br>
                    Brauchst du noch was?<br>
                    <br>
                    Bei mit klapt jetzt alles sauber.... danke<br>
                    <br>
                    LG<br>
                    Sascha<br>
                    <br>
                    <div
                      class="m_-3324749454392833913m_-450724982062542007moz-cite-prefix">Am
                      05.03.2017 um 14:24 schrieb Frank Richter:<br>
                    </div>
                    <blockquote type="cite">
                      <p dir="ltr">Du hast einen Screenshot geschickt,
                        der einen Zeitbereich von 1 Sekunde abdeckt.
                        Damit kann keiner was anfangen. Also bitte mal
                        einen Tag oder wenigstens ein paar Stunden.<br>
                        Und dafür aktivierst du nur die 3 UUIDs, die du
                        mit vzlogger erfasst und schreibst die Zuordnung
                        zwischen Identifier vom Zähler und Kanalname im
                        Frontend dazu.</p>
                      <p dir="ltr">Grüße<br>
                        Frank</p>
                      <div class="gmail_quote">Am 05.03.2017 14:16
                        schrieb "Sascha Koszowyj" <<a
                          moz-do-not-send="true"
                          href="mailto:saschakoszowyj@arcor.de"
                          target="_blank">saschakoszowyj@arcor.de</a>>:<br
                          type="attribution">
                        <blockquote class="gmail_quote">
                          <div dir="auto">
                            <div>Sorry... ich wollte niemanden
                              beleidigen... mache ich nachher... was
                              genau möchtest du sehen...</div>
                            <div><br>
                            </div>
                            <div>Kann an auf dem Screen  Shot nichts
                              erkennen... ich jetzt unterwegs ... bis
                              später ...</div>
                            <div><br>
                              Am 05.03.2017 um 14:13 schrieb Frank
                              Richter <<a moz-do-not-send="true"
                                href="mailto:frank.richter83@gmail.com"
                                target="_blank">frank.richter83@gmail.com</a>>:<br>
                              <br>
                            </div>
                            <blockquote type="cite">
                              <div>
                                <p dir="ltr">Wenn du nicht bereit bist,
                                  einen vernünftigen Screenshot zu
                                  zeigen, auf dem man auch einen
                                  zeitlichen Verlauf sieht, und die
                                  Frage zur Kanalzuordnung zu
                                  beantworten, ist das Thema für mich
                                  durch.</p>
                                <p dir="ltr">Grüße<br>
                                  Frank</p>
                                <div class="gmail_quote">Am 05.03.2017
                                  14:05 schrieb "Sascha Koszowyj" <<a
                                    moz-do-not-send="true"
                                    href="mailto:saschakoszowyj@arcor.de"
                                    target="_blank">saschakoszowyj@arcor.de</a>>:<br
                                    type="attribution">
                                  <blockquote class="gmail_quote">
                                    <div> 3 Werte hole ich aus dem
                                      VZlogger (Stromzähler)<br>
                                      <br>
                                      2 Werte asu meiner PV Anlage<br>
                                      <br>
                                      2 Werte berechne ich aus den
                                      (Gesamtverbrauch und
                                      Direktverbrauch)<br>
                                      <br>
                                      <br>
                                      <br>
                                      <div
class="m_-3324749454392833913m_-450724982062542007m_6014629221647702030m_-8902133529873183534moz-cite-prefix">Am
                                        05.03.2017 um 13:54 schrieb
                                        Frank Richter:<br>
                                      </div>
                                      <blockquote type="cite">
                                        <p dir="ltr">1 Sekunde?! Was
                                          soll man darauf erkennen?</p>
                                        <p dir="ltr">Deine Kanal-Config
                                          sieht ziemlich "eigenwillig"
                                          aus. Woher sollen die Daten
                                          für die Leistungswert-Kanäle
                                          kommen? Deine vzlogger-Config
                                          liefert nur Zählerstände.
                                          Welcher identifier wird in
                                          welchem Kanal geloggt?</p>
                                        <p dir="ltr">Frank</p>
                                        <div class="gmail_quote">Am
                                          05.03.2017 13:35 schrieb
                                          "Sascha Koszowyj" <<a
                                            moz-do-not-send="true"
                                            href="mailto:saschakoszowyj@arcor.de"
                                            target="_blank">saschakoszowyj@arcor.de</a>>:<br
                                            type="attribution">
                                          <blockquote
                                            class="gmail_quote">
                                            <div> Habe nur die Farben
                                              noch nciht angepasst....<br>
                                              <br>
                                              Es ist der Zählerstand ...
                                              die anderen beiden ist der
                                              momentante Verbraucht bzw
                                              die momentane Einspeisung.<br>
                                              <br>
                                              VG<br>
                                              Sascha<br>
                                              <br>
                                              <div
class="m_-3324749454392833913m_-450724982062542007m_6014629221647702030m_-8902133529873183534m_7468149731825935330moz-cite-prefix">Am
                                                05.03.2017 um 13:31
                                                schrieb Frank Richter:<br>
                                              </div>
                                              <blockquote type="cite">
                                                <p dir="ltr">Zeig mal
                                                  bitte einen
                                                  Frontend-Screenshot
                                                  der 3 Kanäle. Kann mir
                                                  grad nicht vorstellen
                                                  wie man die Summe
                                                  interpretieren sollte.</p>
                                                <p dir="ltr">Frank</p>
                                                <div class="gmail_quote">Am
                                                  05.03.2017 13:22
                                                  schrieb "Sascha
                                                  Koszowyj" <<a
                                                    moz-do-not-send="true"
href="mailto:saschakoszowyj@arcor.de" target="_blank">saschakoszowyj@arcor.de</a>>:<br
                                                    type="attribution">
                                                  <blockquote
                                                    class="gmail_quote">
                                                    <div> Hi Frank,<br>
                                                      <br>
                                                      vielen Dank...
                                                      aber warum die
                                                      Frage nach 2
                                                      mal...<br>
                                                      <br>
                                                      1-0:1.8.0*255
                                                      => Summer
                                                      Stromzähler<br>
                                                      <span>1-0:1.8.0
                                                        => Bezug<br>
                                                      </span><span>1-0:2.8.0
                                                        =>
                                                        Einspreisung
                                                        (ICh habe eine
                                                        PV Anlage, daher
                                                        der Zähler mit
                                                        -A und +A<br>
                                                        <br>
                                                        LG<br>
                                                        Sascha<br>
                                                      </span>
                                                      <div
class="m_-3324749454392833913m_-450724982062542007m_6014629221647702030m_-8902133529873183534m_7468149731825935330m_7621092446018770980moz-cite-prefix"><br>
                                                        <br>
                                                        Am 05.03.2017 um
                                                        12:45 schrieb
                                                        Frank Richter:<br>
                                                      </div>
                                                      <blockquote
                                                        type="cite">
                                                        <div dir="ltr">Hallo
                                                          Sascha,
                                                          <div><br>
                                                          </div>
                                                          <div>wieso
                                                          hast du 2
                                                          Kanäle für den
                                                          identifier
                                                          1.8.0?</div>
                                                          <div>Config
                                                          mit
                                                          Aggregation
                                                          s.u.:</div>
                                                          <div><br>
                                                          </div>
                                                          <div><span>{</span><br>
                                                          <span> 
                                                          "retry": 0,</span><br>
                                                          <span> 
                                                          "daemon":
                                                          true,</span><br>
                                                          <span> 
                                                          "verbosity":
                                                          0,</span><br>
                                                          <span>  "log":
"/tmp/vzlogger.log",</span><br>
                                                          <span> 
                                                          "local": {</span><br>
                                                          <span>   
                                                          "enabled":
                                                          false,</span><br>
                                                          <span>   
                                                          "port": 8080,</span><br>
                                                          <span>   
                                                          "index":
                                                          false,</span><br>
                                                          <span>   
                                                          "timeout": 30,</span><br>
                                                          <span>   
                                                          "buffer": 10</span><br>
                                                          <span>  },</span><br>
                                                          <br>
                                                          <span>"meters"
                                                          : [</span><br>
                                                          <span>    {</span><br>
                                                          <span>   
                                                          "enabled" :
                                                          true ,</span><br>
                                                          <span>   
                                                          "protocol" :
                                                          "d0", </span><br>
                                                          <span>   
                                                          "baudrate" :
                                                          9600,</span><br>
                                                          <span>   
                                                          "device" :
                                                          "/dev/ttyUSB0",</span><br>
                                                          <span>   
                                                          "parity" :
                                                          "7E1",</span><br>
                                                              "aggtime":
                                                          60,<br>
                                                          <span>   
                                                          "channels":
                                                          [    {</span><br>
                                                          <span>                        
                                                          "uuid" :
                                                          "f83ac920-fb68-11e6-ac39-</span><span>05397<wbr>2a0aad0",</span><br>
                                                          <span>                        
                                                          "middleware"
                                                          : </span><a
                                                          moz-do-not-send="true"
class="m_-3324749454392833913m_-450724982062542007m_6014629221647702030m_-8902133529873183534m_7468149731825935330m_7621092446018770980gmail-m_4821294497429123512moz-txt-link-rfc2396E"
href="http://localhost/middleware.php" target="_blank">"http://localhost/middleware<wbr>.php"</a><span>,</span><br>
                                                          <span>                        
                                                          "identifier" :
"1-0:1.8.0*255", /* Summe  */</span></div>
                                                          <div>         
                                                                       
                                                           "aggmode":
                                                          "MAX"<br>
                                                          <span>                        
                                                          }, {</span><br>
                                                          <br>
                                                          <span>       
                                                                  
                                                          "uuid" :
"63227c40-fb69-11e6-bbca-</span><span>6588f<wbr>c7ddfc4",</span><br>
                                                          <span>       
                                                                 
                                                           "middleware"
                                                          : </span><a
                                                          moz-do-not-send="true"
class="m_-3324749454392833913m_-450724982062542007m_6014629221647702030m_-8902133529873183534m_7468149731825935330m_7621092446018770980gmail-m_4821294497429123512moz-txt-link-rfc2396E"
href="http://localhost/middleware.php" target="_blank">"http://localhost/middleware<wbr>.php"</a><span>,</span><br>
                                                          <span>       
                                                                 
                                                           "identifier"
                                                          : "1-0:1.8.0",
                                                          /* Wirkarbeit
                                                          Bezug +A */</span></div>
                                                          <div>         
                                                               
                                                           "aggmode":
                                                          "MAX"<br>
                                                          <span>       
                                                                   }, {</span><br>
                                                          <span>       
                                                                  
                                                          "uuid" :
"5c886660-fb69-11e6-a9a1-</span><span>2f9e7<wbr>86ebdf9",</span><br>
                                                          <span>       
                                                                  
                                                          "middleware"
                                                          : </span><a
                                                          moz-do-not-send="true"
class="m_-3324749454392833913m_-450724982062542007m_6014629221647702030m_-8902133529873183534m_7468149731825935330m_7621092446018770980gmail-m_4821294497429123512moz-txt-link-rfc2396E"
href="http://localhost/middleware.php" target="_blank">"http://localhost/middleware<wbr>.php"</a><span>,</span><br>
                                                          <span>       
                                                                  
                                                          "identifier" :
                                                          "1-0:2.8.0",
                                                          /* Wirkarbeit
                                                          Lieferung -A
                                                          */</span></div>
                                                          <div>         
                                                               
                                                           "agmode":
                                                          "MAX"<br>
                                                          <span>   
                                                                   }]</span><br>
                                                          <br>
                                                          <span>}</span><br>
                                                          <span>]}</span></div>
                                                          <div><span><br>
                                                          </span></div>
                                                          <div><span>Grüße</span></div>
                                                          <div><span>Frank</span></div>
                                                        </div>
                                                        <div
                                                          class="gmail_extra"><br>
                                                          <div
                                                          class="gmail_quote">Am
                                                          5. März 2017
                                                          um 12:32
                                                          schrieb Sascha
                                                          Koszowyj <span
                                                          dir="ltr"><<a
moz-do-not-send="true" href="mailto:saschakoszowyj@arcor.de"
                                                          target="_blank">saschakoszowyj@arcor.de</a>></span>:<br>
                                                          <blockquote
                                                          class="gmail_quote">
                                                          <div> Hi Fank,<br>
                                                          <br>
                                                          diese
                                                          Attribute habe
                                                          ich nicht?<br>
                                                          <br>
                                                          <br>
                                                          {<br>
                                                            "retry": 0,<br>
                                                            "daemon":
                                                          true,<br>
                                                            "verbosity":
                                                          0,<br>
                                                            "log":
                                                          "/tmp/vzlogger.log",<br>
                                                            "local": {<br>
                                                              "enabled":
                                                          false,<br>
                                                              "port":
                                                          8080,<br>
                                                              "index":
                                                          false,<br>
                                                              "timeout":
                                                          30,<br>
                                                              "buffer":
                                                          10<br>
                                                            },<br>
                                                          <br>
                                                          "meters" : [<br>
                                                              {<br>
                                                              "enabled"
                                                          : true ,<br>
                                                              "protocol"
                                                          : "d0", <br>
                                                              "baudrate"
                                                          : 9600,<br>
                                                              "device" :
"/dev/ttyUSB0",<br>
                                                              "parity" :
                                                          "7E1",<br>
                                                          <br>
                                                             
                                                          "channels":
                                                          [    {<br>
                         "uuid" : "f83ac920-fb68-11e6-ac39-05397<wbr>2a0aad0",<br>
                         "middleware" : <a moz-do-not-send="true"
class="m_-3324749454392833913m_-450724982062542007m_6014629221647702030m_-8902133529873183534m_7468149731825935330m_7621092446018770980m_4821294497429123512moz-txt-link-rfc2396E"
href="http://localhost/middleware.php" target="_blank">"http://localhost/middleware.p<wbr>hp"</a>,<br>
                         "identifier" : "1-0:1.8.0*255", /* Summe  */<br>
                         }, {<br>
                                                          <br>
                                                                 
                                                                  
                                                          "uuid" :
                                                          "63227c40-fb69-11e6-bbca-6588f<wbr>c7ddfc4",<br>
                                                                     
                                                             
                                                           "middleware"
                                                          : <a
                                                          moz-do-not-send="true"
class="m_-3324749454392833913m_-450724982062542007m_6014629221647702030m_-8902133529873183534m_7468149731825935330m_7621092446018770980m_4821294497429123512moz-txt-link-rfc2396E"
href="http://localhost/middleware.php" target="_blank">"http://localhost/middleware.p<wbr>hp"</a>,<br>
                                                                      
                                                             
                                                           "identifier"
                                                          : "1-0:1.8.0",
                                                          /* Wirkarbeit
                                                          Bezug +A */<br>
                                                                     
                                                               }, {<br>
                                                                 
                                                                  
                                                          "uuid" :
                                                          "5c886660-fb69-11e6-a9a1-2f9e7<wbr>86ebdf9",<br>
                                                                 
                                                                  
                                                          "middleware" :
                                                          <a
                                                          moz-do-not-send="true"
class="m_-3324749454392833913m_-450724982062542007m_6014629221647702030m_-8902133529873183534m_7468149731825935330m_7621092446018770980m_4821294497429123512moz-txt-link-rfc2396E"
href="http://localhost/middleware.php" target="_blank">"http://localhost/middleware.p<wbr>hp"</a>,<br>
                                                                 
                                                                  
                                                          "identifier" :
                                                          "1-0:2.8.0",
                                                          /* Wirkarbeit
                                                          Lieferung -A
                                                          */<br>
                                                                      
                                                          }]<br>
                                                          <br>
                                                          }<br>
                                                          ]}
                                                          <div>
                                                          <div
class="m_-3324749454392833913m_-450724982062542007m_6014629221647702030m_-8902133529873183534m_7468149731825935330m_7621092446018770980h5"><br>
                                                          <br>
                                                          <br>
                                                          <div
class="m_-3324749454392833913m_-450724982062542007m_6014629221647702030m_-8902133529873183534m_7468149731825935330m_7621092446018770980m_4821294497429123512moz-cite-prefix">Am
                                                          05.03.2017 um
                                                          12:27 schrieb
                                                          Frank Richter:<br>
                                                          </div>
                                                          <blockquote
                                                          type="cite">
                                                          <p dir="ltr">Hallo,</p>
                                                          <p dir="ltr">in
                                                          der
                                                          vzlogger.conf
                                                          aggtime und
                                                          aggmode
                                                          setzen.</p>
                                                          <p dir="ltr">Gruß<br>
                                                          Frank</p>
                                                          <div
                                                          class="gmail_quote">Am
                                                          05.03.2017
                                                          12:24 schrieb
                                                          "Sascha
                                                          Koszowyj" <<a
moz-do-not-send="true" href="mailto:saschakoszowyj@arcor.de"
                                                          target="_blank">saschakoszowyj@arcor.de</a>>:<br
type="attribution">
                                                          <blockquote
                                                          class="gmail_quote">Hallo
                                                          Zusammen,<br>
                                                          <br>
                                                          wie / wo kann
                                                          ich den
                                                          einstellen,
                                                          wie offt er
                                                          meinen
                                                          Stromzähler in
                                                          der Minute
                                                          ausliest?<br>
                                                          Ich bracuhe
                                                          die Daten
                                                          nciht alle x
                                                          Sekunden....
                                                          mir würde es
                                                          reichen jede
                                                          minute.<br>
                                                          <br>
                                                          LG<br>
                                                          Sascha<br>
                                                          <br>
                                                          </blockquote>
                                                          </div>
                                                          </blockquote>
                                                          <br>
                                                          </div>
                                                          </div>
                                                          </div>
                                                          </blockquote>
                                                          </div>
                                                          <br>
                                                        </div>
                                                      </blockquote>
                                                      <br>
                                                    </div>
                                                  </blockquote>
                                                </div>
                                              </blockquote>
                                              <br>
                                            </div>
                                          </blockquote>
                                        </div>
                                      </blockquote>
                                      <br>
                                    </div>
                                  </blockquote>
                                </div>
                              </div>
                            </blockquote>
                          </div>
                        </blockquote>
                      </div>
                    </blockquote>
                    <br>
                  </div>
                </blockquote>
              </div>
            </blockquote>
            <br>
          </div>
        </blockquote>
      </div>
    </blockquote>
    <br>
  </body>
</html>