- Nav-users - lister.unit.no

Announcement: NAV 3.11.0 and 3.10.4 released
by Morten Brekkevold 13 Mar '12

13 Mar '12

The newest feature release of NAV, version 3.11.0, is now available for download at Launchpad: https://launchpad.net/nav/3.11/3.11.0 The (hopefully) last bugfix release of the 3.10 series is also available at https://launchpad.net/nav/3.10/3.10.4 Both releases include a fix for the following embarrassing issue: * LP#947080 (Netbox attributes aren't updated when modules are found) The 3.11.0 release adds the following user-visible features and improvements: * LLDP support for improved topology detection. * getBoksMacs replaced by ipdevpoll plugins in `topo` job (i.e. fewer Java dependencies) * Q-BRIDGE-MIB now also used when collecting switch forwarding tables, meaning improved machine tracking data for switch vendors like HP, Juniper and Alcatel. * The Machine Tracker's IP search form has consolidated the `To` and `From` IP address search fields into a single `IP Range` search field with extended search syntax for ranges of IP addresses. See LP#643544 for details. * ipdevpoll can now be made to run single job configurations from ipdevpoll.conf, to run in the foreground, and to log to stderr instead of its log file. * ipdevpoll will reset its log levels from logging.conf upon receiving a SIGHUP signal. * ipdevpoll will log the currently active polling jobs upon receiving a SIGUSR1 signal. Don't forget to check out the release notes before/during/after upgrading to NAV 3.11. Please report bugs at https://launchpad.net/nav/+filebug :-) Binary packages for Debian will be made available as soon as possible. The Debian package is maintained by Morten Werner Forsbring, on commission From UNINETT. Happy NAVing everyone! -- Morten Brekkevold UNINETT

3 2

Using NAV as a source for rancid
by Sigurd Mytting 12 Mar '12

12 Mar '12

