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=
...
Viele Grüße und vielen Dank im voraus