Nav-users

nav-users@lister.sikt.no

1376 discussions

Cisco 2900xl + ATM module
by woj＠tstd.pl 18 Feb '05

18 Feb '05

Hi, I have some question about NAV and support for new devices. There was already such topic, but I received suggestion to write some classes in Java to make NAV support new device. My question is - do NAV developers have plans to build some interface by which non-programmer user can add snmpoids for cricket, reports and so on. Maybe it is good idea to make some public database where nav-users can put plugins which supports new devices. Like I said, I have bunch of Alcatel stuff, which I also want to monitor via NAV. I added to NAV cisco catalyst 2900xl switch which has ATM module onboard. It would be nice to have some stats from this module... And another question - what about ATM - pvc support in NAV, are there any chances? best regards. -- Wojciech (Woj) Kozicki >From magnus at ntnu.no Fri Feb 18 16:36:24 2005 From: magnus at ntnu.no (Magnus Nordseth) Date: Fri Feb 18 16:36:26 2005 Subject: [Nav-users] Cisco 2900xl + ATM module In-Reply-To: <200502181504.32188.woj(a)tstd.pl> References: <200502181504.32188.woj(a)tstd.pl> Message-ID: <20050218153624.GA3120(a)stud.ntnu.no> Wojciech Kozicki: > I have some question about NAV and support for new devices. There was already > such topic, but I received suggestion to write some classes in Java to make > NAV support new device. > > My question is - do NAV developers have plans to build some interface by which > non-programmer user can add snmpoids for cricket, reports and so on. Maybe it > is good idea to make some public database where nav-users can put plugins > which supports new devices. Like I said, I have bunch of Alcatel stuff, which > I also want to monitor via NAV. We have discussed replacing the use of cricket and use our own framwork in java to collect statistics as well. Then it would be possible to register a new OID, and we will then be able to check which devices support it and start collecting statistics from it automagically. I'm not sure of the priority of this feature, but as alwys, feedback from all users is highly appreciated. Best regards, -- Magnus Nordseth echo '[q]sa[ln0=aln256%Pln256/snlbx]sb3135071790101768542287578439snlbxq' | dc >From kjetil.olsen at usit.uio.no Sat Feb 19 10:48:42 2005 From: kjetil.olsen at usit.uio.no (Kjetil Otter Olsen) Date: Sat Feb 19 10:48:46 2005 Subject: [Nav-users] Cisco 2900xl + ATM module In-Reply-To: <20050218153624.GA3120(a)stud.ntnu.no> References: <200502181504.32188.woj(a)tstd.pl> <20050218153624.GA3120(a)stud.ntnu.no> Message-ID: <1089.85.164.144.150.1108806522.squirrel(a)webmail.uio.no> On Fri, February 18, 2005 16:36, Magnus Nordseth said: > > We have discussed replacing the use of cricket and use our own framwork in > java to collect statistics as well. Then it would be possible to register a > new OID, and we will then be able to check which devices support it and > start collecting statistics from it automagically. I think this is a great idea! We would even be willing to assist in such a development, one way or another. --Kjetil

1 0

problems with getDeviceData (beta10)
by Jan.Susegg＠hint.no 17 Feb '05

17 Feb '05

I have some problems with getDeviceData. It stops collecting/deletes GWP data on some routers after getBoksMacs.sh has run. If I restart getDeviceData it works ok for a new hour until getBoksMacs.sh runs again. Running beta10. Feb 17 09:20:55 2005 xxxx-gw.uninett.no_13 CGW_DEVHANDLER-4-CGW_MATCH-MODULE Supervisor not found and could not match module pattern to if: Loopback0 Feb 17 09:20:55 2005 xxxx-gw.uninett.no_13 CGW_DEVHANDLER-4-CGW_MATCH-MODULE No module match from interf, defaulting to module 0 Feb 17 09:20:55 2005 xxxx-gw.uninett.no_13 CGW_DEVHANDLER-4-CGW_MATCH-MODULE Supervisor not found and could not match module pattern to if: Loopback1 Feb 17 09:20:55 2005 xxxx-gw.uninett.no_13 CGW_DEVHANDLER-4-CGW_MATCH-MODULE No module match from interf, defaulting to module 0 Feb 17 09:21:21 2005 xxxxxx-gsw.hint.no_09 GwportHandler-3-HANDLE SQLException: ERROR: $2 referential integrity violation - key referenced from gwportpre fix not found in prefix Feb 17 09:29:16 2005 xxxxxx-gsw.hint.no_02 ServerPlugin-6-canHandleDevice We cannot serve xxxxxx-gsw.hint.no Feb 17 09:21:23 2005 xxx-gw.uninett.no_05 CGW_DEVHANDLER-4-CGW_MATCH-MODULE Supervisor not found and could not match module pattern to if: Vlan10 Feb 17 09:21:23 2005 xxx-gw.uninett.no_05 CGW_DEVHANDLER-4-CGW_MATCH-MODULE Supervisor not found and could not match module pattern to if: Vlan15 Feb 17 09:21:23 2005 xxx-gw.uninett.no_05 CGW_DEVHANDLER-4-CGW_MATCH-MODULE Supervisor not found and could not match module pattern to if: Vlan20 Feb 17 09:21:23 2005 xxx-gw.uninett.no_05 CGW_DEVHANDLER-4-CGW_MATCH-MODULE Supervisor not found and could not match module pattern to if: Vlan30 Feb 17 09:21:23 2005 xxx-gw.uninett.no_05 CGW_DEVHANDLER-4-CGW_MATCH-MODULE Supervisor not found and could not match module pattern to if: Vlan32 Feb 17 09:21:23 2005 xxx-gw.uninett.no_05 CGW_DEVHANDLER-4-CGW_MATCH-MODULE Supervisor not found and could not match module pattern to if: Loopback0 Feb 17 09:21:23 2005 xxx-gw.uninett.no_05 SRT_DEVHANDLER-6-ROUTE_DEST Routes is now empty ******************************************************** Jan Susegg F?rstekonsulent, IT-tjenesten H?gskolen i Nord-Tr?ndelag R?stad 7600 LEVANGER tlf: 74022711 mob: 91184451 ********************************************************

