mijago / d2statcollector Goto Github PK

I know SQL so i can kinda read this but im struggling here.

Looking for a way to exclude time if no values are present , aka, not null or not 0. This way the graph only shows the recorded data and not this:

Rework the logging and implement good non-spammy logging.
We probably do not need a lot of text, but enough info to see what went wrong (in case anything went wrong).

Im not able to connect to the WebUI of the influxDB installed though this process (http://d2stat-influxdb:8086/) -- i was hoping that i could get to some sort of data dictionary to start making more Grafina charts.

is there any way to get to the Web Ui of influxDB?

We shall provide InfluxDB retention policies to improve data storage over a long timespan.

• Discuss if you can do this automatically (in the docker compose file/s)
• Discuss which policies make the most sense.
• Keep #6 in mind.

The API also has information about medals. Add these to the metric collector too.

If you import your example dashboard into Grafana, you have to replace its uid "I9EdXRL4z" with the newly installed DB uid.

to do that, create a temporary new dashboard, edit it and view its JSON and copy that UID.

Go back to the imported "User stats" dashboard and edit that -- find and replace "I9EdXRL4z" (CTRL+H) with the uid you just got from the temp dashboard.

Save.

Then it will show your dashboard!

Right now, I use InfluxDB 1.8. We should update this to 2.x.

Goals of this issue:

• Update InfluxDB to 2.x
• Update the StatCollector to send to InfluxDB 2.x
• Present a simple way to migrate data from the old InfluxDB to the new one.

(Must have HACS installed)

Id like to use Home assistant because you can add the plugin for Grafana and influxDB from the Add-ons in Home assistant shown here:

be sure to then toggle the "Show inside bar" for each

Start by goign to the WebUI of InfluxDB and under InfluxDB Admin create the new DB "D2StatCollector"

• adjust your retention policy as needed. Defaults are fine for now.
  

I made two users: "Admin" with full privileges and a "viewer_user" with read only privileges to the "D2StatCollector" database.

Jump over to the Grafana tab and "Add your first datasource"

This next part I wasn't sure of how to go about doing so i tried this and it seemed to work -- if you have a better way -- would love to hear it.

Import Mijago's dashboard template -- we'll need ot edit the JSON and do a CTRL+H (find and replace) the datasource type value and put in D2StatCollector -- im also certain that the uid has to be updated as well.

once you have that corrected for your setup. The dashbaord should look like this:

todo: the fancy bits. (i should make more coffee)

Is it possible that I have API setup wrong?

I noticed that when trying to run "docker compose up" in CMD Windows 11 it was throwing error.

While in Powershell it worked as expected.

also, had to run that command in the folder ./D2StatCollector-master/ -- not sure if that should be specified or not in the install notes.

Implement good error handling and log it somewhere.

This must also take the following into account:

• API is down for maintenance
• API is ratelimiting us
• Any other error

The threading right now has some issues that need to be taken care of:

• We start the threads, but we do not keep track of them.
• We start one thread for every clan and member. While this is fine (as the API limits us nonetheless), this can probably be optimized.

I do not want to be too aggressive with the Bungie API.
We should reduce the amount of calls made in a short timespan.