search

AP-Hunt / FicsitRemoteMonitoringCompanion

A companion app to the Ficsit Remote Monitoring mod for Satisfactory
18 stars 7 forks source link

FRMC Staying White #5

Closed kiligir closed 2 years ago

kiligir commented 3 years ago

I've loaded up FRMC after Satfat started, launched the web server from the plugin, and... nothing. It's a white screen.

Under the Exporter tab I get:

Will contact Ficsit Remote Montioring on http://127.0.0.1:8080/
Begun exposing metrics at localhost:9000
Will collect power metrics from http://127.0.0.1:8080/getPowerData
Will collect production metrics from http://127.0.0.1:8080/getProdStats

Under the Prometheus tab I get absolutely nothing.

Under the Grafana tab I get:

t=2021-06-26T01:57:01-0400 lvl=info msg="Starting Grafana" logger=server version=7.5.7 commit=91de51771c branch=HEAD compiled=2021-05-17T15:16:45-0400
t=2021-06-26T01:57:01-0400 lvl=info msg="Config loaded from" logger=settings file=C:\\Users\\kilig\\Downloads\\FicsitRemoteMonitoringCompanion-v0.6.0\\grafana/conf/defaults.ini
t=2021-06-26T01:57:01-0400 lvl=info msg="Config loaded from" logger=settings file=C:\\Users\\kilig\\Downloads\\FicsitRemoteMonitoringCompanion-v0.6.0\\grafana\\bin\\config.ini
t=2021-06-26T01:57:01-0400 lvl=info msg="Path Home" logger=settings path=C:\\Users\\kilig\\Downloads\\FicsitRemoteMonitoringCompanion-v0.6.0\\grafana
t=2021-06-26T01:57:01-0400 lvl=info msg="Path Data" logger=settings path=C:\\Users\\kilig\\Downloads\\FicsitRemoteMonitoringCompanion-v0.6.0\\grafana\\data
t=2021-06-26T01:57:01-0400 lvl=info msg="Path Logs" logger=settings path=C:\\Users\\kilig\\Downloads\\FicsitRemoteMonitoringCompanion-v0.6.0\\grafana\\data\\log
t=2021-06-26T01:57:01-0400 lvl=info msg="Path Plugins" logger=settings path=C:\\Users\\kilig\\Downloads\\FicsitRemoteMonitoringCompanion-v0.6.0\\grafana\\data\\plugins
t=2021-06-26T01:57:01-0400 lvl=info msg="Path Provisioning" logger=settings path=C:\\Users\\kilig\\Downloads\\FicsitRemoteMonitoringCompanion-v0.6.0\\grafana\\conf\\provisioning
t=2021-06-26T01:57:01-0400 lvl=info msg="App mode production" logger=settings
t=2021-06-26T01:57:01-0400 lvl=info msg="Connecting to DB" logger=sqlstore dbtype=sqlite3
t=2021-06-26T01:57:01-0400 lvl=warn msg="SQLite database file has broader permissions than it should" logger=sqlstore path=C:\\Users\\kilig\\Downloads\\FicsitRemoteMonitoringCompanion-v0.6.0\\grafana\\data\\grafana.db mode=-rw-rw-rw- expected=-rw-r-----
t=2021-06-26T01:57:01-0400 lvl=info msg="Starting DB migrations" logger=migrator
t=2021-06-26T01:57:01-0400 lvl=info msg="migrations completed" logger=migrator performed=0 skipped=279 duration=499.8µs
t=2021-06-26T01:57:01-0400 lvl=info msg="Starting plugin search" logger=plugins
t=2021-06-26T01:57:01-0400 lvl=info msg="Registering plugin" logger=plugins id=input
t=2021-06-26T01:57:01-0400 lvl=info msg="HTTP Server Listen" logger=http.server address=[::]:3000 protocol=http subUrl= socket=
t=2021-06-26T01:57:01-0400 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=ficsit method=GET path=/api/datasources/uid/prometheus status=404 remote_addr=[::1] time_ms=22 size=35 referer=
t=2021-06-26T01:57:01-0400 lvl=eror msg="data source with the same name already exists" logger=context userId=1 orgId=1 uname=ficsit error="data source with the same name already exists" remote_addr=[::1]
t=2021-06-26T01:57:01-0400 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=ficsit method=POST path=/api/datasources status=409 remote_addr=[::1] time_ms=13 size=59 referer=
t=2021-06-26T01:57:01-0400 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=ficsit method=PUT path=/api/folders/ficsit status=404 remote_addr=[::1] time_ms=11 size=51 referer=

I've made sure to add the four *.exe files to my firewall exceptions in Defender (running Win 10 Pro 19041.1052), and even went as far as to open 8080 and 9000 (which I really don't like at all.) I have, of course, restarted things. All to no avail!

The save file I'm dealing with has ~1200 hours on it and is very large, so that may be the problem. I've let the program run for a solid hour and no luck there either, just in case it was taking forever and lacked a loading bar.

AP-Hunt commented 3 years ago

Hi @kiligir

I'm aware this is affecting multiple users, but I haven't been able to replicate it myself yet, so thanks for the sharing logs.

I'm going to look to find a fix in the next week, life permitting.

kiligir commented 3 years ago

Hi @kiligir

I'm aware this is affecting multiple users, but I haven't been able to replicate it myself yet, so thanks for the sharing logs.

I'm going to look to find a fix in the next week, life permitting.

Take your time, my man. Thank you for the work!

kulcris commented 3 years ago

Json results from http://127.0.0.1:8080/getProdStats

