- Nav-users - lister.unit.no

Java Client configuration ( Machine Client )
by jean.tomaz.da.silva＠gmail.com 03 Sep '09

03 Sep '09

Hello, Friends, What is the best configuration of Java Virtual Machine to use in tool NetMap visualization ? Best Regards, Jean Tomaz.

2 1

Bandwith usage not showing on some Cisco switches.
by Audun Einangen 26 Aug '09

26 Aug '09

Hi. This may be a stupid question, but I am experiencing a strange problem in NAV, where only about a third of the links on our core router shows up with any usage, the rest comes up as if there is no traffic there at all. One other switch on the network shows usage towards all other switches, but the rest of the switches on our network shows no usage whatsoever. The easiest way to see this, is when I look at the network map, and find most of the links gray, while some are green. This is a fairly new install (only a few days old,) so I may have missed some of the documentation, but I can't seem to find anything on this problem. Our goal is, among other things, to monitor for any congestions, so the map could prove useful for those purposes. Any ideas of what I might be doing wrong? Mvh, Audun Einangen Hammerfest Kommune, IT-avdelingen

3 4

Asset tracking features in NAV
by D.P.Round 26 Aug '09

26 Aug '09

One of the features we particularly wanted from NAV is asset tracking. Am I right that these features are going to be dropped from NAV? All I really want is some way for NAV to keep track of switches in the store cupboard (both new and recycled), as well as those on the network. I don't think we are ever likely to use any features beyond that. If this feature area is to be dropped, would be be possible to add an "inactive" check box to the main Seed database/IP Devices/Add screen? David -- Dr. David Round -- Network Engineer University of Wales, Bangor - IT Services Adeilad Deiniol, Ffordd Deiniol phone (01248) 382416 Bangor, Gwynedd, LL57 2UX, UK EMail d.p.round(a)bangor.ac.uk -- Gall y neges e-bost hon, ac unrhyw atodiadau a anfonwyd gyda hi, gynnwys deunydd cyfrinachol ac wedi eu bwriadu i'w defnyddio'n unig gan y sawl y cawsant eu cyfeirio ato (atynt). Os ydych wedi derbyn y neges e-bost hon trwy gamgymeriad, rhowch wybod i'r anfonwr ar unwaith a dilëwch y neges. Os na fwriadwyd anfon y neges atoch chi, rhaid i chi beidio â defnyddio, cadw neu ddatgelu unrhyw wybodaeth a gynhwysir ynddi. Mae unrhyw farn neu safbwynt yn eiddo i'r sawl a'i hanfonodd yn unig ac nid yw o anghenraid yn cynrychioli barn Prifysgol Bangor. Nid yw Prifysgol Bangor yn gwarantu bod y neges e-bost hon neu unrhyw atodiadau yn rhydd rhag firysau neu 100% yn ddiogel. Oni bai fod hyn wedi ei ddatgan yn uniongyrchol yn nhestun yr e-bost, nid bwriad y neges e-bost hon yw ffurfio contract rhwymol - mae rhestr o lofnodwyr awdurdodedig ar gael o Swyddfa Cyllid Prifysgol Bangor. www.bangor.ac.uk This email and any attachments may contain confidential material and is solely for the use of the intended recipient(s). If you have received this email in error, please notify the sender immediately and delete this email. If you are not the intended recipient(s), you must not use, retain or disclose any information contained in this email. Any views or opinions are solely those of the sender and do not necessarily represent those of the Bangor University. Bangor University does not guarantee that this email or any attachments are free from viruses or 100% secure. Unless expressly stated in the body of the text of the email, this email is not intended to form a binding contract - a list of authorised signatories is available from the Bangor University Finance Office. www.bangor.ac.uk

2 3

Email problems after upgrade
by Lars 18 Aug '09

18 Aug '09

