Hi,
Thanks for the reply, inital creation of database works fine. I used the following cmd to create the db as instructed in "Prepare PostgreSQL for an OpenACS Service" procedure in the install manual:
[service0 service0]$ createdb -E UNICODE service0
and was sucessfully.
thus, inital startup of AOLsvr and OpenACS was o.k, errors persist only during start of Kernel Data Model installation as per my earlier posting, so I dun really think there was a problem with loading of nsd-postgres, the log file didn't show any erros I didn't make much changes on the config.tcl (only the necessary minor change as per the install instruction), we had a couple of servers running live openacs sites on redhat9 but this is our 1st openacs on solaris 8.
<snip>....
[16/Jun/2004:13:38:02][17840.1][-main-] Notice: modload: loading '/usr/local/ao\
lserver/bin/nsdb.so'
[16/Jun/2004:13:38:02][17840.1][-main-] Notice: modload: loading '/usr/local/ao\
lserver/bin/nspostgres.so'
[16/Jun/2004:13:38:02][17840.1][-main-] Notice: PostgreSQL loaded.
[16/Jun/2004:13:38:02][17840.1][-main-] Notice: conf: [ns/server/service0]enabl\
etclpages = 0
[16/Jun/2004:13:38:02][17840.1][-main-] Notice: Loading OpenACS, rooted at /var\
/lib/aolserver/service0
[16/Jun/2004:13:38:02][17840.1][-main-] Notice: Sourcing /var/lib/aolserver/ser\
vice0/packages/acs-bootstrap-installer/bootstrap.tcl
<snip>....
<snip>
[16/Jun/2004:13:38:07][17840.5][-sched-] Notice: sched: starting
[16/Jun/2004:13:38:07][17840.1][-main-] Notice: nssock: listening on 10.5.13.23\
1:8000
[16/Jun/2004:13:38:07][17840.12][-driver-] Notice: starting
[16/Jun/2004:13:38:07][17840.12][-driver-] Notice: driver: accepting connection\
s
[16/Jun/2004:13:50:17][17840.7][-conn:service0::1] Error: Ns_PgExec: result sta\
tus: 7 message: ERROR: relation "apm_package_db_types" does not exist
[16/Jun/2004:13:50:17][17840.7][-conn:service0::1] Error: Error sourcing /var/l\
ib/aolserver/service0/packages/acs-bootstrap-installer/installer/install.tcl:
Database operation "0or1row" failed (exception NSDB, "Query was not a statement\
returning rows.")
ERROR: relation "apm_package_db_types" does not exist
SQL:
select case when count(*) = 0 then 0 else 1 end from apm_package_db_typ\
es
while executing
<snip>
ciao..
ina
