Scott,
Sure, glad to help in exchange for the help you gave me. :-)
We are running FreeBSD 4.4, Aolserver 3.4, and Postgres 7.0.something. We
will upgrade to the current Postgres soon.
postgres.so lives in /usr/local/aolserver/bin
nsadmin owns the directory and the file with read, write and execute
permissions
LD_LIBRARY_PATH=/usr/local/pgsql/lib
I restart the server as root. I only made sure that LD_LIBRARY_PATH was in
the environment, restarted Aolserver (Postgres was already running), and the
driver loaded.
We start postgres as pgsql.
The Aolserver binary may have been (probably was) copied to this machine from
another of our servers - not compiled in place.
Let me know if there's anything else you need or want.
Thanks,
Paul
Scott Goodwin wrote:
> Can you tell me where your postgres.so resides? I've never had to muck with
> LD_LIBRARY_PATH. I'd like whatever info you can tell me about exactly what
> you had to do and why so I can add it to the nspostgres FAQ which I'm now
> working on. Whatever details you can give me would be helpful.
>
> thanks,
>
> /s.
>
> > 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
> > > >
> > > >
> > > >
> > > >
> >
> >
> >
> >