1 0

Release-notice: NAV 3.0 beta 10
by werner＠usit.uio.no 16 Feb '05

16 Feb '05

On Mon, Feb 14, 2005 at 09:12:12AM +0100, Wojciech Kozicki wrote: > > > NAV 3.0 beta 10 is now available download at http://metanav.ntnu.no/ . > > > > And a Debian-package is built and is available here: > > > > http://skolelinux.no/~werner/debian/pool/unstable/n/nav/ > > > > I have not tested this package, nor included the database upgrade as > > part of the package, so you'll have to upgrade the database > > yourselves. > > ok, where I will found necessary sql statements? Upstream forgot to include it in doc/Makefile.in, but I made a small patch and built a new debian-package which include the sql-upgrade file in /usr/share/doc/nav/sql/upgrades/ . - Werner >From werner at skolelinux.no Mon Feb 14 11:41:37 2005 From: werner at skolelinux.no (Morten Werner Olsen) Date: Wed Feb 16 08:40:13 2005 Subject: [Nav-users] Release-notice: NAV 3.0 beta 10 In-Reply-To: <42107EA6.4050406(a)ntnu.no> References: <420CC263.1050801(a)ntnu.no> <20050212151136.GA11338(a)debra.uio.no> <200502140912.13019.woj(a)tstd.pl> <42107EA6.4050406(a)ntnu.no> Message-ID: <20050214104137.GC3072(a)lillehjelper.wcc.no> On Mon, Feb 14, 2005 at 11:34:14AM +0100, Morten Vold wrote: > >> I have not tested this package, nor included the database upgrade > >> as part of the package, so you'll have to upgrade the database > >> yourselves. > > ok, where I will found necessary sql statements? > > I don't know where Morten Werner's Debian package puts it, but you can > find it here (from the Subversion repository): The file is located in /usr/share/doc/nav/sql/updates/ together with the README-file. - Werner >From Borge.Brunes at cc.uit.no Thu Feb 17 08:59:13 2005 From: Borge.Brunes at cc.uit.no (Borge Brunes) Date: Thu Feb 17 08:59:31 2005 Subject: [Nav-users] Problem with eventEngine Message-ID: <20050217085447.W53178(a)duke.cc.uit.no> [running beta10] I'm getting tons of these messages in the eventEngine.log: eventEngine EVENTQ_MONITOR_TASK-3-RUN SQLException when fetching from eventq: Operation requires a scrollable ResultSet, but this ResultSet is FORWARD_ONLY. Does anyone have a clue what this means, and maybe have a solution? -- B?rge Brunes Univ. of Troms? >From morten.vold at ntnu.no Thu Feb 17 09:21:53 2005 From: morten.vold at ntnu.no (Morten Vold) Date: Thu Feb 17 09:21:54 2005 Subject: [Nav-users] report-errors In-Reply-To: <20050214144223.A409A13C5EB(a)merke.itea.ntnu.no> References: <20050214144223.A409A13C5EB(a)merke.itea.ntnu.no> Message-ID: <42145421.2070603(a)ntnu.no> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Fredrik Holmberg wrote: > Here's another tough nut to crack for ya :) Oops, sorry for overlooking this one :) > When I edit/add an IP device using "Edit database", after supplying ip, cat, > community, room and organization, pressing "Continue" or "Update" causes NAV > beta 10 to return: > Error: psycopg.ProgrammingError: ERROR: permission denied for relation > snmpoid select snmpoid from snmpoid where oidkey='typeoid' That's rather strange. Edit Database uses the navwrite account to access the NAVdb, and there is no reason this account should've had its write access revoked from the snmpoid table during the upgrade to beta10. Are you sure this message was absent when running beta9 and earlier? Anyway, you can try to reset the privileges for the navread and navwrite users by issuing the following SQL statements after connecting to the manage database ("psql manage"): SELECT nav_grant('navread', false); SELECT nav_grant('navwrite', true); These two are also part of manage.sql, which initializes the manage database on your first install. They invoke a stored procedure, which is part of the manage database - a procedure that grants rights to all the objects in the database (tables, views and sequences). - -- Morten Vold NTNU ITEA Integrasjonsgruppen -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCFFQhXxIl0kpcOkQRAqCHAKDRhf7oMacbXCiSEJW7dkbfm2qwOACfZXpR AaAqNG25qaYnQXsXkLAOdPw= =7ZRo -----END PGP SIGNATURE----- >From morten.vold at ntnu.no Thu Feb 17 09:23:23 2005 From: morten.vold at ntnu.no (Morten Vold) Date: Thu Feb 17 09:23:42 2005 Subject: [Nav-users] Problem with eventEngine In-Reply-To: <20050217085447.W53178(a)duke.cc.uit.no> References: <20050217085447.W53178(a)duke.cc.uit.no> Message-ID: <4214547B.8020909(a)ntnu.no> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Borge Brunes wrote: > I'm getting tons of these messages in the eventEngine.log: > eventEngine EVENTQ_MONITOR_TASK-3-RUN SQLException when fetching from > eventq: Operation requires a scrollable ResultSet, but this ResultSet is > FORWARD_ONLY. > > Does anyone have a clue what this means, and maybe have a solution? Not that I really know any of the code of the Event Engine, but I would ask which versions of the PostgreSQL server and the PostgreSQL JDBC driver you have installed? - -- Morten Vold NTNU ITEA Integrasjonsgruppen -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCFFR7XxIl0kpcOkQRAjI+AJ9V+dcFiJCfkKmYc61CpUBub5J77QCfdN6K yXN+YRom+H9V9aOpHpmzeT4= =5wBr -----END PGP SIGNATURE----- >From Borge.Brunes at cc.uit.no Thu Feb 17 09:32:19 2005 From: Borge.Brunes at cc.uit.no (Borge Brunes) Date: Thu Feb 17 09:32:30 2005 Subject: [Nav-users] Problem with eventEngine In-Reply-To: <4214547B.8020909(a)ntnu.no> References: <20050217085447.W53178(a)duke.cc.uit.no> <4214547B.8020909(a)ntnu.no> Message-ID: <20050217093107.X53336(a)duke.cc.uit.no> Hei Morten, On Thu, 17 Feb 2005, Morten Vold wrote: > Not that I really know any of the code of the Event Engine, but I would > ask which versions of the PostgreSQL server and the PostgreSQL JDBC > driver you have installed? postgresql-server-7.4.7 postgresql-jdbc-8.0.310 B?rge >From morten.vold at ntnu.no Thu Feb 17 09:51:50 2005 From: morten.vold at ntnu.no (Morten Vold) Date: Thu Feb 17 09:51:49 2005 Subject: [Nav-users] Problem with eventEngine In-Reply-To: <20050217093107.X53336(a)duke.cc.uit.no> References: <20050217085447.W53178(a)duke.cc.uit.no> <4214547B.8020909(a)ntnu.no> <20050217093107.X53336(a)duke.cc.uit.no> Message-ID: <42145B26.7050304(a)ntnu.no> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Borge Brunes wrote: > postgresql-server-7.4.7 > postgresql-jdbc-8.0.310 Ok, I would, first of all, recommend that you try a JDBC driver matching the version of your server, i.e. the latest 7.4 version (although the website jdbc.postgresql.org suggest that newer versions of the driver may work with older versions of the server). Probably more important is what JDBC version your JDBC driver was made for. At http://jdbc.postgresql.org/ you can choose between drivers adhering to JDBC 1, 2 or 3. I don't think JDBC1 supports scrolling result sets, so you should at least download the JDBC2-version of the driver. - -- Morten Vold NTNU ITEA Integrasjonsgruppen -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCFFslXxIl0kpcOkQRAk+lAKDfcV8j8XFgOE8jNhwqJSbtluW7SgCfTQdI hBMr+8XBnSZc0v42x9m84G8= =Pz8e -----END PGP SIGNATURE----- >From fredrik.holmberg at luh.hihm.no Thu Feb 17 12:33:45 2005 From: fredrik.holmberg at luh.hihm.no (Fredrik Holmberg) Date: Thu Feb 17 12:33:55 2005 Subject: [Nav-users] report-errors In-Reply-To: <42145421.2070603(a)ntnu.no> Message-ID: <20050217113353.4EFDA66DF4(a)royk.itea.ntnu.no> Thanks! Those two SQL statements solved it. The error-message appeared after upgrading to Beta 10 from Beta 9.. Regards, Fredrik Holmberg -----Original Message----- From: Morten Vold [mailto:morten.vold@ntnu.no] Sent: Thursday, February 17, 2005 9:22 AM To: Fredrik Holmberg Cc: nav-users(a)itea.ntnu.no Subject: Re: [Nav-users] report-errors -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Fredrik Holmberg wrote: > Here's another tough nut to crack for ya :) Oops, sorry for overlooking this one :) > When I edit/add an IP device using "Edit database", after supplying ip, cat, > community, room and organization, pressing "Continue" or "Update" causes NAV > beta 10 to return: > Error: psycopg.ProgrammingError: ERROR: permission denied for relation > snmpoid select snmpoid from snmpoid where oidkey='typeoid' That's rather strange. Edit Database uses the navwrite account to access the NAVdb, and there is no reason this account should've had its write access revoked from the snmpoid table during the upgrade to beta10. Are you sure this message was absent when running beta9 and earlier? Anyway, you can try to reset the privileges for the navread and navwrite users by issuing the following SQL statements after connecting to the manage database ("psql manage"): SELECT nav_grant('navread', false); SELECT nav_grant('navwrite', true); These two are also part of manage.sql, which initializes the manage database on your first install. They invoke a stored procedure, which is part of the manage database - a procedure that grants rights to all the objects in the database (tables, views and sequences). - -- Morten Vold NTNU ITEA Integrasjonsgruppen -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCFFQhXxIl0kpcOkQRAqCHAKDRhf7oMacbXCiSEJW7dkbfm2qwOACfZXpR AaAqNG25qaYnQXsXkLAOdPw= =7ZRo -----END PGP SIGNATURE-----

