Dockerimage

Solaranzeige und Docker
Alles was mit der Docker Version zu tun hat.

Moderatoren: Ulrich, DeBaschdi

SFB
Beiträge: 5
Registriert: Di 8. Feb 2022, 00:14
Danksagung erhalten: 1 Mal

Re: Dockerimage

Beitrag von SFB »

Servus!

Aaaaalso.
Ich habe jetzt meine ersten Gehversuche in Docker hinter mir.
Docker-Host : QNAP NAS mit "Container Station" (CPU-Limit: 90%, Memory Limit: 3072MB)
WR = Sungrow (Typ 70 mit Port 502)

Erste Probleme:
InfluxDB- und Mosquitto-Services starten nicht automatisch, letzterer überhaupt nicht,
und Grafana bleibt leer.

Das mit den Services erkläre ich mir damit, dass ich beim Kopieren der Parameter wohl auch unsichtbare Sonderzeichen im Text mit drin hatte. Nachdem ich jedenfalls alles neu getippt hatte und auch noch die Parameter INFLUXDB=yes und MOSQUITTO=yes unter "Advanced Settings"-"Environment" in der "Container Station" eingetragen hatte, starteten beide Services sofort nach Container-Neustart und setup.
Das mit den Sonderzeichen könnte auch bei vielen anderen Mitstreitern hier im Forum das Problem gewesen sein.

Was mir jetzt aber immer noch nicht gelingt, ist die Anzeige von irgendwelchen Daten im Grafana.
Das sungrow.php-Skript sammelt jedenfalls fleissig Daten und kann diese laut Meldung auch in die DB schreiben.
Im Grafana habe ich das passende Sungrow-Dashboard geladen und kann über "Configuration"-"Data Sources" auch beide Einträge "Solaranzeige" und "Steuerung" erfolgreich testen. Wegen einem Hinweis hier im Forum habe ich den Parameter "-p 8080:80" mal weggelassen - hat auch nicht geholfen.

Das Logfile "/var/www/log/grafana/grafana.log":

Code: Alles auswählen

