(InfluxDB or Graphite) to Grafana

[finish06]

Has anyone set this up yet? I am attempting via following the wiki instructions...
https://pve.proxmox.com/wiki/External_metric_server

I have put both Graphite and InfluxDB into the status.cfg file... However when I perform a tcpdump, I do not receive any successful packet transfers.

tcpdump udp -i vmbr0 port 2003 -vv

Any advice?

 

[t.lamprecht]

Hi,

There are some post on the user list where they report of a successful setup, so it should work outside from our testing lab also.
Can you please post the output of

pveversion -v

and

cat /etc/pve/status.cfg

.

 

[finish06]

Hi,

There are some post on the user list where they report of a successful setup, so it should work outside from our testing lab also.
Can you please post the output of

pveversion -v

and

cat /etc/pve/status.cfg

.

The results of

pveversion -v

is the following

proxmox-ve: 4.2-48 (running kernel: 4.4.6-1-pve)
pve-manager: 4.2-4 (running version: 4.2-4/2660193c)
pve-kernel-4.4.6-1-pve: 4.4.6-48
lvm2: 2.02.116-pve2
corosync-pve: 2.3.5-2
libqb0: 1.0-1
pve-cluster: 4.0-39
qemu-server: 4.0-74
pve-firmware: 1.1-8
libpve-common-perl: 4.0-60
libpve-access-control: 4.0-16
libpve-storage-perl: 4.0-50
pve-libspice-server1: 0.12.5-2
vncterm: 1.2-1
pve-qemu-kvm: 2.5-16
pve-container: 1.0-63
pve-firewall: 2.0-26
pve-ha-manager: 1.0-31
ksm-control-daemon: 1.2-1
glusterfs-client: 3.5.2-2+deb8u1
lxc-pve: 1.1.5-7
lxcfs: 2.0.0-pve2
cgmanager: 0.39-pve1
criu: 1.6.0-1
zfsutils: 0.6.5-pve9~jessie
openvswitch-switch: 2.5.0-1

And the results of

cat /etc/pve/status.cfg

is the following:

graphite:
        server http://192.168.1.143
        port 2003
        path server

influxdb:
      server https://influxdb.dunn.private
      port 8089

 

[t.lamprecht]

server http://192.168.1.143

This here is the problem, after you posted that I played a little with the tool and found out that we only supported DNS names as addresses. So no IP and also no protocol like http://

I posted patches on our mailing list which address this behaviour, until they are in the repos it will take some time, in the meanwhile do:

graphite:
        server graphite.localnet
        port 2003
        path server

influxdb:
      server influxdb.dunn.private
      port 8089

If you have no DNS available to add a domain for your Graphite Server then just add an entry to /etc/hosts:

192.168.1.143 graphite.localnet

 

[finish06]

Since making the changes you recommended, it has all worked out! Thank you. Now I am trying to graph the information in Grafana, however I am unable to graph the CPU... Here is how I have my string set up in Grafana:

SELECT mean("value") FROM "cpustat" WHERE "object" = 'nodes' AND "host" = 'node2' AND $timeFilter GROUP BY time($interval) fill(null)

However this does not successfully pull any information. I have tried removing the "object" value too...

Anyone else have this issue?

 

[t.lamprecht]

The table layout is not totally intuitive, to see what data each table holds try:

select * from system limit 5

Here 'system' can be changed to:

name
ballooninfo
blockstat
cpustat
memory
nics
system

E.g. system holds data for guests, cpustat holds data from the node, so no need for the "objects" part in your query. It has no field value so that would be the reason you did not get anything.

Use the query above to get an idea which fields are in the table and how you extract the wanted data the easiest.

 

[tomte76]

This here is the problem, after you posted that I played a little with the tool and found out that we only supported DNS names as addresses. So no IP and also no protocol like http://

I posted patches on our mailing list which address this behaviour, until they are in the repos it will take some time, in the meanwhile do:

Is it meanwhile possible to submit data to influx-db using https and authentication. As I need to bypass unsafe networks I would prefer this over UDP without authentication.

Thank you!

 

[John Wick]

Is there any complete tutorial?

 

[DerDanilo]

Same question here. Is there a project on github or so for Proxmox stats to Grafana ?

 

[sfnme]

Is there any complete tutorial?

Actually, i need also ... Because grafana cloud is free for one user but i couldn't find exactly how can i make connection between grafana cloud and my proxmox .

Thank you.

 

[patefoniq]

I'm digging up the topic, is there any progress on that issue?

 

[darmach]

Grafanacloud seem to need additionally at leasy auth data - user+password/token

Did anyone get this to work?