[SOLVED] Another Nectar issue

[lcano]

Don't want to repeat any issue already solved, so I searched for issues related to Nectar Pluging, but nothing that helped me.

The point is, after installing nectar, I am able to create a report, but when I Add report items, no item is saved and/or applied. It apparently saves the items, but no results.

I tried to modify the plugings load order, selecting first nectar, but same issue. I also uninstall all plugins but nectar, but no changes

Any suggestion or something I didn't realized?

Attached, some screenshots.

System:
Cacti: 0.8.7g
PA: 2.8
PHP: 5.1.2
RRDTool: 1.2.x
Apache: 2.2.3
Platform: Linux SUSE

[gandalf]

Please see http://docs.cacti.net/plugin:nectar
R.

[prospero63]

Do you have the patch file in a format usable on a Windows based Cacti server? I assume settings_include_functions.php.patch is the mentioned patch ("NOTE: You must patch the settings plugin using the attached patch"). TIA.

[lcano]

Please see http://docs.cacti.net/plugin:nectar
R.

Gandalf,

from "Prerequisites", I missed patching the functions.php file from settings pluging. Ok, already done, still same problem

Patching command applied from cacti directory:

Code: Select all

mxmecore01:/aplicaciones/cacti # patch -p1 -N --verbose < settings_include_functions.php.patch
Hmm...  Looks like a unified diff to me...
The text leading up to this was:
--------------------------
|--- cacti_plugins/settings/trunk/include/functions.php 2009-10-29 23:46:43.000000000 +0100
|+++ plugin087d/plugins/settings/include/functions.php  2009-12-05 22:23:07.000000000 +0100
--------------------------
Patching file plugins/settings/include/functions.php using Plan A...
Hunk #1 succeeded at 22.
Hunk #2 succeeded at 107.
done



mxmecore01:/aplicaciones/cacti # patch -p1 -N --verbose < settings_include_functions.php.patch
Hmm...  Looks like a unified diff to me...
The text leading up to this was:
--------------------------
|--- cacti_plugins/settings/trunk/include/functions.php 2009-10-29 23:46:43.000000000 +0100
|+++ plugin087d/plugins/settings/include/functions.php  2009-12-05 22:23:07.000000000 +0100
--------------------------
Patching file plugins/settings/include/functions.php using Plan A...
Reversed (or previously applied) patch detected!  Skipping patch.
Hunk #1 ignored at 22.
Hunk #2 ignored at 107.
2 out of 2 hunks ignored -- saving rejects to file plugins/settings/include/functions.php.rej
done

Reminder:

PIA: 2.8
Cacti: 0.8.7g

[gandalf]

Please post plugins/settings/inlcude/functions.* to resolve the patch issue.
Then, please tell us which mysql tables for nectar are available to you. And please search for mysql errors in cacti.log
R.

[lcano]

Attached, the final functions.php after patching. No other functions.* in cacti/plugins/settings/include folder.

No mysql errors in cacti.log, with poller logging level set to HIGH.

Looking for tables in mysql, as I'm not sure how many of them are specifically related to nectar, i post the full output:

Code: Select all

mysql> use cacti;
Database changed
mysql> show tables;
+---------------------------------------+
| Tables_in_cacti                       |
+---------------------------------------+
| cdef                                  | 
| cdef_items                            | 
| colors                                | 
| data_input                            | 
| data_input_data                       | 
| data_input_fields                     | 
| data_local                            | 
| data_template                         | 
| data_template_data                    | 
| data_template_data_rra                | 
| data_template_rrd                     | 
| gpsmap_templates                      | 
| graph_local                           | 
| graph_template_input                  | 
| graph_template_input_defs             | 
| graph_templates                       | 
| graph_templates_gprint                | 
| graph_templates_graph                 | 
| graph_templates_item                  | 
| graph_tree                            | 
| graph_tree_items                      | 
| host                                  | 
| host_graph                            | 
| host_snmp_cache                       | 
| host_snmp_query                       | 
| host_template                         | 
| host_template_graph                   | 
| host_template_snmp_query              | 
| plugin_aggregate_color_template_items | 
| plugin_aggregate_color_templates      | 
| plugin_config                         | 
| plugin_db_changes                     | 
| plugin_hooks                          | 
| plugin_nectar                         | 
| plugin_nectar_items                   | 
| plugin_realms                         | 
| plugin_rrdclean                       | 
| plugin_rrdclean_action                | 
| plugin_thold_contacts                 | 
| plugin_thold_log                      | 
| plugin_thold_template_contact         | 
| plugin_thold_threshold_contact        | 
| poller                                | 
| poller_command                        | 
| poller_item                           | 
| poller_output                         | 
| poller_reindex                        | 
| poller_time                           | 
| rra                                   | 
| rra_cf                                | 
| settings                              | 
| settings_graphs                       | 
| settings_tree                         | 
| snmp_query                            | 
| snmp_query_graph                      | 
| snmp_query_graph_rrd                  | 
| snmp_query_graph_rrd_sv               | 
| snmp_query_graph_sv                   | 
| superlinks_auth                       | 
| superlinks_pages                      | 
| thold_data                            | 
| thold_template                        | 
| user_auth                             | 
| user_auth_perms                       | 
| user_auth_realm                       | 
| user_log                              | 
| version                               | 
| weathermap_auth                       | 
| weathermap_data                       | 
| weathermap_groups                     | 
| weathermap_maps                       | 
| weathermap_settings                   | 
+---------------------------------------+
72 rows in set (0.01 sec)

