The Toolkit for Online Communities
18814 Community Members, 0 members online, 1792 visitors today
Log In Register
OpenACS Home : Forums : OpenACS Q&A : Novice question : One Message

Forum OpenACS Q&A: Response to Novice question

Posted by G. Armour Van Horn on
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.