<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div dir="ltr"></div><div dir="ltr">...oder :update, meist klappt das!</div><div dir="ltr"><br>Am 11.06.2019 um 22:03 schrieb Frank Richter <<a href="mailto:frank.richter83@gmail.com">frank.richter83@gmail.com</a>>:<br><br></div><blockquote type="cite"><div dir="ltr"><div dir="auto">Die vorhandenen Datensätze sind nicht besonders wertvoll, oder?<div dir="auto"><br></div><div dir="auto">Dann am besten nochmal neu: die 2 Tabellen löschen und dann entweder einen Dump vom Image erstellen und importieren oder einfach:</div><div dir="auto"><br></div><div dir="auto">php /home/pi/<a href="http://volkszaehler.org/bin/doctrine">volkszaehler.org/bin/doctrine</a> orm:schema-tool:create</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">René W. <<a href="mailto:tylonhh@gmail.com" target="_blank" rel="noreferrer">tylonhh@gmail.com</a>> schrieb am Di., 11. Juni 2019, 21:43:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="DE" link="blue" vlink="#954F72"><div class="m_-9032567608653631422m_8970912275749680802WordSection1"><p class="MsoNormal">Ok, ich habe Zugriff. Der angelegte Benutzer hatte nur Zugriff von localhost. Mit Änderung auf @% hat es geklappt.</p><p class="MsoNormal">Die DB scheint aber nicht alle Tabellen sauber zu haben. Wie kann ich die „nachpflegen“?</p><p class="MsoNormal"><img width="645" height="168" style="width:6.7187in;height:1.75in" id="m_-9032567608653631422m_8970912275749680802Grafik_x0020_3" src="cid:image003.png@01D5209E.A2670600"></p><p class="MsoNormal"><u></u> <u></u></p><div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0cm 0cm 0cm"><p class="MsoNormal" style="border:none;padding:0cm"><b>Von: </b><a href="mailto:cpuidle@gmail.com" rel="noreferrer noreferrer" target="_blank">Andreas Goetz</a><br><b>Gesendet: </b>Dienstag, 11. Juni 2019 21:37<br><b>An: </b><a href="mailto:volkszaehler-users@demo.volkszaehler.org" rel="noreferrer noreferrer" target="_blank">volkszaehler.org - users</a><br><b>Betreff: </b>Re: [vz-users] You have new mail in /var/mail/pi</p></div><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Dann hat- wie vermutet- Dein User keinen Zugriff auf die DB. Eindeutiger wirds nicht ;)<u></u><u></u></p><div><p class="MsoNormal"><br><br><u></u><u></u></p><blockquote style="margin-top:5.0pt;margin-bottom:5.0pt"><div><p class="MsoNormal">On 11. Jun 2019, at 21:09, René W. <<a href="mailto:tylonhh@gmail.com" rel="noreferrer noreferrer" target="_blank">tylonhh@gmail.com</a>> wrote:<u></u><u></u></p></div><p class="MsoNormal"><u></u> <u></u></p><div><div><p class="MsoNormal">Ich teste gerade:<u></u><u></u></p></div><div><p class="MsoNormal">pi@raspberrypi:~ $ mysql -h192.168.178.58 -P3306 -uroot -pXXXXXX volkzaehler<u></u><u></u></p></div><div><p class="MsoNormal">ERROR 1045 (28000): Access denied for user 'root'@'PiHole.fritz.box' (using password: YES)<u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div><div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0cm 0cm 0cm"><div><p class="MsoNormal"><b>Von:<span class="m_-9032567608653631422m_8970912275749680802apple-converted-space"> </span></b><a href="mailto:cpuidle@gmail.com" rel="noreferrer noreferrer" target="_blank"><span style="color:#954f72">Andreas Goetz</span></a><br><b>Gesendet:<span class="m_-9032567608653631422m_8970912275749680802apple-converted-space"> </span></b>Dienstag, 11. Juni 2019 20:52<br><b>An:<span class="m_-9032567608653631422m_8970912275749680802apple-converted-space"> </span></b><a href="mailto:volkszaehler-users@demo.volkszaehler.org" rel="noreferrer noreferrer" target="_blank"><span style="color:#954f72">volkszaehler.org - users</span></a><br><b>Betreff:<span class="m_-9032567608653631422m_8970912275749680802apple-converted-space"> </span></b>Re: [vz-users] You have new mail in /var/mail/pi<u></u><u></u></p></div></div><div><p class="MsoNormal"> <u></u><u></u></p></div><div><p class="MsoNormal">Mhhm. Und Du bist sicher, dass der gleiche User auf der Kommandozeile funktioniert, also:<u></u><u></u></p></div><div><div><p class="MsoNormal"> <u></u><u></u></p></div></div><div><div><p class="MsoNormal"><span class="m_-9032567608653631422m_8970912275749680802apple-tab-span"> </span><span class="m_-9032567608653631422m_8970912275749680802apple-converted-space"> </span>mysql -u root2 -ppassword volkszaehler<u></u><u></u></p></div></div><div><div><p class="MsoNormal"> <u></u><u></u></p></div></div><div><div><p class="MsoNormal">Viele Grüße, <u></u><u></u></p></div></div><div><div><p class="MsoNormal">Andreas<u></u><u></u></p></div></div><div><div><p class="MsoNormal"> <u></u><u></u></p></div><div><div><p class="MsoNormal"><br><br><br><u></u><u></u></p></div><blockquote style="margin-top:5.0pt;margin-bottom:5.0pt"><div><div><p class="MsoNormal">On 11. Jun 2019, at 20:21, René W. <<a href="mailto:tylonhh@gmail.com" rel="noreferrer noreferrer" target="_blank"><span style="color:#954f72">tylonhh@gmail.com</span></a>> wrote:<u></u><u></u></p></div></div><div><p class="MsoNormal"> <u></u><u></u></p></div><div><div><div><p class="MsoNormal">Das habe ich, dachte ich zumindest. Hab extra nochmal einen root2 User mit allen Privilegien angelegt. Ich erhalte immer noch die Meldung. Auch ein Auskommentieren brachte kein Erfolg.<u></u><u></u></p></div></div><div><div><p class="MsoNormal"> <u></u><u></u></p></div></div><div><div><p class="MsoNormal">LG<u></u><u></u></p></div></div><div><div><p class="MsoNormal"> <u></u><u></u></p></div></div><div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0cm 0cm 0cm"><div><div><p class="MsoNormal"><b>Von:<span class="m_-9032567608653631422m_8970912275749680802apple-converted-space"> </span></b><a href="mailto:frank.richter83@gmail.com" rel="noreferrer noreferrer" target="_blank"><span style="color:#954f72">Frank Richter</span></a><br><b>Gesendet:<span class="m_-9032567608653631422m_8970912275749680802apple-converted-space"> </span></b>Dienstag, 11. Juni 2019 19:02<br><b>An:<span class="m_-9032567608653631422m_8970912275749680802apple-converted-space"> </span></b><a href="mailto:volkszaehler-users@demo.volkszaehler.org" rel="noreferrer noreferrer" target="_blank"><span style="color:#954f72">volkszaehler.org - users</span></a><br><b>Betreff:<span class="m_-9032567608653631422m_8970912275749680802apple-converted-space"> </span></b>Re: [vz-users] You have new mail in /var/mail/pi<u></u><u></u></p></div></div></div><div><div><p class="MsoNormal"> <u></u><u></u></p></div></div><div><div><div><p class="MsoNormal">In der config.yaml für den DB-Admin passende Zugangsdaten eingeben.<u></u><u></u></p></div></div></div><div><div><p class="MsoNormal"> <u></u><u></u></p></div></div><div><div><div><div><p class="MsoNormal">René W. <<a href="mailto:tylonhh@gmail.com" rel="noreferrer noreferrer" target="_blank"><span style="color:#954f72">tylonhh@gmail.com</span></a>> schrieb am Di., 11. Juni 2019, 18:51:<u></u><u></u></p></div></div></div><blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt"><div><div><div><div><p class="MsoNormal">Moin,<u></u><u></u></p></div></div><p class="MsoNormal"> </p><div><div><p class="MsoNormal">ich erhalte regelmäßig im SSH „You have new mail in /var/mail/pi“<u></u><u></u></p></div></div><div><div><p class="MsoNormal">In der Log steht folgendes:<u></u><u></u></p></div></div><p class="MsoNormal"> </p><div><div><p class="MsoNormal">From pi@raspberrypi Tue Jun 11 16:50:01 2019<u></u><u></u></p></div></div><div><div><p class="MsoNormal">Return-path: <pi@raspberrypi><u></u><u></u></p></div></div><div><div><p class="MsoNormal">Envelope-to: pi@raspberrypi<u></u><u></u></p></div></div><div><div><p class="MsoNormal">Delivery-date: Tue, 11 Jun 2019 16:50:01 +0200<u></u><u></u></p></div></div><div><div><p class="MsoNormal">Received: from pi by raspberrypi.fritz.box with local (Exim 4.92)<u></u><u></u></p></div></div><div><div><p class="MsoNormal"> (envelope-from <pi@raspberrypi>)<u></u><u></u></p></div></div><div><div><p class="MsoNormal"> id 1hai65-0002MX-Lf<u></u><u></u></p></div></div><div><div><p class="MsoNormal"> for pi@raspberrypi; Tue, 11 Jun 2019 16:50:01 +0200<u></u><u></u></p></div></div><div><div><p class="MsoNormal">From: root@raspberrypi (Cron Daemon)<u></u><u></u></p></div></div><div><div><p class="MsoNormal">To: pi@raspberrypi<u></u><u></u></p></div></div><div><div><p class="MsoNormal">Subject: Cron <pi@raspberrypi> php /var/www/<a href="http://volkszaehler.org/bin/aggregate" rel="noreferrer noreferrer" target="_blank"><span style="color:#954f72">volkszaehler.org/bin/aggregate</span></a><span class="m_-9032567608653631422m_8970912275749680802apple-converted-space"> </span>run -m delta -l minute >/dev/null<u></u><u></u></p></div></div><div><div><p class="MsoNormal">MIME-Version: 1.0<u></u><u></u></p></div></div><div><div><p class="MsoNormal">Content-Type: text/plain; charset=UTF-8<u></u><u></u></p></div></div><div><div><p class="MsoNormal">Content-Transfer-Encoding: 8bit<u></u><u></u></p></div></div><div><div><p class="MsoNormal">X-Cron-Env: <SHELL=/bin/sh><u></u><u></u></p></div></div><div><div><p class="MsoNormal">X-Cron-Env: <HOME=/home/pi><u></u><u></u></p></div></div><div><div><p class="MsoNormal">X-Cron-Env: <PATH=/usr/bin:/bin><u></u><u></u></p></div></div><div><div><p class="MsoNormal">X-Cron-Env: <LOGNAME=pi><u></u><u></u></p></div></div><div><div><p class="MsoNormal">Message-Id: <<a href="mailto:E1hai65-0002MX-Lf@raspberrypi.fritz.box" rel="noreferrer noreferrer" target="_blank"><span style="color:#954f72">E1hai65-0002MX-Lf@raspberrypi.fritz.box</span></a>><u></u><u></u></p></div></div><div><div><p class="MsoNormal">Date: Tue, 11 Jun 2019 16:50:01 +0200<u></u><u></u></p></div></div><p class="MsoNormal"> </p><div><div><p class="MsoNormal">In AbstractMySQLDriver.php line 106:<u></u><u></u></p></div></div><p class="MsoNormal"> </p><div><div><p class="MsoNormal"> An exception occurred in driver: SQLSTATE[HY000] [1698] Access denied for u <u></u><u></u></p></div></div><div><div><p class="MsoNormal"> ser 'root'@'localhost' <u></u><u></u></p></div></div><p class="MsoNormal"> </p><div><div><p class="MsoNormal">In PDOConnection.php line 31:<u></u><u></u></p></div></div><p class="MsoNormal"> </p><div><div><p class="MsoNormal"> SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' <u></u><u></u></p></div></div><p class="MsoNormal"> </p><div><div><p class="MsoNormal">In PDOConnection.php line 27:<u></u><u></u></p></div></div><p class="MsoNormal"> </p><div><div><p class="MsoNormal"> SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' <u></u><u></u></p></div></div><p class="MsoNormal"> </p><div><div><p class="MsoNormal">run [-l|--level LEVEL] [-m|--mode MODE] [-p|--periods PERIODS] [-v|--verbose] [--] [<uuid>...]<u></u><u></u></p></div></div><p class="MsoNormal"> </p><div><div><p class="MsoNormal">Was muss ich nun machen?<u></u><u></u></p></div></div><p class="MsoNormal"> </p></div></div></blockquote></div><div style="margin-left:4.8pt"><div><p class="MsoNormal">LG<u></u><u></u></p></div></div></div></blockquote></div></div></div></blockquote></div><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"><u></u> <u></u></p></div></div></blockquote></div>
</div></blockquote></body></html>