Forum OpenACS Q&A: Re: nscache.dll and nssha1.dll ?

Collapse
Posted by Effendy Zainuddin on
New errors encountered !!!

My Installation:

OpenACS4.6/dotLRN from CVS + nsd4 from AOLserver_4-0_plus_2003-02-07.msi + Postgresql7.2.4 from CVS on cygwin

AOLserver boots up perfectly (dun really need to refresh a few times like before) but encountered some error messages in the command console and the cygwin bash shell as per below after installing the data model but still presented with the next button (after I do a refresh on the browser) with the message "Data model installed" in the browser.

Errors Message in c:\WINNT\System32\cm.exe - bin\nsd.exe -f -t openacs4.tcl

------------------------------------------------------------

[11/Mar/2003:21:57:56][1784.796][-conn:openacs4::0] Error: Error sourcing /web/o
penacs4/packages/acs-bootstrap-installer/installer/install-data-model.tcl:
psql:groups-body-create.sql:220: ERROR:  ProcedureCreate: cannot change return t
ype of existing function.
        Use DROP FUNCTION first.

    invoked from within
"db_source_sql_file -callback apm_dummy_callback "acs-kernel-create.sql""
    (file "/web/openacs4/packages/acs-bootstrap-installer/installer/install-data
-model.tcl" line 31)
    invoked from within
"source $__file "

------------------------------------------------------------

1. Error Message (within dashed lines above) in cygwin bash shell where i run postmaster (postmaster -i)

Administrator@winsvr ~
$ postmaster -i
LOG:  database system was shut down at 2003-03-11 21:53:27 MPST
LOG:  checkpoint record is at 0/1748FF0
LOG:  redo record is at 0/1748FF0; undo record is at 0/0; shutdown TRUE
LOG:  next transaction id: 10048; next oid: 29345
LOG:  database system is ready
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'acs_function_arg
s_pk' for table 'acs_function_args'
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 'acs_function_args_un'
<snip...>
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
NOTICE:  CreateTrigger: changing return type of function acs_permissions_lock_tr
() from OPAQUE to TRIGGER
NOTICE:  CreateTrigger: changing return type of function membership_rels_in_tr()
from OPAQUE to TRIGGER
NOTICE:  CreateTrigger: changing return type of function membership_rels_up_tr()
from OPAQUE to TRIGGER
NOTICE:  CreateTrigger: changing return type of function membership_rels_del_tr(
) from OPAQUE to TRIGGER

------------------------------------------------------------

ERROR:  ProcedureCreate: cannot change return type of existing function.
        Use DROP FUNCTION first.

------------------------------------------------------------

NOTICE:  CreateTrigger: changing return type of function composition_rels_del_tr
() from OPAQUE to TRIGGER
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'sec_session_prop
erties_pkey' for table 'sec_session_properties'
<snip...>

After clicking the next button the following error messages in both console windows, "Completing Install sequence by mounting the main site and other core packages." can be seen in the browser window

Error Messages after I click the next button:

<snip...>
[11/Mar/2003:21:55:21][1784.1752][-main-] Notice: Loading packages/acs-tcl/tcl/x
ml-2-procs.tcl...
[11/Mar/2003:21:55:21][1784.1752][-main-] Notice: Multiple definition of util_me
moize in /web/openacs4/packages/acs-tcl/tcl/memoize-procs.tcl and /web/openacs4/
packages/acs-bootstrap-installer/bootstrap.tcl
[11/Mar/2003:21:55:21][1784.1752][-main-] Notice: Installation is not complete -
sourcing the installer.
[11/Mar/2003:21:55:21][1784.1752][-main-] Notice: Sourcing files for postload...

[11/Mar/2003:21:55:21][1784.1752][-main-] Notice: Done.
[11/Mar/2003:21:55:21][1784.1752][-main-] Notice: Executing initialization code
blocks...
[11/Mar/2003:21:55:22][1784.1752][-main-] Notice: nsmain: AOLserver/4.0 running
[11/Mar/2003:21:55:22][1784.1356][-sched-] Notice: sched: starting
[11/Mar/2003:21:55:22][1784.1752][-main-] Notice: nssock: listening on 192.168.1
.1:80
[11/Mar/2003:21:55:22][1784.1644][-driver-] Notice: starting
[11/Mar/2003:21:55:22][1784.1644][-driver-] Notice: driver: accepting connection
s

------------------------------------------------------------

[11/Mar/2003:21:57:56][1784.796][-conn:openacs4::0] Error: Error sourcing /web/o
penacs4/packages/acs-bootstrap-installer/installer/install-data-model.tcl:
psql:groups-body-create.sql:220: ERROR:  ProcedureCreate: cannot change return t
ype of existing function.
        Use DROP FUNCTION first.

    invoked from within
"db_source_sql_file -callback apm_dummy_callback "acs-kernel-create.sql""
    (file "/web/openacs4/packages/acs-bootstrap-installer/installer/install-data
-model.tcl" line 31)
    invoked from within
"source $__file "

------------------------------------------------------------

[11/Mar/2003:22:33:59][1784.796][-conn:openacs4::0] Notice: Loading acs-tcl init
file utilities-init.tcl
<snip...>
[11/Mar/2003:22:34:07][1784.796][-conn:openacs4::0] Notice: APM/QD = DONE loopin
g through files to load queries from
NOTICE:  Adding missing FROM-clause entry for table "acs_object_id_seq"

------------------------------------------------------------

[11/Mar/2003:22:34:07][1784.796][-conn:openacs4::0] Error: <p><font color=red>Ac
s-core-docs not installed.</font>
<p> Error:
<pre><blockquote>no such cache: util_memoize</blockquote><blockquote>no such cac
he: util_memoize
    while executing
&quot;ns_cache flush util_memoize $script&quot;
    (procedure &quot;util_memoize_flush&quot; line 2)
    invoked from within
&quot;util_memoize_flush [list apm_package_installed_p_not_cached $package_key]&
quot;
    (procedure &quot;apm_package_install&quot; line 139)
    invoked from within
&quot;apm_package_install -callback $callback $spec_file&quot;</blockquote></pre
<blockquote>
</blockquote>

------------------------------------------------------------

[11/Mar/2003:22:34:07][1784.796][-conn:openacs4::0] Notice: APM/QD = loading up
package query files for skin
[11/Mar/2003:22:34:07][1784.796][-conn:openacs4::0] Notice: APM: Query files for
skin:
[11/Mar/2003:22:34:07][1784.796][-conn:openacs4::0] Notice: INSTALL-HACK-LOG-BEN
: version_id is 175
[11/Mar/2003:22:34:08][1784.796][-conn:openacs4::0] Notice: APM/QD = DONE loopin
g through files to load queries from

------------------------------------------------------------

[11/Mar/2003:22:34:08][1784.796][-conn:openacs4::0] Error: <p><font color=red>Sk
in not installed.</font>
<p> Error:
<pre><blockquote>no such cache: util_memoize</blockquote><blockquote>no such cac
he: util_memoize
    while executing
&quot;ns_cache flush util_memoize $script&quot;
    (procedure &quot;util_memoize_flush&quot; line 2)
    invoked from within
&quot;util_memoize_flush [list apm_package_installed_p_not_cached $package_key]&
quot;
    (procedure &quot;apm_package_install&quot; line 139)
    invoked from within
&quot;apm_package_install -callback $callback $spec_file&quot;</blockquote></pre
<blockquote>
</blockquote>
[11/Mar/2003:22:34:09][1784.796][-conn:openacs4::0] Error: Error sourcing /web/o
penacs4/packages/acs-bootstrap-installer/installer/packages-install.tcl:
psql:acs-install.sql:76: WARNING:  Error occurred while executing PL/pgSQL funct
ion inline_0
psql:acs-install.sql:76: WARNING:  line 20 at SQL statement
psql:acs-install.sql:76: ERROR:  Relation "application_groups" does not exist

    invoked from within
"db_source_sql_file -callback apm_dummy_callback acs-install.sql"
    invoked from within
"if { ![ad_acs_admin_node] } {
    ns_write "  <p><li> Completing Install sequence by mounting the main site an
d other core packages.<p>
    <blockquot..."
    (file "/web/openacs4/packages/acs-bootstrap-installer/installer/packages-ins
tall.tcl" line 44)
    invoked from within
"source $__file "

------------------------------------------------------------

2. Error Message (within dashed lines above) in cygwin bash shell after clicking the next button

NOTICE:  Adding missing FROM-clause entry for table "acs_object_id_seq"
NOTICE:  Adding missing FROM-clause entry for table "acs_object_id_seq"
ERROR:  Relation "application_groups" does not exist
WARNING:  Error occurred while executing PL/pgSQL function inline_0
WARNING:  line 20 at SQL statement

Question 1

Any idea on the above errors?

Question 2

Should I used Postgres7.3.2-1 src that i downloaded via cygwin?, (It comes with some specific cygwin patches, installation of postgres was flawles if i use this version - i.e no funny error message while compiling) but decided to used the 7.2.x vesion as i read somewhere that dotLRN doesnt really work well with the 7.3.x revision.

Question 3

I was told  to download the latest tarball for OpenACS 4.6.1 ver. beta 2 that will soon be a release. Will this clear up all the errors that I'm getting above?

Question 4

Somehow I'd never successfully run postmaster as a service as per the instrcutions in the OpenACS on Windows <http://empoweringminds.mle.ie/openacs/index.html>: Installing PostgreSQL

4. Install PostgreSQL as a service that depends on ipc-daemon. Run the following commands from a Win2k cmd prompt:
  cygrunsrv -I postmaster -p /usr/bin/postmaster -a "-D /usr/share/postgresql/data -i" -y ipc-daemon -s INT -o
  net start postmaster
It says starting service and then dies off with no specific error message execpt the service could not be started (My ipc-daemon is running)

Cheers and thanks again for your kind help !!!!

Collapse
Posted by Jamie Rasmussen on
1-3.  These don't look like Windows-specific errors to me, but rather mismatched PostgreSQL/OpenACS/dotLRN versions.  Which cvs tags specifically did you use?

4.  Try adding --stderr C:\postmaster.log to your cygrunsrv line, you will then get a log of the problem postmaster is running into during the startup.  (You will have to "cygrunsrv -R postmaster" first.)  I didn't have any problems with PostgreSQL running as a service on my laptop, but after reviewing some mails in the pgsql-cygwin mailing list archive, I think that might be because it is FAT32 and not NTFS.  This may or may not be your problem.

If you are getting the error message "FATAL:  cannot open /usr/share/postgresql/data/PG_VERSION: Permission denied" that means that the account postmaster is running under (LocalSystem if you used my doc) doesn't have the right permissions on the data directory.  I would suggest stopping ipc-daemon, resetting the permissions on the data directory to match those on its parent, deleting cygipc* and MultiFile* in C:\cygwin\tmp\, and then trying to net start ipc-daemon and postmaster.  You'll also want to drop and recreate the acs database as in my step 6.

I should probably update my document to include the creation and use of a separate postgres account as in http://www.tishler.net/jason/software/postgresql/postgresql-7.3.2.README
I'm not sure if that would fix this particular problem, but it is probably The Right Thing To Do.  If you run into anything else that should be added or clarified in my documentation, please let me know.

Collapse
Posted by Effendy Zainuddin on
Thank you for your feedback. Will definitely try out your suggestion and let you know what happens. Really appreciate your response.
Collapse
Posted by Effendy Zainuddin on
With regards to my openacs and dotlRN installation, you are probably right, i'm a bit confused on which cvs tags to use, i'm looking at the following doc for instruction:

https://openacs.org/projects/dotlrn/dotlrn-doc/dotlrn-installation

There seems to be some updates on the doc, will read it more carefully this time around, and try to download the packages again. Hope no more errors.

Also, my win2k installation is on NTFS, will try out your feedback on the postgress soon and let you know.

I really hope to get the openACS up and running, trying to convince my partners that we should commit a few programmers to the comminity as many of our previous customers (mostly running comercial ECM & KM products) are very keen to explore OpenACS. Anyway, FYI, I did managed to install and run CCM-CORE-CMS 5.1.x on win2k & oracle 8.1.6, and also the APLAWS version, both are quite solid products. Also somehow i stumble upon RedHat CCM-CORE-ECM 1.x which is their new KM application running on top of 5.1.x from their ftp sites, i dun think the are givin this out to the public, but somehow when i did a google search the url came out, installed and run it, seems like another solid application with really good features (I spent a couple of years selling DOCUMENTUM & Autonomy products), but havent fully tested it. The url are as below if you wanna have a look at it:

http://labs.redhat.com/tzumainn/

If it's not there anymore, i can put it up on my ftp sites if you are interested to look at it.

Cheers