Access to VWFriends and grafana

[BelIblis31]

Hello,

I successfully installed the packages on docker.
However, trying to access my server on ports 4000 and 4001 I automatically am switched to HTTPS and I get an error : SSL_ERROR_RX_RECORD_TOO_LONG

On VWsFriend log I have the following:

2022-03-13T18:23:36+0000:INFO:vwsfriend_base:vwsfriend 0.16.4 (using WeConnect-python 0.37.2)
2022-03-13T18:23:36+0000:INFO:session_manager:Could not use token from file /tmp/weconnect.token ([Errno 2] No such file or directory: '/tmp/weconnect.token')
2022-03-13T18:23:39+0000:ERROR:agent_connector:Could not establish a connection to database, will try again after 10 seconds: (psycopg2.OperationalError) connection to server at "postgresdbbackend" (172.30.0.2), port 5432 failed: Connection refused
	Is the server running on that host and accepting TCP/IP connections?

(Background on this error at: https://sqlalche.me/e/14/e3q8)
2022-03-13T18:23:49+0000:INFO:agent_connector:It looks like you have an empty database will create all tables
2022-03-13T18:23:56+0000:INFO:migration:Context impl PostgresqlImpl.
2022-03-13T18:23:56+0000:INFO:migration:Will assume transactional DDL.
2022-03-13T18:23:56+0000:INFO:migration:Running stamp_revision  -> 79ac0505ad35
2022-03-13T18:23:57+0000:INFO:vwsfriend_ui:VWsFriend is listening on 0.0.0.0:4000)
2022-03-13T18:23:57+0000:INFO:vwsfriend_base:Updating data from WeConnect
2022-03-13T18:24:02+0000:INFO:agent_connector:Found no matching vehicle for vin WVWZZZE1ZMP085473 in database, will create a new one
2022-03-13T18:24:02+0000:INFO:trip_agent:Vehicle WVWZZZE1ZMP085473 provides isActive flag in readinessStatus and thus allows to record trips with several minutes inaccuracy
2022-03-13T18:25:24+0000:ERROR:_internal:172.30.0.1 - - [13/Mar/2022 18:25:24] code 400, message Bad request version ('éºÆ\x07\x93Ð%ePü¿\x01UG·Î!|\x00"\x13\x01\x13\x03\x13\x02À+À/̨̩À,À0À')
2022-03-13T18:25:24+0000:INFO:_internal:172.30.0.1 - - [13/Mar/2022 18:25:24] "����

On Grafana log I have this :

