Data from MySQL in GeoLoop?!

[glomerata]

Hi,

at first, thanks for developing GeoLoop plugin fo Grafana!

I am trying to visualize some temperature data (our community runs municipal biomass heated boiler and I want to display temperature data from houses). I made a trial dashboard with just three points to test functionality, but I had to make some mistake which blocks dashboard from running.

Could you please check my settings, help me to find a mistake I made and "force" dashboard to run?

• my trial dashboard is at: http://zodiac.hostetin.org:3000/d/1INL0avmk/geo?orgId=2&tab=general&from=1530610406440&to=1530696806440

• data for metrics come from MySQL: http://zodiac.hostetin.org/adminer/adminer-4.2.4.php?username=sosak_usr&db=sosak&select=view_geoTeploty

• GeoJSON: http://zodiac.hostetin.org/pub/kn/buildings_points_test.geojson

[samhatchett]

Hi @radimmachu - the trial dashboard is a 404.

[glomerata]

Sorry, the trial dashboard should be OK now: http://zodiac.hostetin.org:3000/d/1INL0avmk/geo?orgId=2&tab=general&from=1530610406440&to=1530696806440

[glomerata]

Hi,

I found out and repaired my mistakes in settings of the panel!

Now, the panel displays those 3 points but with no color visualization -- points are just black. Any idea how to fix it? Also, there is no possibility to stop/pause the animation -- it would be helpful to have some basic control.

[Nozlaf]

I have the same issue cant seem to get it working with mysql, does this plugin work with mysql datasources?

[xerocobra]

Hi, did you manage to make it work? What should be the column name for measurement value used for coloring the points?

[jruivo-dev]

Did you find a way to solve this?

[glomerata]

I did couple of unsuccessful trials with MySQL and I gave it up. I change data source to InfluxDB and it works.