Nav-users

nav-users@lister.sikt.no

1373 discussions

SQL errors in NAV 3.4
by Morten Brekkevold 21 Jul '08

21 Jul '08

Hello everyone, While testing Werner's upcoming Debian package of NAV 3.4.1, we discovered some bugs in the SQL scripts that initialize the NAV database, see [1] for details. Two of the problems described in [1] will affect anyone who has initialized a new NAV database while installing NAV 3.4.0 or 3.4.1 from scratch. These two problems are potentially serious if you value the correctness of your machine tracker data. Whenever your delete an IP Device from NAV, there are two database rules making sure that every machine tracker entry related to this IP Device is closed. If you are affected, these rules will not have been defined, and all open records related to an IP Device will stay open as the device is deleted. The third problem is relatively minor. It only affects those who have initialized the NAV database on PostgreSQL 8.3 or newer. When a service check is deleted, a database rule removes NAV's knowledge of the service response time RRD file. Other parts of NAV will automatically remove this when it sees the file has gone 30 days without being updated. To summarize: If you upgraded to NAV 3.4 from an older version, and you do not run PostgreSQL 8.3 or newer, you do not need to take any action. If you are affected by the above problems, you can either wait for NAV 3.4.2, which we hope to release shortly, or you can apply the attached, short SQL script in your NAV manage database (using psql). [1] http://sourceforge.net/support/tracker.php?aid=2023345 -- mvh Morten Brekkevold UNINETT /* * * This SQL script is designed to upgrade your NAV database from * version 3.4.0 or 3.4.1 to 3.4.2. * * This script is only necessary if either: * * 1. You installed NAV 3.4 from scratch, creating a new database. * * or * * 2. You installed NAV on a PostgreSQL version 8.3 database. * * * NAV 3.4.1 and 3.4.1 were shipped with a manage.sql containing a * couple of errors in the order of which relations and rules were * created, and also a small typecasting error only present on * PostgreSQL 8.3 and newer (See SF#2023345 for more details). * * * Run the script as the nav database user like this: * * psql -f 3.4.2.sql manage nav * */ BEGIN; -- Redefine these two rules to make sure that they actually are -- present. CREATE OR REPLACE RULE netbox_close_arp AS ON DELETE TO netbox DO UPDATE arp SET end_time=NOW() WHERE netboxid=OLD.netboxid AND end_time='infinity'; CREATE OR REPLACE RULE netbox_close_cam AS ON DELETE TO netbox DO UPDATE cam SET end_time=NOW() WHERE netboxid=OLD.netboxid AND end_time='infinity'; -- Redefine this rule to make sure it is present also on a PostgreSQL -- 8.3 database. CREATE OR REPLACE RULE rrdfile_deleter AS ON DELETE TO service DO DELETE FROM rrd_file WHERE key='serviceid' AND value=old.serviceid; WHERE key='serviceid' AND value=old.serviceid::text; COMMIT;

1 0

NAV and HP ProCurve Switches
by Stokkenes Vidar 25 Jun '08

25 Jun '08

Hello, This might be a stupid question, but can someone with HP ProCurve equipment please guide me through the progress of getting them to work with NAV? I've added the device (HP Procurve 2824) in the database, but NAV doesn't seem to be pulling port info from the switch. The switchview shows it's been polled, but there is no "portview" on the polled switch. Any ideas? Any input is appreciated. ------------------------------------------------------ Vidar Stokkenes Konsulent Nettverk Seksjon for nettverk og telekom HN IKT - Tromsø Tlf: 76 16 61 87 / 77 66 99 55 Mobil: 95 87 99 42 e-post: vidar.stokkenes(a)hn-ikt.no<mailto:vidar.stokkenes@hn-ikt.no> [cid:image001.png@01C8D6C3.7182BF60]

1 0

The new IP device Info interface (django based) fails
by Stokkenes Vidar 16 Jun '08

16 Jun '08

