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

Re: [Openinteract-help] Fruit demo package: select fails on /Fruit

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

* Steven Devijver (st...@de...) [011025 11:16]:
> However, after I installed the fruit package as described I get the
> following error when I go to http://<hostname>/Fruit :
> 
> OpenInteract::UI::Main::handler (42) >> Action died. Here is what it left: SELECT failed; cannot retrieve records at /usr/local/lib/perl5/site_perl/5.6.1/SPOPS/SQLInterface.pm line 119, <GEN0> line 3.
> 
> The demo records have all be added to the appropriate table so it
> cannot be a case of no records returned. Since otherwise OI and its
> initial packages are working fine could this too be a matter of an
> outdated demo exercise?

That is very strange that you'd get that error because we've wrapped
the 'fetch_group' statement in an eval {}. Any error thrown there
should be trapped and an error message displayed. Did this happen for
you?

Chris

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

[Openinteract-help] Fruit demo package: select fails on /Fruit

[Steven D. <st...@de...>]

All,

I've been able to install and run OI on my system. I have also been able =
to install the fruit demo package thanks to Chris.

However, after I installed the fruit package as described I get the =
following error when I go to http://<hostname>/Fruit :

OpenInteract::UI::Main::handler (42) >> Action died. Here is what it =
left: SELECT failed; cannot retrieve records at =
/usr/local/lib/perl5/site_perl/5.6.1/SPOPS/SQLInterface.pm line 119, =
<GEN0> line 3.

The demo records have all be added to the appropriate table so it cannot =
be a case of no records returned. Since otherwise OI and its initial =
packages are working fine could this too be a matter of an outdated demo =
exercise?

Perhaps if someone else can install the fruit package (check with Chris =
Winters for the latest version of that package)?

Many thanks

Steven Devijver

Re: [Openinteract-help] install_sql: insert of data from data file fails

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

* Steven Devijver (st...@de...) [011025 05:16]:

> Is it then possible that the documentation for
> OpenInteract::SQLInstall for OI 1.30 is outdated too? This document
> describes the same data file schema as the fruit example. Or doesn't
> the problem reside with the data file schema at all?

No, it wasn't a problem with the data file schema. It was a problem
with the object definition.

I've updated this to install cleanly now, and it's in CVS (in
OpenInteract/doc/fruit-0.09.tar.gz). I can email anyone who requests a
copy of the new package -- it's only 6K.

Later,

Chris

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

Re: [Openinteract-help] install_sql: insert of data from data file fails

[Steven D. <st...@de...>]

> > ...
> > What's the problem here? Why is the data file not parsed like
> > expected? After extensive study of the docs I'm still stuck. I'm
> > probably missing something ;)
>
> Nope, you're not missing anything. The only thing wrong is that the
> fruit example was written a year ago (almost exactly) and a lot of
> things in OpenInteract have changed since then. I'll give it an update
> and ship it with the next version.
>

Is it then possible that the documentation for OpenInteract::SQLInstall for
OI 1.30 is outdated too? This document describes the same data file schema
as the fruit example. Or doesn't the problem reside with the data file
schema at all?

Re: [Openinteract-help] install_sql: insert of data from data file fails

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

* Steven Devijver (st...@de...) [011024 20:19]:
> ...
> What's the problem here? Why is the data file not parsed like
> expected? After extensive study of the docs I'm still stuck. I'm
> probably missing something ;)

Nope, you're not missing anything. The only thing wrong is that the
fruit example was written a year ago (almost exactly) and a lot of
things in OpenInteract have changed since then. I'll give it an update
and ship it with the next version.

Chris

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

[Openinteract-help] install_sql: insert of data from data file fails

[Steven D. <st...@de...>]

All,

During my first installation of OI I have managed to reach the step of =
the Fruit excersise where the install_sql script is executed. There I =
encounter a peculiar error: the table is created succesfully but the =
data is not inserted correctly. The data file is being read but =
apparently is not parsed succesfully by OpenInteract::SQLInstall. This =
is shown by the hash ref printed by SPOPS::DBI. The required data =
structure is missing, does this mean the parsing of the data file is =
somehow not being completed? I would expect and error message from =
OpenInteract::SQLInstall regarding the parsing of the data file but this =
does not occur.

What's the problem here? Why is the data file not parsed like expected? =
After extensive study of the docs I'm still stuck. I'm probably missing =
something ;)

Any help is welcome.

regards

Steven Devijver

(data file below)

[ ... The output of oi_manage install_sql ... ]