t=2022-03-18T12:23:38+0100 lvl=info msg="Starting Grafana" logger=server version=7.5.7 commit=91de51771c branch=HEAD compiled=2021-05-17T21:16:45+0200
t=2022-03-18T12:23:38+0100 lvl=info msg="Config loaded from" logger=settings file=/usr/share/grafana/conf/defaults.ini
t=2022-03-18T12:23:38+0100 lvl=info msg="Config loaded from" logger=settings file=/etc/grafana/grafana.ini
t=2022-03-18T12:23:38+0100 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.data=/var/lib/grafana"
t=2022-03-18T12:23:38+0100 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.logs=/var/www/log/grafana"
t=2022-03-18T12:23:38+0100 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.plugins=/var/lib/grafana/plugins"
t=2022-03-18T12:23:38+0100 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.provisioning=/etc/grafana/provisioning"
t=2022-03-18T12:23:38+0100 lvl=info msg="Path Home" logger=settings path=/usr/share/grafana
t=2022-03-18T12:23:38+0100 lvl=info msg="Path Data" logger=settings path=/var/lib/grafana
t=2022-03-18T12:23:38+0100 lvl=info msg="Path Logs" logger=settings path=/var/www/log/grafana
t=2022-03-18T12:23:38+0100 lvl=info msg="Path Plugins" logger=settings path=/var/lib/grafana/plugins
t=2022-03-18T12:23:38+0100 lvl=info msg="Path Provisioning" logger=settings path=/etc/grafana/provisioning
t=2022-03-18T12:23:38+0100 lvl=info msg="App mode production" logger=settings
t=2022-03-18T12:23:38+0100 lvl=info msg="Writing PID file" logger=server path=/var/run/grafana-server.pid pid=112
t=2022-03-18T12:23:38+0100 lvl=info msg="Connecting to DB" logger=sqlstore dbtype=sqlite3
t=2022-03-18T12:23:38+0100 lvl=warn msg="SQLite database file has broader permissions than it should" logger=sqlstore path=/var/lib/grafana/grafana.db mode=-rwxrwxrwx expected=-rw-r-----
t=2022-03-18T12:23:38+0100 lvl=info msg="Starting DB migrations" logger=migrator
t=2022-03-18T12:23:38+0100 lvl=info msg="Executing migration" logger=migrator id="drop index IDX_temp_user_email - v1"
t=2022-03-18T12:23:38+0100 lvl=info msg="Executing migration" logger=migrator id="drop index IDX_temp_user_org_id - v1"
t=2022-03-18T12:23:38+0100 lvl=info msg="Executing migration" logger=migrator id="drop index IDX_temp_user_code - v1"
t=2022-03-18T12:23:38+0100 lvl=info msg="Executing migration" logger=migrator id="drop index IDX_temp_user_status - v1"
t=2022-03-18T12:23:38+0100 lvl=info msg="Executing migration" logger=migrator id="Rename table temp_user to temp_user_tmp_qwerty - v1"
t=2022-03-18T12:23:39+0100 lvl=info msg="Executing migration" logger=migrator id="create temp_user v2"
t=2022-03-18T12:23:39+0100 lvl=info msg="Executing migration" logger=migrator id="create index IDX_temp_user_email - v2"
t=2022-03-18T12:23:39+0100 lvl=info msg="Executing migration" logger=migrator id="create index IDX_temp_user_org_id - v2"
t=2022-03-18T12:23:39+0100 lvl=info msg="Executing migration" logger=migrator id="create index IDX_temp_user_code - v2"
t=2022-03-18T12:23:39+0100 lvl=info msg="Executing migration" logger=migrator id="create index IDX_temp_user_status - v2"
t=2022-03-18T12:23:40+0100 lvl=info msg="Executing migration" logger=migrator id="copy temp_user v1 to v2"
t=2022-03-18T12:23:40+0100 lvl=info msg="Executing migration" logger=migrator id="drop temp_user_tmp_qwerty"
t=2022-03-18T12:23:40+0100 lvl=info msg="Executing migration" logger=migrator id="Set created for temp users that will otherwise prematurely expire"
t=2022-03-18T12:23:40+0100 lvl=info msg="Executing migration" logger=migrator id="delete tags for deleted dashboards"
t=2022-03-18T12:23:40+0100 lvl=info msg="Executing migration" logger=migrator id="delete stars for deleted dashboards"
t=2022-03-18T12:23:40+0100 lvl=info msg="Executing migration" logger=migrator id="add unique index datasource_org_id_is_default"
t=2022-03-18T12:23:41+0100 lvl=info msg="Executing migration" logger=migrator id="Add encrypted dashboard json column"
t=2022-03-18T12:23:41+0100 lvl=info msg="Executing migration" logger=migrator id="Change dashboard_encrypted column to MEDIUMBLOB"
t=2022-03-18T12:23:41+0100 lvl=info msg="Executing migration" logger=migrator id="drop index UQE_alert_rule_tag_alert_id_tag_id - v1"
t=2022-03-18T12:23:41+0100 lvl=info msg="Executing migration" logger=migrator id="Rename table alert_rule_tag to alert_rule_tag_v1 - v1"
t=2022-03-18T12:23:41+0100 lvl=info msg="Executing migration" logger=migrator id="Create alert_rule_tag table v2"
t=2022-03-18T12:23:41+0100 lvl=info msg="Executing migration" logger=migrator id="create index UQE_alert_rule_tag_alert_id_tag_id - Add unique index alert_rule_tag.alert_id_tag_id V2"
t=2022-03-18T12:23:41+0100 lvl=info msg="Executing migration" logger=migrator id="copy alert_rule_tag v1 to v2"
t=2022-03-18T12:23:41+0100 lvl=info msg="Executing migration" logger=migrator id="drop table alert_rule_tag_v1"
t=2022-03-18T12:23:42+0100 lvl=info msg="Executing migration" logger=migrator id="Add column secure_settings in alert_notification"
t=2022-03-18T12:23:42+0100 lvl=info msg="Executing migration" logger=migrator id="alter alert.settings to mediumtext"
t=2022-03-18T12:23:42+0100 lvl=info msg="Executing migration" logger=migrator id="Add non-unique index alert_notification_state_alert_id"
t=2022-03-18T12:23:42+0100 lvl=info msg="Executing migration" logger=migrator id="Add non-unique index alert_rule_tag_alert_id"
t=2022-03-18T12:23:42+0100 lvl=info msg="Executing migration" logger=migrator id="drop index UQE_annotation_tag_annotation_id_tag_id - v2"
t=2022-03-18T12:23:42+0100 lvl=info msg="Executing migration" logger=migrator id="Rename table annotation_tag to annotation_tag_v2 - v2"
t=2022-03-18T12:23:42+0100 lvl=info msg="Executing migration" logger=migrator id="Create annotation_tag table v3"
t=2022-03-18T12:23:43+0100 lvl=info msg="Executing migration" logger=migrator id="create index UQE_annotation_tag_annotation_id_tag_id - Add unique index annotation_tag.annotation_id_tag_id V3"
t=2022-03-18T12:23:43+0100 lvl=info msg="Executing migration" logger=migrator id="copy annotation_tag v2 to v3"
t=2022-03-18T12:23:43+0100 lvl=info msg="Executing migration" logger=migrator id="drop table annotation_tag_v2"
t=2022-03-18T12:23:43+0100 lvl=info msg="Executing migration" logger=migrator id="add index team_member.team_id"
t=2022-03-18T12:23:43+0100 lvl=info msg="Executing migration" logger=migrator id="delete acl rules for deleted dashboards and folders"
t=2022-03-18T12:23:43+0100 lvl=info msg="Executing migration" logger=migrator id="add index user_auth_token.user_id"
t=2022-03-18T12:23:43+0100 lvl=info msg="Executing migration" logger=migrator id="Add revoked_at to the user auth token"
t=2022-03-18T12:23:44+0100 lvl=info msg="Executing migration" logger=migrator id="create short_url table v1"
t=2022-03-18T12:23:44+0100 lvl=info msg="Executing migration" logger=migrator id="add index short_url.org_id-uid"
t=2022-03-18T12:23:44+0100 lvl=info msg="migrations completed" logger=migrator performed=40 skipped=239 duration=6.330187437s
t=2022-03-18T12:23:44+0100 lvl=info msg="Starting plugin search" logger=plugins
t=2022-03-18T12:23:45+0100 lvl=info msg="Registering plugin" logger=plugins id=input
t=2022-03-18T12:23:47+0100 lvl=info msg="Registering plugin" logger=plugins id=briangann-gauge-panel
t=2022-03-18T12:23:47+0100 lvl=info msg="Registering plugin" logger=plugins id=fetzerch-sunandmoon-datasource
t=2022-03-18T12:23:47+0100 lvl=info msg="Registering plugin" logger=plugins id=yesoreyeram-boomtable-panel
t=2022-03-18T12:23:47+0100 lvl=info msg="HTTP Server Listen" logger=http.server address=[::]:3000 protocol=http subUrl= socket=
t=2022-03-18T12:24:28+0100 lvl=eror msg="Failed to look up user based on cookie" logger=context error="user token not found"
t=2022-03-18T12:24:28+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/d/99Sungrow01/sungrow-wechselrichter status=302 remote_addr=192.168.1.99 time_ms=33 size=29 referer=
t=2022-03-18T12:24:28+0100 lvl=eror msg="Failed to look up user based on cookie" logger=context error="user token not found"
t=2022-03-18T12:24:31+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=2 size=29 referer=
t=2022-03-18T12:24:32+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:24:35+0100 lvl=eror msg="Failed to look up user based on cookie" logger=context error="user token not found"
t=2022-03-18T12:24:35+0100 lvl=info msg="Successful Login" logger=http.server User=admin@localhost
t=2022-03-18T12:24:37+0100 lvl=eror msg="Dashboard not found" logger=context userId=1 orgId=1 uname=admin error="Dashboard not found" remote_addr=192.168.1.99
t=2022-03-18T12:24:37+0100 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=GET path=/api/dashboards/uid/99Sungrow01 status=404 remote_addr=192.168.1.99 time_ms=2 size=33 referer="http://192.168.1.131:3000/d/99Sungrow01/sungrow-wechselrichter?orgId=1&refresh=30s"
t=2022-03-18T12:24:57+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:25:05+0100 lvl=eror msg="Dashboard not found" logger=context userId=1 orgId=1 uname=admin error="Dashboard not found" remote_addr=192.168.1.99
t=2022-03-18T12:25:05+0100 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=GET path=/api/dashboards/uid/99Sungrow01 status=404 remote_addr=192.168.1.99 time_ms=1 size=33 referer=http://192.168.1.131:3000/dashboard/import
t=2022-03-18T12:25:05+0100 lvl=eror msg="Dashboard not found" logger=context userId=1 orgId=1 uname=admin error="Dashboard not found" remote_addr=192.168.1.99
t=2022-03-18T12:25:05+0100 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=GET path=/api/dashboards/uid/99Sungrow01 status=404 remote_addr=192.168.1.99 time_ms=2 size=33 referer=http://192.168.1.131:3000/dashboard/import
t=2022-03-18T12:25:15+0100 lvl=eror msg="Dashboard not found" logger=context userId=1 orgId=1 uname=admin error="Dashboard not found" remote_addr=192.168.1.99
t=2022-03-18T12:25:15+0100 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=GET path=/api/dashboards/uid/99Sungrow01 status=404 remote_addr=192.168.1.99 time_ms=14 size=33 referer=http://192.168.1.131:3000/dashboard/import
t=2022-03-18T12:25:26+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:26:00+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:26:29+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:26:57+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=90 size=29 referer=
t=2022-03-18T12:27:28+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:27:58+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:28:25+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:28:59+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=59 size=29 referer=
t=2022-03-18T12:29:25+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:29:53+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:30:21+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:30:54+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=125 size=29 referer=
t=2022-03-18T12:31:22+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:31:54+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:32:42+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=87 size=29 referer=
t=2022-03-18T12:33:49+0100 lvl=info msg="Starting Grafana" logger=server version=7.5.7 commit=91de51771c branch=HEAD compiled=2021-05-17T21:16:45+0200
t=2022-03-18T12:33:49+0100 lvl=info msg="Config loaded from" logger=settings file=/usr/share/grafana/conf/defaults.ini
t=2022-03-18T12:33:49+0100 lvl=info msg="Config loaded from" logger=settings file=/etc/grafana/grafana.ini
t=2022-03-18T12:33:49+0100 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.data=/var/lib/grafana"
t=2022-03-18T12:33:49+0100 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.logs=/var/www/log/grafana"
t=2022-03-18T12:33:49+0100 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.plugins=/var/lib/grafana/plugins"
t=2022-03-18T12:33:49+0100 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.provisioning=/etc/grafana/provisioning"
t=2022-03-18T12:33:49+0100 lvl=info msg="Path Home" logger=settings path=/usr/share/grafana
t=2022-03-18T12:33:49+0100 lvl=info msg="Path Data" logger=settings path=/var/lib/grafana
t=2022-03-18T12:33:49+0100 lvl=info msg="Path Logs" logger=settings path=/var/www/log/grafana
t=2022-03-18T12:33:49+0100 lvl=info msg="Path Plugins" logger=settings path=/var/lib/grafana/plugins
t=2022-03-18T12:33:49+0100 lvl=info msg="Path Provisioning" logger=settings path=/etc/grafana/provisioning
t=2022-03-18T12:33:49+0100 lvl=info msg="App mode production" logger=settings
t=2022-03-18T12:33:49+0100 lvl=info msg="Writing PID file" logger=server path=/var/run/grafana-server.pid pid=111
t=2022-03-18T12:33:49+0100 lvl=info msg="Connecting to DB" logger=sqlstore dbtype=sqlite3
t=2022-03-18T12:33:49+0100 lvl=warn msg="SQLite database file has broader permissions than it should" logger=sqlstore path=/var/lib/grafana/grafana.db mode=-rwxrwxrwx expected=-rw-r-----
t=2022-03-18T12:33:49+0100 lvl=info msg="Starting DB migrations" logger=migrator
t=2022-03-18T12:33:49+0100 lvl=info msg="migrations completed" logger=migrator performed=0 skipped=279 duration=2.335112ms
t=2022-03-18T12:33:49+0100 lvl=info msg="Starting plugin search" logger=plugins
t=2022-03-18T12:33:51+0100 lvl=info msg="Registering plugin" logger=plugins id=input
t=2022-03-18T12:33:53+0100 lvl=info msg="Registering plugin" logger=plugins id=briangann-gauge-panel
t=2022-03-18T12:33:53+0100 lvl=info msg="Registering plugin" logger=plugins id=fetzerch-sunandmoon-datasource
t=2022-03-18T12:33:53+0100 lvl=info msg="Registering plugin" logger=plugins id=yesoreyeram-boomtable-panel
t=2022-03-18T12:33:53+0100 lvl=info msg="HTTP Server Listen" logger=http.server address=[::]:3000 protocol=http subUrl= socket=
t=2022-03-18T12:34:07+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:34:07+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:34:34+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=100 size=29 referer=
t=2022-03-18T12:35:01+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:35:29+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=41 size=29 referer=
...
Hat jemand eine Idee?

