Nav-users

nav-users@lister.sikt.no

3 participants
1372 discussions

java.sql.SQLException: ERROR
by Jan.Susegg＠hint.no 18 Okt '05

18 Okt '05

Can anyone tell me why I receive the error message: SQLException while posting alert: java.sql.SQLException: ERROR: More than one tuple returned by a subselect used as an expression in my eventEngine.log. The only alerts I receive is software and firmware changes and not box down or anything else. Okt 18 08:45:53 2005 eventEngine BOX_STATE_EVENTHANDLER-6-CALLBACK Alert processing done, processed 1, queue size 34 Okt 18 08:45:53 2005 eventEngine BOX_STATE_EVENTHANDLER-6-CALLBACK Box down: 158.38.xx.xx Okt 18 08:45:53 2005 eventEngine BOX_STATE_EVENTHANDLER-6-CALLBACK Added alert: e=7731 d=222 n=117 t=boxState s=x [status=down] Okt 18 08:45:53 2005 eventEngine DEV_DB-6-POSTALERT Posting alert: e=7731 d=222 n=117 t=boxState s=x [status=down] Okt 18 08:45:53 2005 eventEngine DEV_DB-6-POSTALERT SQLException while posting alert: java.sql.SQLException: ERROR: More than one tuple returned by a subselect used as an expression. Okt 18 08:45:53 2005 eventEngine BOX_STATE_EVENTHANDLER-4-CALLBACK While posting netel down alert, PostAlertException: Got SQLException: ERROR: More than one tuple returned by a subselect used as an expression. Okt 18 08:45:53 2005 eventEngine BOX_STATE_EVENTHANDLER-6-HANDLE Scheduling callback in 883 ms (0 s) Okt 18 08:45:53 2005 eventEngine BOX_STATE_EVENTHANDLER-6-CALLBACK Alert processing done, processed 1, queue size 34 >From kreide at gmail.com Tue Oct 18 01:16:43 2005 From: kreide at gmail.com (Kristian Eide) Date: Tue Oct 18 09:16:48 2005 Subject: [Nav-users] java.sql.SQLException: ERROR In-Reply-To: <8A65B72C71E7484FBE1862045AAC5A8FB73BC2(a)embla.ansatt.hint.no> References: <8A65B72C71E7484FBE1862045AAC5A8FB73BC2(a)embla.ansatt.hint.no> Message-ID: <b4c110fd0510180016ud40dff9l3c8fbb736c7d2662(a)mail.gmail.com> > Can anyone tell me why I receive the error message: SQLException while > posting alert: java.sql.SQLException: ERROR: More than one tuple > returned by a subselect used as an expression in my eventEngine.log. The Yes, this is most likely caused by too many entries in the alerttype table. My suggestion would be to delete all entries from that table and re-run the INSERT statements from manage.sql. -- Kristian

1 0

Beginner problem
by silvije.milisic＠carnet.hr 17 Okt '05

17 Okt '05

