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

NAV mac-search with Nexus and FabricPath
by Mischa Diehm 09 Apr '15

09 Apr '15

Hi, we have FP activated in our datacenter and use Cisco Nexus (5,6,7)k. I'm not sure what caused the problem but NAV can't find MAC-addresses on these devices and even on catalysts behind them anymore. I don't know what algorithm is used to figure out where a MAC-address is attached but maybe someone who knows can clarify what is needed for that to work? Thanks in advance, Mischa -- Mischa Diehm | Network Operations Center (NOC) UniBasel | UniRechenZentrum (URZ) Klingebergstr. 70 | CH-4056 Basel Tel. +41 61 267 1574 | http://urz.unibas.ch

2 7

Manually adjust topology - [interface] table changes
by davide＠wpweb.com 09 Mai '14

09 Mai '14

I read https://nav.uninett.no/doc/3.15/howto/debugging-topology.html but I can't resolve the error in topology discovering on my network. I have some Catalyst 3550 with stackable modules that automaticaly are not correclty connected. I changed the [interface] table to adjust my topology and all is okay but my changes are lost from automatic discover. How can I permanently change the [interface] table? Thank you NAV 4.0.1

3 3

Setting up NAV from scratch/non-OVA (Graphite-issues)
by Joachim Tingvold 29 Apr '14

29 Apr '14

Hi, Decided to install NAV from 'scratch' (i.e. not use the OVA-package). Got NAV running fine, but had some hiccups getting Graphite working as it should. Found no documentation on this what-so-ever (neither on the NAV-pages, or the Graphite-pages), so had to try-and-fail some. Thought I'd share. - Debian Wheezy (not OVA) - NAV via apt (from https://nav.uninett.no/debian) root@tardis:~# dpkg -s nav|grep Vers Version: 4.0.1-3 1) Fixed /etc/nav/graphite.conf; base=http://localhost:8888/ 2) Copied content of '/usr/share/graphite-web/apache2-graphite.conf' into own VHost; <VirtualHost localhost:8888> ( + add NameVirtualHost + Listen in /etc/apache2/ports.conf) 3) Set 'CARBON_CACHE_ENABLED=true' in '/etc/default/graphite-carbon' Set 'ENABLE_UDP_LISTENER = True' in '/etc/carbon/carbon.conf' Set 'SECRET_KEY = <longsecretstring>' in '/etc/graphite/local_settings.py' Set 'TIME_ZONE = '<Gallifrey>' in '/etc/graphite/local_settings.py' 4) cd /usr/share/pyshared/graphite python manage.py syncdb 5) Started carbon-cache (/etc/init.d/carbon-cache start) 6) Started NAV + apache Should work. Some of the errors I got along the road; <http://files.jocke.no/b/nav-graphite-error.txt>. -- Joachim

2 4

Setting up NAV from scratch/non-OVA (Graphite-issues)
by Joachim Tingvold 27 Apr '14

27 Apr '14

Hi, Decided to install NAV from 'scratch' (i.e. not use the OVA-package). Got NAV running fine, but had some hiccups getting Graphite working as it should. Found no documentation on this what-so-ever (neither on the NAV-pages, or the Graphite-pages), so had to try-and-fail some. Thought I'd share. - Debian Wheezy (not OVA) - NAV via apt (from https://nav.uninett.no/debian) root@tardis:~# dpkg -s nav|grep Vers Version: 4.0.1-3 1) Fixed /etc/nav/graphite.conf; base=http://localhost:8888/ 2) Copied content of '/usr/share/graphite-web/apache2-graphite.conf' into own VHost; <VirtualHost localhost:8888> ( + add NameVirtualHost + Listen in /etc/apache2/ports.conf) 3) Set 'CARBON_CACHE_ENABLED=true' in '/etc/default/graphite-carbon' Set 'ENABLE_UDP_LISTENER = True' in '/etc/carbon/carbon.conf' Set 'SECRET_KEY = <longsecretstring>' in '/etc/graphite/local_settings.py' Set 'TIME_ZONE = '<Gallifrey>' in '/etc/graphite/local_settings.py' 4) cd /usr/share/pyshared/graphite python manage.py syncdb 5) Started carbon-cache (/etc/init.d/carbon-cache start) 6) Started NAV + apache Should work. Some of the errors I got along the road; <http://files.jocke.no/b/nav-graphite-error.txt>. -- Joachim

