Forum OpenACS Q&A: Re: OpenACS 5.1.0 & Solaris Install problem

Collapse
2: Re: OpenACS 5.1.0 & Solaris Install problem (response to 1)
Posted by Dirk Gomez on 06/16/04 08:18 AM
Yes, most likely something with your OpenACS configuration file or your environment is wrong.

What are the database options in your OpenACS configuration file for PostgreSQL? Have you (manually!) created this database?

Are you starting the server with the proper environment? Check whether the pathnames in nsd-postgres are correct.

Collapse
3: Re: OpenACS 5.1.0 & Solaris Install problem (response to 2)
Posted by azlina danyal on 06/16/04 02:25 PM
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