- Nav-users - lister.unit.no

missing FROM-clause entry for table netboxcategory
by perica＠akton.com.mk 19 Des '05

19 Des '05

> -----Original Message----- > From: Morten Vold [mailto:morten.vold@ntnu.no] > Sent: Wednesday, December 14, 2005 11:08 > To: Perica Veljanovski > Cc: nav-users(a)itea.ntnu.no > Subject: Re: [Nav-users] missing FROM-clause entry for table > netboxcategory > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On 09/12/2005 14:32, Perica Veljanovski uttered: > > > ProgrammingError: ERROR: missing FROM-clause entry for table > > "netboxcategory" > [...] > > The same error appears when I try to edit ip devices. I did a select > > * query to manage.netbox and my device is there! Netboxcategory is > > empty, so I gather that the problem lies there but don't know what > > should be in it? Is this because I missed a step or maybe because I > > started to seed with a new device type. > > Looks like a bug in editdb. I tried to grok the code quickly (it's not > pretty ;) ), and my first impression is that your analysis is correct; > that "Add IP Device" might crash if there are no registered netbox > categories. > > Netbox categories are just a way to do site-specific categorization of > devices. Example categories from our own installation are "Web", > "Unix", "Windows", "LDAP" and soforth (we use them to categorize servers). > > I'll try to give the bug a closer look, but did you solve this problem > on your installation? > > > Also I've read the mailing lists archive and see that you've reported > > a "unexpected EOF on client connection" error from postgresql, which > > I also have! I didn't find a reference on how to confront this > > problem though? I haven't got to that point yet, but it would be nice > > to have some input. > > Sorry, but you'll have to live with this "problem" a bit longer. This > error is logged by PostgreSQL because of some clients that don't > properly close their database connections, they just sever them. > Apparently some of the NAV processes don't behave properly in this > respect. It's on the TODO-list to investigate which of them are the > naughty ones, but rest assured that the only actual problem in this is > that your PostgreSQL logs grow larger. > > > Note: my /alertprofiles/ doesn't work at all :) when I click it from > > /toolbox/ I get a blank screen. > > Sounds like a PHP problem, but it looks like your fellow FreeBSD users > are helping you with this :) > > - -- > Morten Vold, ITEA, NTNU > > A: Because it messes up the order in which people normally read text. > Q: Why is it such a bad thing? > A: Top-posting. > Q: What is the most annoying thing on usenet and in e-mail? > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.2.1 (MingW32) > Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org > > iD8DBQFDn+76XxIl0kpcOkQRAlZNAKCebhr/8+FHW2mLdDQMCQm1Y+FuzACgx5S+ > HOVwxf+mE28hzVqR3Rr1XcY= > =LUC1 > -----END PGP SIGNATURE----- Thank you!!! This makes since :) So, today I had some time, gave the problem a go, and this is what I've come up with: IP Devices->Add doesn't populate the netboxcategory table, it doesn't even let you choose from subcat table in the web form! Netboxcategory has 2 fkey's, netboxid = netbox.netboxid and category = subcat.subcatid. I tried populating netboxcategory myself, but the problem persists! I think the problem is in the IP Devices->Edit query, the error again: --- ProgrammingError: ERROR: missing FROM-clause entry for table "netboxcategory" SELECT netboxid,netboxcategory.category FROM netbox WHERE netboxcategory.netboxid=netboxid --- Now I have no experience with postgressql, but have about 5 years of mysql experience, and this query doesn't make much since to me. There is no reference to netboxcategory in the FROM clause, but the SELECT uses it!? Maybe I'm wrong. Also, I think that the idea of add ip devices is to first populate netbox and then call edit (or part from it) to populate netboxcategory and probably other tables. And this is where the module crashes. But don't take my word for it, because I haven't used NAV before, nor have I examined the code!!! Hope this helps. On the other subject: A BIG thanks to my fellow FreeBSD users :P All NAV modules work now! Alert Profiles still has some errors (I assume they are trivial, haven't had time to check), and Cricket still doesn't display files from /images and doesn't read the .css so it looks kinda grouse :) Apart from that, I have a working NAV >:) Morten, I have a favor to ask. Since I have a deadline until Monday to get NAV running (or we will use cacti+kannel), could you look into my ip devices->edit problem. I'm more of a Perl guy, so Python is new to me. Thanks all! Perica Veljanovski

2 1

Messages from alaertengine
by morten.vold＠ntnu.no 14 Des '05

14 Des '05

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 06/12/2005 13:07, Hauge Odd Arne uttered: > I always get 2 e-mail messages if a box does not repy to ping and two > messages if it's declared down/up from alertenigne@nav... If a service > is down/up I get 6 e-mail messages from alertengine... > I have tried deleting my entire alertprofile and adding a new one, but > it didn't make any different. Did the alerts stop entirely when you disabled/deleted your profile? Could be that you've defined the same alert address on two different user accounts (or it might just be a weird bug). - -- Morten Vold, ITEA, NTNU A: Because it messes up the order in which people normally read text. Q: Why is it such a bad thing? A: Top-posting. Q: What is the most annoying thing on usenet and in e-mail? -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDn+N6XxIl0kpcOkQRAgTWAJ0VpuQ9d2mvRrooBW/2tMcqc00LDwCgy35G nyc+3jSo0YjIMpjJVKul19s= =6yhB -----END PGP SIGNATURE----- >From morten.vold at ntnu.no Wed Dec 14 10:25:58 2005 From: morten.vold at ntnu.no (Morten Vold) Date: Wed Dec 14 10:26:00 2005 Subject: VS: [Nav-users] Don't get alerts based on Sub category In-Reply-To: <s3959dc4.001(a)HVO-3.hivolda.no> References: <s3959dc4.001(a)HVO-3.hivolda.no> Message-ID: <439FE526.1010607(a)ntnu.no> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 06/12/2005 14:18, Peder Magne Sefland uttered: > I have been trying to get alerts based on this idea, but with no > success. If I add "All alerts" I get alerts on email and sms. So I > know that the alertengine is working. > > But I have also tried to make an alert based on one ip-address > (equals IP) with no success. When should I use "equals" or "in"? (I > have tried both) I cannot confirm nor deny your claims here. Fact is that I've experienced some very strange problems with the alert system myself. My problem is that I've tried creating an alert profile to alert me of anything that concerns one particular IP (or sysname), and it seems I always end up receiving any and all alerts that pass through NAV. Strangely enough, I don't hear anyone else here at NTNU complaining :-/ I asked the alertprofiles/alertengine authors to investigate a while back, but still no word from them. - -- Morten Vold, ITEA, NTNU A: Because it messes up the order in which people normally read text. Q: Why is it such a bad thing? A: Top-posting. Q: What is the most annoying thing on usenet and in e-mail? -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDn+UmXxIl0kpcOkQRAhgBAKDpCHY9JCLThTCZ6Xz7DKM6vqfVBwCcCQSG EJtSJ20Ae9CaoxO6n1yZWiw= =ShBq -----END PGP SIGNATURE----- >From morten.vold at ntnu.no Wed Dec 14 11:07:54 2005 From: morten.vold at ntnu.no (Morten Vold) Date: Wed Dec 14 11:07:57 2005 Subject: [Nav-users] missing FROM-clause entry for table netboxcategory In-Reply-To: <CARMENKicUbvBDxroC600000068(a)carmen.akton.si> References: <CARMENKicUbvBDxroC600000068(a)carmen.akton.si> Message-ID: <439FEEFA.2000002(a)ntnu.no> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 09/12/2005 14:32, Perica Veljanovski uttered: > ProgrammingError: ERROR: missing FROM-clause entry for table > "netboxcategory" [...] > The same error appears when I try to edit ip devices. I did a select > * query to manage.netbox and my device is there! Netboxcategory is > empty, so I gather that the problem lies there but don't know what > should be in it? Is this because I missed a step or maybe because I > started to seed with a new device type. Looks like a bug in editdb. I tried to grok the code quickly (it's not pretty ;) ), and my first impression is that your analysis is correct; that "Add IP Device" might crash if there are no registered netbox categories. Netbox categories are just a way to do site-specific categorization of devices. Example categories from our own installation are "Web", "Unix", "Windows", "LDAP" and soforth (we use them to categorize servers). I'll try to give the bug a closer look, but did you solve this problem on your installation? > Also I've read the mailing lists archive and see that you've reported > a "unexpected EOF on client connection" error from postgresql, which > I also have! I didn't find a reference on how to confront this > problem though? I haven't got to that point yet, but it would be nice > to have some input. Sorry, but you'll have to live with this "problem" a bit longer. This error is logged by PostgreSQL because of some clients that don't properly close their database connections, they just sever them. Apparently some of the NAV processes don't behave properly in this respect. It's on the TODO-list to investigate which of them are the naughty ones, but rest assured that the only actual problem in this is that your PostgreSQL logs grow larger. > Note: my /alertprofiles/ doesn't work at all :) when I click it from > /toolbox/ I get a blank screen. Sounds like a PHP problem, but it looks like your fellow FreeBSD users are helping you with this :) - -- Morten Vold, ITEA, NTNU A: Because it messes up the order in which people normally read text. Q: Why is it such a bad thing? A: Top-posting. Q: What is the most annoying thing on usenet and in e-mail? -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDn+76XxIl0kpcOkQRAlZNAKCebhr/8+FHW2mLdDQMCQm1Y+FuzACgx5S+ HOVwxf+mE28hzVqR3Rr1XcY= =LUC1 -----END PGP SIGNATURE----- >From Ingeborg.Hellemo at cc.uit.no Wed Dec 14 13:32:14 2005 From: Ingeborg.Hellemo at cc.uit.no (Ingeborg Hellemo) Date: Wed Dec 14 13:32:19 2005 Subject: SV: Re: [Nav-users] Don't get alerts based on Sub category In-Reply-To: Your message of "Wed, 07 Dec 2005 16:20:19 +0100." <s3970bc9.024(a)HVO-3.hivolda.no> Message-ID: <200512141232.jBECWEVD051728(a)dis.cc.uit.no> peder.sefland(a)hivolda.no said: > Do mean that alerts based on Sub category works with your own filters/filter? > I did not get it to work at, all based on Sub category I have now tested this once more, and you are correct. Filters (global or personal) based on Sub category does not work. I really hope someone can fix this because we need this functionality. --Ingeborg

1 0

[Nav-users]
by lox＠netzwerkplanet.de 13 Des '05

13 Des '05

Dru schrieb: > > contribute the steps I documented to get nav working on FreeBSD Hi! I would appreciate this very much, since I am changing our major server OS from Linux to FreeBSD. And even on Linux we are still experiencing trouble with NAV. Thanks for your effort, Christian >From dlavigne6 at sympatico.ca Tue Dec 13 12:55:02 2005 From: dlavigne6 at sympatico.ca (Dru) Date: Tue Dec 13 18:51:59 2005 Subject: [Nav-users] In-Reply-To: <439F05A6.1020001(a)netzwerkplanet.de> References: <20051201165300.ZVHR1593.tomts46-srv.bellnexxia.net(a)[209.226.175.82]> <43902063.3020404(a)ntnu.no> <20051203104910.M27954(a)dru.domain.org> <439F05A6.1020001(a)netzwerkplanet.de> Message-ID: <20051213125308.O547(a)dru.domain.org> On Tue, 13 Dec 2005, Christian Lox wrote: > Dru schrieb: >> >> contribute the steps I documented to get nav working on FreeBSD > > Hi! > > I would appreciate this very much, since I am changing our major > server OS from Linux to FreeBSD. > And even on Linux we are still experiencing trouble with NAV. > Thanks for your effort, I've sent my notes to Christian but haven't uploaded them yet for others as I'm working on updating the port. I'm hoping to automate a lot of the post-installation configs into the port's install scripts. Hopefully I'll have something before New Years. Dru >From Borge.Brunes at cc.uit.no Tue Dec 13 21:30:32 2005 From: Borge.Brunes at cc.uit.no (Borge Brunes) Date: Tue Dec 13 21:30:39 2005 Subject: [Nav-users] missing FROM-clause entry for table netboxcategory In-Reply-To: Message from "Perica Veljanovski" <perica(a)akton.com.mk> <CARMEN6pkNzPZrIkyPz00000157(a)carmen.akton.si> Message-ID: <200512132030.jBDKUWFu006262(a)duke.cc.uit.no> perica(a)akton.com.mk said: > ----- Traceback (most recent call last): > File "/usr/local/nav/lib/python/nav/web/pyproxy/proxy.py", line 61, in > handler > user=user, session=req.session.id) > File "/usr/local/nav/lib/python/nav/web/pyproxy/proxy.py", line 124, in > doRequest > request.request(method, path, query, headers) > File "/usr/local/lib/python2.4/httplib.py", line 801, in request > self._send_request(method, url, body, headers) > File "/usr/local/lib/python2.4/httplib.py", line 824, in _send_request > self.endheaders() > File "/usr/local/lib/python2.4/httplib.py", line 795, in endheaders > self._send_output() > File "/usr/local/lib/python2.4/httplib.py", line 676, in _send_output > self.send(msg) > File "/usr/local/lib/python2.4/httplib.py", line 643, in send > self.connect() > File "/usr/local/lib/python2.4/httplib.py", line 627, in connect > raise socket.error, msg error: (61, 'Connection refused') ----- Any > suggestions?! Make sure that Tomcat are listen on the same port as defined in SERVERPORT= in nav/lib/python/nav/web/pyproxy/proxy.py regards, -- Borge Brunes, Computer Center, University of Tromso, Norway http://www.cc.uit.no/~borge/ | http://www.freebsd.org

1 0

NAV - Device discovery problems
by adam.nisula＠gmail.com 12 Des '05

12 Des '05

Hello Everyone, I have installed the NAV3.0.0 on a CentOS system[Linux version 2.6.9-22.0.1.EL (buildcentos@x8664-build)] Originally I had installed most of the devices into the Database and everything seemed to be working well. The program did not see module 1 / port 1 on several devices. All of the other ports and modules showed up. After this I tried adding new devices to the database and they would not show up in the network explorer. To try and fix this problem I decided to dump the databases and recreate them and try adding the devices again. This did not work. The devices showed up but the problem with missing ports was still there. I then tried dropping the databases again, removing all of the files installed, and walked through the install process again. Now only the first ip-device I installed shows up in the network-explorer, yet they are all in the report. I've tried all the cron jobs for navcron and still only the one shows up. All of the devices show that their gateway is the ip address of the first device added to the database. Devices: #vendorid:typename:sysoid[:description:frequency:cdp=(yes|no):tftp=(yes|no)] nortel:bps2000:1.3.6.1.4.1.45.3.40.1:Business Policy Switch 2000:3600:no:no nortel:551024:1.3.6.1.4.1.45.3.52.1:BayStack 5510 24T:3600:no:no nortel:551048:1.3.6.1.4.1.45.3.53.1:BayStack 5510 48T:3600:no:no nortel:552048:1.3.6.1.4.1.45.3.59.2:BayStack 5520 48T PWR:3600:no:no nortel:46024:1.3.6.1.4.1.45.3.49.1:BayStack 460 24T PWR:3600:no:no nortel:nortelcore:1.3.6.1.4.1.2272.30:Nortel Core:3600:no:no The program can reteive the serial from all other devices. First Ip Device: #roomid:ip:orgid:catid:[ro:serial:rw:function:subcat1:subcat2..] 1:172.20.8.13:baycrest:SW:snmp-read::snmp-write:switch 13:172.18.0.2:baycrest:GSW:$upp0rt::bcgc-SW:core #obtains type from sysObjectID and the active ports on the first module of 9, but nothing more. This ip '172.20.8.13' becomes the gateway for all other devices discovered after adding this one. 1) How do I force an update for Network Explorer? 2) How do I get NAV to show the first port on the first module of a switch? (172.20.8.13) 3) How do I get NAV to reteive the correct gateway information for a device? (172.20.8.13) 4) What do I change to get the rest of the modules to show up in the core device? (172.18.0.2) I know this is a lot to look at but I would greatly appreciate help with any of these questions. Adam >From perica at akton.com.mk Tue Dec 13 17:38:24 2005 From: perica at akton.com.mk (Perica Veljanovski) Date: Tue Dec 13 17:38:35 2005 Subject: [Nav-users] missing FROM-clause entry for table netboxcategory In-Reply-To: <CARMENmRf6Ci6nx8dyD000000d0(a)carmen.akton.si> Message-ID: <CARMEN6pkNzPZrIkyPz00000157(a)carmen.akton.si> Hi again, I changed php5 with php4 and the extensions you suggested. I double checked my setup against the post from Roar and the setup steps that Dru sent me. Everyting seems ok, but... The proglem persists! So, let's thake a look at another problem, maybe will solve the problem by attacking another one :) This is what happens when i clikc on the Network Explorer from my Toolbox: ----- Traceback (most recent call last): File "/usr/local/nav/lib/python/nav/web/pyproxy/proxy.py", line 61, in handler user=user, session=req.session.id) File "/usr/local/nav/lib/python/nav/web/pyproxy/proxy.py", line 124, in doRequest request.request(method, path, query, headers) File "/usr/local/lib/python2.4/httplib.py", line 801, in request self._send_request(method, url, body, headers) File "/usr/local/lib/python2.4/httplib.py", line 824, in _send_request self.endheaders() File "/usr/local/lib/python2.4/httplib.py", line 795, in endheaders self._send_output() File "/usr/local/lib/python2.4/httplib.py", line 676, in _send_output self.send(msg) File "/usr/local/lib/python2.4/httplib.py", line 643, in send self.connect() File "/usr/local/lib/python2.4/httplib.py", line 627, in connect raise socket.error, msg error: (61, 'Connection refused') ----- Any suggestions?! Also to remind you, my posgres log file is filling up with "unexpected EOF on client connection". This is a subject I found in the mail archive but found no solution for. Thanks alot for taking the tame! Perica Vlejanovski -----Original Message----- From: nav-users-bounces(a)itea.ntnu.no [mailto:nav-users-bounces@itea.ntnu.no] On Behalf Of Perica Veljanovski Sent: Sunday, December 11, 2005 10:43 To: 'Roar Pettersen' Cc: nav-users(a)itea.ntnu.no Subject: RE: [Nav-users] missing FROM-clause entry for table netboxcategory Hi, That is exactly what I did in my install of NAV, except of the edit in /usr/local/cricket/cricket/lib/RRD/File.pm. I use php5, so maybe the problem is there. Also php5 doesn't have overload in the extensions. Anyway, thanks for the post. It was nice to compare what I did to my poor nav install with someone else :P Perica Veljanovski -----Original Message----- From: Roar Pettersen [mailto:edprp@uib.no] On Behalf Of Roar Pettersen Sent: Friday, December 09, 2005 14:55 To: Dru Cc: Perica Veljanovski; nav-users(a)itea.ntnu.no Subject: Re: [Nav-users] missing FROM-clause entry for table netboxcategory Hello ! >> I installed NAV 3.0.b10 on a FreeBSD 5.4 from ports. Had some trouble >> setting everything up :) and apparently still have some troubles. > > > The port doesn't install everything you need to get each module working. I'm > working on a how-to as I've resolved most of the issues on a FreeBSD 6.0. If > you want to send me a copy of your pkg_info we can start comparing systems > from there. Please read my posting on this forum earlier regarding NAV and FreeBSD, read this info and maybe some info is still missing ? http://desperados.itea.ntnu.no/pipermail/nav-users/2005-August/000912.html Btw, the FreeBSD port of NAV is dead, but we are hoping that we have a new maintainer soon. -- Med vennlig hilsen / Regards; Roar Pettersen Universitetet i Bergen - The University of Bergen Nygardsgt. 5 - N-5020 BERGEN - Norway Tlf: +47 55 58 40 55 VIP: 81503 fax: +47 55 58 40 70 roar.pettersen(a)it.uib.no - IT-Avd, UiB - http://www.uib.no _______________________________________________ Nav-users mailing list Nav-users(a)itea.ntnu.no http://mailman.itea.ntnu.no/mailman/listinfo/nav-users

