InfluxDB/Grafana/Bosun + Cacti = CereusTransport - Updated!

[phalek]

Besided the sample dashboard which I created. Has some of the users of this plugin created a nice dashboard already that you can share with us ?

I'm planning on updating the plugin in the near future. It will be moved to github for better issue and feature request tracking as well.

[jhakas]

Hello,

Thanx for plugins,

I tried setup with remote influxdb, m getting proper log but it won't insert the data to influxdb. All the influxdb connection seems to be fine.

its won't show any thing while tcpdump in remote influxdb host.

Cacti Log:
04/27/2020 10:20:01 PM - CereusTransporter: Poller[0] INFO: Adding data to influxdb
04/27/2020 10:20:01 PM - CereusTransporter: Poller[0] INFO: Adding data to influxdb
04/27/2020 10:20:05 PM - CereusTransporter: Poller[0] DEBUG: influxdb Lookup table size: [40189]
04/27/2020 10:20:05 PM - CereusTransporter: Poller[0] DEBUG: influxdb Lookup table size: [40189]
04/27/2020 10:20:09 PM - CereusTransporter: Poller[0] DEBUG: influxdb Units lookup table size: [61078]
04/27/2020 10:20:09 PM - CereusTransporter: Poller[0] STATS: Time:8.73 LookupTableSize:40189 LookupUnitsTableSize:61078 MetricsCount:0 AverageHostTime:0.01 SlowestHostnames:[: 0.010s]
04/27/2020 10:20:09 PM - CereusTransporter: Poller[0] DEBUG: influxdb Units lookup table size: [61078]
04/27/2020 10:20:09 PM - CereusTransporter: Poller[0] STATS: Time:8.92 LookupTableSize:40189 LookupUnitsTableSize:61078 MetricsCount:0 AverageHostTime:0.00 SlowestHostnames:[: 0.000s]

curl Ans:
{"results":[{"statement_id":0,"series":[{"name":"databases","columns":["name"],"values":[["_internal"],["cacti"]]}]}]}

is there any option which I can do debug on same:

please help

[phalek]

What InfluxDB are you using ?

The plugin was tested with 0.x versions only so at least any version greated then 1.8 will probably not work right now.

The plugin is currently being rewritten to support 1.8 and 2.x versions of InfluxDB loosing PHP 5.4/5.3 compatibility

[jhakas]

Hi,

I'm using
influxdb - 1.8
cacti - 0.8.8a
php - 5.4.16

while checking influxdb some measurements has been created but empty most probably.
> show measurements
name: measurements
name
----
linux.memory.free
linux.memory.free.swap
local.cacti.poller.item.statistics
local.cacti.poller.recache.statistics
local.cacti.poller.statistics
unix.hard.drive.space
unix.load.average
unix.logged.in.users
unix.processes

> select * from linux.memory.free
ERR: database not found: linux

select * from unix.processes
ERR: retention policy not found: unix

Regards,

[shaunmccloud]

Hi,

I'm using
influxdb - 1.8
cacti - 0.8.8a
php - 5.4.16

while checking influxdb some measurements has been created but empty most probably.
> show measurements
name: measurements
name
----
linux.memory.free
linux.memory.free.swap
local.cacti.poller.item.statistics
local.cacti.poller.recache.statistics
local.cacti.poller.statistics
unix.hard.drive.space
unix.load.average
unix.logged.in.users
unix.processes

> select * from linux.memory.free
ERR: database not found: linux

select * from unix.processes
ERR: retention policy not found: unix

Regards,

Use select * from "linux.memory.free" and select * from "unix.process".

I have noticed that while everything is writing to the database correctly (I think), but the traffic values for the interfaces on my switch are all messed up. Like a 1Gb/s port at well over 200Gb/s. Any suggestions? Everything looks correct in Cacti.

[bbbburns]

I've been using this plugin for a few months and I'd like to migrate my InfluxDB to https with a self signed certificate.

I looked at the infludb-php client this plugin is using and it seems to be version 0.1.2. It seems like the most recent versions of the influxdb-php client can support SSL (1.14.5 and newer) and even has an option to specify verifySSL=false. https://github.com/influxdata/influxdb-php

Is it possible for me to use SSL with a self signed cert with the current released version of the CereusTransporter plugin, or would it need an update to pick up the new influxdb-php code?

If it is possible to use https today, how would I specify that URL in my cacti config? Currently I'm using

Code: Select all

influxdb://<name>:<pass>@localhost:8086/<database>

Thanks for this awesome plugin and for the help!

EDIT:
I found a way to make this work by turning my Apache2 server running on that host to an insecure http to https proxy. I don't recommend this, but it seems to work.

I accept connections on http port 8080 and proxy them to the influxdb server listening on https 8086. I had to disable the cert checks for apache to successfully proxy the connection.

Turn on apache mods:

Code: Select all

sudo a2enmod proxy_http
sudo a2enmod ssl

Setup the proxy vhost:

Code: Select all

cat /etc/apache2/sites-enabled/001-influx-proxy.conf

Listen 8080
<VirtualHost *:8080>
        ServerName <name>
        SSLProxyEngine On

	SSLProxyCheckPeerCN Off
	SSLProxyCheckPeerName Off

        ProxyPass  / https://localhost:8086/

</VirtualHost> 

Restart apache:

Code: Select all

sudo systemctl restart apache2

Change the Database spec slightly to 8080:

Code: Select all

influxdb://<name>:<pass>@localhost:8080/<database>