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
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
The fourth maintenance release of the 5.1 series of NAV is now out!
The source code is available for download at GitHub [1].
A new package for Debian 10 (Buster) is available in our APT repository
[2] as usual. Packages for Debian 9 (Stretch) have been discontinued.
Please 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.
Changes
=======
Fixed GitHub issues in this release:
* #2281 ([BUG] Saving alert permissions crashes Alert Profiles)
* #2282 (PortAdmin SNMP error handling is broken in several ways)
* #2284 ([BUG] IP device interfaces don't get updated with speed
information)
* #2285 (Extract Cisco PoE port mapping method)
* #2288 (Disable the PortAdmin "Enable" checkbox for interfaces that
aren't editable)
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.readthedocs.io/en/latest/release-notes.html#nav-5-1
--
Sincerely,
Morten Brekkevold
Uninett
The initial feature release of the 5.1 series of NAV is now out!
The source code is available for download at GitHub [1].
A new package for Debian 10 (Buster) is available in our APT repository
[2] as usual. Packages for Debian 9 (Stretch) have been discontinued.
Please 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.
Changes
=======
User-visible features and improvements:
* #2021 (Add SeedDB action to clone netboxes and rooms)
* #2051 (Link to affected devices in Management profile)
* #2128 (Add device filtering options to ipdevpoll and pping, to
enable support for horizontal scaling and distributed
monitoring)
* #2175 (Implement NAPALM management profiles and connectivity)
* #2185 (Modernize the type dumping script and make it available as an
installable script for end user use)
* #2204 (Add support for configuring Juniper switch ports in
PortAdmin)
- #2173 (Clean up PortAdmin ManagementHandler interface)
- #2112 (Refactor PortAdmin's SNMP back-end classes and factories)
- #2115 (Refactor portadmin configuration parsing bits)
- #2121 (Use nav.config.NAVConfigParser for PortAdmin configuration)
- #2205 (Adapt Portadmin UI workflow to meet needs of multiple
backend protocols)
Fixed GitHub issues in this release:
* #2078 ([BUG] NAV daemons are unnecessarily run as root)
* #2103 (Support Django 2.2)
* #2139 ([BUG] fanState and psuState e-mail alerts say "no message
template is defined")
* #2141 (Work around lack of entity names when collecting sensors from
Arista devices)
* #2174 ([BUG] PortAdmin never issues a "write mem" operation when
editing trunks)
* #2190 ([BUG] Regression - mysql service check does not work)
* #2197 ([BUG] Bottom part of room images are obscured by image
caption)
* #2198 ([BUG] CSV export from Netbox interfaces in Room view produce
wrong filename and content.)
* #2199 (Make servicemon HttpChecker use the port number from the URL,
if present)
* #2207 (Netbox reference is not passed to customization template for
the ipdevinfo "What if" tab)
* #2213 ([BUG] NAV does not import room position)
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.1
--
Sincerely,
Morten Brekkevold
Uninett