1 0

missing FROM-clause entry for table netboxcategory
by dlavigne6＠sympatico.ca 09 Des '05

09 Des '05

On Fri, 9 Dec 2005, Perica Veljanovski wrote: > Hi, > > I installed NAV 3.0.b10 on a FreeBSD 5.4 from ports. Had some trouble > setting everything up :) and apparently still have some troubles. The port doesn't install everything you need to get each module working. I'm working on a how-to as I've resolved most of the issues on a FreeBSD 6.0. If you want to send me a copy of your pkg_info we can start comparing systems from there. Dru >From roar.pettersen at uib.no Fri Dec 9 14:54:38 2005 From: roar.pettersen at uib.no (Roar Pettersen) Date: Fri Dec 9 14:54:51 2005 Subject: [Nav-users] missing FROM-clause entry for table netboxcategory In-Reply-To: <20051209084648.S564(a)dru.domain.org> References: <CARMENKicUbvBDxroC600000068(a)carmen.akton.si> <20051209084648.S564(a)dru.domain.org> Message-ID: <Pine.GSO.4.61.0512091451560.18271(a)alf.uib.no> Hello ! >> I installed NAV 3.0.b10 on a FreeBSD 5.4 from ports. Had some trouble >> setting everything up :) and apparently still have some troubles. > > > The port doesn't install everything you need to get each module working. I'm > working on a how-to as I've resolved most of the issues on a FreeBSD 6.0. If > you want to send me a copy of your pkg_info we can start comparing systems > from there. Please read my posting on this forum earlier regarding NAV and FreeBSD, read this info and maybe some info is still missing ? http://desperados.itea.ntnu.no/pipermail/nav-users/2005-August/000912.html Btw, the FreeBSD port of NAV is dead, but we are hoping that we have a new maintainer soon. -- Med vennlig hilsen / Regards; Roar Pettersen Universitetet i Bergen - The University of Bergen Nygardsgt. 5 - N-5020 BERGEN - Norway Tlf: +47 55 58 40 55 VIP: 81503 fax: +47 55 58 40 70 roar.pettersen(a)it.uib.no - IT-Avd, UiB - http://www.uib.no >From perica at akton.com.mk Sun Dec 11 10:42:53 2005 From: perica at akton.com.mk (Perica Veljanovski) Date: Sun Dec 11 10:43:06 2005 Subject: [Nav-users] missing FROM-clause entry for table netboxcategory In-Reply-To: <Pine.GSO.4.61.0512091451560.18271(a)alf.uib.no> Message-ID: <CARMENmRf6Ci6nx8dyD000000d0(a)carmen.akton.si> Hi, That is exactly what I did in my install of NAV, except of the edit in /usr/local/cricket/cricket/lib/RRD/File.pm. I use php5, so maybe the problem is there. Also php5 doesn't have overload in the extensions. Anyway, thanks for the post. It was nice to compare what I did to my poor nav install with someone else :P Perica Veljanovski -----Original Message----- From: Roar Pettersen [mailto:edprp@uib.no] On Behalf Of Roar Pettersen Sent: Friday, December 09, 2005 14:55 To: Dru Cc: Perica Veljanovski; nav-users(a)itea.ntnu.no Subject: Re: [Nav-users] missing FROM-clause entry for table netboxcategory Hello ! >> I installed NAV 3.0.b10 on a FreeBSD 5.4 from ports. Had some trouble >> setting everything up :) and apparently still have some troubles. > > > The port doesn't install everything you need to get each module working. I'm > working on a how-to as I've resolved most of the issues on a FreeBSD 6.0. If > you want to send me a copy of your pkg_info we can start comparing systems > from there. Please read my posting on this forum earlier regarding NAV and FreeBSD, read this info and maybe some info is still missing ? http://desperados.itea.ntnu.no/pipermail/nav-users/2005-August/000912.html Btw, the FreeBSD port of NAV is dead, but we are hoping that we have a new maintainer soon. -- Med vennlig hilsen / Regards; Roar Pettersen Universitetet i Bergen - The University of Bergen Nygardsgt. 5 - N-5020 BERGEN - Norway Tlf: +47 55 58 40 55 VIP: 81503 fax: +47 55 58 40 70 roar.pettersen(a)it.uib.no - IT-Avd, UiB - http://www.uib.no