[{"ItemName": "Iron Ore","ProdPerMin": "P: 120.0/120.0/min - C: 0.0/0.0/min","ProdPercent": 1.0,"ConsPercent": 0.0,"CurrentProd":120.0,"MaxProd": 120.0,"CurrentConsumed": 0.0,"MaxConsumed": 0.0, "Type": "Belt"},{"ItemName": "Limestone","ProdPerMin": "P: 0.0/0.0/min - C: 0.0/0.0/min","ProdPercent": 0.0,"ConsPercent": 0.0,"CurrentProd":0.0,"MaxProd": 0.0,"CurrentConsumed": 0.0,"MaxConsumed": 0.0, "Type": "Belt"}]

exporter

Will contact Ficsit Remote Montioring on http://127.0.0.1:8080/
Begun exposing metrics at localhost:9000
Will collect power metrics from http://127.0.0.1:8080/getPowerData
Will collect production metrics from http://127.0.0.1:8080/getProdStats
No connection could be made because the target machine actively refused it. No connection could be made because the target machine actively refused it.
No connection could be made because the target machine actively refused it. No connection could be made because the target machine actively refused it.
No connection could be made because the target machine actively refused it. No connection could be made because the target machine actively refused it.
No connection could be made because the target machine actively refused it. No connection could be made because the target machine actively refused it.
No connection could be made because the target machine actively refused it. No connection could be made because the target machine actively refused it.
No connection could be made because the target machine actively refused it. No connection could be made because the target machine actively refused it.
No connection could be made because the target machine actively refused it. No connection could be made because the target machine actively refused it.
No connection could be made because the target machine actively refused it. No connection could be made because the target machine actively refused it.

PROMETHEUS = BLANK

grafana

t=2021-06-28T16:06:07-0500 lvl=info msg="Starting Grafana" logger=server version=7.5.7 commit=91de51771c branch=HEAD compiled=2021-05-17T14:16:45-0500
t=2021-06-28T16:06:07-0500 lvl=info msg="Config loaded from" logger=settings file=C:\\Users\\Chris\\Desktop\\folder\\grafana/conf/defaults.ini
t=2021-06-28T16:06:07-0500 lvl=info msg="Config loaded from" logger=settings file=C:\\Users\\Chris\\Desktop\\folder\\grafana\\bin\\config.ini
t=2021-06-28T16:06:07-0500 lvl=info msg="Path Home" logger=settings path=C:\\Users\\Chris\\Desktop\\folder\\grafana
t=2021-06-28T16:06:07-0500 lvl=info msg="Path Data" logger=settings path=C:\\Users\\Chris\\Desktop\\folder\\grafana\\data
t=2021-06-28T16:06:07-0500 lvl=info msg="Path Logs" logger=settings path=C:\\Users\\Chris\\Desktop\\folder\\grafana\\data\\log
t=2021-06-28T16:06:07-0500 lvl=info msg="Path Plugins" logger=settings path=C:\\Users\\Chris\\Desktop\\folder\\grafana\\data\\plugins
t=2021-06-28T16:06:07-0500 lvl=info msg="Path Provisioning" logger=settings path=C:\\Users\\Chris\\Desktop\\folder\\grafana\\conf\\provisioning
t=2021-06-28T16:06:07-0500 lvl=info msg="App mode production" logger=settings
t=2021-06-28T16:06:07-0500 lvl=info msg="Connecting to DB" logger=sqlstore dbtype=sqlite3
t=2021-06-28T16:06:07-0500 lvl=warn msg="SQLite database file has broader permissions than it should" logger=sqlstore path=C:\\Users\\Chris\\Desktop\\folder\\grafana\\data\\grafana.db mode=-rw-rw-rw- expected=-rw-r-----
t=2021-06-28T16:06:07-0500 lvl=info msg="Starting DB migrations" logger=migrator
t=2021-06-28T16:06:07-0500 lvl=info msg="migrations completed" logger=migrator performed=0 skipped=279 duration=500.2µs
t=2021-06-28T16:06:07-0500 lvl=info msg="Starting plugin search" logger=plugins
t=2021-06-28T16:06:07-0500 lvl=info msg="Registering plugin" logger=plugins id=input
t=2021-06-28T16:06:07-0500 lvl=info msg="HTTP Server Listen" logger=http.server address=[::]:3000 protocol=http subUrl= socket=
t=2021-06-28T16:06:07-0500 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=ficsit method=GET path=/api/datasources/uid/prometheus status=404 remote_addr=[::1] time_ms=13 size=35 referer=
t=2021-06-28T16:06:07-0500 lvl=eror msg="data source with the same name already exists" logger=context userId=1 orgId=1 uname=ficsit error="data source with the same name already exists" remote_addr=[::1]
t=2021-06-28T16:06:07-0500 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=ficsit method=POST path=/api/datasources status=409 remote_addr=[::1] time_ms=10 size=59 referer=
t=2021-06-28T16:06:07-0500 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=ficsit method=PUT path=/api/folders/ficsit status=404 remote_addr=[::1] time_ms=10 size=51 referer=

image

I was having an issue where my pc was refusing connection as well but that doesnt seem to be the issue anymore (fixed by renaming folder to folder instead of new folder (3) not sure if that actually fixed it or if it fixed itself when i forse closed app and restarted)

I have tried administrator on both satisfactory and the remote monitoring companion

AP-Hunt commented 3 years ago

As a work around, you might be able to go to http://localhost:3000 in your browser will the app is running.

When it says "actively refused the connection" it's usually because the mod's web server isn't running.

Thanks for the extra info again. Much appreciated.

On Mon, 28 Jun 2021, 22:14 kulcris, @.***> wrote:

Json results from http://127.0.0.1:8080/getProdStats

[{"ItemName": "Iron Ore","ProdPerMin": "P: 120.0/120.0/min - C: 0.0/0.0/min","ProdPercent": 1.0,"ConsPercent": 0.0,"CurrentProd":120.0,"MaxProd": 120.0,"CurrentConsumed": 0.0,"MaxConsumed": 0.0, "Type": "Belt"},{"ItemName": "Limestone","ProdPerMin": "P: 0.0/0.0/min - C: 0.0/0.0/min","ProdPercent": 0.0,"ConsPercent": 0.0,"CurrentProd":0.0,"MaxProd": 0.0,"CurrentConsumed": 0.0,"MaxConsumed": 0.0, "Type": "Belt"}]