1 0

vlan information from cisco switches
by woj＠tstd.pl 15 Feb '05

15 Feb '05

Dnia wtorek, 15 lutego 2005 10:19, Fredrik Holmberg napisa?: > I forgot to include NAV Beta 9: > > nav3:~ # diff /usr/local/nav/etc/report/report.conf > /usr/local/src/nav-3.0_beta9/subsystem/report/src/report.conf > 370c370 > < $sql="SELECT b1.sysname,s1.interface, m1.module, s1.port, s1.link, > s1.speed, s1.duplex, s1.media, s1.trunk, vlan.vlan,s1.portname, b2.sysname > as to_netboxid,m2.module AS remote_module, s1.swportid, b1.netboxid as > netboxid, b1.catid FROM swport AS s1 JOIN module AS m1 USING (moduleid) > JOIN netbox AS b1 USING (netboxid) LEFT JOIN netbox AS b2 ON > (to_netboxid=b2.netboxid) LEFT JOIN swportvlan ON > (s1.swportid=swportvlan.swportid AND trunk='f') left join vlan using(vlan) > LEFT JOIN swport AS s2 ON (s1.to_swportid=s2.swportid) LEFT JOIN module AS > m2 ON (s2.moduleid=m2.moduleid)"; > --- > > > $sql="SELECT b1.sysname,s1.interface, m1.module, s1.port, s1.link, > > s1.speed, s1.duplex, s1.media, s1.trunk, vlan.vlan,s1.portname, b2.sysname > as to_netboxid,m2.module AS remote_module, s1.swportid, b1.netboxid as > netboxid, b1.catid FROM swport AS s1 JOIN module AS m1 USING (moduleid) > JOIN netbox AS b1 USING (netboxid) LEFT JOIN netbox AS b2 ON > (to_netboxid=b2.netboxid) LEFT JOIN swportvlan ON > (s1.swportid=swportvlan.swportid AND trunk='f') left join vlan > using(vlanid) LEFT JOIN swport AS s2 ON (s1.to_swportid=s2.swportid) LEFT > JOIN module AS m2 ON (s2.moduleid=m2.moduleid)"; > > :) Ok, it worked :) > best regards -- Wojciech (Woj) Kozicki