Hi! I am new to NAV! I have installed it from debian package. I did some database seeding and i get SNMP data from router, but: 1. I dont get any Statistics 2. When I click in Network explorer on my router icon I get Mod_python error: "PythonHandler nav.web.devBrowser.dispatcher" Traceback (most recent call last): File "/usr/lib/python2.3/site-packages/mod_python/apache.py", line 287, in HandlerDispatch log=debug) File "/usr/lib/python2.3/site-packages/mod_python/apache.py", line 457, in import_module module = imp.load_module(mname, f, p, d) File "/usr/lib/python2.3/site-packages/nav/web/devBrowser/dispatcher.py", line 33, in ? import profile ImportError: No module named profile and 3. Traffic Map does not draw anything, I just get Java loading icon Please some hint ;) Thanx, Silvije >From Vidar.Faltinsen at uninett.no Mon Oct 10 16:25:15 2005 From: Vidar.Faltinsen at uninett.no (Vidar Faltinsen) Date: Mon Oct 10 15:25:57 2005 Subject: [Nav-users] Minor bug user account Message-ID: <Pine.LNX.4.63.0510101511400.1560(a)valentin.uninett.no> Morten, In the user admin tool when you add a new user, a slightly confusing thing happens. Say I am logged in as faltin with administative privilege. Then I create the account joe, and fill in full name and password and submits. On the following page the login: is replaced with faltin, not joe... So it _looks_ as if I am altering my own user account instead of creating the new account for joe. bug? ho-ho - Vidar >From odd.hauge at hiMolde.no Mon Oct 10 17:39:50 2005 From: odd.hauge at hiMolde.no (Hauge Odd Arne) Date: Mon Oct 10 16:39:57 2005 Subject: [Nav-users] Alertengine Message-ID: <8EEE7738AEDF6947B3E5508A0244D1C26A09B5(a)stam.himolde.no> Hi. I cannot start AlertEngine. Seems like some problem with the Pg library on my installation. The error message in the logfile is: Uncaught exception from user code: DBD::Pg initialisation failed: Can't locate object method "driver" via package "DBD::Pg" at /usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi/DBI.pm line 747. Perhaps the capitalisation of DBD 'Pg' isn't right. at /usr/lib/perl5/site_perl/5.8.6/NAV/AlertEngine/Engine.pm line 53 at /usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi/DBI.pm line 753 DBI::install_driver('DBI', 'Pg') called at /usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi/DBI.pm line 573 DBI::connect('DBI', 'dbi:Pg:dbname=navprofiles;host=\'localhost\'', 'navwrite', 'some-password', 'undef') called at /usr/lib/perl5/site_perl/5.8.6/NAV/AlertEngine/Engine.pm line 53 NAV::AlertEngine::Engine::new('NAV::AlertEngine::Engine', 'HASH(0x8d40074)') called at ./alertengine.pl line 31 Cheking if DBD:PG is installed: # perl -MCPAN -e 'install DBD::Pg' CPAN: Storable loaded ok Going to read /root/.cpan/Metadata Database was generated on Thu, 30 Jun 2005 00:00:19 GMT DBD::Pg is up to date. Any suggestion anyone ? - odd arne hauge

2 1

Vlan problems, traffic map, network explorer
by allmanj＠cp.dias.ie 13 Okt '05

13 Okt '05

Hi - i'm having two problems, which i suspect are related. I have just installed nav (debian package, version 2+3.0rc1-3) and set it up according to the docs. I have added our router and a few of our switches to the database but when i visit the traffic map, all i see is the router. Ditto for the network explorer. What exactly is required for devices to show up? I then noticed that it wasn't picking up the vlans correctly when i looked in reports. They're all set to blank. I've added one router which is a cisco 7204vxr, one cisco 2900 switch and one dell Powerconnect 5224 switch. Based on previous posts, i looked in the swport table in the manage database and can confirm that it has picked up the correct vlans from one of our switches at least. getBoksMacs.log contains lines like these: Oct 13 16:10:03 2005 getBoksData_01 QUERY_NETBOX-6-MAC_ENTRY Missing swportid for ifindex 25 on boks: cisco0 Oct 13 16:10:03 2005 getBoksData_01 QUERY_NETBOX-6-MAC_ENTRY Querying vlan: 1, MACs: 56 Mappings: 22 Blocked: 0 / 1 Oct 13 16:10:03 2005 getBoksData_01 QUERY_NETBOX-6-MAC_ENTRY Fetching vlan: 2 It has lines like that for all of our vlans. I'm more than willing to dig through logs and show you anything relevant. I really like the look of nav and want to be able to use it properly. Anything you can do to help would be greatly appreciated. Thanks, John Allman >From Vidar.Faltinsen at uninett.no Mon Oct 17 11:40:43 2005 From: Vidar.Faltinsen at uninett.no (Vidar Faltinsen) Date: Mon Oct 17 10:40:49 2005 Subject: [Nav-users] machine tracker In-Reply-To: <2870BA02E1D7E14CA524C38AD06CAB7713593F(a)mailit.northwood.edu> References: <2870BA02E1D7E14CA524C38AD06CAB7713593F(a)mailit.northwood.edu> Message-ID: <Pine.LNX.4.63.0510171035540.9230(a)valentin.uninett.no> On Sun, 9 Oct 2005, Kimalat, Kipngetich wrote: > hello, > i have just installed NAV 3.0 and whats steps are there to use the machine tracker? I am not sure where you are in the post-install process; but you need to seed the NAV database, of course. More info on http://metanav.ntnu.no/moin.cgi/SeedEssentials After you have given necessary seed info on your routers and switches, gDD (getDeviceData) will start to collect information from the devices. The arp logger and cam logger will in turn collect and store arp and cam data. With this in place you can use the machine tracker to track live and historical data regarding an ip address and in turn (or directly) a mac address. Hope this answers your question. best regards - Vidar

