openinteract-help — For new and current users, we offer support, troubleshooting and assistance.

Re: [Openinteract-help] Re: [ openinteract-Bugs-572661 ] Bug in SPOPS 0.61

[Chris W. <ch...@cw...>]

On Sat, 2002-08-10 at 09:43, Hal Finkel (DiscoverNet Inc.) wrote:
> Thank you for the reply, overall OpenInteract/SPOPS are excellent pieces of
> software. I have not had any problems since I made the change mentioned in
> the bug report. I am sorry I did not make it more clear... there was no
> problem editing objects... the problem was in creating objects (any objects,
> not just theme objects... the theme object was simple the example I
> provided). The problem comes because the <input type="hidden"
> name="theme_id" value=""> when creating a new object is not undef, but an
> empty string as returned by  $apr->param( 'theme_id' );. Thus the change
> from testing for a non-zero vale to testing for a defined value, causes
> SPOPS::DBI::fetch to attempt to fetch an object when passed the empty string
> as an id (instead of returning undef). I understand the that rationale
> behind the change might have been to allow the id '0' (or an empty string
> for that matter) to be used, which is fine, however the current OpenInteract
> base_* packages depend on the fact the passing an empty string to the fetch
> function will return undef allowing them to create a new object. I was
> testing this using OI 1.40 (and MS IE, if that makes any difference).

Ah, I see what you're saying, and you're absolutely right. I fixed this
in the base_theme package (and it should be fixed everywhere else,
but...) and added a check in SPOPS::DBI for the length() of the ID
passed in -- this will take care of the empty ID issue.

This modification is in 0.64 which should be rolling around CPAN right
now. (It has been the weekend of many releases...) You can also get it
from the Sourceforge site.

Thanks for the report!

Chris

-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.

[Openinteract-help] Re: [ openinteract-Bugs-572661 ] Bug in SPOPS 0.61

[Hal F. \(D. Inc.\) <ha...@di...>]

Chris,

Thank you for the reply, overall OpenInteract/SPOPS are excellent pieces of
software. I have not had any problems since I made the change mentioned in
the bug report. I am sorry I did not make it more clear... there was no
problem editing objects... the problem was in creating objects (any objects,
not just theme objects... the theme object was simple the example I
provided). The problem comes because the <input type="hidden"
name="theme_id" value=""> when creating a new object is not undef, but an
empty string as returned by  $apr->param( 'theme_id' );. Thus the change
from testing for a non-zero vale to testing for a defined value, causes
SPOPS::DBI::fetch to attempt to fetch an object when passed the empty string
as an id (instead of returning undef). I understand the that rationale
behind the change might have been to allow the id '0' (or an empty string
for that matter) to be used, which is fine, however the current OpenInteract
base_* packages depend on the fact the passing an empty string to the fetch
function will return undef allowing them to create a new object. I was
testing this using OI 1.40 (and MS IE, if that makes any difference).

Hal Finkel

Bugs item #572661, was opened at 2002-06-23 00:29
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=116810&aid=572661&group_id
=16810

Category: None
Group: None
>Status: Closed
>Resolution: Invalid
Priority: 5
Submitted By: Hal Finkel (half26d)
Assigned to: Nobody/Anonymous (nobody)
Summary: Bug in SPOPS 0.61

Initial Comment:
in SPOPS::DBI::fetch the line:
return undef  unless ( defined( $id ) and $id !~ /^tmp/ );

causes OpenInteract to fail to create new objects...
replacing the line with the older version of:
return undef  unless ( $id and $id !~ /^tmp/ );
fixes the problem.

As an example, attempting to add a new theme object
results in an update of the existing 'main' theme (where
XXXX is the website name):

XXXX::Handler::Theme::edit (95) >> Trying to modify ID
<<>>
SPOPS::DBI::fetch (253) >> SELECTing:
theme_id//title//description//parent//credit
SPOPS::DBI::id_clause (141) >> No ID passed in and
called as a class method rather than an object method.
SPOPS::SQLInterface::db_select (90) >> No SQL passed
in to execute directly; building.
SPOPS::SQLInterface::db_select (111) >> SQL for select:
           SELECT  theme_id, title, description, parent, credit
             FROM theme




SPOPS::SQLInterface::db_select (123) >> Values bound:
SPOPS::SQLInterface::db_select (142) >> Returning single
row.
SPOPS::DBI::_fetch_assign_row (466) >> Setting data
from row into XXXX::Theme
SPOPS::DBI::_fetch_assign_row (469) >>
theme_id             --> 1
SPOPS::DBI::_fetch_assign_row (469) >>  title                --
> main
SPOPS::DBI::_fetch_assign_row (469) >>
description          --> Your basic
SPOPS::DBI::_fetch_assign_row (469) >>
parent               --> 0
SPOPS::DBI::_fetch_assign_row (469) >>
credit               --> OpenIntera
SPOPS::DBI::_fetch_post_process (503) >> XXXX::Theme
( 1 ) : cache set (if available), post_fetch_action() done,
change flag cleared and save  flag set. Security: 8
OpenInteract::SPOPS::log_action_enter (135) >> Log
[update] to [XXXX::Theme] [1] by  [1] on [2002-06-23
02:38:35]

Hal Finkel
ha...@di...

----------------------------------------------------------------------

>Comment By: Chris Winters (lachoy)
Date: 2002-08-09 23:36

Message:
Logged In: YES
user_id=37377

This is a separate problem, not in SPOPS. This is evidenced
by the line: "XXXX::Handler::Theme::edit (95) >> Trying to
modify ID
<<>>". There's some error with the class getting the ID of
the theme it's supposed to edit. What is the theme_id in the
database table? Is the theme_id getting set properly in the
form? Please email the openinteract-help mailing list if
this is still an issue.

----------------------------------------------------------------------

You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=116810&aid=572661&group_id
=16810

[Openinteract-help] blank page after initial install

