Re: [AOLSERVER] nspostgres and aolserver4beta1 and beta2
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
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
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
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...