Hello -
I'm trying to get 4b10 up and running and I've been hitting some
hurdles.
The latest one has been that I can't seem to get any database
connectivity. Period. I go into nscp and type (no quotes) "set db [ns_db
gethandle]" and it reports that ns_db is an unknown command.
>From my nsd.tcl:
######## Database Drivers
ns_section "ns/db/drivers"
ns_param postgres_driver "${bindir}/nspostgres.so"
ns_section "ns/db/pools"
ns_param skwx_de "Skunkworks Dataengine"
ns_param skwx_tgs "Skunkworks TGS"
ns_section "ns/db/pool/skwx_de"
ns_param driver postgres_driver
ns_param datasource localhost:5432:edu2_dataengine
ns_param user xxxxx
ns_param password xxxxx
ns_param connections 5
ns_param logsqlerrors true ;# Verbose SQL query error logging
ns_param verbose true ;# Verbose error logging
ns_param maxidle 600 ;# Max time to keep idle db conn
ns_param maxopen 3600 ;# Max time to keep active db conn
ns_section "ns/db/pool/skwx_tgs"
ns_param driver postgres_driver
ns_param datasource localhost:5432:edu2_tgs
ns_param user xxxxx
ns_param password xxxxx
ns_param connections 5
ns_param logsqlerrors true ;# Verbose SQL query error logging
ns_param verbose false ;# Verbose error logging
ns_param maxidle 600 ;# Max time to keep idle db conn
ns_param maxopen 3600 ;# Max time to keep active db conn
ns_section ns/server/xmlrpc/db
ns_param pools skwx_de
ns_param defaultpool skwx_de
ns_section "ns/server/tgs/db"
ns_param pools skwx_tgs
ns_param defaultpool skwx_tgs
If it isn't obvious, I've obfuscated username/password data.
To get some basic troubleshooting questions out of the way:
1) Yes, $bindir/nspostgres.so exists.
2) Yes, the PostgreSQL postmaster is running on 5432, is properly
configured, has two databases named edu2_dataengine and edu2_tgs that
the configured user has permission to access.
3) Yes, the servers tgs and xmlrpc exist.
4) No, my logs don't give me any information.
5) Yes, $NSHOME/lib/libnsdb.so exists and is accessible.
This configuration is all based on my experience with pre-3.4 AOLServer,
so if something's changed, until there are administrative docs, I'm not
going to know about it.
Thanks for any help.
-jag
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the
body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of
your email blank.
