Nav-users Mars 2009

nav-users@lister.sikt.no

9 participants
11 discussions

Weird Report behaviour in Internet Explorer
by Stokkenes Vidar 31 Mar '09

31 Mar '09

Hello all, This is most likely the weirdest error I've seen in NAV so far, and I can't really seem to trace where the "hidden" value is hiding. When I go to Reports, All IP Devices -> Advanced Search and put "Breivika" in the Location field and click search, I get the following SQL error: Configuration error! The report generator is not able to do such things. ERROR: column "r4g3n53nd" does not exist SELECT locationid,roomid,sysname,ip,catid,sub,typeid,typename,orgid,netbox.up,modules,swport,gwport,prefixcount,CASE WHEN Mem THEN 'Mem' ELSE NULL END AS Mem,snmp,sw_ver AS Software,serial,val AS Function,netbox.netboxid,prefixid FROM type RIGHT OUTER JOIN netbox USING (typeid) LEFT JOIN room USING (roomid) LEFT JOIN (SELECT netboxid,count(netboxid) AS gwport FROM gwport JOIN module USING (moduleid) GROUP BY netboxid) tempaggr1 USING (netboxid) LEFT JOIN (SELECT netboxid,count(netboxid) AS swport FROM swport JOIN module USING (moduleid) GROUP BY netboxid) tempaggr2 USING (netboxid) LEFT JOIN (SELECT netboxid,count(netboxid) AS modules FROM module GROUP BY netboxid) tempaggr3 USING (netboxid) LEFT JOIN (SELECT netboxid,count(netboxid) AS sub FROM netboxcategory GROUP BY netboxid) tempaggr4 USING (netboxid) LEFT JOIN (SELECT netboxid,count(netboxid) AS snmp FROM netboxsnmpoid GROUP BY netboxid) tempaggr5 USING (netboxid) LEFT JOIN (SELECT netboxid, count(netboxid) > 0 AS Mem FROM mem GROUP by netboxid) tempaggr6 USING (netboxid) LEFT JOIN (SELECT netboxid, count(gwportid) AS prefixcount FROM gwportprefix JOIN gwport USING (gwportid) JOIN module USING (moduleid) GROUP BY netboxid) tempaggr7 USING (netboxid) LEFT JOIN device ON (netbox.deviceid=device.deviceid) LEFT JOIN netboxinfo ON (netbox.netboxid=netboxinfo.netboxid AND var='function') WHERE r4g3n53nd = 'Search' AND locationid = 'Breivika' ORDER BY locationid,roomed I have no idea whatsoever where it is getting "r4g3n53nd". It looks like a password of some kind, but I can't find it in report.conf or front.html. Does anyone have a clue why I get this error? I am not able to reproduce the same error while using Mozilla Firefox. Any help appreciated :-) ------------------------------------------------------ Vidar Stokkenes Networking Consulant Networking and telecom Department 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  Before printing, think about the environment

2 6

Problem sending SMS alerts
by Sjøholt Steinar Otto 26 Mar '09

26 Mar '09

Hi There seem to be a bug somewhere i NAV 3.5.2 that requires the user to be member of the "NAV administrators" group to be able to receive SMS messages from NAV. A regular user with access only to specific parts of the NAV interface (including membership in the "SMS" group that gives "alert_by for sms" privileges) never recieves any SMS alerts, even if the "Alert profiles" account details informs the user that "You have permission to be alerted by SMS"... Steinar Otto Sjøholt IT Services Aalesund University College

3 2

Re: SV: Log engine
by Borge Brunes 25 Mar '09

25 Mar '09

ronny.raudstein(a)kvinnherad.kommune.no said: > This number is the sequence-numer of the syslog-message. I've tried to turn > it off on the router with the command: > no service sequence-number Try to use the command no logging message-counter syslog But IMHO the NAV syslog system should handle this beacuse it is the default setting on a Cisco switch/router. regards, -- Børge Brunes, IT-avdelingen, Universitetet i Tromsø http://www.cc.uit.no/~borge/ http://www.freebsd.org

3 4

Re: Log engine
by Morten Brekkevold 20 Mar '09

20 Mar '09

On Fri, 20 Mar 2009 10:22:03 +0100 "ronny.raudstein" <ronny.raudstein(a)kvinnherad.kommune.no> wrote: > Here is an example syslog: > > Mar 20 10:27:26 sw_1 607977: Mar 20 2009 10:20:06: %SEC-6-IPACCESSLOGP: > list fraVLAN800 denied tcp x.x.x.x(1380) -> 64.94.137.105(80), 2 packets What's that number doing there? 607977? Logengine doesn't expect that between the originating switch name and the colon... (oh, and please don't forget to reply-to-all, let's remember to keep nav-users on the Cc list) -- mvh Morten Brekkevold UNINETT

2 1

Re: Problem with Netmap
by Morten Brekkevold 20 Mar '09

20 Mar '09

On Fri, 20 Mar 2009 09:25:09 +0100 Gaëtan Enderlé <gaetan.enderle(a)ujf-grenoble.fr> wrote: >>> com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceException: >>> Invalid byte 2 of 3-byte UTF-8 sequence. >> >> Which browser are you using, on which operating system? >> > I try with Firefox 3.0.7 and ie 6, on windows xp. There is a known problem with the Netmap on Windows. We thought we fixed this bug in NAV 3.5.1, but it appears to still be present for Windows users (oddly enough). We're working to find new fix, but it's puzzling that a bug in a platform agnostic Java program only appears on a specific platform... -- mvh Morten Brekkevold UNINETT

1 0

Log engine
by ronny.raudstein＠kvinnherad.kommune.no 20 Mar '09

