Nav-users Februar 2005

nav-users@lister.sikt.no

13 participants
18 discussions

SV: [Nav-users] problem with Syslog Analyzer
by peder.sefland＠hivolda.no 22 Feb '05

22 Feb '05

I'm also looking forward to a solution on this. I have config all my cisco-devices to send syslog to nav3. Peder Sefland >>> Wojciech Kozicki <woj(a)tstd.pl> 22.02.2005 11:06:50 >>> Hi, I am using Syslog Analyzer from NAV. I have /var/log/cisco.log file, where all logs from my cisco stuff are collected. Nav has got +w permission on that file. tail -f /var/log/cisco.log gives me all communicates. Afer while file is truncated - I think that NAV process gets to it. But - in NAV Syslog Analyzer I can see only few communicates, or no communicates. What should I check? best regards. -- Wojciech (Woj) Kozicki _______________________________________________ Nav-users mailing list Nav-users(a)itea.ntnu.no http://mailman.itea.ntnu.no/mailman/listinfo/nav-users >From kreide at online.no Wed Feb 23 01:26:49 2005 From: kreide at online.no (Kristian Eide) Date: Wed Feb 23 01:27:01 2005 Subject: [Nav-users] Several problems in beta10 In-Reply-To: <20050222104551.H42633(a)duke.cc.uit.no> References: <20050222104551.H42633(a)duke.cc.uit.no> Message-ID: <200502230126.54149.kreide(a)online.no> Skipped content of type multipart/mixed

1 0

Several problems in beta10
by Borge.Brunes＠cc.uit.no 22 Feb '05

22 Feb '05

getDeviceData: Having a cachingproblem? 01) a switch (3550-12G) running IOS v12.1 in NAV 02) the switch is removed from NAV. (getDeviceData UPDATE_DATA-5-UPDATE_NETBOXES 1 removed) 03) The switch is uppgraded to eg. IOS v12.2 something 04) inserted into NAV again. 05) the gDD collects info, but it says that the switch is still running IOS v12.1 The same happends when the switch is not removed/inserted More gDD-stuff: SQLException for update statement: INSERT INTO gwportprefix (gwportid,prefixid,gwip,hsrp) VALUES ('315','179','129.242.84.1','f') org.postgresql.util.PSQLException: ERROR: insert or update on table "gwportprefix" violates foreign key constraint "$1" alertengine(?): One box is down. The email is sent, but no sms (even if the smsd.log said it have been). The gammu-log is also emty. I'm able to send sms with the navcron user using gammu from the shell. Network explorer: I'm not able to browse some part of the tree. If i use the Device browser it's there. Device browser: On some switches it don't show any info (all ports are "white") regards, -- B?rge Brunes Running NAV on FreeBSD >From woj at tstd.pl Tue Feb 22 11:06:50 2005 From: woj at tstd.pl (Wojciech Kozicki) Date: Tue Feb 22 11:07:28 2005 Subject: [Nav-users] problem with Syslog Analyzer Message-ID: <200502221106.50315.woj(a)tstd.pl> Hi, I am using Syslog Analyzer from NAV. I have /var/log/cisco.log file, where all logs from my cisco stuff are collected. Nav has got +w permission on that file. tail -f /var/log/cisco.log gives me all communicates. Afer while file is truncated - I think that NAV process gets to it. But - in NAV Syslog Analyzer I can see only few communicates, or no communicates. What should I check? best regards. -- Wojciech (Woj) Kozicki >From peder.sefland at hivolda.no Tue Feb 22 11:43:12 2005 From: peder.sefland at hivolda.no (Peder Magne Sefland) Date: Tue Feb 22 11:43:22 2005 Subject: SV: [Nav-users] Several problems in beta10 Message-ID: <s21b1ad5.062(a)HVO-3.hivolda.no> alertengine(?): One box is down. The email is sent, but no sms (even if the smsd.log said it have been). The gammu-log is also emty. I'm able to send sms with the navcron user using gammu from the shell. I have experience something like this, when we wanted to make our own scripts with gammu. We where able to execute the script from shell, but not from a cron-job. The solution was given me from Bergen University. Gammu needed an exit or end code "\x04" When I added echo "\x04" into the TEXT that was going to gammu, it worked. But maybe this is something different. Peder Magne Sefland Avd. ingeni?r IT-avd. H?gskulen i Volda Postboks 500 6101 VOLDA 70075284 (kontor) 90823914 (mob.)

1 0

problems with getDeviceData (beta10)
by Ketil.Forselv＠hin.no 21 Feb '05

21 Feb '05

Hi I have a similar problem with our Catalyst 6509, and this is the main problem for me to get Nav3 Beta 10 function satisfactorily. Regards Ketil Susegg, Jan said: > > 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 > ******************************************************** > > > _______________________________________________ > Nav-users mailing list > Nav-users(a)itea.ntnu.no > http://mailman.itea.ntnu.no/mailman/listinfo/nav-users >

2 1

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

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

Nav-users Februar 2005