November 2024 - Nav-users - lister.unit.no

NAV - Palo Alto Plugin: MAC Records Keep Expiring
by Mehmet E. Şahin (BAŞKANLIK-BİDB) 10 Dec '24

10 Dec '24

Hi Everyone, We started using the new Palo Alto plugin with excitement. It successfully retrieves the ARP table from the Palo Alto firewall as XML every 20 minutes. However, for some reason, while reading the ARP table from Palo Alto, the records are constantly expiring and being added again. This does not occur for the ARP records received via SNMP. Has anyone observed this situation? In the example below, the IP address 192.168.0.250 belongs to a server. There is no disconnection, but for some reason, the MAC tracker records show that a re-connection is happening every 20 minutes. (BTW - our nav version is the latest (5.10.2).) Best Regards Mehmet E. ŞAHİN

3 5

During upgrade I get "The automatic update script failed to update database"
by Davide Miccone 12 Nov '24

12 Nov '24

This is not the first time that happen. Upgrading to the latest 5.11 (from 5.9) I get error at the end. Inspecting nav DB it seems that DB has been updated. To check that DB has been updated I read the content of file cat sc.05.11.0001.sql, cat sc.05.11.0002.sql and check the DB for the presence of the table "manage.oui" and of the new records in the table "altertype". Below the error that I get: ===================== Automatic database update failed The automatic update script failed to update the database. Script output: could not connect to server: Connection refused Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432? could not connect to server: Connection refused Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?

2 1

Port description is not committed Cisco 3750X
by Davide Miccone 12 Nov '24

12 Nov '24

Cisco a C3750X-48. Cisco IOS Software, C3750E Software (C3750E-UNIVERSALK9-M), Version 15.2(4)E, RELEASE SOFTWARE (fc2) NAV 5.11.0 Port description is not written to switch configuration. Changes to vlan and enable/disable works Davide

2 1

Error in snmptrapd
by Ingeborg Hellemo 04 Nov '24

04 Nov '24