20 Mar '09

I'm having problem getting syslog messages inserted into the database. cisco.log under /var/log/nav is being populated as it supposed, and truncated every minute, but no data get inserted into the tables. When i run logengine.py manually i get this result: Traceback (most recent call last): File "logengine.py", line 298, in ? message = createMessage(line) File "logengine.py", line 123, in createMessage oritime = DateTime.DateTime(year,month,day,hour,min) TypeError: an integer is required I'm using NAV 3.5.2 upgraded from 3.5.0 Ronny Raudstein Kvinnherad Kommune

2 1

Problem with Netmap
by gaetan.enderle＠ujf-grenoble.fr 20 Mar '09

20 Mar '09

Hello, I'have install nav on debian etch with package precompiled (with apt...). It works, i have rensign my seed database with my equipment. But when i put up the netmap, my java send the following error : 19 mars 2009 17:06:10 no.uninett.nav.netmap.Main init SEVERE: null prefuse.data.io.DataIOException: prefuse.data.io.DataIOException: prefuse.data.io.DataIOException: com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceException: Invalid byte 2 of 3-byte UTF-8 sequence. at no.uninett.nav.netmap.resources.ResourceHandler.getGraphFromURL(Unknown Source) at no.uninett.nav.netmap.Main.init(Unknown Source) at sun.plugin2.applet.Plugin2Manager$AppletExecutionRunnable.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: prefuse.data.io.DataIOException: prefuse.data.io.DataIOException: com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceException: Invalid byte 2 of 3-byte UTF-8 sequence. ... 4 more Caused by: prefuse.data.io.DataIOException: com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceException: Invalid byte 2 of 3-byte UTF-8 sequence. ... 4 more Caused by: com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceException: Invalid byte 2 of 3-byte UTF-8 sequence. at com.sun.org.apache.xerces.internal.impl.io.UTF8Reader.invalidByte(Unknown Source) at com.sun.org.apache.xerces.internal.impl.io.UTF8Reader.read(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLEntityScanner.load(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLEntityScanner.skipChar(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source) at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source) at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) at javax.xml.parsers.SAXParser.parse(Unknown Source) at javax.xml.parsers.SAXParser.parse(Unknown Source) at prefuse.data.io.GraphMLReader.readGraph(Unknown Source) ... 4 more Could not index one or more tables java.lang.NullPointerException at prefuse.Visualization.addGraph(Unknown Source) at prefuse.Visualization.addGraph(Unknown Source) at prefuse.Visualization.addGraph(Unknown Source) at no.uninett.nav.display.views.MainView.prepare(Unknown Source) at no.uninett.nav.netmap.Main.start(Unknown Source) at sun.plugin2.applet.Plugin2Manager$AppletExecutionRunnable.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Exception : java.lang.NullPointerException On my server i have install sun-java6-jre and i have try with java5 and 6 on my client... Can you help me ? Thanks, yours sincerly. -- Gaëtan Enderlé

2 1

IP device Availability shown as "N/A"
by larskulseng＠gmail.com 20 Mar '09

20 Mar '09

We're using NAV 3.5 to monitor several IP devices, including switches and access points. Most devices report an availability in the form of a percentage, likely the percentage of uptime or successful ping responses. Some of our devices, (notably all of them switches), report a "last Day" availability of "N/A". My question is, how should "N/A" be interpreted? Some switches have no known downtime and are N/A, while other test switches are purposely disconnected and also show N/A. Does N/A mean that there has been no change in the given period? A small test showed that a test switch, when left off for 24 hours, gave availability of N/A for "last Day". Once this switch was turned on, N/A turned into a percentage. Shouldn't the availability always be a percentage? Thanks! Lars

2 1

network explorer issue
by sergemueller＠gmail.com 20 Mar '09

20 Mar '09

Hi everyone, i've got some strange issues with the network explorer in nav 3.5: it shows only the root node (our coreswitch) and its vlan interfaces. The Problem might occur because the coreswitch is a h3c switch, and h3c tends to index their physical interfaces starting from .4227614 going to 4228033 (52 ports) (for the first stack member and ports of the second stack are indexed from 503316505 to 503316913 the rest looks like this: IF-MIB::ifName.14 = STRING: NULL0 IF-MIB::ifName.16 = STRING: InLoopBack0 IF-MIB::ifName.31 = STRING: Vlan-interface1 IF-MIB::ifName.2431 = STRING: Vlan-interface301 IF-MIB::ifName.4023 = STRING: Vlan-interface500 IF-MIB::ifName.4031 = STRING: Vlan-interface501 IF-MIB::ifName.4227614 = STRING: Aux1/0/0 IF-MIB::ifName.4227625 = STRING: GigabitEthernet1/0/1 the last thing shown in the netexplorer is vlan-interface 501 then the whole tree is cut of. But in the network map you can see the topology, with some switches connected to our coreswitch (uplinks detected correctly) any suggestions where to look for this problem/how to fix? thx in advance

2 1

Announcement: NAV 3.5.2 released (security fixes)
by Morten Brekkevold 17 Mar '09

17 Mar '09

NAV 3.5.2 is now available for download at Launchpad: https://launchpad.net/nav/3.5/3.5.2 This release fixes two cross-site scripting vulnerabilities in the NAV web interface; we recommend that everyone upgrade as soon as possible. 10 other bugs are also fixed in this release, please see the attached changelog. A binary package for Debian Etch has already been made available in the etch repository at http://pkg-nav.aliot.debian.org/. The Debian package is maintained by Morten Werner Forsbring, on commission From UNINETT. Happy NAVing everyone! -- mvh Morten Brekkevold UNINETT

1 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

Nav-users Mars 2009