Viele Grüße und vielen Dank im voraus

Solaranzeige im Docker-Container in QNAP-Container-Station
WR = Sungrow SH10RT
PV-Module = 26x380Wp = 9,88kWp
Batterie = Sungrow 9,6kW

SFB
Beiträge: 5
Registriert: Di 8. Feb 2022, 00:14
Danksagung erhalten: 1 Mal

Re: Dockerimage

Beitrag von SFB »

Lösung zu leerem Grafana-Dashboard gefunden!

Servus!
Ich weiß zwar nicht warum, aber die Zuordnung der Queries zur Datenbank hat nicht automatisch funktioniert.
Lösung: Jedes Dashboard-Element editieren. In der unteren Hälfte habe ich "[object Object] - not found" gefunden. Da drauf klicken und "Solaranzeige (default)" auswählen. Danach noch oben rechts auf "apply" klicken. Und schwupp, waren die Daten sichtbar.

Jetzt werde ich mal eintauchen :-)

Wirsing!

Solaranzeige im Docker-Container in QNAP-Container-Station
WR = Sungrow SH10RT
PV-Module = 26x380Wp = 9,88kWp
Batterie = Sungrow 9,6kW

floeg
Beiträge: 10
Registriert: Mo 27. Dez 2021, 23:15
Hat sich bedankt: 1 Mal
Danksagung erhalten: 1 Mal

Re: Dockerimage

Beitrag von floeg »

SFB hat geschrieben:
So 20. Mär 2022, 16:32
Lösung zu leerem Grafana-Dashboard gefunden!

Servus!
Ich weiß zwar nicht warum, aber die Zuordnung der Queries zur Datenbank hat nicht automatisch funktioniert.
Lösung: Jedes Dashboard-Element editieren. In der unteren Hälfte habe ich "[object Object] - not found" gefunden. Da drauf klicken und "Solaranzeige (default)" auswählen. Danach noch oben rechts auf "apply" klicken. Und schwupp, waren die Daten sichtbar.

Jetzt werde ich mal eintauchen :-)

Wirsing!
Super, vielen Dank. Bei den meisten Werte klappt das; aber leider nicht bei allen:

/ EDIT:
Nach einem Neustart des Dockers sind ausser dem Gerätestatus alle Werte da.

floeg
Beiträge: 10
Registriert: Mo 27. Dez 2021, 23:15
Hat sich bedankt: 1 Mal
Danksagung erhalten: 1 Mal

Re: Dockerimage

Beitrag von floeg »

SFB hat geschrieben:
Fr 18. Mär 2022, 15:34
Servus!

Aaaaalso.
Ich habe jetzt meine ersten Gehversuche in Docker hinter mir.
Docker-Host : QNAP NAS mit "Container Station" (CPU-Limit: 90%, Memory Limit: 3072MB)
WR = Sungrow (Typ 70 mit Port 502)

Erste Probleme:
InfluxDB- und Mosquitto-Services starten nicht automatisch, letzterer überhaupt nicht,
und Grafana bleibt leer.

Das mit den Services erkläre ich mir damit, dass ich beim Kopieren der Parameter wohl auch unsichtbare Sonderzeichen im Text mit drin hatte. Nachdem ich jedenfalls alles neu getippt hatte und auch noch die Parameter INFLUXDB=yes und MOSQUITTO=yes unter "Advanced Settings"-"Environment" in der "Container Station" eingetragen hatte, starteten beide Services sofort nach Container-Neustart und setup.
Das mit den Sonderzeichen könnte auch bei vielen anderen Mitstreitern hier im Forum das Problem gewesen sein.

Was mir jetzt aber immer noch nicht gelingt, ist die Anzeige von irgendwelchen Daten im Grafana.
Das sungrow.php-Skript sammelt jedenfalls fleissig Daten und kann diese laut Meldung auch in die DB schreiben.
Im Grafana habe ich das passende Sungrow-Dashboard geladen und kann über "Configuration"-"Data Sources" auch beide Einträge "Solaranzeige" und "Steuerung" erfolgreich testen. Wegen einem Hinweis hier im Forum habe ich den Parameter "-p 8080:80" mal weggelassen - hat auch nicht geholfen.

Das Logfile "/var/www/log/grafana/grafana.log":

Code: Alles auswählen