1 0

SV: Re: [Nav-users] Don't get alerts based on Sub category
by peder.sefland＠hivolda.no 07 Des '05

07 Des '05

>>> Ingeborg Hellemo <Ingeborg.Hellemo(a)cc.uit.no> 07.12.2005 10:09:33 >>> I think we have the same problem. I have made a public filter, but when I include this in my personal filter group I don't receive alerts that match the filter. If I make my own filters or filtergroups things works as expected. Perhaps it has something to do with settings in the "Public Access" page? --Ingeborg Do mean that alerts based on Sub category works with your own filters/filter? I did not get it to work at, all based on Sub category Peder Sefland >From perica at akton.com.mk Fri Dec 9 14:32:28 2005 From: perica at akton.com.mk (Perica Veljanovski) Date: Fri Dec 9 14:32:41 2005 Subject: [Nav-users] missing FROM-clause entry for table netboxcategory Message-ID: <CARMENKicUbvBDxroC600000068(a)carmen.akton.si> Hi, I installed NAV 3.0.b10 on a FreeBSD 5.4 from ports. Had some trouble setting everything up :) and apparently still have some troubles. Some parts of the web interface show errors, and because I'm just starting to seed the db I will begin from there: So, I added some locations, rooms, organizations, vendors, types. Everything worked fine until I tried to add an ip device. Then I got this error: --- Mod_python error: "PythonHandler editdb" Traceback (most recent call last): File "/usr/local/lib/python2.4/site-packages/mod_python/apache.py", line 299, in HandlerDispatch result = object(req) File "/usr/local/nav/apache/webroot/editdb/editdb.py", line 156, in handler output = editPage(req,pageList[table](),request,unicodeError) File "/usr/local/nav/apache/webroot/editdb/editdb.py", line 524, in editPage listView.fill(req) File "/usr/local/nav/apache/webroot/editdb/editdb.py", line 798, in fill tooltipDef[2] = executeSQLreturn(sql) File "/usr/local/nav/apache/webroot/editdb/editdbSQL.py", line 45, in executeSQLreturn database.execute(sql) ProgrammingError: ERROR: missing FROM-clause entry for table "netboxcategory" SELECT netboxid,netboxcategory.category FROM netbox WHERE netboxcategory.netboxid=netboxid --- The same error appears when I try to edit ip devices. I did a select * query to manage.netbox and my device is there! Netboxcategory is empty, so I gather that the problem lies there but don't know what should be in it? Is this because I missed a step or maybe because I started to seed with a new device type. Also I've read the mailing lists archive and see that you've reported a "unexpected EOF on client connection" error from postgresql, which I also have! I didn't find a reference on how to confront this problem though? I haven't got to that point yet, but it would be nice to have some input. Note: my /alertprofiles/ doesn't work at all :) when I click it from /toolbox/ I get a blank screen. Thanks ahead

