Pascal,
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,