1 0

vlan information from cisco switches
by woj＠tstd.pl 15 Feb '05

15 Feb '05

Dnia wtorek, 15 lutego 2005 10:03, Fredrik Holmberg napisa?: > Are you referring to "Report"? > It doesn't show VLAN when you view the switchports? > Yes, I meant "report"... > If this is the case, I might have a "fix" for you.. :) best regards -- Wojciech (Woj) Kozicki

2 1

report-errors
by fredrik.holmberg＠luh.hihm.no 15 Feb '05

15 Feb '05

A follow-up to the previous mail; this is what root@localhost receives in local mail-folder every hour: N229 root(a)nav3.hihm.no Tue Feb 15 09:10 51/3090 Cron <navcron@nav3> $BINDIR/getBoksMacs.sh $NUM_THREADS >From navcron(a)nav3.hihm.no Tue Feb 15 09:10:07 2005 X-Original-To: root@localhost Delivered-To: root(a)localhost.hihm.no From: root@localhost (Cron Daemon) To: root(a)localhost.hihm.no Subject: Cron <navcron@nav3> $BINDIR/getBoksMacs.sh $NUM_THREADS X-Cron-Env: <PERL5LIB=:/usr/local/nav/lib/perl> X-Cron-Env: <PYTHONPATH=:/usr/local/nav/lib/python> X-Cron-Env: <CLASSPATH=.:/usr/local/nav/lib/java/ConfigParser.jar:/usr/local/nav/lib/jav a/Database.jar:/usr/local/nav/lib/java/Event.jar:/us r/local/nav/lib/java/Logger.jar:/usr/local/nav/lib/java/NetboxInfo.jar:/usr/ local/nav/lib/java/SimpleSnmp.jar:/usr/local/nav/lib/java/Util.j ar:/usr/local/nav/lib/java/pg74.jar:/usr/local/nav/lib/java/snmp.jar> X-Cron-Env: <BINDIR=/usr/local/nav/bin> X-Cron-Env: <LOCALSTATEDIR=/usr/local/nav/var> X-Cron-Env: <MAILTO=root@localhost> X-Cron-Env: <CRICKETDIR=/usr/local/nav/cricket> X-Cron-Env: <NUM_THREADS=24> X-Cron-Env: <SHELL=/bin/sh> X-Cron-Env: <HOME=/usr/local/nav> X-Cron-Env: <PATH=/usr/bin:/bin> X-Cron-Env: <LOGNAME=navcron> Date: Tue, 15 Feb 2005 09:10:07 +0100 (CET) org.postgresql.util.PSQLException: ERROR: permission denied for relation snmpoid 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.j ava:517) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j ava:50) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statem ent.java:233) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statem ent.java:221) at no.ntnu.nav.Database.Database.query(Database.java:740) at no.ntnu.nav.Database.Database.query(Database.java:723) at getBoksMacs.main(getBoksMacs.java:372) Exception in thread "main" org.postgresql.util.PSQLException: ERROR: permission denied for relation snmpoid 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.j ava:517) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j ava:50) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statem ent.java:233) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statem ent.java:221) at no.ntnu.nav.Database.Database.query(Database.java:740) at no.ntnu.nav.Database.Database.query(Database.java:723) at getBoksMacs.main(getBoksMacs.java:372) I also tried restarting the server. Sincerely, Fredrik Holmberg -----Original Message----- From: nav-users-bounces(a)itea.ntnu.no [mailto:nav-users-bounces@itea.ntnu.no] On Behalf Of Fredrik Holmberg Sent: Monday, February 14, 2005 3:42 PM To: nav-users(a)itea.ntnu.no Subject: RE: [Nav-users] report-errors It worked! Here's another tough nut to crack for ya :) When I edit/add an IP device using "Edit database", after supplying ip, cat, community, room and organization, pressing "Continue" or "Update" causes NAV beta 10 to return: Error: psycopg.ProgrammingError: ERROR: permission denied for relation snmpoid select snmpoid from snmpoid where oidkey='typeoid' >From getDeviceData.log: ...... Feb 14 15:26:08 2005 getDeviceData PLUGIN_MONITOR-6-INIT Starting query scheduler Feb 14 15:26:08 2005 getDeviceData PLUGIN_MONITOR-3-UPDATE_TYPES SQLException: org.postgresql.util.PSQLException: ERROR: permission denied for relation snmpoid Feb 14 15:26:08 2005 getDeviceData PLUGIN_MONITOR-3-UPDATE_NETBOXES SQLException: org.postgresql.util.PSQLException: ERROR: permission denied for relation snmpoid Feb 14 15:26:08 2005 getDeviceData PLUGIN_MONITOR-5-UPDATE_NETBOXES Num netboxes: 0 (0 high, 0 new, 0 removed, 0 skipped, 0 runq, 0 active) ...... /var/log/postgresql: ..... 2005-02-14 15:26:08 ERROR: permission denied for relation snmpoid 2005-02-14 15:26:08 ERROR: permission denied for relation snmpoid ..... getBoksMacs.log: ..... OID db...Feb 14 15:10:01 2005 getBoksData null-5-INIT ============ getBoksData starting ============ Feb 14 15:10:01 2005 getBoksData null-5-INIT Running with 24 threads. watchMacs read: 0 Dumping data from tables... netboxmac...63 ms. boks...147 ms. swport...159 ms. swportblocked...70 ms. vlan...187 ms. swp_boks...13 ms. OID db... ..... - Fredrik Holmberg -----Original Message----- From: Morten Vold [mailto:morten.vold@ntnu.no] Sent: Monday, February 14, 2005 2:27 PM To: Fredrik Holmberg Cc: nav-users(a)itea.ntnu.no Subject: Re: [Nav-users] report-errors -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Fredrik Holmberg wrote: > Configuration error! The report generator is not able to do such > The same thing happens when I access "Routers" etc. > Installed the rpm and applied the sql-files. > Is there a "quick-fix" for this? :) Did you remember to restart Apache and Tomcat? You also need to enter the webapps directory of Tomcat and delete the vPServer and navAdmin directories before starting Tomcat over (to make sure that Tomcat is running the newest version of these NAV components). - -- Morten Vold NTNU ITEA Integrasjonsgruppen -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCEKc0XxIl0kpcOkQRAhNiAKDj7PCdcQLoGP2f31plkkEtk37AfgCfc0lS ND+73RWyxPG4ZYukPy/Wxcs= =xBUV -----END PGP SIGNATURE----- _______________________________________________ Nav-users mailing list Nav-users(a)itea.ntnu.no http://mailman.itea.ntnu.no/mailman/listinfo/nav-users