Hello, After upgrading my system to NAV 3.4.0 (apt-get dist-upgrade) I get the following error when searching for a random device on the new IP Device Info feature: Mod_python error: "PythonHandler django.core.handlers.modpython" Traceback (most recent call last): File "/usr/lib/python2.4/site-packages/mod_python/apache.py", line 299, in HandlerDispatch result = object(req) File "/var/lib/python-support/python2.4/django/core/handlers/modpython.py", line 189, in handler return ModPythonHandler()(req) File "/var/lib/python-support/python2.4/django/core/handlers/modpython.py", line 162, in __call__ response = self.get_response(request) File "/var/lib/python-support/python2.4/django/core/handlers/base.py", line 132, in get_response return callback(request, **param_dict) File "/var/lib/python-support/python2.4/django/views/defaults.py", line 89, in server_error t = loader.get_template(template_name) # You need to create a 500.html template. File "/var/lib/python-support/python2.4/django/template/loader.py", line 79, in get_template source, origin = find_template_source(template_name) File "/var/lib/python-support/python2.4/django/template/loader.py", line 72, in find_template_source raise TemplateDoesNotExist, name TemplateDoesNotExist: 500.html Any ideas what this might be? Oh, when looking at the new Netmap beta, it also turns out to be blank every time :( Any help appreciated! ------------------------------------------------------ Vidar Stokkenes Konsulent Nettverk Seksjon for nettverk og telekom HN IKT - Tromsø Tlf: 76 16 61 87 / 77 66 99 55 Mobil: 95 87 99 42 e-post: vidar.stokkenes(a)hn-ikt.no<mailto:vidar.stokkenes@hn-ikt.no> [cid:image001.png@01C8CF8E.64014690]

3 5

Announcement: NAV 3.4.0 released
by Morten Brekkevold 06 Jun '08

06 Jun '08

NAV 3.4.0 final is now available for download. As SourceForge's upload system is currently unavailable for maintenance reasons, the source tarball can be downloaded from the MetaNAV web site: http://metanav.uninett.no/files/nav-3.4.0.tar.gz (md5 checksum: 8ee1b3739db7c5af2b07987ea3f6d2bb) This is a feature release, the list of features and bugs fixed can be found in the attached changelog. Changes since the release candidate include a small regression in a CSS stylesheet, and some added schema changes that were missing the first time around. Binary packages for Debian will be available soon. The Debian package is maintained by Morten Werner Forsbring, on commission from UNINETT. Happy NAVing everyone! -- mvh Morten Brekkevold UNINETT

3 5

Funky Network Explorer error
by Stokkenes Vidar 04 Jun '08

04 Jun '08

Hello there, For some reason I've started to get a "random" error when accessing the Network Explorer map on my NAV installation. Can someone please tell me what might be wrong? Here is the error output in my browser: Traceback (most recent call last): File "/usr/lib/python2.4/site-packages/nav/web/pyproxy/proxy.py", line 61, in handler user=user, session=req.session.id) File "/usr/lib/python2.4/site-packages/nav/web/pyproxy/proxy.py", line 124, in doRequest request.request(method, path, query, headers) File "httplib.py", line 804, in request self._send_request(method, url, body, headers) File "httplib.py", line 827, in _send_request self.endheaders() File "httplib.py", line 798, in endheaders self._send_output() File "httplib.py", line 679, in _send_output self.send(msg) File "httplib.py", line 646, in send self.connect() File "httplib.py", line 630, in connect raise socket.error, msg error: (111, 'Connection refused') Any ideas? Thanks. ------------------------------------------------------ Vidar Stokkenes Networking Consulant Dep. for networking og telecommunications HN IKT - Tromsø Tlf: 76 16 61 87 / 77 66 99 55 Cell: 95 87 99 42 e-mail: vidar.stokkenes(a)hn-ikt.no<mailto:vidar.stokkenes@hn-ikt.no> [cid:image001.png@01C8C22E.0DC9C3F0]

2 1

Redhat AS4 python errors
by desaiaa＠gmail.com 04 Jun '08

04 Jun '08

Hi, I did a fresh install and ran up2date on RedHat AS4. After install of NAV 3.3.2, i get python error like below when accessing through browser..please help Mod_python error: "PythonHeaderParserHandler nav.web" Traceback (most recent call last): File "/usr/lib/python2.3/site-packages/mod_python/apache.py", line 299, in HandlerDispatch result = object(req) File "/usr/local/nav/lib/python/nav/web/__init__.py", line 64, in headerparserhandler user = req.session['user'] KeyError: 'user' Ed

3 2

debian and nav-package
by Hans-Peter Fuchs 28 Mai '08

