<div dir="ltr">Hallo Torsten,<div><br></div><div>Lass dir doch von python erstmal den genauen Fehler ausgeben. Damit kannst du dann weiter suchen.</div><div>Du kannst entweder eine Methode deiner Wahl (<a href="https://docs.python.org/3/tutorial/errors.html">https://docs.python.org/3/tutorial/errors.html</a>) verwenden, um das hübsch zu formatieren, oder das "try.. except" um deinen Block weg lassen, dann gibt python den Fehler von sich aus aus.</div><div><br></div><div>Schönen Gruß</div><div><br></div><div>Nils</div></div><div class="gmail_extra"><br><div class="gmail_quote">Am 17. Oktober 2016 um 07:03 schrieb Christian Schnellrieder <span dir="ltr"><<a href="mailto:schnellrieder.cs@gmail.com" target="_blank">schnellrieder.cs@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><p dir="ltr">Hallo Torsten.</p>
<p dir="ltr">Mysql verwendet nicht den Port 80. Davon abgesehen... Hast du dir das Beispiel angesehen was ich dir geschickt habe? </p><div class="HOEnZb"><div class="h5">
<br><div class="gmail_quote"><div dir="ltr">Torsten <<a href="mailto:t.wisgalla@gmx.de" target="_blank">t.wisgalla@gmx.de</a>> schrieb am Mo., 17. Okt. 2016, 00:59:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000" class="m_7532193586420200261gmail_msg">
<p class="m_7532193586420200261gmail_msg">Hallo zusammen ,</p>
besten dank erstmal an alle!<br class="m_7532193586420200261gmail_msg">
<br class="m_7532193586420200261gmail_msg">
>>> Woran klemmts denn genau? <<<<br class="m_7532193586420200261gmail_msg">
<br class="m_7532193586420200261gmail_msg">
Bezüglich meines Script´´s (direkt in die DB) daran(Script-Auszug):<br class="m_7532193586420200261gmail_msg">
<br class="m_7532193586420200261gmail_msg">
<span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg">mysqlHost </span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg">= </span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(221,0,0)" class="m_7532193586420200261gmail_msg">'127.0.0.1'<br class="m_7532193586420200261gmail_msg">
</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg">mysqlPort </span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg">= </span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg">80<br class="m_7532193586420200261gmail_msg">
mysqlLogin </span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg">= </span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(221,0,0)" class="m_7532193586420200261gmail_msg">'root'<br class="m_7532193586420200261gmail_msg">
</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg">mysqlPass </span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg">= </span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(221,0,0)" class="m_7532193586420200261gmail_msg">'raspberry'<br class="m_7532193586420200261gmail_msg">
</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg">mysqlDatabase </span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg">= </span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(221,0,0)" class="m_7532193586420200261gmail_msg">'volkszaehler'<br class="m_7532193586420200261gmail_msg">
<br class="m_7532193586420200261gmail_msg">
.<br class="m_7532193586420200261gmail_msg">
</span><br class="m_7532193586420200261gmail_msg">
<i class="m_7532193586420200261gmail_msg"><b class="m_7532193586420200261gmail_msg"><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg"><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(255,128,0)" class="m_7532193586420200261gmail_msg"># Permanente MySQL Verbindung<br class="m_7532193586420200261gmail_msg">
</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg">try:<br class="m_7532193586420200261gmail_msg">
</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg">db </span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg">= </span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg">MySQLdb</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg">.</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg">connect</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg">(</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg">host</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg">=</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg"><wbr>mysqlHost</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg">, </span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg">port</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg">=</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg">mysqlPort</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg">, </span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg">use<wbr>r</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg">=</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg">mysqlLogin</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg">, </span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg">passwd</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg">=</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg">mysqlPass</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg"><wbr>)<br class="m_7532193586420200261gmail_msg">
</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg">cursor </span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg">= </span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg">db</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg">.</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg">cursor</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg">()<br class="m_7532193586420200261gmail_msg">
</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg">except</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg">:<br class="m_7532193586420200261gmail_msg">
print(</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(221,0,0)" class="m_7532193586420200261gmail_msg">"Fehler beim <wbr>verbinden zum MySQL Server"</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg">)<br class="m_7532193586420200261gmail_msg">
</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg">sys</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg">.exit()<br class="m_7532193586420200261gmail_msg">
<br class="m_7532193586420200261gmail_msg">
</span>.<br class="m_7532193586420200261gmail_msg">
</span></b></i><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg"></span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg"></span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(221,0,0)" class="m_7532193586420200261gmail_msg"></span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg"></span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg"></span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg"></span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg"></span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(221,0,0)" class="m_7532193586420200261gmail_msg"></span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg"></span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg"></span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(221,0,0)" class="m_7532193586420200261gmail_msg"><br class="m_7532193586420200261gmail_msg">
</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg"></span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg"></span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(221,0,0)" class="m_7532193586420200261gmail_msg"></span><i class="m_7532193586420200261gmail_msg"><b class="m_7532193586420200261gmail_msg"><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg"></span></b></i><i class="m_7532193586420200261gmail_msg"><b class="m_7532193586420200261gmail_msg"><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg"></span></b></i><i class="m_7532193586420200261gmail_msg"><b class="m_7532193586420200261gmail_msg"><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg"><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg">cursor</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg">.</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg">execute</span>(</span></b></i><i class="m_7532193586420200261gmail_msg"><b class="m_7532193586420200261gmail_msg"><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(221,0,0)" class="m_7532193586420200261gmail_msg">"INSERT INTO <wbr>data (channel_id(34)) (<wbr>timestamp, value) VALUES (%s, <wbr>%s);"</span></b></i><i class="m_7532193586420200261gmail_msg"><b class="m_7532193586420200261gmail_msg"><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg">, (</span></b></i><i class="m_7532193586420200261gmail_msg"><b class="m_7532193586420200261gmail_msg"><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg"></span></b></i><i class="m_7532193586420200261gmail_msg"><b class="m_7532193586420200261gmail_msg"><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg"></span></b></i><i class="m_7532193586420200261gmail_msg"><b class="m_7532193586420200261gmail_msg"><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg">time</span></b></i><i class="m_7532193586420200261gmail_msg"><b class="m_7532193586420200261gmail_msg"><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg">.</span></b></i><i class="m_7532193586420200261gmail_msg"><b class="m_7532193586420200261gmail_msg"><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg">time</span></b></i><i class="m_7532193586420200261gmail_msg"><b class="m_7532193586420200261gmail_msg"><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg">(), </span></b></i><i class="m_7532193586420200261gmail_msg"><b class="m_7532193586420200261gmail_msg"><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(221,0,0)" class="m_7532193586420200261gmail_msg">'1'</span></b></i><i class="m_7532193586420200261gmail_msg"><b class="m_7532193586420200261gmail_msg"><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg">))<br class="m_7532193586420200261gmail_msg">
</span></b></i><br class="m_7532193586420200261gmail_msg">
Es folgt dann nach ca.2min das:<br class="m_7532193586420200261gmail_msg">
<br class="m_7532193586420200261gmail_msg">
<span style="color:rgb(51,51,51);font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);display:inline!important;float:none" class="m_7532193586420200261gmail_msg">pi@raspberrypi:~ $ sudo /test01.py</span><br style="color:rgb(51,51,51);font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255)" class="m_7532193586420200261gmail_msg">
<br style="color:rgb(51,51,51);font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255)" class="m_7532193586420200261gmail_msg">
<span style="color:rgb(51,51,51);font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);display:inline!important;float:none" class="m_7532193586420200261gmail_msg">Fehler beim verbinden zum MySQL Server<br class="m_7532193586420200261gmail_msg">
</span>
<div class="m_7532193586420200261m_6752501364788242553moz-cite-prefix m_7532193586420200261gmail_msg"><br class="m_7532193586420200261gmail_msg">
Wenn ich die Zeile<span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg">(</span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg"></span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(221,0,0)" class="m_7532193586420200261gmail_msg"></span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg"></span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg"></span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg"></span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg"></span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(221,0,0)" class="m_7532193586420200261gmail_msg"></span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg"></span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg"></span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(221,0,0)" class="m_7532193586420200261gmail_msg"></span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,0,187)" class="m_7532193586420200261gmail_msg"></span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(0,119,0)" class="m_7532193586420200261gmail_msg"></span><span style="font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);color:rgb(221,0,0)" class="m_7532193586420200261gmail_msg"></span><span style="color:rgb(0,0,187);font-family:monospace;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(250,250,255);display:inline!important;float:none" class="m_7532193586420200261gmail_msg">cursor...)</span>
entferne, läuft das Script ohne Fehler.<br class="m_7532193586420200261gmail_msg">
<br class="m_7532193586420200261gmail_msg">
Stimmen eventuell die Zugangsdaten nicht? Wenn ich die
Zugangsdaten ändere(z.B.das password), so kommt die Fehlermeldung
sofort!<br class="m_7532193586420200261gmail_msg">
Die Daten (value(0 oder 1)) sollen in die channel_id:34
geschrieben werden. Wenn ich die Daten von Hand per phpmyadmin
eingebe, erhalte ich im Frondend die gewünschte Darstellung.<br class="m_7532193586420200261gmail_msg">
<br class="m_7532193586420200261gmail_msg">
Kann jemand helfen? Baucht es weitere Info´s?<br class="m_7532193586420200261gmail_msg">
<br class="m_7532193586420200261gmail_msg">
Besten Dank schonmal - Torsten</div></div><div bgcolor="#FFFFFF" text="#000000" class="m_7532193586420200261gmail_msg"><div class="m_7532193586420200261m_6752501364788242553moz-cite-prefix m_7532193586420200261gmail_msg"><br class="m_7532193586420200261gmail_msg">
<br class="m_7532193586420200261gmail_msg">
<br class="m_7532193586420200261gmail_msg">
Am 16.10.2016 um 17:26 schrieb Daniel Lauckner:<br class="m_7532193586420200261gmail_msg">
</div></div><div bgcolor="#FFFFFF" text="#000000" class="m_7532193586420200261gmail_msg">
<blockquote type="cite" class="m_7532193586420200261gmail_msg">
<pre class="m_7532193586420200261gmail_msg">Hallo Torsten,
am Sonntag, 16. Oktober 2016 um 16:58 hast du geschrieben:
</pre>
<blockquote type="cite" class="m_7532193586420200261gmail_msg">
<pre class="m_7532193586420200261gmail_msg">ist es generell möglich, direkt in die DB
(volkszaehler/data/value) Werte aus einem Script zu übertragen ode
gelingt das nur über z.B. Vzclient oder API(zur middleware)?
</pre>
</blockquote>
<pre class="m_7532193586420200261gmail_msg">Geht auch direkt.
Ich verwende in meinen Scripten aber auch API oder vzclient.
</pre>
<blockquote type="cite" class="m_7532193586420200261gmail_msg">
<pre class="m_7532193586420200261gmail_msg">Mit dem wiki zu vzclient und API komme ich mit meinem
Kenntnissstand leider nicht weiter - bekomme das Zusammenspiel von
meinem PHYTON-Script zu diesen Tool´s nicht hin.
</pre>
</blockquote>
<pre class="m_7532193586420200261gmail_msg">Woran klemmts denn genau?
mfg Daniel
</pre>
</blockquote>
<br class="m_7532193586420200261gmail_msg">
</div></blockquote></div></div></div><span class="HOEnZb"><font color="#888888"><div dir="ltr">-- <br></div><div data-smartmail="gmail_signature"><p dir="ltr">Von meinem Smartphone versendet</p>
</div>
</font></span></blockquote></div><br></div>