-- 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@merke.itea.ntnu.no References: 20050214144223.A409A13C5EB@merke.itea.ntnu.no Message-ID: 42145421.2070603@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@duke.cc.uit.no References: 20050217085447.W53178@duke.cc.uit.no Message-ID: 4214547B.8020909@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@ntnu.no References: 20050217085447.W53178@duke.cc.uit.no 4214547B.8020909@ntnu.no Message-ID: 20050217093107.X53336@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@duke.cc.uit.no References: 20050217085447.W53178@duke.cc.uit.no 4214547B.8020909@ntnu.no 20050217093107.X53336@duke.cc.uit.no Message-ID: 42145B26.7050304@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@ntnu.no Message-ID: 20050217113353.4EFDA66DF4@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@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-----