logger=migrator t=2022-03-13T18:24:18.56+0000 lvl=info msg="Executing migration" id="create builtin role table"
logger=migrator t=2022-03-13T18:24:18.7+0000 lvl=info msg="Executing migration" id="add index builtin_role.role_id"
logger=migrator t=2022-03-13T18:24:18.83+0000 lvl=info msg="Executing migration" id="add index builtin_role.name"
logger=migrator t=2022-03-13T18:24:18.97+0000 lvl=info msg="Executing migration" id="Add column org_id to builtin_role table"
logger=migrator t=2022-03-13T18:24:19.1+0000 lvl=info msg="Executing migration" id="add index builtin_role.org_id"
logger=migrator t=2022-03-13T18:24:19.27+0000 lvl=info msg="Executing migration" id="add unique index builtin_role_org_id_role_id_role"
logger=migrator t=2022-03-13T18:24:19.43+0000 lvl=info msg="Executing migration" id="Remove unique index role_org_id_uid"
logger=migrator t=2022-03-13T18:24:19.57+0000 lvl=info msg="Executing migration" id="add unique index role.uid"
logger=migrator t=2022-03-13T18:24:19.76+0000 lvl=info msg="Executing migration" id="create seed assignment table"
logger=migrator t=2022-03-13T18:24:19.92+0000 lvl=info msg="Executing migration" id="add unique index builtin_role_role_name"
logger=migrator t=2022-03-13T18:24:20.06+0000 lvl=info msg="Executing migration" id="create query_history table v1"
logger=migrator t=2022-03-13T18:24:20.18+0000 lvl=info msg="Executing migration" id="add index query_history.org_id-created_by-datasource_uid"
logger=migrator t=2022-03-13T18:24:20.31+0000 lvl=info msg="migrations completed" performed=385 skipped=0 duration=1m28.236509368s
logger=sqlstore t=2022-03-13T18:24:20.34+0000 lvl=info msg="Created default admin" user=admin
logger=sqlstore t=2022-03-13T18:24:20.34+0000 lvl=info msg="Created default organization"
logger=plugin.manager t=2022-03-13T18:24:20.66+0000 lvl=info msg="Plugin registered" pluginId=input
logger=plugin.signature.validator t=2022-03-13T18:24:21.23+0000 lvl=warn msg="Permitting unsigned plugin. This is not recommended" pluginID=panodata-map-panel pluginDir=/var/lib/grafana/plugins/panodata-map-panel
logger=plugin.manager t=2022-03-13T18:24:21.23+0000 lvl=info msg="Plugin registered" pluginId=pr0ps-trackmap-panel
logger=plugin.manager t=2022-03-13T18:24:21.23+0000 lvl=info msg="Plugin registered" pluginId=gapit-htmlgraphics-panel
logger=plugin.manager t=2022-03-13T18:24:21.23+0000 lvl=info msg="Plugin registered" pluginId=marcusolsson-json-datasource
logger=plugin.manager t=2022-03-13T18:24:21.23+0000 lvl=info msg="Plugin registered" pluginId=natel-plotly-panel
logger=plugin.manager t=2022-03-13T18:24:21.23+0000 lvl=info msg="Plugin registered" pluginId=panodata-map-panel
logger=query_data t=2022-03-13T18:24:21.23+0000 lvl=info msg="Query Service initialization"
logger=live.push_http t=2022-03-13T18:24:21.24+0000 lvl=info msg="Live Push Gateway initialization"
logger=provisioning.datasources t=2022-03-13T18:24:22.04+0000 lvl=warn msg="[Deprecated] the use of password field is deprecated. Please use secureJsonData.password" datasourcename="VWsFriend Live"
logger=provisioning.datasources t=2022-03-13T18:24:22.04+0000 lvl=info msg="inserting datasource from configuration " name="VWsFriend Live" uid=P36D08C1A0297C737
logger=provisioning.datasources t=2022-03-13T18:24:22.21+0000 lvl=info msg="inserting datasource from configuration " name=VWsFriend uid=P2EF847825A020B66
logger=ngalert t=2022-03-13T18:24:22.42+0000 lvl=info msg="warming cache for startup"
logger=ngalert.multiorg.alertmanager t=2022-03-13T18:24:22.43+0000 lvl=info msg="starting MultiOrg Alertmanager"
logger=http.server t=2022-03-13T18:24:22.52+0000 lvl=info msg="HTTP Server Listen" address=[::]:4001 protocol=http subUrl= socket=
logger=server t=2022-03-13T18:26:16.23+0000 lvl=info msg="Shutdown started" reason="System signal: terminated"
logger=tracing t=2022-03-13T18:26:16.23+0000 lvl=info msg="Closing tracing"
logger=ngalert t=2022-03-13T18:26:16.23+0000 lvl=eror msg="unable to fetch orgIds" msg="context canceled"
✔ Downloaded marcusolsson-json-datasource v1.3.1 zip successfully

Please restart Grafana after installing plugins. Refer to Grafana documentation for instructions if necessary.

✔ Downloaded pr0ps-trackmap-panel v2.1.2 zip successfully

Please restart Grafana after installing plugins. Refer to Grafana documentation for instructions if necessary.

✔ Downloaded natel-plotly-panel v0.0.7 zip successfully

Please restart Grafana after installing plugins. Refer to Grafana documentation for instructions if necessary.

✔ Downloaded gapit-htmlgraphics-panel v2.0.2 zip successfully

Please restart Grafana after installing plugins. Refer to Grafana documentation for instructions if necessary.

✔ Downloaded panodata-map-panel v0.16.0 zip successfully

Please restart Grafana after installing plugins. Refer to Grafana documentation for instructions if necessary.

logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="Starting Grafana" version=8.4.3 commit=b7d2911cac branch=HEAD compiled=2022-03-02T13:01:27Z
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=warn msg="falling back to legacy setting of 'min_interval_seconds'; please use the configuration option in the `unified_alerting` section if Grafana 8 alerts are enabled."
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="Config loaded from" file=/usr/share/grafana/conf/defaults.ini
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="Config loaded from" file=/etc/grafana/grafana.ini
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="Config overridden from command line" arg="default.paths.data=/var/lib/grafana"
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="Config overridden from command line" arg="default.paths.logs=/var/log/grafana"
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="Config overridden from command line" arg="default.paths.plugins=/var/lib/grafana/plugins"
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="Config overridden from command line" arg="default.paths.provisioning=/etc/grafana/provisioning"
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="Config overridden from command line" arg="default.log.mode=console"
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="Config overridden from Environment variable" var="GF_PATHS_DATA=/var/lib/grafana"
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="Config overridden from Environment variable" var="GF_PATHS_LOGS=/var/log/grafana"
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="Config overridden from Environment variable" var="GF_PATHS_PLUGINS=/var/lib/grafana/plugins"
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="Config overridden from Environment variable" var="GF_PATHS_PROVISIONING=/etc/grafana/provisioning"
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="Config overridden from Environment variable" var="GF_SERVER_HTTP_PORT=4001"
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="Config overridden from Environment variable" var="GF_SERVER_ENABLE_GZIP=true"
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="Config overridden from Environment variable" var="GF_SECURITY_ADMIN_USER=admin"
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="Config overridden from Environment variable" var="GF_SECURITY_ADMIN_PASSWORD=*********"
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="Config overridden from Environment variable" var="GF_DASHBOARDS_DEFAULT_HOME_DASHBOARD_PATH=/var/lib/grafana-static/dashboards/vwsfriend/VWsFriend/overview.json"
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="Config overridden from Environment variable" var="GF_USERS_ALLOW_SIGN_UP=false"
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="Config overridden from Environment variable" var="GF_ALERTING_ENABLED=false"
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="Config overridden from Environment variable" var="GF_EXPLORE_ENABLED=false"
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="Config overridden from Environment variable" var="GF_METRICS_ENABLED=false"
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="Config overridden from Environment variable" var="GF_PLUGINS_ALLOW_LOADING_UNSIGNED_PLUGINS=panodata-map-panel"
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="Config overridden from Environment variable" var="GF_PLUGINS_PLUGIN_ADMIN_ENABLED=false"
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="Config overridden from Environment variable" var="GF_EXPRESSIONS_ENABLED=false"
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="Path Home" path=/usr/share/grafana
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="Path Data" path=/var/lib/grafana
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="Path Logs" path=/var/log/grafana
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="Path Plugins" path=/var/lib/grafana/plugins
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="Path Provisioning" path=/etc/grafana/provisioning
logger=settings t=2022-03-13T18:26:56.27+0000 lvl=info msg="App mode production"
logger=sqlstore t=2022-03-13T18:26:56.27+0000 lvl=info msg="Connecting to DB" dbtype=sqlite3
logger=migrator t=2022-03-13T18:26:56.3+0000 lvl=info msg="Starting DB migrations"
logger=migrator t=2022-03-13T18:26:56.31+0000 lvl=info msg="migrations completed" performed=0 skipped=381 duration=1.104023ms
logger=plugin.manager t=2022-03-13T18:26:56.38+0000 lvl=info msg="Plugin registered" pluginId=input
logger=plugin.signature.validator t=2022-03-13T18:26:56.57+0000 lvl=warn msg="Permitting unsigned plugin. This is not recommended" pluginID=panodata-map-panel pluginDir=/var/lib/grafana/plugins/panodata-map-panel
logger=plugin.manager t=2022-03-13T18:26:56.57+0000 lvl=info msg="Plugin registered" pluginId=pr0ps-trackmap-panel
logger=plugin.manager t=2022-03-13T18:26:56.57+0000 lvl=info msg="Plugin registered" pluginId=gapit-htmlgraphics-panel
logger=plugin.manager t=2022-03-13T18:26:56.57+0000 lvl=info msg="Plugin registered" pluginId=marcusolsson-json-datasource
logger=plugin.manager t=2022-03-13T18:26:56.57+0000 lvl=info msg="Plugin registered" pluginId=natel-plotly-panel
logger=plugin.manager t=2022-03-13T18:26:56.57+0000 lvl=info msg="Plugin registered" pluginId=panodata-map-panel
logger=query_data t=2022-03-13T18:26:56.57+0000 lvl=info msg="Query Service initialization"
logger=live.push_http t=2022-03-13T18:26:56.57+0000 lvl=info msg="Live Push Gateway initialization"
logger=provisioning.datasources t=2022-03-13T18:26:56.69+0000 lvl=warn msg="[Deprecated] the use of password field is deprecated. Please use secureJsonData.password" datasourcename="VWsFriend Live"
logger=http.server t=2022-03-13T18:26:57.12+0000 lvl=info msg="HTTP Server Listen" address=[::]:4001 protocol=http subUrl= socket=
logger=ngalert t=2022-03-13T18:26:57.12+0000 lvl=info msg="warming cache for startup"
logger=ngalert.multiorg.alertmanager t=2022-03-13T18:26:57.12+0000 lvl=info msg="starting MultiOrg Alertmanager"

I am quite lost to findout where is the configuration issue.
do you have any suggestion ?

[tillsteinbach]

It looks like there are multiple errors. First of all the postgres database cannot be reached. Is it really running and accessible?
Then by default you should only reach VWsFriend through port 4000 not 4001. is maybe something else listening on 4001? And usually you should not be forwarded to https. Can you try maybe another browser or clean the cache?

[tillsteinbach]

Ok, the UI still is not accessible on port 4000?

[BelIblis31]

Yes same situation:
if I connect to serverIP:4000 i have no answer.
if I connect to my-domain:4000 I get the SSL_ERROR_RX_RECORD_TOO_LONG

[tillsteinbach]

is there maybe something else also running on port 4000?

[BelIblis31]

I tried again and I now can access with another Web browser.
For any reason I can’t access with local IP and Firefow wants to be on SSL connection only

[tillsteinbach]

hmmm, somehow the network configuration of that server seems strange.