1 0

Cheetah upgrade may be necessary
by morten.vold＠ntnu.no 14 Feb '05

14 Feb '05

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 As previously discussed on nav-users, there seems to have been a problem in our Cheetah version which did not warn us properly of syntax errors in our Cheetah templates. Therefore, Cheetah was upgraded on our development server from version 0.9.15 to 0.9.16a2. Apparently, templates compiled with this version of Cheetah are not backwards-compatible with Cheetah 0.9.15, as we discovered when upgrading NAV on our "test production" server. If your NAV web interface crashes immediately and complains of Cheetah/template problems after upgrading NAV, you should make sure you have at least version 0.9.16a2 of Cheetah installed on your server. - -- Morten Vold NTNU ITEA Integrasjonsgruppen -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCEKQnXxIl0kpcOkQRAsjIAKDS0ULU0cRrZYxtIEEOYg9EViLTkQCgqRQ/ 2oClgJymTGEJnIXmHEE62CI= =EJqC -----END PGP SIGNATURE----- >From morten.vold at ntnu.no Mon Feb 14 14:27:16 2005 From: morten.vold at ntnu.no (Morten Vold) Date: Mon Feb 14 14:27:18 2005 Subject: [Nav-users] report-errors In-Reply-To: <20050214115720.326DB66CFE(a)royk.itea.ntnu.no> References: <20050214115720.326DB66CFE(a)royk.itea.ntnu.no> Message-ID: <4210A734.5040208(a)ntnu.no> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Fredrik Holmberg wrote: > Configuration error! The report generator is not able to do such > The same thing happens when I access "Routers" etc. > Installed the rpm and applied the sql-files. > Is there a "quick-fix" for this? :) Did you remember to restart Apache and Tomcat? You also need to enter the webapps directory of Tomcat and delete the vPServer and navAdmin directories before starting Tomcat over (to make sure that Tomcat is running the newest version of these NAV components). - -- Morten Vold NTNU ITEA Integrasjonsgruppen -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCEKc0XxIl0kpcOkQRAhNiAKDj7PCdcQLoGP2f31plkkEtk37AfgCfc0lS ND+73RWyxPG4ZYukPy/Wxcs= =xBUV -----END PGP SIGNATURE----- >From fredrik.holmberg at luh.hihm.no Mon Feb 14 15:42:18 2005 From: fredrik.holmberg at luh.hihm.no (Fredrik Holmberg) Date: Mon Feb 14 15:42:25 2005 Subject: [Nav-users] report-errors In-Reply-To: <4210A734.5040208(a)ntnu.no> Message-ID: <20050214144223.A409A13C5EB(a)merke.itea.ntnu.no> It worked! Here's another tough nut to crack for ya :) When I edit/add an IP device using "Edit database", after supplying ip, cat, community, room and organization, pressing "Continue" or "Update" causes NAV beta 10 to return: Error: psycopg.ProgrammingError: ERROR: permission denied for relation snmpoid select snmpoid from snmpoid where oidkey='typeoid' >From getDeviceData.log: .... Feb 14 15:26:08 2005 getDeviceData PLUGIN_MONITOR-6-INIT Starting query scheduler Feb 14 15:26:08 2005 getDeviceData PLUGIN_MONITOR-3-UPDATE_TYPES SQLException: org.postgresql.util.PSQLException: ERROR: permission denied for relation snmpoid Feb 14 15:26:08 2005 getDeviceData PLUGIN_MONITOR-3-UPDATE_NETBOXES SQLException: org.postgresql.util.PSQLException: ERROR: permission denied for relation snmpoid Feb 14 15:26:08 2005 getDeviceData PLUGIN_MONITOR-5-UPDATE_NETBOXES Num netboxes: 0 (0 high, 0 new, 0 removed, 0 skipped, 0 runq, 0 active) .... /var/log/postgresql: ... 2005-02-14 15:26:08 ERROR: permission denied for relation snmpoid 2005-02-14 15:26:08 ERROR: permission denied for relation snmpoid ... getBoksMacs.log: ... OID db...Feb 14 15:10:01 2005 getBoksData null-5-INIT ============ getBoksData starting ============ Feb 14 15:10:01 2005 getBoksData null-5-INIT Running with 24 threads. watchMacs read: 0 Dumping data from tables... netboxmac...63 ms. boks...147 ms. swport...159 ms. swportblocked...70 ms. vlan...187 ms. swp_boks...13 ms. OID db... ... - Fredrik Holmberg -----Original Message----- From: Morten Vold [mailto:morten.vold@ntnu.no] Sent: Monday, February 14, 2005 2:27 PM To: Fredrik Holmberg Cc: nav-users(a)itea.ntnu.no Subject: Re: [Nav-users] report-errors -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Fredrik Holmberg wrote: > Configuration error! The report generator is not able to do such > The same thing happens when I access "Routers" etc. > Installed the rpm and applied the sql-files. > Is there a "quick-fix" for this? :) Did you remember to restart Apache and Tomcat? You also need to enter the webapps directory of Tomcat and delete the vPServer and navAdmin directories before starting Tomcat over (to make sure that Tomcat is running the newest version of these NAV components). - -- Morten Vold NTNU ITEA Integrasjonsgruppen -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCEKc0XxIl0kpcOkQRAhNiAKDj7PCdcQLoGP2f31plkkEtk37AfgCfc0lS ND+73RWyxPG4ZYukPy/Wxcs= =xBUV -----END PGP SIGNATURE-----

