camm - rule= Marker does not work

[gthe]

Show me the output of this sql:

Code: Select all

SELECT * FROM settings where name like 'camm_%';

[torstentfk]

Show me the output of this sql:

Code: Select all

SELECT * FROM settings where name like 'camm_%';

Hi,

here the output from the phpmyadmin-view:

Edit Delete camm_action_order 3
Edit Delete camm_autopurge_timing disabled
Edit Delete camm_debug_mode 1
Edit Delete camm_dependencies 1
Edit Delete camm_email_title CAMM: Syslog-Alert Cacti
Edit Delete camm_general_graphs_ids 0
Edit Delete camm_join_field sourceip
Edit Delete camm_last_autopurge_run_time 1270716937
Edit Delete camm_last_run_time
Edit Delete camm_last_syslogtreedb_time 1280143145
Edit Delete camm_num_rows 50
Edit Delete camm_period_day 1
Edit Delete camm_period_hour 1
Edit Delete camm_period_week 1
Edit Delete camm_process_markers 1
Edit Delete camm_rule_order 2
Edit Delete camm_show_all_records 0
Edit Delete camm_snmptt_delay_purge_day 30
Edit Delete camm_snmptt_max_row_all 0
Edit Delete camm_snmptt_max_row_per_device 0
Edit Delete camm_snmptt_min_row_all 0
Edit Delete camm_snmptt_tables 3
Edit Delete camm_snmptt_trap_tab_update 0
Edit Delete camm_snmptt_unktrap_tab_update 0
Edit Delete camm_startup_tab 0
Edit Delete camm_stats del_traps:0 del_unk_traps:0 del_sys_messages:0
Edit Delete camm_stats_ruledel_snmptt 0
Edit Delete camm_stats_ruledel_syslog 2210
Edit Delete camm_stats_snmptt_tree TreecammTime:0
Edit Delete camm_stats_syslog_tree TreesyslogTime:90.4500

[gthe]

I see 2 incorrect values:

camm_last_run_time

must be set to last poller run date-time.

camm_tree_update

must be!

Try this files from archive and wait for new poller run.

[torstentfk]

sorry - does not help:
see pictures;

and here the log:

Code: Select all

Last run time was '2010-07-26 11:19:05'. Tree update int. in sec=1800 
07/28/2010 03:07:22 PM - SYSTEM camm General STATS: AllTime:1.6103 PurgeTime:0.0000 RuleTime:0.3191 TreeTime:1.2912 
07/28/2010 03:12:26 PM - camm: Poller[0] S3. Checking to determine if it's time to run AutoCreate Tree Menu.
07/28/2010 03:12:26 PM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '1970-01-01 0:00:00'. Last run time was '2010-07-26 11:19:05'. Tree update int. in sec=1800 
07/28/2010 03:12:27 PM - SYSTEM camm General STATS: AllTime:1.6526 PurgeTime:0.0000 RuleTime:0.3590 TreeTime:1.2935 
07/28/2010 03:13:37 PM - camm: Poller[0]  S. CAMM [syslog] Tree was recreated for [123.0779] sec with rezult=[1]
07/28/2010 03:17:21 PM - camm: Poller[0] S3. Checking to determine if it's time to run AutoCreate Tree Menu.
07/28/2010 03:17:21 PM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '1970-01-01 0:00:00'. Last run time was '2010-07-28 15:13:37'. Tree update int. in sec=1800 
07/28/2010 03:17:22 PM - SYSTEM camm General STATS: AllTime:1.6336 PurgeTime:0.0000 RuleTime:0.3195 TreeTime:1.3140 
tfechner@mrshlamste01:/var/www/cacti/log$ tail -f cacti.log | grep Tree
07/28/2010 03:17:21 PM - camm: Poller[0] S3. Checking to determine if it's time to run AutoCreate Tree Menu.
07/28/2010 03:17:21 PM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '1970-01-01 0:00:00'. Last run time was '2010-07-28 15:13:37'. Tree update int. in sec=1800 
07/28/2010 03:17:22 PM - SYSTEM camm General STATS: AllTime:1.6336 PurgeTime:0.0000 RuleTime:0.3195 TreeTime:1.3140 
07/28/2010 03:22:19 PM - camm: Poller[0] S3. Checking to determine if it's time to run AutoCreate Tree Menu.
07/28/2010 03:22:19 PM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '1970-01-01 0:00:00'. Last run time was '2010-07-28 15:13:37'. Tree update int. in sec=1800 
07/28/2010 03:22:21 PM - SYSTEM camm General STATS: AllTime:1.6630 PurgeTime:0.0000 RuleTime:0.3602 TreeTime:1.3027 