[lcano]

Ok, my fault

I downloaded the wrong pluging version, the one on the top of the page, so I tried to install v0.11

Now, installed the last one, v0.29, also changed mailer.php with the one included in the pluging, but I didn't find any functions.php or any *.patch file These are all the files included:

Code: Select all

:/aplicaciones/cacti/plugins/nectar # ls -lrt
total 208
drwxrwxr-x 2 cactiuser users   136 Nov 18 20:48 0.8.7e
drwxrwxr-x 2 cactiuser users   120 Nov 18 20:48 images
-rw-rw-r-- 1 cactiuser users 15237 Nov 18 20:48 LICENSE
drwxrwxr-x 2 cactiuser users    80 Nov 18 20:48 0.8.7g
-rw-rw-r-- 1 cactiuser users  6197 Nov 18 20:48 top_general_header.php
drwxrwxr-x 2 cactiuser users   160 Nov 18 20:48 formats
-rw-rw-r-- 1 cactiuser users 49927 Dec 11 15:36 setup.php
-rw-rw-r-- 1 cactiuser users  5397 Dec 11 15:37 README
-rw-rw-r-- 1 cactiuser users 55555 Dec 11 15:51 nectar_webapi.php
-rw-rw-r-- 1 cactiuser users  5471 Dec 11 15:54 poller_nectar.php
-rw-rw-r-- 1 cactiuser users  3082 Dec 11 15:55 import_from_reports.php
-rw-rw-r-- 1 cactiuser users  3099 Dec 11 15:56 nectar_user.php
-rw-rw-r-- 1 cactiuser users  3233 Dec 11 15:56 nectar.php
-rw-rw-r-- 1 cactiuser users 46030 Dec 11 18:15 nectar_functions.php

Anyway, I continue without patching and it seems to work properly.

Waiting only for Gandalf's confirmation to change post subject to SOLVED.

Thanks...

[gandalf]

Code: Select all

drwxrwxr-x 2 cactiuser users   136 Nov 18 20:48 0.8.7e

What about this directory?
BTB: I just released v0.30. Some fixes, no features
R.

[lcano]

What about this directory?
BTB: I just released v0.30. Some fixes, no features
R.

There it is. But it is tricky, as I'm running v0.8.7g and I didn't pay many attention to a 0.8.7e directory.

Thanks

[gandalf]

What about this directory?
BTB: I just released v0.30. Some fixes, no features
R.

There it is. But it is tricky, as I'm running v0.8.7g and I didn't pay many attention to a 0.8.7e directory.

Thanks

Then, your sig is misleading. Please find the patches in 087g directory, then
R.

[lcano]

Then, your sig is misleading. Please find the patches in 087g directory, then
R.

I have some other cacti servers running 0.8.7em but not this one. That's the reason of the signature.

Anyway, following your tips:

Code: Select all

mxmecore01:/aplicaciones/cacti/plugins/nectar/0.8.7g # ls -lrta
total 33
-rw-rw-r-- 1 cactiuser users 30261 Nov 18 20:48 mailer.php
drwxrwxr-x 2 cactiuser users    80 Nov 18 20:48 .
drwxrwxr-x 6 cactiuser users   488 Dec 11 15:23 ..

So, no patching files in that directory. I downloaded the pluging from the officlal plugin page:

http://docs.cacti.net/_media/plugin:nectar-v0.29.tgz

Do we really need any patch for 0.8.7g and the files are missed, or this version doesn't need to be patched?

[phalek]

If you have PIA 2.9 installed then you do not need to patch. PIA 2.8 does need to be patched.

[lcano]

If you have PIA 2.9 installed then you do not need to patch. PIA 2.8 does need to be patched.

Thanks, Phalek. PIA 2.8 in my case, so needs to be patched. The point,.... no files in 0.8.7g directory in v0.29, neither in v0.30.

[gandalf]

I'm surprised. My SVN copy has this file. Please find it attached
R.

[lcano]

Gandalf,

there was a misunderstanding. I was looking for a patching file, not a file to replace. Don't be surprised, the mailer.php file to replace IS in the directory. Sorry for that !

From my point, the issue is absolutely solved.