1 0

Release-notice: NAV 3.0 beta 10
by morten.vold＠ntnu.no 14 Feb '05

14 Feb '05

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Wojciech Kozicki wrote: >> I have not tested this package, nor included the database upgrade >> as part of the package, so you'll have to upgrade the database >> yourselves. > ok, where I will found necessary sql statements? I don't know where Morten Werner's Debian package puts it, but you can find it here (from the Subversion repository): https://svn.nav.ntnu.no/nav/navme/tags/3.0_beta10/doc/sql/upgrades/3.0_beta… Also read https://svn.nav.ntnu.no/nav/navme/tags/3.0_beta10/doc/sql/upgrades/README if you haven't already :) - -- Morten Vold NTNU ITEA Integrasjonsgruppen -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCEH6mXxIl0kpcOkQRAoJFAKDIX2VIcfJDWiMmmLB03DPp92CWPQCfeih/ 5Qx2lWI3zXNo/YiLzH2sI7I= =MDh8 -----END PGP SIGNATURE----- >From woj at tstd.pl Mon Feb 14 12:36:25 2005 From: woj at tstd.pl (Wojciech Kozicki) Date: Mon Feb 14 12:37:00 2005 Subject: [Nav-users] vlan information from cisco switches Message-ID: <200502141236.26162.woj(a)tstd.pl> Hi, I reported it earlier, I have problem with getting info about vlans from cisco 2900XL and 2950 switches, even if there is simple config: vlan trunk server------switch-------router Cricket stats for switches, mac info, switchports raport - everything is working, but there is no vlan information. On routers I specified vlan info via nav-style descriptions and it worked - in router port report I have vlan info. I think, that nav-style descriptions for switches interfaces won't fix it? regards -- Wojciech (Woj) Kozicki >From fredrik.holmberg at luh.hihm.no Mon Feb 14 12:57:12 2005 From: fredrik.holmberg at luh.hihm.no (Fredrik Holmberg) Date: Mon Feb 14 12:57:24 2005 Subject: [Nav-users] report-errors Message-ID: <20050214115720.326DB66CFE(a)royk.itea.ntnu.no> After upgrading to beta 10 the following message appears when I access https://nav-server/report/netbox: Configuration error! The report generator is not able to do such things.ERROR: column "netboxid" does not exist SELECT roomid,sysname,ip,catid,sub,typeid,typename,orgid,netbox.up,modules,swport,g wport,'Mem',snmp,val AS Function,netbox.netboxid,prefixid FROM type RIGHT OUTER JOIN netbox USING (typeid) LEFT JOIN (SELECT netboxid,count(netboxid) AS gwport FROM gwport JOIN module USING (moduleid) GROUP BY netboxid) tempaggr1 USING (netboxid) LEFT JOIN (SELECT netboxid,count(netboxid) AS swport FROM swport JOIN module USING (moduleid) GROUP BY netboxid) tempaggr2 USING (netboxid) LEFT JOIN (SELECT netboxid,count(netboxid) AS modules FROM module GROUP BY netboxid) tempaggr3 USING (netboxid) LEFT JOIN (SELECT netboxid,count(netboxid) AS sub FROM netboxcategory GROUP BY netboxid) tempaggr4 USING (netboxid) LEFT JOIN (SELECT netboxid,count(netboxid) AS snmp FROM type GROUP BY netboxid) tempaggr1 USING (netboxid) LEFT JOIN (SELECT netboxid,count(netboxid) AS swport FROM swport JOIN module USING (moduleid) GROUP BY netboxid) tempaggr2 USING (netboxid) LEFT JOIN (SELECT netboxid,count(netboxid) AS modules FROM module GROUP BY netboxid) tempaggr3 USING (netboxid) LEFT JOIN (SELECT netboxid,count(netboxid) AS sub FROM netboxcategory GROUP BY netboxid) tempaggr4 USING (netboxid) LEFT JOIN (SELECT netboxid,count(netboxid) AS snmp FROM netboxsnmpoid GROUP BY netboxid) tempaggr5 USING (netboxid) LEFT JOIN netboxinfo ON (netbox.netboxid=netboxinfo.netboxid AND var='function') ORDER BY roomid LIMIT 100 OFFSET 0 The same thing happens when I access "Routers" etc. Installed the rpm and applied the sql-files. Is there a "quick-fix" for this? :) Regards, Fredrik Holmberg