t=2022-03-18T12:23:38+0100 lvl=info msg="Starting Grafana" logger=server version=7.5.7 commit=91de51771c branch=HEAD compiled=2021-05-17T21:16:45+0200
t=2022-03-18T12:23:38+0100 lvl=info msg="Config loaded from" logger=settings file=/usr/share/grafana/conf/defaults.ini
t=2022-03-18T12:23:38+0100 lvl=info msg="Config loaded from" logger=settings file=/etc/grafana/grafana.ini
t=2022-03-18T12:23:38+0100 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.data=/var/lib/grafana"
t=2022-03-18T12:23:38+0100 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.logs=/var/www/log/grafana"
t=2022-03-18T12:23:38+0100 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.plugins=/var/lib/grafana/plugins"
t=2022-03-18T12:23:38+0100 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.provisioning=/etc/grafana/provisioning"
t=2022-03-18T12:23:38+0100 lvl=info msg="Path Home" logger=settings path=/usr/share/grafana
t=2022-03-18T12:23:38+0100 lvl=info msg="Path Data" logger=settings path=/var/lib/grafana
t=2022-03-18T12:23:38+0100 lvl=info msg="Path Logs" logger=settings path=/var/www/log/grafana
t=2022-03-18T12:23:38+0100 lvl=info msg="Path Plugins" logger=settings path=/var/lib/grafana/plugins
t=2022-03-18T12:23:38+0100 lvl=info msg="Path Provisioning" logger=settings path=/etc/grafana/provisioning
t=2022-03-18T12:23:38+0100 lvl=info msg="App mode production" logger=settings
t=2022-03-18T12:23:38+0100 lvl=info msg="Writing PID file" logger=server path=/var/run/grafana-server.pid pid=112
t=2022-03-18T12:23:38+0100 lvl=info msg="Connecting to DB" logger=sqlstore dbtype=sqlite3
t=2022-03-18T12:23:38+0100 lvl=warn msg="SQLite database file has broader permissions than it should" logger=sqlstore path=/var/lib/grafana/grafana.db mode=-rwxrwxrwx expected=-rw-r-----
t=2022-03-18T12:23:38+0100 lvl=info msg="Starting DB migrations" logger=migrator
t=2022-03-18T12:23:38+0100 lvl=info msg="Executing migration" logger=migrator id="drop index IDX_temp_user_email - v1"
t=2022-03-18T12:23:38+0100 lvl=info msg="Executing migration" logger=migrator id="drop index IDX_temp_user_org_id - v1"
t=2022-03-18T12:23:38+0100 lvl=info msg="Executing migration" logger=migrator id="drop index IDX_temp_user_code - v1"
t=2022-03-18T12:23:38+0100 lvl=info msg="Executing migration" logger=migrator id="drop index IDX_temp_user_status - v1"
t=2022-03-18T12:23:38+0100 lvl=info msg="Executing migration" logger=migrator id="Rename table temp_user to temp_user_tmp_qwerty - v1"
t=2022-03-18T12:23:39+0100 lvl=info msg="Executing migration" logger=migrator id="create temp_user v2"
t=2022-03-18T12:23:39+0100 lvl=info msg="Executing migration" logger=migrator id="create index IDX_temp_user_email - v2"
t=2022-03-18T12:23:39+0100 lvl=info msg="Executing migration" logger=migrator id="create index IDX_temp_user_org_id - v2"
t=2022-03-18T12:23:39+0100 lvl=info msg="Executing migration" logger=migrator id="create index IDX_temp_user_code - v2"
t=2022-03-18T12:23:39+0100 lvl=info msg="Executing migration" logger=migrator id="create index IDX_temp_user_status - v2"
t=2022-03-18T12:23:40+0100 lvl=info msg="Executing migration" logger=migrator id="copy temp_user v1 to v2"
t=2022-03-18T12:23:40+0100 lvl=info msg="Executing migration" logger=migrator id="drop temp_user_tmp_qwerty"
t=2022-03-18T12:23:40+0100 lvl=info msg="Executing migration" logger=migrator id="Set created for temp users that will otherwise prematurely expire"
t=2022-03-18T12:23:40+0100 lvl=info msg="Executing migration" logger=migrator id="delete tags for deleted dashboards"
t=2022-03-18T12:23:40+0100 lvl=info msg="Executing migration" logger=migrator id="delete stars for deleted dashboards"
t=2022-03-18T12:23:40+0100 lvl=info msg="Executing migration" logger=migrator id="add unique index datasource_org_id_is_default"
t=2022-03-18T12:23:41+0100 lvl=info msg="Executing migration" logger=migrator id="Add encrypted dashboard json column"
t=2022-03-18T12:23:41+0100 lvl=info msg="Executing migration" logger=migrator id="Change dashboard_encrypted column to MEDIUMBLOB"
t=2022-03-18T12:23:41+0100 lvl=info msg="Executing migration" logger=migrator id="drop index UQE_alert_rule_tag_alert_id_tag_id - v1"
t=2022-03-18T12:23:41+0100 lvl=info msg="Executing migration" logger=migrator id="Rename table alert_rule_tag to alert_rule_tag_v1 - v1"
t=2022-03-18T12:23:41+0100 lvl=info msg="Executing migration" logger=migrator id="Create alert_rule_tag table v2"
t=2022-03-18T12:23:41+0100 lvl=info msg="Executing migration" logger=migrator id="create index UQE_alert_rule_tag_alert_id_tag_id - Add unique index alert_rule_tag.alert_id_tag_id V2"
t=2022-03-18T12:23:41+0100 lvl=info msg="Executing migration" logger=migrator id="copy alert_rule_tag v1 to v2"
t=2022-03-18T12:23:41+0100 lvl=info msg="Executing migration" logger=migrator id="drop table alert_rule_tag_v1"
t=2022-03-18T12:23:42+0100 lvl=info msg="Executing migration" logger=migrator id="Add column secure_settings in alert_notification"
t=2022-03-18T12:23:42+0100 lvl=info msg="Executing migration" logger=migrator id="alter alert.settings to mediumtext"
t=2022-03-18T12:23:42+0100 lvl=info msg="Executing migration" logger=migrator id="Add non-unique index alert_notification_state_alert_id"
t=2022-03-18T12:23:42+0100 lvl=info msg="Executing migration" logger=migrator id="Add non-unique index alert_rule_tag_alert_id"
t=2022-03-18T12:23:42+0100 lvl=info msg="Executing migration" logger=migrator id="drop index UQE_annotation_tag_annotation_id_tag_id - v2"
t=2022-03-18T12:23:42+0100 lvl=info msg="Executing migration" logger=migrator id="Rename table annotation_tag to annotation_tag_v2 - v2"
t=2022-03-18T12:23:42+0100 lvl=info msg="Executing migration" logger=migrator id="Create annotation_tag table v3"
t=2022-03-18T12:23:43+0100 lvl=info msg="Executing migration" logger=migrator id="create index UQE_annotation_tag_annotation_id_tag_id - Add unique index annotation_tag.annotation_id_tag_id V3"
t=2022-03-18T12:23:43+0100 lvl=info msg="Executing migration" logger=migrator id="copy annotation_tag v2 to v3"
t=2022-03-18T12:23:43+0100 lvl=info msg="Executing migration" logger=migrator id="drop table annotation_tag_v2"
t=2022-03-18T12:23:43+0100 lvl=info msg="Executing migration" logger=migrator id="add index team_member.team_id"
t=2022-03-18T12:23:43+0100 lvl=info msg="Executing migration" logger=migrator id="delete acl rules for deleted dashboards and folders"
t=2022-03-18T12:23:43+0100 lvl=info msg="Executing migration" logger=migrator id="add index user_auth_token.user_id"
t=2022-03-18T12:23:43+0100 lvl=info msg="Executing migration" logger=migrator id="Add revoked_at to the user auth token"
t=2022-03-18T12:23:44+0100 lvl=info msg="Executing migration" logger=migrator id="create short_url table v1"
t=2022-03-18T12:23:44+0100 lvl=info msg="Executing migration" logger=migrator id="add index short_url.org_id-uid"
t=2022-03-18T12:23:44+0100 lvl=info msg="migrations completed" logger=migrator performed=40 skipped=239 duration=6.330187437s
t=2022-03-18T12:23:44+0100 lvl=info msg="Starting plugin search" logger=plugins
t=2022-03-18T12:23:45+0100 lvl=info msg="Registering plugin" logger=plugins id=input
t=2022-03-18T12:23:47+0100 lvl=info msg="Registering plugin" logger=plugins id=briangann-gauge-panel
t=2022-03-18T12:23:47+0100 lvl=info msg="Registering plugin" logger=plugins id=fetzerch-sunandmoon-datasource
t=2022-03-18T12:23:47+0100 lvl=info msg="Registering plugin" logger=plugins id=yesoreyeram-boomtable-panel
t=2022-03-18T12:23:47+0100 lvl=info msg="HTTP Server Listen" logger=http.server address=[::]:3000 protocol=http subUrl= socket=
t=2022-03-18T12:24:28+0100 lvl=eror msg="Failed to look up user based on cookie" logger=context error="user token not found"
t=2022-03-18T12:24:28+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/d/99Sungrow01/sungrow-wechselrichter status=302 remote_addr=192.168.1.99 time_ms=33 size=29 referer=
t=2022-03-18T12:24:28+0100 lvl=eror msg="Failed to look up user based on cookie" logger=context error="user token not found"
t=2022-03-18T12:24:31+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=2 size=29 referer=
t=2022-03-18T12:24:32+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:24:35+0100 lvl=eror msg="Failed to look up user based on cookie" logger=context error="user token not found"
t=2022-03-18T12:24:35+0100 lvl=info msg="Successful Login" logger=http.server User=admin@localhost
t=2022-03-18T12:24:37+0100 lvl=eror msg="Dashboard not found" logger=context userId=1 orgId=1 uname=admin error="Dashboard not found" remote_addr=192.168.1.99
t=2022-03-18T12:24:37+0100 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=GET path=/api/dashboards/uid/99Sungrow01 status=404 remote_addr=192.168.1.99 time_ms=2 size=33 referer="http://192.168.1.131:3000/d/99Sungrow01/sungrow-wechselrichter?orgId=1&refresh=30s"
t=2022-03-18T12:24:57+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:25:05+0100 lvl=eror msg="Dashboard not found" logger=context userId=1 orgId=1 uname=admin error="Dashboard not found" remote_addr=192.168.1.99
t=2022-03-18T12:25:05+0100 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=GET path=/api/dashboards/uid/99Sungrow01 status=404 remote_addr=192.168.1.99 time_ms=1 size=33 referer=http://192.168.1.131:3000/dashboard/import
t=2022-03-18T12:25:05+0100 lvl=eror msg="Dashboard not found" logger=context userId=1 orgId=1 uname=admin error="Dashboard not found" remote_addr=192.168.1.99
t=2022-03-18T12:25:05+0100 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=GET path=/api/dashboards/uid/99Sungrow01 status=404 remote_addr=192.168.1.99 time_ms=2 size=33 referer=http://192.168.1.131:3000/dashboard/import
t=2022-03-18T12:25:15+0100 lvl=eror msg="Dashboard not found" logger=context userId=1 orgId=1 uname=admin error="Dashboard not found" remote_addr=192.168.1.99
t=2022-03-18T12:25:15+0100 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=GET path=/api/dashboards/uid/99Sungrow01 status=404 remote_addr=192.168.1.99 time_ms=14 size=33 referer=http://192.168.1.131:3000/dashboard/import
t=2022-03-18T12:25:26+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:26:00+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:26:29+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:26:57+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=90 size=29 referer=
t=2022-03-18T12:27:28+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:27:58+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:28:25+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:28:59+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=59 size=29 referer=
t=2022-03-18T12:29:25+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:29:53+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:30:21+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:30:54+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=125 size=29 referer=
t=2022-03-18T12:31:22+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:31:54+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:32:42+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=87 size=29 referer=
t=2022-03-18T12:33:49+0100 lvl=info msg="Starting Grafana" logger=server version=7.5.7 commit=91de51771c branch=HEAD compiled=2021-05-17T21:16:45+0200
t=2022-03-18T12:33:49+0100 lvl=info msg="Config loaded from" logger=settings file=/usr/share/grafana/conf/defaults.ini
t=2022-03-18T12:33:49+0100 lvl=info msg="Config loaded from" logger=settings file=/etc/grafana/grafana.ini
t=2022-03-18T12:33:49+0100 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.data=/var/lib/grafana"
t=2022-03-18T12:33:49+0100 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.logs=/var/www/log/grafana"
t=2022-03-18T12:33:49+0100 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.plugins=/var/lib/grafana/plugins"
t=2022-03-18T12:33:49+0100 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.provisioning=/etc/grafana/provisioning"
t=2022-03-18T12:33:49+0100 lvl=info msg="Path Home" logger=settings path=/usr/share/grafana
t=2022-03-18T12:33:49+0100 lvl=info msg="Path Data" logger=settings path=/var/lib/grafana
t=2022-03-18T12:33:49+0100 lvl=info msg="Path Logs" logger=settings path=/var/www/log/grafana
t=2022-03-18T12:33:49+0100 lvl=info msg="Path Plugins" logger=settings path=/var/lib/grafana/plugins
t=2022-03-18T12:33:49+0100 lvl=info msg="Path Provisioning" logger=settings path=/etc/grafana/provisioning
t=2022-03-18T12:33:49+0100 lvl=info msg="App mode production" logger=settings
t=2022-03-18T12:33:49+0100 lvl=info msg="Writing PID file" logger=server path=/var/run/grafana-server.pid pid=111
t=2022-03-18T12:33:49+0100 lvl=info msg="Connecting to DB" logger=sqlstore dbtype=sqlite3
t=2022-03-18T12:33:49+0100 lvl=warn msg="SQLite database file has broader permissions than it should" logger=sqlstore path=/var/lib/grafana/grafana.db mode=-rwxrwxrwx expected=-rw-r-----
t=2022-03-18T12:33:49+0100 lvl=info msg="Starting DB migrations" logger=migrator
t=2022-03-18T12:33:49+0100 lvl=info msg="migrations completed" logger=migrator performed=0 skipped=279 duration=2.335112ms
t=2022-03-18T12:33:49+0100 lvl=info msg="Starting plugin search" logger=plugins
t=2022-03-18T12:33:51+0100 lvl=info msg="Registering plugin" logger=plugins id=input
t=2022-03-18T12:33:53+0100 lvl=info msg="Registering plugin" logger=plugins id=briangann-gauge-panel
t=2022-03-18T12:33:53+0100 lvl=info msg="Registering plugin" logger=plugins id=fetzerch-sunandmoon-datasource
t=2022-03-18T12:33:53+0100 lvl=info msg="Registering plugin" logger=plugins id=yesoreyeram-boomtable-panel
t=2022-03-18T12:33:53+0100 lvl=info msg="HTTP Server Listen" logger=http.server address=[::]:3000 protocol=http subUrl= socket=
t=2022-03-18T12:34:07+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:34:07+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:34:34+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=100 size=29 referer=
t=2022-03-18T12:35:01+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:35:29+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=41 size=29 referer=
...
Hat jemand eine Idee?

