Manage Plugin 0.6.2 for monitoring networks, servers...

[gilles]

tbaror,
in Console -> Device Managing -> Devices
can you send me a screenshot ?

[tbaror]

Hi,

screenshot as requested attached.
thanks

[gilles]

can you execute this with phpmyadmin ?

Code: Select all

SELECT * FROM data_template_data,data_template,data_local  WHERE data_template.name = 'SNMP  - Running Process Info' and data_template.id=data_template_data.data_template_id and data_local.id=data_template_data.local_data_id and data_local.host_id='<your_id>'

replace <your_id> and give the result (i need name_cache)

[tbaror]

Hi,

i have attached in zip file results
Thanks

[ABX]

I'm trying to implement this plugin, but so far with no success.

I'm trying for a start to make it display on hosts down or up, but each time I try to add a device to manage nothing shows up. Instead in my Cacti log file I get:

Code: Select all

07/31/2007 11:36:30 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT min(id) FROM manage_groups where id in(SELECT min(id) FROM manage_sites)"  
07/31/2007 11:36:30 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT max(id) FROM manage_sites"  
07/31/2007 11:36:30 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT max(id) FROM manage_groups where site_id=''"  
07/31/2007 11:36:30 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT name FROM manage_sites where id=''"  
07/31/2007 11:36:30 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT site_id FROM manage_groups where id=''"  
07/31/2007 11:36:29 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT min(id) FROM manage_groups where id in(SELECT min(id) FROM manage_sites)"  
07/31/2007 11:36:29 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT max(id) FROM manage_sites"  
07/31/2007 11:36:29 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT max(id) FROM manage_groups where site_id=''"  
07/31/2007 11:36:29 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT name FROM manage_sites where id=''"  
07/31/2007 11:36:29 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT site_id FROM manage_groups where id=''"  
07/31/2007 11:36:23 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "delete from manage_tcp where id='6'"  
07/31/2007 11:36:23 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO manage_host VALUES ('6', NULL , '1', '', 'nopoll' , '9', '0', '0', '1', '' )"  

[stevetuk31]

Plugin looks great.

I am having a few issues with installation. I have a few plugins installed with no issues. I have selected a device to monitor.

I have the following warnings.

Trying to add a site:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/cacti-0.8.6j/plugins/manage/manage_sites.php on line 169

Host configuration:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/cacti-0.8.6j/plugins/manage/manage_list.php on line 1403

Manage Tab:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/cacti-0.8.6j/plugins/manage/manage_ajax.php on line 349

[gilles]

verify if the tables are here with phpmyadmin or debug link in settings/misc
if not, the sql files are provided

[stevetuk31]

Thanks Giles.

I think i was a little premature with my query, as i should have looked into the issue a little further. I slapped my wrist

I do however still have an issue when debugging:

Setting 'manage_double_email' from table 'settings' : NOK (0.5)

where might I find the value for the setting?

Thanks in advance

[jayendra.dhamdhere]

I ve extracted into plugins folder.not imported the sql files.but when i create site its not saved.
On the otherhand,if i do a manual import of sql,it adds sites.but againg am not able to view the devices correctly.in any view type.it only shows the upper thin line.

[bloodrayne]

Hi Gilles,

first thanks for that ... it seems very well!

But i have this in my error_log!

Code: Select all

[Fri Aug 17 09:24:16 2007] [error] [client 192.168.100.44] PHP Warning:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/cacti/plugins/manage/manage_sites.php on line 169, referer:http://rss-monitor/cacti/plugins/manage/manage_sites.php?id2=-1&name=aaa&force=null&drp_action=1&x=12&y=13&action=actions

I have that error each time i'm trying to add something to manage plugins!

Thanks!

[super-hornet]

I ve extracted into plugins folder.not imported the sql files.but when i create site its not saved.
On the otherhand,if i do a manual import of sql,it adds sites.but againg am not able to view the devices correctly.in any view type.it only shows the upper thin line.

U need PHP bcmath

SH

[bloodrayne]

Hi Gilles,

first thanks for that ... it seems very well!

But i have this in my error_log!

Code:

[Fri Aug 17 09:24:16 2007] [error] [client 192.168.100.44] PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/cacti/plugins/manage/manage_sites.php on line 169, referer:http://rss-monitor/cacti/plugins/manage ... on=actions



I have that error each time i'm trying to add something to manage plugins!

Thanks!

Does anybody work around this problem?

I'm not able to do any job that correspond to MySQL ... i did some tests, and it seems that the databases functions are there but for a reason or another ... it can connect to the connection that Cacti make ...

Do anybody can help me on that?

Thanks

[bloodrayne]

i found something weird ...

when i do :

Code: Select all

$test = "SELECT COUNT(id) FROM manage_sites";
        $rows = db_fetch_cell($test);
        echo "TEST:";
        echo $rows;

It's doesnt work ...

but i do :

Code: Select all

$test = "SELECT COUNT(id) FROM manage_method";
        $rows = db_fetch_cell($test);
        echo "TEST:";
        echo $rows;

It's working ... the problem really seems to be with manage_sites table ... i dunno where ... dunno why, but it's not working

[chrisgapske]

I have this same issue on a clean install.

I do notice when setting up a device "TCP Ports Template" in the manage--device. I get this error.
"09/12/2007 10:00:40 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT count(id) FROM data_local where data_template_id = AND snmp_index = 23 AND host_id =126" "

Can sombody help me ID what my next step should be to look at this issue.

I must be missing a step somewhere. I've got everything installed properly as far as I can tell. I have configured groups, sites, devices, etc. When I click on the manage tab it shows the devices, but the status of each is the color of blue which is "waiting". I have the poller scheduled to run every minute and it runs as far as I can tell, but the Last poll date stays at 0.

My poller output is:
06/25/2007 03:29:19 PM - MANAGE: Poller[0] Checking Manage
nb pollers : 5
7 9 81 19 12 51
count : 6
N : 1
reste : 1
reste different de 0
nouvelle valeur de N : 2
exec 1 -> 2 snmp 7 9
exec 3 -> 4 snmp 81 19
exec 5 -> 6 snmp 12 51
exec 7 -> 6 snmp

A debug of my tables shows everything is green (OK).

What am I missing?

Thanks,

Cory

[pepj]

After an upgrade from 0.82 to 0.92 I had all the problem you and other had:

Code: Select all

- "Warning: mysql_fetch_array():"

+ solve with applying manually all the sql upgrades (the automatic upgrade didn't upgrade all the changes)

Code: Select all

- CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT count(id) FROM data_local where data_template_id = AND snmp_index = ... AND host_id =..." "

solve with:
1/ "Use Windows PHP Patch"-setting = NO
2/ create sites and groups and later see step 4/

Code: Select all

(solve the "SELECT COUNT(id) FROM manage_sites")

3/ create "manage templates" for each group of ports I used (the old group-ports of 0.82 wasn't more accepted
4/ set site,group, ports-template for each managed hosts and save
5/ remove all managed hosts without site or group

6/ wait 5 minutes or start "php poller_manage.php"

Now all is OK for me but I will do some requests for improving this great plugins.