1 0

adding cisco 2900XL switch to NAV
by woj＠tstd.pl 14 Feb '05

14 Feb '05

Hi, After adding another Cisco Catalyst 2900xl switch to NAV I get following error: --> Mod_python error: "PythonHandler editdb" Traceback (most recent call last): File "/usr/lib/python2.3/site-packages/mod_python/apache.py", line 299, in HandlerDispatch result = object(req) File "/var/www/nav/editdb/editdb.py", line 156, in handler output = editPage(req,pageList[table](),request,unicodeError) File "/var/www/nav/editdb/editdb.py", line 463, in editPage outputForm,action) File "/var/www/nav/editdb/editdb.py", line 2435, in add disabled=True)) TypeError: __init__() takes at least 2 non-keyword arguments (1 given) <-- One 2900xl is running in NAV, but I had to add new type, because NAV don't recognize these switches. When I am trying to add another 2900 switch, after clicking add I have: "Error: pysnmp.asn1.error.ValueConstraintError: Single value constraint for Version: 0 not within allowed values" then, clicking continue once again, I have proper recognize of type (because I added it earlier), but serial number is: "0x10". So, continue once again and... there is error which I quoted on top. Also - in beta9: - IP scope is not working, - Traffic Map crashes my FireFox sometimes, in Konqueror there is applet failed info. - still no desc for routers interfaces in Cricket - what about traffic measure in traffic map? I am using Debian packet of NAV best regards -- Wojciech (Woj) Kozicki >From woj at tstd.pl Fri Feb 11 11:15:42 2005 From: woj at tstd.pl (Wojciech Kozicki) Date: Fri Feb 11 11:16:14 2005 Subject: [Nav-users] adding cisco 2900XL switch to NAV Message-ID: <200502111115.42876.woj(a)tstd.pl> Dnia czwartek, 10 lutego 2005 08:31, Fredrik Holmberg napisa?: > nav3:~ # diff /usr/local/nav/cricket/cricket-config/router-interfaces/.nav > /usr/local/src/nav-3.0_beta9/subsystem/statTools/cricket/cricket-config/rou >t er-interfaces/.nav > 14c14 > < descr = select nettype,netident from gwportprefix left join prefix using > (prefixid) left join vlan using (vlanid) where gwportid=$id and netident is > not null > --- > > > descr = select nettype,netident from gwportprefix left join prefix > > using > > (prefixid) left join vlan using (vlan) where gwportid=$id and netident is > not null ok, I patched it and it worked! But. In Debian installation navcron user hasn't got bash (/bin/false only). When I gived bash to navcron user and started makecricketconfig.pl there where some access denied errors. But it worked after running makecricketconfig.pl as root. Another question. After adding new switch to nav, and running makecricketconfig.pl, when I should see first stats for this switch? I have some new switches in NAV, but I can't see them in cricket. best regards. -- Wojciech (Woj) Kozicki

