Forum OpenACS Q&A: Problem in running OpenACS-3.2.5 with PostgreSQL-7.2.2

Collapse
1: Problem in running OpenACS-3.2.5 with PostgreSQL-7.2.2
Posted by Abhay Kulkarni on 04/23/04 06:52 AM
Hi All !

In our setup, we are running OpenACS-3.2.5 on Red Hat 7.1 with PostgreSQL-7.1.3. And it runs just fine, in development as well as production.

We decided to upgrade to Red Hat 8 which has shipped PostgreSQL-7.2.2 with it. While running the index.adp page, we get the message as "Connection to server broken" with following log message

NOTICE: Error occurred while executing PL/pgSQL function sec_rotate_last_visit
NOTICE: line 11 at SQL statement [22/Apr/2004:16:41:23][16947.40966][-conn0-] Error: Ns_PgExec: result status: 7 message: ERROR: value too lon g for type character(1)

[22/Apr/2004:16:41:23][16947.40966][-conn0-] Error: dbinit: error(localhost::pbnic,ERROR: value too long for type character(1)
): 'select sec_rotate_last_visit(1, 1082632283)'
[22/Apr/2004:16:41:23][16947.40966][-conn0-] Error: Filter sec_read_security_info returned error #1: Database operation "1row" failed (exception NSDB, "Query was not a statement returning rows.")
[22/Apr/2004:16:41:23][16947.40966][-conn0-] Error: tclop: invalid return code from filter proc 'Critical filt er sec_read_security_info failed.': must be filter_ok, filter_return, or filter_break
NOTICE: Error occurred while executing PL/pgSQL function sec_rotate_last_visit
NOTICE: line 11 at SQL statement
[22/Apr/2004:16:41:26][16947.40966][-conn0-] Error: Ns_PgExec: result status: 7 message: ERROR: value too lon g for type character(1)

[22/Apr/2004:16:41:26][16947.40966][-conn0-] Error: dbinit: error(localhost::pbnic,ERROR: value too long for type character(1)
): 'select sec_rotate_last_visit(3, 1082632286)'
[22/Apr/2004:16:41:26][16947.40966][-conn0-] Error: Filter sec_read_security_info returned error #1: Database operation "1row" failed (exception NSDB, "Query was not a statement returning rows.")
[22/Apr/2004:16:41:26][16947.40966][-conn0-] Error: tclop: invalid return code from filter proc 'Critical filt er sec_read_security_info failed.': must be filter_ok, filter_return, or filter_break

Can anybody help please ?

Thank you,
Regards.
Collapse
2: Re: Problem in running OpenACS-3.2.5 with PostgreSQL-7.2.2 (response to 1)
Posted by Claudio Pasolini on 04/23/04 02:34 PM
You have to change the function sec_rotate_last_visit: in the last insert the parameter v_time must be changed from v_time::char to v_time::varchar.

Note tha to avoid problems with ns_sendmail you also have to change the sendmail.tcl script (usually in /usr/local/aolserver/modules/tcl/sendmail.tcl) eliminating the string AOLSERVER after the HELO command.

Collapse
3: Re: Problem in running OpenACS-3.2.5 with PostgreSQL-7.2.2 (response to 1)
Posted by Abhay Kulkarni on 05/05/04 06:23 AM
Hello Claudio,

It worked !!

Sorry for the late reply as we had a week long vacation here.

Thanks a lot !

Regards.