Running install_sql...
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=


OpenInteract::DBI::connect (41) >> DBI::connect >> Connected ok
OpenInteract::SQLInstall::require_package_installer (29) >> Trying to =
require (OpenInteract::SQLInstall::Fruit) from =
(OpenInteract::SQLInstall) for (fruit)
OpenInteract::SQLInstall::apply (57) >> Finding coderef for =
create_structure
OpenInteract::SQLInstall::read_file (602) >> Reading file =
/usr/local/websites/oitest/pkg/fruit-0.06/struct/create-table-fruit.sql
NOTICE:  CREATE TABLE will create implicit sequence 'tbl_fruits_id_seq' =
for SERIAL column 'tbl_fruits.id'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index =
'tbl_fruits_pkey' for table 'tbl_fruits'
OpenInteract::SQLInstall::create_structure (144) >> Structure (from =
create-table-fruit.sql) ok!
oitest::User::_class_initialize (15) >> Set oitest::User to use crypt =
(1)
OpenInteract::DBI::connect (41) >> DBI::connect >> Connected ok
OpenInteract::SQLInstall::apply (57) >> Finding coderef for install_data
OpenInteract::SQLInstall::read_file (602) >> Reading file =
/usr/local/websites/oitest/pkg/fruit-0.06/data/fruit-initial-data.perl
OpenInteract::SQLInstall::process_data_file (259) >> Reading data for =
class oitest::Fruit
SPOPS::DBI::save (524) >> Trying to save a ( oitest::Fruit )
SPOPS::DBI::save (549) >> Security check passed ok. Continuing.
SPOPS::DBI::_save_insert (611) >> Treating the save as an INSERT.
SPOPS::DBI::_save_insert (645) >> Insert failed! Args:  $VAR1 =3D {
          'db' =3D> bless( {}, 'DBI::db' ),
          'is_add' =3D> 1,
          'skip_cache' =3D> 1,
          'DEBUG' =3D> 1,
          'skip_log' =3D> 1,
          'table' =3D> 'tbl_fruits',
          'skip_security' =3D> 1,
          'return_sth' =3D> 1
        };
 Cannot continue with no SQL, values or table name
OpenInteract::SQLInstall::apply (57) >> Finding coderef for =
install_security
Status of the packages requested for SQL install:

fruit (0.06)
  OK:

      Structure:
        * Created table from (create-table-fruit.sql): ok
      Data:
        * Error: Cannot create SPOPS object!
      Basic: Error saving record to database: INSERT failed
      at
      /usr/local/lib/perl5/site_perl/5.6.1/SPOPS/SQLInterfa
      ce.pm line 243.

      Error: Cannot continue with no SQL, values or table
      name

      Security:


Important Notes
-------------------------

none

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=

Finished install_sql!


[ ... And the data file ... ]

$data =3D [
   {
      spops_class =3D> 'OpenInteract::Fruit',
      field_order =3D> [ qw/ name taste price / ]
   },
   [ "Apple", "slightly sour", "1.00" ],
   [ "Banana", "sweet", "1.00" ],
   [ "Cherry", "red", "0.05" ],
   [ "Tomato", "yes, this is a fruit - look it up in the dictionary", =
"1.00" ],
];

[Openinteract-help] Re: default index pages in OI

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

* Peter Beardsley (pbe...@ap...) [011024 16:42]:
> Is there any way to facilitate the default index page behavior you
> see with Apache ie:
> 
> http://www.foo.com/bar/
> 
> actually loads
> 
> http://www.foo.com/bar/index.html

This already exists, actually. As long as '/bar/' is being handled by
the 'basic_page' handler (in the 'static_page' package, an unfortunate
naming mishap) it will look for an index page whose name depends on
whether OI is getting the content from the filesystem or the database.

And in general, you can (and should!) specify a default action for a
handler that gets called when no other action is specified. So when
you request:

  http://www.foo.com/User/

The 'user' handler in 'base_user' gets the request and, finding no
action, uses the default action of 'search_form'.

> I realize that in OI the first URL itself can be a document so it
> kinda breaks the rules, but I would like not to have to maintain two
> identical copies of the same document.
> 
> I could mangle the URL with mod_rewrite, but I thought I'd check
> with you to see if maybe there's some way of doing like a "symbolic
> link" or some other trick.

Yep, you should be able to go into:

 $WEBSITE_DIR/pkg/static_page-x.xx/conf/action.perl

and set the keys:

 'basicpage'->'object_home_name'

