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

Addons for Cacti and discussion about those addons

Moderators: Moderators, Developers

Post Reply
Author
Message
User avatar
phalek
Cacti Guru User
Posts: 2711
Joined: Thu Jan 31, 2008 6:39 am
Location: Kressbronn, Germany
Contact:

Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport - Upda

#61 Post by phalek » Mon Aug 15, 2016 5:17 am

How about actually reading the error messages you posted and act accordingly ?

Code: Select all

The PHP cURL extension must be installed to use Guzzle.
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: Select all

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
[/size]

soniravi06
Posts: 3
Joined: Mon Aug 15, 2016 2:49 am

Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport - Upda

#62 Post by soniravi06 » Tue Aug 16, 2016 12:39 am

Thank you phalek.
I did install php and i dont get that error anymore but still i'm getting this...

Code: Select all

08/16/2016 11:06:21 AM - SYSTEM SYSLOG STATS:Time:0.06 Deletes:0 Incoming:0 Removes:0 XFers:0 Alerts:2 Alarms:0 Reports:1
08/16/2016 11:06:20 AM - CereusTransporter: Poller[0] INFO: Adding data to influxdb
08/16/2016 11:06:20 AM - SYSTEM THOLD STATS: Time:0.0945 Tholds:0 TotalHosts:195 DownHosts:28 NewDownHosts:0
08/16/2016 11:06:20 AM - SYSTEM STATS: Time:79.2342 Method:cmd.php Processes:1 Threads:N/A Hosts:196 HostsPerProcess:196 DataSources:9054 RRDsProcessed:4024
08/16/2016 11:06:20 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1114', SQL:"INSERT INTO `plugin_CereusTransporter_data` (`timestamp`, `local_data_id`, `key`, `value`) VALUES ('1471325780',11409,'traffic_out','407531540663') '
08/16/2016 11:06:20 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1114', SQL:"INSERT INTO `plugin_CereusTransporter_data` (`timestamp`, `local_data_id`, `key`, `value`) VALUES ('1471325780',11409,'traffic_in','50299973415') '
08/16/2016 11:06:20 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1114', SQL:"INSERT INTO `plugin_CereusTransporter_data` (`timestamp`, `local_data_id`, `key`, `value`) VALUES ('1471325780',11408,'traffic_in','0') '
08/16/2016 11:06:20 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1114', SQL:"INSERT INTO `plugin_CereusTransporter_data` (`timestamp`, `local_data_id`, `key`, `value`) VALUES ('1471325780',11408,'traffic_out','1421350') '
08/16/2016 11:06:20 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1114', SQL:"INSERT INTO `plugin_CereusTransporter_data` (`timestamp`, `local_data_id`, `key`, `value`) VALUES ('1471325780',11407,'traffic_out','1679915') '
08/16/2016 11:06:20 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1114', SQL:"INSERT INTO `plugin_CereusTransporter_data` (`timestamp`, `local_data_id`, `key`, `value`) VALUES ('1471325780',11407,'traffic_in','287386') '
08/16/2016 11:06:20 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1114', SQL:"INSERT INTO `plugin_CereusTransporter_data` (`timestamp`, `local_data_id`, `key`, `value`) VALUES ('1471325780',11406,'traffic_in','105639198434') '
08/16/2016 11:06:20 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1114', SQL:"INSERT INTO `plugin_CereusTransporter_data` (`timestamp`, `local_data_id`, `key`, `value`) VALUES ('1471325780',11406,'traffic_out','2222761769') '
08/16/2016 11:06:20 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1114', SQL:"INSERT INTO `plugin_CereusTransporter_data` (`timestamp`, `local_data_id`, `key`, `value`) VALUES ('1471325780',11405,'traffic_out','1172915003631') '
08/16/2016 11:06:20 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1114', SQL:"INSERT INTO `plugin_CereusTransporter_data` (`timestamp`, `local_data_id`, `key`, `value`) VALUES ('1471325780',11405,'traffic_in','128459011266') '
08/16/2016 11:06:20 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1114', SQL:"INSERT INTO `plugin_CereusTransporter_data` (`timestamp`, `local_data_id`, `key`, `value`) VALUES ('1471325780',11404,'traffic_in','1114000065884') '
08/16/2016 11:06:20 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1114', SQL:"INSERT INTO `plugin_CereusTransporter_data` (`timestamp`, `local_data_id`, `key`, `value`) VALUES ('1471325780',11404,'traffic_out','123031695918') '
08/16/2016 11:06:20 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1114', SQL:"INSERT INTO `plugin_CereusTransporter_data` (`timestamp`, `local_data_id`, `key`, `value`) VALUES ('1471325780',11403,'traffic_out','0') '
08/16/2016 11:06:20 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1114', SQL:"INSERT INTO `plugin_CereusTransporter_data` (`timestamp`, `local_data_id`, `key`, `value`) VALUES ('1471325780',11403,'traffic_in','0') '
08/16/2016 11:06:20 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1114', SQL:"INSERT INTO `plugin_CereusTransporter_data` (`timestamp`, `local_data_id`, `key`, `value`) VALUES ('1471325780',11402,'traffic_in','72843540073') '
08/16/2016 11:06:20 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1114', SQL:"INSERT INTO `plugin_CereusTransporter_data` (`timestamp`, `local_data_id`, `key`, `value`) VALUES ('1471325780',11402,'traffic_out','757833603724') '
08/16/2016 11:06:20 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1114', SQL:"INSERT INTO `plugin_CereusTransporter_data` (`timestamp`, `local_data_id`, `key`, `value`) VALUES ('1471325780',11401,'uptime','32543500') '
08/16/2016 11:06:20 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1114', SQL:"INSERT INTO `plugin_CereusTransporter_data` (`timestamp`, `local_data_id`, `key`, `value`) VALUES ('1471325780',11400,'cpu','0') '
08/16/2016 11:06:20 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1114', SQL:"INSERT INTO `plugin_CereusTransporter_data` (`timestamp`, `local_data_id`, `key`, `value`) VALUES ('1471325780',11399,'active','77') '
08/16/2016 11:06:20 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1114', SQL:"INSERT INTO `plugin_CereusTransporter_data` (`timestamp`, `local_data_id`, `key`, `value`) VALUES ('1471325780',11398,'arp_entries','U') ' 