exporter

Will contact Ficsit Remote Montioring on http://127.0.0.1:8080/

Begun exposing metrics at localhost:9000

Will collect power metrics from http://127.0.0.1:8080/getPowerData

Will collect production metrics from http://127.0.0.1:8080/getProdStats

No connection could be made because the target machine actively refused it. No connection could be made because the target machine actively refused it.

No connection could be made because the target machine actively refused it. No connection could be made because the target machine actively refused it.

No connection could be made because the target machine actively refused it. No connection could be made because the target machine actively refused it.

No connection could be made because the target machine actively refused it. No connection could be made because the target machine actively refused it.

No connection could be made because the target machine actively refused it. No connection could be made because the target machine actively refused it.

No connection could be made because the target machine actively refused it. No connection could be made because the target machine actively refused it.

No connection could be made because the target machine actively refused it. No connection could be made because the target machine actively refused it.

No connection could be made because the target machine actively refused it. No connection could be made because the target machine actively refused it.

PROMETHEUS = BLANK

grafana

t=2021-06-28T16:06:07-0500 lvl=info msg="Starting Grafana" logger=server version=7.5.7 commit=91de51771c branch=HEAD compiled=2021-05-17T14:16:45-0500

t=2021-06-28T16:06:07-0500 lvl=info msg="Config loaded from" logger=settings file=C:\Users\Chris\Desktop\folder\grafana/conf/defaults.ini

t=2021-06-28T16:06:07-0500 lvl=info msg="Config loaded from" logger=settings file=C:\Users\Chris\Desktop\folder\grafana\bin\config.ini

t=2021-06-28T16:06:07-0500 lvl=info msg="Path Home" logger=settings path=C:\Users\Chris\Desktop\folder\grafana

t=2021-06-28T16:06:07-0500 lvl=info msg="Path Data" logger=settings path=C:\Users\Chris\Desktop\folder\grafana\data

t=2021-06-28T16:06:07-0500 lvl=info msg="Path Logs" logger=settings path=C:\Users\Chris\Desktop\folder\grafana\data\log

t=2021-06-28T16:06:07-0500 lvl=info msg="Path Plugins" logger=settings path=C:\Users\Chris\Desktop\folder\grafana\data\plugins

t=2021-06-28T16:06:07-0500 lvl=info msg="Path Provisioning" logger=settings path=C:\Users\Chris\Desktop\folder\grafana\conf\provisioning

t=2021-06-28T16:06:07-0500 lvl=info msg="App mode production" logger=settings

t=2021-06-28T16:06:07-0500 lvl=info msg="Connecting to DB" logger=sqlstore dbtype=sqlite3

t=2021-06-28T16:06:07-0500 lvl=warn msg="SQLite database file has broader permissions than it should" logger=sqlstore path=C:\Users\Chris\Desktop\folder\grafana\data\grafana.db mode=-rw-rw-rw- expected=-rw-r-----

t=2021-06-28T16:06:07-0500 lvl=info msg="Starting DB migrations" logger=migrator

t=2021-06-28T16:06:07-0500 lvl=info msg="migrations completed" logger=migrator performed=0 skipped=279 duration=500.2µs

t=2021-06-28T16:06:07-0500 lvl=info msg="Starting plugin search" logger=plugins

t=2021-06-28T16:06:07-0500 lvl=info msg="Registering plugin" logger=plugins id=input

t=2021-06-28T16:06:07-0500 lvl=info msg="HTTP Server Listen" logger=http.server address=[::]:3000 protocol=http subUrl= socket=

t=2021-06-28T16:06:07-0500 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=ficsit method=GET path=/api/datasources/uid/prometheus status=404 remote_addr=[::1] time_ms=13 size=35 referer=

t=2021-06-28T16:06:07-0500 lvl=eror msg="data source with the same name already exists" logger=context userId=1 orgId=1 uname=ficsit error="data source with the same name already exists" remote_addr=[::1]

t=2021-06-28T16:06:07-0500 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=ficsit method=POST path=/api/datasources status=409 remote_addr=[::1] time_ms=10 size=59 referer=

t=2021-06-28T16:06:07-0500 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=ficsit method=PUT path=/api/folders/ficsit status=404 remote_addr=[::1] time_ms=10 size=51 referer=

[image: image] https://user-images.githubusercontent.com/2667394/123704677-8a467a00-d82b-11eb-8964-e4414a4f6f81.png

I was having an issue where my pc was refusing connection as well but that doesnt seem to be the issue anymore (fixed by renaming folder to folder instead of new folder (3) not sure if that actually fixed it or if it fixed itself when i forse closed app and restarted)

I have tried administrator on both satisfactory and the remote monitoring companion

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/AP-Hunt/FicsitRemoteMonitoringCompanion/issues/5#issuecomment-870046922, or unsubscribe https://github.com/notifications/unsubscribe-auth/AANKTOTLMAJEVKZSQIDJNR3TVDQ23ANCNFSM47LATXBQ .

kulcris commented 3 years ago

image

when on ficsit org it shows nothing, but when i switch to main org it shows a database i can look at

AP-Hunt commented 3 years ago

Interesting. I'll take a deeper look later this week. Thanks for persisting with it.

On Mon, 28 Jun 2021, 22:23 kulcris, @.***> wrote:

[image: image] https://user-images.githubusercontent.com/2667394/123705875-1efda780-d82d-11eb-9207-6d282621187d.png

when on ficsit org it shows nothing, but when i switch to main org it shows a database i can look at

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/AP-Hunt/FicsitRemoteMonitoringCompanion/issues/5#issuecomment-870054300, or unsubscribe https://github.com/notifications/unsubscribe-auth/AANKTOVJDA7VKR3RVNYFF4LTVDR55ANCNFSM47LATXBQ .