and/or:

 'basicpage'->'filesystem_home_name'

To the name you want (by default they're set to 'home' and
'index.html', respectively). It currently only handles one name
(vs. the Apache DirectoryIndex multiple names).

However, I'm rewriting this module right now -- literally getting
ready to test the first version :-) -- and you'll be able to specify
multiple names in it.

Chris

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

Re: [Openinteract-help] multiple errors starting with Test::Handler::Error

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

* Mike Eggleston (mi...@mi...) [011023 15:12]:
> I get the following message:
> 
> Can't locate object method "read_date" via package "Test::Handler::Error" (perhaps you forgot to load
>  "Test::Handler::Error"?) at /www/htdocs/OI/pkg/base_error-1.30/Test/Handler/Error.pm line 60. 
> 
> when pressing 'Filter' on the Error Browser screen with choosing a
> previous date of 1 Jan 2000 and an ending date of 1 Dec 2002.

Egads, how dumb. Change:


        my $from_date = $class->read_date( 'filter_date_from' );
to:
        my $from_date = $class->date_read( 'filter_date_from' );

and:

        my $to_date = $class->read_date( 'filter_date_to' );
to:
        my $to_date = $class->date_read( 'filter_date_to' );

I'll update this in CVS shortly. Thanks for the post.

Chris

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

[Openinteract-help] multiple errors starting with Test::Handler::Error

[Mike E. <mi...@mi...>]

I get the following message:

Can't locate object method "read_date" via package "Test::Handler::Error" (perhaps you forgot to load
 "Test::Handler::Error"?) at /www/htdocs/OI/pkg/base_error-1.30/Test/Handler/Error.pm line 60. 

when pressing 'Filter' on the Error Browser screen with choosing a
previous date of 1 Jan 2000 and an ending date of 1 Dec 2002.

I received another error on logout, but I can't reproduce it just now.

Mike

Re: [Openinteract-help] SPOPS::LDAP::Multidatasource

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

* Andreas Nolte (And...@Be...) [011023 08:52]:
>
> just tried to use SPOPS::LDAP::Multidatasource to get users from different
> ldap servers. I managed to get the users looked up correktly, but the
> password check bails out, if anything other than the main ldap server is
> used. Any hints?

Yep. In SPOPS::LDAP::MultiDatasource we weren't making the datasource
sticky, meaning that once an object was retrieved it lost all
knowledge of whence it came. Ouch.

I've got a modified OpenInteract::User::LDAP file rolled into a new
base_user package, as well as changes to
SPOPS::LDAP::MultiDatasource. I can send you both offlist shortly.

I'll probably release a new SPOPS fairly soon that integrates the
bugfix from SPOPS::ClassFactory::DefaultBehavior mentioned last week
as well as a couple of other small items.

Chris

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

[Openinteract-help] SPOPS::LDAP::Multidatasource

[<And...@Be...>]

Hey,

just tried to use SPOPS::LDAP::Multidatasource to get users from different
ldap servers. I managed to get the users looked up correktly, but the
password check bails out, if anything other than the main ldap server is
used. Any hints?

regards,

Andreas

Re: [Openinteract-help] debugging eval

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

* Jochen Lillich (jl...@te...) [011019 08:29]:
> Hi,
> 
> not until working with OI, I found that enclosing critical code parts
> in eval blocks keeps my program from crashing.
> 
> But now, I ran into problems. I get the following error on Apache
> startup:
> 
> (eval 214): Odd number of elements in hash assignment at (eval 214)
> line 1
> 
> How am I supposed to find the file and line where the error occurs if
> Perl sees the eval block as an isolated script?

This is almost certainly occurring in SPOPS when it creates the
classes using SPOPS::ClassFactory. The best thing to do: edit SPOPS.pm
and set DEBUG to 1. This way you should see a running commentary on
what classes are being built and be able to pinpoint which
configuration is giving you headaches.

Thanks,

Chris

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

[Openinteract-help] debugging eval

[Jochen L. <jl...@te...>]

Hi,

not until working with OI, I found that enclosing critical code parts
in eval blocks keeps my program from crashing.

But now, I ran into problems. I get the following error on Apache
startup:

(eval 214): Odd number of elements in hash assignment at (eval 214)
line 1

How am I supposed to find the file and line where the error occurs if
Perl sees the eval block as an isolated script?

Thanks in advance,

        Jochen

-- 
----------------------------------------------------------------
 *Jochen Lillich*, Dipl.-Inform. (FH) 
 Consultant/Trainer @ /TeamLinux GbR/
 Tel. +49 7255 76784-12                 http://www.teamlinux.de
