Nav-users November 2019

nav-users@lister.sikt.no

4 participants
5 discussions

Status Check on Dell N2048P (PoE)
by Vinsonnaud Ludovic 19 Feb '24

19 Feb '24

Hello, I've check my logs on ipdevpoll and I found this : 2019-01-28 17:37:28,698 [ERROR jobs.jobhandler] [statuscheck PAL-SW-R1-13.res.iogs] Caught exception during save. Last manager = DefaultManager(<class 'nav.ipdevpoll.shadows.POEPort'>, 'ContainerRepository'(...)). Last model = <class 'nav.ipdevpoll.shadows.POEPort'> Traceback (most recent call last): File "/usr/lib/python2.7/dist-packages/nav/ipdevpoll/jobs.py", line 442, in _perform_save manager.save() File "/usr/lib/python2.7/dist-packages/nav/ipdevpoll/storage.py", line 87, in save obj.save(self.containers) File "/usr/lib/python2.7/dist-packages/nav/ipdevpoll/storage.py", line 476, in save obj.save() File "/usr/lib/python2.7/dist-packages/django/db/models/base.py", line 589, in save force_update=force_update, update_fields=update_fields) File "/usr/lib/python2.7/dist-packages/django/db/models/base.py", line 617, in save_base updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields) File "/usr/lib/python2.7/dist-packages/django/db/models/base.py", line 698, in _save_table result = self._do_insert(cls._base_manager, using, fields, update_pk, raw) File "/usr/lib/python2.7/dist-packages/django/db/models/base.py", line 731, in _do_insert using=using, raw=raw) File "/usr/lib/python2.7/dist-packages/django/db/models/manager.py", line 92, in manager_method return getattr(self.get_queryset(), name)(*args, **kwargs) File "/usr/lib/python2.7/dist-packages/django/db/models/query.py", line 921, in _insert return query.get_compiler(using=using).execute_sql(return_id) File "/usr/lib/python2.7/dist-packages/django/db/models/sql/compiler.py", line 921, in execute_sql cursor.execute(sql, params) File "/usr/lib/python2.7/dist-packages/django/db/backends/utils.py", line 65, in execute return self.cursor.execute(sql, params) File "/usr/lib/python2.7/dist-packages/django/db/utils.py", line 94, in __exit__ six.reraise(dj_exc_type, dj_exc_value, traceback) File "/usr/lib/python2.7/dist-packages/django/db/backends/utils.py", line 65, in execute return self.cursor.execute(sql, params) IntegrityError: ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne « classification » DETAIL: La ligne en échec contient (599034, 49, 66, null, 34, t, 2, 4, null) 2019-01-28 17:37:28,701 [ERROR jobs.jobhandler] [statuscheck PAL-SW-R1-13.res.iogs] Job 'statuscheck' for PAL-SW-R1-13.res.iogs aborted: Job aborted due to save failure (cause=IntegrityError('ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne \xc2\xab classification \xc2\xbb\nDETAIL: La ligne en \xc3\xa9chec contient (599034, 49, 66, null, 34, t, 2, 4, null)\n',)) 2019-01-28 17:37:28,703 [INFO schedule.netboxjobscheduler] [statuscheck PAL-SW-R1-13.res.iogs] statuscheck for PAL-SW-R1-13.res.iogs failed in 0:00:14.603465. next run in 0:04:59.999955. It seems it doesn't like the PoE on my Dell N2048P because of a NULL value in "classification" column. Do you have an idea ? Regards -- Cordialement, IOGS Logo <https://www.institutoptique.fr> *Ludovic Vinsonnaud * - Ingénieur Réseau basé à Bordeaux, bureau F108 (IOA, Rue François Mitterrand, 33400 Talence) *Institut Optique Graduate School* 2 Avenue Augustin Fresnel - 91127 PALAISEAU Cedex Tel. +33 5 57 01 71 52 - Mob. +33 6 08 08 41 05

5 16

NAV with Cisco 3850
by Mischa Diehm 15 Sep '23

15 Sep '23

Hi, we have a 3850 Stack with 3x ES-C3850-48T-S and 5x WS-C3850-12X48U. When we try to PortAdmin and edit a Port we get (see also attached Jpg): „IP device found but has no type“ Any ideas? Cheers, Mischa -- Mischa Diehm | Network Team (NINS) UniBasel | IT-Services (ITS) Klingebergstr. 70 | CH-4056 Basel Tel. +41 61 267 1574 | https://its.unibas.ch

4 4

Upgrade Debian to Buster and NAV to 4.9.8
by René Romijn 02 Dec '19

02 Dec '19