soniravi06
Posts: 3
Joined: Mon Aug 15, 2016 2:49 am

Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport - Upda

#63 Post by soniravi06 » Thu Aug 18, 2016 6:44 am

Can anybody please help ...???

User avatar
phalek
Cacti Guru User
Posts: 2711
Joined: Thu Jan 31, 2008 6:39 am
Location: Kressbronn, Germany
Contact:

Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport - Upda

#64 Post by phalek » Thu Aug 18, 2016 8:40 am

Search for "mysql error 1114" and look for a solution there. It is neither a cacti nor plugin issue
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: Select all

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
[/size]

jmgonzalezp
Posts: 2
Joined: Fri Sep 09, 2016 3:40 am

Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport - Upda

#65 Post by jmgonzalezp » Fri Sep 09, 2016 3:51 am

Hello, thank you for your contribution with this pluggin.

I have a problem, I uploaded it to the plugins directory and now the "Plugging Management" page doesn't work. Maybe a PHP version problem?

My configuration:
PHP 5.1.2
Cacti Version: 0.8.8c, Plugin Architecture Version: 3.1

BR

User avatar
phalek
Cacti Guru User
Posts: 2711
Joined: Thu Jan 31, 2008 6:39 am
Location: Kressbronn, Germany
Contact:

Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport - Upda

#66 Post by phalek » Fri Sep 09, 2016 3:58 am

Hi,

You're right. It's a PHP version issue.
The Guzzlehttp module being used requires a minimum PHP version of 5.3.3. I've updated the plugin page accordingly.
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: Select all

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
[/size]

jmgonzalezp
Posts: 2
Joined: Fri Sep 09, 2016 3:40 am

Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport - Upda

#67 Post by jmgonzalezp » Mon Sep 12, 2016 1:03 am

Thanks. For me it's hard to upgrade PHP, is there a way to implement a workaround in the code?

BR

wentaoyan
Posts: 13
Joined: Tue Sep 20, 2016 3:41 am

Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport - Upda

#68 Post by wentaoyan » Tue Sep 20, 2016 3:49 am

I just unzip the CereusTransporter_v0.64-1.zip to /var/www/html/cacti/plugins/ to install the CereusTransporter. Is that the right installation?

In cacti log there huge amout of error :
09/20/2016 04:34:01 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"DELETE FROM `plugin_CereusTransporter_data`'

It because of Cacti cannot find the table plugin_CereusTransporter_data. But how can I create the table?

User avatar
phalek
Cacti Guru User
Posts: 2711
Joined: Thu Jan 31, 2008 6:39 am
Location: Kressbronn, Germany
Contact:

Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport - Upda

#69 Post by phalek » Tue Sep 20, 2016 3:56 am

As every other plugin you will have to enable it using the plugin management page within Cacti.
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: Select all

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
[/size]

wentaoyan
Posts: 13
Joined: Tue Sep 20, 2016 3:41 am

Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport - Upda

#70 Post by wentaoyan » Tue Sep 20, 2016 5:09 am

Of course, I have enabled the plugin in plugins management

wentaoyan
Posts: 13
Joined: Tue Sep 20, 2016 3:41 am

Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport - Upda

#71 Post by wentaoyan » Tue Sep 20, 2016 5:10 am

How to trigger creating tables in the installation process?

User avatar
phalek
Cacti Guru User
Posts: 2711
Joined: Thu Jan 31, 2008 6:39 am
Location: Kressbronn, Germany
Contact:

Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport - Upda

#72 Post by phalek » Tue Sep 20, 2016 5:12 am

That should happen automatically unless you have not provided that CREATE access to the underlying cacti database user.
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: Select all

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
[/size]

wentaoyan
Posts: 13
Joined: Tue Sep 20, 2016 3:41 am

Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport - Upda

#73 Post by wentaoyan » Tue Sep 20, 2016 5:29 am

yes. I have config the influxdb's admin user

wentaoyan
Posts: 13
Joined: Tue Sep 20, 2016 3:41 am

Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport - Upda

#74 Post by wentaoyan » Tue Sep 20, 2016 5:31 am

Is that the time when I changed the config triggered the creating action?

wentaoyan
Posts: 13
Joined: Tue Sep 20, 2016 3:41 am

Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport - Upda

#75 Post by wentaoyan » Tue Sep 20, 2016 5:41 am

create cacti db user? not influxdb user?

Is there anyway I can config the cacti database user?

Post Reply