[Cole K. <cke...@vi...>]

After installation appeared to go smoothly, opening the site produced a 
blank age.  The apaache error log showed the following:

OpenInteract::Startup::require_module (374) >>  --require error: 
OpenInteract::Template::Process          (from ): Bareword 
"Template::Constants::STATUS_ERROR"
not allowed while "strict subs" in use at 
/usr/lib/perl5/site_perl/5.6.1/OpenInteract/Template/Context.pm line 52.
Bareword "Template::Constants::ERROR_FILE" not allowed while "strict 
subs" in use at 
/usr/lib/perl5/site_perl/5.6.1/OpenInteract/Template/Context.pm line 54.
Bareword "Template::Constants::ERROR_FILE" not allowed while "strict 
subs" in use at 
/usr/lib/perl5/site_perl/5.6.1/OpenInteract/Template/Context.pm line 57.
Compilation failed in require at 
/usr/lib/perl5/site_perl/5.6.1/OpenInteract/Template/Process.pm line 7.
BEGIN failed--compilation aborted at 
/usr/lib/perl5/site_perl/5.6.1/OpenInteract/Template/Process.pm line 7.
Compilation failed in require at (eval 210) line 3.

On retracing my steps through the installation I found that the same 
error occurred when I ran oi_manage ... install_sql and oi_manage ... 
install_template

cck

Re: [Openinteract-help] Apache won't start after OI installation

[Drew T. <dr...@dr...>]

Do you have the apache source around still? All the header files mentioned 
below are from the main apache distribution. I'm sure the solution is 
somewhere along those lines.

Drew

At 12:26 PM 7/24/02 -0400, Cole Keirsey wrote:

>In file included from apache_request.c:59:
>apache_request.h:5:19: httpd.h: No such file or directory
>apache_request.h:6:25: http_config.h: No such file or directory
>apache_request.h:7:23: http_core.h: No such file or directory
>apache_request.h:8:22: http_log.h: No such file or directory
>apache_request.h:9:23: http_main.h: No such file or directory
>apache_request.h:10:27: http_protocol.h: No such file or directory
>apache_request.h:11:25: util_script.h: No such file or directory
>In file included from apache_request.c:59:
>apache_request.h:38: parse error before `table'
>apache_request.h:38: warning: no semicolon at end of struct or union
>apache_request.h:47: parse error before `*'
>
>Apparently there are some header files missing.
>This is occuring on a Mandrake 8.2 linux system.
>I've tried this for both the proxied and solo mod_perl configurations.

======================================================================
Drew Taylor                  |  Freelance web development using
http://www.drewtaylor.com/   |  perl/mod_perl/MySQL/postgresql/DBI
mailto:dr...@dr...   |  Email jobs at drewtaylor.com
----------------------------------------------------------------------
Speakeasy.net: A DSL provider with a clue. Sign up today.
http://www.speakeasy.net/refer/29655
======================================================================

[Openinteract-help] Apache won't start after OI installation

[Cole K. <cke...@vi...>]

My OpenInteract installation proceeds fine up to the point of restarting 
apache.
Apache fails to restart with the following message:
Can't locate Apache/Request.pm...

When I try to install Apache::Request using CPAN I get errors including:

Checking if your kit is complete...
Looks good
Writing Makefile for libapreq
mkdir ../blib
mkdir ../blib/arch
mkdir ../blib/arch/auto
mkdir ../blib/arch/auto/libapreq
Warning: -L../blib/arch/auto/libapreq changed to 
-L/root/.cpan/build/libapreq-1.0/Request/../blib/arch/auto/libapreq 
Writing Makefile for Apache::Request
Warning: -L../blib/arch/auto/libapreq changed to 
-L/root/.cpan/build/libapreq-1.0/Cookie/../blib/arch/auto/libapreq
Writing Makefile for Apache::Cookie
Writing Makefile for libapreq
cp libapreq.pod blib/lib/libapreq.pod
cp lib/Apache/libapreq.pm blib/lib/Apache/libapreq.pm
make[1]: Entering directory `/root/.cpan/build/libapreq-1.0/c'
cc -c  -fno-strict-aliasing -I/usr/local/include -O3 
-fomit-frame-pointer -pipe -mcpu=pentiumpro -march=i586 -ffast-math 
-fno-strength-reduce   -DVERSION=\"0.10\" -DXS_VERSION=\"0.10\" -fpic 
-I/usr/lib/perl5/5.6.1/i386-linux/CORE  apache_request.c
In file included from apache_request.c:59:
apache_request.h:5:19: httpd.h: No such file or directory
apache_request.h:6:25: http_config.h: No such file or directory
apache_request.h:7:23: http_core.h: No such file or directory
apache_request.h:8:22: http_log.h: No such file or directory
apache_request.h:9:23: http_main.h: No such file or directory
apache_request.h:10:27: http_protocol.h: No such file or directory
apache_request.h:11:25: util_script.h: No such file or directory
In file included from apache_request.c:59:
apache_request.h:38: parse error before `table'
apache_request.h:38: warning: no semicolon at end of struct or union
apache_request.h:47: parse error before `*'

etc.

Apparently there are some header files missing.
This is occuring on a Mandrake 8.2 linux system.
I've tried this for both the proxied and solo mod_perl configurations.

Thanks in advance for your help.

cck

Re: [Openinteract-help] install compression problems continued

[Chris W. <ch...@cw...>]

On Tue, 2002-07-23 at 13:11, Cole Keirsey wrote:
> Installing Bundle::CPAN didn't solve my problem with compression errors 
> on install.
> 
> When I try: install Compress::Zlib
> in the cpan shell I get the following error:
> 
> cc -c -I/usr/local/include -fno-strict-aliasing -I/usr/local/include -O3 
> -fomit-frame-pointer -pipe -mcpu=pentiumpro -march=i586 -ffast-math 
> -fno-strength-reduce   -DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -fpic 
> -I/usr/lib/perl5/5.6.1/i386-linux/CORE  Zlib.c
> cc: installation problem, cannot exec `cpp0': No such file or directory
> ...
> 
> I rember seeing the same problem with Class::Date on an earlier attempt 
> to install OpenInteract.  Most perl modules seem to install without such 
> problems.

