<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>
<br><div class="gmail_quote"><div dir="ltr">Torsten <<a href="mailto:t.wisgalla@gmx.de">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="gmail_msg">
<p class="gmail_msg">Hallo zusammen ,</p>
besten dank erstmal an alle!<br class="gmail_msg">
<br class="gmail_msg">
>>> Woran klemmts denn genau? <<<<br class="gmail_msg">
<br class="gmail_msg">
Bezüglich meines Script´´s (direkt in die DB) daran(Script-Auszug):<br class="gmail_msg">
<br class="gmail_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="gmail_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="gmail_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="gmail_msg">'127.0.0.1'<br class="gmail_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="gmail_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="gmail_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="gmail_msg">80<br class="gmail_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="gmail_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="gmail_msg">'root'<br class="gmail_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="gmail_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="gmail_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="gmail_msg">'raspberry'<br class="gmail_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="gmail_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="gmail_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="gmail_msg">'volkszaehler'<br class="gmail_msg">
<br class="gmail_msg">
.<br class="gmail_msg">
</span><br class="gmail_msg">
<i class="gmail_msg"><b class="gmail_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="gmail_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="gmail_msg"># Permanente MySQL Verbindung<br class="gmail_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="gmail_msg">try:<br class="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_msg">user</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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_msg">)<br class="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_msg">()<br class="gmail_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="gmail_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="gmail_msg">:<br class="gmail_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="gmail_msg">"Fehler beim 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="gmail_msg">)<br class="gmail_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="gmail_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="gmail_msg">.exit()<br class="gmail_msg">
<br class="gmail_msg">
</span>.<br class="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_msg"><br class="gmail_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="gmail_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="gmail_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="gmail_msg"></span><i class="gmail_msg"><b class="gmail_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="gmail_msg"></span></b></i><i class="gmail_msg"><b class="gmail_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="gmail_msg"></span></b></i><i class="gmail_msg"><b class="gmail_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="gmail_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="gmail_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="gmail_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="gmail_msg">execute</span>(</span></b></i><i class="gmail_msg"><b class="gmail_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="gmail_msg">"INSERT INTO data (channel_id(34)) (timestamp, value) VALUES (%s, %s);"</span></b></i><i class="gmail_msg"><b class="gmail_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="gmail_msg">, (</span></b></i><i class="gmail_msg"><b class="gmail_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="gmail_msg"></span></b></i><i class="gmail_msg"><b class="gmail_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="gmail_msg"></span></b></i><i class="gmail_msg"><b class="gmail_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="gmail_msg">time</span></b></i><i class="gmail_msg"><b class="gmail_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="gmail_msg">.</span></b></i><i class="gmail_msg"><b class="gmail_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="gmail_msg">time</span></b></i><i class="gmail_msg"><b class="gmail_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="gmail_msg">(), </span></b></i><i class="gmail_msg"><b class="gmail_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="gmail_msg">'1'</span></b></i><i class="gmail_msg"><b class="gmail_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="gmail_msg">))<br class="gmail_msg">
</span></b></i><br class="gmail_msg">
Es folgt dann nach ca.2min das:<br class="gmail_msg">
<br class="gmail_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="gmail_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="gmail_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="gmail_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="gmail_msg">Fehler beim verbinden zum MySQL Server<br class="gmail_msg">
</span>
<div class="m_6752501364788242553moz-cite-prefix gmail_msg"><br class="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_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="gmail_msg">cursor...)</span>
entferne, läuft das Script ohne Fehler.<br class="gmail_msg">
<br class="gmail_msg">
Stimmen eventuell die Zugangsdaten nicht? Wenn ich die
Zugangsdaten ändere(z.B.das password), so kommt die Fehlermeldung
sofort!<br class="gmail_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="gmail_msg">
<br class="gmail_msg">
Kann jemand helfen? Baucht es weitere Info´s?<br class="gmail_msg">
<br class="gmail_msg">
Besten Dank schonmal - Torsten</div></div><div bgcolor="#FFFFFF" text="#000000" class="gmail_msg"><div class="m_6752501364788242553moz-cite-prefix gmail_msg"><br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
Am 16.10.2016 um 17:26 schrieb Daniel Lauckner:<br class="gmail_msg">
</div></div><div bgcolor="#FFFFFF" text="#000000" class="gmail_msg">
<blockquote type="cite" class="gmail_msg">
<pre class="gmail_msg">Hallo Torsten,
am Sonntag, 16. Oktober 2016 um 16:58 hast du geschrieben:
</pre>
<blockquote type="cite" class="gmail_msg">
<pre class="gmail_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="gmail_msg">
Geht auch direkt.
Ich verwende in meinen Scripten aber auch API oder vzclient.
</pre>
<blockquote type="cite" class="gmail_msg">
<pre class="gmail_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="gmail_msg">
Woran klemmts denn genau?
mfg Daniel
</pre>
</blockquote>
<br class="gmail_msg">
</div></blockquote></div><div dir="ltr">-- <br></div><div data-smartmail="gmail_signature"><p dir="ltr">Von meinem Smartphone versendet</p>
</div>