Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Wed Jun 26, 2019 3:16 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 136 posts ]  Go to page Previous  1, 2, 3, 4, 5, 6 ... 10  Next
Author Message
 Post subject: Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport
PostPosted: Tue Jan 26, 2016 7:35 am 
Offline

Joined: Mon Jan 25, 2016 9:02 am
Posts: 4
Location: Vienna/AUSTRIA
Hi Phalek,

SQL error message has vanished now, but still no data in the influxDB.

Last log line in a poller cycle is:
Code:
01/26/2016 12:03:31 PM - CereusTransporter: Poller[0] DEBUG: Adding [634] of data points for [imp-sr-sw1]


But imp-sr-sw1 is just the first one of the switches, I am polling.

execution exits at this line in setup.php:
Code:
$newPoints = $database->writePoints($points, InfluxDB\Database::PRECISION_SECONDS);


I can e-mail the content of $points to you, if that helps.

greetings, Christian.


Top
 Profile  
 
 Post subject: Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport
PostPosted: Tue Jan 26, 2016 8:25 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Jan 31, 2008 6:39 am
Posts: 2710
Location: Kressbronn, Germany
Yes please. [email protected]

_________________
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 1.x Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusTransporter | CereusReporting | nmidWebService | nmidSmokeping | nmidWeb2 |

Code:
CereusServer Master:  SYSTEM STATS: Time:2.5621 Method:spine Processes:1 Threads:16 Hosts:446 HostsPerProcess:446 DataSources:14683 RRDsProcessed:7573
CereusServer Agent:   SYSTEM STATS: Time:27.4840 Method:spine Processes:1 Threads:8 Hosts:16 HostsPerProcess:16 DataSources:114576 RRDsProcessed:48061


Top
 Profile  
 
 Post subject: Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport
PostPosted: Fri Jan 29, 2016 9:27 am 
Offline

Joined: Fri Jan 29, 2016 9:22 am
Posts: 3
I'm also having problems getting this to work on Cacti 0.8.8b and PIA 3.1. I uploaded it to the plugins folder, and installed and enabled it in the Plugin Management tab. I don't get any new setting tabs anywhere in the system for it, and my log file is showing this when the poller runs every 5 minutes:

01/29/2016 09:25:09 AM - CereusTransporter: Poller[0] ERROR: is not a valid scheme
01/29/2016 09:25:09 AM - CereusTransporter: Poller[0] INFO: Adding data to influxdb

I should be seeing some sort of settings tab somewhere for this plugin, right?


Top
 Profile  
 
 Post subject: Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport
PostPosted: Fri Jan 29, 2016 9:29 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Jan 31, 2008 6:39 am
Posts: 2710
Location: Kressbronn, Germany
It's in the "MISC" settings tab.

_________________
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 1.x Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusTransporter | CereusReporting | nmidWebService | nmidSmokeping | nmidWeb2 |

Code:
CereusServer Master:  SYSTEM STATS: Time:2.5621 Method:spine Processes:1 Threads:16 Hosts:446 HostsPerProcess:446 DataSources:14683 RRDsProcessed:7573
CereusServer Agent:   SYSTEM STATS: Time:27.4840 Method:spine Processes:1 Threads:8 Hosts:16 HostsPerProcess:16 DataSources:114576 RRDsProcessed:48061


Top
 Profile  
 
 Post subject: Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport
PostPosted: Fri Jan 29, 2016 9:56 am 
Offline

Joined: Fri Jan 29, 2016 9:22 am
Posts: 3
phalek wrote:
It's in the "MISC" settings tab.


I can't find a "MISC" settings tab anywhere in the system. Should this tab be under the Settings window under configuration?


Top
 Profile  
 
 Post subject: Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport
PostPosted: Fri Jan 29, 2016 10:02 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Jan 31, 2008 6:39 am
Posts: 2710
Location: Kressbronn, Germany
It's in Console -> Settings -> misc


Attachments:
screenshot.4.png
screenshot.4.png [ 145.83 KiB | Viewed 2601 times ]

_________________
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 1.x Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusTransporter | CereusReporting | nmidWebService | nmidSmokeping | nmidWeb2 |

