update 1.x to 2.5 problems

[torstentfk]

Hello,
i upgrades mactrack from version 1 to 2.5:
- unzipped the 25.tgz file
- removed config line in global.php
- removed old directory
- waited 5 minutes to give cacti time to include the new mactrack into "plugin management" screen

-> nothing appeared: no chapter to install the plugin, no mactrack top icon.
there was soime time where both , old and new version are in the plugin directory. I hope that cacti does not get confused with this temporary config.

How can I enable this plugin now?

Torsten

[TheWitness]

Odd, if the directory is named "mactrack", it should show up under pluing management. You only had to overcopy them. Very odd.

TheWitness

[torstentfk]

hi,
seems easy - as I have done the installation of plugins many times before.
All times it works - but now I have this problem.
It shows like:
-----------------
host:/var/www/cacti/plugins# ls -al
..
drw-r--r-- 5 www-data www-data 4096 Apr 19 17:40 mactrack
..
-----------------
But under Plugin Management there is no link to "install" it.
should I delete the old mactrack tables?

Torsten

[TheWitness]

No, don't delete them. They will upgrade on their own fine once you install/enable the plugin. Get rid of the old directory though.

This has to be some issue with the old pia way of doing things as it would appear all is fine.

TheWitness

[TheWitness]

Wait, are you saying that you see the plugin from Plugin Management, but no install link? If that's the case, your done.

TheWitness

[torstentfk]

Wait, are you saying that you see the plugin from Plugin Management, but no install link? If that's the case, your done.

TheWitness

sorry- wrong words ( may be I am german?)
No - normaly I see the new plugins in the screen with a blue "Install". but now I have no entry of the whol eplugin "Device Tracking" or "Mactrack"...

T

[TheWitness]

Code: Select all

chmod -R 644

mactrack is all I can think of.

[TheWitness]

Oh, crap, I know what wrong now. The directories don't have RX permissions. Therefore, the web server can ls into them. Crap. My bad.

Code: Select all

chmod -R 755 mactrack

Will fix that.

TheWitness

[TheWitness]

I'm re-uploading a new 2.5 now with corrected permissions.

TheWitness

[torstentfk]

I'm re-uploading a new 2.5 now with corrected permissions.

TheWitness

ok - works - Now I have to test the new features...

....
the poller runs.
in the meantime I saw this (see picture):
an error in the main cacti-files and no devices listed , but many pages available.
Do I have to patch some files from the origin cacti installation?

Torsten[/img]

[TheWitness]

That is odd. I did not see that in my testing. I'll have to investigate. I also need the errors from the Cacti Log when you show this page. Might be the new feature that I did not test cause someone told me it worked (Not you).

TheWitness

[TheWitness]

Found the index issue. Now we need to understand the SQL error.

[torstentfk]

That is odd. I did not see that in my testing. I'll have to investigate. I also need the errors from the Cacti Log when you show this page. Might be the new feature that I did not test cause someone told me it worked (Not you).

TheWitness

hi,

this is the error in the log file

Code: Select all

root@m1:/var/www/cacti/log# cat cacti.log 
04/22/2010 07:58:44 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT mac_track_interfaces.*,  mac_track_device_types.description AS device_type,  mac_track_devices.device_name,  mac_track_devices.host_id,  mac_track_devices.disabled,  mac_track_devices.last_rundate  FROM mac_track_interfaces  INNER JOIN mac_track_devices  ON mac_track_interfaces.device_id=mac_track_devices.device_id  INNER JOIN mac_track_device_types  ON mac_track_device_types.device_type_id=mac_track_devices.device_type_id  WHERE (ifName NOT REGEXP '(Vlan|Loopback|Null)' AND ifDescr NOT REGEXP '(Vlan|Loopback|Null)')  ORDER BY device_name DESC LIMIT 0,40"
04/22/2010 07:58:51 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT mac_track_interfaces.*,  mac_track_device_types.description AS device_type,  mac_track_devices.device_name,  mac_track_devices.host_id,  mac_track_devices.disabled,  mac_track_devices.last_rundate  FROM mac_track_interfaces  INNER JOIN mac_track_devices  ON mac_track_interfaces.device_id=mac_track_devices.device_id  INNER JOIN mac_track_device_types  ON mac_track_device_types.device_type_id=mac_track_devices.device_type_id  WHERE (ifName NOT REGEXP '(Vlan|Loopback|Null)' AND ifDescr NOT REGEXP '(Vlan|Loopback|Null)')  ORDER BY device_name DESC LIMIT 0,40"
root@m:/var/www/cacti/log#

btw: I have several old processes like this:

Code: Select all

www-data  4980     1  0 Apr21 ?        00:00:09 /usr/bin/php -q /var/www/cacti/plugins/mactrack/mactrack_resolver.php
www-data 26078     1  0 Apr21 ?        00:00:07 /usr/bin/php -q /var/www/cacti/plugins/mactrack/mactrack_resolver.php

this is not only for the mactrack plugin; I also have this lost processes from spine. (newest version incl. patches).
Is this a php ini-problem?

Torsten

[torstentfk]

perhaps this help you:

mactrack-page via tab-> devices

sorry - no sql error in the cacti log

[TheWitness]

Looks like the database upgrade did not run correctly for you.

TheWitness