- Nav-users - lister.unit.no

Collects cam data from switches
by roar.pettersen＠uib.no 20 Des '05

20 Des '05

Hello ! I've just re-installed our NAV3 from scratch and I have a odd problem with the CAM collector cron job : org.postgresql.util.PSQLException: ERROR: invalid message format at org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139) at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152) at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100) at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43) at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:273) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:259) at no.ntnu.nav.Database.Database.update(Database.java:987) at no.ntnu.nav.Database.Database.insert(Database.java:911) at no.ntnu.nav.netboxinfo.NetboxInfo.insertVals(NetboxInfo.java:502) at no.ntnu.nav.netboxinfo.NetboxInfo.putNoError(NetboxInfo.java:359) at no.ntnu.nav.netboxinfo.NetboxInfo.putError(NetboxInfo.java:335) at no.ntnu.nav.netboxinfo.NetboxInfo.put(NetboxInfo.java:326) at no.ntnu.nav.netboxinfo.NetboxInfo.put(NetboxInfo.java:296) at QueryBoks.processCDP(QueryBoks.java:665) at QueryBoks.run(QueryBoks.java:212) SQLException for update statement: INSERT INTO netboxinfo (netboxid,key,var,val) VALUES ('304','unrecognizedCDP','148','`?@') org.postgresql.util.PSQLException: ERROR: invalid message format at org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139) at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152) at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100) at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43) at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:273) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:259) at no.ntnu.nav.Database.Database.update(Database.java:987) at no.ntnu.nav.Database.Database.insert(Database.java:911) at no.ntnu.nav.netboxinfo.NetboxInfo.insertVals(NetboxInfo.java:502) at no.ntnu.nav.netboxinfo.NetboxInfo.putNoError(NetboxInfo.java:359) at no.ntnu.nav.netboxinfo.NetboxInfo.putError(NetboxInfo.java:335) at no.ntnu.nav.netboxinfo.NetboxInfo.put(NetboxInfo.java:326) at no.ntnu.nav.netboxinfo.NetboxInfo.put(NetboxInfo.java:296) at QueryBoks.processCDP(QueryBoks.java:665) at QueryBoks.run(QueryBoks.java:212) java.lang.RuntimeException: Got SQLException, aborting put: ERROR: invalid message format at no.ntnu.nav.netboxinfo.NetboxInfo.putError(NetboxInfo.java:342) at no.ntnu.nav.netboxinfo.NetboxInfo.put(NetboxInfo.java:326) at no.ntnu.nav.netboxinfo.NetboxInfo.put(NetboxInfo.java:296) at QueryBoks.processCDP(QueryBoks.java:665) at QueryBoks.run(QueryBoks.java:212) SQLException for update statement: INSERT INTO netboxinfo (netboxid,key,var,val) VALUES ('305','unrecognizedCDP','148','`?@') I'm using postgresql-7.4.9 and pg74.216.jdbc3.jar, have also tried other .jar files without luck. Wounder what 'unrecognizedCDP' mean ? -- 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 kreide at gmail.com Tue Dec 20 09:50:47 2005 From: kreide at gmail.com (Kristian Eide) Date: Tue Dec 20 18:50:55 2005 Subject: [Nav-users] Collects cam data from switches In-Reply-To: <Pine.GSO.4.61.0512201119310.15708(a)alf.uib.no> References: <Pine.GSO.4.61.0512201119310.15708(a)alf.uib.no> Message-ID: <b4c110fd0512200950l494bfce1ydf7a260e6a125ab4(a)mail.gmail.com> > SQLException for update statement: INSERT INTO netboxinfo > (netboxid,key,var,val) VALUES ('304','unrecognizedCDP','148','`?@') > org.postgresql.util.PSQLException: ERROR: invalid message format > Wounder what 'unrecognizedCDP' mean ? This could be a string escaping issue, but that theory should be easy to test at least. The 'unrecognizedCDP' is a CDP neighbour string for which we were not able to find a matching name in netbox, and it is then stored in netboxinfo (there it is used for correctly dealing with HP stacks IIRC). -- Kristian

1 0

missing FROM-clause entry for table netboxcategory
by morten.vold＠ntnu.no 19 Des '05

19 Des '05

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 19/12/2005 10:54, Perica Veljanovski uttered: > Thanks for taking the time mate! > postgresql-server-8.1.0 > postgresql-client-8.1.0 Ok, I don't know what changed from 8.0 to 8.1 - for all I know, it could be related to the default configuration installed in a FreeBSD package of PostgreSQL. I believe a quick work-around for your problem would be to edit your postgresql.conf and make sure the following line is present: add_missing_from = true - From the PostgreSQL manual: add_missing_from (boolean) When true, tables that are referenced by a query will be automatically added to the FROM clause if not already present. The default is true for compatibility with previous releases of PostgreSQL. However, this behavior is not SQL-standard, and many people dislike it because it can mask mistakes. Set to false for the SQL-standard behavior of rejecting references to tables that are not listed in FROM. I'll take a look into fixing the actual SQL query in NAV later. - -- 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 iD8DBQFDpoZAXxIl0kpcOkQRAl6lAKChOU9kOBhBmH/LSE8XcHGnm/KzlgCgxUFU kkmV6nVlgWdPxvBBMxS17oI= =8Qdh -----END PGP SIGNATURE----- >From perica at akton.com.mk Mon Dec 19 11:38:58 2005 From: perica at akton.com.mk (Perica Veljanovski) Date: Mon Dec 19 11:39:06 2005 Subject: [Nav-users] missing FROM-clause entry for table netboxcategory In-Reply-To: <43A68640.5020506(a)ntnu.no> Message-ID: <CARMENZIhTrBoe2U8QV00000126(a)carmen.akton.si> > -----Original Message----- > From: Morten Vold [mailto:morten.vold@ntnu.no] > Sent: Monday, December 19, 2005 11:07 > 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 19/12/2005 10:54, Perica Veljanovski uttered: > > > Thanks for taking the time mate! > > > postgresql-server-8.1.0 > > postgresql-client-8.1.0 > > Ok, I don't know what changed from 8.0 to 8.1 - for all I know, it could > be related to the default configuration installed in a FreeBSD package > of PostgreSQL. > > I believe a quick work-around for your problem would be to edit your > postgresql.conf and make sure the following line is present: > > add_missing_from = true > > - From the PostgreSQL manual: > > add_missing_from (boolean) > > When true, tables that are referenced by a query will be > automatically added to the FROM clause if not already present. The > default is true for compatibility with previous releases of PostgreSQL. > However, this behavior is not SQL-standard, and many people dislike it > because it can mask mistakes. Set to false for the SQL-standard behavior > of rejecting references to tables that are not listed in FROM. > > > > I'll take a look into fixing the actual SQL query in NAV later. > > - -- > 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 > > iD8DBQFDpoZAXxIl0kpcOkQRAl6lAKChOU9kOBhBmH/LSE8XcHGnm/KzlgCgxUFU > kkmV6nVlgWdPxvBBMxS17oI= > =8Qdh > -----END PGP SIGNATURE----- Thanks mate! You were right. add_missing_from is off by default in pgsql 8.1 This should solve a couple of my problems. I discovered a similar "missing FROM-clause entry" problem in the messages module. Anyway, you know how to look for it now ;) Thanks again. Perica Veljanovski

1 0

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