1 0

VS: [Nav-users] Don't get alerts based on Sub category
by peder.sefland＠hivolda.no 06 Des '05

06 Des '05

I can't see that I have got any response on this question. So I try again. Peder Sefland >>> "Peder Magne Sefland" <peder.sefland(a)hivolda.no> 21.06.2005 08:50:18 >>> The "Alert Profiles" is not so easy to understand. But I'm not giving up :-) My idea was that I should make some Public filters and Public filter groups for my colleges at the computer dep. To make it easier for them to make alert profiles. So I thought that if we regisetred all the servers in their Sub category, it would be easy to get all the alerts for the servers in that group (All the Novell servers or Mail servers and so on.) I have been trying to get alerts based on this idea, but with no success. If I add "All alerts" I get alerts on email and sms. So I know that the alertengine is working. But I have also tried to make an alert based on one ip-address (equals IP) with no success. When should I use "equals" or "in"? (I have tried both) I'm attaching two screen-shot of my Sub category filter and filter groups. Please help me, tell me what I'm doing wrong, or if there is some bug. My boss wants alerts :-) Peder Sefland >From peder.sefland at hivolda.no Tue Dec 6 14:40:23 2005 From: peder.sefland at hivolda.no (Peder Magne Sefland) Date: Tue Dec 6 15:14:35 2005 Subject: [Nav-users] Don't get alerts based on Sub category Message-ID: <s395a2f0.070(a)HVO-3.hivolda.no> The "Alert Profiles" is not so easy to understand. But I'm not giving up :-) My idea was that I should make some Public filters and Public filter groups for my colleges at the computer dep. To make it easier for them to make alert profiles. So I thought that if we regisetred all the servers in their Sub category, it would be easy to get all the alerts for the servers in that group (All the Novell servers or Mail servers and so on.) I have been trying to get alerts based on this idea, but with no success. If I add "All alerts" I get alerts on email and sms. So I know that the alertengine is working. But I have also tried to make an alert based on one ip-address (equals IP) with no success. When should I use "equals" or "in"? (I have tried both) Peder Sefland >From Ingeborg.Hellemo at cc.uit.no Wed Dec 7 10:09:33 2005 From: Ingeborg.Hellemo at cc.uit.no (Ingeborg Hellemo) Date: Wed Dec 7 10:09:39 2005 Subject: [Nav-users] Don't get alerts based on Sub category In-Reply-To: Your message of "Tue, 06 Dec 2005 14:40:23 +0100." <s395a2f0.070(a)HVO-3.hivolda.no> Message-ID: <200512070909.jB799X5b051660(a)dis.cc.uit.no> peder.sefland(a)hivolda.no said: > My idea was that I should make some Public filters and Public filter groups > for my colleges at the computer dep. To make it easier for them to make alert > profiles. > So I thought that if we regisetred all the servers in their Sub category, it > would be easy to get all the alerts for the servers in that group (All the > Novell servers or Mail servers and so on.) > I have been trying to get alerts based on this idea, but with no success. I think we have the same problem. I have made a public filter, but when I include this in my personal filter group I don't receive alerts that match the filter. If I make my own filters or filtergroups things works as expected. Perhaps it has something to do with settings in the "Public Access" page? --Ingeborg

1 0

Statistics for ports with > 600Mb/s traffic
by kjetil.olsen＠usit.uio.no 05 Des '05

05 Des '05

We have a couple of GE-ports with quite heavy traffic, close to 700 Mb/s. NAV generates Cricket-configs to use SNMPv1-counters (32bit) when polling GE interfaces. But even when polling every minute, the counters loop when the traffic exceeds 600 Mb/s. Is there any plans to use SNMPv2-counters (64-bit) for GE-equipment?? All GE-equipment I have seen for the past years support 64-bit counters. The polling could then be done every 5 minutes without any problems as well. --Kjetil

2 1

by dlavigne6＠sympatico.ca 02 Des '05

02 Des '05

I've installed and configured nav on FreeBSD 6.0 using the FreeBSD port and modifying the configs according to Getting Started and the Install doc for RedHat. Haven't written the rewrite yet for https. When I point my browser to http://ip_address, I receive this error: Mod_python error: "PythonHeaderParserHandler nav.web" Traceback (most recent call last): File "/usr/local/lib/python2.4/site-packages/mod_python/apache.py", line 287, in HandlerDispatch log=debug) File "/usr/local/lib/python2.4/site-packages/mod_python/apache.py", line 454, in import_module f, p, d = imp.find_module(parts[i], path) ImportError: No module named nav The changes to httpd.conf follow. Any idea what I'm missing? Dru --- > Listen 192.168.1.117:80 > Listen 192.168.1.117:443 < LoadModule unique_id_module libexec/apache2/mod_unique_id.so < <IfDefine SSL> < </IfDefine> > LoadModule php4_module libexec/apache2/libphp4.so > LoadModule python_module libexec/apache2/mod_python.so > ServerName 192.168.1.117:80 < DocumentRoot "/usr/local/www/data" > DocumentRoot "/usr/local/nav/apache/webroot" > <Directory "/usr/local/nav/apache/webroot"> > Options Indexes FollowSymLinks ExecCGI > AllowOverride All > PythonPath "['/usr/local/include/python2.4','/usr/local/lib', '/usr/local/nav/lib/python', '/usr/local/nav/lib/python/nav', '/usr/local/nav/lib/python/nav/web', '/usr/local/lib/python2.4/site- packages/mod_python', '/usr/local/lib/python2.4', '/usr/local/lib/python2.4/site-packages/pygsl']" > AddHandler python-program .py > AddHandler cgi-script .cgi > SetHandler mod_python > PythonHandler apache > PythonDebug On > DirectoryIndex index.html index.html.var index.py index.cgi > SSLProtocol all > SSLCipherSuite HIGH:MEDIUM

2 1

Switch data isn't coming trough
by tom＠planetix.net 18 Nov '05

18 Nov '05

