Forum OpenACS Q&A: initial acs access

Collapse
Posted by michael matzke on
got no chance to get access to openacs  although the database
connection seems to work ( all initial checks as spam mail etc. work
fine ). i'm running ( or try to ) openacs on SuSE 7.0 with postgres
7.3 and apache with mod_aolserver. of course this problem is
something basic, but what ?

michael matzke
mailto:m.matzke@ctnm.de

[Mon Jan 29 23:00:21 2001] [notice] [client 192.168.200.200] [uri: /]
  closing idle handle in pool: main

[Mon Jan 29 23:00:21 2001] [notice] [client 192.168.200.200] [uri: /]
  Ns_PgCloseDb(3):  Closing connection:  localhost:5432:oracleman

[Mon Jan 29 23:01:19 2001] [notice] [client 192.168.200.200] [uri: /]
  opening:  postgres:localhost:5432:oracleman

[Mon Jan 29 23:01:19 2001] [notice] [client 192.168.200.200] [uri: /]
  Opening oracleman on localhost

[Mon Jan 29 23:01:19 2001] [notice] [client 192.168.200.200] [uri: /]
  Ns_PgOpenDb(postgres):  Openned connection to
localhost:5432:oracleman.

[Mon Jan 29 23:01:19 2001] [notice] [client 192.168.200.200] [uri: /]
  Querying 'set datestyle to 'ISO';'

[Mon Jan 29 23:01:19 2001] [notice] [client 192.168.200.200] [uri: /]
  Querying 'select nextval('sec_id_seq') from dual;'

[Mon Jan 29 23:01:19 2001] [error] [client 192.168.200.200] [uri: /]
  Ns_PgExec: result status: 7 message: ERROR:  Relation 'dual' does
not exist

[Mon Jan 29 23:01:19 2001] [notice] [client 192.168.200.200] [uri: /]
  sql(localhost:5432:oracleman):  select nextval('sec_id_seq') from
dual

Failed assertion at dbutil.c, line 311: strlen(code) <= 5
[Mon Jan 29 23:01:19 2001] [error] [client 192.168.200.200] [uri: /]
  Filter sec_read_security_info returned error #1: Database
operation "1row" failed (exception NSDB, "Query was not a statement
returning rows.")

[Mon Jan 29 23:01:19 2001] [error] [client 192.168.200.200] [uri: /]
  preauth filter blew up --- backtrace follows:

Critical filter sec_read_security_info failed.
    while executing
"error "Critical filter $proc failed.""
    (procedure "ad_handle_filter" line 47)
    invoked from within
"ad_handle_filter {} preauth"

Collapse
Posted by Don Baccus on
The OpenACS datamodel defines a view called "dual" which returns a
single row with a column named "sysdate".  Sounds familiar to
"oracleman", I bet :)

Anyway, the fact that "dual" does not exist is an indication that the
OpenACS datamodel hasn't been loaded, or failed miserably when you
tried to load it.

Is there any chance you loaded the data model into another database,
say the "postgres" database, rather than the "oracleman" database?
That's one possible explanation.