Hi, NAV has been running on a Debian machine flawlessly for a while, but after I did a "aptitude update" and "aptitude upgrade" I ran into some problems. The updated NAV package warned me that I needed to edit in the db password manually, which I did. Firstly I had to point apache into the right directory to get the webpage to work again. It seems to work properly. It detects devices going up and down and updates statuses on the frontpage/status page and logs per device seem fine as well. So as far as I can tell the database is working as it should as well as all the background processes. Email alerts does not work though. Apparently the addresses are blacklisted according to the alertenginge.log, but I can't find any place where email addresses are blacklisted. New alert adresses also get blacklisted. From what I can see in our mailserver log, the mail alerts never get there, which is understandable since it looks like there is some setting in NAV somewhere that stop alerts from being sent. Here is an example from the log. [2009-07-27 00:48:19,368] [WARNING] [pid=5403 nav.alertengine.alertaddress.send] Not sending alert 4927 to xxxx(a)example.com as handler Email is blacklisted (Email address edited out) alertengine.err.log is empty. Email from Cron daemon works fine. I tried changing the mailserver in the alertengine.conf file, but that did not change anything. I am lost here. Anyone have any pointers? Lars Marius Schjærin Brednett AS

2 3

__init__.pyc not publishable - trying to get NAV to go
by D.P.Round 12 Aug '09

12 Aug '09

I'm trying to get NAV to go, on Debian this time. It all seemed to be going well, but when I try to get the nav login page I get 403 forbidden. In the apache logs I can see: [Thu Aug 06 14:09:14 2009] [warn] [client 147.143.1.98] Cannot publish nav in /nav because <module 'nav' from '/usr/lib/python2.4/site-packages/nav/__init__.pyc'> is not publishable Unfortunately, I can't see what to do at the moment. Any pointers would be appreciated. Many thanks David -- Dr. David Round -- Network Engineer University of Wales, Bangor - IT Services Adeilad Deiniol, Ffordd Deiniol phone (01248) 382416 Bangor, Gwynedd, LL57 2UX, UK EMail d.p.round(a)bangor.ac.uk -- Gall y neges e-bost hon, ac unrhyw atodiadau a anfonwyd gyda hi, gynnwys deunydd cyfrinachol ac wedi eu bwriadu i'w defnyddio'n unig gan y sawl y cawsant eu cyfeirio ato (atynt). Os ydych wedi derbyn y neges e-bost hon trwy gamgymeriad, rhowch wybod i'r anfonwr ar unwaith a dilëwch y neges. Os na fwriadwyd anfon y neges atoch chi, rhaid i chi beidio â defnyddio, cadw neu ddatgelu unrhyw wybodaeth a gynhwysir ynddi. Mae unrhyw farn neu safbwynt yn eiddo i'r sawl a'i hanfonodd yn unig ac nid yw o anghenraid yn cynrychioli barn Prifysgol Bangor. Nid yw Prifysgol Bangor yn gwarantu bod y neges e-bost hon neu unrhyw atodiadau yn rhydd rhag firysau neu 100% yn ddiogel. Oni bai fod hyn wedi ei ddatgan yn uniongyrchol yn nhestun yr e-bost, nid bwriad y neges e-bost hon yw ffurfio contract rhwymol - mae rhestr o lofnodwyr awdurdodedig ar gael o Swyddfa Cyllid Prifysgol Bangor. www.bangor.ac.uk This email and any attachments may contain confidential material and is solely for the use of the intended recipient(s). If you have received this email in error, please notify the sender immediately and delete this email. If you are not the intended recipient(s), you must not use, retain or disclose any information contained in this email. Any views or opinions are solely those of the sender and do not necessarily represent those of the Bangor University. Bangor University does not guarantee that this email or any attachments are free from viruses or 100% secure. Unless expressly stated in the body of the text of the email, this email is not intended to form a binding contract - a list of authorised signatories is available from the Bangor University Finance Office. www.bangor.ac.uk

2 1

Login "unsupported hash type" error
by Pau 07 Aug '09

07 Aug '09

