Nav-users

nav-users@lister.sikt.no

1373 discussions

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

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

Nav-users