----------------------------------------------------------------

Re: [Openinteract-help] Static page problem

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

* Peter Beardsley (pbe...@ap...) [011015 17:23]:
> I just installed OpenInteract-- it seems like everything's okay, but
> this is a problem I'm having: When I create a new static page, it
> gets put in the basic_page table fine, and I can access it by going
> to it's designated directory.  But the pages don't show up in the
> tree when I go to "List".  It shows the beginning of a tree and then
> "(2 files)", but it doesn't display the names of the files.
> 
> Any idea what this could possibly be?

Ok, figured it out. Error from reorganizing things. Easy patch
(attached, also on Sourceforge), or you can grab the modified file
SPOPS/SPOPS/ClassFactory/DefaultBehavior.pm from CVS. (I can send it
to you as well, if you like.)

Thanks for the report!

Chris

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

Re: [Openinteract-help] Static page problem

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

* Peter Beardsley (pbe...@ap...) [011015 17:23]:
> I just installed OpenInteract-- it seems like everything's okay, but
> this is a problem I'm having: When I create a new static page, it
> gets put in the basic_page table fine, and I can access it by going
> to it's designated directory.  But the pages don't show up in the
> tree when I go to "List".  It shows the beginning of a tree and then
> "(2 files)", but it doesn't display the names of the files.
> 
> Any idea what this could possibly be?

Yep -- for some reason the 'directory' field is not getting set
properly. I'm looking into it now.

For a quick fix, you can set the 'directory' field by hand to
everything but the filename of your location. For instance:

 location               directory
 ==========             ==========
 /test/test1            /test
 /test/here/now/test2   /test/here/now
 /this                  

More soon...

Chris

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

[Openinteract-help] Static page problem

[Peter B. <pbe...@ap...>]

I just installed OpenInteract-- it seems like everything's okay, but =
this is a problem I'm having:  When I create a new static page, it gets =
put in the basic_page table fine, and I can access it by going to it's =
designated directory.  But the pages don't show up in the tree when I go =
to  "List".  It shows the beginning of a tree and then "(2 files)", but =
it doesn't display the names of the files.

Any idea what this could possibly be?

Re: [Openinteract-help] Security of initial data

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

* Jochen Lillich (jl...@te...) [011013 06:11]:
> Hi Chris,
> 
> As we already discussed, I tried to import some data by converting it
> into an initial_data.perl file. The data import went well, but I was
> surprised that no security entries were generated. So my data couldn't
> be accessed by anyone but the superuser. Is this behaviour intentional?

I had a response all prepared for this based on what I *thought* would
happen, but then I actually looked at the code and saw this wasn't
so. Whoops!

Previously I'd generated all new security entries by hand (or script)
and put them in the 'install_security.dat' files you'll find in the
various packages, but this clearly isn't scalable. The problem is that
when we're installing security we're not running under a user, so we
have to do the 'save()' call with 'skip_security' set to allow the
insert to proceed.

However, when 'skip_security' is active we also don't create security,
so that's why no security was created for your objects.

To automate this there's a batch security creation script at
'pkg/base_security_x.xx/script/create_object_security.pl'.

To solve the problem is a little more tricky and a bit of a
bootstrapping issue. (It's also kind of complicated.)

So maybe what I'll do for now is writeup a data import guide that has
the instructions to use the script I mentioned above. In the long-term
maybe we can make this more consistent.

Thanks,

Chris

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

[Openinteract-help] Security of initial data

[Jochen L. <jl...@te...>]

Hi Chris,

As we already discussed, I tried to import some data by converting it
into an initial_data.perl file. The data import went well, but I was
surprised that no security entries were generated. So my data couldn't
be accessed by anyone but the superuser. Is this behaviour intentional?

Regards,

        Jochen

-- 
Jochen Lillich                  http://geewiz.teamlinux.de

           Intel: where Quality is job number 0.9998782345!

Re: [Openinteract-help] need for both -users and -help mailing lists?

[Jochen L. <jl...@te...>]

Chris Winters schrieb am Thu, 11 Oct 2001 08:17:52 -0400:

> So I'm inclined to delete -users and move the people not already there
> over to -help. What do you think? 

Fine with me. One less procmail entry. :-)

-- 
Jochen Lillich                  http://geewiz.teamlinux.de

Ohne Sonntag gibt es nur noch Werktage.

Re: [Openinteract-help] cannot read oi_docs/templates.html

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