[gthe]

One more fix...

[torstentfk]

One more fix...

hmmmmm - bad news: see pictures

camm was running 3 days.
seems, that now the runtime is correct stored:

Code: Select all

08/02/2010 07:17:22 AM - camm: Poller[0] S3. Checking to determine if it's time to run AutoCreate Tree Menu.
08/02/2010 07:17:22 AM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '2010-07-28 15:43:37'. Last run time was '2010-07-28 15:13:37'. Tree update int. in sec=1800 
08/02/2010 07:22:27 AM - camm: Poller[0] S3. Checking to determine if it's time to run AutoCreate Tree Menu.
08/02/2010 07:22:27 AM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '2010-08-02 7:52:16'. Last run time was '2010-08-02 7:22:16'. Tree update int. in sec=1800 
08/02/2010 07:27:18 AM - camm: Poller[0] S3. Checking to determine if it's time to run AutoCreate Tree Menu.
08/02/2010 07:27:18 AM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '2010-08-02 7:52:16'. Last run time was '2010-08-02 7:22:16'. Tree update int. in sec=1800 
08/02/2010 07:32:21 AM - camm: Poller[0] S3. Checking to determine if it's time to run AutoCreate Tree Menu.
08/02/2010 07:32:21 AM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '2010-08-02 7:52:16'. Last run time was '2010-08-02 7:22:16'. Tree update int. in sec=1800 
08/02/2010 07:37:20 AM - camm: Poller[0] S3. Checking to determine if it's time to run AutoCreate Tree Menu.
08/02/2010 07:37:20 AM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '2010-08-02 7:52:16'. Last run time was '2010-08-02 7:22:16'. Tree update int. in sec=1800 
08/02/2010 07:42:20 AM - camm: Poller[0] S3. Checking to determine if it's time to run AutoCreate Tree Menu.
08/02/2010 07:42:20 AM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '2010-08-02 7:52:16'. Last run time was '2010-08-02 7:22:16'. Tree update int. in sec=1800 
08/02/2010 07:47:19 AM - camm: Poller[0] S3. Checking to determine if it's time to run AutoCreate Tree Menu.
08/02/2010 07:47:19 AM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '2010-08-02 7:52:16'. Last run time was '2010-08-02 7:22:16'. Tree update int. in sec=1800 
08/02/2010 07:52:20 AM - camm: Poller[0] S3. Checking to determine if it's time to run AutoCreate Tree Menu.
08/02/2010 07:52:20 AM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '2010-08-02 7:52:16'. Last run time was '2010-08-02 7:22:16'. Tree update int. in sec=1800 
08/02/2010 07:57:18 AM - camm: Poller[0] S3. Checking to determine if it's time to run AutoCreate Tree Menu.
08/02/2010 07:57:18 AM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '2010-08-02 7:52:16'. Last run time was '2010-08-02 7:22:16'. Tree update int. in sec=1800 
08/02/2010 08:02:23 AM - camm: Poller[0] S3. Checking to determine if it's time to run AutoCreate Tree Menu.
08/02/2010 08:02:23 AM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '2010-08-02 7:52:16'. Last run time was '2010-08-02 7:22:16'. Tree update int. in sec=1800 
08/02/2010 08:07:18 AM - camm: Poller[0] S3. Checking to determine if it's time to run AutoCreate Tree Menu.
08/02/2010 08:07:18 AM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '2010-08-02 7:52:16'. Last run time was '2010-08-02 7:22:16'. Tree update int. in sec=1800 
08/02/2010 08:12:19 AM - camm: Poller[0] S3. Checking to determine if it's time to run AutoCreate Tree Menu.
08/02/2010 08:12:19 AM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '2010-08-02 7:52:16'. Last run time was '2010-08-02 7:22:16'. Tree update int. in sec=1800 
08/02/2010 08:17:22 AM - camm: Poller[0] S3. Checking to determine if it's time to run AutoCreate Tree Menu.
08/02/2010 08:17:22 AM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '2010-08-02 7:52:16'. Last run time was '2010-08-02 7:22:16'. Tree update int. in sec=1800 
08/02/2010 08:22:21 AM - camm: Poller[0] S3. Checking to determine if it's time to run AutoCreate Tree Menu.
08/02/2010 08:22:21 AM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '2010-08-02 7:52:16'. Last run time was '2010-08-02 7:22:16'. Tree update int. in sec=1800 
08/02/2010 08:27:18 AM - camm: Poller[0] S3. Checking to determine if it's time to run AutoCreate Tree Menu.
08/02/2010 08:27:18 AM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '2010-08-02 7:52:16'. Last run time was '2010-08-02 7:22:16'. Tree update int. in sec=1800 
08/02/2010 08:32:21 AM - camm: Poller[0] S3. Checking to determine if it's time to run AutoCreate Tree Menu.
08/02/2010 08:32:21 AM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '2010-08-02 7:52:16'. Last run time was '2010-08-02 7:22:16'. Tree update int. in sec=1800 
08/02/2010 08:37:21 AM - camm: Poller[0] S3. Checking to determine if it's time to run AutoCreate Tree Menu.
08/02/2010 08:37:21 AM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '2010-08-02 7:52:16'. Last run time was '2010-08-02 7:22:16'. Tree update int. in sec=1800 
tfechner@mrshlamste01:/var/www/cacti/log$ tail -f cacti.log | grep camm | grep run
08/02/2010 08:37:21 AM - camm: Poller[0] S3. Checking to determine if it's time to run AutoCreate Tree Menu.
08/02/2010 08:37:21 AM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '2010-08-02 7:52:16'. Last run time was '2010-08-02 7:22:16'. Tree update int. in sec=1800 