Was trying to use snmptrapd for the first time in years. Incoming traps generates this error: 2024-10-30 11:00:25,287 [ERROR] [zen.pynetsnmp.callback] Exception in _callback invalid input syntax for type inet: "None" LINE 1: ... LEFT JOIN gwportprefix USING (interfaceid) WHERE 'None' IN ... ^ Traceback (most recent call last): File "/usr/local/lib/python3.9/site-packages/pynetsnmp/netsnmp.py", line 464, in _callback sess.callback(pdu.contents) File "/usr/local/lib/python3.9/site-packages/nav/snmptrapd/agent_pynetsnmp.py ", line 221, in callback self._callback(addr, pdu) File "/usr/local/lib/python3.9/site-packages/nav/snmptrapd/agent_pynetsnmp.py ", line 130, in callback self._client_callback(trap) File "/usr/local/lib/python3.9/site-packages/nav/bin/snmptrapd.py", line 234, in trap_handler _log_trap_handle_result(handled_by, trap) File "/usr/local/lib/python3.9/site-packages/nav/bin/snmptrapd.py", line 239, in _log_trap_handle_result trap.netbox.sysname + ' ({})'.format(trap.agent) if trap.netbox else trap.agent File "/usr/local/lib/python3.9/site-packages/nav/snmptrapd/trap.py", line 87, in netbox setattr(self, '_netbox', self._lookup_agent()) File "/usr/local/lib/python3.9/site-packages/nav/snmptrapd/trap.py", line 67, in _lookup_agent cur.execute( psycopg2.errors.InvalidTextRepresentation: invalid input syntax for type inet: "None" LINE 1: ... LEFT JOIN gwportprefix USING (interfaceid) WHERE 'None' IN ... ^ 2024-10-30 11:02:07,171 [ERROR] [zen.pynetsnmp.callback] Exception in _callback current transaction is aborted, commands ignored until end of transaction block Traceback (most recent call last): File "/usr/local/lib/python3.9/site-packages/pynetsnmp/netsnmp.py", line 464, in _callback sess.callback(pdu.contents) File "/usr/local/lib/python3.9/site-packages/nav/snmptrapd/agent_pynetsnmp.py ", line 221, in callback self._callback(addr, pdu) File "/usr/local/lib/python3.9/site-packages/nav/snmptrapd/agent_pynetsnmp.py ", line 130, in callback self._client_callback(trap) File "/usr/local/lib/python3.9/site-packages/nav/bin/snmptrapd.py", line 207, in trap_handler connection = getConnection('default') File "/usr/local/lib/python3.9/site-packages/nav/db/__init__.py", line 170, in getConnection _connection_cache.invalidate() File "/usr/local/lib/python3.9/site-packages/nav/__init__.py", line 55, in invalidate if self[key].is_invalid(): File "/usr/local/lib/python3.9/site-packages/nav/db/__init__.py", line 57, in is_invalid if self.ping(): File "/usr/local/lib/python3.9/site-packages/nav/db/__init__.py", line 77, in ping cursor.execute('SELECT 1') psycopg2.errors.InFailedSqlTransaction: current transaction is aborted, commands ignored until end of transaction block The incoming traps does not have any corresponding handler (yet), but I was expecting the code to handle unknown traps without barfing. --Ingeborg -- Ingeborg Østrem Hellemo -- ingeborg.hellemo(a)uit.no Dep. of Information Technology --- Univ. of Tromsø

3 7

Re: Problem with build_sphinx
by Ingeborg Hellemo 04 Nov '24

04 Nov '24

(Morten forgot to Cc the list. I think he is struggling with som new shortcuts in his mailer.) > On Fri 01 Nov 2024 at 07:50, Ingeborg Hellemo <ingeborg.hellemo(a)uit.no> wrote: > > > I'm compiling NAV from source. Somehow I've messed up my environment and > > haven't been able to install the documentation for the last two versions. (No > > showstopper, but irritating). I guess I have the wrong version of setuptools > > or something. > ... > > /usr/local/src/nav-5.11.0/# python setup.py build_sphinx > ... > > error: invalid command 'build_sphinx' > > Nah, the old ways of setuptools are becoming deprecated in the Python > world, and I think maybe Sphinx no longer integrates with setuptools. > We should really update our install docs on this point: We already > updated the docs build routine for the latest Debian package: > > https://github.com/Uninett/nav-debian/commit/ee65417603ae2780c506443e398c1a… > > Sphinx should have provided its own `sphinx-build` command, but you > apparently need to give it an input directory and an output directory as > arguments, so for the Debian build we use something like > > `sphinx-build doc/ doc/_build` > *Gasp!* Install docs not updated!?! The new command worked as a charm. --Ingeborg -- Ingeborg Østrem Hellemo -- ingeborg.hellemo(a)uit.no Dep. of Information Technology --- Univ. of Tromsø

2 1

Problem with build_sphinx
by Ingeborg Hellemo 01 Nov '24

01 Nov '24

I'm compiling NAV from source. Somehow I've messed up my environment and haven't been able to install the documentation for the last two versions. (No showstopper, but irritating). I guess I have the wrong version of setuptools or something. FreeBSD 13.3-RELEASE-p7 python39-3.9.20 setuptools 63.1.0 Sphinx 7.4.7 sphinxcontrib-applehelp 2.0.0 sphinxcontrib-devhelp 2.0.0 sphinxcontrib-django 2.5 sphinxcontrib-htmlhelp 2.1.0 sphinxcontrib-jsmath 1.0.1 sphinxcontrib-programoutput 0.17 sphinxcontrib-qthelp 2.0.0 sphinxcontrib-serializinghtml 2.0.0 /usr/local/src/nav-5.11.0/# python setup.py build_sphinx /usr/local/lib/python3.9/site-packages/setuptools/installer.py:27: SetuptoolsDeprecationWarning: setuptools.installer is deprecated. Requirements should be satisfied by a PEP 517 installer. warnings.warn( WARNING: The wheel package is not available. /usr/local/lib/python3.9/site-packages/setuptools/config/pyprojecttoml.py:104: _BetaConfiguration: Support for `[tool.setuptools]` in `pyproject.toml` is still *beta*. warnings.warn(msg, _BetaConfiguration) usage: setup.py [global_opts] cmd1 [cmd1_opts] [cmd2 [cmd2_opts] ...] or: setup.py --help [cmd1 cmd2 ...] or: setup.py --help-commands or: setup.py cmd --help error: invalid command 'build_sphinx' --Ingeborg -- Ingeborg Østrem Hellemo -- ingeborg.hellemo(a)uit.no Dep. of Information Technology --- Univ. of Tromsø

1 0