Hello Anyone,
Can someone please spare some of your time to teach me how to use Worldmap Panel on Grafana.
Prometheus or Influxdb.
I don’t know how to take the geohash, where to place the hash and how to link all the location,
i have create the PING device, but dont know how to point the location.
Which file should be edited.
Please Help. If you can please provide example for a single device i would really be happy
Any DB will do.
I use location Coords and there you need a latitude and longitude value from you DB
here is my telegraf config,
[[inputs.ping]]
urls = [“x.x.x.x”]
interval = “10s”
count = 4
ping_interval = 1.0
timeout = 1.0
deadline = 10
[inputs.ping.tags]
name =“switch”
Where will i add the latitude and longitude. On which file should i add.
I am totally lost. Kindly help step by step. Please
So where and what is your data source you are extracting from and pushing to influxdb using telegraf?
Yes. I am using telegraf and influxdb. As I mentioned, I can get the device ping from telegraf to influxdb and than to grafana. But I don’t know how and where to set the geohash or location ( longitude and latitude). I cannot find any tutorial for this on the internet, only COVID-19 heat map was there.
If you can spare some of your time, can you show me the the example of each config files
please post your sample influxdb data here as csv
devicename,lon,lat
chickpeas,8.9806,38.7578
May I get post it tomorrow. It’s on my work computer and i can’t access right now.
weekend, party time. post Monday
Ok thanks for the reply. Anyway i did not make any modification on the influxdb config file
remember : Telegraf is a server-based agent for collecting and sending all metrics and events from databases, systems, and IoT sensors, etc to Influxdb. Influxdb is a target time series database that telegraf can write to.
telegraf has nothing to do with workmap panel. influxdb could have something to do with worldmap panel if it contains long, lat or geohash data.
You need to show us what you store in your DB and if you want to show something on a map you need lat and long info some where.
Are these fix positions for the devises you want to show on the map? If they are you can have a table with that information in it and query it from there.
SHOW DATABASES
name: databases
name
_internal
telegrafuse telegraf
Using database telegraf
SHOW MEASUREMENTS
name: measurements
name
cpu
disk
diskio
kernel
mem
ping
INFLUXDB CONF (all are commented, i did not change the bind address also)
grep -v “#” /etc/influxdb/influxdb.conf
reporting-enabled = false
[meta]
dir = “/var/lib/influxdb/meta”
[data]
dir = “/var/lib/influxdb/data”
wal-dir = “/var/lib/influxdb/wal”
[coordinator]
[retention]
[shard-precreation]
[monitor]
[http]
[ifql]
[logging]
[subscriber]
[[graphite]]
[[collectd]]
[[opentsdb]]
[[udp]]
[continuous_queries]
[tls]
TELEGRAF CONFIG
grep -v “#” /etc/telegraf/telegraf.conf
[global_tags]
[agent]
interval = “10s”
round_interval = true
metric_batch_size = 1000
metric_buffer_limit = 10000
collection_jitter = “0s”
flush_interval = “10s”
flush_jitter = “0s”
precision = “”
hostname = “”
omit_hostname = false
[[outputs.influxdb]]
[[inputs.ping]]
urls = [“192.168.0.2”]
interval = “10s”
count = 4
ping_interval = 1.0
timeout = 1.0
deadline = 10
[inputs.ping.tags]
name =“SWITCH”
[[inputs.cpu]]
percpu = true
totalcpu = true
collect_cpu_time = false
report_active = false
[[inputs.disk]]
ignore_fs = [“tmpfs”, “devtmpfs”, “devfs”, “iso9660”, “overlay”, “aufs”, “squashfs”]
[[inputs.diskio]]
[[inputs.kernel]]
[[inputs.mem]]
[[inputs.processes]]
[[inputs.swap]]
[[inputs.system]]
Please show us sample of your data.
@yosiasz here is my database and the sample data.
I just have ping input. How can i used with worldmap panel
show measurements
name: measurements
name
cpu
disk
diskio
kernel
mem
ping
processes
swap
system
use telegraf
Using database telegraf
select * from Ping
select * from ping
name: ping
time average_response_ms host maximum_response_ms minimum_response_ms name packets_received packets_transmitted percent_packet_loss resul t_code standard_deviation_ms ttl url
---- ------------------- ---- ------------------- ------------------- ---- ---------------- ---------1655894153000000000 118.831 xox-VirtualBox 263.438 21.693 DISTRICT 4 4 0 0 102.574 251 192.168.1.2
1655894153000000000 5.323 xox-VirtualBox 8.797 4.053 DISTRICT 4 4 0 0 2.009 192.168.1.3
1655894153000000000 7.789 xox-VirtualBox 8.011 7.534 DISTRICT 4 4 0 0 0.183 192.168.1.4
1655894153000000000 4.048 xox-VirtualBox 4.787 3.73 DISTRICT 4 4 0 0 0.433 192.168.1.5
1655894153000000000 1.885 xox-VirtualBox 4.045 0.891 DISTRICT 4 4 0 0 1.267 60 192.168.1.6
You cannot use world map as you do not have any geohash or longitude latitude data
This is my actual question, can you help me on this, how do i put the geohash, and where to put it, how do i query it etc can you please show me how to do it. i am totally lost.
If you do not have it in your database then you cannot query it. So you need to add it to your database. Unless some of what you are showing us is longitude and latitude? I dont see any columns names as such but maybe one of those data points is longitude and latitude?
If not, however you are getting your data into influxdb, you need to also capture longitude lat into influxdb
Please show me how to add the longitude and latitude.