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
NAV 5.1.2
I had to upgrade the OS on my NAV-box, and hence all the software depending on
libraries.
After this I have wsgi throwing errors on me. Not all the time. Users local to
NAV can log in just fine, but users who authenticate via ldap gets the error.
I have tried to reinstall psycopg2. I have also switched from installing
mod_wsgi from an OS-package to using pip
Apache/2.4.51 (FreeBSD) OpenSSL/1.1.1l mod_wsgi/4.9.0 Python/3.7
The error is not connected to communication with the ldap-server (AD)
Output with debug=true in webfront.conf
ldap_create
ldap_url_parse_ext(ldaps://XXXX.ad.uit.no:636)
ldap_sasl_bind
ldap_send_initial_request
ldap_new_connection 1 1 0
ldap_int_open_connection
ldap_connect_to_host: TCP XXXX.ad.uit.no:636
ldap_new_socket: 18
ldap_prepare_socket: 18
ldap_connect_to_host: Trying 129.242.xx.zzz:636
ldap_pvt_connect: fd: 18 tm: -1 async: 0
attempting to connect:
connect success
[Tue Nov 02 08:53:35.941429 2021] [wsgi:error] [pid 34769] [client
129.242.14.106:49209] Truncated or oversized response headers received from
daemon process 'NAV': /usr/local/lib/python3.7/site-packages/nav/wsgi.py,
referer: https://nav.uit.no/index/login/?origin=/&noaccess
[Tue Nov 02 08:53:35.977367 2021] [core:notice] [pid 34758] AH00052: child pid
34760 exit signal Segmentation fault (11)
Any ideas?
--Ingeborg
--
Ingeborg Østrem Hellemo -- ingeborg.hellemo(a)uit.no
Dep. of Information Technology --- Univ. of Tromsø