Scott,
Thanks for your help. One of my coworkers took a look and noticed that I
hadn't sourced the right files before starting the server (and therefore
hadn't set LD_LIBRARY_PATH). Setting that variable fixed it. Sorry for the
trouble.
Thanks,
Paul
Scott Goodwin wrote:
> Your nsd.tcl file looks fine.
>
> I was able to duplicate the problem:
>
> [12/Dec/2001:13:47:55][30217.1024][-main-] Error: dbdrv: failed to load
> driver 'nspostgres'
> [12/Dec/2001:13:47:55][30217.1024][-main-] Error: dbinit: no such default
> pool 'main'
>
> This happens when the server literally cannot find nspostgres.so. Check
> your aolserver bin directory; make sure permissions are correct (it should
> be owned by the user and group the server runs as. Also, check the name of
> the module. You should have 'postgres.so'; I'm now maintaining the postgres
> module in AOLserver's sourceforge area and it's now called 'nspostgres.so',
> so ensure you have it in the right place with the name that matches in your
> nsd.tcl file.
>
> /s.
>
> > Scott,
> >
> > My nsd file looks different than yours. It has been untouched since
> > October 23, and when I diffed it with its backup (which is working on
> > another of our machines) - it's the same, except for hostname and ip.
> > I'm reluctant to make wholesale changes, because we want to use this
> > machine for a demo tomorrow. Take a look if you have time and let me
> > know what you think. Thanks again for your help.
> >
> > ns_section "ns/db/drivers"
> > ns_param postgres ${bindir}/postgres.so
> >
> > ns_section "ns/db/driver/driver/postgres"
> > ns_param datestyle iso
> >
> > 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 localhost::HRS
> > ns_param User user
> > ns_param Password password
> > ns_param Verbose On
> > ns_param LogSQLErrors On
> > ns_param ExtendedTableInfo On
> >
> > ns_section "ns/db/pool/subquery"
> > ns_param Driver postgres
> > ns_param Connections 4
> > ns_param MaxOpen 1000000000
> > ns_param MaxIdle 1000000000
> > ns_param DataSource localhost::HRS
> > ns_param User user
> > ns_param Password password
> > ns_param Verbose On
> > ns_param LogSQLErrors On
> > ns_param ExtendedTableInfo On
> >
> > ns_section "ns/db/pool/log"
> > ns_param Driver postgres
> > ns_param Connections 4
> > ns_param MaxOpen 1000000000
> > ns_param MaxIdle 1000000000
> > ns_param DataSource localhost::HRS
> > ns_param User user
> > ns_param Password password
> > ns_param Verbose On
> > ns_param LogSQLErrors On
> > ns_param ExtendedTableInfo On
> >
> > ns_section "ns/db/pools"
> > ns_param main "main"
> > ns_param subquery "subquery"
> > ns_param log "log"
> >
> > ns_section "ns/server/hrs/db"
> > ns_param Pools *
> > ns_param DefaultPool main
> >
> >
> > Thanks,
> > Paul
> >
> >
> >
> >
