Nav-users

nav-users@lister.sikt.no

3 participants
1372 discussions

SQL-query takes looong time
by Ingeborg Hellemo 03 Jul '09

03 Jul '09

postgresql version 8.3.7 When we use "IP Device Info" and enter the name of a SRV the resulting page takes minutes to load. Thanks to the useful Debug:-line at the bottom of the page I know this is because of this query: SELECT "cam"."camid", "cam"."netboxid", "cam"."sysname", "cam"."ifindex", "cam"."module", "cam"."port", "cam"."start_time", "cam"."end_time", "cam"."misscnt", "cam"."mac" FROM "cam" WHERE "cam"."netboxid" = 566 ORDER BY "cam"."start_time" ASC LIMIT 1 Time: 174.495 The result of this query is 0 lines since this is a SRV and not a GW/GSW. If I drop the "ASC LIMIT 1" from the query I get the answer in no time. I hope somebody with more SQL-knowledge than me can come up with a fix, since this is quite annoying. --Ingeborg -- Ingeborg Østrem Hellemo -- ingeborg.hellemo(a)uit.no (Univ. of Tromsø, Norway)

2 2

cleanrrds.pl is not up to date
by Ingeborg Hellemo 03 Jul '09

03 Jul '09

NAV 3.5.4 $BINDIR/cleanrrds.pl is run nightly from crickets crontab. 1) This script has not been updated to use the new database: my $dbh = &NAV::connection('statTools', 'manage'); 2) This script also needs a version of find(1) that supports -printf. In FreeBSD we have to use gfind (no problem). gfind returns timestamps with a fractional part i.e. Thu May 28 12:38:06.0000000000 I suggest that line 117 in cleanrrds.pl is replaced with something like this: # Selects filepath,filename, time and size from the output. $line =~ m/(^\/.*)\/(.*\.rrd)\s(.*\d{2}:\d{2}:\d{2}(\.\d{10})?\s\d{4})\s(\d+)/; --Ingeborg -- Ingeborg Østrem Hellemo -- ingeborg.hellemo(a)uit.no (Univ. of Tromsø, Norway)

2 1

Virtual Appliance with NAV preinstalled
by Morten Werner Forsbring 29 Jun '09

29 Jun '09

Hi! I have the pleasure of announcing a Virtual Appliance with NAV preinstalled on Debian GNU/Linux 4.0 (aka. etch). There are download-instructions and some documentation on the metanav-wiki [1]. Please send bugsreports and comments to this list or to me directly. - Werner [1] http://metanav.uninett.no/navappliance

3 3

Wrong time zone in email alerts
by Ole Martin Bjorndalen 23 Jun '09

23 Jun '09

The new Alertengine sends email alerts where the Date header is in UTC instead of local time: From nav(a)gullars.uit.no Tue Jun 16 10:05:14 2009 Date: Tue, 16 Jun 2009 08:05:40 -0000 Alertengine uses Django to send mail, and Django sets the Date header like this: from email.Utils import formatdate, parseaddr, formataddr ... if 'date' not in header_names: msg['Date'] = formatdate() Calling formatdate() without arguments returns a date in UTC. So Django disregards its own time zone setting here. I'm not sure if it's done on purpose, but anyway a workaround in Alertengine would be to set the Date header explicitly to some localtime value, perhaps with: formatdate(localtime=True) or even better, use a value based on the time zone in the Django config. (Not sure how to do that.)

2 1

getBoksMacs is segfaulting
by Ingeborg Hellemo 23 Jun '09

23 Jun '09

getBoksMacs is sometimes, but not always, segfaulting and we need some hints about debugging. >From getBoksMacs.log it seems that i it crashes early, right after reading the database: Jun 10 11:03:35 2009 getBoksData null-5-INIT ============ getBoksData starting ============ Jun 10 11:03:35 2009 getBoksData null-5-INIT Running with 12 threads. Could not read watchMacs.conf Dumping data from tables... netboxmac...15514 ms. boks...154 ms. swport...300 ms. swportblocked...1194 ms. vlan...560 ms. swp_boks...27 ms. OID db...363 ms. # # An unexpected error has been detected by Java Runtime Environment: # # SIGSEGV (0xb) at pc=0x000000080102edc6, pid=446, tid=0x1832780 # # Java VM: Diablo Java HotSpot(TM) 64-Bit Server VM (10.0-b23 mixed mode bsd-amd64) # Problematic frame: # V [libjvm.so+0x52edc6] # # An error report file with more information is saved as: # /usr/local/nav/lib/java/getBoksMacs/hs_err_pid446.log Sometimes it also manage to write the line "cam... XXXms." The error report is attached. If the script gets past this point without crashing it runs without problems. We have tried to vary the number of threads without seeing any difference. OS: FreeBSD 7.1-RELEASE-p5 amd64 Java: diablo-jdk-1.6.0.07.02_5 Java Development Kit 1.6.0_07.02 --Ingeborg -- Ingeborg Østrem Hellemo -- ingeborg.hellemo(a)uit.no (Univ. of Tromsø, Norway)

