Forum OpenACS Q&A: Novice question

When I got to "Prepare PostgreSQL for OpenACS" on the "Install OpenACS 4.5" page, the "createdb " failed with "command not found." (This had worked fine after installing PG7.2)

I went back to the install logs from AOLServer, there were no errors in any of the logs except pgdriver.log:

[root@vox log]# cat pgdriver.log
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

[root@vox log]# locate libpq-fe.h
/raid1/usr.local/local/src/postgresql-7.2/src/interfaces/libpq/libpq-fe.h

lrwxrwxrwx    1 root     root           16 Mar  4 03:51 usr -> /raid1/usr.local
lrwxrwxrwx    1 root     root           10 Mar  4 21:25 web -> /raid1/web

I'm hoping I did something really stupid and embarrassing, i.e., something with an easy answer!

Van

[root@vox local]# cd ~postgres
[root@vox pgsql]# cd ..
[root@vox local]# ls -l
total 48
drwxrwxr-x    8 nsadmin  web          4096 Mar  4 20:54 aolserver
drwxr-xr-x    2 root     root         4096 Feb  6  1996 bin
drwxr-xr-x    2 root     root         4096 Feb  6  1996 doc
drwxr-xr-x    2 root     root         4096 Feb  6  1996 etc
drwxr-xr-x    2 root     root         4096 Feb  6  1996 games
drwxr-xr-x    2 root     root         4096 Jun 22  2001 include
drwxr-xr-x    2 root     root         4096 Feb  6  1996 lib
drwxr-xr-x    2 root     root         4096 Jun 22  2001 libexec
drwxr-----    9 postgres web          4096 Mar  4 13:22 pgsql
drwxr-xr-x    2 root     root         4096 Feb  6  1996 sbin
drwxr-xr-x    4 root     root         4096 Jun 22  2001 share
drwxr-xr-x    4 root     root         4096 Mar  4 20:07 src

Van

You will also need to run "createuser nsadmin" as the postgres user.  Answer yes to both questions.  Then login as the nsadmin user and run "created openacs-4".  Start aolserver and you should be good to go.

chmod g+rx postgres

<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

NSHOME=/usr/local/aolserver

It had been set to /usr/local/aolserver/aolserver. That was line 59 in the version I was working from. The line numbers in my copy (part of the complete tar identified as "Mat's AOLServer distribution" in the docs) were slightly different from yours, but yours got me close enough to finish up.

Oh boy, oh boy! I have an OACS running after a year or more of reading about it.

Van