kulcris commented 3 years ago

np, and.... never mind it looks like the info IS in the Ficsit tab, image Im going to play around with it to see if i can get it to work, if i can il let you know my work around so you can narrow it down

kulcris commented 3 years ago

Last post i will make unless i fix it :P sorry about the spam

ok yes the issue with main org and ficsit org was correct i must have done the Prometheus import (now have a fresh install)

Here is the log from first time startup along with a few api calls i did to see how things were showing up

From what i can tell the folder ficsit does not get created and instead the default dashboard gets put into "general" under "main org"

looks like atleast one of the API calls are also wrong? I noticed you do "/api/datasources/uid/prometheus" when from what i can gather it should be "/api/datasources/name/prometheus" ^ i think this may be the main issue as it is throwing everything else off in both the creation and viewing.

First startup log

t=2021-06-28T17:16:09-0500 lvl=info msg="Starting Grafana" logger=server version=7.5.7 commit=91de51771c branch=HEAD compiled=2021-05-17T14:16:45-0500
t=2021-06-28T17:16:09-0500 lvl=info msg="Config loaded from" logger=settings file=C:\\Users\\Chris\\Desktop\\folder\\grafana/conf/defaults.ini
t=2021-06-28T17:16:09-0500 lvl=info msg="Config loaded from" logger=settings file=C:\\Users\\Chris\\Desktop\\folder\\grafana\\bin\\config.ini
t=2021-06-28T17:16:09-0500 lvl=info msg="Path Home" logger=settings path=C:\\Users\\Chris\\Desktop\\folder\\grafana
t=2021-06-28T17:16:09-0500 lvl=info msg="Path Data" logger=settings path=C:\\Users\\Chris\\Desktop\\folder\\grafana\\data
t=2021-06-28T17:16:09-0500 lvl=info msg="Path Logs" logger=settings path=C:\\Users\\Chris\\Desktop\\folder\\grafana\\data\\log
t=2021-06-28T17:16:09-0500 lvl=info msg="Path Plugins" logger=settings path=C:\\Users\\Chris\\Desktop\\folder\\grafana\\data\\plugins
t=2021-06-28T17:16:09-0500 lvl=info msg="Path Provisioning" logger=settings path=C:\\Users\\Chris\\Desktop\\folder\\grafana\\conf\\provisioning
t=2021-06-28T17:16:09-0500 lvl=info msg="App mode production" logger=settings
t=2021-06-28T17:16:09-0500 lvl=info msg="Connecting to DB" logger=sqlstore dbtype=sqlite3
t=2021-06-28T17:16:09-0500 lvl=info msg="Creating SQLite database file" logger=sqlstore path=C:\\Users\\Chris\\Desktop\\folder\\grafana\\data\\grafana.db
t=2021-06-28T17:16:09-0500 lvl=info msg="Starting DB migrations" logger=migrator
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="create migration_log table"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="create user table"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="add unique index user.login"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="add unique index user.email"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="drop index UQE_user_login - v1"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="drop index UQE_user_email - v1"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Rename table user to user_v1 - v1"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="create user table v2"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="create index UQE_user_login - v2"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="create index UQE_user_email - v2"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="copy data_source v1 to v2"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Drop old table user_v1"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Add column help_flags1 to user table"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Update user table charset"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Add last_seen_at column to user"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Add missing user data"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Add is_disabled column to user"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Add index user.login/user.email"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="create temp user table v1-7"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="create index IDX_temp_user_email - v1-7"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="create index IDX_temp_user_org_id - v1-7"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="create index IDX_temp_user_code - v1-7"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="create index IDX_temp_user_status - v1-7"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Update temp_user table charset"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="drop index IDX_temp_user_email - v1"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="drop index IDX_temp_user_org_id - v1"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="drop index IDX_temp_user_code - v1"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="drop index IDX_temp_user_status - v1"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Rename table temp_user to temp_user_tmp_qwerty - v1"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="create temp_user v2"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="create index IDX_temp_user_email - v2"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="create index IDX_temp_user_org_id - v2"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="create index IDX_temp_user_code - v2"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="create index IDX_temp_user_status - v2"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="copy temp_user v1 to v2"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="drop temp_user_tmp_qwerty"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Set created for temp users that will otherwise prematurely expire"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="create star table"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="add unique index star.user_id_dashboard_id"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="create org table v1"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="create index UQE_org_name - v1"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="create org_user table v1"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="create index IDX_org_user_org_id - v1"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="create index UQE_org_user_org_id_user_id - v1"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Update org table charset"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Update org_user table charset"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Migrate all Read Only Viewers to Viewers"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="create dashboard table"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="add index dashboard.account_id"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="add unique index dashboard_account_id_slug"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="create dashboard_tag table"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="add unique index dashboard_tag.dasboard_id_term"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="drop index UQE_dashboard_tag_dashboard_id_term - v1"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Rename table dashboard to dashboard_v1 - v1"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="create dashboard v2"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="create index IDX_dashboard_org_id - v2"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="create index UQE_dashboard_org_id_slug - v2"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="copy dashboard v1 to v2"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="drop table dashboard_v1"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="alter dashboard.data to mediumtext v1"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Add column updated_by in dashboard - v2"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Add column created_by in dashboard - v2"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Add column gnetId in dashboard"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Add index for gnetId in dashboard"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Add column plugin_id in dashboard"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Add index for plugin_id in dashboard"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Add index for dashboard_id in dashboard_tag"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Update dashboard table charset"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Update dashboard_tag table charset"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Add column folder_id in dashboard"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Add column isFolder in dashboard"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Add column has_acl in dashboard"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Add column uid in dashboard"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Update uid column values in dashboard"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Add unique index dashboard_org_id_uid"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Remove unique index org_id_slug"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Update dashboard title length"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Add unique index for dashboard_org_id_title_folder_id"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="create dashboard_provisioning"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="Rename table dashboard_provisioning to dashboard_provisioning_tmp_qwerty - v1"
t=2021-06-28T17:16:09-0500 lvl=info msg="Executing migration" logger=migrator id="create dashboard_provisioning v2"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create index IDX_dashboard_provisioning_dashboard_id - v2"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create index IDX_dashboard_provisioning_dashboard_id_name - v2"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="copy dashboard_provisioning v1 to v2"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="drop dashboard_provisioning_tmp_qwerty"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add check_sum column"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add index for dashboard_title"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="delete tags for deleted dashboards"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="delete stars for deleted dashboards"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create data_source table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add index data_source.account_id"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add unique index data_source.account_id_name"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="drop index IDX_data_source_account_id - v1"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="drop index UQE_data_source_account_id_name - v1"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Rename table data_source to data_source_v1 - v1"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create data_source table v2"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create index IDX_data_source_org_id - v2"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create index UQE_data_source_org_id_name - v2"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="copy data_source v1 to v2"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Drop old table data_source_v1 #2"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add column with_credentials"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add secure json data column"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Update data_source table charset"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Update initial version to 1"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add read_only data column"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Migrate logging ds to loki ds"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Update json_data with nulls"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add uid column"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Update uid value"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add unique index datasource_org_id_uid"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add unique index datasource_org_id_is_default"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create api_key table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add index api_key.account_id"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add index api_key.key"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add index api_key.account_id_name"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="drop index IDX_api_key_account_id - v1"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="drop index UQE_api_key_key - v1"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="drop index UQE_api_key_account_id_name - v1"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Rename table api_key to api_key_v1 - v1"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create api_key table v2"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create index IDX_api_key_org_id - v2"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create index UQE_api_key_key - v2"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create index UQE_api_key_org_id_name - v2"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="copy api_key v1 to v2"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Drop old table api_key_v1"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Update api_key table charset"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add expires to api_key table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create dashboard_snapshot table v4"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="drop table dashboard_snapshot_v4 #1"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create dashboard_snapshot table v5 #2"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create index UQE_dashboard_snapshot_key - v5"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create index UQE_dashboard_snapshot_delete_key - v5"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create index IDX_dashboard_snapshot_user_id - v5"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="alter dashboard_snapshot to mediumtext v2"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Update dashboard_snapshot table charset"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add column external_delete_url to dashboard_snapshots table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add encrypted dashboard json column"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Change dashboard_encrypted column to MEDIUMBLOB"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create quota table v1"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create index UQE_quota_org_id_user_id_target - v1"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Update quota table charset"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create plugin_setting table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create index UQE_plugin_setting_org_id_plugin_id - v1"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add column plugin_version to plugin_settings"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Update plugin_setting table charset"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create session table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Drop old table playlist table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Drop old table playlist_item table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create playlist table v2"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create playlist item table v2"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Update playlist table charset"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Update playlist_item table charset"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="drop preferences table v2"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="drop preferences table v3"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create preferences table v3"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Update preferences table charset"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add column team_id in preferences"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Update team_id column values in preferences"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create alert table v1"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add index alert org_id & id "
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add index alert state"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add index alert dashboard_id"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Create alert_rule_tag table v1"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add unique index alert_rule_tag.alert_id_tag_id"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="drop index UQE_alert_rule_tag_alert_id_tag_id - v1"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Rename table alert_rule_tag to alert_rule_tag_v1 - v1"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Create alert_rule_tag table v2"
t=2021-06-28T17:16:10-0500 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=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="copy alert_rule_tag v1 to v2"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="drop table alert_rule_tag_v1"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create alert_notification table v1"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add column is_default"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add column frequency"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add column send_reminder"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add column disable_resolve_message"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add index alert_notification org_id & name"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Update alert table charset"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Update alert_notification table charset"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create notification_journal table v1"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add index notification_journal org_id & alert_id & notifier_id"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="drop alert_notification_journal"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create alert_notification_state table v1"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add index alert_notification_state org_id & alert_id & notifier_id"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add for to alert table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add column uid in alert_notification"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Update uid column values in alert_notification"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add unique index alert_notification_org_id_uid"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Remove unique index org_id_name"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add column secure_settings in alert_notification"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="alter alert.settings to mediumtext"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add non-unique index alert_notification_state_alert_id"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add non-unique index alert_rule_tag_alert_id"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Drop old annotation table v4"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create annotation table v5"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add index annotation 0 v3"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add index annotation 1 v3"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add index annotation 2 v3"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add index annotation 3 v3"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add index annotation 4 v3"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Update annotation table charset"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add column region_id to annotation table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Drop category_id index"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add column tags to annotation table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Create annotation_tag table v2"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add unique index annotation_tag.annotation_id_tag_id"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="drop index UQE_annotation_tag_annotation_id_tag_id - v2"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Rename table annotation_tag to annotation_tag_v2 - v2"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Create annotation_tag table v3"
t=2021-06-28T17:16:10-0500 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=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="copy annotation_tag v2 to v3"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="drop table annotation_tag_v2"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Update alert annotations and set TEXT to empty"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add created time to annotation table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add updated time to annotation table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add index for created in annotation table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add index for updated in annotation table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Convert existing annotations from seconds to milliseconds"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add epoch_end column"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add index for epoch_end"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Make epoch_end the same as epoch"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Move region to single row"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Remove index org_id_epoch from annotation table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Remove index org_id_dashboard_id_panel_id_epoch from annotation table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add index for org_id_dashboard_id_epoch_end_epoch on annotation table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add index for org_id_epoch_end_epoch on annotation table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Remove index org_id_epoch_epoch_end from annotation table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add index for alert_id on annotation table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create test_data table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create dashboard_version table v1"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add index dashboard_version.dashboard_id"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add unique index dashboard_version.dashboard_id and dashboard_version.version"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Set dashboard version to 1 where 0"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="save existing dashboard data in dashboard_version table v1"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="alter dashboard_version.data to mediumtext v1"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create team table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add index team.org_id"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add unique index team_org_id_name"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create team member table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add index team_member.org_id"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add unique index team_member_org_id_team_id_user_id"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add index team_member.team_id"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add column email to team table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add column external to team_member table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add column permission to team_member table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create dashboard acl table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add index dashboard_acl_dashboard_id"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add unique index dashboard_acl_dashboard_id_user_id"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add unique index dashboard_acl_dashboard_id_team_id"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="save default acl rules in dashboard_acl table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="delete acl rules for deleted dashboards and folders"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create tag table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add index tag.key_value"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create login attempt table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add index login_attempt.username"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="drop index IDX_login_attempt_username - v1"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Rename table login_attempt to login_attempt_tmp_qwerty - v1"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create login_attempt v2"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create index IDX_login_attempt_username - v2"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="copy login_attempt v1 to v2"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="drop login_attempt_tmp_qwerty"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create user auth table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create index IDX_user_auth_auth_module_auth_id - v1"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="alter user_auth.auth_id to length 190"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add OAuth access token to user_auth"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add OAuth refresh token to user_auth"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add OAuth token type to user_auth"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add OAuth expiry to user_auth"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add index to user_id column in user_auth"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create server_lock table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add index server_lock.operation_uid"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create user auth token table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add unique index user_auth_token.auth_token"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add unique index user_auth_token.prev_auth_token"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add index user_auth_token.user_id"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="Add revoked_at to the user auth token"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create cache_data table"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add unique index cache_data.cache_key"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="create short_url table v1"
t=2021-06-28T17:16:10-0500 lvl=info msg="Executing migration" logger=migrator id="add index short_url.org_id-uid"
t=2021-06-28T17:16:10-0500 lvl=info msg="migrations completed" logger=migrator performed=279 skipped=0 duration=1.1439801s
t=2021-06-28T17:16:10-0500 lvl=info msg="Created default admin" logger=sqlstore user=ficsit
t=2021-06-28T17:16:10-0500 lvl=info msg="Created default organization" logger=sqlstore
t=2021-06-28T17:16:10-0500 lvl=info msg="Starting plugin search" logger=plugins
t=2021-06-28T17:16:10-0500 lvl=info msg="Registering plugin" logger=plugins id=input
t=2021-06-28T17:16:10-0500 lvl=info msg="External plugins directory created" logger=plugins directory=C:\\Users\\Chris\\Desktop\\folder\\grafana\\data\\plugins
t=2021-06-28T17:16:11-0500 lvl=info msg="HTTP Server Listen" logger=http.server address=[::]:3000 protocol=http subUrl= socket=
t=2021-06-28T17:16:11-0500 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=ficsit method=GET path=/api/datasources/uid/prometheus status=404 remote_addr=[::1] time_ms=15 size=35 referer=
t=2021-06-28T17:16:11-0500 lvl=eror msg="Organization not found" logger=context userId=1 orgId=1 uname=ficsit error="organization not found" remote_addr=[::1]
t=2021-06-28T17:16:11-0500 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=ficsit method=GET path=/api/orgs/name/Ficsit status=404 remote_addr=[::1] time_ms=11 size=36 referer=
t=2021-06-28T17:16:11-0500 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=ficsit method=PUT path=/api/folders/ficsit status=404 remote_addr=[::1] time_ms=11 size=51 referer=

