Forum OpenACS Q&A: compiling nspostgres

Aolserver beta10, openacs4.6.3, postgresql 7.3.4, nspostgres 4beta1.

I've been able to compile everything I need except for nspostgres.  I've been messing with it for a while, I've searched all the docs I can find, but I don't know enough to troubleshoot why it isn't working.

I'd appreciate any help, or even a link to a precompiled version.  Thanks ahead of time.

Here is the output of running make:

[derek:local/src/nspostgres-4.0beta1] derek% make INST=/usr/local/aolserver/ POSTGRES=/usr/local/pgsql ACS=1

gcc -pipe -DBIND_EMULATION -I/usr/local/pgsql/include -DFOR_ACS_USE -Os -Wall -Wconversion -Wno-implicit-int -fno-common -DMAC_OSX_TCL -DHAVE_CFBUNDLE -DUSE_VFORK -DTCL_DEFAULT_ENCODING=\"utf-8\" -I/usr/local/aolserver/include -I/Library/Frameworks/Tcl.framework/Versions/8.4/Headers -DNO_CONST  -DHAVE_UNISTD_H=1 -DHAVE_LIMITS_H=1 -DTCL_THREADS=1 -DUSE_THREAD_ALLOC=1 -D_REENTRANT=1 -D_THREAD_SAFE=1 -DHAVE_PTHREAD_ATTR_SETSTACKSIZE=1 -DHAVE_READDIR_R=1 -DTCL_WIDE_INT_TYPE=long\ long -DWORDS_BIGENDIAN=1 -DHAVE_GETCWD=1 -DHAVE_OPENDIR=1 -DHAVE_STRSTR=1 -DHAVE_STRTOL=1 -DHAVE_STRTOLL=1 -DHAVE_STRTOULL=1 -DHAVE_TMPNAM=1 -DHAVE_WAITPID=1 -DNO_VALUES_H=1 -DHAVE_UNISTD_H=1 -DHAVE_SYS_PARAM_H=1 -DUSE_TERMIOS=1 -DHAVE_SYS_TIME_H=1 -DTIME_WITH_SYS_TIME=1 -DHAVE_TM_ZONE=1 -DHAVE_GMTIME_R=1 -DHAVE_LOCALTIME_R=1 -DHAVE_TM_GMTOFF=1 -DHAVE_ST_BLKSIZE=1 -DSTDC_HEADERS=1 -Dsocklen_t=unsigned -DHAVE_SIGNED_CHAR=1 -DHAVE_PUTENV_THAT_COPIES=1 -DHAVE_SYS_IOCTL_H=1 -DHAVE_SYS_FILIO_H=1  -DHAVE_TIMEGM=1 -DHAVE_DRAND48=1 -DHAVE_RANDOM=1 -DHAVE__NSGETENVIRON=1 -DUSE_DYLD=1 -DHAVE_CMMSG=1    -c -o nspostgres.o nspostgres.c
nspostgres.c: In function `Ns_PgTableList':
nspostgres.c:678: warning: passing arg 3 of `Tcl_DStringAppend' as signed due to prototype
nspostgres.c: In function `encode3':
nspostgres.c:748: warning: passing arg 1 of `enc_one' with different width due to prototype
nspostgres.c:749: warning: passing arg 1 of `enc_one' with different width due to prototype
nspostgres.c:750: warning: passing arg 1 of `enc_one' with different width due to prototype
nspostgres.c:751: warning: passing arg 1 of `enc_one' with different width due to prototype
nspostgres.c: In function `decode3':
nspostgres.c:771: warning: passing arg 1 of `get_one' with different width due to prototype
nspostgres.c:772: warning: passing arg 1 of `get_one' with different width due to prototype
nspostgres.c:773: warning: passing arg 1 of `get_one' with different width due to prototype
nspostgres.c:774: warning: passing arg 1 of `get_one' with different width due to prototype
nspostgres.c: In function `stream_actually_write':
nspostgres.c:863: warning: passing arg 3 of `write' as unsigned due to prototype
nspostgres.c: In function `blob_send_to_stream':
nspostgres.c:979: warning: `fd' might be used uninitialized in this function
nspostgres.c:981: warning: `conn' might be used uninitialized in this function
nspostgres.c: In function `parse_bind_variables':
nspostgres.c:1210: warning: unused variable `first_bind'
nspostgres.c: In function `PgBindCmd':
nspostgres.c:1326: warning: unused variable `value_frag_len'
/bin/rm -f nspostgres.so
cc -bundle -L/usr/local/aolserver/lib -o nspostgres.so nspostgres.o -L/usr/local/pgsql/lib -lpq -lcrypto -lssl -lnsthread -lnsd -framework Tcl  -lpthread -framework CoreFoundation
ld: Undefined symbols:
_Ns_Db0or1Row
_Ns_Db1Row
_Ns_DbDML
_Ns_DbDriverName
_Ns_DbExec
_Ns_DbGetRow
_Ns_DbRegisterDriver
_Ns_DbSelect
_Ns_TclDbGetHandle
make: *** [nspostgres.so] Error 1

i've been messing with this for so long...  THANKS!

I hope to God someone picks this reply up in "new responses." I've been trying to get nspostgres to compile and I can't. I did the MODLIBS hack mentioned above (since I'm using AOLserver 4).

#MODLIBS  = -L$(PGLIB) -lpq
MODLIBS  = -L$(PGLIB) -lpq -lnsdb

Anyway when I run:
# make INST=/usr/local/aolserver/ POSTGRES=/usr/local/pgsql ACS=1

I get a bunch of errors like below (this isn't the top of the errors unfortunately PuTTY's buffer for copy/paste craps out):

I'm on Red Hat 7.3 posgresql 7.4 and aolserver 4.

nspostgres.h:157: warning: (near initialization for `PgProcs[11]')
nspostgres.h:157: warning: excess elements in scalar initializer
nspostgres.h:157: warning: (near initialization for `PgProcs[11]')
nspostgres.h:158: warning: data definition has no type or storage class
nspostgres.c: In function `Ns_DbDriverInit':
nspostgres.c:49: warning: implicit declaration of function `Ns_DbRegisterDriver'
nspostgres.c: At top level:
nspostgres.c:88: parse error before `*'
nspostgres.c:97: parse error before `*'
nspostgres.c:106: parse error before `*'
nspostgres.c: In function `Ns_PgOpenDb':
nspostgres.c:116: `handle' undeclared (first use in this function)
nspostgres.c:116: (Each undeclared identifier is reported only once
nspostgres.c:116: for each function it appears in.)
nspostgres.c:158: `NS_DML' undeclared (first use in this function)
nspostgres.c: At top level:
nspostgres.c:175: parse error before `*'
nspostgres.c: In function `Ns_PgCloseDb':
nspostgres.c:180: `handle' undeclared (first use in this function)
nspostgres.c: At top level:
nspostgres.c:207: parse error before `*'
nspostgres.c: In function `Ns_PgSetErrorstate':
nspostgres.c:209: `handle' undeclared (first use in this function)
nspostgres.c: At top level:
nspostgres.c:243: parse error before `*'
nspostgres.c: In function `set_transaction_state':
nspostgres.c:244: `handle' undeclared (first use in this function)
nspostgres.c:245: `sql' undeclared (first use in this function)
nspostgres.c:248: `asfuncname' undeclared (first use in this function)
nspostgres.c: At top level:
nspostgres.c:272: parse error before `*'
nspostgres.c: In function `Ns_PgExec':
nspostgres.c:278: `sql' undeclared (first use in this function)
nspostgres.c:283: `handle' undeclared (first use in this function)
nspostgres.c:399: `NS_ROWS' undeclared (first use in this function)
nspostgres.c:403: `NS_DML' undeclared (first use in this function)
nspostgres.c:416: warning: control reaches end of non-void function
nspostgres.c: At top level:
nspostgres.c:420: parse error before `*'
nspostgres.c: In function `Ns_PgResetHandle':
nspostgres.c:424: `handle' undeclared (first use in this function)
nspostgres.c: At top level:
nspostgres.c:456: parse error before `*'
nspostgres.c: In function `Ns_PgSelect':
nspostgres.c:463: `handle' undeclared (first use in this function)
nspostgres.c:468: `sql' undeclared (first use in this function)
nspostgres.c: At top level:
nspostgres.c:502: parse error before `*'
nspostgres.c: In function `Ns_PgGetRow':
nspostgres.c:508: `handle' undeclared (first use in this function)
nspostgres.c:513: `row' undeclared (first use in this function)
nspostgres.c:529: `NS_END_DATA' undeclared (first use in this function)
nspostgres.c: At top level:
nspostgres.c:547: parse error before `*'
nspostgres.c: In function `Ns_PgFlush':
nspostgres.c:552: `handle' undeclared (first use in this function)
nspostgres.c: At top level:
nspostgres.c:574: parse error before `*'
nspostgres.c:575: parse error before `*'
nspostgres.c:575: warning: return type defaults to `int'
nspostgres.c: In function `Ns_PgGetTableInfo':
nspostgres.c:580: `Ns_DbTableInfo' undeclared (first use in this function)
nspostgres.c:580: `tinfo' undeclared (first use in this function)
nspostgres.c:580: invalid lvalue in assignment
nspostgres.c:581: parse error before `int'
nspostgres.c:585: `handle' undeclared (first use in this function)
nspostgres.c:590: `table' undeclared (first use in this function)
nspostgres.c:606: `status' undeclared (first use in this function)
nspostgres.c:607: `name' undeclared (first use in this function)
nspostgres.c:608: `type' undeclared (first use in this function)
nspostgres.c:630: `NS_END_DATA' undeclared (first use in this function)
nspostgres.c:637: warning: control reaches end of non-void function
nspostgres.c: At top level:
nspostgres.c:643: parse error before `Ns_DbHandle'
nspostgres.c: In function `Ns_PgTableList':
nspostgres.c:651: `pds' undeclared (first use in this function)
nspostgres.c:656: `handle' undeclared (first use in this function)
nspostgres.c:664: `fSystemTables' undeclared (first use in this function)
nspostgres.c:672: warning: implicit declaration of function `Ns_DbGetRow'
nspostgres.c:678: warning: passing arg 3 of `Tcl_DStringAppend' as signed due to prototype
nspostgres.c:682: `NS_END_DATA' undeclared (first use in this function)
nspostgres.c: In function `encode3':
nspostgres.c:748: warning: passing arg 1 of `enc_one' with different width due to prototype
nspostgres.c:749: warning: passing arg 1 of `enc_one' with different width due to prototype
nspostgres.c:750: warning: passing arg 1 of `enc_one' with different width due to prototype
nspostgres.c:751: warning: passing arg 1 of `enc_one' with different width due to prototype
nspostgres.c: In function `decode3':
nspostgres.c:771: warning: passing arg 1 of `get_one' with different width due to prototype
nspostgres.c:772: warning: passing arg 1 of `get_one' with different width due to prototype
nspostgres.c:773: warning: passing arg 1 of `get_one' with different width due to prototype
nspostgres.c:774: warning: passing arg 1 of `get_one' with different width due to prototype
nspostgres.c: At top level:
nspostgres.c:789: parse error before `Ns_DbHandle'
nspostgres.c: In function `blob_get':
nspostgres.c:791: `handle' undeclared (first use in this function)
nspostgres.c:800: `lob_id' undeclared (first use in this function)
nspostgres.c:812: `NS_ROWS' undeclared (first use in this function)
nspostgres.c:813: `interp' undeclared (first use in this function)
nspostgres.c: In function `stream_actually_write':
nspostgres.c:863: warning: passing arg 3 of `write' as unsigned due to prototype
nspostgres.c: At top level:
nspostgres.c:876: parse error before `Ns_DbHandle'
nspostgres.c: In function `blob_put':
nspostgres.c:883: `value' undeclared (first use in this function)
nspostgres.c:887: `blob_id' undeclared (first use in this function)
nspostgres.c:900: `handle' undeclared (first use in this function)
nspostgres.c:900: `NS_DML' undeclared (first use in this function)
nspostgres.c:901: `interp' undeclared (first use in this function)
nspostgres.c:881: warning: `value_ptr' might be used uninitialized in this function
nspostgres.c: At top level:
nspostgres.c:916: parse error before `Ns_DbHandle'
nspostgres.c: In function `blob_dml_file':
nspostgres.c:923: `filename' undeclared (first use in this function)
nspostgres.c:929: `interp' undeclared (first use in this function)
nspostgres.c:935: `blob_id' undeclared (first use in this function)
nspostgres.c:947: `handle' undeclared (first use in this function)
nspostgres.c:947: `NS_DML' undeclared (first use in this function)
nspostgres.c: At top level:
nspostgres.c:973: parse error before `Ns_DbHandle'
nspostgres.c: In function `blob_send_to_stream':
nspostgres.c:976: `handle' undeclared (first use in this function)
nspostgres.c:983: `to_conn_p' undeclared (first use in this function)
nspostgres.c:985: `interp' undeclared (first use in this function)
nspostgres.c:996: `filename' undeclared (first use in this function)
nspostgres.c:1020: `lob_id' undeclared (first use in this function)
nspostgres.c:1032: `NS_ROWS' undeclared (first use in this function)
nspostgres.c:979: warning: `fd' might be used uninitialized in this function
nspostgres.c: At top level:
nspostgres.c:1113: parse error before `Ns_DbHandle'
nspostgres.c: In function `DbFail':
nspostgres.c:1115: `handle' undeclared (first use in this function)
nspostgres.c:1118: `interp' undeclared (first use in this function)
nspostgres.c:1118: `cmd' undeclared (first use in this function)
nspostgres.c:1135: `sql' undeclared (first use in this function)
nspostgres.c: In function `parse_bind_variables':
nspostgres.c:1210: warning: unused variable `first_bind'
nspostgres.c: In function `PgBindCmd':
nspostgres.c:1319: `Ns_DbHandle' undeclared (first use in this function)
nspostgres.c:1319: `handle' undeclared (first use in this function)
nspostgres.c:1319: warning: statement with no effect
nspostgres.c:1320: parse error before `*'
nspostgres.c:1333: warning: implicit declaration of function `Ns_TclDbGetHandle'
nspostgres.c:1345: warning: implicit declaration of function `Ns_DbDriverName'
nspostgres.c:1345: warning: comparison between pointer and integer
nspostgres.c:1351: `cmd' undeclared (first use in this function)
nspostgres.c:1354: `set' undeclared (first use in this function)
nspostgres.c:1359: `sql' undeclared (first use in this function)
nspostgres.c:1391: `value' undeclared (first use in this function)
nspostgres.c:1426: `p' undeclared (first use in this function)
nspostgres.c:1461: warning: implicit declaration of function `Ns_DbDML'
nspostgres.c:1465: `rowPtr' undeclared (first use in this function)
nspostgres.c:1465: warning: implicit declaration of function `Ns_Db1Row'
nspostgres.c:1474: warning: implicit declaration of function `Ns_Db0or1Row'
nspostgres.c:1485: warning: implicit declaration of function `Ns_DbSelect'
nspostgres.c:1492: warning: implicit declaration of function `Ns_DbExec'
nspostgres.c:1493: `NS_DML' undeclared (first use in this function)
nspostgres.c:1496: `NS_ROWS' undeclared (first use in this function)
nspostgres.c:1494: warning: unreachable code at beginning of switch statement
nspostgres.c: In function `PgCmd':
nspostgres.c:1522: `Ns_DbHandle' undeclared (first use in this function)
nspostgres.c:1522: `handle' undeclared (first use in this function)
nspostgres.c:1522: warning: statement with no effect
nspostgres.c:1523: parse error before `*'
nspostgres.c:1529: `pgconn' undeclared (first use in this function)
nspostgres.c:1535: warning: comparison between pointer and integer
nspostgres.c: At top level:
nspostgres.c:1670: parse error before `*'
nspostgres.c: In function `Ns_PgBindRow':
nspostgres.c:1677: `handle' undeclared (first use in this function)
nspostgres.c: At top level:
nspostgres.c:1750: parse error before `Ns_DbTableInfo'
nspostgres.c: In function `pg_get_column_index':
nspostgres.c:1755: `interp' undeclared (first use in this function)
nspostgres.c:1755: `indexStr' undeclared (first use in this function)
nspostgres.c:1755: warning: passing arg 3 of `Tcl_GetInt' from incompatible pointer type
nspostgres.c:1760: `tinfo' undeclared (first use in this function)
nspostgres.c: In function `pg_column_command':
nspostgres.c:1786: `Ns_DbHandle' undeclared (first use in this function)
nspostgres.c:1786: `handle' undeclared (first use in this function)
nspostgres.c:1786: warning: statement with no effect
nspostgres.c:1787: `Ns_DbTableInfo' undeclared (first use in this function)
nspostgres.c:1787: `tinfo' undeclared (first use in this function)
nspostgres.c:1787: invalid lvalue in assignment
nspostgres.c:1788: parse error before `int'
nspostgres.c:1831: `colindex' undeclared (first use in this function)
nspostgres.c: In function `pg_table_command':
nspostgres.c:1949: `Ns_DbHandle' undeclared (first use in this function)
nspostgres.c:1949: `handle' undeclared (first use in this function)
nspostgres.c:1949: warning: statement with no effect
nspostgres.c: At top level:
nspostgres.c:2072: parse error before `*'
nspostgres.c:2074: warning: return type defaults to `int'
nspostgres.c: In function `Ns_DbNewTableInfo':
nspostgres.c:2075: `Ns_DbTableInfo' undeclared (first use in this function)
nspostgres.c:2075: `tinfo' undeclared (first use in this function)
nspostgres.c:2075: warning: statement with no effect
nspostgres.c:2086: warning: control reaches end of non-void function
nspostgres.c: At top level:
nspostgres.c:2091: parse error before `*'
nspostgres.c: In function `Ns_DbAddColumnInfo':
nspostgres.c:2093: `tinfo' undeclared (first use in this function)
nspostgres.c:2101: `column_info' undeclared (first use in this function)
nspostgres.c: At top level:
nspostgres.c:2108: parse error before `*'
nspostgres.c: In function `Ns_DbFreeTableInfo':
nspostgres.c:2112: `tinfo' undeclared (first use in this function)
nspostgres.c: At top level:
nspostgres.c:2128: parse error before `*'
nspostgres.c: In function `Ns_DbColumnIndex':
nspostgres.c:2133: `tinfo' undeclared (first use in this function)
nspostgres.c:2136: `name' undeclared (first use in this function)
make: *** [nspostgres.o] Error 1

Mac OS X, 10.3.2 (Panther)
AOLserver 4.0.1
PG 7.4.1
Tcl 8.4.5
nscache-1.5
nssha1-0.1

Home directories of postgres and aolserver respectively:

POSTGRES = /usr/local/pgsql
NSHOME = /usr/local/aolserver

make version: GNU Make version 3.79, Built for powerpc-apple-darwin7.0

I downloaded and untarred nspostgres-4.0beta1 into my /usr/local/aolserver/ directory.

I edited this line in the Makefile from this:

# MODLIBS  = -L$(PGLIB) -lpq

to this:

MODLIBS  = -L$(PGLIB) -lpq -lnsdb

(Per Russell Muetzelfeldt's suggestion above)

However, when I issue the command:

$ make POSTGRES=/usr/local/pgsql INST=/usr/local/aolserver ACS=1

I get the following error message:

gcc -pipe -DBIND_EMULATION -I/usr/local/pgsql/include -DFOR_ACS_USE -Os -Wall -Wconversion -Wno-implicit-int -fno-common -DMAC_OSX_TCL -DHAVE_CFBUNDLE -DUSE_VFORK -DTCL_DEFAULT_ENCODING=\"utf-8\" -I/usr/local/aolserver/include -I/usr/local/aolserver/include -DNO_CONST  -DHAVE_UNISTD_H=1 -DHAVE_LIMITS_H=1 -DTCL_THREADS=1 -DUSE_THREAD_ALLOC=1 -D_REENTRANT=1 -D_THREAD_SAFE=1 -DHAVE_PTHREAD_ATTR_SETSTACKSIZE=1 -DHAVE_READDIR_R=1 -DTCL_WIDE_INT_TYPE=long\ long -DWORDS_BIGENDIAN=1 -DHAVE_GETCWD=1 -DHAVE_OPENDIR=1 -DHAVE_STRSTR=1 -DHAVE_STRTOL=1 -DHAVE_STRTOLL=1 -DHAVE_STRTOULL=1 -DHAVE_TMPNAM=1 -DHAVE_WAITPID=1 -DNO_VALUES_H=1 -DHAVE_UNISTD_H=1 -DHAVE_SYS_PARAM_H=1 -DUSE_TERMIOS=1 -DHAVE_SYS_TIME_H=1 -DTIME_WITH_SYS_TIME=1 -DHAVE_TM_ZONE=1 -DHAVE_GMTIME_R=1 -DHAVE_LOCALTIME_R=1 -DHAVE_TM_GMTOFF=1 -DHAVE_ST_BLKSIZE=1 -DSTDC_HEADERS=1 -DHAVE_SIGNED_CHAR=1 -DHAVE_PUTENV_THAT_COPIES=1 -DHAVE_LANGINFO=1 -DHAVE_SYS_IOCTL_H=1 -DHAVE_SYS_FILIO_H=1  -DHAVE_TIMEGM=1 -DHAVE_POLL=1 -DHAVE_DRAND48=1 -DHAVE_RANDOM=1 -DHAVE__NSGETENVIRON=1 -DUSE_DYLD=1 -DHAVE_CMMSG=1    -c -o nspostgres.o nspostgres.c
nspostgres.c: In function `Ns_PgTableList':
nspostgres.c:678: warning: passing arg 3 of `Tcl_DStringAppend' as signed due to prototype
nspostgres.c: In function `encode3':
nspostgres.c:748: warning: passing arg 1 of `enc_one' with different width due to prototype
nspostgres.c:749: warning: passing arg 1 of `enc_one' with different width due to prototype
nspostgres.c:750: warning: passing arg 1 of `enc_one' with different width due to prototype
nspostgres.c:751: warning: passing arg 1 of `enc_one' with different width due to prototype
nspostgres.c: In function `decode3':
nspostgres.c:771: warning: passing arg 1 of `get_one' with different width due to prototype
nspostgres.c:772: warning: passing arg 1 of `get_one' with different width due to prototype
nspostgres.c:773: warning: passing arg 1 of `get_one' with different width due to prototype
nspostgres.c:774: warning: passing arg 1 of `get_one' with different width due to prototype
nspostgres.c: In function `stream_actually_write':
nspostgres.c:863: warning: passing arg 3 of `write' as unsigned due to prototype
nspostgres.c: In function `blob_send_to_stream':
nspostgres.c:979: warning: `fd' might be used uninitialized in this function
nspostgres.c:981: warning: `conn' might be used uninitialized in this function
nspostgres.c: In function `parse_bind_variables':
nspostgres.c:1210: warning: unused variable `first_bind'
nspostgres.c: In function `PgBindCmd':
nspostgres.c:1326: warning: unused variable `value_frag_len'
/bin/rm -f nspostgres.so
cc -bundle -L/usr/local/aolserver/lib -o nspostgres.so nspostgres.o -L/usr/local/pgsql/lib -lpq -lnsdb -lnsthread -lnsd -L/usr/local/aolserver/lib -ltcl8.4  -lpthread -framework CoreFoundation
ld: Undefined symbols:
_SSL_pending
_BIO_free
_BIO_new_mem_buf
_DH_check
_DH_generate_parameters
_DH_size
_ERR_get_error
_ERR_reason_error_string
_EVP_PKEY_free
_PEM_read_DHparams
_PEM_read_PrivateKey
_PEM_read_X509
_PEM_read_bio_DHparams
_SSL_CTX_ctrl
_SSL_CTX_free
_SSL_CTX_load_verify_locations
_SSL_CTX_new
_SSL_CTX_set_tmp_dh_callback
_SSL_CTX_set_verify
_SSL_CTX_set_verify_depth
_SSL_connect
_SSL_free
_SSL_get_error
_SSL_get_ex_data
_SSL_get_peer_certificate
_SSL_library_init
_SSL_load_error_strings
_SSL_new
_SSL_read
_SSL_set_ex_data
_SSL_set_fd
_SSL_shutdown
_SSL_write
_TLSv1_method
_X509_NAME_get_text_by_NID
_X509_NAME_oneline
_X509_check_private_key
_X509_free
_X509_get_subject_name
make: *** [nspostgres.so] Error 1

I did compile Postgres with OpenSSL support.  Here's the configure line I used:

./configure --with-includes=/sw/include --with-libs=/sw/lib --with-openssl --with-python --with-perl

I tried adding the line you suggested.  This time, I got the following error when I tried to compile nspostgres:

dhcp232:/usr/local/src/aolserver/nspostgres-4.0beta1 chris$ make POSTGRES=/usr/local/pgsql INST=/usr/local/aolserver ACS=1
gcc -pipe -DBIND_EMULATION -I/usr/local/pgsql/include -DFOR_ACS_USE -Os -Wall -Wconversion -Wno-implicit-int -fno-common -DMAC_OSX_TCL -DHAVE_CFBUNDLE -DUSE_VFORK -DTCL_DEFAULT_ENCODING=\"utf-8\" -I/usr/local/aolserver/include -I/usr/local/aolserver/include -DNO_CONST  -DHAVE_UNISTD_H=1 -DHAVE_LIMITS_H=1 -DTCL_THREADS=1 -DUSE_THREAD_ALLOC=1 -D_REENTRANT=1 -D_THREAD_SAFE=1 -DHAVE_PTHREAD_ATTR_SETSTACKSIZE=1 -DHAVE_READDIR_R=1 -DTCL_WIDE_INT_TYPE=long\ long -DWORDS_BIGENDIAN=1 -DHAVE_GETCWD=1 -DHAVE_OPENDIR=1 -DHAVE_STRSTR=1 -DHAVE_STRTOL=1 -DHAVE_STRTOLL=1 -DHAVE_STRTOULL=1 -DHAVE_TMPNAM=1 -DHAVE_WAITPID=1 -DNO_VALUES_H=1 -DHAVE_UNISTD_H=1 -DHAVE_SYS_PARAM_H=1 -DUSE_TERMIOS=1 -DHAVE_SYS_TIME_H=1 -DTIME_WITH_SYS_TIME=1 -DHAVE_TM_ZONE=1 -DHAVE_GMTIME_R=1 -DHAVE_LOCALTIME_R=1 -DHAVE_TM_GMTOFF=1 -DHAVE_ST_BLKSIZE=1 -DSTDC_HEADERS=1 -DHAVE_SIGNED_CHAR=1 -DHAVE_PUTENV_THAT_COPIES=1 -DHAVE_LANGINFO=1 -DHAVE_SYS_IOCTL_H=1 -DHAVE_SYS_FILIO_H=1  -DHAVE_TIMEGM=1 -DHAVE_POLL=1 -DHAVE_DRAND48=1 -DHAVE_RANDOM=1 -DHAVE__NSGETENVIRON=1 -DUSE_DYLD=1 -DHAVE_CMMSG=1    -c -o nspostgres.o nspostgres.c
nspostgres.c: In function `Ns_PgTableList':
nspostgres.c:678: warning: passing arg 3 of `Tcl_DStringAppend' as signed due to prototype
nspostgres.c: In function `encode3':
nspostgres.c:748: warning: passing arg 1 of `enc_one' with different width due to prototype
nspostgres.c:749: warning: passing arg 1 of `enc_one' with different width due to prototype
nspostgres.c:750: warning: passing arg 1 of `enc_one' with different width due to prototype
nspostgres.c:751: warning: passing arg 1 of `enc_one' with different width due to prototype
nspostgres.c: In function `decode3':
nspostgres.c:771: warning: passing arg 1 of `get_one' with different width due to prototype
nspostgres.c:772: warning: passing arg 1 of `get_one' with different width due to prototype
nspostgres.c:773: warning: passing arg 1 of `get_one' with different width due to prototype
nspostgres.c:774: warning: passing arg 1 of `get_one' with different width due to prototype
nspostgres.c: In function `stream_actually_write':
nspostgres.c:863: warning: passing arg 3 of `write' as unsigned due to prototype
nspostgres.c: In function `blob_send_to_stream':
nspostgres.c:979: warning: `fd' might be used uninitialized in this function
nspostgres.c:981: warning: `conn' might be used uninitialized in this function
nspostgres.c: In function `parse_bind_variables':
nspostgres.c:1210: warning: unused variable `first_bind'
nspostgres.c: In function `PgBindCmd':
nspostgres.c:1326: warning: unused variable `value_frag_len'
/bin/rm -f nspostgres.so
cc -bundle -L/usr/local/aolserver/lib -o nspostgres.so nspostgres.o -L/usr/local/pgsql/lib -lpq -lnsdb -lssl -lnsthread -lnsd -L/usr/local/aolserver/lib -ltcl8.4  -lpthread -framework CoreFoundation
ld: /usr/local/pgsql/lib/libpq.a(fe-secure.o) illegal reference to symbol: _BIO_free defined in indirectly referenced dynamic library /usr/lib/libcrypto.0.9.7.dylib
make: *** [nspostgres.so] Error 1

When compiling nspostgres (and after fixing some other bugs, like -lnsdb flag),
/usr/local/src/aolserver45/nspostgres# make POSTGRES=$PG ACS=1 NSHOME=${NS}
I'm getting that error:

ar rv libnspostgres.a
ar: no archive members specified
usage:  ar -d [-TLsv] archive file ...
        ar -m [-TLsv] archive file ...
        ar -m [-abiTLsv] position archive file ...
        ar -p [-TLsv] archive [file ...]
        ar -q [-cTLsv] archive file ...
        ar -r [-cuTLsv] archive file ...
        ar -r [-abciuTLsv] position archive file ...
        ar -t [-TLsv] archive [file ...]
        ar -x [-ouTLsv] archive [file ...]
make: *** [libnspostgres.a] Error 1
/usr/local/src/aolserver45/nspostgres#

I've also tried:
/usr/local/src/aolserver45/nspostgres# make install POSTGRES=$PG ACS=1 AOLSERVER=/usr/local/aolserver

/usr/local/aolserver/bin/tclsh8.4 /usr/local/aolserver/bin/nsinstall.tcl -d /usr/local/aolserver/bin -e nspostgres.so
installed: /usr/local/aolserver45/bin/nspostgres.so (0755)
/usr/local/aolserver/bin/tclsh8.4 /usr/local/aolserver/bin/nsinstall.tcl -d /usr/local/aolserver/lib -e libnspostgres.dylib
installed: /usr/local/aolserver45/lib/libnspostgres.dylib (0755)
/usr/local/aolserver/bin/tclsh8.4 /usr/local/aolserver/bin/nsinstall.tcl -d /usr/local/aolserver/lib libnspostgres.a
ranlib /usr/local/aolserver/lib/libnspostgres.a
ranlib: can't open file: /usr/local/aolserver/lib/libnspostgres.a (No such file or directory)
make: *** [install-dll] Error 1
/usr/local/src/aolserver45/nspostgres#

But can't fix that.

I added to the build system in aolserver nspostgres...

I added POSTGRESQL = SEPARATELY PGLIB = /some/path/lib PGINC = /some/where/include

And, POSTGRESQL = PG_CONFIG (in which case pg_config is the first one found in the $PATH)

And, POSTGRESQL = PG_CONFIG PG_CONFIG = /usr/some/where/bin/pg_config (so you can select which of many postgreses you want)

Read the Makefile, read the README... and finally, I ask a favor:

If you are having any problems compiling nspostgres with my buildtime extensions and you have not altered files, I'd be interested in seeing what your issue is so I can try to correct it.

Thanks

-Jim

Just checking in... did you get nspostgres going?

-Jim