Unable to install mactrack 2.9

[praxis]

Continuation of an earlier post: http://forums.cacti.net/viewtopic.php?f=15&t=38960

Running Cacti 0.8.7g and PA 2.8, unable to install mactrack 2.9-1. Basically, when I untar the files, plugin management page goes blank, and the following shows up in the log:

10/12/2010 04:26:31 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"INSERT INTO plugin_temp_table_356077068 SELECT * FROM plugin_config'
10/12/2010 04:26:31 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1050', SQL:"CREATE TEMPORARY TABLE plugin_temp_table_356077068 LIKE plugin_config'

PA 2.8 doesnt like setup.php

Really wish I could use this plugin, and I'm not running anything out of the ordinary (latest stable cacti and latest stable PA)...why me?

Thanks in advance for any help

[TheWitness]

If you pull a fresh copy of the PIA from SVN, the problem you saw with the errors will be remediated. I don't know why 2.9-1 did not install for you. It has just fine for lot's of others. You may have another plugin affecting this one. The Apache Error Log will give you more details.

TheWitness

[praxis]

Sorry about the double-post, but I felt that announcement reply was misplaced shortly after posting it.

I did try removing all plugins, but even by itself, mactrack wont install, same deal. Apache logs arent yielding any useful information...I've scoured logs looking for clues, but all I find is the cacti.log entries about DB exec failing related to plugin_temp_table - these logs are generated when I click on plugin management after moving the mactrack dir into cacti/plugins.

I'm not comfortable pulling PIA from SVN (my specialty is networks, not software)...is there a beta package with patched files I can try? Any thoughts on where else I might look for clues?

[TheWitness]

Well here it is.... Just not official.

TheWitness

[praxis]

I installed the pia-2.9 you posted and still have the same issue - although I no longer see the errors I mentioned in cacti.log

wish I had more clues here...is there something with mysql that I can check? I'm running mysql version "5.0.77-log" and dont see any errors in the mysqld.log

[praxis]

Finally found the problem. There was a setup.php in the cacti/plugins dir that appeared to be from mactrack 1.1, I rm'ed this file and everything just works.

I figured it was something stupid...thanks anyways

[praxis]

hrmm, when I add devices, I get an error

10/13/2010 03:02:26 PM - CMDPHP: Poller[0] ERROR: SQL Save Command Failed for Table 'mac_track_devices'. Error was 'Unknown column 'host_id' in 'field list''

mac_track_devices doesnt have a host_id column...

Code: Select all

mysql> DESCRIBE mac_track_devices;
+------------------+----------------------+------+-----+---------------------+----------------+
| Field            | Type                 | Null | Key | Default             | Extra          |
+------------------+----------------------+------+-----+---------------------+----------------+
| site_id          | int(10) unsigned     | NO   | PRI | 0                   |                |
| device_id        | int(10) unsigned     | NO   | MUL | NULL                | auto_increment |
| device_name      | varchar(100)         | YES  | MUL |                     |                |
| device_type_id   | int(10) unsigned     | YES  | MUL | 0                   |                |
| hostname         | varchar(40)          | NO   | PRI |                     |                |
| notes            | text                 | YES  |     | NULL                |                |
| disabled         | char(2)              | YES  |     |                     |                |
| ignorePorts      | varchar(255)         | YES  |     | NULL                |                |
| ips_total        | int(10) unsigned     | NO   |     | 0                   |                |
| vlans_total      | int(10) unsigned     | NO   |     | 0                   |                |
| ports_total      | int(10) unsigned     | NO   |     | 0                   |                |
| ports_active     | int(10) unsigned     | NO   |     | 0                   |                |
| ports_trunk      | int(10) unsigned     | NO   |     | 0                   |                |
| macs_active      | int(10) unsigned     | NO   |     | 0                   |                |
| scan_type        | tinyint(11)          | NO   |     | 1                   |                |
| user_name        | varchar(40)          | YES  |     | NULL                |                |
| user_password    | varchar(40)          | YES  |     | NULL                |                |
| snmp_readstring  | varchar(100)         | NO   |     | NULL                |                |
| snmp_readstrings | varchar(255)         | YES  |     | NULL                |                |
| snmp_version     | varchar(100)         | NO   |     |                     |                |
| snmp_port        | int(10)              | NO   | PRI | 161                 |                |
| snmp_timeout     | int(10) unsigned     | NO   |     | 500                 |                |
| snmp_retries     | tinyint(11) unsigned | NO   |     | 3                   |                |
| snmp_sysName     | varchar(100)         | YES  |     |                     |                |
| snmp_sysLocation | varchar(100)         | YES  |     |                     |                |
| snmp_sysContact  | varchar(100)         | YES  |     |                     |                |
| snmp_sysObjectID | varchar(100)         | YES  | MUL | NULL                |                |
| snmp_sysDescr    | varchar(100)         | YES  | MUL | NULL                |                |
| snmp_sysUptime   | varchar(100)         | YES  |     | NULL                |                |
| snmp_status      | int(10) unsigned     | NO   |     | 0                   |                |
| last_runmessage  | varchar(100)         | YES  |     |                     |                |
| last_rundate     | datetime             | NO   |     | 0000-00-00 00:00:00 |                |
| last_runduration | decimal(10,5)        | NO   |     | 0.00000             |                |
+------------------+----------------------+------+-----+---------------------+----------------+

