Hi,
I’m quite a newbie here but with experience in devons, and I currently searching for a grafana plugin able to display a map with the position of IoT objects.
I found two plugins : 1) TrackMap : but I didn’t succeed in connecting mySQL datasource (even when I try the 2 request as it is recommended in some notes on the web)
2) World map travel or event the extension map travel . It works with mysql connectors but it appears to be quite poor compared to 1)
So I would be very pleased if any of you could give me advice on another plugin to use or maybe could have succeed in operating Trackmap with mysql
Thank for your post Daniel,
maybe U can help in using WorldMap with mySQL requesting in Table format
here is my request SELECT
CAST(latitude AS DECIMAL(10,6)) AS latitude,
CAST(longitude AS DECIMAL(10,6)) AS longitude,
CAST(humidite AS DECIMAL(2,0)) AS metric
FROM mesures
WHERE fk_deveui = ‘0004A30B00EBBB4B’
LIMIT 1
Thank for your post Daniel,
maybe U can help in using WorldMap with mySQL requesting in Table format
here is my request SELECT
CAST(latitude AS DECIMAL(10,6)) AS latitude,
CAST(longitude AS DECIMAL(10,6)) AS longitude,
CAST(humidite AS DECIMAL(2,0)) AS metric
FROM mesures
WHERE fk_deveui = ‘0004A30B00EBBB4B’
LIMIT 1
the query give back : tables:Array[1]
0:Object
columns:Array[3]
0:Object text:“latitude”
1:Object text:“longitude”
2:Object text:“metric”
rows:Array[1]
0:Array[49.106175,6.410369,21]
which seems to be correct for a good plot in world map , but it produces an error : Panel rendering error undefined is not an object (evaluating ‘o.x’)
where is the mistake ?
other question : what is the way to change th ebackground color of world map panel from dark to lighter color ?
i think that the problem is that you arent setting value in you query, try this:
SELECT
CAST(latitude AS DECIMAL(10,6)) AS latitude,
CAST(longitude AS DECIMAL(10,6)) AS longitude,
CAST(humidite AS DECIMAL(2,0)) AS value,
fk_deveui as metric
FROM mesures
WHERE fk_deveui = ‘0004A30B00EBBB4B’
LIMIT 1
Request is correctly executed now, but no plotting on the map :-((
the query response is as follows . We can see latitude, longitude , value and metric in the table rows , but nothing plots on the graph :
response:Object
results:Object
A:Object
refId:“A”
meta:Object
series:null
tables:Array[1]
0:Object
columns:Array[4]
rows:Array[1]
0:Array[4]
0:49.106175
1:6.410369
2:21
3:“0004A30B00EBBB4B”
I don’t understand why there is nothing plotted with such a good response table
Absolutly same configuration but no spots on the map
Here follows the result of the request made. It seems OK with 192 points returned
I still do not succeed in plotting points with WorldMap , I cant o with TrackMap but not with Worldmap
SELECT