1 1

Is there a way to change the default 10 rows in the lists?
by davide＠wpweb.com 23 Apr '14

23 Apr '14

It should be useful if I can change the default 10 rows in the "Show xx entries" in the lists. I searched through the configuration file and in the .js but I can't change this. I wish to put 50 rows or at least "all". Thank you

2 1

Problem with uplink detecion
by Martin.Jaburek＠cah.cz 22 Apr '14

22 Apr '14

Hi, I just face another problém with uplink detection. I tried to follow documentation about troubleshooting topology, but it yielded no results. I check switchport report of both connected devices and there it is showed in the columnt labeled as connected to. I also check cdp and it also report it correctly. I also found another problém when it displays an actual uplink, but with empty from device (which seems to me quite strange). In other case an uplink is showed only on one device but not the other. Is there any limit about number of uplinks? (I have more then ten uplinks on one box) Brgds Mat -----Original Message----- From: nav-users-request(a)uninett.no [mailto:nav-users-request@uninett.no] On Behalf Of Morten Brekkevold Sent: Thursday, March 27, 2014 3:09 PM To: nav-users(a)uninett.no Subject: Announcement: NAV 3.15.7 released For those of you who wish to continue running NAV 3.15 for while, the seventh maintenance release of this series is now available for download at Launchpad: https://launchpad.net/nav/3.15/3.15.7 This release fixes 12 reported issues: * LP#1251211 (portadmin wishlist: option to reset active interface whene changing vlan) * LP#1285601 (Switch ports on non-existant VLANs on Cisco switches don't appear as switch ports in NAV) * LP#1287700 (SeedDB will readily accept serial numbers with trailing spaces) * LP#1289219 (affected displays no information on nodes not in topology) * LP#1289320 (Submitting invalid alert subscription forms cause crash instead of error message) * LP#1291956 (LDAP auth against MS AD broken since NAV 3.14.1592653) * LP#1291978 (User supplied login name is not escaped in LDAP search filters, causing possible injection vulnerabilities) * LP#1292513 (sysname/reverse dns lookups are inconsistent or lacking after a bulk import) * LP#1293621 (missing cascade in table accounttool) * LP#1295092 (Only modules and power supplies on first member are collected from stacked HP 2920) * LP#1297200 (powersupplywatch crashes when there are more than ~1024 devices to poll) * LP#1297767 (Django exposes sensitive data like: username/password) Please report further bugs at https://launchpad.net/nav/+filebug A binary package for Debian Wheezy has been made available in our APT repository, as usual. Happy NAVing everyone! -- Morten Brekkevold UNINETT AS

3 5

Nav 4.0.1 trouble with nav pping service
by Jostein Berge 22 Apr '14

22 Apr '14