* Reinier Post (rp...@wi...) [011012 06:18]:
>   Hello list,
> 
> Still in my first steps with OpenInteract, I have installed it from CPA
> After applying the patch to base_user posted here, I have been able to
> administer users and read most of the system documentation.  But
> oi_docs/templates.html gives me an error message: it complains about
> a character '&', which isn't actually in the source.
>
> Without prior experience with the Template Toolkit, I find it hard to
> understand the cause of this error, but the message seems very misleading.

This is a very tricky and misleading error. It will not appear if you
just view the page as normal HTML.

The line in the file you're getting an error on is:

 [% IF news.tmp_security_level >= security_level.write %]

You see it reported back to you in the browser as:

 [% IF news.tmp_security_level >= security_level.write %]

which is absolutely fine.

The problem is that this page contains samples of TT code, which are
in turn getting interpreted by TT. 

This points to a larger problem, so what I'll do is create a new tag
for static pages that tells OI NOT to run this through TT but just to
return the content. This is similar to how you can specify boxes to
use on the page using <boxes>box1, box2</boxes>.

This is pretty easy so it will be in the next release, any day now. In
the meantime, just open the file directly in your browser rather than
going through OpenInteract.

Thanks!

Chris

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

Re: [Openinteract-help] cannot read oi_docs/templates.html

[Reinier P. <rp...@wi...>]

PS

The exact error message is this:

Cannot process template!file error - parse error: anon_1 line 378: unexpected token (&) [% IF
 news.tmp_security_level >= security_level.write %] at
 /home/rp/rpsoft/perl-5.6.1/lib/site_perl/5.6.1/OpenInteract/Template/Process.pm line 50, line 1. 

[Openinteract-help] cannot read oi_docs/templates.html

[Reinier P. <rp...@wi...>]

  Hello list,

Still in my first steps with OpenInteract, I have installed it from CPA
After applying the patch to base_user posted here, I have been able to
administer users and read most of the system documentation.  But
oi_docs/templates.html gives me an error message: it complains about
a character '&', which isn't actually in the source.

Without prior experience with the Template Toolkit, I find it hard to
understand the cause of this error, but the message seems very misleading.

1) How can I repair the page?  The link from

  http://www.openinteract.org/docs/developer

is broken.

2) How can I obtain better error messages when debugging HTML templates?


This is my version info:

% perl -MOpenInteract -MSPOPS -e \
  'printf "%s\n%s\n", $OpenInteract::VERSION,$SPOPS::VERSION'
1.07
0.50
% perl -v | head -2

This is perl, v5.6.1 built for sun4-solaris-multi
% uname -rsp
SunOS 5.7 sparc

-- 
Reinier Post

[Openinteract-help] need for both -users and -help mailing lists?

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

Currently we have both openinteract-users and openinteract-help
mailing lists. I'm not sure we need both of them -- having -help, -dev
and -announce lists seems sufficient for talking about the project,
looking for help, discussing development strategies, letting people
know about new releases, etc.

There's quite a bit of membership overlap between the -users and -help
lists, and it's trivial for me to delete one list and subscribe those
from that list to the other. Neither of the lists is high-traffic --
-users has had 34 messages in 2001, -help has had 101.

So I'm inclined to delete -users and move the people not already there
over to -help. What do you think? 

Thanks,

Chris

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

[Openinteract-help] openinteract-commits list now available

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

For people curious about the commits going into CVS, the list
'ope...@li...' has been
created. Subscribe via the normal means at:

 http://sourceforge.net/mail/?group_id=16810

Chris

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

Re: [Openinteract-help] Re: [Templates] Internetlinks in OI

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

* Chris McDaniel (Chr...@te...) [011010 09:31]:
> 
> Just a note - this concept of putting arbitrary external content in
> a box in OI is basically the concept behind plumtree's 'gadgets',
> which is uber-cool.  If someone is going to be taking this on,
> making the handler such that parameters posted to the dynamic URL
> get passed back to the content generator remotely (like a gateway)
> so that you could use external cgi/servlets/whatever in a box, would
> be fantastic, and probably take OI to another level entirely.

And even further: once retrieved from the other site, OI can perform
actions based on where the content was retrieved from or the content
itself. For instance, you can create a box that gets triggered when a
user requests information from a URL concerning baseball that grabs
the latest box scores from somewhere. (Or even the box score from the
user's favorite team.) Or even modify the content from the other site
with links, highlights...

Fun stuff :-) (but probably OT for the TT list)

Chris

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