Code:
CereusServer Master:  SYSTEM STATS: Time:2.5621 Method:spine Processes:1 Threads:16 Hosts:446 HostsPerProcess:446 DataSources:14683 RRDsProcessed:7573
CereusServer Agent:   SYSTEM STATS: Time:27.4840 Method:spine Processes:1 Threads:8 Hosts:16 HostsPerProcess:16 DataSources:114576 RRDsProcessed:48061
Top
 Profile  
 
 Post subject: Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport
PostPosted: Fri Jan 29, 2016 10:11 am 
Offline

Joined: Fri Jan 29, 2016 9:22 am
Posts: 3
I don't have that tab. I just have General, Paths, Poller, Graph Export, Visual, and Authentication. The Plugin Management screen says it's installed and enabled, and shows 'Active'.

EDIT:

I installed the Monitor plugin, and I got the Misc tab. Under that I now have the CereusTransporter Settings section. It would appear that the CereusTransporter plugin doesn't create or enable the Misc Tab by itself.


Top
 Profile  
 
 Post subject: Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport
PostPosted: Fri Jan 29, 2016 12:42 pm 
Offline
Cacti Guru User
User avatar

Joined: Thu Jan 31, 2008 6:39 am
Posts: 2710
Location: Kressbronn, Germany
Thanks,

Found the issue and fixed it. Will upload 0.49 soon.

_________________
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 1.x Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusTransporter | CereusReporting | nmidWebService | nmidSmokeping | nmidWeb2 |

Code:
CereusServer Master:  SYSTEM STATS: Time:2.5621 Method:spine Processes:1 Threads:16 Hosts:446 HostsPerProcess:446 DataSources:14683 RRDsProcessed:7573
CereusServer Agent:   SYSTEM STATS: Time:27.4840 Method:spine Processes:1 Threads:8 Hosts:16 HostsPerProcess:16 DataSources:114576 RRDsProcessed:48061


Top
 Profile  
 
 Post subject: Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport
PostPosted: Mon Feb 01, 2016 2:08 am 
Offline

Joined: Sun Apr 08, 2007 8:17 am
Posts: 16
HI,

Great work...

Am new to Grafana
data source added to grafana , But i need steps to create graph. kindly can you please share the steps


Top
 Profile  
 
 Post subject: Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport
PostPosted: Tue Feb 02, 2016 3:24 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Jan 31, 2008 6:39 am
Posts: 2710
Location: Kressbronn, Germany
0.49 has been released, adding the missing "Misc" tab:

http://blog.network-outsourcing.de/prod ... ansporter/

theslim1 noted that he may write a short guide, but I assume it's quite time consuming doing so :-)

_________________
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 1.x Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusTransporter | CereusReporting | nmidWebService | nmidSmokeping | nmidWeb2 |

Code:
CereusServer Master:  SYSTEM STATS: Time:2.5621 Method:spine Processes:1 Threads:16 Hosts:446 HostsPerProcess:446 DataSources:14683 RRDsProcessed:7573
CereusServer Agent:   SYSTEM STATS: Time:27.4840 Method:spine Processes:1 Threads:8 Hosts:16 HostsPerProcess:16 DataSources:114576 RRDsProcessed:48061


Top
 Profile  
 
 Post subject: Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport
PostPosted: Mon May 23, 2016 8:57 pm 
Offline

Joined: Mon Apr 22, 2013 1:30 pm
Posts: 25
Hey phalek, awesome plugin. Thank you so much for creating it!

I was wondering if you could share the metrics you are using to show interface data like your earlier screenshot? Or if you have a template I can load up and pick this data from :)

New to Grafana but finding it a bit difficult to pull multiple datasources from a single graph (using InfluxDB as back end).


Top
 Profile  
 
 Post subject: Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport
PostPosted: Tue May 24, 2016 2:45 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Jan 31, 2008 6:39 am
Posts: 2710
Location: Kressbronn, Germany
I've added the sample dashboard I was using for download to this page:

https://www.urban-software.com/products ... ansporter/

It's by far not complete and I would really appreciate if someone can post their Dashboard for other to use as well.

_________________
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 1.x Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusTransporter | CereusReporting | nmidWebService | nmidSmokeping | nmidWeb2 |

