Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Wed Aug 16, 2017 12:36 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 109 posts ]  Go to page Previous  1, 2, 3, 4, 5, 6, 7, 8  Next
Author Message
 Post subject: Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport - Upda
PostPosted: Mon Aug 15, 2016 5:17 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Jan 31, 2008 6:39 am
Posts: 2598
Location: Kressbronn, Germany
How about actually reading the error messages you posted and act accordingly ?

Code:
The PHP cURL extension must be installed to use Guzzle.

_________________
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 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 - Upda
PostPosted: Tue Aug 16, 2016 12:39 am 
Offline

Joined: Mon Aug 15, 2016 2:49 am
Posts: 3
Thank you phalek.
I did install php and i dont get that error anymore but still i'm getting this...


Code:
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') '


Top
 Profile  
 
 Post subject: Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport - Upda
PostPosted: Thu Aug 18, 2016 6:44 am 
Offline

Joined: Mon Aug 15, 2016 2:49 am
Posts: 3
Can anybody please help ...???


Top
 Profile  
 
 Post subject: Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport - Upda
PostPosted: Thu Aug 18, 2016 8:40 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Jan 31, 2008 6:39 am
Posts: 2598
Location: Kressbronn, Germany
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 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 - Upda
PostPosted: Fri Sep 09, 2016 3:51 am 
Offline

Joined: Fri Sep 09, 2016 3:40 am
Posts: 2
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


Top
 Profile  
 
 Post subject: Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport - Upda
PostPosted: Fri Sep 09, 2016 3:58 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Jan 31, 2008 6:39 am
Posts: 2598
Location: Kressbronn, Germany
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 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 - Upda
PostPosted: Mon Sep 12, 2016 1:03 am 
Offline

Joined: Fri Sep 09, 2016 3:40 am
Posts: 2
Thanks. For me it's hard to upgrade PHP, is there a way to implement a workaround in the code?

BR


Top
 Profile  
 
 Post subject: Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport - Upda
PostPosted: Tue Sep 20, 2016 3:49 am 
Offline

Joined: Tue Sep 20, 2016 3:41 am
Posts: 13
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?


Top
 Profile  
 
 Post subject: Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport - Upda
PostPosted: Tue Sep 20, 2016 3:56 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Jan 31, 2008 6:39 am
Posts: 2598
Location: Kressbronn, Germany
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 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 - Upda
PostPosted: Tue Sep 20, 2016 5:09 am 
Offline

Joined: Tue Sep 20, 2016 3:41 am
Posts: 13
Of course, I have enabled the plugin in plugins management


Top
 Profile  
 
 Post subject: Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport - Upda
PostPosted: Tue Sep 20, 2016 5:10 am 
Offline

Joined: Tue Sep 20, 2016 3:41 am
Posts: 13
How to trigger creating tables in the installation process?


Top
 Profile  
 
 Post subject: Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport - Upda
PostPosted: Tue Sep 20, 2016 5:12 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Jan 31, 2008 6:39 am
Posts: 2598
Location: Kressbronn, Germany
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 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 - Upda
PostPosted: Tue Sep 20, 2016 5:29 am 
Offline

Joined: Tue Sep 20, 2016 3:41 am
Posts: 13
yes. I have config the influxdb's admin user


Top
 Profile  
 
 Post subject: Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport - Upda
PostPosted: Tue Sep 20, 2016 5:31 am 
Offline

Joined: Tue Sep 20, 2016 3:41 am
Posts: 13
Is that the time when I changed the config triggered the creating action?


Top
 Profile  
 
 Post subject: Re: InfluxDB/Grafana/Bosun + Cacti = CereusTransport - Upda
PostPosted: Tue Sep 20, 2016 5:41 am 
Offline

Joined: Tue Sep 20, 2016 3:41 am
Posts: 13
create cacti db user? not influxdb user?

Is there anyway I can config the cacti database user?


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

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 2 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