Viele Grüße und vielen Dank im voraus
Was meinst du, das du alles nochmal neu getippt hast?
Hast du das ganze Setup nochmal neu gemacht, oder alle deine Eingaben in der user.config.php nochmal gelöscht und nochmal eingetragen?

SFB
Beiträge: 5
Registriert: Di 8. Feb 2022, 00:14
Danksagung erhalten: 1 Mal

Re: Dockerimage

Beitrag von SFB »

Ich habe die Docker-Start-Parameter (-d -e ...) neu eingegeben. Mein erster Versuch war natürlich alles per cut&paste in die Container-Steuerung zu übernehmen ... und das hatte nicht geklappt.

Solaranzeige im Docker-Container in QNAP-Container-Station
WR = Sungrow SH10RT
PV-Module = 26x380Wp = 9,88kWp
Batterie = Sungrow 9,6kW

pRoJeCTiL
Beiträge: 1
Registriert: So 10. Apr 2022, 14:41

Re: Dockerimage

Beitrag von pRoJeCTiL »

Hallo zusammen,

ich bin ganz neu hier, eigentlich kein technischer Laie und ich traue mich fast nicht meine Frage zu stellen. Teilweise geht es in Foren relativ rabiat vor, wenn jemand nicht sofort zu 100% mit der Materie vertraut ist. Mit Docker habe ich noch relativ wenig bis gar keine Erfahrung. Das einzige was ich hier bisher gemacht habe ist einen kleinen Minecraft-Hausserver für meine Kids zu erstellen, damit diese bissl geschützt daddeln können.