But I will investigate more on that.

btw: is it possible to get the column width global configurable in the camm settings ?

Torsten

[gthe]

I added one more debug strings. Enable debug mode for camm and wail for rows in cacti log file like this:
(manually recreate)

08/03/2010 01:15:44 PM - camm: Poller[0] php [camm_poller_recreate_tree] The last time the syslog Tree was recreated at '2010-07-27 13:08:12'.
08/03/2010 01:15:44 PM - camm: Poller[0] S. CAMM [syslog] Tree was recreated for [6.2519] sec with rezult=[1]
08/03/2010 01:15:44 PM - camm: Poller[0] php [camm_poller_recreate_tree] The last time the syslog Tree was manually recreated at '2010-08-03 13:15:44'.

(recreate by poller)

08/03/2010 01:17:44 PM - camm: Poller[0] php [poller_camm.php] The last time the snmptt Tree was recreated at '2010-07-27 13:08:05'.
08/03/2010 01:17:44 PM - camm: Poller[0] S3.1 The next snmptt Tree to DB run time has been determined to be NOW
08/03/2010 01:17:44 PM - camm: Poller[0] php [poller_camm.php] The last time the syslog Tree was recreated at '2010-08-03 13:15:44'.
08/03/2010 01:17:44 PM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '2010-08-03 13:25:44'. Last run time was '2010-08-03 13:15:44'. Tree update int. in sec=600
08/03/2010 01:17:49 PM - camm: Poller[0] php [camm_poller_recreate_tree] The last time the snmptt Tree was recreated at '2010-07-27 13:08:05'.
08/03/2010 01:17:49 PM - camm: Poller[0] S. CAMM [snmptt] Tree was recreated for [4.6326] sec with rezult=[1]
08/03/2010 01:17:49 PM - camm: Poller[0] php [camm_poller_recreate_tree] The last time the snmptt Tree was manually recreated at '2010-08-03 13:17:49'.

