Nav-users

nav-users@lister.sikt.no

3 participants
1372 discussions

SV: RE: [Nav-users] vlan information from cisco switches
by peder.sefland＠hivolda.no 03 Mar '05

03 Mar '05

In my nav3beta10 (debian) every switch shows vlan information on ports, except on my two cisco 2980. model descr serial sw_ver hw_ver fw_ver WS-X2980GBRJ WS-X2980RJ 10/100BaseTx Ethernet Rev. 2.0 JAB05250BZH 5.5(18) 2.0 5.4(1) model descr serial sw_ver hw_ver fw_ver WS-X2980GBRJ WS-X2980GBRJ 10/100/1000 Ethernet Rev. 1.2 JAB061906WQ 6.3(5) 1.2 6.1(4) They are running CatOS, but my 5500 is also running CatOS and he is showing vlan information. This is the information from the web-page /report/swport?b1.netboxid=38 interface module port link Mbps duplex media trunk vlan portname 2/17 2 17 y 100.0 h 0 UPS-Strom snmp But the vlan information is collected, and I can find it tabell swport swportid | moduleid | ifindex | port | interface | link | speed | duplex | media | vlan | trunk | portname | to_netboxid | to_swportid ----------+----------+---------+------+-----------+------+-------+--------+-------+------+-------+----------------+-------------+------------- 12069 | 824 | 25 | 17 | 2/17 | y | 100 | h | | 10 | f | UPS-Strom snmp | | Any ideas? Peder Sefland >>> "Fredrik Holmberg" <fredrik.holmberg(a)luh.hihm.no> 15.02.2005 10:17:54 >>> NAV Beta 10: nav3:/usr/local/nav/etc/report # diff report.conf report.conf.old 432c432 < $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)"; Maybe this sorts it out :) - Fredrik -----Original Message----- From: nav-users-bounces(a)itea.ntnu.no [mailto:nav-users-bounces@itea.ntnu.no] On Behalf Of Wojciech Kozicki Sent: Tuesday, February 15, 2005 10:09 AM To: nav-users(a)desperados.itea.ntnu.no Subject: Re: [Nav-users] vlan information from cisco switches 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 _______________________________________________ Nav-users mailing list Nav-users(a)itea.ntnu.no http://mailman.itea.ntnu.no/mailman/listinfo/nav-users _______________________________________________ Nav-users mailing list Nav-users(a)itea.ntnu.no http://mailman.itea.ntnu.no/mailman/listinfo/nav-users

1 0

Several problems in beta10
by Borge.Brunes＠cc.uit.no 01 Mar '05

01 Mar '05

kreide(a)online.no said: >> Network explorer: >> I'm not able to browse some part of the tree. If i use >> the Device browser it's there. > > Can you give an example so I can debug this? Network explorer always starts > from the top and explores downward, thus the complete topology needs to be > present. Some missing topology is probably what is causing this problem. Seems that after I upgraded the switch browsing are working OK....but If I do a "Search in field IP" I got no hit. If I do the same search with "sysName" it works. >> Device browser: >> On some switches it don't show any info (all ports are "white") > > Example? Same solution as above: After an upgrade things are OK. Some more: Network discovery report (var/log/networkDiscovery/networkDiscovery-topology.html): (where do I find this report in the web-gui?) Some problem with the link between all(?) the routers eg: ERROR: Could not find record for other side of link! boks(31): asgvn-gsw.infra.uit.no Ifindex: 10101 boksBak: holt-gsw.infra.uit.no ERROR: Could not find record for other side of link! boks(47): mort-gsw.infra.uit.no Ifindex: 10101 boksBak: munin-gw.infra.uit.no This problem is also present in NAV v2. gDD: On the 3550 and 3750 a lot of these are found in the gDD-log: CGW_DEVHANDLER-4-CGW_MATCH-MODULE Module 0 does not exist on netbox beiva-gsw.infra.uit.no, default to 1 CGW_DEVHANDLER-4-CGW_MATCH-MODULE Module 0 does not exist on netbox beiva-gsw.infra.uit.no, default to 1 CGW_DEVHANDLER-4-CGW_MATCH-MODULE Supervisor not found and could not match module pattern to if: Loopback0 CGW_DEVHANDLER-4-CGW_MATCH-MODULE Supervisor not found and could not match module pattern to if: Vlan167 CGW_DEVHANDLER-4-CGW_MATCH-MODULE Supervisor not found and could not match module pattern to if: Vlan202 CGW_DEVHANDLER-4-CGW_MATCH-MODULE Supervisor not found and could not match module pattern to if: Vlan203 CGW_DEVHANDLER-4-CGW_MATCH-MODULE Supervisor not found and could not match module pattern to if: Vlan204 CGW_DEVHANDLER-4-CGW_MATCH-MODULE Supervisor not found and could not match module pattern to if: Vlan221 CGW_DEVHANDLER-4-CGW_MATCH-MODULE Supervisor not found and could not match module pattern to if: Vlan703 CGW_DEVHANDLER-4-CGW_MATCH-MODULE Supervisor not found and could not match module pattern to if: Vlan805 CGW_DEVHANDLER-4-CGW_MATCH-MODULE Supervisor not found and could not match module pattern to if: Vlan848 CGW_DEVHANDLER-4-CGW_MATCH-MODULE Supervisor not found and could not match module pattern to if: Vlan94 After moving a IP-net from one SVI to another: SQLException for update statement: INSERT INTO gwportprefix (gwportid,prefixid,gwip,hsrp) VALUES ('545','278','129.242.240.1','f') org.postgresql.util.PSQLException: ERROR: insert or update on table "gwportprefix" violates foreign key constraint "$2" regards, -- Borge Brunes, Computer Center, University of Tromso, Norway http://www.cc.uit.no/~borge/ | http://www.freebsd.org

1 0

cricket problem
by peder.sefland＠hivolda.no 01 Mar '05

01 Mar '05

I have nav3Beta10 (debian) up and running. But the cricket won't show anything execpt Name Description giga-router-interfaces Graphs for giga-router-interfaces giga-switch-ports Graphs for giga-switch-ports router-interfaces Graphs for router-interfaces routers Graphs for routers servers Graphs for servers switch-ports Graphs for switch-ports switches Graphs for switches When I click on any of these links, nothing comes up. Cricket is running, # /etc/init.d/nav status networkDiscovery: Up cricket: Up eventEngine (pid 875) is running... iptrace: Up maintengine: Up servicemon.py (pid 887) is running... smsd.pl (pid 903) is running... thresholdMon: Up mactrace: Up logengine: Up safe_smsd: Up getDeviceData (pid 909) is running... backup: Up pping.py (pid 918) is running... Alertengine is running with process id 932. It has been running for 3 hours and 7 minutes. And I can see that cricket is collecting data. /var/lib/nav/rrd/volda-berte-spraaklab-sw.hivolda.no.rrd /var/lib/nav/rrd/volda-berte-sw2.hivolda.no.rrd /var/lib/nav/rrd/volda-berte-sw3.hivolda.no.rrd /var/lib/nav/rrd/volda-berte-sw4.hivolda.no.rrd /var/lib/nav/rrd/volda-berte-sw5.hivolda.no.rrd ........................ I follow the instructions for installation in the README.Debian Any suggestion what could be wrong? Peder Sefland

1 0

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

Jump to page:

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

Nav-users