Forum OpenACS Q&A: Re: RDBMS type could not be determined for any pool

Collapse
15: Re: RDBMS type could not be determined for any pool (response to 1)
Posted by Torben Brosten on 02/03/06 10:18 PM

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.

Collapse
16: Re: Re: RDBMS type could not be determined for any pool (response to 15)
Posted by anjali n on 02/06/06 05:16 AM
thanks for the reply.I'll work on it and let you know.
Collapse
17: error (response to 16)
Posted by anjali n on 02/06/06 03:36 PM
Hi,
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