http://localhost:3000/api/datasources

[{"id":1,"uid":"U-sKZpk7z","orgId":1,"name":"prometheus","type":"prometheus","typeName":"Prometheus","typeLogoUrl":"public/app/plugins/datasource/prometheus/img/prometheus_logo.svg","access":"proxy","url":"http://localhost:9090","password":"","user":"","database":"","basicAuth":false,"isDefault":false,"jsonData":{},"readOnly":false}]

http://localhost:3000/api/orgs

[{"id":2,"name":"Ficsit"},{"id":1,"name":"Main Org."}]
AP-Hunt commented 3 years ago

https://github.com/AP-Hunt/FicsitRemoteMonitoringCompanion/pull/6 is an attempt to fix this. It'll get merged when I've time tomorrow.

kulcris commented 3 years ago

built but the datasource is still not being found according to the log (404) still white screen

AP-Hunt commented 3 years ago

The 404 on the data source is a red herring, I think. Before it's created for the first time, it gives a 404 to indicate it doesn't yet exist.

Thanks for building from that branch and trying it. I've not been able to replicate what you're seeing yet, which is a little frustrating! The branch in PR #6 largely focuses on simplifying and instrumenting, in the hopes of getting it located.

Did the new logs show you anything? Does Visual Studio give you any useful output?