Hi, We did an upgrade to a new VM, we installed Debian Buster and we installed NAV 4.9.8. After that we did a restore of the postgress db with navsyncdb, and we also restored the /var/lib/graphite directory to have the history of the graphs. But now if i reboot the new NAV server, the graphs are resetted tot he point we did the restore. In the console log we see this error: 16/09/2019 08:02:28 :: Unhandled Error Traceback (most recent call last): File "/usr/lib/python3/dist-packages/twisted/python/threadpool.py", line 250, in inContext result = inContext.theWork() File "/usr/lib/python3/dist-packages/twisted/python/threadpool.py", line 266, in <lambda> inContext.theWork = lambda: context.call(ctx, func, *args, **kw) File "/usr/lib/python3/dist-packages/twisted/python/context.py", line 122, in callWithContext return self.currentContext().callWithContext(ctx, func, *args, **kw) File "/usr/lib/python3/dist-packages/twisted/python/context.py", line 85, in callWithContext return func(*args,**kw) --- <exception caught here> --- File "/usr/lib/python3/dist-packages/carbon/writer.py", line 189, in writeForever writeCachedDataPoints() File "/usr/lib/python3/dist-packages/carbon/writer.py", line 98, in writeCachedDataPoints (metric, datapoints) = cache.drain_metric() File "/usr/lib/python3/dist-packages/carbon/cache.py", line 187, in drain_metric metric = self.strategy.choose_item() File "/usr/lib/python3/dist-packages/carbon/cache.py", line 116, in choose_item return next(self.queue) builtins.StopIteration: Is this easy to fix? Kind regards, René.

2 11

Downgrade back to 4.9.8?
by Steve Kersley 14 Nov '19

14 Nov '19

Afternoon all, Is there a way to downgrade a Nav install to 4.9.8? Or will I need to blow away the database and start from scratch (no huge deal to be honest). Confession: I'm running it on Ubuntu rather than the recommended Debian. It got upgraded to 5.0.0, but as the Ubuntu LTS releases don't have a version of graphite-web that works with wsgi-python3 it's become an either/or, and I use graphite for storing other metrics as well as those from Nav. On attempting to pin the older version of Nav, it's failing to install because the database update script failed. Which I presume is because it had already upgraded the database for 5.0.0. I'm also toying after this to look at options of having Nav (and graphite and other services on this machine) as Docker containers simply to avoid version clashes in future. I see that Docker is listed as experimental, are there any particular issues to be aware of? Steve.

2 1

Announcement: NAV 5.0.0 released
by Morten Brekkevold 08 Nov '19

08 Nov '19

The first feature release of the 5.0 series of NAV is now out! The source code is available for download at GitHub [1]. New packages for Debian 9/10 (Stretch/Buster) are available in our APT repository [2] as usual. Please also be extra aware of config file changes. Look out for `*.dpkg-dist` files in /etc/nav and make sure to update your running config. The virtual appliance will be updated shortly. Deprecation warning =================== Python 2 reaches its end-of-life on **January 1, 2020**. NAV 5.0 therefore moves to Python 3, and as such, you will need at least Python 3.5 to run NAV. Most of NAV will still run on Python 2 as of the 5.0 release, but from this point, Python 2 will be deprecated and we will start removing code that exists solely to keep compatibility with Python 2. Changes ======= User-visible features and improvements: * #1793 (Add maintenance filter option to netbox API endpoint) + #1995 (Add maintenance filter to Netbox API endpoint) * #1859 (Improve portadmin support for dot1x) * #1905 (Add support for alcatel DDM-sensors) * #1908 (Add display widget for binary/boolean sensors to "racks") * #1919 (Add support for external sensors from newer Watchdog products) + #1926 (Add support for most external sensors on newer watchdog products) * #1930 (Refactor IT-WATCHDOGS-MIB MibRetriever implementations) * #1943 (Improve support for boolean sensors in racks) * #1947 (Management profiles) * #1969 (Store local chassis ids from LLDP-MIB and use for neighbor lookups) * #1970 (Add API for management profiles) * #1971 (Provide option to automatically enable CDP on voice ports) + #1974 (enabling CDP when a voice port is set using portadmin) * #1987 (Refactor power supply and fan monitoring functionality) * #1988 (Add status monitoring for Juniper PSUs and FANs) * #1989 (Collect optical sensor measurements from Coriant Groove devices) * #1998 (Remove support for alert dispatching over Jabber) * #2002 (Refactor installation documentation.) * #2005 (Export stream of serialized alerts from the event engine) * #2007 (Support REMOTE_USER header for web authentication) * #2008 (Add more database stats to Watchdog's "NAV by the numbers") Fixed GitHub issues in this release: * #1978 (Netmap layer 2 traffic data requests to Graphite are too slow and too large) * #1979 (Location alerts widget crashes intermittently) * #1980 (Using the wrong Radius dictionary file can cause servicemon to eat all available system memory and hang) * #1984 (Blank sysnames should not be allowed) + #1985 (Disallow blank sysnames) * #1990 (Make type changes immediately when unknown types are encountered) * #2004 ([BUG] Interface browser shows wrong "last used" date) * #2009 (Ensure rooms require a location attribute also in the SQL schema) Please see the release notes [3] for more details. Happy NAVing everyone! Links ===== [1] https://github.com/UNINETT/nav/releases [2] https://nav.uninett.no/install-instructions/#debian [3] https://nav.uninett.no/doc/latest/release-notes.html#nav-5.0 -- Sincerely, Morten Brekkevold Uninett

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 November 2019