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

[phalek]

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.

[soniravi06]

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]

Can anybody please help ...???

[phalek]

Search for "mysql error 1114" and look for a solution there. It is neither a cacti nor plugin issue

[jmgonzalezp]

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

[phalek]

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.

[jmgonzalezp]

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

BR

[wentaoyan]

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?

[phalek]

As every other plugin you will have to enable it using the plugin management page within Cacti.

[wentaoyan]

Of course, I have enabled the plugin in plugins management

[wentaoyan]

How to trigger creating tables in the installation process?

[phalek]

That should happen automatically unless you have not provided that CREATE access to the underlying cacti database user.

[wentaoyan]

yes. I have config the influxdb's admin user

[wentaoyan]

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

[wentaoyan]

create cacti db user? not influxdb user?

Is there anyway I can config the cacti database user?