28 Mai '08

I want to test nav under debian etch. The command:aptitude install nav gives this output: Reading package lists... Done Building dependency tree... Done Reading extended state information Initializing package states... Done Writing extended state information... Done Reading task descriptions... Done Building tag database... Done The following packages have been kept back: linux-image-2.6.18-6-amd64 0 packages upgraded, 0 newly installed, 0 to remove and 1 not upgraded. Need to get 0B of archives. After unpacking 0B will be used. Writing extended state information... Done Setting up tomcat5.5 (5.5.20-2etch2) ... * Not starting Tomcat: no Java Development Kit found. invoke-rc.d: initscript tomcat5.5, action "start" failed. dpkg: error processing tomcat5.5 (--configure): subprocess post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of nav: nav depends on tomcat5.5; however: Package tomcat5.5 is not configured yet. dpkg: error processing nav (--configure): dependency problems - leaving unconfigured Errors were encountered while processing: tomcat5.5 nav E: Sub-process /usr/bin/dpkg returned an error code (1) A package failed to install. Trying to recover: Setting up tomcat5.5 (5.5.20-2etch2) ... * Not starting Tomcat: no Java Development Kit found. invoke-rc.d: initscript tomcat5.5, action "start" failed. dpkg: error processing tomcat5.5 (--configure): subprocess post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of nav: nav depends on tomcat5.5; however: Package tomcat5.5 is not configured yet. dpkg: error processing nav (--configure): dependency problems - leaving unconfigured Errors were encountered while processing: tomcat5.5 nav I suppose the 'java-development kit' ist missing or not found. Have you a tip what to do? sincerely -- Grüße Hans-Peter Fuchs Hans-Peter Fuchs - RRZK Zimmer 20 Zentrum für angewandte Informatik - Universitätsweiter Service RRZK Universität zu Köln - Tel: 0221-470-6972

2 1

Re: NAV on FreeBSD
by Morten Brekkevold 21 Mai '08

21 Mai '08

On Fri, 9 May 2008 15:35:18 -0400 "Scorpion7" <scorpion7(a)iqonline.net> wrote: > Here's what happens: > > nav start getDeviceData <enter> > > (execution hangs - intr won't work, have to CTRL+Z and then do a kill -9 PID > to stop. The same occurs for nav start eventengine) > > Attached are 4 text files (extension to show which command was utilized to > generate the output. The first line of each file shows the command and > arguments utilized to generate the output. In getDeviceData it appears that > the last action was to chdir to the nav directory. Well, upon reading the truss output of "nav start getDeviceData", it seems that the "su" command is the one that hangs after the chdir command. Can you successfully execute "su - navcron" as root? Does the navcron user have a valid login shell? > What is the difference between 'nav start ....' and executing the process > directly, ie: > cd etc/init.d > ./getDeviceData start > > "nav start ..." fails and "./getDeviceData start" succeeds? I think the > inherent difference may help us to understand what is happening and why the > failure. Or at least may help me to locate more pertinent data. There's no difference, really. The nav command is a convenience tool to do all the starting and stopping in one go (plus the added crontab manipulation). It still calls the etc/init.d scripts in the end. Are you running both commands as root? >> Besides, you say that "nav start alertengine" seems to stall, and this >> command will not modify the crontab, since alertengine isn't a cronjob >> but a daemon. It will however look at the files in the cron.d >> directory, and look at the navcron user's crontab with "crontab -u >> navcron -l". > > This is an interesting point. I su'd to navcron, just to verify and this > command is denied (as I expected). Wait, are you saying that "su - navcron" fails? That would be a reasonable cause for your problem. Several of the init scripts are designed to be run as root, and use su to drop privileges to navcron before executing processes that cannot drop privileges by themselves (such as java). As I mentioned in less detail above, the navcron user must have a valid login shell for the su'ing to work. > there is a Python class for crontab but nothing that defines command line > arguments (not familiar with python). Crontab commands are hardcoded on lines 243 and 261 in startstop.py. The nav script requires root access to run properly (and will give a warning/error if executed by anyone but root). > I've also included the strace output - as it sounded like you are more > familiar with strace - may help to locate the issue. Thanks, although I found the complete truss (with forks) output more helpful this time around :-) -- mvh Morten Brekkevold UNINETT

