Hi! Thank you for the nice words! :) I'm afraid we are currently not doing more tutorials and I also haven't really set up an example like in this video with a time-series database. So I don't know that much about it. Personally I would maybe check out "home assistant" in your case. I use it myself and it already handles a lot of the things you would probably need to do. You should also find many other people who extended it using grafana when you search for something like "home assistant solar dashboard". Other than that some relevant terms might be: InfluxDB, TimescaleDB, Time-series database, Data retention, Grafana, Solar, Dashboard, Sensor data. I hope that helps a bit, even if it's probably not what you were hoping for.

If you click Settings on the video, you can click Playback Speed and slow the video down, makes it much easier to follow along :)

Hi Narayan It seems you got the same error message as Vikas Arora down below. Unfortunately I can't really help you without knowing how exactly your request and setup looks like. In the documentation on mysql.com it says, you might be calling your functions in the wrong order? Maybe you could start by simplifying your request as much as possible, and then add more parameters step by step, to see where it goes wrong.

@@sql4automation584 how can I contact you

Sorry to be so offtopic but does anyone know a method to get back into an Instagram account? I was dumb forgot the account password. I love any help you can give me!

@Leonel Kellan instablaster ;)

@Jeremias Miguel thanks so much for your reply. I got to the site thru google and Im waiting for the hacking stuff atm. I see it takes a while so I will get back to you later with my results.

@Jeremias Miguel It worked and I finally got access to my account again. I am so happy! Thank you so much, you saved my account!

@Leonel Kellan glad I could help :)

Hi Vikas Unfortunately I don't really know what the problem might be. In the documentation on mysql.com it says, you might be calling your functions in the wrong order? Or maybe you should try to simplify your requests? Anyway I think Google can help you a lot more, than I do. :)

Same problem for me, did you do it?

Thank you. We currently don't have another Grafana tutorial. But we're considering doing another one in the future. I'd let you know in that case! :)

they are details from mysql

Thanks! Yes they've changed it quite a bit. I think I was using the version 6.4.3

Thank you! I've never tried that, so I don't know unfortunately. But there is a JSON-Plugin which might help you maybe? grafana.com/grafana/plugins/simpod-json-datasource

Hi Martin, yes the interface changed quite a bit in the 2.5 years since this video was made.

Hi Nebiyat 8086 would be just the port. For the complete URL you need the IP aswell.

Yes it's possible. But it depends a bit on the data. I think you will have to define the data for the labels as "metric" in your request and then in the Visualization Tab under X-Axis set the Mode to "Series". Maybe this helps you a bit? medium.com/@sean_bradley/graphing-non-time-series-sql-data-in-grafana-8a0ea8c55ee3

Use IP instead of host name

Hi, I'm sorry. I'm afraid I don't have this data anymore. I'll make sure to provide it next time, if we'll ever make an update.

Hi Monica Apologies for the late reply! Yes the URL, IP address and maybe also the port would probably be different on your system. I would recommend you google how you can find out your specific settings.

Hi hammershigh, the IP "192.168.0.150" is the IP of my synology network drive where I've installed the MariaDB database. And the database uses the port 3306, which is why I'm adding the ":3306". Now since that's very specific to my setup, you can't just copy it. In order to use Grafana you will also need to install a database on a device in your local network and then enter the IP of that device as the "Host". (It's very unlikely that you'd also have 192.168.0.150) MariaDB is free and relatively easy to install and you can find many tutorials for it on the internet. I hope that helps!

Can i ask, does grafana have to use a database application?

@@yosanhade Hi Yosan. Yes I think so, you need some place to get your data from.

@@sql4automation584 halo If i just use database from php my admin? Can it or not?

@@yosanhade Yes that should probably work since it uses a MySQL or MariaDB database as far as I know.