This sounds like your environment for building XS modules isn't setup
properly. Can you install other modules like DBI or DBD::mysql (or
DBD::Pg) without any problems? (That is, using the perl build process
rather than an RPM.)

Chris

-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.

[Openinteract-help] install compression problems continued

[Cole K. <cke...@vi...>]

Installing Bundle::CPAN didn't solve my problem with compression errors 
on install.

When I try: install Compress::Zlib
in the cpan shell I get the following error:

cc -c -I/usr/local/include -fno-strict-aliasing -I/usr/local/include -O3 
-fomit-frame-pointer -pipe -mcpu=pentiumpro -march=i586 -ffast-math 
-fno-strength-reduce   -DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" -fpic 
-I/usr/lib/perl5/5.6.1/i386-linux/CORE  Zlib.c
cc: installation problem, cannot exec `cpp0': No such file or directory
...

I rember seeing the same problem with Class::Date on an earlier attempt 
to install OpenInteract.  Most perl modules seem to install without such 
problems.

cck

Re: [Openinteract-help] install compression error

[Chris W. <ch...@cw...>]

On Tue, 2002-07-23 at 12:27, Cole Keirsey wrote:
> Hello,
> 
> When I run oi_manage ... install, I get a series of errors like the 
> following:
> 
> main::install_oi (1321) >> Error installing: Error found trying to 
> unpack the di
> stribution! Error: Compression not available
> ...
> 
> Packages installed:
> base
>   FAILED!: Error found trying to unpack the distribution! Error:
>            Compression not available
> ...
> 
> This is happening on a clean new installation of Mandrake Linux 8.2. 
>  unzip and gunzip are both in the path.

The current version of OI uses Archive::Tar and Compress::Zlib for
archiving and compression. If you do the following as root:

  # perl -MCPAN -e shell
  cpan> install Bundle::CPAN

Then these will be installed for you. You might need to install the
packages for the zlib library -- I'm not sure if these are included by
default in most distribution installs.

Chris

-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.

[Openinteract-help] install compression error

[Cole K. <cke...@vi...>]

Hello,

When I run oi_manage ... install, I get a series of errors like the 
following:

main::install_oi (1321) >> Error installing: Error found trying to 
unpack the di
stribution! Error: Compression not available
...

Packages installed:
base
  FAILED!: Error found trying to unpack the distribution! Error:
           Compression not available
...

This is happening on a clean new installation of Mandrake Linux 8.2. 
 unzip and gunzip are both in the path.

Any guidance will be appreciated.

cck

Re: [Openinteract-help] Problem at first access: can't locate object method "..."

[Chris W. <ch...@cw...>]

(Apologies for the lateness of this reply -- we're in the middle of
moving -- always hectic :-)

On Sun, 2002-07-14 at 07:02, Florian Helmberger wrote:
> Okay. Here are the messages generated at server startup:
> 
> error_log:
> 
> ***
> Subroutine Compress::Zlib::constant redefined at
> /Library/Perl/darwin/Compress/Zlib.pm line 94.
> ...

These are a separate issue, I think.
> DBI handle cleared whilst still active at /Library/Perl/darwin/DBI.pm line
> 266.
>     dbih_clearcom (h 0x4c79d8, com 0xaa5c90):
>        FLAGS 0x211: COMSET Warn AutoCommit
>        TYPE 1
>        PARENT undef
>        KIDS 0 (0 Active)
>        IMP_DATA undef in 'DBD::Pg::dr'
> [Sun Jul 14 12:57:45 2002] [notice] Apache/1.3.23 (Darwin) mod_perl/1.27
> configured -- resuming normal operations
> [Sun Jul 14 12:57:45 2002] [notice] Accept mutex: flock (Default: flock)
> OpenInteract::Error::Main::initialize (59) >> Initialized DEFAULT_HANDLER
> for app (OpenInteract::Stash) to (OpenInteract::Error::System)
> ...
These look ok too. This is the first time I've seen the DBI error, but I
don't think it's a big deal. (Actually, it probably means you're not
using Apache::DBI.)
 
> A request via browser creates the following entries in the OI error log:
> 
> ***
> OpenInteract::handler (34) >>
> 
> ==============================
> Request started: Sun Jul 14 13:01:08 2002
>  path: ( / ) PID: (1202)
> OpenInteract::setup_server_interface (128) >> Server hostname set to
> openinteract
> OpenInteract::setup_server_interface (131) >> Request coming from 127.0.0.1
> OpenInteract::parse_uri (176) >> Original path: (/)
> OpenInteract::parse_uri (184) >> Items in the path:
> OpenInteract::parse_uri (197) >> Action found from URL:
> OpenInteract::parse_uri (204) >> Original path/query string set to: /
> OpenInteract::Request::lookup_conductor (225) >> Find conductor for action
> ()
> OpenInteract::Request::lookup_action (254) >> Find action corresponding to
> ()
> OpenInteract::Request::lookup_action (275) >> Found action info for ()
> OpenInteract::find_action_handler (227) >> Found OpenInteract::UI::Main //
> handler for conductor
> Found item: Apache::DBI::db
>  --EXITED WITH ERROR from main handler eval block
> Error: 0
> ***

This is dying where you'd normally parse your cookies and create your
session. This may be a problem with Apache::Cookie. Try changing the
class we use to parse the cookies. In $WEBSITE_DIR/conf/server.ini,
modify the line:

[system_alias]
cookies         = OpenInteract::Cookies::Apache

to read:

[system_alias]
cookies         = OpenInteract::Cookies::CGI

And restart the server to see what happens. (You might also set DEBUG at
the top of the server.ini file to 2 to see more information.)

Chris
 
-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.

Re: [Openinteract-help] Problem at first access: can't locate object method "..."

[Florian H. <fh...@in...>]

Am 14.07.2002 0:46 Uhr schrieb "Chris Winters" unter <ch...@cw...>:

> * Florian Helmberger (fh...@in...) [020713 06:18]:
>> I justed installed OI 1.40 on a Powerbook running OS X 10.1.5 with Perl
>> 5.6.0, Apache 1.2.23 (patched version to fix OS X specific problems with
>> libapreq), mod_perl 1.27 and PostgreSQL as database.
> 
> Do you mean Apache 1.3.23?

Oh yes I meant 1.3.23 - sorry for the typo.

> It sounds like something wasn't initialized properly. Do you see
> anything in the Apache server error log (where messages generated
> during the OpenInteract::Apache process go) or the virtual host error
> log? Also try setting DEBUG to 1 and restart the server to get more
> messages in the vhost log.

Okay. Here are the messages generated at server startup:

error_log:

***
Subroutine Compress::Zlib::constant redefined at
/Library/Perl/darwin/Compress/Zlib.pm line 94.
Subroutine Compress::Zlib::zlib_version redefined at
/Library/Perl/darwin/Compress/Zlib.pm line 94.
Subroutine Compress::Zlib::gzopen_ redefined at
/Library/Perl/darwin/Compress/Zlib.pm line 94.
Subroutine Compress::Zlib::gzdopen_ redefined at
/Library/Perl/darwin/Compress/Zlib.pm line 94.
Subroutine Compress::Zlib::gzFile::gzread redefined at
/Library/Perl/darwin/Compress/Zlib.pm line 94.
Subroutine Compress::Zlib::gzFile::gzreadline redefined at
/Library/Perl/darwin/Compress/Zlib.pm line 94.
Subroutine Compress::Zlib::gzFile::gzwrite redefined at
/Library/Perl/darwin/Compress/Zlib.pm line 94.
Subroutine Compress::Zlib::gzFile::gzflush redefined at
/Library/Perl/darwin/Compress/Zlib.pm line 94.
Subroutine Compress::Zlib::gzFile::gzclose redefined at
/Library/Perl/darwin/Compress/Zlib.pm line 94.
Subroutine Compress::Zlib::gzFile::DESTROY redefined at
/Library/Perl/darwin/Compress/Zlib.pm line 94.
Subroutine Compress::Zlib::gzFile::gzerror redefined at
/Library/Perl/darwin/Compress/Zlib.pm line 94.
Subroutine Compress::Zlib::adler32 redefined at
/Library/Perl/darwin/Compress/Zlib.pm line 94.
Subroutine Compress::Zlib::crc32 redefined at
/Library/Perl/darwin/Compress/Zlib.pm line 94.
Subroutine Compress::Zlib::_deflateInit redefined at
/Library/Perl/darwin/Compress/Zlib.pm line 94.
Subroutine Compress::Zlib::_inflateInit redefined at
/Library/Perl/darwin/Compress/Zlib.pm line 94.
Subroutine Compress::Zlib::deflateStream::deflate redefined at
/Library/Perl/darwin/Compress/Zlib.pm line 94.
Subroutine Compress::Zlib::deflateStream::DESTROY redefined at
/Library/Perl/darwin/Compress/Zlib.pm line 94.
Subroutine Compress::Zlib::deflateStream::flush redefined at
/Library/Perl/darwin/Compress/Zlib.pm line 94.
Subroutine Compress::Zlib::deflateStream::dict_adler redefined at
/Library/Perl/darwin/Compress/Zlib.pm line 94.
Subroutine Compress::Zlib::deflateStream::msg redefined at
/Library/Perl/darwin/Compress/Zlib.pm line 94.
Subroutine Compress::Zlib::inflateStream::inflate redefined at
/Library/Perl/darwin/Compress/Zlib.pm line 94.
Subroutine Compress::Zlib::inflateStream::__unc_inflate redefined at
/Library/Perl/darwin/Compress/Zlib.pm line 94.
Subroutine Compress::Zlib::inflateStream::DESTROY redefined at
/Library/Perl/darwin/Compress/Zlib.pm line 94.
Subroutine Compress::Zlib::inflateStream::dict_adler redefined at
/Library/Perl/darwin/Compress/Zlib.pm line 94.
Subroutine Compress::Zlib::inflateStream::msg redefined at
/Library/Perl/darwin/Compress/Zlib.pm line 94.
DBI handle cleared whilst still active at /Library/Perl/darwin/DBI.pm line
266.
    dbih_clearcom (h 0x4c79d8, com 0xaa5c90):
       FLAGS 0x211: COMSET Warn AutoCommit
       TYPE 1
       PARENT undef
       KIDS 0 (0 Active)
       IMP_DATA undef in 'DBD::Pg::dr'
[Sun Jul 14 12:57:45 2002] [notice] Apache/1.3.23 (Darwin) mod_perl/1.27
configured -- resuming normal operations
[Sun Jul 14 12:57:45 2002] [notice] Accept mutex: flock (Default: flock)
OpenInteract::Error::Main::initialize (59) >> Initialized DEFAULT_HANDLER
for app (OpenInteract::Stash) to (OpenInteract::Error::System)
OpenInteract::Error::Main::initialize (59) >> Initialized DEFAULT_HANDLER
for app (OpenInteract::Stash) to (OpenInteract::Error::System)
OpenInteract::Error::Main::initialize (59) >> Initialized DEFAULT_HANDLER
for app (OpenInteract::Stash) to (OpenInteract::Error::System)
OpenInteract::Error::Main::initialize (59) >> Initialized DEFAULT_HANDLER
for app (OpenInteract::Stash) to (OpenInteract::Error::System)
OpenInteract::Error::Main::initialize (59) >> Initialized DEFAULT_HANDLER
for app (OpenInteract::Stash) to (OpenInteract::Error::System)
OpenInteract::Error::Main::initialize (59) >> Initialized DEFAULT_HANDLER
for app (OpenInteract::Stash) to (OpenInteract::Error::System)
OpenInteract::Error::Main::initialize (59) >> Initialized DEFAULT_HANDLER
for app (OpenInteract::Stash) to (OpenInteract::Error::System)
OpenInteract::Error::Main::initialize (59) >> Initialized DEFAULT_HANDLER
for app (OpenInteract::Stash) to (OpenInteract::Error::System)
OpenInteract::Error::Main::initialize (59) >> Initialized DEFAULT_HANDLER
for app (OpenInteract::Stash) to (OpenInteract::Error::System)
OpenInteract::Error::Main::initialize (59) >> Initialized DEFAULT_HANDLER
for app (OpenInteract::Stash) to (OpenInteract::Error::System)
OpenInteract::Error::Main::initialize (59) >> Initialized DEFAULT_HANDLER
for app (OpenInteract::Stash) to (OpenInteract::Error::System)
OpenInteract::Error::Main::initialize (59) >> Initialized DEFAULT_HANDLER
for app (OpenInteract::Stash) to (OpenInteract::Error::System)
OpenInteract::Error::Main::initialize (59) >> Initialized DEFAULT_HANDLER
for app (OpenInteract::Stash) to (OpenInteract::Error::System)
OpenInteract::Error::Main::initialize (59) >> Initialized DEFAULT_HANDLER
for app (OpenInteract::Stash) to (OpenInteract::Error::System)
OpenInteract::Error::Main::initialize (59) >> Initialized DEFAULT_HANDLER
for app (OpenInteract::Stash) to (OpenInteract::Error::System)
***

Note: all of the shown messages are not present when I exclude the OI
httdp.conf.

A request via browser creates the following entries in the OI error log:

***
OpenInteract::handler (34) >>

==============================
Request started: Sun Jul 14 13:01:08 2002
 path: ( / ) PID: (1202)
OpenInteract::setup_server_interface (128) >> Server hostname set to
openinteract
OpenInteract::setup_server_interface (131) >> Request coming from 127.0.0.1
OpenInteract::parse_uri (176) >> Original path: (/)
OpenInteract::parse_uri (184) >> Items in the path:
OpenInteract::parse_uri (197) >> Action found from URL:
OpenInteract::parse_uri (204) >> Original path/query string set to: /
OpenInteract::Request::lookup_conductor (225) >> Find conductor for action
()
OpenInteract::Request::lookup_action (254) >> Find action corresponding to
()
OpenInteract::Request::lookup_action (275) >> Found action info for ()
OpenInteract::find_action_handler (227) >> Found OpenInteract::UI::Main //
handler for conductor
Found item: Apache::DBI::db
 --EXITED WITH ERROR from main handler eval block
Error: 0
***

Is this of any help to you?

Thanks,
Florian

-- 
0699 109 24 24 5 - http://www.laudatio.com

Re: [Openinteract-help] Problem at first access: can't locate object method "..."

[Chris W. <ch...@cw...>]

* Florian Helmberger (fh...@in...) [020713 06:18]:
> I justed installed OI 1.40 on a Powerbook running OS X 10.1.5 with Perl
> 5.6.0, Apache 1.2.23 (patched version to fix OS X specific problems with
> libapreq), mod_perl 1.27 and PostgreSQL as database.

Do you mean Apache 1.3.23?

> Installation ran very smooth - but on the first access with a browser I get
> this error message:
> 
> Can't locate object method "parse" via package
> "OpenInteract::Cookies::Apache" at /Library/Perl/OpenInteract.pm line 253.
> 
> I tried to comment this line out just to see what happens, but it seems as
> if this is a more systematic problem as I get a similar error for line 256.
> 
> I don't have a linux based system around at the moment, so I cannot try it
> on a "proved working" plattform.

It sounds like something wasn't initialized properly. Do you see
anything in the Apache server error log (where messages generated
during the OpenInteract::Apache process go) or the virtual host error
log? Also try setting DEBUG to 1 and restart the server to get more
messages in the vhost log.

> Anyway, my question is, might that be the same issue as mentioned in the
> NOTES section of the man page for OpenInteract? And if so - has anyone
> discovered what the exact problem is?

I'm pretty confident this is a different problem. The 'NOTES' item
happens after a number of requests, usually when there were memory
issues from out-of-control processes. (I haven't seen this happen for
over a year, so I think these problems were fixed.)

Chris

-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988

[Openinteract-help] Problem at first access: can't locate object method "..."

[Florian H. <fh...@in...>]

Hi.

I justed installed OI 1.40 on a Powerbook running OS X 10.1.5 with Perl
5.6.0, Apache 1.2.23 (patched version to fix OS X specific problems with
libapreq), mod_perl 1.27 and PostgreSQL as database.

Installation ran very smooth - but on the first access with a browser I get
this error message:

Can't locate object method "parse" via package
"OpenInteract::Cookies::Apache" at /Library/Perl/OpenInteract.pm line 253.

I tried to comment this line out just to see what happens, but it seems as
if this is a more systematic problem as I get a similar error for line 256.

I don't have a linux based system around at the moment, so I cannot try it
on a "proved working" plattform.

Anyway, my question is, might that be the same issue as mentioned in the
NOTES section of the man page for OpenInteract? And if so - has anyone
discovered what the exact problem is?

Thanks for listening,
Florian

-- 
0699 109 24 24 5 - http://www.laudatio.com

Re: [Openinteract-help] editing templates in the browser...

[Chris W. <ch...@cw...>]

On Thu, 2002-07-11 at 10:52, Arva, Adrian wrote:
> Hi,
> 
> I installed OI on a RedHat 7.2 and everything went perfectly. I am very
> impressed with it and my kudos 
> for Chris Winters being able to build such thing. 
> 
> Of course, now, I have a question :)
> I tried to edit in the browser the templates for various boxes but the
> changes weren't picked up. Only when I edited the file system templates
> and loaded them in the database:
> oi_manage --website_dir <web_site_dir> --package base_box
> install_template
> 
> the changes showed up. 
> The docs suggest this to be the recommended way but don't deny the other
> either. 
> 
> Is there something what I miss when I edit a template in the browser and
> the change does not show up?

This is a "should be re-implemented soon" item -- you'll be able to edit
them via the browser and have the changes saved to the filesystem. Sorry
for the confusion.

Chris

-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.

[Openinteract-help] editing templates in the browser...

[Arva, A. <ar...@cs...>]

Hi,

I installed OI on a RedHat 7.2 and everything went perfectly. I am very
impressed with it and my kudos 
for Chris Winters being able to build such thing. 

Of course, now, I have a question :)
I tried to edit in the browser the templates for various boxes but the
changes weren't picked up. Only when I edited the file system templates
and loaded them in the database:
oi_manage --website_dir <web_site_dir> --package base_box
install_template

the changes showed up. 
The docs suggest this to be the recommended way but don't deny the other
either. 

Is there something what I miss when I edit a template in the browser and
the change does not show up?

Thanks, 
Adrian Arva

Re: [Openinteract-help] Question.

[Chris W. <ch...@cw...>]

* Victor Piterbarg (ope...@ha...) [020707 18:53]:
> For some reason I keep getting this error using the CommonHandler,
> "Cannot process template!undef error - Can't use an undefined value as a
> HASH reference at /usr/local/lib/perl5/site_perl/5.6.1/SPOPS.pm line 375."
> It happens when I assign a paritcular object to the $params hash in
> show_customize thusly:
> $param->{nasa_car} = eval($attrib->{car_object});
> and then use nasa_car in the template.
> 
> When I dump the object it looks perfectly normal.
> Any help would be greatly appreciated. Thanks.

A couple of things: 

 - When you say:
     eval ( $attrib->{car_object} );
   you probably mean:
     eval { $attrib->{car_object} };
   although I'm not sure why you need an eval {} here at all, since
this shouldn't throw any errors.

 - Are you sure that the value you're assigning is defined? If it is,
then how are you creating the object in $attrib->{car_object}?

Chris

-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988

[Openinteract-help] Question.

[Victor P. <ope...@ha...>]

For some reason I keep getting this error using the CommonHandler,
"Cannot process template!undef error - Can't use an undefined value as a
HASH reference at /usr/local/lib/perl5/site_perl/5.6.1/SPOPS.pm line 375."
It happens when I assign a paritcular object to the $params hash in
show_customize thusly:
$param->{nasa_car} = eval($attrib->{car_object});
and then use nasa_car in the template.

When I dump the object it looks perfectly normal.
Any help would be greatly appreciated. Thanks.

-Victor

Re: [Openinteract-help] suggestions

[Chris W. <ch...@cw...>]

* Jon Dugan (jd...@nc...) [020625 15:54]:
> ...
>   booth they want the fiber to come to, etc.  At any time until we
>   close registration they can come in and modify their requests.
>   This data is all kept in a database (PostgreSQL) and used by those
>   of us building the network to determine how much gear we need to
>   borrow, etc.  So, the second set of users for this site are the
>   people on the networking committee.
>
>   I have developed a database schema that handles the data that we
>   need to collect and maintain pretty well.  My first question is
>   should I try to use SPOPS as my interface to this data?  SPOPS has
>   a lot of nice things, but the database is fairly normalized and
>   SPOPS seems most suited to single table applications.  I need to
>   do a lot of JOINs (thank goodness that Pg now supports OUTER JOINs
>   -- I had to emulate them with UNIONs last year).  This leads to my
>   second question -- how do I use SPOPS to access a normalized
>   database?

SPOPS does relationships just fine, but not using joins. (Not yet,
anyway.) The types of relationships you seem to imply are of the
dependent object sort -- the related object has no meaning outside the
context of the primary object. IME (which does not include a high
traffic environment) treating these differently than primary objects
is too much work.

You can declare relationships in the SPOPS configuration and have them
automatically created for you. For instance, without writing any code
you'd be able to do something like (in the context of OI):

 my $exhibitor = $R->exhibitor->fetch( $id );
 foreach my $booth ( @{ $exhibitor->booth } ) {
    foreach my $connection ( @{ $booth->net_connection } ) {
       print "Booth $booth->{booth_name}\n",
             "Connection $connection->{location}\n";
       foreach my $gear ( @{ $connection->gear } ) {
           print "  requires: $gear->{name}\n";
       }
    }
 }

This is circuitous, forcing you to walk down all the relationships
manually. (Well, sort of manually.) Fortunately, you can create
shortcuts fairly easily. For instance, say we want to get all the gear
required for a particular booth. We could create something like the
following code, telling SPOPS to include it into the generated class:

 package OpenInteract::Booth;

 sub get_gear_required {
     my ( $self ) = @_;
     my $R = OpenInteract::Request->instance;
     my @tables = ( $self->table_name,
                    $R->net_connection->table_name,
                    $R->connection_gear->table_name,
                    $R->gear->table_name );
     my @where = (
           "booth.booth_id = ?", 
           "connection.booth_id = booth.booth_id",
           "connection_gear.connection_id = connection.connection_id",
           "gear.gear_id = connection_gear.gear_id"
     );
     return $R->gear->fetch_group({
                             from  => \@tables,
                             where => join( ' AND ', @where ),
                             value => [ $self->id ] });
 }

(Again, this is in the context of OI. Without OI we'd just have to
lookup another way or hardcode the classnames.)

It would probably be fairly straightforward to declare and create
automatically OUTER JOIN relationships as well. When I finally get
around to implementing some of the improved relationship declarations
this may be part of the package.

>   That said, I like SQL, so I don't necessarily want it hidden from
>   me.  Is using SPOPS::SQLInterface a viable option?  The man page
>   seems to gently discourage it.

It's got its own way of doing things, as you can see from the example
above. The SQL paradigm is still prevalent -- you can still do joins,
just not with straight SQL. (Actually, you *can* pass SQL to the
various methods, but what's the point?)

Whether it's viable is really up to you. All the information necessary
for the tradeoffs is in your head: after testing, is this fast enough?
Are you able to create easy workarounds for the tasks you do all the
time? Does the object representation *feel* right? It's very difficult
for me to say without more concrete examples and knowing the problem a
little better.

I'd recommend you fool around with the data model and how you're going
to use it before tackling the application server. Otherwise it's too
much to do at once :-)

Finally, there's nothing wrong with using your own data access
framework within OI. You'll still need SPOPS for all the app server
maintenance stuff -- users, groups, themes, security, etc. -- but you
can use whatever persistence framework works for you.

>   Lastly, how is OI 2 coming along?  The CVS repository on
>   Sourceforge doesn't appear to have been touched in a few weeks.

It's moving, slowly. I expect that when I get back from vacation in
the first week of July I'll be able to spend some more time on it,
getting a working alpha/beta done by the end of August. (Sometime in
there I'm moving, too :-) I can't forecast right now when the release
will finally be out, but I hope that when things get to a working
state that other folks (you know who you are!) will be able to help
out.

Chris

[Openinteract-help] suggestions

[Jon D. <jd...@nc...>]

  I've been playing with OI for a bit over a week now.  I'm pretty impressed,
  but I'm having a little trouble getting acclimated.

  The project I am working on is porting an existing HTML::Mason application
  that I wrote last year to OI.  Mason is OK, but it doesn't really provide
  as much as I would like.

  The application is a site to register for network connections at a fairly
  large tradeshow.  We provide about 10 different types of connections to over
  150 exhibitors.  Many of the exhibitors register for multiple connections.
  The site allows them to go in an request their connections, specify at what
  location in the booth they want the fiber to come to, etc.  At any time
  until we close registration they can come in and modify their requests.
  This data is all kept in a database (PostgreSQL) and used by those of us
  building the network to determine how much gear we need to borrow, etc.  So,
  the second set of users for this site are the people on the networking
  committee.

  I have developed a database schema that handles the data that we need to
  collect and maintain pretty well.  My first question is should I try to use
  SPOPS as my interface to this data?  SPOPS has a lot of nice things, but the
  database is fairly normalized and SPOPS seems most suited to single table
  applications.  I need to do a lot of JOINs (thank goodness that Pg now
  supports OUTER JOINs -- I had to emulate them with UNIONs last year).  This
  leads to my second question -- how do I use SPOPS to access a normalized
  database?

  That said, I like SQL, so I don't necessarily want it hidden from me.  Is
  using SPOPS::SQLInterface a viable option?  The man page seems to gently
  discourage it.

  Lastly, how is OI 2 coming along?  The CVS repository on Sourceforge doesn't
  appear to have been touched in a few weeks.

  Thanks,

Jon
-- 
Jon Dugan             |  Senior Network Engineer, NCSA Network Development
jd...@nc...  |  269 CAB, 605 E Springfield, Champaign, IL 61820
217-244-7715          |  http://www.ncsa.uiuc.edu/~jdugan/

Re: [Openinteract-help] even more installation problems

[Allen D. <all...@uc...>]

> Probably not: I forgot to mention that you need to set the environment variable
> OIWEBSITE to your website directory or the parameter --website_dir to
> the same thing.

 ./v.pl c4d27f160f39f8564580debf2619324f --website_dir /usr/local/www/vcdnfo

providing --website_dir, i get a whole string of errors for
attempts to change permissions and unlink, and at the end on STDOUT I get:

$VAR1 = {
          '_session_id' => 'c4d27f160f39f8564580debf2619324f'
        };

> > BTW, I installed OpenInteract on a second machine.  Went without a hitch.
> > Looks nice!  I'll try to play with it this weekend.
>
> Is that also using MySQL?

Yes, both of these machines are Redhat 7.1, same mysql.  The problem
machine may have some old versions perl modules we're depending on, or
possibly newer libraries.

-Allen

Re: [Openinteract-help] even more installation problems

[Chris W. <ch...@cw...>]

* Allen Day (all...@uc...) [020618 02:08]:
> I get:
> 
> allenday@kermit:/home/allenday> ./v.pl c4d27f160f39f8564580debf2619324f
> HASH(0x8109368)
>  Parameter 'website_dir' must refer to an OpenInteract website directory!
> allenday@kermit:/home/allenday>
> 
> Are we on to something?

Probably not: I forgot to mention that you need to set the environment variable
OIWEBSITE to your website directory or the parameter --website_dir to
the same thing.

> BTW, I installed OpenInteract on a second machine.  Went without a hitch.
> Looks nice!  I'll try to play with it this weekend.

Is that also using MySQL?

Chris

Re: [Openinteract-help] even more installation problems

[Allen D. <all...@uc...>]

I get:

allenday@kermit:/home/allenday> ./v.pl c4d27f160f39f8564580debf2619324f
HASH(0x8109368)
 Parameter 'website_dir' must refer to an OpenInteract website directory!
allenday@kermit:/home/allenday>

Are we on to something?

BTW, I installed OpenInteract on a second machine.  Went without a hitch.
Looks nice!  I'll try to play with it this weekend.

-Allen


On Tue, 18 Jun 2002, Chris Winters wrote:

> On Sun, 2002-06-16 at 01:17, Allen Day wrote:
> > I think the problem is here:
> >
> > OpenInteract::Session::DBI::_create_session (28) >> Trying to fetch session [c4d27f160f39f8564580debf2619324f]
> > OpenInteract::Auth::user (63) >> No uid found in session. Finding login info.
> > OpenInteract::Auth::user (72) >> Creating the not-logged-in user.
> > OpenInteract::Auth::group (256) >> No logged-in user found, not retrieving groups.
> > <snip>
> > >> Error: Cannot accomplish task due to security. at /usr/lib/perl5/site_perl/5.6.1/OpenInteract/Error/System.pm line 295
> >
> > Shouldn't a uid be found in that session after a successful login?  Would
> > it be in sessions.a_session?
>
> Yes, it should. But the session is encoded in a binary format, so unless
> you have superhuman abilities that won't help much :-)
>
> Try running the following script to see what you get:
>
> ---------------
> #!/usr/bin/perl
>
> use strict;
> use Apache::Session::MySQL;
> use OpenInteract::Startup;
> use Data::Dumper qw( Dumper );
>
> {
>     my $session_id = shift @ARGV;
>     unless ( $session_id ) {
>         die "Usage: $0 session-id\n";
>     }
>     my $R = OpenInteract::Startup->setup_static_environment_options(
>                               {}, { temp_lib => 'lazy' } );
>     my $session_class = $R->CONFIG->{session_info}{class};
>     my $db = $R->db();
>     my ( %session );
>     tie %session, $session_class, $session_id, { Handle => $db,
>                                                  LockHandle => $db };
>     print Dumper( \%session );
> }
> ---------------
>
> Chris
>
>

Re: [Openinteract-help] installation woes

[Chris W. <ch...@cw...>]

On Mon, 2002-06-17 at 17:26, Jon Dugan wrote:
>   Nevermind.  I didn't have mod_dir enabled, so it wasn't finding the
>   index.html when i went to /.
> 
>   What is it about sending a trouble report that causes one's mind to become
>   clear?

"Let he who has never issued an immediate retraction to a mailing list
cast the first stone." 

Chris

-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.

Re: [Openinteract-help] even more installation problems

[Chris W. <ch...@cw...>]

On Sun, 2002-06-16 at 01:17, Allen Day wrote:
> I think the problem is here:
> 
> OpenInteract::Session::DBI::_create_session (28) >> Trying to fetch session [c4d27f160f39f8564580debf2619324f]
> OpenInteract::Auth::user (63) >> No uid found in session. Finding login info.
> OpenInteract::Auth::user (72) >> Creating the not-logged-in user.
> OpenInteract::Auth::group (256) >> No logged-in user found, not retrieving groups.
> <snip>
> >> Error: Cannot accomplish task due to security. at /usr/lib/perl5/site_perl/5.6.1/OpenInteract/Error/System.pm line 295
> 
> Shouldn't a uid be found in that session after a successful login?  Would
> it be in sessions.a_session?

Yes, it should. But the session is encoded in a binary format, so unless
you have superhuman abilities that won't help much :-)

Try running the following script to see what you get:

---------------
#!/usr/bin/perl

use strict;
use Apache::Session::MySQL;
use OpenInteract::Startup;
use Data::Dumper qw( Dumper );

{
    my $session_id = shift @ARGV;
    unless ( $session_id ) {
        die "Usage: $0 session-id\n";
    }
    my $R = OpenInteract::Startup->setup_static_environment_options(
                              {}, { temp_lib => 'lazy' } );
    my $session_class = $R->CONFIG->{session_info}{class};
    my $db = $R->db();
    my ( %session );
    tie %session, $session_class, $session_id, { Handle => $db,
                                                 LockHandle => $db };
    print Dumper( \%session );
}
---------------

Chris

-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.

Re: [Openinteract-help] installation woes

[Jon D. <jd...@nc...>]

  Nevermind.  I didn't have mod_dir enabled, so it wasn't finding the
  index.html when i went to /.

  What is it about sending a trouble report that causes one's mind to become
  clear?

On Mon, Jun 17, 2002 at 04:20:48PM -0500, Jon Dugan wrote:
>   OpenInteract looks like it will be a great environment for a couple of sites
>   I need to put together.
> 
>   I installed mod_perl 1.27 and had a ton of problems.  I switched to mod_perl
>   1.26 and httpd will start now.  (Weird problems claiming that it couldn't
>   find a module in a list of paths when the module was there.)  My system is
>   FreeBSD 4.4 and apache 1.3.24, mod_perl 1.25 and perl 5.6.1.
> 
>   The problem I am having now, is that when I go to the site I have just set
>   up I get a 500 Internal Server Error back. 
> 
>   The error log file in the OI directory shows:
> 
>   [Mon Jun 17 21:40:23 2002] [error] Can't locate object method "send_html"
>   via package "Apache" (perhaps you forgot to load "Apache"?) at
>   /usr/local/lib/perl5/site_perl/5.6.1/OpenInteract.pm line 31.
> 
>   The server error log file has:
> 
>   OpenInteract::Error::Main::initialize (59) >> Initialized DEFAULT_HANDLER
>   for app (SCinet::Stash) to (OpenInteract::Error::System)
> 
>   Any hints would be greatly appreciated!
> 
>   Thanks,
> 
> Jon
> -- 
> Jon Dugan             |  Senior Network Engineer, NCSA Network Development
> jd...@nc...  |  269 CAB, 605 E Springfield, Champaign, IL 61820
> 217-244-7715          |  http://www.ncsa.uiuc.edu/~jdugan/
> 
> ----------------------------------------------------------------------------------------------------
>                                      Sponsor's Message
> ----------------------------------------------------------------------------------------------------
>                       Bringing you mounds of caffeinated joy
>                          >>>     http://thinkgeek.com/sf    <<<
> 
> _______________________________________________
> openinteract-help mailing list
> ope...@li...
> https://lists.sourceforge.net/lists/listinfo/openinteract-help

-- 
Jon Dugan             |  Senior Network Engineer, NCSA Network Development
jd...@nc...  |  269 CAB, 605 E Springfield, Champaign, IL 61820
217-244-7715          |  http://www.ncsa.uiuc.edu/~jdugan/