Тёмный

NEXT LEVEL STATISTICS - Home Assistant InfluxDB and Grafana 

Everything Smart Home
Подписаться 199 тыс.
Просмотров 125 тыс.
50% 1

In this video we take a look at Installing InfluxDB and Grafana with Home Assistant, giving you access to next level data logging, statistics and analytics so that you can retain your Home Assistant sensor data for longer, allowing you to do long term visualization and graphing of your data to view trends. We go through how to install InfluxDB and Grafana, the difference between InfluxDB and MariaDB and we also create a couple of basic graphs inside Grafana.
If you'd like to support me and future projects:
Patreon:
/ everythingsmarthome
Buy Me a Coffee:
www.buymeacoffee.com/EverySma...
Written Article:
everythingsmarthome.co.uk
EVERYWHERE YOU CAN FIND ME:
Everything Smart Home Community Discord:
/ discord
Twitter: / everysmarthome (@EverySmartHome)
Instagram: / everythingsmarthome
Facebook: / everythingsmarthomeoff...
#homeassistant #smarthome
________________________
Some of the links above are affiliate links, where I earn a small commission if you click on the link and purchase an item. You are not obligated to do so, but it does help fund these videos in hopes of bringing value to you!
0:00 - Intro
1:06 - Pre-warning
1:24 - What do InfluxDB and Grafana do?
2:56 - Practical application of what you can use it for
3:32 - InfluxDB vs MariaDB
4:52 - InfluxDB Installation and Configuration
8:13 - Grafana Installation and Configuration
10:15 - Using Grafana, creating a systems monitoring dashboard with 4 Graphs.
34:33 - Outro

Наука

Опубликовано:

 

