April 2022 - Nav-users - lister.unit.no

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

nav 5.3 - alertengine not sending alert / blacklisted and connection timeout (error 110)
by Andrea Verni 26 Aug '22

26 Aug '22

Hi, I'm running NAV 5.3 and have issue with alertengine and email notifications. Email seems to remain stuck in the queue until I force a reboot of the VM. The error message I see in /var/log/nav/alertengine.log is: 2022-03-08 08:35:10,707 [WARNING] [nav.alertengine.alertaddress.send] Not sending alert 5824 ****** as handler Email is blacklisted: [Errno 110] Connection timed out 2022-03-08 08:35:10,716 [WARNING] [nav.alertengine.alertaddress.send] Not sending alert 5825 to ****** as handler Email is blacklisted: [Errno 110] Connection timed out 2022-03-08 08:35:10,720 [INFO] [nav.alertengine.check_alerts] 0 new alert(s), sent 0 alert(s), 910 queued alert(s), 0 alert(s) deleted, 910 failed send(s), 0 ignored However, by running a tcpdump I do not see any outbound/inbound connection to the configured email server. After the reboot it seems messages are going through (and I do see outbound connections to the configured mail server) 2022-03-08 08:39:38,277 [INFO] [nav.alertengine.alertaddress.send] alert 5367 sent by Email to ****** due to immediately subscription 2 2022-03-08 08:39:38,500 [INFO] [nav.alertengine.alertaddress.send] alert 5320 sent by Email to ****** due to immediately subscription 2 2022-03-08 08:41:34,963 [INFO] [nav.alertengine.check_alerts] 0 new alert(s), sent 910 alert(s), 0 queued alert(s), 0 alert(s) deleted, 0 failed send(s), 0 ignored I'm running Debian 10 and not have iptables/fail2ban on it. Any help? Thanks! Andrea

2 3

Re: wrong Port configuration status for juniper device if port manually disabled
by FOUR Ludovic (EXT) 06 Apr '22

06 Apr '22

Hello, I just forgot to reply to all, my bad sorry I leave all the comments below I took a look into ipdevpoll.log When I'm updating a port, there is new [INFO schedule.netboxjobscheduler] line into ipdevpoll log, means that the scheduler is doing fine. I still have the same issue with portadmin enabled checkbox : if you uncheck enabled box, save, then reload page, the checkbox goes back to checked, and remains in this state. - but it updates the interface - (disabled) I've made some setup to portadmin.conf, and changed link_edit = false (better not cut the tree branch where you are sitting on) but I don't think it's related to. Regards, Ludovic ----- Mail original ----- De: "Morten Brekkevold" <morten.brekkevold(a)sikt.no> À: "FOUR Ludovic / PHA" <ludovic.four(a)unistra.fr> Envoyé: Vendredi 1 Avril 2022 14:39:19 Objet: Re: wrong Port configuration status for juniper device if port manually disabled On Thu, 31 Mar 2022 09:24:46 +0200 (CEST) "FOUR Ludovic (EXT)" <ludovic.four(a)unistra.fr> wrote: > I only disable the physical port in this case. Hi Ludovic, did you intentionally leave the mailing list out of your reply? > I did that, but there's no update even when I close Chrome or firefox > (did some tests on both). I tried by clearing firefox/chrome cache > too. The interface status still remains checked (enable) in portadmin > web page. Then I need to do some testing on our own equipment in an attempt to reproduce this. I'll have to get back to you. > I also have some update problem with aggregated interfaces (aeX) > created with Junos Console. NAV can detect the aeX interface when I > create it. But still remains when I remove it. I can't see the > physical interfaces that were previously members of the aggregated > interface in the physical ports list anymore. What ports NAV knows about is only updated by the inventory job, which runs every 6 hours. However, ipdevpoll does show some restraint from deleting any interface as soon as it appears missing (some devices can be wonky) - it actually marks it internally with a "missing since" timestamp, and removes it only when it remains missing after certain amount of time. I don't recall the exact amount, but I'm guessing 24 hours. > Maybe a SSL cache issue on server side ? > I'm using standard apache mod ssl settings > SSLSessionCache shmcb:${APACHE_RUN_DIR}/ssl_scache(512000) > SSLSessionCacheTimeout 300 No, this is unrelated to content caching. -- Sincerely, Morten Brekkevold Sikt – Norwegian Agency for Shared Services in Education and Research

2 1