Hi Having some trouble starting pping after upgradring from 3.15 Running on pping.log produces the following error : [2014-04-14 09:28:35] pping.py:__init__:54 [Notice] Setting debuglevel=5 [2014-04-14 09:28:35] pping.py:__init__:57 [Notice] Setting checkinterval=20 [2014-04-14 09:28:35] db.py:cursor:109 [Critical] 'NoneType' object has no attribute 'cursor' [2014-04-14 09:28:35] db.py:cursor:110 [Critical] Could not get cursor. Trying to reconnect... [2014-04-14 09:28:35] db.py:connect:70 [Notice] Successfully (re)connected to NAVdb [2014-04-14 09:28:35] db.py:connect:70 [Notice] Successfully (re)connected to NAVdb Traceback (most recent call last): File "/usr/lib/nav/pping.py", line 273, in <module> start(nofork) File "/usr/lib/nav/pping.py", line 241, in start myPinger.main() File "/usr/lib/nav/pping.py", line 174, in main self.generateEvents() File "/usr/lib/nav/pping.py", line 115, in generateEvents rtt) File "/usr/lib/python2.7/dist-packages/nav/statemon/statistics.py", line 68, in update send_metrics(metrics) File "/usr/lib/python2.7/dist-packages/nav/metrics/carbon.py", line 69, in send_metrics return send_metrics_to(metric_tuples, host, port) File "/usr/lib/python2.7/dist-packages/nav/metrics/carbon.py", line 57, in send_metrics_to carbon.send(packet) socket.error: [Errno 111] Connection refused Anyone have solution for this ? Hilsen Jostein Berge It-konsulent Karmøy Kommune Tlf : (528)57291

2 2

Shutdown a port
by davide＠wpweb.com 22 Apr '14

22 Apr '14

NAV 4 I can change port description or vlan in "Configure port". How can I change the port administrative status? Thank you

2 1

Problem retrieving port statistics
by Martin.Jaburek＠cah.cz 10 Apr '14

10 Apr '14

Hi, After recreating whisper databases I can see some of the graphs. Now I have another problém - not all statistics are collected! I checked graphite and it displays only few of them. The nav systém have ran for a day now, so I would expect, that it is enough time to collect all informations. In the screenshot (made from graphite webinterface) you can see various collected statistics - they are not even the same for various ports. There are no problems reported for this device in the ipdevpoll.log Any ideas? Thanks Mat -----Original Message----- From: nav-users-request(a)uninett.no [mailto:nav-users-request@uninett.no] On Behalf Of Martin.Jaburek(a)cah.cz Sent: Tuesday, March 25, 2014 4:05 PM To: John-Magne Bredal; Morten Brekkevold Cc: nav-users(a)uninett.no Subject: RE: New to nav system Hi, I'm stupid. I forget to update etc/graphite/storage-schemas.conf and etc/graphite/storage-aggregation.conf. I deleted all whisper databases and hopefully it will be much better now. Mat -----Original Message----- From: JABUREK Martin Sent: Tuesday, March 25, 2014 3:55 PM To: 'John-Magne Bredal'; Morten Brekkevold Cc: nav-users(a)uninett.no Subject: RE: New to nav system Hi, Regarding the bug - I'm using 4.0b5 right now. Is the patch also applicable for this version? Restarting ipdevpoll does help, but not for the first time. I had to restart it repeatadly (I did it due to other errors and then I mention, that it corrected it) Regarding the graphs I think there is some problem with graphing/storing data? I attached three pictures: Ten correct.png ... correct graph from rrdtools Ten graphite.png ... graph collected from graphite web interface Ten nav.png ... graph collected from nav interface It seems to me, that graphite stores too few datapoints, I tried to dump raw data and I get this: nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:16:00, nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:17:00, nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:18:00, nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:19:00,6302589367015099.0 nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:20:00, nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:21:00, nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:22:00, nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:23:00,6302603784021890.0 nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:24:00, nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:25:00, nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:26:00, nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:27:00, nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:28:00,6302617817392692.0 nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:29:00, nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:30:00, nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:31:00, nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:32:00, nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:33:00, nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:34:00,6302631305894654.0 nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:35:00, nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:36:00, nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:37:00, nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:38:00,6302639660718015.0 nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:39:00, nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:40:00, nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:41:00, nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:42:00, nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:43:00,6302653053594991.0 nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:44:00, nav.devices.DEVICE.ports.Te1_1.ifInOctets,2014-03-25 09:45:00, Shouldn't I set up scheme for carbon database to await only 5 min collections? It seems to me, that after applying derivative function it show nothing due to empty datapoints. Mat -----Original Message----- From: John-Magne Bredal [mailto:john.m.bredal@uninett.no] Sent: Monday, March 24, 2014 2:36 PM To: JABUREK Martin; Morten Brekkevold Cc: nav-users(a)uninett.no Subject: Re: New to nav system On 03/24/2014 10:51 AM, Martin.Jaburek(a)cah.cz wrote: > I modified the unknown OIDs and now I am able to collect information > from boxes. Great! > Now I have these issues: > - graphs showing throughput - there are only empty graphs on port info > tabs. > I think that backend should be fine, because I can see some graphs > (for example SystemMetrics/CPU are all fine) Maybe it is related to a > fetch error from statistics pane. (see screenshot) See below. > 2014-03-24 04:59:09,673 [WARNING plugins.dnsname.dnsname] [inventory > IP2] Box dnsname has changed from u 'IP2' to 'DNS2' > When I edit device it gets the right name, but it keep reporting only > IP. This started when I added unknown device and now I corrected it. > So I have other devices with right DNS names as sysnames. We think this may be related to this bug: https://bugs.launchpad.net/nav/+bug/1292513 . This has been fixed and will be part of the next release. The port statistics are probably being stored using the IP-address not the DNS name of the IP Device. You can verify this by browsing the Graphite Web interface and see which nodes are present under nav.devices. Try restarting ipdevpoll. This may fix your current problem. > - how can I change the look of graphs? I'm getting black backgrounded > graphs which are really ugly on white background. In the graphite configuration directory (perhaps /opt/graphite/conf), copy the file graphTemplates.conf.example to graphTemplates.conf. Then edit it and add the following: [nav] background = white foreground = black > The work done is really amazing. I look forward when I have it finally > fully up. > Thank you! :) -- John-Magne Bredal UNINETT AS

