Matt Hall wrote:
Matt Hall wrote:
Matt Hall wrote:
try to:
stop nav psql manage delete from rrd_file where subsystem='cricket'; run makecricketconfig.pl as user navcron nav start
Done
, or macs, it appears data is not being collected. >
What is getDeviceData.log telling you?
Guess I am still getting that error:
Aug 08 14:38:01 2005 getDeviceData MAIN-5-INIT Running with 16 threads (max) Aug 08 14:38:01 2005 getDeviceData MAIN-3-INIT Could not connect to database!
This seems to look wrong, when I execute the nav startup script with a status command I get the following:
networkDiscovery: Up cricket: Up eventEngine does not seem to be running... logengine: Up maintengine: Up servicemon.py (pid 2039) is running... smsd.pl (pid 2050) is running... thresholdMon: Up mactrace: Up iptrace: Up safe_smsd: Up getDeviceData does not seem to be running... backup: Up pping.py (pid 2079) is running... Alertengine is running with process id 2089. It has been running for 0 minutes and 31 seconds.
Should I be worried that getDeviceData is no running?
My path is showing correctly now in the cron jobs...Yeah!!!
But I'm getting a notification from cron now that follows:
Subject: smsd database connection problem
Status: 08.08.2005 14:54:04 PG_conn=SCALAR(0x8175b44) 1 Reset
Error was: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.
I think I still have a path problem. I'm thinking the path still isn't getting sourced in the startup script correctly. Maybe I should change it from a bourne script to a bash script and use the "source" command.
Thanks for the help guys.
Matt _______________________________________________ Nav-users mailing list Nav-users@itea.ntnu.no http://mailman.itea.ntnu.no/mailman/listinfo/nav-users
Just as an FYI I gave up and symbolically linked everything into /usr/local/jdk1.4.2/jre/lib/ext. Things seem to be working now, but I'm worried that I'll have problem with other environmental variables not being set. Any freebsd people here have suggestions on how to globally export this? I tried /etc/profile, but that doesn't seem to work since it isn't running with a login prompt. Freebsd has no /etc/profile.d and the only other option I can think of is using bash instead of sh in my startup scripts so that I can use the "source" statement instead of just using a ".". I'm not sure if this will work.
One step closer, now that the symlinks are inSQLException for update statement: INSERT INTO swport (swportid,moduleid,port,ifindex,interface,link,speed,duplex,vlan,trunk) VALUES ('20','6','05','6','FastEthernet0/5','y','100','f','1','f') org.postgresql.util.PSQLException: This statement has been closed. at org.postgresql.jdbc2.AbstractJdbc2Statement.checkClosed(AbstractJdbc2Statement.java:2304)
atorg.postgresql.jdbc2.AbstractJdbc2Statement.getUpdateCount(AbstractJdbc2Statement.java:432)
atorg.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:268)
at no.ntnu.nav.Database.Database.update(Database.java:987) at no.ntnu.nav.Database.Database.insert(Database.java:911) atno.ntnu.nav.getDeviceData.dataplugins.Swport.SwportHandler.handleData(SwportHandler.java:217)
at DataContainersImpl.callDataHandlers(DataContainersImpl.java:64) at QueryNetbox.run(QueryNetbox.java:775)place I get SQL Exeptions in the getDeviceData-stderr.log:
Matt
Sorry, here is the proper cut and paste job:
One step closer, now that the symlinks are in place I get SQL Exeptions in the getDeviceData-stderr.log:
SQLException for update statement: INSERT INTO swport (swportid,moduleid,port,ifindex,interface,link,speed,duplex,vlan,trunk) VALUES ('20','6','05','6','FastEthernet0/5','y','100','f','1','f') org.postgresql.util.PSQLException: This statement has been closed. at org.postgresql.jdbc2.AbstractJdbc2Statement.checkClosed(AbstractJdbc2Statement.java:2304)
at org.postgresql.jdbc2.AbstractJdbc2Statement.getUpdateCount(AbstractJdbc2Statement.java:432)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:268)
at no.ntnu.nav.Database.Database.update(Database.java:987) at no.ntnu.nav.Database.Database.insert(Database.java:911) at no.ntnu.nav.getDeviceData.dataplugins.Swport.SwportHandler.handleData(SwportHandler.java:217)
at DataContainersImpl.callDataHandlers(DataContainersImpl.java:64) at QueryNetbox.run(QueryNetbox.java:775)
Matt
From arajgarh at iwu.edu Mon Aug 8 16:34:38 2005
From: arajgarh at iwu.edu (Aditya Rajgarhia) Date: Mon Aug 8 22:34:48 2005 Subject: [Nav-users] Can't add devices Message-ID: 966713.1123533278086.JavaMail.arajgarh@iwu.edu
I used to get those org.postgresql.jdbc2 errors. I messed with different versions of the jdbc postgresql drivers and it fixed those:
http://jdbc.postgresql.org/download.html
Put the jar file in the jre/lib/ext directory, try different versions maybe like I did.
------------------------------------------------------------------------ ----------------------------
SQLException for update statement: INSERT INTO swport (swportid,moduleid,port,ifindex,interface,link,speed,duplex,vlan,trunk) VALUES ('20','6','05','6','FastEthernet0/5','y','100','f','1','f') org.postgresql.util.PSQLException: This statement has been closed. at org.postgresql.jdbc2.AbstractJdbc2Statement.checkClosed(AbstractJdbc2Sta
tement.java:2304)
atorg.postgresql.jdbc2.AbstractJdbc2Statement.getUpdateCount(AbstractJdbc2
Statement.java:432)
atorg.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2S
tatement.java:268)
at no.ntnu.nav.Database.Database.update(Database.java:987) at no.ntnu.nav.Database.Database.insert(Database.java:911) atno.ntnu.nav.getDeviceData.dataplugins.Swport.SwportHandler.handleData(Sw
portHandler.java:217)
at
DataContainersImpl.callDataHandlers(DataContainersImpl.java:64)
at QueryNetbox.run(QueryNetbox.java:775)Matt _______________________________________________ Nav-users mailing list Nav-users@itea.ntnu.no http://mailman.itea.ntnu.no/mailman/listinfo/nav-users
---------------- Aditya Rajgarhia 305 Kemp Hall x2042 arajgarh@iwu.edu
From arajgarh at iwu.edu Mon Aug 8 16:36:37 2005
From: arajgarh at iwu.edu (Aditya Rajgarhia) Date: Mon Aug 8 22:36:42 2005 Subject: [Nav-users] NullPointerException Message-ID: 4556391.1123533397154.JavaMail.lumadmin@my.iwu.edu
I get this in the getDeviceData-stderr.log whenever it tries to get data. Any clue? THanks
java.lang.NullPointerException at no.ntnu.nav.getDeviceData.deviceplugins.StaticRoutes.StaticRoutes.proces sCiscoGw(StaticRoutes.java:261) at no.ntnu.nav.getDeviceData.deviceplugins.StaticRoutes.StaticRoutes.handle Device(StaticRoutes.java:127) at QueryNetbox.run(QueryNetbox.java:770)
---------------- Aditya Rajgarhia 305 Kemp Hall x2042 arajgarh@iwu.edu
From roar.pettersen at uib.no Tue Aug 9 09:21:41 2005
From: roar.pettersen at uib.no (Roar Pettersen) Date: Tue Aug 9 08:21:50 2005 Subject: [Nav-users] Can't add devices In-Reply-To: 42F7BAFF.9080506@newsstand.com References: 200508081944.j78JiHHW039752@duke.cc.uit.no 42F7B91F.4040502@newsstand.com 42F7BAFF.9080506@newsstand.com Message-ID: Pine.GSO.4.61.0508090819190.24379@alf.uib.no
Hello !
Any freebsd people here have suggestions on how to globally export this? I tried /etc/profile, but that doesn't seem to work since it isn't running with a login prompt. Freebsd has no /etc/profile.d and the only other option I can think of is using bash instead of sh in my startup scripts so that I can use the "source" statement instead of just using a ".". I'm not sure if this will work.
A good advise is to always use bash as shell and put the enviroment varibles in the eg .bash_profile :
cat /root/.bash_profile export PYTHONPATH=/usr/local/nav/lib/python export JAVA_HOME=/usr/local/jdk1.4.2 export PATH=$PATH:/usr/local/nav/bin:/usr/local/jdk1.4.2/bin export PERL5LIB=/usr/local/nav/lib/perl:/usr/local/cricket/cricket/lib export CLASSPATH="`echo /usr/local/nav/lib/java/*.jar | tr ' ' ':'`:/usr/local/share/java/classes/postgresql.jar:/usr/local/share/ja va/classes/snmp.jar"
-- Med vennlig hilsen / Regards;
Roar Pettersen Universitetet i Bergen - The University of Bergen Nygardsgt. 5 - N-5020 BERGEN - Norway Tlf: +47 55 58 40 55 VIP: 81503 fax: +47 55 58 40 70 roar.pettersen@it.uib.no - IT-Avd, UiB - http://www.uib.no
From Jan.Susegg at hint.no Tue Aug 9 10:10:54 2005
From: Jan.Susegg at hint.no (Susegg, Jan) Date: Tue Aug 9 09:08:54 2005 Subject: [Nav-users] Problems with getDeviceData Message-ID: 8A65B72C71E7484FBE1862045AAC5A8FB73B24@embla.ansatt.hint.no
Skipped content of type multipart/alternative
-
mhall＠newsstand.com