Forum OpenACS Q&A: Response to Novice question

Collapse
11: Response to Novice question (response to 1)
Posted by G. Armour Van Horn on 03/05/02 10:09 PM
Warning, this is long and rife with error messages. The first couple may be minor items that need to be edited in the default site-service.tcl file.

<P>After minimal editing of the /usr/local/aolserver/wimls.tcl file (wimls being my first project) I invoked:

<pre>/usr/local/aolserver/bin/nsd-postgres -t /usr/local/aolserver/wimls.tcl</pre>

and got:

<pre>[05/Mar/2002:10:50:58][18381.1024][-main-] Fatal: config: script error: wrong # args: should be "ns_param key value
    while executing
"ns_param  fancy".adp""</pre>

On line 132 I added a space between fancy and ".adp" - then restarted:

<pre>[nsadmin@vox aolserver]$ [05/Mar/2002:11:08:17][18396.1024][-main-] Notice: nsd.tcl: starting to read config file...
[05/Mar/2002:11:08:17][18396.1024][-main-] Fatal: config: script error: wrong # args: should be "ns_param key value
    while executing
"ns_param  classpath          "</pre>

On line 274, I unwrapped the line.

<pre>[nsadmin@vox aolserver]$ [05/Mar/2002:11:13:20][18411.1024][-main-] Notice: nsd.tcl: starting to read config file...
[05/Mar/2002:11:13:20][18411.1024][-main-] Warning: nsd.tcl: nsssl not loaded because key/cert files do not exist.
[05/Mar/2002:11:13:20][18411.1024][-main-] Notice: nsd.tcl: finished reading config file.</pre>

I think that's exactly what I was supposed to see, right? I then went to a browser and got this:

<H2>Request Error</H2>
Server startup failed: Error during bootstrapping<blockquote><pre>command &#34;ns_db&#34; is not enabled
    while executing
&#34;ns_db pools&#34;
    (procedure &#34;db_bootstrap_set_db_type&#34; line 72)
    invoked from within
&#34;db_bootstrap_set_db_type database_problem&#34;</pre></blockquote>
<P ALIGN=RIGHT><SMALL><I>AOLserver/3.3.1+ad13 on http://vox.domainvanhorn.com:8000</I></SMALL></P>

I recompiled aolserver, but I still get the indication in the /usr/local/src/aolserver/log/pgdriver.log mentioned several messages back:

<pre>gcc -DFOR_ACS_USE -DBIND_EMULATION -I/usr/local/aolserver/include -fpic -shared -I/usr/include/pgsql -I/usr/local/aolserver/include -I-/usr/include  -c -o postgres.o postgres.c
postgres.c:45:22: libpq-fe.h: No such file or directory
make: *** [postgres.o] Error 1</pre>

and /usr/local/aolserver/log/wimls-error.log starts out like this:

<pre>[05/Mar/2002:11:21:10][18441.1024][-main-] Notice: nsmain: AOLserver/3.3.1+ad13 starting
[05/Mar/2002:11:21:10][18441.1024][-main-] Notice: nsmain: security info: uid=502, euid=502, gid=502, egid=502
[05/Mar/2002:11:21:10][18441.1024][-main-] Notice: nsmain: max files: FD_SETSIZE = 1024, rl_cur = 1024, rl_max = 1024
[05/Mar/2002:11:21:10][18441.1024][-main-] Notice: return: redirecting '404' to 'global/file-not-found.html'
[05/Mar/2002:11:21:10][18441.1024][-main-] Notice: return: redirecting '403' to 'global/forbidden.html'
[05/Mar/2002:11:21:10][18441.1024][-main-] Notice: modload: loading '/usr/local/aolserver/bin/postgres.so'
[05/Mar/2002:11:21:10][18441.1024][-main-] Warning: modload: failed to load '/usr/local/aolserver/bin/postgres.so': '/usr/local/
aolserver/bin/postgres.so: cannot open shared object file: No such file or directory'
[05/Mar/2002:11:21:10][18441.1024][-main-] Error: dbdrv: failed to load driver 'postgres'
[05/Mar/2002:11:21:10][18441.1024][-main-] Error: dbinit: no such default pool 'pool1'
[05/Mar/2002:11:21:10][18441.1024][-main-] Debug: dbinit: no configured pools</pre>

PostgreSQL is happily running, there is a postmaster, a stats buffer process, and a stats collection process process all running. So it looks like it's come back to the libpq-fe.h file not being seen when I compile AOLServer, which apparently keeps the PostgreSQL driver from compiling into AOLServer.

<P>Van