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

Posted by Effendy Zainuddin on 03/10/03 08:06 AM

Where can i get the above modules, i'm tryin to install oacs4.6/dotlrn on postgres 7.3, windows 2000, AOLserver 4 beta(binaries). The openacs welcome page is reporting that the above modules is missing, continue with the next button anyway, got passed that, presented with another next button (Installing OpenACS Core Services) click on it and got the following errors:

ERROR: Relation "application_groups" does not exist peer
WARNING: Error occurred while executing PL/pgSQL function inline_0
WARNING: line 20 at SQL statement

And the following in my postmaster Window:

[10/Mar/2003:06:02:24][1864.1380][-conn2-] Error: Error sourcing /web/winsvr/pac
kages/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

2: Re: nscache.dll and nssha1.dll ? (response to 1)

Posted by Jeff Davis on 03/10/03 10:36 AM

The source of both of these (and other aolserver modules) is available at the aolservers repository. ( checkout instructions )

3: Re: nscache.dll and nssha1.dll ? (response to 1)

Posted by Jamie Rasmussen on 03/10/03 11:08 AM

May I ask where you found the AOLserver 4 binaries for Windows? I'm guessing the AOLserver 4-UH binaries from acs-misc on SourceForge, in which case what you have is very old and missing source code. I'd suggest starting from my 4.0 beta 2 installer at http://empoweringminds.mle.ie/4/ (the larger one) if you aren't going to build from the beta 2 sources at SourceForge. I haven't checked the project files for non-core modules like nscache and nssha1 into SF yet, but I can email them to you if you want to go that route.

See http://empoweringminds.mle.ie/openacs/aolserver_modules for a long list of AOLserver modules, including their Win32 support level. You will also need to patch several files in OpenACS.

5: Re: nscache.dll and nssha1.dll ? (response to 3)

Posted by Jeff Davis on 03/10/03 11:15 AM

Jamie, do you have a patch you can submit for what's needed on the openacs side for win32 support? I think we would be happy to apply it.

4: Re: nscache.dll and nssha1.dll ? (response to 3)

Posted by Jamie Rasmussen on 03/10/03 11:23 AM

Actually, it looks like 4-UH did include source code - my apologies Yon, I must have been thinking of something else.

I'd be happy to submit the patches I have, but I should clean them up first. Currently they are just in my HEAD checkout and not against a tagged release. There are also a few places where I did quick and dirty things that would break non-Win32 installs, and I need to come up with better solutions for those.

6: Re: nscache.dll and nssha1.dll ? (response to 4)

Posted by Jeff Davis on 03/10/03 11:41 AM

It would be great to have the patches up just so we know what needs attention. You can always comment that it's a work in progress and we can nuke the existing one if you have something better. I for one don't know what sorts of things are a problem (beyond regexps for dir separators and things like that).

7: Re: nscache.dll and nssha1.dll ? (response to 1)

Posted by Don Baccus on 03/10/03 05:56 PM

Yeah, go ahead and submit the patch while pointing out that it breaks things on non-Windows platforms. I think you're the only person among us who knows just what needs diddling. We might be able to help you figure out clean ways to support both. If changes were extensive in certain areas we could go so far as to supply foo-windows.tcl and foo-unix.tcl scripts much as we do for RDBMS support - though I'd very much prefer not to do so if it's just a matter of a few things here and there.

Will AOLserver tell us what platform we're on? Do we have some way of knowing when we start up in acs-bootstrap-installer?

8: Re: nscache.dll and nssha1.dll ? (response to 7)

Posted by Jamie Rasmussen on 03/10/03 08:17 PM

It has been a few months since I looked at this, but the changes should be relatively minor - inline should definitely be possible. I should have time to put something out later this week. I still want to submit the API browser coloring and linking stuff too.

There are a couple of ways to get platform information.
1. global tcl_platform array
2. ns_info platform
3. ns_info winnt

9: Re: nscache.dll and nssha1.dll ? (response to 3)

Posted by Effendy Zainuddin on 03/11/03 06:10 AM

Thank you for your response. You are right, I am using the early beta AOLServer 4-UH windows binaries (nsd4.zip) that I downloaded from
http://asc-misc.sourceforge.net/dl/nsd4.zip

Tried to download the 4.0 beta 2 installer from the link that was given by you (http://empoweringminds.mle.ie/4/). Seems it's broken. Would appreciate it if you could point me to another URL.

10: Re: nscache.dll and nssha1.dll ? (response to 9)

Posted by Jamie Rasmussen on 03/11/03 09:11 AM

Sorry - I meant http://empoweringminds.mle.ie/openacs/4/
I've been putting all of my documentation related to AOLserver and OpenACS at http://empoweringminds.mle.ie/openacs/

11: Re: nscache.dll and nssha1.dll ? (response to 10)

Posted by Effendy Zainuddin on 03/12/03 01:53 AM

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: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: Ac
s-core-docs not installed.
 Error:
<pre><blockquote>no such cache: util_memoize</blockquote><blockquote>no such cac
he: util_memoize
while executing
"ns_cache flush util_memoize $script"
(procedure "util_memoize_flush" line 2)
invoked from within
"util_memoize_flush [list apm_package_installed_p_not_cached $package_key]&
quot;
(procedure "apm_package_install" line 139)
invoked from within
"apm_package_install -callback $callback $spec_file"</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: Sk
in not installed.
 Error:
<pre><blockquote>no such cache: util_memoize</blockquote><blockquote>no such cac
he: util_memoize
while executing
"ns_cache flush util_memoize $script"
(procedure "util_memoize_flush" line 2)
invoked from within
"util_memoize_flush [list apm_package_installed_p_not_cached $package_key]&
quot;
(procedure "apm_package_install" line 139)
invoked from within
"apm_package_install -callback $callback $spec_file"</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 " <li> Completing Install sequence by mounting the main site an
d other core packages.
<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 !!!!

12: Re: nscache.dll and nssha1.dll ? (response to 11)

Posted by Jamie Rasmussen on 03/12/03 05:27 PM

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.

13: Re: nscache.dll and nssha1.dll ? (response to 12)

Posted by Effendy Zainuddin on 03/13/03 02:44 AM

Thank you for your feedback. Will definitely try out your suggestion and let you know what happens. Really appreciate your response.

14: Re: nscache.dll and nssha1.dll ? (response to 12)

Posted by Effendy Zainuddin on 03/13/03 03:40 AM

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