2 2

RE: NAV build on FreeBSD v7.x
by Scorpion7 15 Mai '08

15 Mai '08

Anders - that did the trick - THANKS! Output: Classpath: /usr/ports/net-mgmt/nav/work/nav-3.2.2/src/src/Logger/build:/usr/ports/net-m gmt/nav/work/nav-3.2.2/src/src/vlanPlot/build:/usr/ports/net-mgmt/nav/work/n av-3.2.2/src/src/ConfigParser/build:/usr/ports/net-mgmt/nav/work/nav-3.2.2/s rc/src/Database/build:/usr/ports/net-mgmt/nav/work/nav-3.2.2/src/src/Util/bu ild:/usr/ports/net-mgmt/nav/work/nav-3.2.2/src/src/Event/build:/usr/ports/ne t-mgmt/nav/work/nav-3.2.2/src/src/NetboxInfo/build:/usr/ports/net-mgmt/nav/w ork/nav-3.2.2/src/src/eventEngine/build:/usr/ports/net-mgmt/nav/work/nav-3.2 .2/src/src/SimpleSnmp/build:/usr/ports/net-mgmt/nav/work/nav-3.2.2/src/src/g etBoksMacs/build:/usr/ports/net-mgmt/nav/work/nav-3.2.2/src/src/getDeviceDat a/build:/usr/ports/net-mgmt/nav/work/nav-3.2.2/src/src/networkDiscovery/buil d:/usr/ports/net-mgmt/nav/work/nav-3.2.2/src/src/webapps/navAdmin/build:/usr /ports/net-mgmt/nav/work/nav-3.2.2/src/src/webapps/vPServer/build:/usr/local /nav/lib/java/ConfigParser.jar:/usr/local/nav/lib/java/Database.jar:/usr/loc al/nav/lib/java/Event.jar:/usr/local/nav/lib/java/Logger.jar:/usr/local/nav/ lib/java/NetboxInfo.jar:/usr/local/nav/lib/java/SimpleSnmp.jar:/usr/local/na v/lib/java/Util.jar:/usr/local/nav/lib/java/postgresql.jar:/usr/local/nav/li b/java/snmp.jar:/usr/local/share/java/classes/postgresql.jar:/usr/local/shar e/java/classes/snmp.jar INSTALL_TARGETS: Logger_inst vlanPlot_inst ConfigParser_inst Database_inst Util_inst Event_inst NetboxInfo_inst eventEngine_inst SimpleSnmp_inst getBoksMacs_inst getDeviceData_inst networkDiscovery_inst webapps/navAdmin_inst webapps/vPServer_inst > -----Original Message----- > From: Anders Nordby [mailto:anders@fupp.net] > Sent: Friday, May 09, 2008 6:01 PM > To: nav-users(a)uninett.no; Scorpion7 > Cc: 'Morten Brekkevold' > Subject: Re: NAV build on FreeBSD v7.x > > Hi, > > The nav port uses GNU make, so try gmake debug instead of make debug. > > Cheers, > Anders. > > On Fri, May 09, 2008 at 03:50:49PM -0400, Scorpion7 wrote: > > When doing the "make debug": > > > > -------------- > > make debug > > "Makefile", line 44: Need an operator > > make: fatal errors encountered -- cannot continue > > -------------- > > > > If I comment out that line (line #44): > > export -> #export > > > > -------------- > > make debug > > Classpath: > > > > > > INSTALL_TARGETS: > > -------------- > > > > Thoughts? > > > > > > > -----Original Message----- > > > From: Morten Brekkevold [mailto:morten.brekkevold@uninett.no] > > > Sent: Wednesday, May 07, 2008 5:15 AM > > > To: nav-users(a)uninett.no > > > Cc: Scorpion7 > > > Subject: Re: NAV build on FreeBSD v7.x > > > > > > On Fri, 2 May 2008 15:12:59 -0400 "Scorpion7" > <scorpion7(a)iqonline.net> > > > wrote: > > > > > > > Here is what happens when building NAV 3.2.2 on FreeBSD v7.x via > the > > > "ports" collection: > > > [snip] > > > > compile: > > > > [javac] Compiling 1 source file to /usr/ports/net- > > > mgmt/nav/work/nav-3.2.2/src/Logger/build > > > > [javac] /usr/ports/net-mgmt/nav/work/nav- > > > 3.2.2/src/Logger/src/no/ntnu/nav/logger/Log.java:33: package > > > no.ntnu.nav.ConfigParser does not exist > > > > [javac] import no.ntnu.nav.ConfigParser.*; > > > > [javac] ^ > > > > [javac] /usr/ports/net-mgmt/nav/work/nav- > > > 3.2.2/src/Logger/src/no/ntnu/nav/logger/Log.java:34: cannot find > symbol > > > > [javac] symbol : class Path > > > > [javac] location: package no.ntnu.nav > > > > [javac] import no.ntnu.nav.Path; > > > > [javac] ^ > > > > [javac] /usr/ports/net-mgmt/nav/work/nav- > > > 3.2.2/src/Logger/src/no/ntnu/nav/logger/Log.java:69: cannot find > symbol > > > > [javac] symbol : variable Path > > > > [javac] location: class no.ntnu.nav.logger.Log > > > > [javac] private static final String navConfigFile = > > > (Path.sysconfdir + "/nav.conf").replace('/', File.separatorChar); > > > > [javac] > ^ > > > > [javac] /usr/ports/net-mgmt/nav/work/nav- > > > 3.2.2/src/Logger/src/no/ntnu/nav/logger/Log.java:88: cannot find > symbol > > > > [javac] symbol : class ConfigParser > > > > [javac] location: class no.ntnu.nav.logger.Log > > > > [javac] ConfigParser navCp; > > > > [javac] ^ > > > > [javac] /usr/ports/net-mgmt/nav/work/nav- > > > 3.2.2/src/Logger/src/no/ntnu/nav/logger/Log.java:90: cannot find > symbol > > > > [javac] symbol : class ConfigParser > > > > [javac] location: class no.ntnu.nav.logger.Log > > > > [javac] navCp = new > > > ConfigParser(navConfigFile); > > > > [javac] ^ > > > > [javac] 5 errors > > > > > > > > BUILD FAILED > > > > /usr/ports/net-mgmt/nav/work/nav-3.2.2/src/Logger/build.xml:30: > > > Compile failed; see the compiler error output for details. > > > [snip] > > > > BTW - How would one normally get the compiler error output? > > > > I can include the output with some insight on how one normally > > > > get's the output. > > > > > > You already pasted the compiler error output, it's all under the > > > "compile:" section. > > > > > > It says it can't find a couple of the NAV libraries, which is > strange. > > > It suggests the CLASSPATH hasn't been set correctly when building > the > > > Logger library, yet the build process should set the CLASSPATH to > > > include all the build directories under src/ . > > > > > > If you cd to /usr/ports/net-mgmt/nav/work/nav-3.2.2/src and type > "make > > > debug", what output do you get (it should tell you what CLASSPATH > is > > > used when building the Java sources). > > > > > > -- > > > mvh > > > Morten Brekkevold > > > UNINETT > > > > > -- > Anders.

1 0

Services
by scorpion7＠iqonline.net 13 Mai '08

13 Mai '08

Good Evenin', Being new to nav..... Installation is on FreeBSD v6.x. Performed initial install from the 'ports' collection. After following instructions on basic configuration (included setup of Postgres, setting up a couple devices, room, location, etc.) it appears that some services still aren't starting: $$> nav start Starting: cricket iptrace logengine mactrace maintengine networkDiscovery pping smsd thresholdMon Failed: alertengine eventengine getDeviceData servicemon I've already done some research and had to hand-tool some .py files as there were errors for "import sre as re" and python stated that it was deprecated, ie: it should be "import re" (sre is now re) I'm not seeing any log data (even with debug=6 in nav.conf) for the failed services. Does anyone have information that may lead to this being more successful? BTW - we utilize Apache 2.x with AD authentication for internal resources. I've seen some errors with python and the web pages as well - is there an expectation that it would be Apache 1.x instead? Here are some specifics: OS: FreeBSD v6.x (Microsoft/BSD shop) Java: Diablo JDK-1.5.0 Tomcat: 6.0.14 Cricket: 1.0.5_4 nav: 3.2.2 Python: 2.5.2 Apache 2.2.8 ant: 1.7.0 Thanks!

3 9

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

Nav-users