* Michael Richman <[EMAIL PROTECTED]>, 2002-01-17 15:26 -0500:
Michael, that did the trick. Thanks a lot!
-Andre
> 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
>
A. B. andre DOT berger AT web DOT de