Da ich seit Februar auch stolzer Besitzer einer PV-Anlage und Fan von grafischen Anzeigen / Auswertungen bin suche ich hierfür eine Lösung und bin auf Solaranzeige gestoßen. Dockerimage habe ich heruntergeladen, installiert und im Protokoll steht, dass das initiale Setup fertig ist und ich nun die Konfiguration durchführen soll. Sorry, hier geht es leider schon los.

Den Befehl: docker exec -ti Solaranzeige /solaranzeige/setup habe ich einfach mal in das "Terminal" eingegeben, da passiert aber nichts.

Wenn mich jemand an die Hand nehmen kann / möchte ?

Ich habe einen Plenticore plus 7 und ein KSME (Smartmeter Kostal).

Ich danke euch im voraus.

Grüße Falko

pixel01
Beiträge: 1
Registriert: Sa 16. Apr 2022, 10:24

neuste Version

Beitrag von pixel01 »

Servus!

Ist das Docker Image aktuell?
So wie ich das sehe ist es das letzte mal vor 1 Jahr aktualisiert worden.

Gab es seither keine updates an der Solaranzeige?
Oder gibt es wo anders ein aktuelles Dockerimage?

Danke!

Benutzeravatar
mdkeil
Beiträge: 107
Registriert: So 12. Sep 2021, 20:40
Hat sich bedankt: 4 Mal
Danksagung erhalten: 6 Mal

Re: Dockerimage

Beitrag von mdkeil »

Wenn du den Container mit Update=yes neustartest, wird die Solaranzeige auf den aktuellsten Stand geupdatet. Du kannst aber auch ein Update gem. Solaranzeige Doku machen, bei dem Punkt, wo man sich auf den Raspberry einloggt, einfach in den Container einloggen. Der Rest ist gleich.
Fronius Symo 20.0-3-M: 20.13kWp 61x QCell Q.PEAK DUO-G7 330, 13.2kWp S 45°, 6.93kWp (2.97/3.96) in N/S-Aufständerung mit Verschattung

zinnik
Beiträge: 2
Registriert: Mi 20. Apr 2022, 08:45

Re: Dockerimage

Beitrag von zinnik »

SFB hat geschrieben:
Fr 18. Mär 2022, 15:34
Servus!

Aaaaalso.
Ich habe jetzt meine ersten Gehversuche in Docker hinter mir.
Docker-Host : QNAP NAS mit "Container Station" (CPU-Limit: 90%, Memory Limit: 3072MB)
WR = Sungrow (Typ 70 mit Port 502)

Erste Probleme:
InfluxDB- und Mosquitto-Services starten nicht automatisch, letzterer überhaupt nicht,
und Grafana bleibt leer.

Das mit den Services erkläre ich mir damit, dass ich beim Kopieren der Parameter wohl auch unsichtbare Sonderzeichen im Text mit drin hatte. Nachdem ich jedenfalls alles neu getippt hatte und auch noch die Parameter INFLUXDB=yes und MOSQUITTO=yes unter "Advanced Settings"-"Environment" in der "Container Station" eingetragen hatte, starteten beide Services sofort nach Container-Neustart und setup.
Das mit den Sonderzeichen könnte auch bei vielen anderen Mitstreitern hier im Forum das Problem gewesen sein.

Was mir jetzt aber immer noch nicht gelingt, ist die Anzeige von irgendwelchen Daten im Grafana.
Das sungrow.php-Skript sammelt jedenfalls fleissig Daten und kann diese laut Meldung auch in die DB schreiben.
Im Grafana habe ich das passende Sungrow-Dashboard geladen und kann über "Configuration"-"Data Sources" auch beide Einträge "Solaranzeige" und "Steuerung" erfolgreich testen. Wegen einem Hinweis hier im Forum habe ich den Parameter "-p 8080:80" mal weggelassen - hat auch nicht geholfen.

Das Logfile "/var/www/log/grafana/grafana.log":

Code: Alles auswählen