1 0

Over 100% used ip-addresses
by peder.sefland＠hivolda.no 13 Okt '05

13 Okt '05

When i click on the link "IP address scope - graphical view", in one of my subnet 114% of the ip-addresses are used. How is that possible? Maybe I should start to use IPv6 on this subnett :-) Peder Sefland

1 0

Installation of NAV 3.0.0 on CentOS 4.1
by roger.aas＠hsh.no 12 Okt '05

12 Okt '05

I have reworked the installation description for NAV 3.0.0 on Red Hat Enterprise Linux 4 AS Update 1 (phew, long name...) to include installing on CentOS 4.1. CentOS is a free version of RHEL and can be found here: http://www.centos.org/ I have also updated some of the packages to newer versions, most notably Java from 1.4.2 to 1.5.0 (after a recommendation from Kristian Eide) and Tomcat from 5.0.28 to 5.5.12. Same link as before: http://metanav.ntnu.no/moin.cgi/InstallingOnRHEL4 Regards, Roger -- Roger Aas Stord/Haugesund College

1 0

pping problem
by magnus＠ntnu.no 10 Okt '05

10 Okt '05

Borge Brunes: > pping is dying with the following message: > What could be wrong? Some exception-handling seem to have been removed... Try the attached patch, you should then get a entry in your log stating which host the pinger fails on. We can continue debug from there... -- Magnus Nordseth echo '[q]sa[ln0=aln256%Pln256/snlbx]sb3135071790101768542287578439snlbxq' | dc

1 0

Alertengine
by odd.hauge＠hiMolde.no 10 Okt '05

10 Okt '05

Problem solved. Downloaded the DBD::Pg library and reinstalled it. Sorrow bothering you. Cheers Odd Arne > -----Original Message----- > From: nav-users-bounces(a)itea.ntnu.no > [mailto:nav-users-bounces@itea.ntnu.no] On Behalf Of Hauge Odd Arne > Sent: Monday, October 10, 2005 4:40 PM > To: nav-users(a)itea.ntnu.no > Subject: [Nav-users] Alertengine > > Hi. > > I cannot start AlertEngine. Seems like some problem with the > Pg library on my installation. The error message in the logfile is: > Uncaught exception from user code: > DBD::Pg initialisation failed: Can't locate object > method "driver" via package "DBD::Pg" at > /usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi/DBI.p > m line 747. > > Perhaps the capitalisation of DBD 'Pg' isn't right. at > /usr/lib/perl5/site_perl/5.8.6/NAV/AlertEngine/Engine.pm line > 53 at > /usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi/DBI.pm line > 753 > DBI::install_driver('DBI', 'Pg') called at > /usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi/DBI.p > m line 573 > DBI::connect('DBI', > 'dbi:Pg:dbname=navprofiles;host=\'localhost\'', 'navwrite', > 'some-password', 'undef') called at > /usr/lib/perl5/site_perl/5.8.6/NAV/AlertEngine/Engine.pm line 53 > NAV::AlertEngine::Engine::new('NAV::AlertEngine::Engine', > 'HASH(0x8d40074)') called at ./alertengine.pl line 31 > > > Cheking if DBD:PG is installed: > > # perl -MCPAN -e 'install DBD::Pg' > CPAN: Storable loaded ok > Going to read /root/.cpan/Metadata > Database was generated on Thu, 30 Jun 2005 00:00:19 GMT > DBD::Pg is up to date. > > > Any suggestion anyone ? > > - odd arne hauge > > _______________________________________________ > Nav-users mailing list > Nav-users(a)itea.ntnu.no > http://mailman.itea.ntnu.no/mailman/listinfo/nav-users >