Hello, I'm Toni Syv?nen and I'm trying to set NAV to monitor a student house network. So far so good. But it seems that getDeviceData isn't working as it should. Database seems to be missing most of the switch ports. They are listed in getDeviceData's logs, but not in the database. When I checked the logs I found this: java.lang.ArrayIndexOutOfBoundsException: 1007 at no.ntnu.nav.getDeviceData.dataplugins.Swport.Swport.getVlanAllowHexString(Swport.java:229) at no.ntnu.nav.getDeviceData.dataplugins.Swport.Swport.getHexstring(Swport.java:201) at no.ntnu.nav.getDeviceData.dataplugins.Swport.SwportHandler.handleData(SwportHandler.java:305) at DataContainersImpl.callDataHandlers(DataContainersImpl.java:63) at QueryNetbox.run(QueryNetbox.java:792) The switch is HP Procurve 2650 and NAV seems to detect it but fails to get all the information. Also I noticed that the database has list of vlan's but those are not listed in the Report-page. Hopefully we can get this fixed soon. Greetz, Toni "ToM" Syv?nen >From a.l.prois at usit.uio.no Mon Nov 21 15:29:48 2005 From: a.l.prois at usit.uio.no (=?ISO-8859-1?Q?Asbj=F8rn_Pr=F8is?=) Date: Mon Nov 21 15:30:04 2005 Subject: [Nav-users] Errors from collect-subtrees normal Message-ID: <Pine.SOL.4.63-L.0511211515450.23271(a)saruman.uio.no> Hello. The "collect-subtrees normal" cronjob keeps sending out mails like this : --- snip --- Date: Mon, 21 Nov 2005 15:13:10 +0100 From: Cron Daemon <root@navbox> To: Subject: Cron <navcron@navbox> $CRICKETDIR/cricket/collect-subtrees normal Error and the lines leading up to it: [21-Nov-2005 15:13:05 ] Retrieved data for loopback0 (15): 0,0,0,0,0,0 [21-Nov-2005 15:13:05 ] Retrieved data for loopback0 (15): 0,0,0,0,0,0 [21-Nov-2005 15:13:05 ] Retrieved data for dec 21143a pci fast ethernet (1): 3246422302,1302780726,0,0,3382367997,3399386702 [21-Nov-2005 15:13:05 ] Retrieved data for dec 21143a pci fast ethernet (1): 3246623089,1302984322,0,0,3382368390,3399387090 [21-Nov-2005 15:13:05*] Cannot update /usr/local/nav/cricket/cricket-config/../cricket-data//router-interfaces/device.uio.no/dec 21143a pci fast ethernet.rrd: illegal attempt to update using time 1132582385 when last update time is 1132582385 (minimum one second step) --- /snip --- device.uio.no is a cisco VPN3030, NAV is 3.0.0 final running on RHEL4. Anyone know whats causing it, and how to fix? Except sending crontab output to /dev/null.. #:) -Asbj?rn- >From john.m.bredal at ntnu.no Mon Nov 21 15:50:41 2005 From: john.m.bredal at ntnu.no (John Magne Bredal) Date: Mon Nov 21 15:50:03 2005 Subject: [Nav-users] Errors from collect-subtrees normal In-Reply-To: <Pine.SOL.4.63-L.0511211515450.23271(a)saruman.uio.no> References: <Pine.SOL.4.63-L.0511211515450.23271(a)saruman.uio.no> Message-ID: <4381DEC1.4010600(a)ntnu.no> Asbj?rn Pr?is wrote: > Hello. > The "collect-subtrees normal" cronjob keeps sending out mails like this : > --- snip --- > Date: Mon, 21 Nov 2005 15:13:10 +0100 > From: Cron Daemon <root@navbox> > To: Subject: Cron <navcron@navbox> $CRICKETDIR/cricket/collect-subtrees > normal > > Error and the lines leading up to it: > [21-Nov-2005 15:13:05 ] Retrieved data for loopback0 (15): 0,0,0,0,0,0 > [21-Nov-2005 15:13:05 ] Retrieved data for loopback0 (15): 0,0,0,0,0,0 > [21-Nov-2005 15:13:05 ] Retrieved data for dec 21143a pci fast ethernet > (1): > 3246422302,1302780726,0,0,3382367997,3399386702 > [21-Nov-2005 15:13:05 ] Retrieved data for dec 21143a pci fast ethernet > (1): > 3246623089,1302984322,0,0,3382368390,3399387090 > [21-Nov-2005 15:13:05*] Cannot update > /usr/local/nav/cricket/cricket-config/../cricket-data//router-interfaces/device.uio.no/dec > 21143a pci fast ethernet.rrd: > illegal attempt to update using time 1132582385 when last update time is > 1132582385 (minimum one second step) > --- /snip --- > > device.uio.no is a cisco VPN3030, NAV is 3.0.0 final running on RHEL4. > > Anyone know whats causing it, and how to fix? Except sending crontab > output to /dev/null.. #:) > > -Asbj?rn- > It seems like there is a redundant config-entry for this interface. If you check the config-file for router-interfaces/device.uio.no, I would suspect that you find either duplicates or an erroneous config of some kind. I can't say anymore until I get more details. -- John Magne Bredal NTNU, ITEA - Nettgruppa "Just because you're paranoid, doesn't mean they're not after you." >From a.l.prois at usit.uio.no Mon Nov 21 15:59:33 2005 From: a.l.prois at usit.uio.no (=?ISO-8859-1?Q?Asbj=F8rn_Pr=F8is?=) Date: Mon Nov 21 15:59:44 2005 Subject: [Nav-users] Errors from collect-subtrees normal In-Reply-To: <4381DEC1.4010600(a)ntnu.no> References: <Pine.SOL.4.63-L.0511211515450.23271(a)saruman.uio.no> <4381DEC1.4010600(a)ntnu.no> Message-ID: <Pine.SOL.4.63-L.0511211556120.23271(a)saruman.uio.no> On Mon, 21 Nov 2005, John Magne Bredal wrote: > It seems like there is a redundant config-entry for this interface. If you > check the config-file for router-interfaces/device.uio.no, I would suspect > that you find either duplicates or an erroneous config of some kind. I can't > say anymore until I get more details. -- snip --- -bash-3.00# more /usr/local/nav/cricket/cricket-config/router-interfaces/device.uio.no/targets target --default-- snmp-host = 1.2.3.4 snmp-community = blingbling target "DEC 21143A PCI Fast Ethernet" order = 2 interface-index = 2 short-desc = "No description available" target "DEC 21143A PCI Fast Ethernet" order = 1 interface-index = 1 short-desc = "No description available" target all order = 3 targets = "dec 21143a pci fast ethernet;dec 21143a pci fast ethernet" --- /snip --- If this is incorrect, any idea why makecricketconfig.pl (?) generates it wrong? -Asbj?rn- >From john.m.bredal at ntnu.no Mon Nov 21 16:06:10 2005 From: john.m.bredal at ntnu.no (John Magne Bredal) Date: Mon Nov 21 16:05:30 2005 Subject: [Nav-users] Errors from collect-subtrees normal In-Reply-To: <Pine.SOL.4.63-L.0511211556120.23271(a)saruman.uio.no> References: <Pine.SOL.4.63-L.0511211515450.23271(a)saruman.uio.no> <4381DEC1.4010600(a)ntnu.no> <Pine.SOL.4.63-L.0511211556120.23271(a)saruman.uio.no> Message-ID: <4381E262.6020704(a)ntnu.no> Asbj?rn Pr?is wrote: > On Mon, 21 Nov 2005, John Magne Bredal wrote: > >> It seems like there is a redundant config-entry for this interface. If >> you check the config-file for router-interfaces/device.uio.no, I would >> suspect that you find either duplicates or an erroneous config of some >> kind. I can't say anymore until I get more details. > > > -- snip --- > -bash-3.00# more > /usr/local/nav/cricket/cricket-config/router-interfaces/device.uio.no/targets > > target --default-- > snmp-host = 1.2.3.4 > snmp-community = blingbling > > target "DEC 21143A PCI Fast Ethernet" > order = 2 > interface-index = 2 > short-desc = "No description available" > > target "DEC 21143A PCI Fast Ethernet" > order = 1 > interface-index = 1 > short-desc = "No description available" > > target all > order = 3 > targets = "dec 21143a pci fast ethernet;dec 21143a pci > fast ethernet" > --- /snip --- > > If this is incorrect, any idea why makecricketconfig.pl (?) generates it > wrong? > Cricket needs unique target-names, because that is what it uses to make rrd-filenames. As we see here, the two target-names are equal, and Cricket then tries to update the same rrd-file. The reason, I guess, is that the ifDesc oid returns the same interface-description for those two interfaces. We have experienced that before, and unfortunately there is no easy fix at the moment. -- John Magne Bredal NTNU, ITEA - Nettgruppa "Just because you're paranoid, doesn't mean they're not after you." >From morten.vold at ntnu.no Mon Nov 28 14:42:34 2005 From: morten.vold at ntnu.no (Morten Vold) Date: Mon Nov 28 14:59:03 2005 Subject: [Nav-users] Can't get a box off maintenance In-Reply-To: <436743C6.5040707(a)ntnu.no> References: <200511010811.jA18B0bO043199(a)duke.cc.uit.no> <436743C6.5040707(a)ntnu.no> Message-ID: <438B094A.1050608(a)ntnu.no> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 01/11/2005 11:30, Morten Vold uttered: >>> I replaced the orginal box with a new one (Sorry. Should have >>> told you that). > I think I know what the problem is - the maintenanceOff-events are > posted using the device ID of the replaced device, but since this > device is no longer associated with the netbox instance, the system > still thinks the netbox is down. Of course, the problem was more complicated than that. Looks like the actual problem was in the event engine - I believe I've fixed it on trunk now :) - -- Morten Vold, ITEA, NTNU Tlf.nr: 735 98048 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDiwlJXxIl0kpcOkQRAjXuAKDktxt4bO6T7Nlgm7nw8F8OrXYu4wCdGVNi yuXOBTtVqVl4f3cgzm8DZJM= =lxHg -----END PGP SIGNATURE-----

1 0

replaced devices don't get updated
by kreide＠gmail.com 17 Nov '05

17 Nov '05

> But the device browser still shows the 12 Ports of the 2912 which > was removed, though the type if the device reports " cisco, > cat3524XL, Catalyst 3524 XL switch". > How do we get the new device registered? Sometimes it is necessary to remove the device from NAV and the re-add it. -- Kristian

1 0

Beginners problem
by smilisic＠carnet.hr 03 Nov '05

03 Nov '05