Code:
CereusServer Master:  SYSTEM STATS: Time:2.5621 Method:spine Processes:1 Threads:16 Hosts:446 HostsPerProcess:446 DataSources:14683 RRDsProcessed:7573
CereusServer Agent:   SYSTEM STATS: Time:27.4840 Method:spine Processes:1 Threads:8 Hosts:16 HostsPerProcess:16 DataSources:114576 RRDsProcessed:48061


Top
 Profile  
 
 Post subject: Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport
PostPosted: Tue May 24, 2016 10:12 pm 
Offline

Joined: Mon Apr 22, 2013 1:30 pm
Posts: 25
Thank you very much, and by the way awesome support on your site over the weekend getting that download link fixed +1

I will have some templates to shoot your in the next week, one thing I noticed is the Cacti device "description" does not appear to be sent to influxdb. I updated the following in setup.php but I know very little of php, wanted to make sure this isnt doing anything silly:

Before (Starting on Line 336):
Code:
         $ds_info[ $ds_id ][ 'hostname' ]      = $ds[ 'hostname' ];      
         $host                                 = CereusTransporter_cleanTag( $db_type, CereusTransporter_host( $ds[ "hostname" ], $ds[ "description" ] ) );
         $ds_info[ $ds_id ][ 'host' ]          = strlen( $host ) > 0 ? $host : $ds[ 'hostname' ];


After (Starting on Line 336):
Code:
         $ds_info[ $ds_id ][ 'hostname' ]      = $ds[ 'hostname' ];
         $ds_info[ $ds_id ][ 'description' ]   = $ds[ 'description' ];      
         $host                                 = CereusTransporter_cleanTag( $db_type, CereusTransporter_host( $ds[ "hostname" ], $ds[ "description" ] ) );
         $ds_info[ $ds_id ][ 'host' ]          = strlen( $host ) > 0 ? $host : $ds[ 'hostname' ];


I am now seeing it in test queries

> show series limit 1
key
host.mib.cpu.utilization,cacti_data_id=207,hostname=192.168.200.6,description=sc-wap-ac66u,host=192.168.200.6,host_type=Generic\ SNMP-enabled\ Host,metric_text=Host\ MIB\ -\ CPU\ Utilization,rate=gauge,namecache=sc-wap-ac66u\ -\ CPU\ Utilization\ -\ CPU0,type=cpu,units=percent


Top
 Profile  
 
 Post subject: Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport
PostPosted: Wed May 25, 2016 12:41 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Jan 31, 2008 6:39 am
Posts: 2710
Location: Kressbronn, Germany
Hi smcline06

Thanks for that. I've added the line with some error checking ( InfluxDB only allows a very limited character range and the description may have others in it ( think of german umlauts or chinese chars ).

Updated to v0.50

_________________
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 1.x Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusTransporter | CereusReporting | nmidWebService | nmidSmokeping | nmidWeb2 |

Code:
CereusServer Master:  SYSTEM STATS: Time:2.5621 Method:spine Processes:1 Threads:16 Hosts:446 HostsPerProcess:446 DataSources:14683 RRDsProcessed:7573
CereusServer Agent:   SYSTEM STATS: Time:27.4840 Method:spine Processes:1 Threads:8 Hosts:16 HostsPerProcess:16 DataSources:114576 RRDsProcessed:48061


Top
 Profile  
 
 Post subject: Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport
PostPosted: Wed May 25, 2016 1:46 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Jan 31, 2008 6:39 am
Posts: 2710
Location: Kressbronn, Germany
The next version will include the ability to send data to a Microsoft SQL Server (i.e. local system or on Azure )...

_________________
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 1.x Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusTransporter | CereusReporting | nmidWebService | nmidSmokeping | nmidWeb2 |

Code:
CereusServer Master:  SYSTEM STATS: Time:2.5621 Method:spine Processes:1 Threads:16 Hosts:446 HostsPerProcess:446 DataSources:14683 RRDsProcessed:7573
CereusServer Agent:   SYSTEM STATS: Time:27.4840 Method:spine Processes:1 Threads:8 Hosts:16 HostsPerProcess:16 DataSources:114576 RRDsProcessed:48061


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 136 posts ]  Go to page Previous  1, 2, 3, 4, 5, 6 ... 10  Next

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group