A follow-up to the previous mail; this is what root@localhost receives in local mail-folder every hour:

N229 root@nav3.hihm.no Tue Feb 15 09:10 51/3090 Cron navcron@nav3 $BINDIR/getBoksMacs.sh $NUM_THREADS

From navcron@nav3.hihm.no Tue Feb 15 09:10:07 2005

X-Original-To: root@localhost Delivered-To: root@localhost.hihm.no From: root@localhost (Cron Daemon) To: root@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@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@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@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

_______________________________________________ Nav-users mailing list Nav-users@itea.ntnu.no http://mailman.itea.ntnu.no/mailman/listinfo/nav-users