I hope this will help to determine why the date is not preserved.

btw: is it possible to get the column width global configurable in the camm settings ?

Torsten

Which columns? Width value stored in cookies

[torstentfk]

Hi,

first thanks for debuging...
columns: resziseabel columns in the syslog-view right table;

debugging:

Code: Select all

08/03/2010 08:46:51 AM - camm: Poller[0] S1.3 Use syslog pre table. Move processed records to main syslog table
08/03/2010 08:46:51 AM - camm: Poller[0] S3. Checking to determine if it's time to run AutoCreate Tree Menu.
08/03/2010 08:46:51 AM - camm: Poller[0]  php [poller_camm.php] The last time the syslog Tree was recreated at '2010-08-02 7:22:16'. 
08/03/2010 08:46:51 AM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '2010-08-02 7:52:16'. Last run time was '2010-08-02 7:22:16'. Tree update int. in sec=1800 
...
08/03/2010 09:11:55 AM - camm: Poller[0] S3. Checking to determine if it's time to run AutoCreate Tree Menu.
...
08/03/2010 09:11:55 AM - camm: Poller[0]  php [poller_camm.php] The last time the syslog Tree was recreated at '2010-08-02 7:22:16'. 
08/03/2010 09:11:55 AM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '2010-08-02 7:52:16'. Last run time was '2010-08-02 7:22:16'. Tree update int. in sec=1800 
08/03/2010 09:12:01 AM - SYSTEM camm General STATS: AllTime:6.6308 PurgeTime:0.0000 RuleTime:0.5469 TreeTime:6.0838 
08/03/2010 09:13:21 AM - camm: Poller[0]  php [camm_poller_recreate_tree] The last time the syslog Tree was recreated at '2010-08-02 7:22:16'. 
08/03/2010 09:13:21 AM - camm: Poller[0]  S. CAMM [syslog] Tree was recreated for [186.0844] sec with rezult=[1]
08/03/2010 09:13:21 AM - camm: Poller[0]  php [camm_poller_recreate_tree] The last time the syslog Tree was manually recreated at '2010-08-03 9:13:21'. 
08/03/2010 09:16:52 AM - camm: Poller[0] S3. Checking to determine if it's time to run AutoCreate Tree Menu.
08/03/2010 09:16:52 AM - camm: Poller[0]  php [poller_camm.php] The last time the syslog Tree was recreated at '2010-08-03 9:13:21'.
..
08/03/2010 09:37:00 AM - SYSTEM camm General STATS: AllTime:5.9678 PurgeTime:0.0000 RuleTime:0.5113 TreeTime:5.4564 
08/03/2010 09:41:55 AM - camm: Poller[0] S3. Checking to determine if it's time to run AutoCreate Tree Menu.
08/03/2010 09:41:55 AM - camm: Poller[0]  php [poller_camm.php] The last time the syslog Tree was recreated at '2010-08-03 9:13:21'. 
08/03/2010 09:41:55 AM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '2010-08-03 9:43:21'. Last run time was '2010-08-03 9:13:21'. Tree update int. in sec=1800 
08/03/2010 09:42:00 AM - SYSTEM camm General STATS: AllTime:6.3807 PurgeTime:0.0000 RuleTime:0.9350 TreeTime:5.4456 

08/03/2010 09:46:50 AM - camm: Poller[0] S3. Checking to determine if it's time to run AutoCreate Tree Menu.
08/03/2010 09:46:50 AM - camm: Poller[0]  php [poller_camm.php] The last time the syslog Tree was recreated at '2010-08-03 9:13:21'. 
08/03/2010 09:46:50 AM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '2010-08-03 9:43:21'. Last run time was '2010-08-03 9:13:21'. Tree update int. in sec=1800 
08/03/2010 09:46:56 AM - SYSTEM camm General STATS: AllTime:5.8255 PurgeTime:0.0000 RuleTime:0.5195 TreeTime:5.3059 
08/03/2010 09:51:52 AM - camm: Poller[0] S3. Checking to determine if it's time to run AutoCreate Tree Menu.
08/03/2010 09:51:52 AM - camm: Poller[0]  php [poller_camm.php] The last time the syslog Tree was recreated at '2010-08-03 9:13:21'. 
08/03/2010 09:51:52 AM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '2010-08-03 9:43:21'. Last run time was '2010-08-03 9:13:21'. Tree update int. in sec=1800 
08/03/2010 09:51:59 AM - SYSTEM camm General STATS: AllTime:7.3375 PurgeTime:0.0000 RuleTime:0.5420 TreeTime:6.7954 