Should it?

[TheWitness]

Is this a new install?

[TheWitness]

You installed by sourcing the *.sql file. This is no longer the process. Drop the mac_track tables and simply install from Plugin Management.

[praxis]

good call, seems to work fine now - thanks

[praxis]

well if it's not one thing...

When I try to add an snmp option set, I get "error: save failed" and no red fields...cacti log shows the following:

10/13/2010 08:38:06 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select max(sequence)+1 as seq from mac_track_snmp_items where snmp_id="
10/13/2010 08:38:06 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM mac_track_snmp WHERE id="
10/13/2010 08:38:04 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select max(sequence)+1 as seq from mac_track_snmp_items where snmp_id="
10/13/2010 08:38:04 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM mac_track_snmp WHERE id="
10/13/2010 08:37:59 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select max(sequence)+1 as seq from mac_track_snmp_items where snmp_id="
10/13/2010 08:37:59 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM mac_track_snmp WHERE id="
10/13/2010 08:37:48 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select max(sequence)+1 as seq from mac_track_snmp_items where snmp_id="
10/13/2010 08:37:48 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM mac_track_snmp WHERE id="

In mysql:

Code: Select all

mysql> select * from mac_track_snmp_items where snmp_id=*;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*' at line 1
mysql> select * from mac_track_snmp_items;
Empty set (0.00 sec)

mysql> select * from mac_track_snmp_items;
Empty set (0.00 sec)

mysql> describe mac_track_snmp_items;
+----------------------+----------------------+------+-----+---------+----------------+
| Field                | Type                 | Null | Key | Default | Extra          |
+----------------------+----------------------+------+-----+---------+----------------+
| id                   | int(10) unsigned     | NO   | PRI | NULL    | auto_increment |
| snmp_id              | int(10) unsigned     | NO   | PRI | 0       |                |
| sequence             | int(10) unsigned     | NO   |     | 0       |                |
| snmp_version         | varchar(100)         | NO   |     |         |                |
| snmp_readstring      | varchar(100)         | NO   |     | NULL    |                |
| snmp_port            | int(10)              | NO   |     | 161     |                |
| snmp_timeout         | int(10) unsigned     | NO   |     | 500     |                |
| snmp_retries         | tinyint(11) unsigned | NO   |     | 3       |                |
| max_oids             | int(12) unsigned     | YES  |     | 10      |                |
| snmp_username        | varchar(50)          | YES  |     | NULL    |                |
| snmp_password        | varchar(50)          | YES  |     | NULL    |                |
| snmp_auth_protocol   | char(5)              | YES  |     |         |                |
| snmp_priv_passphrase | varchar(200)         | YES  |     |         |                |
| snmp_priv_protocol   | char(6)              | YES  |     |         |                |
| snmp_context         | varchar(64)          | YES  |     |         |                |
+----------------------+----------------------+------+-----+---------+----------------+
15 rows in set (0.00 sec)

any ideas?

[TheWitness]

Do not bind the cacti and mactrack devices directly. Manage them separately. The author of that work did not completely test.

Pretty sure that it.