On my Debian 2.2 (potato) system, I'm running Aolserver 3.2-5 und
Postgresql 7.1r3. My default database "mir::germdb" is accessible, my
alternate database "mir::osu" is not. Here's the relevant part
[least I think it's the relevant part :)] of my configuration:
######################
#
# Database Pools
#
ns_section "ns/db/pools"
ns_param main "The main database pool"
ns_section "ns/db/pool/main"
ns_param Driver postgres
ns_param Connections 4
ns_param MaxOpen 1000000000
ns_param MaxIdle 1000000000
ns_param DataSource mir::germdb
ns_param User aolserver
ns_param connections 1
ns_param maxidle 600
ns_param maxopen 3600
ns_param password x
ns_param verbose false
ns_param logsqlerrors false
ns_param extendedtableinfo true
ns_param osu "OSU db"
ns_section "ns/db/pool/osu"
ns_param Driver postgres
ns_param Connections 4
ns_param MaxOpen 1000000000
ns_param MaxIdle 1000000000
ns_param DataSource mir::osu
ns_param User aolserver
ns_param connections 1
ns_param maxidle 600
ns_param maxopen 3600
ns_param password x
ns_param verbose false
ns_param logsqlerrors false
ns_param extendedtableinfo true
ns_section "ns/server/${server}/db"
ns_param Pools *
ns_param DefaultPool "main"
############
So I should be able to connect to database "osu", right?
set db [ns_db gethandle]
ns_adp_puts [ns_db datasource $db]
ns_adp_puts [ns_db poolname $db]
returns "mir::germdb main". I've tried
ns_db release_handle
set db [ns_db gethandle osu]
ns_adp_puts [ns_db datasource $db]
which results in:
[17/Jan/2002:20:44:13][11272.652293][-conn632-] Error: no access to
pool: "osu"
no access to pool: "osu"
while executing
"ns_db gethandle osu"
and error messages about $db not being a variable.
Can somebody please help me here, I'm stuck.
Many thanks in advance.
-Andre
