Re: [AOLSERVER] nspostgres and aolserver4beta1 and beta2

2003-02-10 Thread Jamie Rasmussen
Did you change the config file to load the nsdb module in
ns_section ns/server/$server/modules ?

Jamie


Wes James wrote:

Well, I tried an adp page that would access a database and now I get this:

[10/Feb/2003:10:52:57][2412.40966][-conn:server1::0] Error: invalid command
name ns_db
invalid command name ns_db
while executing
ns_db gethandle

I looked at the startup info for aols4b1 and noticed that there is no
message for loading the nspostgres driver.

I am using the openacs nsd.tcl example to work with.

I did notice that aolsb2 is out so I tried that and nspostgres still does
not seem to load (does not show as loading while nsd loads.)

Any ideas?

thanks,

wj



Re: [AOLSERVER] nspostgres and aolserver4beta1 and beta2

2003-02-10 Thread Wes James
I checked the nsd.tcl and I have these now:

ns_section ns/db/drivers
ns_param   postgres ${bindir}/nspostgres.so


ns_section ns/db/pools
ns_param   main   Main Pool

ns_section ns/db/pool/main
ns_param Driver postgres
ns_param Connections 5
ns_param DataSource localhost::pgdb
#ns_param User nsadmin
#ns_param Password yourpassword
ns_param Verbose Off
ns_param LogSQLErrors On
ns_param ExtendedTableInfo On
   # ns_param MaxOpen 10
   # ns_param MaxIdle 10

ns_section ns/server/${servername}/db
ns_param Pools  *
ns_param DefaultPoolmain


ns_section ns/server/${servername}/modules
ns_param nssock ${bindir}/nssock.so
ns_param nslog ${bindir}/nslog.so
ns_param   postgres ${bindir}/nspostgres.so


And when I run nsd now it I get:

[10/Feb/2003:12:06:37][5838.8192][-main-] Warning: modload: could not load
/usr/local/aolserver/bin/nspostgres.so:
/usr/local/aolserver/bin/nspostgres.so: undefined symbol: Ns_TclDbGetHandle
[10/Feb/2003:12:06:37][5838.8192][-main-] Fatal: modload: failed to load
module '/usr/local/aolserver/bin/nspostgres.so'



Re: [AOLSERVER] nspostgres and aolserver4beta1 and beta2

2003-02-10 Thread Brett Schwarz
This is what I have in my nsd.tcl:

#
# Modules to load
#
ns_section ns/server/${servername}/modules
ns_param   nsdb  ${bindir}/nsdb${ext}
ns_param   nssock  ${bindir}/nssock${ext}
ns_param   nslog   ${bindir}/nslog${ext}
ns_param   nsresult   ${bindir}/nsresult${ext}

Notice the nsdb line...

--brett



On Mon, 2003-02-10 at 11:12, Wes James wrote:
 I checked the nsd.tcl and I have these now:

 ns_section ns/db/drivers
 ns_param   postgres ${bindir}/nspostgres.so


 ns_section ns/db/pools
 ns_param   main   Main Pool

 ns_section ns/db/pool/main
 ns_param Driver postgres
 ns_param Connections 5
 ns_param DataSource localhost::pgdb
 #ns_param User nsadmin
 #ns_param Password yourpassword
 ns_param Verbose Off
 ns_param LogSQLErrors On
 ns_param ExtendedTableInfo On
# ns_param MaxOpen 10
# ns_param MaxIdle 10

 ns_section ns/server/${servername}/db
 ns_param Pools  *
 ns_param DefaultPoolmain


 ns_section ns/server/${servername}/modules
 ns_param nssock ${bindir}/nssock.so
 ns_param nslog ${bindir}/nslog.so
 ns_param   postgres ${bindir}/nspostgres.so


 And when I run nsd now it I get:

 [10/Feb/2003:12:06:37][5838.8192][-main-] Warning: modload: could not load
 /usr/local/aolserver/bin/nspostgres.so:
 /usr/local/aolserver/bin/nspostgres.so: undefined symbol: Ns_TclDbGetHandle
 [10/Feb/2003:12:06:37][5838.8192][-main-] Fatal: modload: failed to load
 module '/usr/local/aolserver/bin/nspostgres.so'
--
Brett Schwarz
brett_schwarz AT yahoo.com



Re: [AOLSERVER] nspostgres and aolserver4beta1 and beta2

2003-02-10 Thread Wes James
nsdb did the trick!

thanks for the help everyone!

wj


-Original Message-
From:   Brett Schwarz [mailto:[EMAIL PROTECTED]]
Sent:   Mon 2/10/2003 12:39 PM
To: [EMAIL PROTECTED]
Cc:
Subject:Re: [AOLSERVER] nspostgres and aolserver4beta1 and beta2
This is what I have in my nsd.tcl:

#
# Modules to load
#
ns_section ns/server/${servername}/modules
ns_param   nsdb  ${bindir}/nsdb${ext}
ns_param   nssock  ${bindir}/nssock${ext}
ns_param   nslog   ${bindir}/nslog${ext}
ns_param   nsresult   ${bindir}/nsresult${ext}

Notice the nsdb line...