2 1

rrd-reading process crashes
by Ingeborg Hellemo 04 Jun '09

04 Jun '09

We have just installed NAV 3.5.4 om a host running 7.1-RELEASE-p5 amd64. When we try to reach URLs like <https://nav.uit.no/rrd/ds=211476/> the page is empty and httpd-error says child pid 48021 exit signal Segmentation fault (11) Where do I start debugging? Which process is seg-faulting? --Ingeborg -- Ingeborg Østrem Hellemo -- ingeborg.hellemo(a)uit.no (Univ. of Tromsø, Norway)

2 2

How does NAV use snmp read and write communities when both are present ?
by Gro-Anita Hillestad Vindheim 28 Mai '09

28 Mai '09

A very long subject, repeated here: How does NAV use snmp read and write communities when both are present ? Untill now, we have only used snmp read on our core boxes. We are going to deploy vlanAdmin on some core boxes, and thus we need to register snmp write communities for these. We'll use snmpview-functionality to control the permission for the snmp write community. Will this affect the NAV data collection in any way, or does all collection use snmp read even with snmp write present? (I think NAV uses snmp read, and that everything will work fine, I just have to check... ) Gro-Anita

3 3

Announcement: NAV 3.5.4 released
by Morten Brekkevold 15 Mai '09

15 Mai '09

NAV 3.5.4 is now available for download at Launchpad: https://launchpad.net/nav/3.5/3.5.4 This release fixes a regression introduced by yesterday's release of NAV 3.5.3. Users of NAV 3.5.3 running under Python 2.5 or newer will not be able to log in to the web interface. Those running NAV on Python 2.4 should not experience this issue. A binary package for Debian Etch will be made available as soon as possible. The Debian package is maintained by Morten Werner Forsbring, on commission From UNINETT. Happy NAVing everyone! -- mvh Morten Brekkevold UNINETT

4 3

Installing from source on Ubuntu server
by Jan Egil Sjåstad 13 Mai '09

13 Mai '09

I'm now trying to install NAV on a server running Ubuntu 6.06.2 (2.6.15-54-amd64-server), following the procedure found here: http://metanav.uninett.no/installing_from_source_on_debian When running the 'make' command I get the following result: Cheetah.Parser.ParseError: Expected assignment operator at line 99, column 22 in file AcctChartsTemplate.tmpl Line|Line contents ----|------------------------------------------------------------- 96 | #if type($column) == type('') 97 | <th>$column</th> 98 | #else 99 | #set $title, $key = $column ^ 100 | #if $key == $sort 101 | <th><a href="?sort=-$key">$title</a></th> 102 | #else make[2]: *** [AcctChartsTemplate.py] Error 1 make[2]: Leaving directory `/home/janegils/nav-3.5.2/subsystem/radius/src' make[1]: *** [all] Error 2 make[1]: Leaving directory `/home/janegils/nav-3.5.2/subsystem/radius' make: *** [all] Error 1 Any idea what the problem is? Is the Ubuntu installlation too old? Jan Egil

2 1

Announcement: NAV 3.5.3 released
by Morten Brekkevold 13 Mai '09

13 Mai '09

NAV 3.5.3 is now available for download at Launchpad: https://launchpad.net/nav/3.5/3.5.3 This release fixes 19 bugs in NAV 3.5, and attempts to resolve the issue described in the last question of the FAQ: http://metanav.uninett.no/navfaq This optimization may also prove to mitigate some issues with the camlogger using too much time on some installations. A binary package for Debian Etch will be made available as soon as possible. The Debian package is maintained by Morten Werner Forsbring, on commission From UNINETT. Happy NAVing everyone! -- mvh Morten Brekkevold UNINETT

1 0

Jump to page:

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

Nav-users