Forum OpenACS Q&A: Re: RDBMS type could not be determined for any pool
It looks like you should not include the dash with "ps" commands. So ps -auxwww becomes ps auxwww. You can also use ps aux to view 1 line per process.
The first number in the ps is the process id, pid for short. The commands above both show 502, so you have only 1 aolserver running at the time you ran ps auxwww.
The svc commands are part of daemontools, which is an automatic startup facility for aolserver. Avoid using them when you are using the other method to start aolserver. You may want to type svc -d /service/service0 just to verify that daemontools does not try to restart aolserver on its own.
Since you used the oacs-5-0 instructions for installing aolserver (instead of https://openacs.org/doc/openacs-5-2/aolserver4.html ), get a fresh copy of config.tcl from cvs to verify that you have one that works well with oacs-5-2. Get it from: http://cvs.openacs.org/cvs/*checkout*/openacs-4/etc/config.tcl?rev=1.32.2.1
Only edit these to begin with:
set hostname [ns_info hostname] set address 0.0.0.0 set db_host localhost set db_port "" set db_user $server
Then verify that postmaster is running and aolserver is not running:
ps aux | grep postmaster ps aux | nsd
Here is how it looks when I verify here:
~ bohr$ ps aux | grep postmaster postgres 346 0.0 0.0 38040 208 ?? S 21Jan06 0:04.23 /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/dat root 4326 0.0 0.1 18172 336 std S+ 1:08PM 0:00.00 grep postmaster ~ bohr$ ps aux | grep nsd root 4328 0.0 0.0 18644 92 std R+ 1:08PM 0:00.00 grep nsd
My example shows 1 pid for postmaster, number 346. No existing processes for aolserver.
To rule out any problems carrying over from earlier attempts at installing, drop the current database, and re-create it with the CREATEDB command.
Then start aolserver, and watch the logs.
Post how it breaks.
I tried to reinstall aolserver.When i installed nspostgres following the OpenACS-5.2.0 manual i'm getting the following error
make install POSTGRES=LSB ACS=1 INST=/usr/local/aolserver AOLSERVER=/usr/local/aolserver
gcc -pipe -DBIND_EMULATION -I/usr/include -DFOR_ACS_USE -O2 -Wall -Wno-implicit-int -fno-strict-aliasing -fPIC -I/usr/local/aolserver/include -I/usr/local/include -DNO_CONST -DTCL_THREADS=1 -DUSE_THREAD_ALLOC=1 -D_REENTRANT=1 -D_THREAD_SAFE=1 -DHAVE_PTHREAD_ATTR_SETSTACKSIZE=1 -DHAVE_PTHREAD_ATFORK=1 -DHAVE_READDIR_R=1 -DHAVE_THREE_ARG_READDIR_R=1 -DPEEK_XCLOSEIM=1 -D_LARGEFILE64_SOURCE=1 -DTCL_WIDE_INT_TYPE=long\ long -DHAVE_STRUCT_STAT64=1 -DHAVE_OPEN64=1 -DHAVE_LSEEK64=1 -DHAVE_TYPE_OFF64_T=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 -DHAVE_LIMITS_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_TIMEZONE_VAR=1 -DHAVE_ST_BLKSIZE=1 -DSTDC_HEADERS=1 -DHAVE_SIGNED_CHAR=1 -DHAVE_LANGINFO=1 -DHAVE_SYS_IOCTL_H=1 -DTCL_CFG_OPTIMIZED=1 -DTCL_CFG_DEBUG=1 -DHAVE_INTTYPES_H=1 -DHAVE_TIMEGM=1 -DHAVE_POLL=1 -DHAVE_DRAND48=1 -DHAVE_RANDOM=1 -DHAVE_CMMSG=1 -DHAVE_GETADDRINFO=1 -DHAVE_GETNAMEINFO=1 -DHAVE_ZLIB_H=1 -DHAVE_LIBZ=1 -c -o nspostgres.o nspostgres.c
In file included from nspostgres.c:32:
nspostgres.h:48:22: libpq-fe.h: No such file or directory
In file included from nspostgres.c:32:
nspostgres.h:169: syntax error before "PGconn"
nspostgres.h:169: warning: no semicolon at end of struct or union
nspostgres.h:171: syntax error before '*' token
nspostgres.h:171: warning: data definition has no type or storage class
nspostgres.h:176: syntax error before '}' token
nspostgres.h:176: warning: data definition has no type or storage class
nspostgres.c: In function `Ns_PgOpenDb':
nspostgres.c:109: `nsConn' undeclared (first use in this function)
nspostgres.c:109: (Each undeclared identifier is reported only once
nspostgres.c:109: for each function it appears in.)
nspostgres.c:110: `PGconn' undeclared (first use in this function)
nspostgres.c:110: `pgConn' undeclared (first use in this function)
nspostgres.c:134: warning: implicit declaration of function `PQsetdbLogin'
nspostgres.c:142: warning: implicit declaration of function `PQstatus'
nspostgres.c:142: `CONNECTION_OK' undeclared (first use in this function)
nspostgres.c:164: warning: implicit declaration of function `PQerrorMessage'
nspostgres.c:165: warning: implicit declaration of function `PQfinish'
nspostgres.c: In function `Ns_PgCloseDb':
nspostgres.c:178: `nsConn' undeclared (first use in this function)
nspostgres.c: In function `Ns_PgSetErrorstate':
nspostgres.c:209: `nsConn' undeclared (first use in this function)
nspostgres.c:214: warning: implicit declaration of function `PQresultStatus'
nspostgres.c:215: `PGRES_EMPTY_QUERY' undeclared (first use in this function)
nspostgres.c:216: `PGRES_COMMAND_OK' undeclared (first use in this function)
nspostgres.c:217: `PGRES_TUPLES_OK' undeclared (first use in this function)
nspostgres.c:218: `PGRES_COPY_OUT' undeclared (first use in this function)
nspostgres.c:219: `PGRES_COPY_IN' undeclared (first use in this function)
nspostgres.c:220: `PGRES_NONFATAL_ERROR' undeclared (first use in this function)
nspostgres.c:221: warning: implicit declaration of function `PQresultErrorMessage'
nspostgres.c:221: warning: passing arg 2 of `Tcl_DStringAppend' makes pointer from integer without a cast
nspostgres.c:224: `PGRES_FATAL_ERROR' undeclared (first use in this function)
nspostgres.c:225: warning: passing arg 2 of `Tcl_DStringAppend' makes pointer from integer without a cast
nspostgres.c:228: `PGRES_BAD_RESPONSE' undeclared (first use in this function)
nspostgres.c:230: warning: passing arg 2 of `Tcl_DStringAppend' makes pointer from integer without a cast
nspostgres.c: In function `set_transaction_state':
nspostgres.c:244: `nsConn' undeclared (first use in this function)
nspostgres.c: In function `Ns_PgExec':
nspostgres.c:274: `nsConn' undeclared (first use in this function)
nspostgres.c:290: warning: implicit declaration of function `PQclear'
nspostgres.c:308: warning: implicit declaration of function `PQexec'
nspostgres.c:320: `CONNECTION_BAD' undeclared (first use in this function)
nspostgres.c:330: `PGRES_NONFATAL_ERROR' undeclared (first use in this function)
nspostgres.c:397: `PGRES_TUPLES_OK' undeclared (first use in this function)
nspostgres.c:401: `PGRES_COPY_IN' undeclared (first use in this function)
nspostgres.c:402: `PGRES_COPY_OUT' undeclared (first use in this function)
nspostgres.c:405: `PGRES_COMMAND_OK' undeclared (first use in this function)
nspostgres.c:407: warning: implicit declaration of function `PQcmdTuples'
nspostgres.c:407: warning: passing arg 1 of `sscanf' makes pointer from integer without a cast
nspostgres.c:413: warning: passing arg 3 of `Ns_DbSetException' makes pointer from integer without a cast
nspostgres.c: In function `Ns_PgResetHandle':
nspostgres.c:423: `nsConn' undeclared (first use in this function)
nspostgres.c:436: `PGRES_COMMAND_OK' undeclared (first use in this function)
nspostgres.c: In function `Ns_PgSelect':
nspostgres.c:461: `nsConn' undeclared (first use in this function)
nspostgres.c:478: `PGRES_TUPLES_OK' undeclared (first use in this function)
nspostgres.c:480: warning: implicit declaration of function `PQnfields'
nspostgres.c:481: warning: implicit declaration of function `PQntuples'
nspostgres.c:485: warning: implicit declaration of function `PQfname'
nspostgres.c: In function `Ns_PgGetRow':
nspostgres.c:506: `nsConn' undeclared (first use in this function)
nspostgres.c:534: warning: implicit declaration of function `PQgetvalue'
nspostgres.c: In function `Ns_PgFlush':
nspostgres.c:551: `nsConn' undeclared (first use in this function)
nspostgres.c: In function `blob_get':
nspostgres.c:792: `nsConn' undeclared (first use in this function)
nspostgres.c:792: syntax error before ')' token
nspostgres.c:820: warning: assignment makes pointer from integer without a cast
nspostgres.c:821: warning: assignment makes pointer from integer without a cast
nspostgres.c: In function `blob_send_to_stream':
nspostgres.c:977: `nsConn' undeclared (first use in this function)
nspostgres.c:977: syntax error before ')' token
nspostgres.c:1040: warning: assignment makes pointer from integer without a cast
nspostgres.c:1041: warning: assignment makes pointer from integer without a cast
nspostgres.c: In function `DbFail':
nspostgres.c:1116: `pgconn' undeclared (first use in this function)
nspostgres.c:1130: warning: assignment makes pointer from integer without a cast
nspostgres.c: In function `parse_bind_variables':
nspostgres.c:1211: warning: unused variable `first_bind'
nspostgres.c: In function `PgBindCmd':
nspostgres.c:1327: warning: unused variable `value_frag_len'
nspostgres.c: In function `PgCmd':
nspostgres.c:1524: `pgconn' undeclared (first use in this function)
nspostgres.c:1530: syntax error before ')' token
nspostgres.c:1601: warning: implicit declaration of function `PQdb'
nspostgres.c:1603: warning: implicit declaration of function `PQhost'
nspostgres.c:1605: warning: implicit declaration of function `PQoptions'
nspostgres.c:1607: warning: implicit declaration of function `PQport'
nspostgres.c:1614: `CONNECTION_OK' undeclared (first use in this function)
nspostgres.c: In function `Ns_PgBindRow':
nspostgres.c:1675: `nsConn' undeclared (first use in this function)
nspostgres.c:1691: `PGRES_TUPLES_OK' undeclared (first use in this function)
make: *** [nspostgres.o] Error 1
please help