Forum OpenACS Q&A: VMWare / OpenACS

Collapse
1: VMWare / OpenACS
Posted by G Florez on 05/09/03 07:18 PM
After installing it, everything seems to be ok
but when I try to login using an email address, I get the following error:

[conn0-] Error: GET /register/user-new email=a%40oas%2eorg&persistent%5fcookie%5fp=1&return%5furl=%2f Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")
    while executing
"ns_pg_bind 0or1row nsdb0 {}"
    ("uplevel" body line 1)
    invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql"
    invoked from within
"db_exec 0or1row $db $full_statement_name $sql"
    invoked from within
"set selection [db_exec 0or1row $db $full_statement_name $sql]"
    ("uplevel" body line 2)
    invoked from within
"uplevel 1 $code_block "
....

thanks

Collapse
2: Re: VMWare / OpenACS (response to 1)
Posted by Jade Rubick on 05/09/03 07:29 PM
I would first try restarting Aolserver. Then I would try looking through the Aolserver log files. The error log will give you an indication of what's going on. This could be caused by the db driver not being loaded, but I've seen it in other circumstances too. Check the error log.
Collapse
3: Re: VMWare / OpenACS (response to 1)
Posted by G Florez on 05/09/03 08:10 PM
Jade, thanks for your reply.

I tried both suggestions without luck.

Collapse
4: Re: VMWare / OpenACS (response to 1)
Posted by tammy m on 05/09/03 08:45 PM
I would try turning on all debugging/logging in the AOLserver config file and then restarting. The goal would be to get the actual SQL to print to the logs. This would help the debugging process;) Add all of the following to your AOLserver config file:

# if debug is false, all debugging will be turned off
set debug true

ns_section ns/parameters
ns_param  debug              $debug

ns_section ns/server/${server}/tcl
ns_param  debug          $debug

ns_section ns/server/${server}/adp
ns_param  enabledebug  $debug    ;# Allow Tclpro debugging with "?debug"

# Do this for each ns/db/pool declared
ns_section ns/db/pool/pool1
ns_param  verbose            $debug
ns_param  logsqlerrors      $debug

This should give ya more clues to work with;)

Collapse
5: Re: VMWare / OpenACS (response to 1)
Posted by John Sequeira on 05/09/03 11:01 PM
Guillermo,

To create the VM,  I followed Jonathan Marsden's instructions:

http://www.xc.org/jonathan/openacs/openacs4-rpm-based-install.html

It looks like it doesn't configure postgresql to restart on boot.

Type "/sbin/service postgresql start" to get it running.

Does anyone know how to get it to start on boot?  The chkconfig command in the docs did not seem to work.

It's RH 7.1.

Collapse
6: Re: VMWare / OpenACS (response to 5)
Posted by tammy m on 05/10/03 05:20 AM
Sounds like you need to start svscan. Look at daemontools. Particularly the part about: Starting svscan at boot time