1 0

problems with eventengine
by Jan.Susegg＠hint.no 10 Okt '05

10 Okt '05

The eventEngine reports the following error message in eventEngine.log Okt 10 08:45:12 2005 eventEngine BOX_STATE_EVENTHANDLER-6-CALLBACK Added alert: e=7731 d=222 n=117 t=boxState s=x [status=down] Okt 10 08:45:12 2005 eventEngine DEV_DB-6-POSTALERT Posting alert: e=7731 d=222 n=117 t=boxState s=x [status=down] Okt 10 08:45:12 2005 eventEngine DEV_DB-6-POSTALERT SQLException while posting alert: java.sql.SQLException: ERROR: More than one tuple returned by a subselect used as an expression. Okt 10 08:45:12 2005 eventEngine BOX_STATE_EVENTHANDLER-4-CALLBACK While posting netel down alert, PostAlertException: Got SQLException: ERROR: More than one tuple returned by a subselect used as an expression. Okt 10 08:45:12 2005 eventEngine BOX_STATE_EVENTHANDLER-6-HANDLE Scheduling callback in 120587 ms (120 s) Does anyone know how to fix this? NAV doesn't report box down, but I know that I have a box down. >From Borge.Brunes at cc.uit.no Mon Oct 10 14:08:59 2005 From: Borge.Brunes at cc.uit.no (Borge Brunes) Date: Mon Oct 10 13:10:34 2005 Subject: [Nav-users] pping problem Message-ID: <200510101108.j9AB8xES002217(a)duke.cc.uit.no> pping is dying with the following message: [2005-10-09 11:25:24] pping.py:main:172 [Notice] 330 hosts checked in 9.957 secs. 1 hosts currently marked as down. Exception in thread sender: Traceback (most recent call last): File "/usr/local/lib/python2.4/threading.py", line 442, in __bootstrap self.run() File "/usr/local/lib/python2.4/threading.py", line 422, in run self.__target(*self.__args, **self.__kwargs) File "/usr/local/nav/lib/python/nav/statemon/megaping.py", line 261, in _sendRequests mySocket.sendto(packet, (host.ip, 0)) error: (64, 'Host is down') Exception in thread getter: Traceback (most recent call last): File "/usr/local/lib/python2.4/threading.py", line 442, in __bootstrap self.run() File "/usr/local/lib/python2.4/threading.py", line 422, in run self.__target(*self.__args, **self.__kwargs) File "/usr/local/nav/lib/python/nav/statemon/megaping.py", line 186, in _getResponses rd, wt, er = select.select([self._sock], [], [], timeout) error: (4, 'Interrupted system call') What could be wrong? -- Borge Brunes, Computer Center, University of Tromso, Norway http://www.cc.uit.no/~borge/ | http://www.freebsd.org

1 0

Bug "Report - Room search"
by Borge.Brunes＠cc.uit.no 10 Okt '05

10 Okt '05

There is a bug in the report "Reports - Room search". If I do a search? on my room tf2437 I got 24 hits The same (advanced) search? based on the report "All IP Devices" gives me 42 hits ?https://nav.uit.no/report/netbox2?roomid=tf2437&op_roomid=like ?https://nav.uit.no/report/netbox?op_roomid=like&adv=1&roomid=tf2437 Fix: use "netbox" instead of "netbox2" in the report. regards, -- Borge Brunes, Computer Center, University of Tromso, Norway http://www.cc.uit.no/~borge/ | http://www.freebsd.org

1 0

machine tracker
by kimalat＠northwood.edu 10 Okt '05

10 Okt '05

hello, i have just installed NAV 3.0 and whats steps are there to use the machine tracker? thanks kip

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