3 12

Downgrade after upgrade to 4.0.2
by Mischa Diehm 08 Apr '14

08 Apr '14

Hi, is there a way to downgrade back to 3.15.8 after a debian upgrade to 4.0.2? After purging 4.0.2 and reinstalling 3.15.8 the files are there but the db seems corrupt: Traceback (most recent call last): File "/usr/lib/python2.7/dist-packages/django/core/handlers/base.py", line 111, in get_response response = callback(request, *callback_args, **callback_kwargs) File "/usr/lib/python2.7/dist-packages/django/views/decorators/debug.py", line 69, in sensitive_post_parameters_wrapper return view(request, *args, **kwargs) File "/usr/lib/pymodules/python2.7/nav/web/webfront/views.py", line 110, in login 'errors': errors, File "/usr/lib/python2.7/dist-packages/django/views/generic/simple.py", line 26, in direct_to_template c = RequestContext(request, dictionary) File "/usr/lib/python2.7/dist-packages/django/template/context.py", line 176, in __init__ self.update(processor(request)) File "/usr/lib/pymodules/python2.7/nav/django/context_processors.py", line 64, in account_processor if preferences.count() == 0: File "/usr/lib/python2.7/dist-packages/django/db/models/query.py", line 351, in count return self.query.get_count(using=self.db) File "/usr/lib/python2.7/dist-packages/django/db/models/sql/query.py", line 418, in get_count number = obj.get_aggregation(using=using)[None] File "/usr/lib/python2.7/dist-packages/django/db/models/sql/query.py", line 384, in get_aggregation result = query.get_compiler(using).execute_sql(SINGLE) File "/usr/lib/python2.7/dist-packages/django/db/models/sql/compiler.py", line 818, in execute_sql cursor.execute(sql, params) File "/usr/lib/python2.7/dist-packages/django/db/backends/postgresql_psycopg2/bas e.py", line 52, in execute return self.cursor.execute(query, args) DatabaseError: relation "accountnavbar" does not exist LINE 1: SELECT COUNT(*) FROM "accountnavbar" WHERE "accountnavbar"."... thx, Mischa -- Mischa Diehm | Network Operations Center (NOC) UniBasel | UniRechenZentrum (URZ) Klingebergstr. 70 | CH-4056 Basel Tel. +41 61 267 1574 | http://urz.unibas.ch

2 1