2 4

Release-notice: NAV 3.0 beta 10
by morten.vold＠ntnu.no 12 Feb '05

12 Feb '05

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 NAV 3.0 beta 10 is now available download at http://metanav.ntnu.no/ . Upgrading from beta 8 ===================== Memory collection has been added, and requires a small update to the NAVdb schema. Please run 3.0_beta10.sql and snmpoid.sql from doc/sql/upgrades/ as documented in the README file of the same directory. CHANGES ======= Version 3.0_beta10 (released 11 February 2005) ##################################################################### ## WARNING WARNING WARNING WARNING WARNING WARNING WARNING ## ##################################################################### ## ## ## This release makes changes to the NAV database. If you are ## ## upgrading from a previous release you also need to upgrade your ## ## database schema. For information on how to upgrade the database ## ## schema, please take a look in doc/sql/upgrades for more ## ## information. ## ## ## ##################################################################### Improvements: * gDD now makes sure to give priority to new devices when its work load with old devices is high. * gDD now refers to IP Devices by sysname in its logs, making it easier to track its actions when reading the logs. * gDD now correctly updates the netident of elinks. * gDD will now also attempt to extract software version information from a device's sysDescr OID (also collects sw_ver for the device itself, and not just its modules). * A bug that prevented the service monitor's LDAP plugin from functioning from time to time was fixed. * Router ports that are administratively down are removed from NAVdb by gDD. * The report generator now supports multi-line and complex SQL queries. * The SQL queries of the netbox, gw, sw, edge and wlan reports were optimized for speed. Additions: * gDD will now collect memory information from devices. Be advised that I haven't had time to test this release, good luck! - -- Morten Vold NTNU ITEA Integrasjonsgruppen -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCDMJjXxIl0kpcOkQRAjpLAJ9/WKL/PYy33e4zb7Vfe1vnhAIO+gCgvZSJ CFtL8itSXRWK5LJoG7jWoiI= =kN/H -----END PGP SIGNATURE----- >From Ketil.Forselv at hin.no Fri Feb 11 18:36:31 2005 From: Ketil.Forselv at hin.no (Forselv Ketil) Date: Fri Feb 11 18:36:37 2005 Subject: SV: [Nav-users] Release-notice: NAV 3.0 beta 10 Message-ID: <4147C56944E2B64D978FA0EAB10A14FA4B0980(a)fagserver2.fag.hin.no> Hi I get compile-error for building getDeviceData when trying to compile source-code for Beta_10 (Redhat 9.0) Regards Ketil Building getDeviceData ... (cd getDeviceData && /usr/local/ant/bin//ant ) && touch getDeviceData Buildfile: build.xml init: [mkdir] Created dir: /root/beta10/nav-3.0_beta10/src/getDeviceData/build compile: [javac] Compiling 15 source files to /root/beta10/nav-3.0_beta10/src/getDeviceData/build [javac] /root/beta10/nav-3.0_beta10/src/getDeviceData/src/OidTester.java:76: cannot resolve symbol [javac] symbol : method setNetbox (java.lang.String) [javac] location: class no.ntnu.nav.logger.Log [javac] Log.setNetbox(nb.getSysname()); [javac] ^ [javac] /root/beta10/nav-3.0_beta10/src/getDeviceData/src/OidTester.java:286: cannot resolve symbol [javac] symbol : method setNetbox (<nulltype>) [javac] location: class no.ntnu.nav.logger.Log [javac] Log.setNetbox(null); [javac] ^ [javac] /root/beta10/nav-3.0_beta10/src/getDeviceData/src/QueryNetbox.java:720: cannot resolve symbol [javac] symbol : method setNetbox (java.lang.String) [javac] location: class no.ntnu.nav.logger.Log [javac] Log.setNetbox(sysName); [javac] ^ [javac] /root/beta10/nav-3.0_beta10/src/getDeviceData/src/QueryNetbox.java:849: cannot resolve symbol [javac] symbol : method setNetbox (<nulltype>) [javac] location: class no.ntnu.nav.logger.Log [javac] Log.setNetbox(null); [javac] ^ [javac] 4 errors BUILD FAILED /root/beta10/nav-3.0_beta10/src/getDeviceData/build.xml:62: Compile failed; see the compiler error output for details. Total time: 2 seconds make[1]: *** [getDeviceData] Error 1 make[1]: Leaving directory `/root/beta10/nav-3.0_beta10/src' make: *** [all] Error 1

2 1

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