5 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 192   
@Bijstandskoning
@Bijstandskoning Год назад
Dude! Thank you. This is the best vid on grafana, influx and home assistant on youtube.
@donbaker3598
@donbaker3598 Год назад
Great video. Used it today to install both products. Thanks for taking the time to create this content.
@laneyweb
@laneyweb 3 года назад
Hey Lewis, really great content. I like the speed you cut the videos to so I can follow along quickly (or pause and rewind a lot!). Appreciate the time you take.
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Thanks Darren! Glad it's useful and appreciate the support!
@Gambriman
@Gambriman Год назад
Thank you for the tutorial, so much faster to watch an easy to follow work-through than trying to figure it on my own!
@williamhickey5376
@williamhickey5376 Год назад
Thank you for this! Such a great, clear & concise tutorial.
@Dox-IOT
@Dox-IOT 3 года назад
As usual, an understandable and useful Tuesday. Thanks! 👍
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Thank you as always for commenting and supporting!
@JamieVids76
@JamieVids76 Год назад
I have finally taken the plunge, energy prices and all (and uncontrollable geek traits). Great tutorial once again. Will be interesting to see how my dashboards turn out in a few months. One thing I have done from the start is used the Include parameter so I can control exactly what goes into the db and keep it small. A lot of work initially but probably worth it.
@matharu863
@matharu863 3 года назад
Thank You.. very informative Have watched a few of your other videos too recently and subscribed! Keep up the good work!
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Thanks, appreciate it! 🙏
@tatersaladfpv1033
@tatersaladfpv1033 3 года назад
FYI to hover over any part of the graph and see the displayed data (instead of hovering over each point) Panel > Display > tooltip mode > all Took me a while but I finally found it. That also bugged me before.
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Thanks Taylor, that should definitely be turned on by default, I have no idea why anyone would want the other behaviour!
@cbhiii
@cbhiii 2 года назад
Thank you Lewis! Great step by step tutorial.
@EverythingSmartHome
@EverythingSmartHome 2 года назад
Your welcome!
@ronniemagatti3342
@ronniemagatti3342 Год назад
This was a great video. Thanks for putting it together!
@EverythingSmartHome
@EverythingSmartHome Год назад
Thanks Ronnie!
@andymok7945
@andymok7945 Год назад
Thanks. Over a year ago, I installed Grafana and influxdb and did a partial setup, but never finished. I got caught up with other stuff and other stuff happened. Decided that I need to get back on track and get it going. Removed my installs ans followed your video. I now have it running and will keep at it.
@streetwiztech5505
@streetwiztech5505 3 года назад
Informative video as always, end the video knowing more than i did at the start. Starting to enjoy tuesdays :-) Thanks
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Thanks appreciate the support and thanks for commenting for the algorithm! 😅
@drkgumby
@drkgumby 3 года назад
Very timely. I have been wanting to setup this type of monitoring and dashboards.
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Let me know how it goes! 🙏
@jamiewilliams3050
@jamiewilliams3050 3 года назад
Great work! Thanks for the valuable info 😊
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Thanks Jamie!!
@maheonpieri6081
@maheonpieri6081 Год назад
Thank you so much!! Your videos are so good an helpful :D
@johndoudar6395
@johndoudar6395 3 года назад
Another great video, now have it fully working. Enjoy your coffee.
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Thanks John, glad you found it useful!
@tatersaladfpv1033
@tatersaladfpv1033 3 года назад
Loving the videos! Keep it up!
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Thanks Taylor! 🙏
@saladinbrandt
@saladinbrandt 2 года назад
Again a very helpful video! Many thanks ...
@EverythingSmartHome
@EverythingSmartHome 2 года назад
Thanks, appreciate the comment!
@pavolholes
@pavolholes 3 года назад
Hi Lewis, honestly? I installed InfluxDB about two months ago and I got stuck on something and I didn’t get back to it it. But thanks to this video I’m going to finish that up now and I’m sure it will take me no time thanks to you. Thanks so much for amazing content!
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Awesome glad it helped!!
@miguelgarcia-vg1fh
@miguelgarcia-vg1fh 3 года назад
As always great content!
@EverythingSmartHome
@EverythingSmartHome 3 года назад
And as always, thanks for commenting and for the support!
@JiltedGeek
@JiltedGeek 2 года назад
Excellent video (again), thank you so much!
@EverythingSmartHome
@EverythingSmartHome 2 года назад
Thanks!
@lukagodnic
@lukagodnic 3 года назад
Great video, thanks. Would like to see more about the biomass boiler and optimizations mentioned at the beginning...
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Thanks appreciate it!
@MaxGoddur
@MaxGoddur 3 года назад
Hi, great video. Across the top towards the left, there is the icon for grafana next to that moving to the right, from the grafan icon, in your video is HOME but on mine, I see General/Home does that make any difference in the setup procedure?
@johntisbury
@johntisbury 2 года назад
This was excellent, thank you.
@EverythingSmartHome
@EverythingSmartHome 2 года назад
Thanks for watching!
@Dorff_Meister
@Dorff_Meister 2 года назад
Thanks! Tonight, I used this and your related video to setup both influxdb and mariadb with 372 day retention. I guess I'll have to use them to watch my free disk space, now ;) I figured out how to embed Grafana graphs directly in a Lovelace dashboard, but tonight I also found the Plotly Graph Card (HACS) which I think I'll love. I've been using the apexcharts-card (HACS) and like it a lot.
@josebatalha2804
@josebatalha2804 Год назад
Hi, Could you please explain how did you do the embeding of Grafana graphs in the lovelace dashbord ?
@Dorff_Meister
@Dorff_Meister Год назад
@@josebatalha2804 Grafana has a way to get a URL for a graph. I used this. It worked fine but I think would stop displaying (authentication reasons, I think) and IIRC they didn't display in the app or maybe when I wasn't home. So I didn't find them useful and quit using almost immediately. I tend to use ApexCharts for all my charts although I've played with Grafana and Plotly (I think I still have stats so I can view them in Grafana, I just don't).
@josebatalha2804
@josebatalha2804 Год назад
Hi, another great video ! Do you by chance know how can I embed Grafana graphs directly in a Lovelace dashboard ? Cheers
@daleholden
@daleholden 3 года назад
Great video Lewis very interesting
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Thanks Dale, appreciate the support!
@fred7flinstone
@fred7flinstone 3 года назад
Very well explained.
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Cheers Steve!
@baldoibs
@baldoibs Год назад
Great video! Thank you. Can I do a query to measure how long time a switch was "on"?
@MarcioTorres
@MarcioTorres 2 года назад
Ótimo vídeo, obrigado por disponibilizar seu conhecimento. Sucesso sempre!
@Chimpster21
@Chimpster21 8 месяцев назад
Thanks for the guide, very helpful. Is there a way of mounting the database to external storage, like a NAS?
@SteevioC
@SteevioC 2 года назад
Great video 👍
@mmatviichuk
@mmatviichuk 3 года назад
Thank you for another great video! It will be good if you can cover the positive and negative sides of different installations ways of Home Assistant. For example image on a virtual machine, RPI with Home Assistant Operating System, RPI with Home Assistant Container etc.
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Thanks Maksym! I will add it to the list!
@MananKakkar
@MananKakkar Год назад
@@EverythingSmartHome I wish I knew this. There's so much in HA as a n00b that I have had to learn after the fact.
@M1L31
@M1L31 2 года назад
excellent video easy if you know what you are doing 😊
@EverythingSmartHome
@EverythingSmartHome 2 года назад
Thanks!
@jshearman17
@jshearman17 11 месяцев назад
Hey Lewis. Would you be able to share a link to the video where you show off the biomass boiler controls?
@smashimone
@smashimone Год назад
Great Tutorial ! - @17:05 My panel does not show option to auto select data refresh period. Not sure if they removed this option in my release of Grafana or do I have to do something else to get that option to be availlable?
@3736june
@3736june 2 года назад
nice and clear Thank you very much
@EverythingSmartHome
@EverythingSmartHome 2 года назад
Thanks my friend!
@makeitworktech
@makeitworktech 2 года назад
so awesome!
@uSlackr
@uSlackr 2 года назад
Lewis, I se this upmonths ago but didn't build the dashboards. Trying today but I don't see any of the OS performance counters. Only HA entities. Is there something else that needs to be on>? FWIW, I have the HA Blue Odroid. Thanks for another good walkthrough
@michalf84
@michalf84 2 года назад
Many thanks for the video what do you use maria vs influxdb for?
@davidjohnson2782
@davidjohnson2782 3 года назад
Is there any way to integrate the graphs from grafana into the lovelace ui, ie so they can be displayed amongst the usual home assistant overview?
@EverythingSmartHome
@EverythingSmartHome 3 года назад
I'm not sure at the moment but will investigate!
@paulbateman3287
@paulbateman3287 2 года назад
Click to share the dashboard or the panel and copy the url. Create a webpage widget in your lovelace dashboard and paste in the url. Add &kiosk at the end of the url to remove menus.
@dumpsterdiner
@dumpsterdiner 2 года назад
@@paulbateman3287 Godsend 🙏
@WallyUK
@WallyUK 3 года назад
Really interesting video, for those people using a pi with an SD Card, is there a way of mounting say, an external HDD/USB HDD or a network share to use for the DB? - or would we have to look to migrating the machine over to a VM/setup with more reliable storage medium?
@EverythingSmartHome
@EverythingSmartHome 3 года назад
If you have a Pi with an SD card then I would recommend moving to a cheap SSD that you can use on the USB port, that should help you along a good bit! Hopefully it's a Pi 4 you have
@WallyUK
@WallyUK 3 года назад
@@EverythingSmartHome Great! it is indeed! thanks for the advice! will look into it!
@walideshtiwi6303
@walideshtiwi6303 3 года назад
Thank you very useful
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Thank you! 🙏
@zyghom
@zyghom 2 года назад
superb! applied ;-)
@EverythingSmartHome
@EverythingSmartHome 2 года назад
Thanks!!
@PauloCarvalhoPMSC
@PauloCarvalhoPMSC 3 года назад
Awesome Video! just missed how on the end when you are on the dashboard and the buttons to change the time periods appear form nowhere.. how did you do that magic?
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Thanks Paulo! If you click on the dashboard settings button in the too right hand side and then untick "hide time picker" that should help!
@danbendavid-ipad2236
@danbendavid-ipad2236 3 года назад
Hi , I would like to compute the average of the sensor (I.e power consumption kw) but from 8am to 8pm for the last 30 day. How to to do this ?
@WernerWagener87
@WernerWagener87 10 месяцев назад
great tutorial! Thanks!
@SamuelWakefield
@SamuelWakefield 3 года назад
Hello again ... I don't use a RasPi for HA (Ubuntu VM) but wondering if you can recommend a piece of software to check the health of a SD card?
@LeivHendrickx
@LeivHendrickx 2 года назад
Awesome videos @Everything Smart Home! Just one question, I just now followed these instructions and it seems as though I dont have any autorefresh options when editing the panel... any tips? I am using Grafana v8.1.2
@LeivHendrickx
@LeivHendrickx 2 года назад
ah, in my case, seems that the autorefresh is not in the query, but on the dashboard itself. So guess that answers that one....
@patrick.denessen
@patrick.denessen 3 года назад
Great Video, but I am running HA on a Raspberry PI with a SD card which is not ideal for storing this kind of data. Therefore have I installed InfluxDB 2.0 in a docker container on my Synology NAS, but am strugling to get this working. Perhaps you can give guidance on how to connect to an external influxdb 2.0 database as well.
@DanieleInaudi
@DanieleInaudi 2 года назад
I would like to plot the status and target temperature of a thermostat, but it looks like those entities are not exported to influx. Is there a way to add them? Thanks
@notofinterest
@notofinterest 3 года назад
I‘ld like to store long term data in influx and more temporarily datas in sqlite or mariadb. There is no way to do so, cause ha just knows record: and store them parallel into both, right?
@martink9785
@martink9785 3 года назад
Thank you for getting me going! :) Wouldn't it be great to be able to add Grafana panels directly into the HA dashboard?
@EverythingSmartHome
@EverythingSmartHome 3 года назад
That would be nice, I'm sure a method exists somewhere! 😅
@martink9785
@martink9785 3 года назад
@@EverythingSmartHome been looking, seems like a pain in the butt. Hopefully it'll come sometime 🙂
@maslianok
@maslianok 3 года назад
Thanks for the tutorial, Is it possible to display these graphs at the main HA dashboard?
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Thanks for watching! Good question, I'm not sure at the moment but I'll try and get back to you!
@maslianok
@maslianok 3 года назад
@@EverythingSmartHome thanks
@meierthomas
@meierthomas 3 года назад
I have seen this question on a Node-RED forum post and the answer there was to use iFrames. Not sure whether Home Assistant supports iFrames but that could be an avenue to explore
@lorenzopiazzi3840
@lorenzopiazzi3840 3 года назад
A way should be selecting "share" from the panel menu, copying the link and pasting it into a web url lovelace tab. What is still unclear to me is how to make graphs visible both from local and external access with the same link. Can you help me on that@@EverythingSmartHome ?
@BusaBarnabas
@BusaBarnabas 3 года назад
Just FYI influx is now pushing stuff over to 2.x from 1.x version. 2.x will use different querying language and different way to handle databases (buckets and organisations) and using tokens for authentication. I’d look into having a different video about having 2.x as it will be much more future proof.
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Thanks for the update, appreciate it!
@dlmac
@dlmac Год назад
@@EverythingSmartHome so....
@carlnakamura4861
@carlnakamura4861 3 года назад
Really great video👍 When trying to add let's say temperature sensor data the entities from HA shows up as expected what would your advice be to manage this (I have many temp sensors and the entity ID is hard to read which is why I use friendly names in HA Lovelace cards). Would you recommend going back to HA and customize each entity ID to be more userfriendly in Grafana and what would the implications in HA be?
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Thanks Carl! I always recommend changing the entity-ids as soon as you get them into HA so it'd a bit of a tricky one! You could change them for sure but be aware that any automations you have will also need their entity IDs changing to match as well as in Lovelace cards.
@carlnakamura4861
@carlnakamura4861 3 года назад
@@EverythingSmartHome Thanks a lot for your swift response! I was afraid that might be the case but since I'm fairly early on I might just bite the bullet and customize the entity IDs of all sensors to have a solid base to build from.
@EverythingSmartHome
@EverythingSmartHome 3 года назад
I think that's a good way if you aren't too deep in, it will save you a lot of hassle in the future!
@carlnakamura4861
@carlnakamura4861 3 года назад
@@EverythingSmartHome I'm at it right now. I seem to remember that you had recommendations on the naming standard of entities, is that correct? In what video was that? domain.AREA_sensorname_property eg sensor.livingroom_lumi_xxx_humidity or would that potentially put me at a dead end down the road?
@Rediscovered
@Rediscovered 2 года назад
Thanks for this guide. It's very useful. When writing the database, username and password strings in Studio Code Server they appear as red and not as blue like in your video. I'm guessing that's why I'm not getting any data in the explore tab in InfluxDB. I've triple checked spelling. What could be the issue? EDIT: I solved the issue by writing host: localhost instead of the IP adress of my Home Assistant server. Hope someone might find the useful.
@Steve61
@Steve61 Год назад
I found this very useful. It's just a pity the interface of things like Grafana keep changing, making the instruction a little outdated or harder to follow. They have moved some things around in the edit area, but it is still very useful. Now I just have to work out the chron settings so my graphs of daily data re-zero at midnight my time and not GMT!
@soumynonareverse7807
@soumynonareverse7807 3 года назад
Looks nice. Is it possible to make a magic mirror using grafana or a similar way? And to display basic things like time, temp and humidity for example and to get some controls like lights switches with a swipe or a double tap?
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Thanks! I'm sure it would be possible yes! I haven't done it yet though 😅
@soumynonareverse7807
@soumynonareverse7807 3 года назад
@@EverythingSmartHome maybe worth it for your next video
@il_fabbro90
@il_fabbro90 3 года назад
What kind of hardware configuration do you suggest to run a full power HA with all the features that you explain/will explain in your video?
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Great question! It depends if you consider the object detection stuff?
@il_fabbro90
@il_fabbro90 3 года назад
@@EverythingSmartHome yes, the haviest one 😆
@mateussilva3756
@mateussilva3756 Год назад
Is it possible to change the time range directly from the dashboard? I mean, change the graphics interactively in real time.
@KrispKiwi
@KrispKiwi 9 месяцев назад
Is there a way to select which sensors InfluxDB monitors to keep storage size low?
@jeffmaynard8371
@jeffmaynard8371 2 года назад
Thanks for all the videos! without your help I would still bee looking at a blank home assistant. One thing I would like to do if you could work it in is put the marieaDB and influx DB on a NAS so that I can keep the SSD on my Pi 4 as clean as I can and keep all the data. Could you help out with that?
@EverythingSmartHome
@EverythingSmartHome 2 года назад
Thanks Jeff! Will try and add it to the list at some point!
@bavon82
@bavon82 2 года назад
Could you please create a video to explain how delete specific entries in Influx DB? After 6 months the DB is now 700mb. I discover now that I can exclude measurements (Using Exclude in configuration yaml), but i don't know how to delete old data. Thanks
@sekt1953
@sekt1953 3 года назад
you are good
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Thanks, you are awesome!
@pajikcz
@pajikcz 7 месяцев назад
what if i have MariaDB as primary DB (replacing inbuilt DB) , will Influx replace MariaDB as well?
@benedictsmith2415
@benedictsmith2415 3 года назад
To get the graph cursor working like you want and to avoid making multiple queries for the same measure, set visualisation to graph and then select measurement from domain, group by tag and fill linearly, i.e. FROM default % WHERE domain = sensor SELECT field (value) max () GROUP BY time ($__interval) tag (entity_id) fill (linear) then add $tag_entity_id in the alias box. You may have lots of percentages in the db, so filter the graph of unwanted percentages using the transform tab function "filter by name". Finally use overrides to clean up the legend naming. Voila!
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Thanks Benedict! This was a difficult transition coming from Elasticsearch, the way things are done are very different so appreciate the pointers!
@benedictsmith2415
@benedictsmith2415 3 года назад
@@EverythingSmartHome I can imagine! The "next level" on top of the inbuilt variables that are auto-generated in the db are the ones you define yourself in the variables tab of the dashboard settings. For example, make a query variable called PercentSelector that does select entity_id, value from "home_assistant"."autogen"."%" This then produces a drop down list at the top of the page that you can incorporate into your queries: SELECT mean("value") FROM "%" WHERE ("domain" = 'sensor' AND "entity_id" =~ /^$PercentSelector$/) AND $timeFilter GROUP BY time($__interval), "entity_id" fill(linear)
@benedictsmith2415
@benedictsmith2415 3 года назад
then the "next level" is using variables to do drill downs.... ;-)
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Thanks I'll look into it, some good tips! Then we can take it to the even next level and do an Elasticsearch guide 🤣 little bit overkill for this though!
@benedictsmith2415
@benedictsmith2415 3 года назад
🤪
@luisabanto7563
@luisabanto7563 3 года назад
Great video. Why we are using IP in the configuration instead of the single url?
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Thanks Luis! You can 100% use your domain name if you have that configured! Only reason I didn't say to use that here was for people who haven't followed that guide so as not to confused them 😅
@luisabanto7563
@luisabanto7563 3 года назад
@@EverythingSmartHome Using the domain name wasn't populating the influxdb, so I use my IP and now is working. I also change the Home dashboard to the System Monitor, there is an option on Grafana preferences to do this.
@tomekhekin914
@tomekhekin914 3 года назад
@@luisabanto7563 are you able to enter your HA locally using IP and have HTTPS for single url? After using HTTPS my local IP address stopped working.
@EverythingSmartHome
@EverythingSmartHome 3 года назад
It will work but you'll get a cert error which is normal. Make sure you are using HTTPS when using the IP address
@luisabanto7563
@luisabanto7563 3 года назад
@@tomekhekin914 I use the https for the single url.
@SamuelWakefield
@SamuelWakefield 3 года назад
Good morning! So I've got Grafana/Influx setup monitoring my UniFi network (using Unifi-Poller in Docker) and wondering if there is a way to create/import a sensor into HA using the data from Grafana/Influx? I've got quite high level stats on everything in my UniFi network and want to get those into HA somehow! At the moment I'm having to use an iFrame with a custom Grafana dashboard on my 'Network' dashboard/panel in HA and it doesn't look or work correctly (if not on the same local network).
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Hey Samuel, hmm that's a good question, that's not necessarily the approach I would take to solve the problem but I'm sure there might be a way to do it that way, I'd need to look into it as I'm not sure from the top of my head
@danielkrzyzak9399
@danielkrzyzak9399 2 года назад
Did you notice that CPU stopped recording once you added the alias? I have the same problem and not yet worked out what the problem is…
@inspiration2292
@inspiration2292 2 года назад
Hi and welcome to me testing which chart I like the most
@L0g1c0n
@L0g1c0n 3 года назад
What suggestions would you have for backing up the DB?
@WernerWagener87
@WernerWagener87 6 месяцев назад
Hi! how can I delete data I not longer need from influx?
@il_fabbro90
@il_fabbro90 3 года назад
Is it going to store a big volume of data? I'm very undecided for what time set the retention policy.
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Very dependent on how big your install is but the good thing is you can configure it to store less or more
@matthewfirestine6303
@matthewfirestine6303 Год назад
what do i do if my sensors dont appear in grafana? i have all system monitor entities available in my entities tab and they are enabled
@stathiskapnidis9389
@stathiskapnidis9389 2 года назад
does our database collect all data as of now? how can we make it only connect data from 1 device?
@sekt1953
@sekt1953 3 года назад
how do I avoid storing sensor data in both MariaDB and InfluxDB
@058Jacko
@058Jacko 3 года назад
I need to get in touch ASAP and will be!
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Thanks for helping the algorithm as always! 😅
@058Jacko
@058Jacko 3 года назад
@@EverythingSmartHome hahaha!!! I am not a robot.
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Haha appreciate you commenting every video my friend! 🙏
@058Jacko
@058Jacko 3 года назад
@@EverythingSmartHome credit where its deserved. 👏
@058Jacko
@058Jacko 3 года назад
@@EverythingSmartHome should have an email 😁
@petermarin
@petermarin 3 года назад
Morning!! You said the pi is not ideal for this. What hub would you recommend then? (Hopefully still relatively affordable)
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Hey Peter, the Pi is acceptable for this just not with an SD card, a Pi with an SSD should be able to run this fine! Hope that helps
@petermarin
@petermarin 3 года назад
@@EverythingSmartHome thanks for the reply!! Is that what you're using?
@EverythingSmartHome
@EverythingSmartHome 3 года назад
No I use a dual Xeon enterprise server, wouldn't recommend that for just this alone 😂
@petermarin
@petermarin 3 года назад
@@EverythingSmartHome haha wow!! Didn't expect that!! What are you using all that horsepower on??
@EverythingSmartHome
@EverythingSmartHome 3 года назад
I run a lot of other projects that I dont discuss on this channel such as an Elasticsearch cluster and an NVR but also I use it for TrueNAS too!
@FrankGraffagnino
@FrankGraffagnino 3 года назад
I would like to know how to get the influxdb integration if influx will be running on another machine in the network. Would you still install influxdb but just not start it? That way you get the integration? Or can you send data to an external influxdb from home assistant without installing the add-on?
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Hey Frank, you would just install influxDB on the machine you want and change the Home Assistant config to point towards the IP address. Hope that helps!
@FrankGraffagnino
@FrankGraffagnino 3 года назад
@@EverythingSmartHome right, but can you have an "influxdb" block in the home assistant config without the integration installed? i guess i'm not sure if the integration installs the product and the support to talk to influx, or if it just installs the product and the ability to talk to influx is always there in HASS. Hope that makes sense.
@EverythingSmartHome
@EverythingSmartHome 3 года назад
You can yes, they are completely unrelated to each other!
@FrankGraffagnino
@FrankGraffagnino 3 года назад
@@EverythingSmartHome fantastic. thanks.
@praannetwork
@praannetwork 2 года назад
How to add glances data to influx and visualize it using grafana?
@sandryseibert
@sandryseibert 2 года назад
Which version of Grafana you used in this video?
@real_christian
@real_christian 10 месяцев назад
Probably version 7. Let me guess, missing the Virtualization option?
@JosenivaldoBenitoJunior
@JosenivaldoBenitoJunior 2 года назад
I would like to add that Grafana can use MariaDB as datasource. Data there is different, sure.
@stefan-lupo-pelzl
@stefan-lupo-pelzl Год назад
Help needed: I am looking for dummies instructions how to efficiently downsample the data within the home assistant influxdb to avoid ever increasing data consumption without loosing the long-term data analytics capabilities. Is there anywhere a dummies guide?
@T-DC
@T-DC 2 года назад
I was wondering how you feel about 'flux'.. I really liked the 'querry selecter' like you are using it. But 'Flux' kinda broke this - I hope influxdb will fix this or grafana will come out with an update to integrate better with 'flux' or am I missing something and using it wrong? I would like to see a video about how you are using influx 2.x and your opinion.
@brettmatthews9886
@brettmatthews9886 Год назад
Any update on this
@christianm2857
@christianm2857 Год назад
If I want to add a new data source, I get the notifications: "origin not allowed" and "unexpected error". Any idea?
@PM-nf6xb
@PM-nf6xb Год назад
Hey there. I'm trying to get this to work but I'm stuck at the 7:52 mark of the video. I don't see any data coming in. I've triple checked the settings and used the IP, localhost, and even the address mentioned in the "Documentation" tab for the add on influx. None seem to work. Any ideas?
@PM-nf6xb
@PM-nf6xb Год назад
log after restart says "Failed to to call / store" and "/store return code 500". It looks like I had a typo in the password for the user, but this error still shows in the log. Data is not coming through.
@werwilldaswissen6815
@werwilldaswissen6815 Год назад
🎉
@mrxmry3264
@mrxmry3264 2 года назад
i see one problem with influxdb: as i keep putting information into the database, it keeps growing until it fills up the hard disk and crashes the computer. how can i prevent that?
@paradin87
@paradin87 Год назад
Do i need Grafana? Can't HA read the InfluxDB Data ?
@PaPaTheGMan1215
@PaPaTheGMan1215 2 года назад
Sorry for a dumb question, but I don't have InfluxDB nor Grafana in the Add-on Store. How do I add them?
@EverythingSmartHome
@EverythingSmartHome 2 года назад
Do you have advanced mode turned on? (Click your user profile in the bottom left and enable advanced mode)
@PaPaTheGMan1215
@PaPaTheGMan1215 2 года назад
@@EverythingSmartHome Yes, 'Advanced Mode is on.
@chishiki_itadaki
@chishiki_itadaki 8 месяцев назад
How can I install infuxDB and grafana ?
@thepyropc_
@thepyropc_ 2 года назад
use this as your host a0d7b954-influxdb would not work for me with the ip of my home assistant. so if ur having failures to connect try this
@scout-ww4ck
@scout-ww4ck 3 года назад
24:30 Ans: may be Panel-Display-Tooltip mode-All
@michaelmolter8828
@michaelmolter8828 2 года назад
Restart. Pro tip. Spent way to long troubleshooting to realize I just needed to restart my core...
@simoneatough6391
@simoneatough6391 3 года назад
Thanks for the guide. An entirely selfish request would be how to setup proxmox and HA as a VM. Looking to move to a mini PC soon from a raspberry pi 4
@EverythingSmartHome
@EverythingSmartHome 3 года назад
Cheers Simon! Will add it to the list!
@simoneatough6391
@simoneatough6391 3 года назад
@@EverythingSmartHome I've seen some setup guides but there is a ton of the day to day stuff that is missing - how to update the home assistant OS, how to create backups of VMs etc. There are a couple of first time setup guides but nothing about maintaining and backing up
@justincooper8144
@justincooper8144 Год назад
I don't seem to have access to memory or CPU. Am I missing something?
@FredrikRambris
@FredrikRambris 3 года назад
I'm pointing my grafana to my mariadb recorder db and it graphs it just fine. You have to know your SQL though. A wish I have for my InfluxDB is to reduce resolution over time like I had with my RRD-based graphs. Say keep a 5 second dataset for 7 days, a 5 minute dataset for 30 days and an hour dataset for a year. Influx can do this but grafana cannot automatically switch between them when you zoom out etc.
@EverythingSmartHome
@EverythingSmartHome 3 года назад
You might consider something like Elasticsearch and Kibana! Man I havent used RRD graphs for a few years now (maybe 5?!) But I do remember that feature 😂
@4wobi
@4wobi 11 месяцев назад
#Lenovo beim scheissen
Далее
15 Home Assistant Tips You MUST Do
14:28
Просмотров 342 тыс.
Influx vs Prometheus vs Timescale
20:33
Просмотров 32 тыс.
My new Proxmox Monitoring Tools: InfluxDB2 + Grafana
19:46
Using Grafana and InfluxDB with Home Assistant.
31:10
Smart Home Protocols Explained
18:25
Просмотров 143 тыс.
12 Of The Best Smart Home Automation Ideas!
20:14
Просмотров 306 тыс.