Hello, I just installed Nav 3.5.3 from source on a Debian 5 (Lenny), following the steps described in http://metanav.uninett.no/installing_from_source_on_debian. The problem is that when I try to log in I get the following error: DocumentRoot: '/usr/local/nav/apache/webroot' URI: '/index/login' Location: None Directory: '/usr/local/nav/apache/webroot/' Filename: '/usr/local/nav/apache/webroot/index.py' PathInfo: '/login' Phase: 'PythonHandler' Handler: 'mod_python.publisher' Traceback (most recent call last): File "/usr/lib/python2.5/site-packages/mod_python/importer.py", line 1537, in HandlerDispatch default=default_handler, arg=req, silent=hlist.silent) File "/usr/lib/python2.5/site-packages/mod_python/importer.py", line 1229, in _process_target result = _execute_target(config, req, object, arg) File "/usr/lib/python2.5/site-packages/mod_python/importer.py", line 1128, in _execute_target result = object(arg) File "/usr/lib/python2.5/site-packages/mod_python/publisher.py", line 213, in handler published = publish_object(req, object) File "/usr/lib/python2.5/site-packages/mod_python/publisher.py", line 425, in publish_object return publish_object(req,util.apply_fs_data(object, req.form, req=req)) File "/usr/lib/python2.5/site-packages/mod_python/util.py", line 554, in apply_fs_data return object(**args) File "/usr/local/nav/apache/webroot/index.py", line 194, in login authenticated = account.authenticate(password) File "/usr/local/nav/lib/python/nav/db/navprofiles.py", line 119, in authenticate return stored_hash.verify(password) File "/usr/local/nav/lib/python/nav/pwhash.py", line 116, in verify password=password) File "/usr/local/nav/lib/python/nav/pwhash.py", line 80, in __init__ self.update(password) File "/usr/local/nav/lib/python/nav/pwhash.py", line 96, in update hasher = known_methods[self.method].new(password + self.salt) File "/usr/lib/python2.5/hashlib.py", line 98, in __hash_new return __get_builtin_constructor(name)(string) File "/usr/lib/python2.5/hashlib.py", line 77, in __get_builtin_constructor raise ValueError, "unsupported hash type" ValueError: unsupported hash type Any clues on this? Did I do something wrong? Let me know if you need more info. Thank You.

3 2

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

Apache/python issue?
by jan.sjastad＠q-free.com 07 Mai '09

07 Mai '09

Hi, I have recently tried to install NAV on a computer running Ubuntu Linux. Seems like I hav an issue with the Apache/Python configuration, if I try to enter the NAV web interfac (click on index.py) I get this responce: MOD_PYTHON ERROR ProcessId: 4210 Interpreter: '127.0.1.1' ServerName: '127.0.1.1' DocumentRoot: '/var/www/' URI: '/nav' Location: None Directory: '/var/www/nav/' Filename: '/var/www/nav' PathInfo: '' Phase: 'PythonHeaderParserHandler' Handler: 'nav.web' Traceback (most recent call last): File "/usr/lib/python2.5/site-packages/mod_python/importer.py", line 1537, in HandlerDispatch default=default_handler, arg=req, silent=hlist.silent) File "/usr/lib/python2.5/site-packages/mod_python/importer.py", line 1202, in _process_target module = import_module(module_name, path=path) File "/usr/lib/python2.5/site-packages/mod_python/importer.py", line 304, in import_module return __import__(module_name, {}, {}, ['*']) ImportError: No module named nav.web Have you seen this before/any idea where the problem might be? Jan Egil Sjåstad

2 3

NAV and Cisco ASA
by Stokkenes Vidar 21 Apr '09

21 Apr '09

