Cacti

OK. I see Cacti is using ADODB for database interface. But it's a very old version from 2004 :-/ I've updated it with latest prod version of ADODB (v5.20.3), and I'm currently in the process of reviewing every SQL request to adapt them to PostgreSQL... I've already a PostgreSQL "Cacti" run...

Hi, Please find my first attempt to provide a SQL schema of the cacti database for PostgreSQL (v 9.4.x). If you want to create a PostgreSQL DB with this schema, you have to create a cacti user and a cacti database before to make PSQL read this file to init the DB (because all tables in the file have...

Hi there, I've a cosmetic problem since ages with CAMM. All snmp traps having severity to Critical are colored in white. Normal SNMP traps are in green, informational are in white, and warning are in orange, so no problem for them. Critical ones should be in Red. Any idea? Thanks a lot for your help...

Result is: mysql> select CONVERT(GROUP_CONCAT(concat('test=',6+8,';\r\n') SEPARATOR '-')USING UTF8); +----------------------------------------------------------------------------+ | CONVERT(GROUP_CONCAT(concat('test=',6+8,';\r\n') SEPARATOR '-')USING UTF8) | +----------------------------------------...

Your first SQL request gives: mysql> SELECT GROUP_CONCAT(t3.name SEPARATOR '') as rules_name, -> t1.*,host.description, host.host_template_id, host.id as device_id FROM -> (SELECT * FROM `cacti`.`plugin_camm_syslog` where `id`='60159' ) as t1 Left join host on (t1.`host`=`host`.`hostname` ) left joi...

SELECT count(*) FROM `cacti`.`plugin_camm_syslog` where `id`='60159'; gives: mysql> SELECT count(*) FROM `cacti`.`plugin_camm_syslog` where `id`='60159'; +----------+ | count(*) | +----------+ | 1 | +----------+ 1 row in set (0.00 sec) SELECT t2.`rule_id` as rules_name,t1.*,host.description, host.h...

Still trying to debug this famous "No row data for this ID" I've modified the error message to show the SQL request done. Here it is below: SELECT CONVERT(GROUP_CONCAT(concat(t2.`rule_id`, ' [',t3.name, ']'),';\r\n' SEPARATOR '') USING UTF8) as rules_name,t1.*,host.description, host.host_t...

I'm continuing my tests about the impossibility to have the "view full trap" window showing anything. I've installed syslog-ng v 3.0.2, and it is configured to send all in the plugin_camm_syslog table of the database used by camm. Then I've enabled syslog in camm (set to true in the settin...

smlick , Very strange.... Can you run this queries in mysql command line and show me the full error output / results ? SELECT CONVERT(GROUP_CONCAT(concat(t2.`rule_id`, ' [',t3.name, ']'),';\r\n' SEPARATOR '') USING UTF8) as rules_name,t1.*,host.description, host.host_template_id, host.id as device_...

Hi Phalek, I've version 0.82 of nmidCreatePdf. Today, I wanted to have a view of the status of my servers in the "monitor" plugin also installed in my cacti installation. But I was surprised to have a white page after having clicked on the "monitor" tab. Taking a look at the http...

Hi Phalek, End of january, our cacti installation stop to work (30th january at midnight), even cacti spine poller. Looking at httpd error log at first, I've seen tthis error message: PHP Fatal error: SourceGuardian Loader - This script has expired. Please contact the script author about this proble...

browniebraun wrote:Do you have sql errors in your log?

I did setup my cacti to have DEBUG log level.

There is no error in the cacti log.

There is also no error in the httpd error_log file.

browniebraun wrote: You have to tick the diplayed data source items like "traffic_in" or "traffic_out" or something else. Or tick all checkboxes.

This is the point.

Nothing is displayed. And that's the same for all kind of data templates...

Hi there. I've installed version 0.71 of reportit for the first time in my cacti 0.8.7e. When I go in Report templates to create a new (abd first) one, I select Interface Traffic and I click on next. Then I give just a name to my template, and click on create. Here, two error messages are displayed:...

Yes :-) We are big european institution having tons of servers to monitor in two datacenters. We are European Investment Bank in Luxembourg. And yes, you made good impression ;-) I will see with directors here if it is possible to buy you a commercial edition (but I need a price for that) But in eur...