you see , I created the the menu manualy, waited until recreating should take place and nothing happened.

Torsten

[gthe]

I think that finally fixed it

[torstentfk]

Hi,

works now!

Code: Select all

08/03/2010 10:56:55 AM - camm: Poller[0]  php [poller_camm.php] The last time the syslog Tree was recreated at '2010-08-03 10:54:15'. 
08/03/2010 10:56:55 AM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '2010-08-03 11:24:15'. Last run time was '2010-08-03 10:54:15'. Tree update int. in sec=1800. current_time=[1280833015], time_till_next_treedb_run=[1640].  
08/03/2010 10:57:01 AM - camm: Poller[0] S4. We have next count of dubled hosts = [2]
08/03/2010 10:57:01 AM - SYSTEM camm General STATS: AllTime:6.7513 PurgeTime:0.0001 RuleTime:0.8542 TreeTime:5.8970 
..
08/03/2010 11:01:54 AM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '2010-08-03 11:24:15'. Last run time was '2010-08-03 10:54:15'. Tree update int. in sec=1800. current_time=[1280833314], time_till_next_treedb_run=[1341]. 
..
08/03/2010 11:22:02 AM - camm: Poller[0] S1.3 Use syslog pre table. Move processed records to main syslog table
08/03/2010 11:22:03 AM - camm: Poller[0] S3. Checking to determine if it's time to run AutoCreate Tree Menu.
08/03/2010 11:22:03 AM - camm: Poller[0]  php [poller_camm.php] The last time the syslog Tree was recreated at '2010-08-03 10:54:15'. 
08/03/2010 11:22:03 AM - camm: Poller[0] S3.1 The next syslog Tree to DB run time has been determined to be at '2010-08-03 11:24:15'. Last run time was '2010-08-03 10:54:15'. Tree update int. in sec=1800. current_time=[1280834523], time_till_next_treedb_run=[132].  
08/03/2010 11:22:09 AM - camm: Poller[0] S4. We have next count of dubled hosts = [2]
08/03/2010 11:22:09 AM - SYSTEM camm General STATS: AllTime:6.5062 PurgeTime:0.0000 RuleTime:0.5512 TreeTime:5.9550 
....
08/03/2010 11:29:34 AM - camm: Poller[0]  php [camm_poller_recreate_tree] The last time the syslog Tree was recreated at '2010-08-03 10:54:15'. 
08/03/2010 11:29:34 AM - camm: Poller[0]  S. CAMM [syslog] Tree was recreated for [150.4686] sec with rezult=[1]
08/03/2010 11:29:34 AM - camm: Poller[0]  php [camm_poller_recreate_tree] The last time the syslog Tree was manually recreated at '2010-08-03 11:29:34'. 
08/03/2010 11:29:40 AM - camm: Poller[0] S4. We have next count of dubled hosts = [2]
08/03/2010 11:29:40 AM - SYSTEM camm General STATS: AllTime:157.1231 PurgeTime:0.0000 RuleTime:0.5594 TreeTime:156.5636 

But next problem is comming - sorry:
I have hugh tables so creating the menue takes time. Is this time is added to the whole polling cycle? If so the polling cyle can exeed 5 minutes. Or do you launch the update process in background and run it asynchron?

Torsten

[gthe]

Hi,

first thanks for debuging...
columns: resziseabel columns in the syslog-view right table;

Torsten

I will add this in next release.

I have hugh tables so creating the menue takes time. Is this time is added to the whole polling cycle? If so the polling cyle can exeed 5 minutes. Or do you launch the update process in background and run it asynchron?

Torsten

Camm poller works in a separate background process.

Thank you for your help in finding this bug!