Hello, Can someone please explain how NAV deals with Cisco ASA (or general DMZ/firewall appliances) when you have... lets say 10 virtual interfaces (sub interfaces, or VLAN interfaces)? Logically these different virtual interfaces are separated from eachother (like a general 'GW' or 'GSW' device), and I would imagine that NAV is confused about this. In my scenario, my NAV box is logically located on a Cisco ASA subinterface (a "DMZ"), but even if I add my default gateway (my vlans default GW) to NAV, it doesn't seem to poll ARP info from the Cisco ASA appliance. As I said earlier, I can imagine that NAV doesn't know how to deal with or parse the output of its ARP table as it looks like something like this: DMZ_1 192.168.1.130 0011.850f.2e01 DMZ_1 192.168.1.111 000c.29d0.772b DMZ_1 192.168.1.116 000c.2949.e0dd DMZ_1 192.168.1.153 000c.29fd.a981 DMZ_1 192.168.1.152 0013.2100.3a5b DMZ_1 192.168.1.112 000d.9d4b.039f DMZ_1 192.168.1.151 0015.1748.2291 DMZ_1 192.168.1.115 0015.1748.2025 DMZ_1 192.168.1.110 0015.1748.2639 DMZ_2 192.168.2.18 001a.a04e.6701 DMZ_2 192.168.2.13 0050.56a5.1974 DMZ_2 192.168.2.31 4a62.1283.06f1 DMZ_2 192.168.2.14 0050.56a5.4802 DMZ_2 192.168.2.30 0050.56b2.25a5 DMZ_2 192.168.2.29 0050.56b2.7c29 DMZ_2 192.168.2.200 001a.e3b1.2888 DMZ_2 192.168.2.27 0050.56b2.1531 DMZ_2 192.168.2.26 0050.56b2.5466 DMZ_2 192.168.2.10 0022.55ca.bf60 DMZ_2 192.168.2.11 0015.1720.97d6 DMZ_2 192.168.2.25 001e.c9d2.45ad DMZ_2 192.168.2.202 0022.919a.541b DMZ_2 192.168.2.20 0015.1774.6ed8 DMZ_2 192.168.2.16 0015.1715.1f3c DMZ_2 192.168.2.12 0015.1720.95c5 DMZ_2 192.168.2.17 0015.1715.1f31 DMZ_2 192.168.2.22 0011.435a.f430 DMZ_2 192.168.2.15 0015.171e.6381 DMZ_2 192.168.2.28 0050.56b2.7394 DMZ_2 192.168.2.21 0050.56b2.4c62 By all means, maybe I am mistaking - but can someone please enlighten me how to deal with these devices in NAV? Do I have to add *every* subinterface to NAV, or would it be sufficient to add whichever side is pointing towards my management network? As it appears now, NAV doesn't seem to poll ARP tables from this device (most likely because it doesn't know how to parse the table..) I also understand that even if I managed to poll ARP data from this device, I would never be able to see a box's physical (port) location as the MAC-port map table is located on another device (the core and edge switch) Thanks for any replies, and happy belated easter! ------------------------------------------------------ Vidar Stokkenes Networking Consulant Networking and telecom Department HN IKT - Tromsø Tlf: +47 76 16 61 87 / +47 77 66 99 55 Cell: +47 95 87 99 42 e-mail: vidar.stokkenes(a)hn-ikt.no  Before printing, think about the environment

2 1

Questions regarding adding devices to NAV from a different frontend.
by Stokkenes Vidar 06 Apr '09

06 Apr '09

Hello, We are currently looking into different ways to make one "authorative" device registry for servers and network equipment for our network (which is not necessarily NAV) I am simply wondering if there is any available contrib script or method to push a new Location, Room and Device into the database without using the NAV GUI? (by using a shell script, CGI, etc) That way we could use a different GUI adding new devices into NAV without depending on using the GUI. I realize that a lot of it can be done by pushing stuff directly into the PostgreSQL database, but I assume I would need some shell scripting in order to add a new device to NAV? The reason I'm wondering is because we're currently using a self scripted inventory registry for servers, and would like to know the possibility to add new devices by pushing info from this registry to the NAV database, without depending on using NAVs GUI to add new devices. I hope the question wasn't too complicated. Regards, ------------------------------------------------------ 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 2

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

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

Nav-users