On Wed, 30 Jun 2021, 22:06 kulcris, @.***> wrote:

built but the datasource is still not being found according to the log (404) still white screen

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/AP-Hunt/FicsitRemoteMonitoringCompanion/issues/5#issuecomment-871727330, or unsubscribe https://github.com/notifications/unsubscribe-auth/AANKTOSOZHJ67C2ZW6LHZL3TVOBMVANCNFSM47LATXBQ .

kulcris commented 3 years ago

so one thing i noticed while looking at the code you never set the UID for prometheus so it gets randomly assigned, but then you search by UID

kulcris commented 3 years ago

only thing visual studio gave me was something along the lines of TAR exit with code 1 (for copying over grafana)

AP-Hunt commented 3 years ago

Ooh, interesting. Thanks! Feel free to raise a PR on that if I don't get to it before tomorrow.

On Wed, 30 Jun 2021, 22:13 kulcris, @.***> wrote:

so one thing i noticed while looking at the code you never set the UID for prometheus so it gets randomly assigned, but then you search by UID

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/AP-Hunt/FicsitRemoteMonitoringCompanion/issues/5#issuecomment-871731475, or unsubscribe https://github.com/notifications/unsubscribe-auth/AANKTOXXTXYZTDPX3AKQXU3TVOCHZANCNFSM47LATXBQ .

