Forum OpenACS Q&A: segmentation fault in OpenACS 3.2.4 : postgres.so problem?

Collapse
1: segmentation fault in OpenACS 3.2.4 : postgres.so problem?
Posted by John Borwick on 03/07/01 11:27 PM
I'm installing OpenACS on OpenBSD 2.8 . Most everything's gone well; I had to tweak a few things in aolserver 3.3pre3's Makefile.global but I didn't get any error messages. Postgres is already a port for OpenACS, so that wasn't a problem. postgres.so (as compiled from pgdriver-1.1) was compiled with 
PGLIB=/usr/local/pgsql/lib

# Location of the PostgreSQL includes
PGINC=/usr/local/pgsql/include

# Location of the AOLserver files (normally the ~nsadmin directory):
NSHOME=/var/aolserver

COPTS=-g -Wall -fpic -pthread -D_THREAD_SAFE
-I/local/build/aolserver3_3pre3-source/include
-I/usr/local/pgsql/include
LDFLAGS=-pthread -Wl -lcrypt
I edited nsd.tcl as ripped from openacs.org, created the nsadmin user, loaded everything from www/install and www/doc/sql . I chowned everything etc etc. Now when I run aolserver in foreground mode to figure out what the problem is: 
./bin/nsd8x -ft ./nsd.tcl -u nsadmin -g nsadmin
I get a huge number of diagnostic messages and a Segmentation Fault. Here's the end of the output: 
[07/Mar/2001:17:19:43][15882.1001984][-sched-] Notice: Running
scheduled proc ad_partner_initialize...
[07/Mar/2001:17:19:43][15882.1001984][-sched-] Notice: dbdrv: opening
database 'postgres:localhost::students'
[07/Mar/2001:17:19:43][15882.1001984][-sched-] Notice: Opening
students on localhost
[07/Mar/2001:17:19:43][15882.1001984][-sched-] Notice:
Ns_PgOpenDb(postgres):  Openned connection to localhost::students.
[07/Mar/2001:17:19:43][15882.1001984][-sched-] Notice: Querying
'select distinct partner_cookie from ad_partner;'
[07/Mar/2001:17:19:43][15882.1001984][-sched-] Notice: dbinit:
sql(localhost::students): 'select distinct partner_cookie from
ad_partner'
[07/Mar/2001:17:19:43][15882.1001984][-sched-] Notice: Registered
partner cookie: ad
[07/Mar/2001:17:19:43][15882.1001984][-sched-] Notice: Done running
scheduled proc ad_partner_initialize.
Segmentation fault
Is this a likely postgres.so problem? Are there any newer versions of postgres.so ? I've tried aolserver 3.2 and 3.3pre3. I'm running Postgres 7.0.2 . Thank you very much for your time, John Borwick
Collapse
2: Response to segmentation fault in OpenACS 3.2.4 : postgres.so problem? (response to 1)
Posted by Jonathan Ellis on 03/08/01 12:40 AM
7.03 is the latest stable release of postgres.  I'm not at all sure though that postgres is your problem.
Collapse
3: Response to segmentation fault in OpenACS 3.2.4 : postgres.so problem? (response to 1)
Posted by John Borwick on 03/09/01 07:42 PM
FYI, I got it to work.  OpenBSD 2.8 was the problem: threads might have been an issue.  I upgraded to OpenBSD 2.8-current (on 7 March 2001) and recompiled everything for good measure.  I don't think the problem was just OpenBSD/aolserver: the server would run by itself with its sample config file.