Hello,
Your problem is that your second pool appears WITHIN the ns_section that
preceeds it.
you need to add a second
ns_section "ns/db/pools"
right BEFORE
ns_param osu "OSU db"
Alternatively, you could move
ns_param osu "OSU db"
to follow your first (and only)
ns_section "ns/db/pools"
hope that helps,
michael
In a message dated 1/17/02 2:18:13 PM Central Standard Time,
[EMAIL PROTECTED] writes:
> 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.
>
>
___________________
michael richman
sr. software engineer
aol technologies - local
214.442.6402
