Pascal,
Thanks,
That was fast :) ... but for whatever reason does not seem to work in my case :(
I know that you said that you won't maintain it, but what would you say of the following errors:
[07/May/2001:14:02:55][441.114][-conn0-] Notice: dbdrv: opening database 'postgres:localhost:5432:test'
[07/May/2001:14:02:55][441.114][-conn0-] Notice: Opening test on localhost
[07/May/2001:14:02:55][441.114][-conn0-] Error: Ns_PgOpenDb(postgres): Could not connect to localhost:5432:test:
connectDBStart() -- socket() failed: errno=0 No error
[07/May/2001:14:02:55][441.114][-conn0-] Error: dbdrv: failed to open database 'postgres:localhost:5432:test'
[07/May/2001:14:02:55][441.114][-conn0-] Error: could not allocate 1 handle from pool "pg_test"
could not allocate 1 handle from pool "pg_test"
while executing
"ns_db gethandle $pool"
invoked from within
"set db [ns_db gethandle $pool]"
(file "d:/Program Files/AOLserver/servers/server1/pages/test.tcl" line 4)
invoked from within
"source $file"
invoked from within
"ns_sourceproc cns0 {}"
The following ${homedir}/config.tcl is used (pgdriver-related section only):
# # db drivers # ns_section "ns/db/drivers" ns_param mysql nsmysql.so ns_param postgres pgdriver.dll ns_section "ns/db/pool/pg_flex" ns_param Driver postgres ns_param Connections 5 ;# 5 is a good number. Increase according to your needs ns_param DataSource localhost:5432:flex ;# Replace 'yourdb' with the name of your database in PG ns_param User nsadmin ;# User and password AOLserver will use to connect ns_param Password "" ns_param Verbose On ;# Set it to On to see all queries. Good for debugging SQL. ns_param LogSQLErrors On ns_param ExtendedTableInfo On # ns_param MaxOpen 1000000000 ;# Max time to keep idle db connection open # ns_param MaxIdle 1000000000 ;# Max time to keep active db connection open
This is all on WinNT4 with AOLServer 3.2 (AOLserver/3.2 (aolserver3_2) for win32 built on Oct 25 2000 at 17:19:06)
Thanks,