kulcris commented 3 years ago

OH! logs show its still looking for ficsit org (anon user) sorry iv been playing around with it trying to get it to work with your current changes, i can edit but dont know enough to make large changes. il keep at messing with it though i feel like its almost there!

kulcris commented 3 years ago

could any of these settings be the issue?

image

kulcris commented 3 years ago

this is my current log 

t=2021-06-30T16:57:59-0500 lvl=info msg="Starting Grafana" logger=server version=7.5.7 commit=91de51771c branch=HEAD compiled=2021-05-17T14:16:45-0500
t=2021-06-30T16:57:59-0500 lvl=info msg="Config loaded from" logger=settings file=C:\\Users\\Chris\\Desktop\\fic\\Companion\\bin\\Debug\\netcoreapp3.1\\grafana/conf/defaults.ini
t=2021-06-30T16:57:59-0500 lvl=info msg="Config loaded from" logger=settings file=C:\\Users\\Chris\\Desktop\\fic\\Companion\\bin\\Debug\\netcoreapp3.1\\grafana\\bin\\config.ini
t=2021-06-30T16:57:59-0500 lvl=info msg="Path Home" logger=settings path=C:\\Users\\Chris\\Desktop\\fic\\Companion\\bin\\Debug\\netcoreapp3.1\\grafana
t=2021-06-30T16:57:59-0500 lvl=info msg="Path Data" logger=settings path=C:\\Users\\Chris\\Desktop\\fic\\Companion\\bin\\Debug\\netcoreapp3.1\\grafana\\data
t=2021-06-30T16:57:59-0500 lvl=info msg="Path Logs" logger=settings path=C:\\Users\\Chris\\Desktop\\fic\\Companion\\bin\\Debug\\netcoreapp3.1\\grafana\\data\\log
t=2021-06-30T16:57:59-0500 lvl=info msg="Path Plugins" logger=settings path=C:\\Users\\Chris\\Desktop\\fic\\Companion\\bin\\Debug\\netcoreapp3.1\\grafana\\data\\plugins
t=2021-06-30T16:57:59-0500 lvl=info msg="Path Provisioning" logger=settings path=C:\\Users\\Chris\\Desktop\\fic\\Companion\\bin\\Debug\\netcoreapp3.1\\grafana\\conf\\provisioning
t=2021-06-30T16:57:59-0500 lvl=info msg="App mode production" logger=settings
t=2021-06-30T16:57:59-0500 lvl=info msg="Connecting to DB" logger=sqlstore dbtype=sqlite3
t=2021-06-30T16:57:59-0500 lvl=warn msg="SQLite database file has broader permissions than it should" logger=sqlstore path=C:\\Users\\Chris\\Desktop\\fic\\Companion\\bin\\Debug\\netcoreapp3.1\\grafana\\data\\grafana.db mode=-rw-rw-rw- expected=-rw-r-----
t=2021-06-30T16:57:59-0500 lvl=info msg="Starting DB migrations" logger=migrator
t=2021-06-30T16:57:59-0500 lvl=info msg="migrations completed" logger=migrator performed=0 skipped=279 duration=0s
t=2021-06-30T16:57:59-0500 lvl=info msg="Starting plugin search" logger=plugins
t=2021-06-30T16:57:59-0500 lvl=info msg="Registering plugin" logger=plugins id=input
t=2021-06-30T16:57:59-0500 lvl=info msg="HTTP Server Listen" logger=http.server address=[::]:3000 protocol=http subUrl= socket=
[2021-06-30T16:57:58.8986167-05:00] waiting for Grafana API to be available
[2021-06-30T16:57:59.4678937-05:00] Grafana API is ready
[2021-06-30T16:57:59.5442417-05:00] Created Grafana dashboard: Power
[2021-06-30T16:57:59.6062371-05:00] Created Grafana dashboard: Production
[2021-06-30T16:57:59.6228446-05:00] waiting for Grafana UI to be ready
[2021-06-30T16:57:59.6373413-05:00] Grafana UI is ready
AP-Hunt commented 3 years ago

I'm starting to think it's a problem with the web browser component I'm using. It seems like Prometheus, Grafana, and the Prometheus exporter are all behaving as they should; especially given that you're able to visit Grafana in your regular browser. I'll look at how to debug that.

On Wed, 30 Jun 2021, 22:58 kulcris, @.***> wrote:

this is my current log