Problem is solved, cricket graphs shows statistics this time.. It was my error. I should run ./compile in cricket dir as navcron-user, not as a root. Running su - navcron was not enough, but su - navcron -s /bin/bash solved it :) Thanx all 4 help! Silvije Citat John Magne Bredal <john.m.bredal(a)ntnu.no>: > Hi, > > it seems like makecricketconfig does not find any data in the database > for some reason. Can you please send me the log makecricketconfig.pl > makes? This log should be in the mailbox to the user navcron. > > Silvije wrote: > > > >> > >> When you say there are no statistics, what do you mean exactly? Are > >> there empty graphs on your Cricket pages, or are there no links to any > >> graphs at all? > > > > > > There are no links at all, just Cricket warning saying: > > > > WARNING: This install of Cricket is a part of NAV-v3. When viewing the > > data, please note that we are not responsible for any anomalies on the > > network that you may see here. We are only displaying them. Any grief > > you may experience when using this install of Cricket is purely > > self-inflicted, and of no importance to us. If you however feel that we > > are helping you in any way, please feel free to send money to the > > editor. If you take this text seriously, don't > > > > and no graphs.. > > > >> Ok, I did a little checking, and it seems Debian packages the Python > >> Profiler as a separate package, under the non-free section (I don't know > >> why, but I assume it's because the profile module is released under some > >> other license than the rest of the Python library..?) > >> > >> Assuming you have the non-free section as part of your sources in > >> /etc/apt/sources.list, try running "apt-get install python-profiler" and > >> see whether NAV works after that. Cc: to Morten Werner, who is the NAV > >> Debian package maintainer. > >> > > > > Thanks for that, now it works without python errors :) > > > > Regards, > > > > Silvije Milisic, > > CARNet > > _______________________________________________ > > Nav-users mailing list > > Nav-users(a)itea.ntnu.no > > http://mailman.itea.ntnu.no/mailman/listinfo/nav-users > > > -- > John Magne Bredal > NTNU, ITEA - Nettgruppa > "Just because you're paranoid, doesn't mean they're not after you." > -- Ova poruka poslana je s CARNetovog webmail sustava --- http://webmail.carnet.hr/ --- >From john.m.bredal at ntnu.no Tue Nov 15 16:06:27 2005 From: john.m.bredal at ntnu.no (John Magne Bredal) Date: Tue Nov 15 16:05:44 2005 Subject: [Nav-users] Messages Message-ID: <4379F973.903(a)ntnu.no> https://beta.nav.ntnu.no/messages/set?netbox=26 velger den ene messagen som ligger der. trykker 'add equipment to message' f?r: Mod_python error: "PythonHandler messageshandler" 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/apache/webroot/messages/messageshandler.py", line 129, in handler output = commitplacement(req) File "/usr/local/nav/apache/webroot/messages/messageshandler.py", line 1076, in commitplacement raise "noe skjedde" noe skjedde -- Mads Vaagland ITEA systemdrift, NTNU via. -- John Magne Bredal NTNU, ITEA - Nettgruppa "Just because you're paranoid, doesn't mean they're not after you." >From morten.vold at ntnu.no Wed Nov 16 10:19:29 2005 From: morten.vold at ntnu.no (Morten Vold) Date: Wed Nov 16 10:19:32 2005 Subject: [Nav-users] Messages In-Reply-To: <4379F973.903(a)ntnu.no> References: <4379F973.903(a)ntnu.no> Message-ID: <437AF9A1.6070207(a)ntnu.no> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 15/11/2005 16:06, John Magne Bredal uttered: > https://beta.nav.ntnu.no/messages/set?netbox=26 > velger den ene messagen som ligger der. John-Magne, I appreciate you forwarding bug reports to nav-users, but don't forget that the list prefers English :) > File "/usr/local/nav/apache/webroot/messages/messageshandler.py", line > 1076, in commitplacement > raise "noe skjedde" > > noe skjedde This is a known bug, and as far as I know, it was fixed on the trunk in r3350. It should be available in the 3.0.1 release (we have no schedule for this release yet; the bug report comes from NTNU, who will be running bleeding edge NAV shortly). - -- Morten Vold, ITEA, NTNU -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDevmhXxIl0kpcOkQRAr2iAJ9byaD+TJsU5G9hrXG4QHYrxfL3wwCeJr7T CqCXHakDnausoM3CyS1na2E= =IphL -----END PGP SIGNATURE----- >From lox at netzwerkplanet.de Wed Nov 16 18:53:05 2005 From: lox at netzwerkplanet.de (Christian Lox) Date: Wed Nov 16 18:54:37 2005 Subject: [Nav-users] cricket question Message-ID: <437B7201.10701(a)netzwerkplanet.de> Hi! I just managed to get an installation of NAV up and running. For test purposes I inserted some witches and routers into the database. When clicking "statistics" on the toolbox page, I notice there are not all device displayed: There is on Cisco 7507 in the DB which is displayed unter router-interfaces but not under router. Then there are two 2610, which also do not appear under router. One of them appears under router-interfaces, the other does not appear at all. Furthermore I am testing two switches which appear fine under switch-interfaces but not under switches. What am I doing wrong? Thanks, Christian -- you don't need eyes to see you need visions. >From lox at netzwerkplanet.de Thu Nov 17 14:13:09 2005 From: lox at netzwerkplanet.de (Christian Lox) Date: Thu Nov 17 14:14:49 2005 Subject: [Nav-users] replaced devices don't get updated Message-ID: <437C81E5.9080107(a)netzwerkplanet.de> Hi! In our initial test setup I had to replace a switch and the corresponding router interface. We had a Cisco 2912XL connected to a Fastethernet interface on a 7507 router. This morning the 2912 was replaced by a 3524 and the router interface now is a Gigabit interface. I edited the switch via "edit database". It was recognized as a 3524XL. So far so good. I would expect that the corresponding websites (like Device browser, statistics etc) get updated. But the device browser still shows the 12 Ports of the 2912 which was removed, though the type if the device reports " cisco, cat3524XL, Catalyst 3524 XL switch". How do we get the new device registered? Thanks, Christian

1 0

Can't get a box off maintenance
by morten.vold＠ntnu.no 01 Nov '05

01 Nov '05

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 01/11/2005 09:11, Borge Brunes uttered: >> I have a sneaking suspicion. Why did you put fp1A245-sw on >> maintenance? Did you change any modules in the box while it was on >> maintenance? > I replaced the orginal box with a new one (Sorry. Should have told > you that). I think I know what the problem is - the maintenanceOff-events are posted using the device ID of the replaced device, but since this device is no longer associated with the netbox instance, the system still thinks the netbox is down. I will try to find some time to fix this bug tomorrow. I'm guessing you're still running the bleeding edge from Subversion? ;) - -- Morten Vold, ITEA, NTNU -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDZ0PGXxIl0kpcOkQRAn71AJ4tu0b7AMRB5AKd4h9QV98bSwK+uQCgmmop 9H/sa5lsSTHGVRI3C18hLT0= =nNtc -----END PGP SIGNATURE----- >From odd.hauge at hiMolde.no Thu Nov 3 08:56:37 2005 From: odd.hauge at hiMolde.no (Hauge Odd Arne) Date: Thu Nov 3 08:56:49 2005 Subject: [Nav-users] Moduke down and up again Message-ID: <8EEE7738AEDF6947B3E5508A0244D1C27D0E16(a)stam.himolde.no> Hi. For a Cisco 3750Metro GSW I get the following messages. This is an automatically generated message from NAV: Module 11, box molde-gw2.uninett.no (158.38.0.65) does not reply to request and is declared down. Detected 2005-11-02 20:36:29. And after some hours: This is an automatically generated message from NAV: Module 11, box molde-gw2.uninett.no (158.38.0.65) is up again. Since: 2005-11-03 02:36:30. Even if the module is declared down I can ping the ip-address. Any ideas anyone ? Regards Odd Arne Hauge

1 0

Can't get a box off maintenance
by Borge.Brunes＠cc.uit.no 01 Nov '05

01 Nov '05