Hi! We´re looking into using rancid (http://www.shrubbery.net/rancid/) for keeping track of device configuration. I´d like to use the NAV database to build the rancid configuration. Currently I use dump.py, but I need more of the internal NAV data per device, most importantly I need to know the device vendor - cisco, juniper, alteon and so on. Is there an easy way to get a more complete dump of the NAV database? Cheers, -Sigurd

2 3

unsubscripe nav-users
by Jan Bakke 02 Mar '12

02 Mar '12

unsubscripe nav-users

1 0

Announcement: NAV 3.10.3 released
by Morten Brekkevold 02 Mar '12

02 Mar '12

NAV 3.10.3 is now available for download at Launchpad: https://launchpad.net/nav/3.10/3.10.3 This maintenance release contains fixes for the following reported issues, as well as a few other minor tweaks: * LP#906849 (Status page does not show current IP devices down) * LP#936926 (mcc registers sensors RRD files in wrong directory) * LP#937622 (a device's supported snmp version is never updated) * LP#937677 (type, device and various other attributes aren't updated) * If you're on NAV 3.10, we recommend that you upgrade as soon as possible, as these bugs are quite crippling if they hit you. * After the upgrade, we also recommend running `cleanrrds.py` with the -d option, to clean NAV's database of references to non-existant sensor-related RRD files. Please report bugs at https://launchpad.net/nav/+filebug :-) Binary packages for Debian will be made available as soon as possible. The Debian package is maintained by Morten Werner Forsbring, on commission From UNINETT. Happy NAVing everyone! -- Morten Brekkevold UNINETT

2 1

Device with strange(?) snmp-implementation triggers bug in seeddb
by Ingeborg Hellemo 23 Feb '12

23 Feb '12

Nav version 3.10.2 Django debug is intentionally turned on We need to monitor uptime on our printers and add them to NAV in category OTHER. When we add snmp-enabled SafeCom controllers (<http://www.betasoft.co.uk/safeco m/safecom_ext_controller.htm>) seeddb barfs while talking snmp to the device with ValueConstraintError at /seeddb/netbox/edit/1691/ SingleValueConstraint for 'Version': value 0 not within allowed values: [1] Request Method: POST Request URL: https://nav.uit.no/seeddb/netbox/edit/1691/ Django Version: 1.3.1 Exception Type: ValueConstraintError Exception Value: SingleValueConstraint for 'Version': value 0 not within allowed values: [1] Exception Location: /usr/local/lib/python2.7/site-packages/pysnmp/asn1/constra ints.py in __call__, line 40 Python Executable: /usr/local/bin/python Python Version: 2.7.2 Python Path: ['/usr/local/lib/python2.7/site-packages/setuptools-0.6c11-py2.7.egg', '/usr/local/lib/python2.7/site-packages/Cheetah-2.4.4-py2.7-freebsd-8.2-RELEAS E-p5-amd64.egg', '/usr/local/lib/python2.7/site-packages/zope.interface-3.8.0-py2.7-freebsd-8.2 -RELEASE-p5-amd64.egg', '/usr/local/lib/python2.7/site-packages/pyasn1-0.1.2-py2.7.egg', '/usr/local/lib/python2.7/site-packages/python_ldap-2.4.7-py2.7-freebsd-8.2-RE LEASE-p5-amd64.egg', '/usr/local/nav/lib/python', '/usr/local/lib/python27.zip', '/usr/local/lib/python2.7', '/usr/local/lib/python2.7/plat-freebsd8', '/usr/local/lib/python2.7/lib-tk', '/usr/local/lib/python2.7/lib-old', '/usr/local/lib/python2.7/lib-dynload', '/usr/local/lib/python2.7/site-packages'] Traceback: File "/usr/local/lib/python2.7/site-packages/django/core/handlers/base.py" in get_response 111. response = callback(request, *callback_args, **callback_kwargs) File "/usr/local/nav/lib/python/nav/web/seeddb/page/netbox/edit.py" in netbox_edit 49. if netbox_form.is_valid(): File "/usr/local/lib/python2.7/site-packages/django/forms/forms.py" in is_valid 121. return self.is_bound and not bool(self.errors) File "/usr/local/lib/python2.7/site-packages/django/forms/forms.py" in _get_errors 112. self.full_clean() File "/usr/local/lib/python2.7/site-packages/django/forms/forms.py" in full_clean 268. self._clean_form() File "/usr/local/lib/python2.7/site-packages/django/forms/forms.py" in _clean_form 296. self.cleaned_data = self.clean() File "/usr/local/nav/lib/python/nav/web/seeddb/page/netbox/forms.py" in clean 81. self._check_ro_community(ip, ro_community, cat) File "/usr/local/nav/lib/python/nav/web/seeddb/page/netbox/forms.py" in _check_ro_community 106. version = self.get_snmp_version(ip, ro_community) File "/usr/local/nav/lib/python/nav/web/seeddb/page/netbox/forms.py" in get_snmp_version 135. snmp.get(sysobjectid) File "/usr/local/nav/lib/python/nav/Snmp/pysnmp_se.py" in get 99. rsp.berDecode(answer) File "/usr/local/lib/python2.7/site-packages/pysnmp/asn1/encoding/ber/base.py" in berDecode 296. input = self[key].berDecode(input) File "/usr/local/lib/python2.7/site-packages/pysnmp/asn1/encoding/ber/base.py" in berDecode 202. self._setRawAsn1Value(value) File "/usr/local/lib/python2.7/site-packages/pysnmp/asn1/base.py" in _setRawAsn1Value 169. self._subtype_constraint(value) File "/usr/local/lib/python2.7/site-packages/pysnmp/asn1/base.py" in _subtype_constraint 78. c( self, value ) File "/usr/local/lib/python2.7/site-packages/pysnmp/asn1/constraints.py" in __call__ 40. self.values.keys(), Exception Type: ValueConstraintError at /seeddb/netbox/edit/1691/ Exception Value: SingleValueConstraint for 'Version': value 0 not within allowed values: [1] It is quite possible that the SNMP-implementation on these devices are odd, but seeddb should be able to cope in a more elegant way. Attached is the output of snmpwalk of the device without any fancy flags. Let me know if you need more info. --Ingeborg -- Ingeborg Østrem Hellemo -- ingeborg.hellemo(a)uit.no Dep. of Information Technology --- Univ. of Tromsø

2 1

Announcement: NAV 3.10.2 released
by Morten Brekkevold 21 Feb '12

21 Feb '12

NAV 3.10.2 is now available for download at Launchpad: https://launchpad.net/nav/3.10/3.10.2 This maintenance release contains fixes for the following reported issues, as well as a few other minor tweaks: * LP#258298 (Service alerts aren't closed on service deletion) * LP#392022 (Incorrect IPv4 net address prefix link in Subnet matrix) * LP#744930 (vlan report for closed vlans is empty) * LP#744933 (IP range searches in radius accounting tool ignores timestamp) * LP#912210 (pping crashes when its PID is >= 32768) * LP#912219 (Network explorer incomplete domain names) * LP#920882 (moduleDown alerts reference affected module only as "$module") * LP#920886 (Status page doesn't show modules down) * LP#922566 (SQL syntax errors from getBoksMacs on PostgreSQL 9.1) * LP#922586 (Cisco 1900 switches cause getBoksMacs SNMP walks to go into infinite loops) * LP#922616 (report system behaves badly if accessed without a trailing slash in url) * LP#923641 (Fan outage on HP devices never reported) * LP#925928 (HP Virtual Connect Ethernet modules report crazy MAC addresses, making getBoksMacs spew SQL errors) * LP#925956 (link from organization report to prefix report crashes report page) * LP#928754 (Installing database on PostgreSQL 9 fails) Please report bugs at https://launchpad.net/nav/+filebug :-) Binary packages for Debian will be made available as soon as possible. The Debian package is maintained by Morten Werner Forsbring, on commission From UNINETT. Happy NAVing everyone! -- Morten Brekkevold UNINETT

2 1

Sanitizing table cam in the nav database
by Nik Mitev 14 Feb '12

14 Feb '12

Hello, I have created a pilot installation of NAV, currently handling 16 production switches. It seems that the cam table, holding the MAC addresses seen on the switches is growing very fast and holding large amounts of redundant information, in some cases up to 250 entries per MAC address. I am looking for ways to restrict the amount of history kept, as we only need to know which switch/port a MAC is on, rather than a full history of online/offline status changes. This can of course be done by scripts, I was wondering though is there any relevant built-in functionality already present? Thanks, Nik

2 1

Timezone problem
by Adrian Bucurica 05 Jan '12

05 Jan '12

Hello everyone, We've just started to test NAV and I have a strange problem with the timezone reported in NAV. It seems that NAV reports all operations using timezone GMT+1 (Western Europe) but on localhost we have configured a different timezone: diff -s /etc/localtime /usr/share/zoneinfo/`cat /etc/timezone` Files /etc/localtime and /usr/share/zoneinfo/America/Chicago are identical We are using Debian Squeeze 64-bit and NAV 3.10 installed from source. What am I missing? Regards, Adrian

2 2

Announcement: NAV 3.10.1 released
by Morten Brekkevold 05 Jan '12

05 Jan '12

NAV 3.10.1 is now available for download at Launchpad: https://launchpad.net/nav/3.10/3.10.1 This maintenance release contains fixes for the following reported issues, as well as a few other minor tweaks: * LP#903096 (Ampersand in organization id crashes ipdevinfo) * LP#904605 (netboxinfo subcat column links to a failing page) * LP#906763 (SyntaxError in powersupplywatch.py on Python < 2.6) * LP#906845 (Status on front page shows device on maintenance as down) * LP#906850 (Alert Profiles NoReverseMatch error under Django 1.3) * LP#907193 (COMMIT/ROLLBACK error after deleting device (Django 1.3)) * LP#907204 (seeddb crashes while adding an already existing switch) * LP#907741 (NAV 3.10 pping inaccurately reports multitudes of devices as down when pinging self) * LP#907772 (navtopology crashes with TypeError) * LP#910849 (ipdevpoll wastes time and I/O bandwidth with unnecessary SQL UPDATEs) * LP#910855 (navtopology doesn't avoid multiple instances) * LP#911684 (radius accounting log crashes when searching) * LP#911786 (servicemon stops sending events) Also, as Adrian Bucurica discovered, there may be issues with how NAV handles time unless you're in the Europe/Oslo (CET/CEST) time zone. nav.conf has been updated to reflect the availability of the TIME_ZONE option. Please report bugs at https://launchpad.net/nav/+filebug :-) Binary packages for Debian will be made available as soon as possible. The Debian package is maintained by Morten Werner Forsbring, on commission From UNINETT. Happy NAVing everyone! -- Morten Brekkevold UNINETT

1 0

nav 9.10 missing cricket summary info
by Tor Pretorius 02 Jan '12

02 Jan '12

Hi. I,m install "nav 3.10" Debian package version, on debian 6 (64bit) system I have installed the "nav 3.10" Debian package version, on debian 6 (64bit) VMware system everything seems to work and, apart from cricket summary All graphs are correct "Daily graph","Weekly graph" in the summary field displays only the time ? no data or graph ?? Is there anyone who has experienced the same ? Med vennlig hilsen / Best Regards Tor Pretorius

2 1

COMMIT/ROLLBACK error after deleting device
by Ingeborg Hellemo 20 Des '11

20 Des '11

When I delete a device I get an "Error: Transaction managed block ended with pending COMMIT/ROLLBACK" The device is deleted, but the error message (in red) is noisy and confusing. NAV 3.9.3 postgresql-client-8.4.8 postgresql-server-8.4.8_1 --Ingeborg -- Ingeborg Østrem Hellemo -- ingeborg.hellemo(a)uit.no Dep. of Information Technology --- Univ. of Tromsø

2 3

Ugly and confusing error messages in /alertprofiles/
by Ingeborg Hellemo 20 Des '11

20 Des '11

NAV 3.9.4 When editing filters and other items in Alert profiles we get several error messages, but the things we are trying to do is indeed saved. Is this a NAV issue or our version of Django? In Alert Profiles -> Alert addresses -> New address When I click "Save new" I get the following error, but when I go back to <https://nav.uit.no/alertprofiles/address/> I see that the address is saved. ---------- NoReverseMatch at /alertprofiles/address/save/ Reverse for 'alertprofiles-address-detail' with arguments '(None,)' and keyword arguments '{}' not found. Request Method: POST Request URL: https://nav.uit.no/alertprofiles/address/save/ Django Version: 1.3 Exception Type: NoReverseMatch Exception Value: Reverse for 'alertprofiles-address-detail' with arguments '(None,)' and keyword arguments '{}' not found. Exception Location: /usr/local/lib/python2.7/site-packages/django/core/urlreso lvers.py in reverse, line 337 Python Executable: /usr/local/bin/python Python Version: 2.7.2 Python Path: ['/usr/local/lib/python2.7/site-packages/setuptools-0.6c11-py2.7.egg', '/usr/local/lib/python2.7/site-packages/simplejson-2.1.6-py2.7-freebsd-8.2-REL EASE-amd64.egg', '/usr/local/lib/python2.7/site-packages/zope.interface-3.6.5-py2.7-freebsd-8.2 -RELEASE-amd64.egg', '/usr/local/lib/python2.7/site-packages/pyasn1-0.0.13b-py2.7.egg', '/usr/local/lib/python2.7/site-packages/Cheetah-2.4.4-py2.7-freebsd-8.2-RELEAS E-amd64.egg', '/usr/local/lib/python2.7/site-packages/pyasn1_modules-0.0.1a-py2.7.egg', '/usr/local/lib/python2.7/site-packages/python_ldap-2.4.3-py2.7-freebsd-8.2-RE LEASE-amd64.egg', '/usr/local/nav/lib/python', '/usr/local/lib/python27.zip', '/usr/local/lib/python2.7', '/usr/local/lib/python2.7/plat-freebsd8', '/usr/local/lib/python2.7/lib-tk', '/usr/local/lib/python2.7/lib-old', '/usr/local/lib/python2.7/lib-dynload', '/usr/local/lib/python2.7/site-packages'] ------- Similar error occurs when adding a new filter or a new filter group: NoReverseMatch at /alertprofiles/filters/save/ Reverse for 'alertprofiles-filters-detail' with arguments '(None,)' and keyword arguments '{}' not found. Request Method: POST Request URL: https://nav.uit.no/alertprofiles/filters/save/ Django Version: 1.3 Exception Type: NoReverseMatch Exception Value: Reverse for 'alertprofiles-filters-detail' with arguments '(None,)' and keyword arguments '{}' not found. Exception Location: /usr/local/lib/python2.7/site-packages/django/core/urlreso lvers.py in reverse, line 337 ------- NoReverseMatch at /alertprofiles/filter-groups/save/ Reverse for 'alertprofiles-filter_groups-detail' with arguments '(None,)' and keyword arguments '{}' not found. Request Method: POST Request URL: https://nav.uit.no/alertprofiles/filter-groups/save/ Django Version: 1.3 Exception Type: NoReverseMatch Exception Value: Reverse for 'alertprofiles-filter_groups-detail' with arguments '(None,)' and keyword arguments '{}' not found. Exception Location: /usr/local/lib/python2.7/site-packages/django/core/urlreso lvers.py in reverse, line 337 Python Executable: /usr/local/bin/python --Ingeborg -- Ingeborg Østrem Hellemo -- ingeborg.hellemo(a)uit.no Dep. of Information Technology --- Univ. of Tromsø

2 2

Issues with status-page and box down
by Ingeborg Hellemo 20 Des '11

20 Des '11

2 issues really: At the moment I have 3 boxes down, one of which is on maintenance. 1. The "Status now" box on the NAV front page shows also the box which is on maintenance as down. Is this a bug or a feature? NAV pre 3.9 was silent about boxes on maintenance on the front page. 2. https://nav.example.com/status/ shows correctly one box as on maintenance, but the "IP devices down" is empty! I have to click on the history-tag to find my two boxes (which went dows yesterday, but are still down). --Ingeborg -- Ingeborg Østrem Hellemo -- ingeborg.hellemo(a)uit.no Dep. of Information Technology --- Univ. of Tromsø

2 1

Bug in reports, subcategories
by Ingeborg Hellemo 20 Des '11

20 Des '11

We use subcategories extensively. There is a bug in the report generator related to subcats. Howto reproduce: * Goto Home > Report > Server (or some other category with subcategories). * Click on subcats for a server which belongs to a subcategory. You are now in <https://nav.uit.no/report/netboxinfo?netboxid=(#ofnetbox)>. * Click on the name of a subcategory * You will now enter https://nav.uit.no/report/netboxinfo?category=(Name of subcat)> Lo and behold: Netboxinfo Configuration error! The report generator is not able to do such things. column "category" does not exist LINE 1: ...IN netboxcategory USING (netboxid)) AS foo WHERE category =... ^ -- Ingeborg Østrem Hellemo -- ingeborg.hellemo(a)uit.no Dep. of Information Technology --- Univ. of Tromsø

3 3

Announcement: NAV 3.10.0 and 3.9.4 released
by Morten Brekkevold 16 Des '11

16 Des '11

The newest feature release of NAV, version 3.10.0, is now available for download at Launchpad: https://launchpad.net/nav/3.10/3.10.0 The last bugfix release of the 3.9 series is also available at https://launchpad.net/nav/3.9/3.9.4 Both releases include fixes for the following issues: * LP#898992 (ipdevinfo displays all ports as blocking whereas stpblock report confirms that they're not) * LP#900723 (No SW version on Cisco 4506E L3 switch) * LP#900779 (smsd crashes when discarding non-dispatchable messages with non- ASCII chars) * LP#901623 (mcc does not update maximum threshold value for interfaces) * LP#903128 (servicemon/pping opens a new connection on any database error) * LP#903681 (room report should include position) * LP#904178 (smsd removes permanently failed dispatchers even when it should ignore permanent failures) The 3.10.0 release also fixes these issues: * LP#744940 (geomap should default to a sensible start map) * LP#894727 (No server software versions since NAV 3.5) The 3.10.0 release adds the following user-visible features and improvements: * VLAN subtopology detection has been rewritten to Python. The old networkDiscovery Java program is now deprecated. * Alerts when SNMP agents stop responding. * Alerts on power failure SNMP traps from UPS units. UPS-MIB (RFC 1628) and proprietary MIBs from Eaton Corporation, APC and MGE are supported. * Configurable port link status monitoring and alerting in ipdevpoll, independent of SNMP trap configuration. * Alerts on redundant power supply and fan failures on Cisco and HP devices. * Statistics from all environment sensors (such as temperature, humidity, light, sound, etc.) detectable through either ENTITY-SENSOR-MIB (RFC 3433), CISCO-ENVMON-MIB or IT-WATCHDOGS-MIB (IT Watchdogs WeatherGoose) are now collected via Cricket. * pping can now ping IPv6 hosts. * ipdevinfo and Machine Tracker now perform bulk DNS lookups in parallel, improving page load times when DNS is slow. Don't forget to check out the release notes before/during/after upgrading to NAV 3.10. Please report bugs at https://launchpad.net/nav/+filebug :-) Binary packages for Debian will be made available as soon as possible. The Debian package is maintained by Morten Werner Forsbring, on commission From UNINETT. Happy NAVing everyone! -- Morten Brekkevold UNINETT

1 0

Announcement: NAV 3.10.0 and 3.9.4 released
by Morten Brekkevold 16 Des '11

16 Des '11

The newest feature release of NAV, version 3.10.0, is now available for download at Launchpad: https://launchpad.net/nav/3.10/3.10.0 The last bugfix release of the 3.9 series is also available at https://launchpad.net/nav/3.9/3.9.4 Both releases include fixes for the following issues: * LP#898992 (ipdevinfo displays all ports as blocking whereas stpblock report confirms that they're not) * LP#900723 (No SW version on Cisco 4506E L3 switch) * LP#900779 (smsd crashes when discarding non-dispatchable messages with non- ASCII chars) * LP#901623 (mcc does not update maximum threshold value for interfaces) * LP#903128 (servicemon/pping opens a new connection on any database error) * LP#903681 (room report should include position) * LP#904178 (smsd removes permanently failed dispatchers even when it should ignore permanent failures) The 3.10.0 release also fixes these issues: * LP#744940 (geomap should default to a sensible start map) * LP#894727 (No server software versions since NAV 3.5) The 3.10.0 release adds the following user-visible features and improvements: * VLAN subtopology detection has been rewritten to Python. The old networkDiscovery Java program is now deprecated. * Alerts when SNMP agents stop responding. * Alerts on power failure SNMP traps from UPS units. UPS-MIB (RFC 1628) and proprietary MIBs from Eaton Corporation, APC and MGE are supported. * Configurable port link status monitoring and alerting in ipdevpoll, independent of SNMP trap configuration. * Alerts on redundant power supply and fan failures on Cisco and HP devices. * Statistics from all environment sensors (such as temperature, humidity, light, sound, etc.) detectable through either ENTITY-SENSOR-MIB (RFC 3433), CISCO-ENVMON-MIB or IT-WATCHDOGS-MIB (IT Watchdogs WeatherGoose) are now collected via Cricket. * pping can now ping IPv6 hosts. * ipdevinfo and Machine Tracker now perform bulk DNS lookups in parallel, improving page load times when DNS is slow. Don't forget to check out the release notes before/during/after upgrading to NAV 3.10. Please report bugs at https://launchpad.net/nav/+filebug :-) Binary packages for Debian will be made available as soon as possible. The Debian package is maintained by Morten Werner Forsbring, on commission From UNINETT. Happy NAVing everyone! -- Morten Brekkevold UNINETT

1 0

Problems after upgrade to 3.9.3
by Sigurd Mytting 09 Des '11

09 Des '11

Hi, I've run into trouble after upgrading to 3.9.3 via apt-source, system is debian 6.0.3, this was not a problem with 3.9.2. First the message during upgrade: Setting up nav (2+3.9.3-1) ... Installing new version of config file /etc/nav/sortedStats.conf ... Installing new version of config file /etc/nav/smsd.conf ... Installing new version of config file /etc/nav/report/report.conf ... Traceback (most recent call last): File "/usr/share/doc/nav/sql/syncdb.py", line 463, in <module> main() File "/usr/share/doc/nav/sql/syncdb.py", line 44, in main sync.synchronize() File "/usr/share/doc/nav/sql/syncdb.py", line 220, in synchronize self.apply_changes() File "/usr/share/doc/nav/sql/syncdb.py", line 305, in apply_changes self.apply_change_script(version, script) File "/usr/share/doc/nav/sql/syncdb.py", line 326, in apply_change_script self.execute_sql_file(script) File "/usr/share/doc/nav/sql/syncdb.py", line 352, in execute_sql_file self.cursor.execute(sql) psycopg2.extensions.QueryCanceledError: canceling statement due to statement timeout CONTEXT: SQL statement "DELETE FROM ONLY "manage"."rrd_datasource" WHERE $1 OPERATOR(pg_catalog.=) "rrd_fileid"" and if I try adding a new device I get: Something went wrong Something went wrong while processing your request. Please try again later. If the problems persists, contact your system administrator and/or report a bug on NAV bugtracker. And an error when trying to delete a device: Error: canceling statement due to statement timeout CONTEXT: SQL statement "UPDATE ONLY "manage"."cam" SET "netboxid" = NULL WHERE $1 OPERATOR(pg_catalog.=) "netboxid"" When digging into the postgres-log I find (everything from a database restart with two delete attempts): 2011-12-07 10:11:04 CET LOG: database system was shut down at 2011-12-07 10:10:55 CET 2011-12-07 10:11:04 CET LOG: database system is ready to accept connections 2011-12-07 10:11:04 CET LOG: autovacuum launcher started 2011-12-07 10:11:05 CET LOG: incomplete startup packet 2011-12-07 10:12:00 CET ERROR: canceling statement due to statement timeout 2011-12-07 10:12:00 CET CONTEXT: SQL statement "UPDATE ONLY "manage"."cam" SET "netboxid" = NULL WHERE $1 OPERATOR(pg_catalog.=) "netboxid"" 2011-12-07 10:12:00 CET STATEMENT: DELETE FROM "netbox" WHERE "netboxid" IN (162) 2011-12-07 10:15:01 CET LOG: unexpected EOF on client connection 2011-12-07 10:18:22 CET ERROR: canceling statement due to statement timeout 2011-12-07 10:18:22 CET CONTEXT: SQL statement "UPDATE ONLY "manage"."cam" SET "netboxid" = NULL WHERE $1 OPERATOR(pg_catalog.=) "netboxid"" 2011-12-07 10:18:22 CET STATEMENT: DELETE FROM "netbox" WHERE "netboxid" IN (162) 2011-12-07 10:20:02 CET LOG: unexpected EOF on client connection Anyone having any idea on what's going on? Postgresql has been tuned a bit with allowing 1000 simultaneous connections, but should otherwise be standard. Best regards, -Sigurd

2 4

Announcement: NAV 3.9.3 released
by Morten Brekkevold 05 Des '11

05 Des '11

NAV version 3.9.3 is now available for download at Launchpad: https://launchpad.net/nav/3.9/3.9.3 This maintenance release includes the following: Improvements: * Using the `-d` option with cleanrrds.py will now also remove references to stale availability and response time RRD files from NAV's database. This should help against the "Availability: N/A" issue seen by some in ipdevinfo, whereas bugfixes to pping should prevent it from creating new entries while leaving stale ones in the future. Bugfixes: * LP#586334 (HTTPS service checker doesn't work with Python 2.6) * LP#744958 (ranked stats config file should default to mbit/s) * LP#888056 (MacWatch GUI crashes if the input of the MAC address is invalid) * LP#891542 (Add option to make smsd ignore "permanent" dispatch errors) * LP#891568 (logengine cron mail complains: global name 'ENOENT' is not defined) * LP#893591 (pping crashes when rrd files already exist) * LP#897175 (ipdevpoll stops polling a device whose type is yet unregistered) * LP#897194 (NameError when adding IP device in SeedDB) * LP#898128 (Trying to seed - when going to USAGE crash) Please report bugs at https://launchpad.net/nav/+filebug :-) A binary package for Debian will be made available as soon as possible. The Debian package is maintained by Morten Werner Forsbring, on commission From UNINETT. Happy NAVing everyone! -- Morten Brekkevold UNINETT

2 1

***SPAM***End of year Online Bonanza...
by Europe Royal 01 Des '11

01 Des '11

Europe Royal Online Program Amsterdam - Holland. Tel: 0031-685242542 Fax: 0031-847508652 online1(a)europe.com Ref: ER/07533 Ticket Number: 025613-ING. Are you the owner of this email address? Congratulations! Your email have been officially selected as a winner from Europe Royal Online. You are hereby authorised for claim with your email attached to winning ticket Number: 025613-ING for the 2nd category winning prize of Seven Hundred and Fifty Thousand Euros and a Dell Latitude Laptop. Contact Notarization Officer: Mr Laurens Nijenhuis Email: notarization(a)winning.com with required informations below: Full Names Occupation: Address: Country: Telephone: Ticket Number: 025613-ING. Regards, Wotide Mo Sope. Europe Royal. © 2011 Europe Royal. All rights reserved. Terms of use. Privacy Statement.

1 0

Re: Question for NAV Users with Cisco 3750 Stacks
by Borge Brunes 21 Nov '11

21 Nov '11

gwc2004(a)gmail.com said: > I'm looking for some input from anyone using NAV with Cisco 3750 switch > stacks. If you have a stack of 2 or more 3750's and all the L2/L3 interfaces > are being properly pulled from it by NAV, then would you mind sharing what > version of IOS you are using? [cut] Seems to be working fine with 12.2(55)SE4 (c3750-ipbasek9-mz.122-55.SE4.bin) regards, -- Borge Brunes, Computer Center, University of Tromso, Norway http://www.cc.uit.no/~borge/ | http://www.freebsd.org

2 1

Announcement: NAV 3.9.2 released
by Morten Brekkevold 21 Nov '11

21 Nov '11

Unfortunately, there were no releases while I was on leave, so it's time to get back on track: NAV version 3.9.2 is now available for download at Launchpad: https://launchpad.net/nav/3.9/3.9.2 This release includes bugfixes for the following issues: * LP#300708 (Improve the link up/down trap plugin to include description) * LP#338696 (Postgresql service checker is actually a port checker) * LP#787957 (No trunk information on H3C switches) * LP#802408 (Lowercase cricket rrd file not found when sysname has uppercase letters) * LP#854696 (Adding a new filter or new filter group in Alert Profiles fails) * LP#858055 (Creating a new maintenance task with ÆØÅ in description fails) * LP#862208 (No cricket stats for directories "routers" and "switches" in cricket) * LP#865292 (HTTP service checker ignores query string) * LP#890190 (linkstate trap handler does not work) * LP#890607 (Set supervisor SW version as chassis SW version on Cisco devices) * LP#891090 (pping creates multiple RRD files for same data, causing ipdevinfo to display availability as N/A) Please report bugs at https://launchpad.net/nav/+filebug :-) A binary package for Debian will be made available as soon as possible. The Debian package is maintained by Morten Werner Forsbring, on commission From UNINETT. Happy NAVing everyone! -- Morten Brekkevold UNINETT

2 1

Differences in SNMP results between versions
by Seb Rupik 17 Nov '11

17 Nov '11

Hi all, I have been tasked with creating a new NAV (3.9.1) install. All appears to be fine until I compare it against the previous old (3.5.4) installation. The majoirty of our switches are Cisco 3750's nearly all stacked, but the new install doesn't seem to acknowledge this under 'IP Device Info' where the 'Modules' field shows '0', but the 'switch port status' table shows all interfaces spanning the stack. On the old install the 'Modules' field has the correct number and the 'Switch port status' shows the right number of separate modules. Looking under: 'Report-> Vendors -> Cisco' confirms that the new install is receiving less SNMP OIDs per switch stack; typically 75. Where as the old install is showing between 88-90 for the same stacks. Also in some cases the new install is not showing any returns under #mod, #swp, #gwp and #prefixes, where is does on the old install. Both installs are running libsnmp1.4-java; the old 1.4-5, and the new install 1.4.2-2. Would that account for the differences? What's the best way to test the two installs side by side in an output based comparison? Many thanks, seb.

4 8

Question for NAV Users with Cisco 3750 Stacks
by Greg Cooper 17 Nov '11

17 Nov '11

Hi, All. I'm looking for some input from anyone using NAV with Cisco 3750 switch stacks. If you have a stack of 2 or more 3750's and all the L2/L3 interfaces are being properly pulled from it by NAV, then would you mind sharing what version of IOS you are using? I think I may be running into an SNMP issue with the particular version of IOS I'm on. I get timeouts when querying the 3750 via SNMP. I can do an snmpwalk from the NAV server to the device, and it runs for a while, but it will sometimes time out. Thanks! Greg

4 3

NAV reference committee
by Morten Brekkevold 15 Nov '11

15 Nov '11

Hello all, I just wanted to say a few words about the NAV reference committee, which was established just last week. Those of you who aren't one of UNINETT's NREN customers in Norway may or may not be aware that NAV is one of the many free software offerings to our customers. We even operate remote NAV servers as a service for ~30 of our smaller customers. We try to concentrate our development efforts to meet the demands of our customers in higher education (HE), and since this is a free software project we also cooperate with some of our HE customers, who regularly contribute to and maintain parts of NAV (some by their own volition, others commissioned and paid by us). It is not always clear what the customer wants. Some of our customers are very vocal about what they want, others keep quiet, maybe spilling their guts in the occasional face to face meeting (or maybe not even then). So we've revived a several years old idea to establish a kind of committee of reference for NAV development. This committee consists of representatives from our HE customers, and would be responsible for collecting, massaging, filtering and prioritizing wishes for further NAV development from the HE community. This committee was established on Thursday 10th November here in Trondheim, and consists of the following representatives: * Vidar Faltinsen, UNINETT (committee leader/secretary) * Morten Brekkevold, UNINETT (lead NAV developer) * Gro-Anita Vindheim, Norwegian University of Science and Technology * Børge Brunes, University of Tromsø * Jan Sigurd Refvik, University of Oslo * Rune Kittelsen, University of Agder * Peder Sefland, Volda University College The committee will publish its work on the web at [1], were you can already find the minutes from the inaugural meeting. As we're the Norwegian NREN, the committee's working language will be Norwegian - if you don't speak Norwegian, you may want to try using Google Translate or similar services to translate those pages if you want to see the details of what's going on (although automatic translation may confuse more than it helps ;-) ). Nevertheless, the results of the committee's input will be visible in how we prioritize bug reports and blueprints on our Launchpad project page [2]. Have a great day! [1] https://ow.feide.no/gigacampus:nav-ref [2] https://launchpad.net/nav -- Morten Brekkevold UNINETT

1 0

Twisted SNMP Patch Question
by Greg Cooper 15 Nov '11

15 Nov '11

Hello, I have a question about this from the NOTES: The latest TwistedSNMP version (0.3.13) contains a bug that manifests in table retrieval operations. Timeouts and retries aren't handled properly, and this may cause slow or otherwise busy devices to be bombarded with requests from NAV. The `contrib/patches` directory contains a patch for TwistedSNMP that solves this problem. The patch has been submitted upstream, but not yet accepted into a new release. Alternatively, you can install `pynetsnmp` for improved performance. I think I am running into the Twisted SNMP timeout issues talked about here. So my question is this: When it says, "Alternatively, you can install pynetsnmp for improved performance" does that mean that instead of patching TwistedSNMP, i can just do an apt-get install pynetsnmp and then I don't have to worry about the Twisted SNMP library's problems? If so, do I have to uninstall twisted SNMP? If I still have to patch Twisted, then what is the best way for me to go from using the standard debian packaged TwistedSNMP to using the patched one I build from scratch? I don't want to be stuck where I have both installed, but it is still using the old version. Thanks in advance, Greg

2 1

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

Nav-users