t=2021-06-30T16:57:59-0500 lvl=info msg="Starting Grafana" logger=server version=7.5.7 commit=91de51771c branch=HEAD compiled=2021-05-17T14:16:45-0500 t=2021-06-30T16:57:59-0500 lvl=info msg="Config loaded from" logger=settings file=C:\Users\Chris\Desktop\fic\Companion\bin\Debug\netcoreapp3.1\grafana/conf/defaults.ini t=2021-06-30T16:57:59-0500 lvl=info msg="Config loaded from" logger=settings file=C:\Users\Chris\Desktop\fic\Companion\bin\Debug\netcoreapp3.1\grafana\bin\config.ini t=2021-06-30T16:57:59-0500 lvl=info msg="Path Home" logger=settings path=C:\Users\Chris\Desktop\fic\Companion\bin\Debug\netcoreapp3.1\grafana t=2021-06-30T16:57:59-0500 lvl=info msg="Path Data" logger=settings path=C:\Users\Chris\Desktop\fic\Companion\bin\Debug\netcoreapp3.1\grafana\data t=2021-06-30T16:57:59-0500 lvl=info msg="Path Logs" logger=settings path=C:\Users\Chris\Desktop\fic\Companion\bin\Debug\netcoreapp3.1\grafana\data\log t=2021-06-30T16:57:59-0500 lvl=info msg="Path Plugins" logger=settings path=C:\Users\Chris\Desktop\fic\Companion\bin\Debug\netcoreapp3.1\grafana\data\plugins t=2021-06-30T16:57:59-0500 lvl=info msg="Path Provisioning" logger=settings path=C:\Users\Chris\Desktop\fic\Companion\bin\Debug\netcoreapp3.1\grafana\conf\provisioning t=2021-06-30T16:57:59-0500 lvl=info msg="App mode production" logger=settings t=2021-06-30T16:57:59-0500 lvl=info msg="Connecting to DB" logger=sqlstore dbtype=sqlite3 t=2021-06-30T16:57:59-0500 lvl=warn msg="SQLite database file has broader permissions than it should" logger=sqlstore path=C:\Users\Chris\Desktop\fic\Companion\bin\Debug\netcoreapp3.1\grafana\data\grafana.db mode=-rw-rw-rw- expected=-rw-r----- t=2021-06-30T16:57:59-0500 lvl=info msg="Starting DB migrations" logger=migrator t=2021-06-30T16:57:59-0500 lvl=info msg="migrations completed" logger=migrator performed=0 skipped=279 duration=0s t=2021-06-30T16:57:59-0500 lvl=info msg="Starting plugin search" logger=plugins t=2021-06-30T16:57:59-0500 lvl=info msg="Registering plugin" logger=plugins id=input t=2021-06-30T16:57:59-0500 lvl=info msg="HTTP Server Listen" logger=http.server address=[::]:3000 protocol=http subUrl= socket=

[2021-06-30T16:57:58.8986167-05:00] waiting for Grafana API to be available [2021-06-30T16:57:59.4678937-05:00] Grafana API is ready [2021-06-30T16:57:59.5442417-05:00] Created Grafana dashboard: Power [2021-06-30T16:57:59.6062371-05:00] Created Grafana dashboard: Production [2021-06-30T16:57:59.6228446-05:00] waiting for Grafana UI to be ready [2021-06-30T16:57:59.6373413-05:00] Grafana UI is ready

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/AP-Hunt/FicsitRemoteMonitoringCompanion/issues/5#issuecomment-871754074, or unsubscribe https://github.com/notifications/unsubscribe-auth/AANKTOQ3NYR337V34BNE6PTTVOHQ3ANCNFSM47LATXBQ .

kulcris commented 3 years ago

THATS IT!

image i installed this branch of edge and it started displaying

kulcris commented 3 years ago

https://docs.microsoft.com/en-us/answers/questions/126385/webview2-control-no-longer-displaying-web-content.html

kulcris commented 3 years ago

this is with current release version image

AP-Hunt commented 3 years ago

Brilliant! I'm glad it's working for you, and thanks for sticking with it. I'll look at what exactly is wrong with WebView2 and put out a release with that fix on top of PRs #6 #7 and #8

kulcris commented 3 years ago

Sorry I don't know.much about GitHub or I would have done one PR.

On Thu, Jul 1, 2021, 8:25 AM Andy Hunt @.***> wrote:

Brilliant! I'm glad it's working for you, and thanks for sticking with it. I'll look at what exactly is wrong with WebView2 and put out a release with that fix on top of PRs #6 https://github.com/AP-Hunt/FicsitRemoteMonitoringCompanion/pull/6 #7 https://github.com/AP-Hunt/FicsitRemoteMonitoringCompanion/pull/7 and #8 https://github.com/AP-Hunt/FicsitRemoteMonitoringCompanion/pull/8

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/AP-Hunt/FicsitRemoteMonitoringCompanion/issues/5#issuecomment-872245731, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAULHAQKDPTOUGOX2RYPJNDTVRUD5ANCNFSM47LATXBQ .

AP-Hunt commented 3 years ago

It's cool. I'm happy with 2 PRs. They're easier to review and reason about.

AP-Hunt commented 3 years ago

PR #6 is merged now, and might fix the issue. It's hard to tell, and even harder to replicate. I'll release it alongside a fix for #3

kulcris commented 3 years ago

when trying to build image

il hold off till you are ready! :P

AP-Hunt commented 3 years ago

You might need to rebase your changes, if you haven't already. It's building and running fine from main right now, or at least it is on my machine :joy:

kulcris commented 3 years ago

still white without edge beta installed

kulcris commented 3 years ago

[2021-07-01T15:36:47.0901367-05:00] initialising web view [2021-07-01T15:36:47.0948203-05:00] error initialising web view: Couldn't find a compatible Webview2 Runtime installation to host WebViews.

AP-Hunt commented 3 years ago

Oh, that's interesting! This could be a hard limitation of the web view component. So much for being a drop in replacement for the standard WPF browser control!

I wonder what else is out there ...

On Thu, 1 Jul 2021, 21:37 kulcris, @.***> wrote:

[2021-07-01T15:36:47.0901367-05:00] initialising web view [2021-07-01T15:36:47.0948203-05:00] error initialising web view: Couldn't find a compatible Webview2 Runtime installation to host WebViews.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/AP-Hunt/FicsitRemoteMonitoringCompanion/issues/5#issuecomment-872535013, or unsubscribe https://github.com/notifications/unsubscribe-auth/AANKTOREEAGSSNQ3PZGK6U3TVTGZZANCNFSM47LATXBQ .

AP-Hunt commented 2 years ago

Hi @kulcris and @kiligir.

I think the fact it doesn't start properly without MS Edge installed is going to be a won't/can't fix on my part. I can't think of a better solution for displaying web pages in a Windows application than WebView2 as it stands, and requiring Edge to be installed looks to be a limitation of that.

I'll cut a new release containing the fixes that've come out of this issue. Thanks for all your help, I really appreciate it.