I took a switch off maintenance. After a couple of minutes I recived 2 messages: - One from cron: "Box fp1A245-sw.infra.uit.no (301) was on unscheduled maintenance, taking off maintenance now..." - One from alertengine: "Dette er en automatisk generert melding fra NAV: fp1A245-sw.infra.uit.no is no longer on maintenance, since 2005-10-31 15:05:00" After that I recive the same to messages every 5 minutes :-( It has been going on for 16 houes now... Suggestions anyone? regards, -- Borge Brunes, Computer Center, University of Tromso, Norway http://www.cc.uit.no/~borge/ | http://www.freebsd.org

2 1

Problem with case sensitive hostname/sysname
by odd.hauge＠hiMolde.no 31 Okt '05

31 Okt '05

Hi. Is there any solution to this "problem"... I'm having the same issue, and it's a bit annoying. Regards Odd Arne Hauge > -----Original Message----- > From: nav-users-bounces(a)itea.ntnu.no > [mailto:nav-users-bounces@itea.ntnu.no] On Behalf Of Borge Brunes > Sent: Friday, March 11, 2005 2:41 PM > To: nav-users(a)itea.ntnu.no > Cc: borge(a)cc.uit.no > Subject: [Nav-users] Problem with case sensitive hostname/sysname > > An old problem from The Beginning is back: > > eventEngine EVENTQ_MONITOR_TASK-6-RUN Got event: e=4153 d=108 > n=32 t=info s=x [dnsname=piffi.cc.uit.no] [sysname=PIFFI] > [alerttype=dnsMismatch] alertEngine User-6-sendSMS: SMS XXXX: > piffi.cc.uit.no does not match piffi.cc.uit.no (This is an > M$-box and there is no easy way tho change the sysname) > > regards, > > -- > Borge Brunes, Computer Center, University of Tromso, Norway > http://www.cc.uit.no/~borge/ | http://www.freebsd.org > > > _______________________________________________ > Nav-users mailing list > Nav-users(a)itea.ntnu.no > http://mailman.itea.ntnu.no/mailman/listinfo/nav-users >

2 1

one more time...
by Borge.Brunes＠cc.uit.no 31 Okt '05

31 Okt '05

woj(a)tstd.pl said: > last time I tried to get such statistics it was problematic, because cricket > module couldn't do it automatically. Something changed? I don't know, but it have always(?) worked for us with category=GW and netsnmp 5.2.1 innstalled on the linux-host. I also use sysservices 79 in snmpd.conf, but I don't think it's necessary. regards, -- Borge Brunes, Computer Center, University of Tromso, Norway http://www.cc.uit.no/~borge/ | http://www.freebsd.org

1 0

one more time...
by Borge.Brunes＠cc.uit.no 31 Okt '05

31 Okt '05

woj(a)tstd.pl said: > 2. Was anybody successful with monitoring linux boxes with MetaNav? No problem. regards, -- B?rge Brunes, IT-avdelingen, Universitetet i Troms? http://www.cc.uit.no/~borge/ http://www.freebsd.org

2 1

one more time...
by morten.vold＠ntnu.no 31 Okt '05

31 Okt '05

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 27/10/2005 21:09, Wojciech Kozicki uttered: > 1. Is debian package up to date? I was using it before, and I would > like to try it again. I was using SID, maybe this time it will go on > stable? What is best distro to install NAV? To have no problems with > upgrades... As far as I know, the Debian package maintainer (Morten Werner) has not yet updated the Debian package to version 3.0.0. I do know that Uninett want to put more force and support behind the Debian package. Their plan is to roll out Debian based servers to Norwegian University Colleges, readily configured for services like e-mail, network monitoring and such. > 2. Was anybody successful with monitoring linux boxes with MetaNav? What do you mean, exactly? (BTW: The name is NAV - Network Administration Visualized. MetaNav is the NAV web site). - -- Morten Vold, ITEA, NTNU -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDZdzlXxIl0kpcOkQRAgqbAKCZ5Cd4k1u2dGdIPeVINYPDMlgXhQCcCFLk Ykd24ffCVJPZdeyEbOPpZPY= =ghyr -----END PGP SIGNATURE----- >From woj at tstd.pl Mon Oct 31 10:24:57 2005 From: woj at tstd.pl (Wojciech Kozicki) Date: Mon Oct 31 10:25:13 2005 Subject: [Nav-users] one more time... In-Reply-To: <4365DCE6.7080403(a)ntnu.no> References: <200510272109.55787.woj(a)tstd.pl> <4365DCE6.7080403(a)ntnu.no> Message-ID: <200510311024.58208.woj(a)tstd.pl> On Monday 31 of October 2005 09:59, Morten Vold wrote: > On 27/10/2005 21:09, Wojciech Kozicki uttered: > > 2. Was anybody successful with monitoring linux boxes with MetaNav? > > What do you mean, exactly? I mean - gather network interfaces statistics (for example) > (BTW: The name is NAV - Network > Administration Visualized. MetaNav is the NAV web site). Ok. regards -- Woj

1 0

Beginners problem
by morten.vold＠ntnu.no 20 Okt '05

20 Okt '05

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 17/10/2005 20:57, Silvije uttered: > # ./nav status cricket > cricket: Up > Does nav have to be in $PATH? Only if it is convenient for you. On the other hand, I'm guessing that on a Debian installation you can use "invoke-rc.d nav" to call the nav init script. When you say there are no statistics, what do you mean exactly? Are there empty graphs on your Cricket pages, or are there no links to any graphs at all? > This is what I get: > > # python -c 'import profile' > Traceback (most recent call last): > File "<string>", line 1, in ? > ImportError: No module named profile Ok, I did a little checking, and it seems Debian packages the Python Profiler as a separate package, under the non-free section (I don't know why, but I assume it's because the profile module is released under some other license than the rest of the Python library..?) Assuming you have the non-free section as part of your sources in /etc/apt/sources.list, try running "apt-get install python-profiler" and see whether NAV works after that. Cc: to Morten Werner, who is the NAV Debian package maintainer. On a side note: I don't know why the profile module is used in the production release, but one of the original authors of the IP Device Center has promised to look into it. > This is solved, but only one router is drawn and link to another > unknown device... I have seeded into database one router and 2 > switches but switches dont appear in graph. Ok, on this matter I will have to ask Kristian to help, since he's the most knowledgeable on the Traffic Map (having authored it, and all ;) ) Kristian? - -- Morten Vold NTNU ITEA -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDVJnkXxIl0kpcOkQRAqozAJ4jS9LivAGdruuPTzvjbFOmRea86QCgtnOV YcF4CpPUqArTRd/I1W7OUWg= =na9/ -----END PGP SIGNATURE----- >From kreide at gmail.com Tue Oct 18 00:50:04 2005 From: kreide at gmail.com (Kristian Eide) Date: Tue Oct 18 08:50:10 2005 Subject: [Nav-users] Beginners problem In-Reply-To: <4353F403.4070007(a)carnet.hr> References: <4353F403.4070007(a)carnet.hr> Message-ID: <b4c110fd0510172350r67599f4crdd324d0e8fc0a397(a)mail.gmail.com> > This is solved, but only one router is drawn and link to another unknown > device... I have seeded into database one router and 2 switches but > switches dont appear in graph. Switches are not shown on the top level actually, but you can click on the router icon to navigate further down in the network (you might have to be logged in for this to work). -- Kristian

2 1

box on maintenance
by Borge.Brunes＠cc.uit.no 19 Okt '05

19 Okt '05

Is it possible to put a box on maintenance which has status down? How? regards, -- Borge Brunes, Computer Center, University of Tromso, Norway http://www.cc.uit.no/~borge/ | http://www.freebsd.org

1 0

Group access in NAV
by morten.vold＠ntnu.no 18 Okt '05

18 Okt '05

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 17/10/2005 15:22, Reier Johan R?dland uttered: > web_access for > ^/(report|status|emotd|alertprofiles|machinetracker|browse|preferences|cricket)/? Don't forget: web_access for ^/(vlanPlot|navAdmin)/? > When we put a user in that group he can also change the Traffic Map > and save the new layout! Bug?? Yep. I just checked this with Kristian, and it seems to be an unfortunate oversight on our part. The Traffic Map assumes that any authenticated user is an adminstrator :( > Are there some documentation on how to build new groups with > different priveleges? What do the different Regular expressions do? It might not be very well documented, but it should be straightforward. The /web_access/ privilege is used to grant access to resources on the web server, by matching the URL requested by the browser against the regular expression in the privilege target. If the URL requested by the browser matches any of the regular expressions in the web_access privileges of the user's groups, access is granted. If not, access is denied, and the user is redirected to the NAV login page. So web_access for ^/(report|status|emotd|alertprofiles|machinetracker|browse|preferences|cricket)/? grants access to any URL beginning with a slash, followed by any of the pipe separated words, then possibly followed by another slash (I'm assuming you know your regexp here). > What are the use of "Member of the following organizations"? I don't think this is actually used by any part of NAV right now, but the idea is to use this in the future as an aid to further limit what information users have access to. The organizational tree you can select from is the one that has been entered in editdb, and the same one which is referred to by IP devices registered in the NAV database. Each IP device can belong to a given organizational unit, and so can network prefixes. So, what we hope to have ready in NAV 3.1 is a system where the administrator(s) can configure privileges which allow users to use the machine tracker to track IP addresses only within the prefixes belonging to their own organizational units, or view detailed information only about IP devices owned by their own organizational units. I also see a need to maybe map these organizational units to organizational units in an LDAP tree, so that NAV will automatically know which organizational units LDAP-authenticated users belong to. - -- Morten Vold NTNU ITEA Integrasjonsgruppen -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDVKzgXxIl0kpcOkQRAsgbAKCAayEN5U1GzadG88E9jsc8Z/96XwCeNQbr 72HoGUIDZAXeYir0aHagZLA= =bDwB -----END PGP SIGNATURE----- >From morten.vold at ntnu.no Tue Oct 18 11:09:23 2005 From: morten.vold at ntnu.no (Morten Vold) Date: Tue Oct 18 10:09:31 2005 Subject: [Nav-users] Group access in NAV In-Reply-To: <Pine.LNX.4.63-L.0510171428050.21307(a)vekter.uio.no> References: <Pine.LNX.4.63-L.0510171428050.21307(a)vekter.uio.no> Message-ID: <4354ADB3.5080606(a)ntnu.no> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 17/10/2005 15:22, Reier Johan R?dland uttered: > Are there some documentation on how to build new groups with different > priveleges? What do the different Regular expressions do? > What are the use of "Member of the following organizations"? I forgot to mention that some of the existing and future concepts surrounding the privilege system are mentioned in the tigaNAV report: http://metanav.ntnu.no/tigaNAV/tigaNAV.pdf - -- Morten Vold NTNU ITEA Integrasjonsgruppen -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDVK2zXxIl0kpcOkQRAqXKAJ9MpoJS84n7oIAtkn2VRzOZLWrAswCghz0b 6C5cefwuGRA1FDbXscnLt5o= =/zer -----END PGP SIGNATURE----- >From magnus at ntnu.no Tue Oct 18 12:29:12 2005 From: magnus at ntnu.no (Magnus Nordseth) Date: Tue Oct 18 11:28:36 2005 Subject: [Nav-users] Beginners problem In-Reply-To: <435499E5.9080807(a)ntnu.no> References: <4353F403.4070007(a)carnet.hr> <435499E5.9080807(a)ntnu.no> Message-ID: <20051018092912.GA9208(a)stud.ntnu.no> Morten Vold: > On a side note: I don't know why the profile module is used in the > production release, but one of the original authors of the IP Device > Center has promised to look into it. It is safe to just remove the line import profile This will be fixed in the next NAV release. -- Magnus Nordseth

1 0

java.sql.SQLException: ERROR
by Jan.Susegg＠hint.no 18 Okt '05

18 Okt '05

Can anyone tell me why I receive the error message: SQLException while posting alert: java.sql.SQLException: ERROR: More than one tuple returned by a subselect used as an expression in my eventEngine.log. The only alerts I receive is software and firmware changes and not box down or anything else. Okt 18 08:45:53 2005 eventEngine BOX_STATE_EVENTHANDLER-6-CALLBACK Alert processing done, processed 1, queue size 34 Okt 18 08:45:53 2005 eventEngine BOX_STATE_EVENTHANDLER-6-CALLBACK Box down: 158.38.xx.xx Okt 18 08:45:53 2005 eventEngine BOX_STATE_EVENTHANDLER-6-CALLBACK Added alert: e=7731 d=222 n=117 t=boxState s=x [status=down] Okt 18 08:45:53 2005 eventEngine DEV_DB-6-POSTALERT Posting alert: e=7731 d=222 n=117 t=boxState s=x [status=down] Okt 18 08:45:53 2005 eventEngine DEV_DB-6-POSTALERT SQLException while posting alert: java.sql.SQLException: ERROR: More than one tuple returned by a subselect used as an expression. Okt 18 08:45:53 2005 eventEngine BOX_STATE_EVENTHANDLER-4-CALLBACK While posting netel down alert, PostAlertException: Got SQLException: ERROR: More than one tuple returned by a subselect used as an expression. Okt 18 08:45:53 2005 eventEngine BOX_STATE_EVENTHANDLER-6-HANDLE Scheduling callback in 883 ms (0 s) Okt 18 08:45:53 2005 eventEngine BOX_STATE_EVENTHANDLER-6-CALLBACK Alert processing done, processed 1, queue size 34 >From kreide at gmail.com Tue Oct 18 01:16:43 2005 From: kreide at gmail.com (Kristian Eide) Date: Tue Oct 18 09:16:48 2005 Subject: [Nav-users] java.sql.SQLException: ERROR In-Reply-To: <8A65B72C71E7484FBE1862045AAC5A8FB73BC2(a)embla.ansatt.hint.no> References: <8A65B72C71E7484FBE1862045AAC5A8FB73BC2(a)embla.ansatt.hint.no> Message-ID: <b4c110fd0510180016ud40dff9l3c8fbb736c7d2662(a)mail.gmail.com> > Can anyone tell me why I receive the error message: SQLException while > posting alert: java.sql.SQLException: ERROR: More than one tuple > returned by a subselect used as an expression in my eventEngine.log. The Yes, this is most likely caused by too many entries in the alerttype table. My suggestion would be to delete all entries from that table and re-run the INSERT statements from manage.sql. -- Kristian

1 0

Beginner problem
by silvije.milisic＠carnet.hr 17 Okt '05

17 Okt '05

Hi! I am new to NAV! I have installed it from debian package. I did some database seeding and i get SNMP data from router, but: 1. I dont get any Statistics 2. When I click in Network explorer on my router icon I get Mod_python error: "PythonHandler nav.web.devBrowser.dispatcher" Traceback (most recent call last): File "/usr/lib/python2.3/site-packages/mod_python/apache.py", line 287, in HandlerDispatch log=debug) File "/usr/lib/python2.3/site-packages/mod_python/apache.py", line 457, in import_module module = imp.load_module(mname, f, p, d) File "/usr/lib/python2.3/site-packages/nav/web/devBrowser/dispatcher.py", line 33, in ? import profile ImportError: No module named profile and 3. Traffic Map does not draw anything, I just get Java loading icon Please some hint ;) Thanx, Silvije >From Vidar.Faltinsen at uninett.no Mon Oct 10 16:25:15 2005 From: Vidar.Faltinsen at uninett.no (Vidar Faltinsen) Date: Mon Oct 10 15:25:57 2005 Subject: [Nav-users] Minor bug user account Message-ID: <Pine.LNX.4.63.0510101511400.1560(a)valentin.uninett.no> Morten, In the user admin tool when you add a new user, a slightly confusing thing happens. Say I am logged in as faltin with administative privilege. Then I create the account joe, and fill in full name and password and submits. On the following page the login: is replaced with faltin, not joe... So it _looks_ as if I am altering my own user account instead of creating the new account for joe. bug? ho-ho - Vidar >From odd.hauge at hiMolde.no Mon Oct 10 17:39:50 2005 From: odd.hauge at hiMolde.no (Hauge Odd Arne) Date: Mon Oct 10 16:39:57 2005 Subject: [Nav-users] Alertengine Message-ID: <8EEE7738AEDF6947B3E5508A0244D1C26A09B5(a)stam.himolde.no> Hi. I cannot start AlertEngine. Seems like some problem with the Pg library on my installation. The error message in the logfile is: Uncaught exception from user code: DBD::Pg initialisation failed: Can't locate object method "driver" via package "DBD::Pg" at /usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi/DBI.pm line 747. Perhaps the capitalisation of DBD 'Pg' isn't right. at /usr/lib/perl5/site_perl/5.8.6/NAV/AlertEngine/Engine.pm line 53 at /usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi/DBI.pm line 753 DBI::install_driver('DBI', 'Pg') called at /usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi/DBI.pm line 573 DBI::connect('DBI', 'dbi:Pg:dbname=navprofiles;host=\'localhost\'', 'navwrite', 'some-password', 'undef') called at /usr/lib/perl5/site_perl/5.8.6/NAV/AlertEngine/Engine.pm line 53 NAV::AlertEngine::Engine::new('NAV::AlertEngine::Engine', 'HASH(0x8d40074)') called at ./alertengine.pl line 31 Cheking if DBD:PG is installed: # perl -MCPAN -e 'install DBD::Pg' CPAN: Storable loaded ok Going to read /root/.cpan/Metadata Database was generated on Thu, 30 Jun 2005 00:00:19 GMT DBD::Pg is up to date. Any suggestion anyone ? - odd arne hauge

