Hi, i'm trying to get NAV running, because I am mainly interested in the network discovery part. After following the instructions in INSTALL, generating the databases, configuring apache2 and recompiling templates, I get this error-message: --------------------------------------------------------------------- Mod_python error: "PythonHeaderParserHandler nav.web" Traceback (most recent call last): File "/usr/local/lib/python2.4/site-packages/mod_python/apache.py", line 299, in HandlerDispatch result = object(req) File "/usr/lib/python2.4/nav/web/__init__.py", line 59, in headerparserhandler nav.web.auth.authenticate(req) File "/usr/lib/python2.4/nav/web/auth.py", line 97, in authenticate if not checkAuthorization(user, req.unparsed_uri): File "/usr/lib/python2.4/nav/web/auth.py", line 49, in checkAuthorization return nav.auth.hasPrivilege(user, 'web_access', uri) File "/usr/lib/python2.4/nav/auth.py", line 48, in hasPrivilege user.cachePrivileges() File "/usr/lib/python2.4/nav/auth.py", line 90, in cachePrivileges groups = account.getChildren(navprofiles.Accountingroup) File "/usr/local/lib/python2.4/site-packages/forgetSQL.py", line 811, in getChildren return forgetter.getAll(whereList, orderBy=orderBy) File "/usr/local/lib/python2.4/site-packages/forgetSQL.py", line 679, in getAll ids = cls.getAllIDs(where, orderBy=orderBy) File "/usr/local/lib/python2.4/site-packages/forgetSQL.py", line 743, in getAllIDs curs.execute(sql) ProgrammingError: ERROR: relation "accountingroup" does not exist SELECT AccountInGroup.accountid, groupid FROM AccountInGroup WHERE (AccountInGroup.accountid='0') ------------------------------------------------------------------------------ I If I try sql by hand in the CLI, it works. I'm puzzled now. Any idea, how to get it working? Some case-sensitive related problems? Some further Information: SuSE 10.1 Nav 3.1.0. from source Python 2.4.2 from RPM postgres 8.1.3 from RPM CHEETAH 1.0 (could not use v2, there were some syntax changes?!) from source apache 2.2.0 from RPM mod_python 3.2.10 from source perl v5.8.8 from RPM java version "1.5.0_06" Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_06-b05) Java HotSpot(TM) Client VM (build 1.5.0_06-b05, mixed mode) from RPM Thanks in advcance Christian
From morten.brekkevold at uninett.no Wed Nov 8 14:38:52 2006 From: morten.brekkevold at uninett.no (Morten Brekkevold) Date: Wed Nov 8 14:39:37 2006 Subject: [Nav-users] Announcement: NAV 3.1.1 is out Message-ID: <4551DDEC.7010009@uninett.no>
NAV 3.1.0 is now available for download at SourceForge, see http://sourceforge.net/projects/nav :-) This is mainly a bugfix release, and some serious issues have been fixed in this version, including one security vulnerability discovered by Jim Gallacher. Binary packages for Debian will be available at a later time. The Debian package is maintained by Morten Werner Olsen, and he is currently polishing his nearly finished packaging of the 3.1.0 release. We would also like to welcome anyone interested in maintaining packages for RPM-based distributions! -- mvh Morten Vold UNINETT
Christian Goutrie wrote, On 07-11-2006 10:13:
ProgrammingError: ERROR: relation "accountingroup" does not exist
SELECT AccountInGroup.accountid, groupid FROM AccountInGroup WHERE (AccountInGroup.accountid='0')
------------------------------------------------------------------------------
I If I try sql by hand in the CLI, it works. I'm puzzled now. Any idea, how to get it working? Some case-sensitive related problems?
Exactly what did you do when you say you tried "sql by hand in the CLI"? Which arguments did you pass to psql, and which SQL statements did you run? -- mvh Morten Brekkevold UNINETT
From morten.brekkevold at uninett.no Wed Nov 8 14:47:03 2006 From: morten.brekkevold at uninett.no (Morten Brekkevold) Date: Wed Nov 8 14:47:21 2006 Subject: [Nav-users] Announcement: NAV 3.1.1 is out In-Reply-To: <4551DDEC.7010009@uninett.no> References: <4551DDEC.7010009@uninett.no> Message-ID: <4551DFD7.4080000@uninett.no>
Morten Brekkevold wrote, On 08-11-2006 14:38:
NAV 3.1.0 is now available for download at SourceForge ^^^^^ I did of course mean, as the subject says, NAV 3.1.1 :-)
-- mvh Morten Brekkevold UNINETT
From goutrie at rapideye.de Wed Nov 8 15:28:21 2006 From: goutrie at rapideye.de (Christian Goutrie) Date: Wed Nov 8 15:28:37 2006 Subject: [Nav-users] Database problem In-Reply-To: <4551DEAB.9090200@uninett.no> References: <200611071013.30970.goutrie@rapideye.de> <4551DEAB.9090200@uninett.no> Message-ID: <200611081528.21461.goutrie@rapideye.de>
On Wednesday 08 November 2006 14:42, Morten Brekkevold wrote:
Christian Goutrie wrote, On 07-11-2006 10:13:
ProgrammingError: ERROR: relation "accountingroup" does not exist
SELECT AccountInGroup.accountid, groupid FROM AccountInGroup WHERE (AccountInGroup.accountid='0')
------------------------------------------------------------------------- -----
I If I try sql by hand in the CLI, it works. I'm puzzled now. Any idea, how to get it working? Some case-sensitive related problems?
Exactly what did you do when you say you tried "sql by hand in the CLI"? Which arguments did you pass to psql, and which SQL statements did you run?
Ok, maybe I forgot something, so here are some more details: sql by hand means, that I passed the statement directly via the psql: ------------------------------------- me@it005:~> psql -U nav -d manage Password for user nav: Welcome to psql 8.1.3, the PostgreSQL interactive terminal. manage=# SELECT AccountInGroup.accountid, groupid FROM AccountInGroup WHERE (AccountInGroup.accountid='0'); accountid | groupid -----------+--------- (0 rows) manage=#\q me@it005:~> ------------------------------------- I don't know, if this "0 rows"-result produces the relation error. Is it right, or did I forgot to put some data into the database? I just followed the INSTALL-instructions, and AFAIR there were no errors while populating the tables. Christian
participants (2)
-
goutrie＠rapideye.de -
morten.brekkevold＠uninett.no