I just installed the rpms for aolserver-3.2-4, aolserver-
postgresql-2.3.1, openacs-3.2.5, postgresql-7.2-0.7, postgres-server-
7.2-0.7, postgres-tcl-7.2-0.7, and postgres-libs-7.2-0.7 onto my Red
Hat 7.2 machine.
After installing, I started up the postgres server and the aol
server. There were no errors upon starting the aolserver. When I
tried to view the index.tcl page in IE 5.50 it says The page cannot
be displayed. It generates the following into the server logs:
[08/Feb/2002:11:35:35][386.19461][-conn3-] Notice:
Querying 'select nextval('sec_id_seq') from dual;'
[08/Feb/2002:11:35:35][386.19461][-conn3-] Notice: dbinit: sql
(localhost::acs): 'select nextval('sec_id_seq') from dual'
[08/Feb/2002:11:35:35][386.19461][-conn3-] Notice: Querying '
select password
from users
where user_id = 1
and user_state = 'authorized';'
[08/Feb/2002:11:35:35][386.19461][-conn3-] Notice: dbinit: sql
(localhost::acs): '
select password
from users
where user_id = 1
and user_state = 'authorized'
'
[08/Feb/2002:11:35:35][386.19461][-conn3-] Notice: Querying '
insert into sec_sessions(session_id, user_id, token,
secure_token, browser_id,
last_ip, last_hit)
values(2494, 1, 'lR/qJ43ZaQ3xWv0SBFGw6uaurImiPXWi', '', 1,
'209.19.21.15', 1013193335);'
[08/Feb/2002:11:35:35][386.19461][-conn3-] Notice: dbinit: sql
(localhost::acs): '
insert into sec_sessions(session_id, user_id, token,
secure_token, browser_id,
last_ip, last_hit)
values(2494, 1, 'lR/qJ43ZaQ3xWv0SBFGw6uaurImiPXWi', '', 1,
'209.19.21.15', 1013193335)
'
[08/Feb/2002:11:35:35][386.19461][-conn3-] Notice: Querying 'select
sec_rotate_last_visit(1, 1013193335);'
NOTICE: Error occurred while executing PL/pgSQL function
sec_rotate_last_visit
NOTICE: line 11 at SQL statement
[08/Feb/2002:11:35:35][386.19461][-conn3-] Error: Ns_PgExec: result
status: 7 message: ERROR: value too long for type character(1)
[08/Feb/2002:11:35:35][386.19461][-conn3-] Error: dbinit: error
(localhost::acs,ERROR: value too long for type character(1)
): 'select sec_rotate_last_visit(1, 1013193335)'
[08/Feb/2002:11:35:35][386.19461][-conn3-] Error: Filter
sec_read_security_info returned error #1: Database operation "1row"
failed (exception NSDB, "Query was not a statement returning rows.")
[08/Feb/2002:11:35:35][386.19461][-conn3-] Error: tclop: invalid
return code from filter proc 'Critical filter sec_read_security_info
failed.': must be filter_ok, filter_return, or filter_break
I've done a few searches and haven't really found a complete
answer yet.
Thanks in advance for any help.