2 1

Vlan problems, traffic map, network explorer
by allmanj＠cp.dias.ie 13 Okt '05

13 Okt '05

Hi - i'm having two problems, which i suspect are related. I have just installed nav (debian package, version 2+3.0rc1-3) and set it up according to the docs. I have added our router and a few of our switches to the database but when i visit the traffic map, all i see is the router. Ditto for the network explorer. What exactly is required for devices to show up? I then noticed that it wasn't picking up the vlans correctly when i looked in reports. They're all set to blank. I've added one router which is a cisco 7204vxr, one cisco 2900 switch and one dell Powerconnect 5224 switch. Based on previous posts, i looked in the swport table in the manage database and can confirm that it has picked up the correct vlans from one of our switches at least. getBoksMacs.log contains lines like these: Oct 13 16:10:03 2005 getBoksData_01 QUERY_NETBOX-6-MAC_ENTRY Missing swportid for ifindex 25 on boks: cisco0 Oct 13 16:10:03 2005 getBoksData_01 QUERY_NETBOX-6-MAC_ENTRY Querying vlan: 1, MACs: 56 Mappings: 22 Blocked: 0 / 1 Oct 13 16:10:03 2005 getBoksData_01 QUERY_NETBOX-6-MAC_ENTRY Fetching vlan: 2 It has lines like that for all of our vlans. I'm more than willing to dig through logs and show you anything relevant. I really like the look of nav and want to be able to use it properly. Anything you can do to help would be greatly appreciated. Thanks, John Allman >From Vidar.Faltinsen at uninett.no Mon Oct 17 11:40:43 2005 From: Vidar.Faltinsen at uninett.no (Vidar Faltinsen) Date: Mon Oct 17 10:40:49 2005 Subject: [Nav-users] machine tracker In-Reply-To: <2870BA02E1D7E14CA524C38AD06CAB7713593F(a)mailit.northwood.edu> References: <2870BA02E1D7E14CA524C38AD06CAB7713593F(a)mailit.northwood.edu> Message-ID: <Pine.LNX.4.63.0510171035540.9230(a)valentin.uninett.no> On Sun, 9 Oct 2005, Kimalat, Kipngetich wrote: > hello, > i have just installed NAV 3.0 and whats steps are there to use the machine tracker? I am not sure where you are in the post-install process; but you need to seed the NAV database, of course. More info on http://metanav.ntnu.no/moin.cgi/SeedEssentials After you have given necessary seed info on your routers and switches, gDD (getDeviceData) will start to collect information from the devices. The arp logger and cam logger will in turn collect and store arp and cam data. With this in place you can use the machine tracker to track live and historical data regarding an ip address and in turn (or directly) a mac address. Hope this answers your question. best regards - Vidar

1 0

Over 100% used ip-addresses
by peder.sefland＠hivolda.no 13 Okt '05

13 Okt '05

When i click on the link "IP address scope - graphical view", in one of my subnet 114% of the ip-addresses are used. How is that possible? Maybe I should start to use IPv6 on this subnett :-) Peder Sefland

1 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

Nav-users