t=2022-03-18T12:23:38+0100 lvl=info msg="Starting Grafana" logger=server version=7.5.7 commit=91de51771c branch=HEAD compiled=2021-05-17T21:16:45+0200
t=2022-03-18T12:23:38+0100 lvl=info msg="Config loaded from" logger=settings file=/usr/share/grafana/conf/defaults.ini
t=2022-03-18T12:23:38+0100 lvl=info msg="Config loaded from" logger=settings file=/etc/grafana/grafana.ini
t=2022-03-18T12:23:38+0100 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.data=/var/lib/grafana"
t=2022-03-18T12:23:38+0100 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.logs=/var/www/log/grafana"
t=2022-03-18T12:23:38+0100 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.plugins=/var/lib/grafana/plugins"
t=2022-03-18T12:23:38+0100 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.provisioning=/etc/grafana/provisioning"
t=2022-03-18T12:23:38+0100 lvl=info msg="Path Home" logger=settings path=/usr/share/grafana
t=2022-03-18T12:23:38+0100 lvl=info msg="Path Data" logger=settings path=/var/lib/grafana
t=2022-03-18T12:23:38+0100 lvl=info msg="Path Logs" logger=settings path=/var/www/log/grafana
t=2022-03-18T12:23:38+0100 lvl=info msg="Path Plugins" logger=settings path=/var/lib/grafana/plugins
t=2022-03-18T12:23:38+0100 lvl=info msg="Path Provisioning" logger=settings path=/etc/grafana/provisioning
t=2022-03-18T12:23:38+0100 lvl=info msg="App mode production" logger=settings
t=2022-03-18T12:23:38+0100 lvl=info msg="Writing PID file" logger=server path=/var/run/grafana-server.pid pid=112
t=2022-03-18T12:23:38+0100 lvl=info msg="Connecting to DB" logger=sqlstore dbtype=sqlite3
t=2022-03-18T12:23:38+0100 lvl=warn msg="SQLite database file has broader permissions than it should" logger=sqlstore path=/var/lib/grafana/grafana.db mode=-rwxrwxrwx expected=-rw-r-----
t=2022-03-18T12:23:38+0100 lvl=info msg="Starting DB migrations" logger=migrator
t=2022-03-18T12:23:38+0100 lvl=info msg="Executing migration" logger=migrator id="drop index IDX_temp_user_email - v1"
t=2022-03-18T12:23:38+0100 lvl=info msg="Executing migration" logger=migrator id="drop index IDX_temp_user_org_id - v1"
t=2022-03-18T12:23:38+0100 lvl=info msg="Executing migration" logger=migrator id="drop index IDX_temp_user_code - v1"
t=2022-03-18T12:23:38+0100 lvl=info msg="Executing migration" logger=migrator id="drop index IDX_temp_user_status - v1"
t=2022-03-18T12:23:38+0100 lvl=info msg="Executing migration" logger=migrator id="Rename table temp_user to temp_user_tmp_qwerty - v1"
t=2022-03-18T12:23:39+0100 lvl=info msg="Executing migration" logger=migrator id="create temp_user v2"
t=2022-03-18T12:23:39+0100 lvl=info msg="Executing migration" logger=migrator id="create index IDX_temp_user_email - v2"
t=2022-03-18T12:23:39+0100 lvl=info msg="Executing migration" logger=migrator id="create index IDX_temp_user_org_id - v2"
t=2022-03-18T12:23:39+0100 lvl=info msg="Executing migration" logger=migrator id="create index IDX_temp_user_code - v2"
t=2022-03-18T12:23:39+0100 lvl=info msg="Executing migration" logger=migrator id="create index IDX_temp_user_status - v2"
t=2022-03-18T12:23:40+0100 lvl=info msg="Executing migration" logger=migrator id="copy temp_user v1 to v2"
t=2022-03-18T12:23:40+0100 lvl=info msg="Executing migration" logger=migrator id="drop temp_user_tmp_qwerty"
t=2022-03-18T12:23:40+0100 lvl=info msg="Executing migration" logger=migrator id="Set created for temp users that will otherwise prematurely expire"
t=2022-03-18T12:23:40+0100 lvl=info msg="Executing migration" logger=migrator id="delete tags for deleted dashboards"
t=2022-03-18T12:23:40+0100 lvl=info msg="Executing migration" logger=migrator id="delete stars for deleted dashboards"
t=2022-03-18T12:23:40+0100 lvl=info msg="Executing migration" logger=migrator id="add unique index datasource_org_id_is_default"
t=2022-03-18T12:23:41+0100 lvl=info msg="Executing migration" logger=migrator id="Add encrypted dashboard json column"
t=2022-03-18T12:23:41+0100 lvl=info msg="Executing migration" logger=migrator id="Change dashboard_encrypted column to MEDIUMBLOB"
t=2022-03-18T12:23:41+0100 lvl=info msg="Executing migration" logger=migrator id="drop index UQE_alert_rule_tag_alert_id_tag_id - v1"
t=2022-03-18T12:23:41+0100 lvl=info msg="Executing migration" logger=migrator id="Rename table alert_rule_tag to alert_rule_tag_v1 - v1"
t=2022-03-18T12:23:41+0100 lvl=info msg="Executing migration" logger=migrator id="Create alert_rule_tag table v2"
t=2022-03-18T12:23:41+0100 lvl=info msg="Executing migration" logger=migrator id="create index UQE_alert_rule_tag_alert_id_tag_id - Add unique index alert_rule_tag.alert_id_tag_id V2"
t=2022-03-18T12:23:41+0100 lvl=info msg="Executing migration" logger=migrator id="copy alert_rule_tag v1 to v2"
t=2022-03-18T12:23:41+0100 lvl=info msg="Executing migration" logger=migrator id="drop table alert_rule_tag_v1"
t=2022-03-18T12:23:42+0100 lvl=info msg="Executing migration" logger=migrator id="Add column secure_settings in alert_notification"
t=2022-03-18T12:23:42+0100 lvl=info msg="Executing migration" logger=migrator id="alter alert.settings to mediumtext"
t=2022-03-18T12:23:42+0100 lvl=info msg="Executing migration" logger=migrator id="Add non-unique index alert_notification_state_alert_id"
t=2022-03-18T12:23:42+0100 lvl=info msg="Executing migration" logger=migrator id="Add non-unique index alert_rule_tag_alert_id"
t=2022-03-18T12:23:42+0100 lvl=info msg="Executing migration" logger=migrator id="drop index UQE_annotation_tag_annotation_id_tag_id - v2"
t=2022-03-18T12:23:42+0100 lvl=info msg="Executing migration" logger=migrator id="Rename table annotation_tag to annotation_tag_v2 - v2"
t=2022-03-18T12:23:42+0100 lvl=info msg="Executing migration" logger=migrator id="Create annotation_tag table v3"
t=2022-03-18T12:23:43+0100 lvl=info msg="Executing migration" logger=migrator id="create index UQE_annotation_tag_annotation_id_tag_id - Add unique index annotation_tag.annotation_id_tag_id V3"
t=2022-03-18T12:23:43+0100 lvl=info msg="Executing migration" logger=migrator id="copy annotation_tag v2 to v3"
t=2022-03-18T12:23:43+0100 lvl=info msg="Executing migration" logger=migrator id="drop table annotation_tag_v2"
t=2022-03-18T12:23:43+0100 lvl=info msg="Executing migration" logger=migrator id="add index team_member.team_id"
t=2022-03-18T12:23:43+0100 lvl=info msg="Executing migration" logger=migrator id="delete acl rules for deleted dashboards and folders"
t=2022-03-18T12:23:43+0100 lvl=info msg="Executing migration" logger=migrator id="add index user_auth_token.user_id"
t=2022-03-18T12:23:43+0100 lvl=info msg="Executing migration" logger=migrator id="Add revoked_at to the user auth token"
t=2022-03-18T12:23:44+0100 lvl=info msg="Executing migration" logger=migrator id="create short_url table v1"
t=2022-03-18T12:23:44+0100 lvl=info msg="Executing migration" logger=migrator id="add index short_url.org_id-uid"
t=2022-03-18T12:23:44+0100 lvl=info msg="migrations completed" logger=migrator performed=40 skipped=239 duration=6.330187437s
t=2022-03-18T12:23:44+0100 lvl=info msg="Starting plugin search" logger=plugins
t=2022-03-18T12:23:45+0100 lvl=info msg="Registering plugin" logger=plugins id=input
t=2022-03-18T12:23:47+0100 lvl=info msg="Registering plugin" logger=plugins id=briangann-gauge-panel
t=2022-03-18T12:23:47+0100 lvl=info msg="Registering plugin" logger=plugins id=fetzerch-sunandmoon-datasource
t=2022-03-18T12:23:47+0100 lvl=info msg="Registering plugin" logger=plugins id=yesoreyeram-boomtable-panel
t=2022-03-18T12:23:47+0100 lvl=info msg="HTTP Server Listen" logger=http.server address=[::]:3000 protocol=http subUrl= socket=
t=2022-03-18T12:24:28+0100 lvl=eror msg="Failed to look up user based on cookie" logger=context error="user token not found"
t=2022-03-18T12:24:28+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/d/99Sungrow01/sungrow-wechselrichter status=302 remote_addr=192.168.1.99 time_ms=33 size=29 referer=
t=2022-03-18T12:24:28+0100 lvl=eror msg="Failed to look up user based on cookie" logger=context error="user token not found"
t=2022-03-18T12:24:31+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=2 size=29 referer=
t=2022-03-18T12:24:32+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:24:35+0100 lvl=eror msg="Failed to look up user based on cookie" logger=context error="user token not found"
t=2022-03-18T12:24:35+0100 lvl=info msg="Successful Login" logger=http.server User=admin@localhost
t=2022-03-18T12:24:37+0100 lvl=eror msg="Dashboard not found" logger=context userId=1 orgId=1 uname=admin error="Dashboard not found" remote_addr=192.168.1.99
t=2022-03-18T12:24:37+0100 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=GET path=/api/dashboards/uid/99Sungrow01 status=404 remote_addr=192.168.1.99 time_ms=2 size=33 referer="http://192.168.1.131:3000/d/99Sungrow01/sungrow-wechselrichter?orgId=1&refresh=30s"
t=2022-03-18T12:24:57+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:25:05+0100 lvl=eror msg="Dashboard not found" logger=context userId=1 orgId=1 uname=admin error="Dashboard not found" remote_addr=192.168.1.99
t=2022-03-18T12:25:05+0100 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=GET path=/api/dashboards/uid/99Sungrow01 status=404 remote_addr=192.168.1.99 time_ms=1 size=33 referer=http://192.168.1.131:3000/dashboard/import
t=2022-03-18T12:25:05+0100 lvl=eror msg="Dashboard not found" logger=context userId=1 orgId=1 uname=admin error="Dashboard not found" remote_addr=192.168.1.99
t=2022-03-18T12:25:05+0100 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=GET path=/api/dashboards/uid/99Sungrow01 status=404 remote_addr=192.168.1.99 time_ms=2 size=33 referer=http://192.168.1.131:3000/dashboard/import
t=2022-03-18T12:25:15+0100 lvl=eror msg="Dashboard not found" logger=context userId=1 orgId=1 uname=admin error="Dashboard not found" remote_addr=192.168.1.99
t=2022-03-18T12:25:15+0100 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=GET path=/api/dashboards/uid/99Sungrow01 status=404 remote_addr=192.168.1.99 time_ms=14 size=33 referer=http://192.168.1.131:3000/dashboard/import
t=2022-03-18T12:25:26+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:26:00+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:26:29+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:26:57+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=90 size=29 referer=
t=2022-03-18T12:27:28+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:27:58+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:28:25+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:28:59+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=59 size=29 referer=
t=2022-03-18T12:29:25+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:29:53+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:30:21+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:30:54+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=125 size=29 referer=
t=2022-03-18T12:31:22+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:31:54+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:32:42+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=87 size=29 referer=
t=2022-03-18T12:33:49+0100 lvl=info msg="Starting Grafana" logger=server version=7.5.7 commit=91de51771c branch=HEAD compiled=2021-05-17T21:16:45+0200
t=2022-03-18T12:33:49+0100 lvl=info msg="Config loaded from" logger=settings file=/usr/share/grafana/conf/defaults.ini
t=2022-03-18T12:33:49+0100 lvl=info msg="Config loaded from" logger=settings file=/etc/grafana/grafana.ini
t=2022-03-18T12:33:49+0100 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.data=/var/lib/grafana"
t=2022-03-18T12:33:49+0100 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.logs=/var/www/log/grafana"
t=2022-03-18T12:33:49+0100 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.plugins=/var/lib/grafana/plugins"
t=2022-03-18T12:33:49+0100 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.provisioning=/etc/grafana/provisioning"
t=2022-03-18T12:33:49+0100 lvl=info msg="Path Home" logger=settings path=/usr/share/grafana
t=2022-03-18T12:33:49+0100 lvl=info msg="Path Data" logger=settings path=/var/lib/grafana
t=2022-03-18T12:33:49+0100 lvl=info msg="Path Logs" logger=settings path=/var/www/log/grafana
t=2022-03-18T12:33:49+0100 lvl=info msg="Path Plugins" logger=settings path=/var/lib/grafana/plugins
t=2022-03-18T12:33:49+0100 lvl=info msg="Path Provisioning" logger=settings path=/etc/grafana/provisioning
t=2022-03-18T12:33:49+0100 lvl=info msg="App mode production" logger=settings
t=2022-03-18T12:33:49+0100 lvl=info msg="Writing PID file" logger=server path=/var/run/grafana-server.pid pid=111
t=2022-03-18T12:33:49+0100 lvl=info msg="Connecting to DB" logger=sqlstore dbtype=sqlite3
t=2022-03-18T12:33:49+0100 lvl=warn msg="SQLite database file has broader permissions than it should" logger=sqlstore path=/var/lib/grafana/grafana.db mode=-rwxrwxrwx expected=-rw-r-----
t=2022-03-18T12:33:49+0100 lvl=info msg="Starting DB migrations" logger=migrator
t=2022-03-18T12:33:49+0100 lvl=info msg="migrations completed" logger=migrator performed=0 skipped=279 duration=2.335112ms
t=2022-03-18T12:33:49+0100 lvl=info msg="Starting plugin search" logger=plugins
t=2022-03-18T12:33:51+0100 lvl=info msg="Registering plugin" logger=plugins id=input
t=2022-03-18T12:33:53+0100 lvl=info msg="Registering plugin" logger=plugins id=briangann-gauge-panel
t=2022-03-18T12:33:53+0100 lvl=info msg="Registering plugin" logger=plugins id=fetzerch-sunandmoon-datasource
t=2022-03-18T12:33:53+0100 lvl=info msg="Registering plugin" logger=plugins id=yesoreyeram-boomtable-panel
t=2022-03-18T12:33:53+0100 lvl=info msg="HTTP Server Listen" logger=http.server address=[::]:3000 protocol=http subUrl= socket=
t=2022-03-18T12:34:07+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:34:07+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:34:34+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=100 size=29 referer=
t=2022-03-18T12:35:01+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=0 size=29 referer=
t=2022-03-18T12:35:29+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.1.70 time_ms=41 size=29 referer=
...
Hat jemand eine Idee?

Viele Grüße und vielen Dank im voraus
Hallo,

ich habe selbiges wie du vor. Könntest du deine Einstellungen eventuell mit Screeshots in der qnap Containerstation posten.

Da wäre ich dir sehr dankbar.

Lg sven

tutu81
Beiträge: 6
Registriert: Do 6. Jan 2022, 16:42

Re: Dockerimage

Beitrag von tutu81 »

mdkeil hat geschrieben:
Sa 16. Apr 2022, 13:46
Wenn du den Container mit Update=yes neustartest, wird die Solaranzeige auf den aktuellsten Stand geupdatet. Du kannst aber auch ein Update gem. Solaranzeige Doku machen, bei dem Punkt, wo man sich auf den Raspberry einloggt, einfach in den Container einloggen. Der Rest ist gleich.
Funkionniert ja für Solaranzeige datein. Aber bei mir ist Influx immer noch bei 1.8.6 und Grafana Grafana v7.5.7 :oops:
Wie kann ich das updaten ?

Antworten