Hi there. Having troubles with vlanplot on Nav 3beta8. Since everything seems to be working, no updates have been done to the installation. But the vlanplot-interface show error "an error occured fetching data from server:" when accessing lokal lans. Example: h**ps://nav.ingok.hitos.no/vlanPlot/ , and doubleklick on "158.39.19.1". Havent found any "boks" relations in any of the .sql-files from nav. Any tips? The tomcat gives this error: org.postgresql.util.PSQLException: ERROR: relation "boks" does not exist at org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139) at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:156) at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:101) at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43) at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement .java:517) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement .java:50) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Stat ement.java:233) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Stat ement.java:221) at no.ntnu.nav.Database.Database.query(Database.java:740) at no.ntnu.nav.Database.Database.query(Database.java:723) at SqlBoks.listBoks(vPServer.java:1243) at SqlBoks.serviceRequest(vPServer.java:129) at vPServer.service(vPServer.java:87) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicati onFilterChain.java:200) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilter Chain.java:146) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve. java:209) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.inv okeNext(StandardPipeline.java:596) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433 ) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve. java:144) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.inv okeNext(StandardPipeline.java:596) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433 ) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2358) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:1 33) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.inv okeNext(StandardPipeline.java:596) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValv e.java:118) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.inv okeNext(StandardPipeline.java:594) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:1 16) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.inv okeNext(StandardPipeline.java:594) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433 ) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.ja va:127) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.inv okeNext(StandardPipeline.java:596) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433 ) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processCon nection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.j ava:683) at java.lang.Thread.run(Thread.java:534) -Åge ########################################### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.F-Secure.com/
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Johnsen, ?ge Olai wrote:
But the vlanplot-interface show error "an error occured fetching data from server:" when accessing lokal lans. Example: h**ps://nav.ingok.hitos.no/vlanPlot/ , and doubleklick on "158.39.19.1".
Havent found any "boks" relations in any of the .sql-files from nav. Any tips?
As far as I know, this was fixed in 3.0 beta9 - Not all the functionality of the Traffic Map had been ported from NAV 2 to NAV 3 before this. Normally, I would recommend you upgrade to the latest beta, but since we've received reports of several disturbing bugs in this version, I suggest you wait for the imminent beta10. - -- Morten Vold NTNU ITEA Integrasjonsgruppen -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCB3VLXxIl0kpcOkQRAhRFAKDBixuuvlAvCTT5o5DnOWQDFW3RWACgmTd/ 5DYACC3ahr/d0/bz+McDiHE= =MErI -----END PGP SIGNATURE-----
From morten.vold at ntnu.no Mon Feb 7 15:12:23 2005 From: morten.vold at ntnu.no (Morten Vold) Date: Mon Feb 7 15:12:31 2005 Subject: [Nav-users] Deleting and refilling database In-Reply-To: <s1fa20b0.002@HVO-3.hivolda.no> References: <s1fa20b0.002@HVO-3.hivolda.no> Message-ID: <42077747.2080704@ntnu.no>
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Peder Magne Sefland wrote:
I have removed some switches end replaced them with some new. I also re-used the ip-address. This may have confused the Machine-tracker, I only get the data from the old switch.
Well, it shouldn't confuse the Machine Tracker; had you supplied a few examples of what you are doing, maybe we can tell you what's going on.
What are the postgresql-syntax for deleting data that the Machine-tracker use?
If you are talking about deleting CAM and ARP data from NAVdb, it depends on what data you want to delete. Either you want to delete the entire tables (which means deleting data for all switches and routers), or you want to delete data pertaining to a particular device. To just delete _all_ historic CAM and ARP data, you would issue the SQL commands: "DELETE FROM cam; DELETE FROM arp;". If you want to select data for specific switches or routers, add the following where clause to your statements: "WHERE sysname = 'your-device's-sysname-here'".
And how do I force a refilling? (in nav2-1-5 we used the kilde2.sh script)
Force a refilling of what? If you add boxes through the Edit Database interface, their information will be automatically gathered by getDeviceData ASAP. CAM/ARP data will be collected automatically on the next run of the mactrace and iptrace cron jobs. - -- Morten Vold NTNU ITEA Integrasjonsgruppen -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCB3dHXxIl0kpcOkQRAgIAAJ49EnmgovVnz0084jjFYvmNyKWw0QCfc1Ga 6QkGKJersFXPLHl+Zpn9SMc= =tWss -----END PGP SIGNATURE-----
From kreide at online.no Tue Feb 8 09:40:14 2005 From: kreide at online.no (Kristian Eide) Date: Tue Feb 8 09:40:19 2005 Subject: [Nav-users] getDeviceData and NAVv3 beta9 Message-ID: <4208A91F@epostleser.online.no>
Related to the introduction of a new SNMP library in NAVv3 beta 9 there exists an issue related to new devices added (or re-added) not having all their data collected. We have investigated this problem, and the cause is a wrong default value for the 'getnext' field in the snmpoid table. This has been fixed in beta 10, which will be released later this week (if the planets align properly), however, there is a quick fix which can be applied to beta 9 to get around this issue. Execute the following SQL statements and then restart getDeviceData: UPDATE snmpoid SET getnext=true; UPDATE netbox SET uptodate=false; Data should then be collected normally. -- Kristian
participants (2)
-
Aage.Olai.Johnsen＠hitos.no -
morten.vold＠ntnu.no