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

RE: [Openinteract-help] getting started

[Steve S. <sap...@gs...>]

Can you point me to some docs or examples for writing that
wrapper?  I looked at SPOPS::DBI some already.  

I'll see about the case study.  Not sure how long it will
take to roll this out ... it's mostly a "spare time" thing
for me right now. 

Excuse the change in mail format ... forced to use Outlook
at work.  

----
Steve Sapovits
GSI Commerce
sap...@gs...

> Security is one of the more attractive features, and you'd just have to
> fit an SPOPS wrapper around your existing data to get it.
> 
> > Thanks for the other info.  I have a much clearer road map now.
> 
> Excellent. If you're into this sort of thing it would be great to get
> another case study like John Sequira's:
> 
> http://radio.weblogs.com/0103492/gems/notes.html
> 
> Particularly since what you're doing is a retrofit rather than creating
> something entirely new.
> 
> Chris
>  
> -- 
> Chris Winters (ch...@cw...)
> Building enterprise-capable snack solutions since 1988.

Re: [Openinteract-help] getting started

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

On Mon, 2002-11-18 at 10:53, Steve Sapovits wrote:
> One thing I'd like to be consistent on is the access control/security.  I
> would need to plug in to SPOPS/OI fully to get that, right?  Seems like
> with the read-only code you sent I could do that without too much pain.
> You think it's worth it?  And I'd also want to be able to handle results
> consistently, as with the paging, etc.

Security is one of the more attractive features, and you'd just have to
fit an SPOPS wrapper around your existing data to get it.

> Thanks for the other info.  I have a much clearer road map now.

Excellent. If you're into this sort of thing it would be great to get
another case study like John Sequira's:

http://radio.weblogs.com/0103492/gems/notes.html

Particularly since what you're doing is a retrofit rather than creating
something entirely new.

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

Re: [Openinteract-help] getting started

[Steve S. <sap...@gs...>]

Chris Winters wrote:

> There's not much of a benefit. If you were creating tools for other
> people to use it would be useful, but if it's for an in-house project
> (or set of projects) there's not much use beyond being consistent with
> what OI currently uses. That you're probably already used to using your
> interface overrides any benefit OI would have.

One thing I'd like to be consistent on is the access control/security.  I
would need to plug in to SPOPS/OI fully to get that, right?  Seems like
with the read-only code you sent I could do that without too much pain.
You think it's worth it?  And I'd also want to be able to handle results
consistently, as with the paging, etc.

Thanks for the other info.  I have a much clearer road map now.

-- 
Steve Sapovits    GSI Commerce, Inc.    http://www.gsicommerce.com
sap...@gs...

Re: [Openinteract-help] getting started

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

On Mon, 2002-11-18 at 09:57, Steve Sapovits wrote:
> This gives me something more to chew on.  Let me throw some more specifics
> at you.  We have many existing data stores I'd want to feed up through OI
> and its TT front end.  A lot of these are Oracle databases/tables.  Those
> are managed by existing apps., but it would seem I could plug those in as
> read only and still benefit from the full OI stack (security, access, etc.).
> I didn't see any master read-only flag -- just a setting that lists the
> columns that are not to be updated.  Is that correct?  For read-only, are
> there advantages to going full OI versus doing something like you suggest
> above?

Actually, SPOPS has a tool for this. If you add: SPOPS::Tool::ReadOnly
to your object's isa declaration, like:

my $spops = {
   myobject => {
      class => 'This::Object',
      isa   => [ qw/ SPOPS::Tool::ReadOnly OpenInteract::SPOPS::DBI
                     SPOPS::DBI::MySQL  SPOPS::DBI / ],
      ...
   },
};

Then any calls to save/remove get intercepted into a no-op.

> In addition to the DB tables we have this other data translation tool set.
> That can either work off DB tables or other data stores; and it creates
> non-database stores (e.g., files in various formats) we'd want to display.
> It would seem one way to do this would be to create an SPOPS interface to
> our data tool set -- fill in enough of the methods to have data accessed
> read-only.  It has a well-defined interface so I think this might be
> relatively easy.  I'm just not 100% clear on the benefits of doing that
> versus just using a direct TT interface to that data.

There's not much of a benefit. If you were creating tools for other
people to use it would be useful, but if it's for an in-house project
(or set of projects) there's not much use beyond being consistent with
what OI currently uses. That you're probably already used to using your
interface overrides any benefit OI would have.

> One other question I haven't seen answered:  For large data driven tables,
> what's the procedure for having those displayed paged?  I know TT offers
> something here, but does OI do anything more?  Do you have to load a full
> table set for each access and page into it, or is there something better?

Yes -- check out the 'results_manage' package; specifically
OpenInteract::ResultsManage. What happens is that your query will fetch
all the IDs the first time; these are stored in a temporary file keyed
to a value which you use as a search ID. Then you pass in the search ID,
the number of items per page and the page number and you'll get in
return an iterator which will cycle through those objects.

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

Re: [Openinteract-help] getting started

[Steve S. <sap...@gs...>]

Chris Winters wrote:

> OI provides a data access model for you to use, but you're not tied to
> it for new development.  Similarly, OI provides an integrated view
> processing model with all sorts of goodies (Plugin, including other
> templates, components, etc.) but you're not tied to it either.
> 
> I'm not sure how your existing system works, but if you've put a lot of
> work into your data model you might want to keep that. And if you've
> already got a templating/view system setup you can access it just like
> you would any other perl module.
> 
> The thing to remember is that at the core an OI action has one task:
> generate content. Every OI action returns content, even if that means
> (pseudo-)forwarding the flow to another action.
> 
> So instead of something like:
> 
> sub show {
>     my ( $class, $p ) = @_;
>     my $R = OpenInteract::Request->instance;
>     my $object_id = $p->{object_id} || $R->apache( 'object_id' );
>     my $object = $R->myobject->fetch( $object_id );
>     return $R->template->handler( {}, { object => $object },
>                                   { name => 'mypkg::mytmpl' } );
> }
> 
> you can have:
> 
> sub show {
>     my ( $class, $p ) = @_;
>     my $object_id = $p->{object_id} || $R->apache( 'object_id' );
>     my $object = MyDataModel->retrieve( 'My::Object', $object_id );
>     return MyViewProcess->generate( 
>                     'objectview', { object => $object } );
> }
> 
> And OI won't really care.
> 
> In the next version you can define a generic ContentGenerator and link
> that to an action, so you should be able to swap different ways of
> generating content in and out. (We'll see how it works...)

This gives me something more to chew on.  Let me throw some more specifics
at you.  We have many existing data stores I'd want to feed up through OI
and its TT front end.  A lot of these are Oracle databases/tables.  Those
are managed by existing apps., but it would seem I could plug those in as
read only and still benefit from the full OI stack (security, access, etc.).
I didn't see any master read-only flag -- just a setting that lists the
columns that are not to be updated.  Is that correct?  For read-only, are
there advantages to going full OI versus doing something like you suggest
above?

In addition to the DB tables we have this other data translation tool set.
That can either work off DB tables or other data stores; and it creates
non-database stores (e.g., files in various formats) we'd want to display.
It would seem one way to do this would be to create an SPOPS interface to
our data tool set -- fill in enough of the methods to have data accessed
read-only.  It has a well-defined interface so I think this might be
relatively easy.  I'm just not 100% clear on the benefits of doing that
versus just using a direct TT interface to that data.

One other question I haven't seen answered:  For large data driven tables,
what's the procedure for having those displayed paged?  I know TT offers
something here, but does OI do anything more?  Do you have to load a full
table set for each access and page into it, or is there something better?

Thanks.

-- 
Steve Sapovits    GSI Commerce, Inc.    http://www.gsicommerce.com
Email:   sap...@gs...
Work:    610-491-7087
Mobile:  610-574-7706
Pager:   877-239-4017

Re: [Openinteract-help] getting started

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

On Sun, 2002-11-17 at 01:34, Steve Sapovits wrote:
> In the Illustrated Manager's Guide To OpenInteract doc, diagram.png
> does not show up.  If I look for it directly I get a "File Not Found"
> page error.  I have Apache set up with a front-end Apache proxying
> back to a mod_perl Apache as suggested.  I see the request in both
> logs.  I can see the doc as expected in a regular Apache server
> environment.  Any ideas there?  I did add two rewrite rules to the
> proxy to pick up existing CGI's and a directory as a migration path.
> Neither of those rules remotely matches the diagram.png URL.

Ah, good catch. The problem is that the request is being passed to the
backend server but OI doesn't have the page registered. You can solve
this in two ways:

1) You can add the following to your front-end proxy:

 RewriteRule .png$ - [L]

2) You can scan the directory for new documents and add 'diagram.png' as
a viewable object. From the 'Admin Tools' menu select 'Page Actions'
then 'Scan' and enter '/oi_docs/' as the directory.

I'll change the install to add this image properly..

> The bigger question I'm still tackling mentally reading the docs is
> the best way to map data to pages.  I have many data sources -- some
> database-oriented, some file based, some even from other sources.  We
> have a tool set we developed that abstracts some of this into ETL like
> transforms.  Ideally I want to plug into that.  I can see how I'd write
> packages suitable for TT template substitution -- mostly I'd write
> wrappers using this underlying toolset as the base data manager; the
> wrappers mapping that to a TT model. That seems good enough, but it's
> not clear to me if I should go beyond that and be importing data into OI.
> What exactly is the difference?  Not too dumb a question I hope ...

OI provides a data access model for you to use, but you're not tied to
it for new development.  Similarly, OI provides an integrated view
processing model with all sorts of goodies (Plugin, including other
templates, components, etc.) but you're not tied to it either.

I'm not sure how your existing system works, but if you've put a lot of
work into your data model you might want to keep that. And if you've
already got a templating/view system setup you can access it just like
you would any other perl module.

The thing to remember is that at the core an OI action has one task:
generate content. Every OI action returns content, even if that means
(pseudo-)forwarding the flow to another action.

So instead of something like:

sub show {
    my ( $class, $p ) = @_;
    my $R = OpenInteract::Request->instance;
    my $object_id = $p->{object_id} || $R->apache( 'object_id' );
    my $object = $R->myobject->fetch( $object_id );
    return $R->template->handler( {}, { object => $object },
                                  { name => 'mypkg::mytmpl' } );
}

you can have:

sub show {
    my ( $class, $p ) = @_;
    my $object_id = $p->{object_id} || $R->apache( 'object_id' );
    my $object = MyDataModel->retrieve( 'My::Object', $object_id );
    return MyViewProcess->generate( 
                    'objectview', { object => $object } );
}

And OI won't really care.

In the next version you can define a generic ContentGenerator and link
that to an action, so you should be able to swap different ways of
generating content in and out. (We'll see how it works...)

Thanks,

Chris

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

Re: [Openinteract-help] getting started

[Steve S. <sap...@gs...>]

I wrote:
> 
> In the Illustrated Manager's Guide To OpenInteract doc, diagram.png
> does not show up.  If I look for it directly I get a "File Not Found"
> page error.  I have Apache set up with a front-end Apache proxying
> back to a mod_perl Apache as suggested ...

I forgot to add that I do not have root priveleges on the install
box so I have the proxy listening on 8080 and the mod_perl back end
listening on 8081.

-- 
Steve Sapovits    GSI Commerce, Inc.    http://www.gsicommerce.com
sap...@gs...

[Openinteract-help] getting started

[Steve S. <sap...@gs...>]

I installed okay -- had some problems with Oracle, so I switched
to MySQL.  Everything's about working it seems.  One small bug I
can't figure out:

In the Illustrated Manager's Guide To OpenInteract doc, diagram.png
does not show up.  If I look for it directly I get a "File Not Found"
page error.  I have Apache set up with a front-end Apache proxying
back to a mod_perl Apache as suggested.  I see the request in both
logs.  I can see the doc as expected in a regular Apache server
environment.  Any ideas there?  I did add two rewrite rules to the
proxy to pick up existing CGI's and a directory as a migration path.
Neither of those rules remotely matches the diagram.png URL.

The bigger question I'm still tackling mentally reading the docs is
the best way to map data to pages.  I have many data sources -- some
database-oriented, some file based, some even from other sources.  We
have a tool set we developed that abstracts some of this into ETL like
transforms.  Ideally I want to plug into that.  I can see how I'd write
packages suitable for TT template substitution -- mostly I'd write
wrappers using this underlying toolset as the base data manager; the
wrappers mapping that to a TT model. That seems good enough, but it's
not clear to me if I should go beyond that and be importing data into OI.
What exactly is the difference?  Not too dumb a question I hope ...

This looks very good at first glance.

-- 
Steve Sapovits    GSI Commerce, Inc.    http://www.gsicommerce.com
sap...@gs...

RE: [Openinteract-help] upgrading questions...

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

On Thu, 2002-11-14 at 10:34, Chris McDaniel wrote:
> Hello again,
> 
> Thanks for your suggestions.  I changed the use lib as you suggested, and
> the require for  startup.pl is indeed after the <Perl> section.  That alone
> was not enough to fix it, but I did discover that if I changed the order of
> the includes in httpd.conf something interesting happened.  I have 2
> websites configured, my productions site, which wants OI-1.21 and this new
> site which wants OI 1.54.  If I do this is my httpd.conf:
> Include /var/www/1.21-site/conf/httpd_modperl_solo.conf
> Include /var/www/1.54-site/conf/httpd_modperl_solo.conf
> ...

Oh! I didn't realize you were running both sites in the same mod_perl
instance. That won't work -- there are many, many more places where
you'll run into the same sort of problems you had here.

To do this you need to run two entirely separate mod_perl instances: one
for the old site and one for the new.

Chris

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

RE: [Openinteract-help] upgrading questions...

[Chris M. <Chr...@te...>]

Hello again,

Thanks for your suggestions.  I changed the use lib as you suggested, and
the require for  startup.pl is indeed after the <Perl> section.  That alone
was not enough to fix it, but I did discover that if I changed the order of
the includes in httpd.conf something interesting happened.  I have 2
websites configured, my productions site, which wants OI-1.21 and this new
site which wants OI 1.54.  If I do this is my httpd.conf:
Include /var/www/1.21-site/conf/httpd_modperl_solo.conf
Include /var/www/1.54-site/conf/httpd_modperl_solo.conf

I get the error I gave you below.  If I do:
Include /var/www/1.54-site/conf/httpd_modperl_solo.conf
Include /var/www/1.21-site/conf/httpd_modperl_solo.conf

Everything starts up OK but then my production site gives:
Cannot require stash class ()!

In my browser, which is bad for me.

So I'm wondering about maybe mod_perl compiling the OI modules and then not
searching @INC again next time the mod is called...  Do I have to do
something crazy like rename either my old or new OI modules and fix all my
code to reflect?

Thanks,

Chris

-----Original Message-----
From: Chris Winters [mailto:ch...@cw...]
Sent: November 14, 2002 8:57 AM
To: Chris McDaniel
Cc: 'ope...@li...'
Subject: RE: [Openinteract-help] upgrading questions...


On Thu, 2002-11-14 at 03:01, Chris McDaniel wrote:
> Well, I've finally gotten trying to upgrade my OI installation.  Following
> your outline below, I have installed (from cpan) the latest to a local lib
> directory (with PREFIX=/var/www/localperl/) and added the use lib
statement
> to my .conf file - here's a little excerpt:
> ------------------
> <Perl>
>  use lib qw( /var/www/commerce );
>  use lib qw( /var/www/localperl/lib/site_perl/5.6.1 );
>  use lib qw( /var/www/localperl/lib/5.6.1 );
> </Perl>

What happens if you do this instead:

<Perl>
  use lib qw( /var/www/commerce
              /var/www/localperl/lib/site_perl/5.6.1
              /var/www/localperl/lib/5.6.1 );
</Perl>

> And I had some troubles starting up the server - here's the output
> ------------------
> [Thu Nov 14 02:38:40 2002] [error] Cannot read configuration file! Error:
No
> configuration class corresponding to type (ini) at
> /usr/local/lib/perl5/site_perl/5.6.1/OpenInteract/Config.pm line 38.
> ...

> And it looks to me from the paths in the error message like my local
modules
> are not being used...  So I tried adding a use lib statement to startup.pl
> as well, just to see, and I get the same error.

Yes, that's the problem. Is the <Perl> section you listed above before
the PerlRequire that brings in startup.pl?
 
> Using a standalone script with the use lib statements as you suggested
seems
> to be better - it just complains about a table not existing (which I
> expected) but I don't know if it is actually looking in my perllocal dir
or
> not.
> 
> Can anyone help me?  Apologies if the solution is obvious, I have my
> wee-hours-of-the-morning-brain on...

Ok, so this is definitely an issue with the library directories in
mod_perl. If moving the <Perl> section before PerlRequire doesn't work,
something else to try would be explicitly placing the entries in @INC:

<Perl>
  unshift @INC, qw( /var/www/commerce
                    /var/www/localperl/lib/site_perl/5.6.1
                    /var/www/localperl/lib/5.6.1 );
</Perl>

This does the same thing as 'use lib' (mostly) but at a lower level.
Also, add something like the following to startup.pl to see if the
changes are taking properly:

 warn "My INC:\n", join( "\n", @INC ), "\n";

Good luck!

Chris

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

RE: [Openinteract-help] upgrading questions...

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

On Thu, 2002-11-14 at 03:01, Chris McDaniel wrote:
> Well, I've finally gotten trying to upgrade my OI installation.  Following
> your outline below, I have installed (from cpan) the latest to a local lib
> directory (with PREFIX=/var/www/localperl/) and added the use lib statement
> to my .conf file - here's a little excerpt:
> ------------------
> <Perl>
>  use lib qw( /var/www/commerce );
>  use lib qw( /var/www/localperl/lib/site_perl/5.6.1 );
>  use lib qw( /var/www/localperl/lib/5.6.1 );
> </Perl>

What happens if you do this instead:

<Perl>
  use lib qw( /var/www/commerce
              /var/www/localperl/lib/site_perl/5.6.1
              /var/www/localperl/lib/5.6.1 );
</Perl>

> And I had some troubles starting up the server - here's the output
> ------------------
> [Thu Nov 14 02:38:40 2002] [error] Cannot read configuration file! Error: No
> configuration class corresponding to type (ini) at
> /usr/local/lib/perl5/site_perl/5.6.1/OpenInteract/Config.pm line 38.
> ...

> And it looks to me from the paths in the error message like my local modules
> are not being used...  So I tried adding a use lib statement to startup.pl
> as well, just to see, and I get the same error.

Yes, that's the problem. Is the <Perl> section you listed above before
the PerlRequire that brings in startup.pl?
 
> Using a standalone script with the use lib statements as you suggested seems
> to be better - it just complains about a table not existing (which I
> expected) but I don't know if it is actually looking in my perllocal dir or
> not.
> 
> Can anyone help me?  Apologies if the solution is obvious, I have my
> wee-hours-of-the-morning-brain on...

Ok, so this is definitely an issue with the library directories in
mod_perl. If moving the <Perl> section before PerlRequire doesn't work,
something else to try would be explicitly placing the entries in @INC:

<Perl>
  unshift @INC, qw( /var/www/commerce
                    /var/www/localperl/lib/site_perl/5.6.1
                    /var/www/localperl/lib/5.6.1 );
</Perl>

This does the same thing as 'use lib' (mostly) but at a lower level.
Also, add something like the following to startup.pl to see if the
changes are taking properly:

 warn "My INC:\n", join( "\n", @INC ), "\n";

Good luck!

Chris

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

RE: [Openinteract-help] upgrading questions...

[Chris M. <Chr...@te...>]

Hello,

Well, I've finally gotten trying to upgrade my OI installation.  Following
your outline below, I have installed (from cpan) the latest to a local lib
directory (with PREFIX=/var/www/localperl/) and added the use lib statement
to my .conf file - here's a little excerpt:
------------------
<Perl>
 use lib qw( /var/www/commerce );
 use lib qw( /var/www/localperl/lib/site_perl/5.6.1 );
 use lib qw( /var/www/localperl/lib/5.6.1 );
</Perl>
------------------
And I had some troubles starting up the server - here's the output
------------------
[Thu Nov 14 02:38:40 2002] [error] Cannot read configuration file! Error: No
configuration class corresponding to type (ini) at
/usr/local/lib/perl5/site_perl/5.6.1/OpenInteract/Config.pm line 38.

Compilation failed in require at (eval 351) line 1.

Syntax error on line 24 of /var/www/commerce/conf/httpd_modperl_solo.conf:
Cannot read configuration file! Error: No configuration class corresponding
to type (ini) at /usr/local/lib/perl5/site_perl/5.6.1/OpenInteract/Config.pm
line 38.

Compilation failed in require at (eval 351) line 1.
------------------

And it looks to me from the paths in the error message like my local modules
are not being used...  So I tried adding a use lib statement to startup.pl
as well, just to see, and I get the same error.

Using a standalone script with the use lib statements as you suggested seems
to be better - it just complains about a table not existing (which I
expected) but I don't know if it is actually looking in my perllocal dir or
not.

Can anyone help me?  Apologies if the solution is obvious, I have my
wee-hours-of-the-morning-brain on...

Thanks,

Chris McDaniel

-----Original Message-----
From: Chris Winters [mailto:ch...@cw...]
Sent: January 8, 2002 10:11 AM
To: Chris McDaniel
Cc: 'ope...@li...'
Subject: Re: [Openinteract-help] upgrading questions...


On Tue, 2002-01-08 at 09:38, Chris McDaniel wrote:
> I'd like to upgrade my OpenInteract installation (1.21, SPOPS 1.41).  I am
> nervous as I'm working in a production environment and the company would
be
> less than pleased if the site went down for a day because I tried to
upgrade
> and broke it.  So, my questions are, if I upgrade what will break?  How
can
> I minimize breakage?

Hmm hah, good question. To start off with, check out the 'Changes' files
in both OI and SPOPS to get a sense of what's different.

With SPOPS, I don't think there are any backward-incompatible changes,
so you should be ok with this part. An easy way to test it is to install
the newest version to a local lib directory, 'use lib' the dir, create
an $R object using OI::Setup->setup_static_environment() and do some
data fetching, relationship fetching, etc.

With OI, there are quite a few changes. It might be useful to do the
following:

 - Install the latest version to a local lib directory
 - Create a new base installation.
 - Create a new website from that base installation
 - Edit the config file (I recommend the INI version, but YMMV) with
your existing values, including the existing database
 - In conf/httpd_modperl.conf, put a 'use lib' statement for your local
lib directory
 - Install any custom packages you have created to the new site
 - Try and startup OI

Off the top of my head, you may have problems with static pages since
that's done through a new package (base_page) and database setup. You
can continue to use the 'static_page' package if you like though, with
just a couple of server configuration modifications. And the 'base_page'
package comes with a migration script.

Once you've plowed through any problems and the new server looks just
like the old one, you can shutdown the old server, install OI and SPOPS
to the Perl installation, remove the 'use lib' from
conf/httpd_modperl.conf, modify your root Apache setup as necessary
(e.g., change the 'Include' statement) and fire it back up.

I think the key is to first setup a parallel server and modify it so the
rollover time is minimal. I did this fairly recently, from an older
version of OI (1.1) and it worked very well. It wasn't a flip-the-switch
rollover because a number of items had changed, but it worked fine with
minimal impact.

Chris

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

Re: [Openinteract-help] additional OI websites on a single server - DB question

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

On Fri, 2002-11-08 at 11:04, Chris McDaniel wrote:
> I was wondering if it is possible to have a second OI website use the same
> database as the first. Is this possible?

Yes, although there is one catch with security. If you have the security
information (table: sys_security) for 2+ separate websites in separate
databases you will have problems unless you create some sort of
synchronization mechanism. (I think this is doable, but a pain, if
you're interested.)

But if you have security centralized in the one database you shouldn't
have any problems.

You can also use multiple databases in a single server. To do this you
need to define multiple datasources and then in the object configuration
specify the datasource you want to use. It's easiest to do this in the
global override configuration:

$WEBSITE_DIR/conf/override_spops.ini:

[user.datasource]
action = add
value  = UserDatasource

$WEBSITE_DIR/conf/server.ini:

[db_info UserDatasource]
db_owner      =
username      = user
password      = password
dsn           = dbname=userdb
db_name       =
driver_name   = Pg
sql_install   =
long_read_len = 65536
long_trunc_ok = 0

Hope this helps,

Chris

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

[Openinteract-help] additional OI websites on a single server - DB question

[Chris M. <Chr...@te...>]

Hello,

I was wondering if it is possible to have a second OI website use the same
database as the first. Is this possible?

Thanks,

Chris McDaniel

[Openinteract-help] Re: news-1.48 bug?

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

On Thu, 2002-11-07 at 08:00, Chris Winters wrote:
> Ah, it's not checking whether you're using the cache or not. I'll issue
> shortly  OI 1.53 which has this (extremely simple) fix. In the meantime,
> you can add the following line to
> OpenInteract::Handler::GenericDispatcher:
> 
> line 172:
>     return undef unless ( $R->cache );

I sent that email a little too hastily. There are actually two other
small changes you have to make. You can d/l OI 1.53 from Sourceforge
right now, and it's winging around CPAN right now as well.

Thanks,

Chris

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

[Openinteract-help] Re: news-1.48 bug?

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

On Thu, 2002-11-07 at 06:21, Ra=FAl Romero wrote:
> I Installed the news-1.48 package under OpenInteract Version 1.52.  When =
I=20
> logged in with the superuser account, it run good. But, when I'm not logg=
ed=20
> in the system say:
>=20
> Can't call method "get" on an undefined value at=20
> /usr/local/lib/perl5/site_perl/5.8.0/OpenInteract/Handler/GenericDispatch=
er.pm=20
> line 175.=20
>=20
> When i logged with register user account.....occurs the same.

Ah, it's not checking whether you're using the cache or not. I'll issue
shortly  OI 1.53 which has this (extremely simple) fix. In the meantime,
you can add the following line to
OpenInteract::Handler::GenericDispatcher:

line 172:
    return undef unless ( $R->cache );

Thanks for the report!

Chris

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

Re: [Openinteract-help] Trouble with Database

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

On Wed, 2002-11-06 at 06:48, Neemann, Thomas, D22K-MSN wrote:
> Hello there.
> 
> I've got a strange problem with the latest OpenInteract version: 
> 
> The version worked fine for many weeks, but now if SPOPS creates a new
> record in the Database, it creates 3 entries ! The right one an two empty
> records.
> 
> I have nothing changed at the root system.

The only thing I can think of is in the FAQ (entry below)

Chris

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

QQQQQQQQQQ

I edited a (news|classified|random) item and OpenInteract saved my
changes but created a new (and empty) record at the same time.

AAAAAAAAAA

You probably refer to an image in the resulting display page that is
in the same directory. Therefore OI tries to load the page twice --
once for your actual submission, and then once for the image (since
it's in the same directory).

For example, we'll use the 'news' package. When you edit a news item
you'll go to the URL '/News/edit/' with your edits POSTed. Now, say
you edited your base template like so:

Template: base_theme::base_main
========================================
<html>
<head><title>[% page.title %]</title></head>
<body>
<img src="my_logo.jpg">
[% page.content %]
</body>
</html>
========================================

(Obviously this is a very slimmed-down template!)

What will happen when the page gets loaded is the browser will be at
the URL '/News/edit/' and see the 'src="my_logo.jpg"'. Because this is
a relative URL, it will then ask the webserver for the image at
'/News/edit/my_logo.jpg'. This request is mapped to the same OI
handler as before, and because there aren't any restrictions on
content (e.g., we don't test to see if there's a news item or title
before saving) OI happily creates an empty news item.

Solution: Use concrete URLs for your images, particularly using
something at the top-level 'src="/images/blah.jpg"' since that's
easier to capture by the static front-end proxy server.

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

[Openinteract-help] Trouble with Database

[Neemann, T. D22K-M. <Tho...@be...>]

Hello there.

I've got a strange problem with the latest OpenInteract version: 

The version worked fine for many weeks, but now if SPOPS creates a new
record in the Database, it creates 3 entries ! The right one an two empty
records.

I have nothing changed at the root system.

How can I solve the problem ?

Best regards
Thomas Neemann

[Openinteract-help] internationalization, multiple domains

[Chris M. <Chr...@te...>]

Hello,

I was curious to know if anyone had any experience with either enabling an
OI instance in multiple languages or with having multiple domains set up
such that backend elements (like users DB, etc.) are shared but surface
elements (look and feel) are different.

Thanks!

Chris McDaniel

Re: [Openinteract-help] update on my woes

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

On Sat, 2002-10-12 at 02:24, Victor Piterbarg wrote:
> Well, I just wiped that box clean, and reinstalled fresh. Everything works
> fine now. Although now I am a bit weary of upgrading on the production box.

This problem is very strange. I looked at the changelog from 1.36 ..
1.52 and nothing jumped out at me. Some other ideas:

Did you upgrade any of the following?
  - Storable
  - Apache::Session
  - MySQL
  - DBD::mysql

Finally, you might try to run the script at:

http://openinteract.sourceforge.net/cgi-bin/wiki.pl?OpenInteractSessionTest

Good luck,

Chris

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

[Openinteract-help] update on my woes

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

Well, I just wiped that box clean, and reinstalled fresh. Everything works
fine now. Although now I am a bit weary of upgrading on the production box.

-Victor

[Openinteract-help] get_lock, etc.

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

I also looked through the query logs for MySQL. And it looks like a second
thread executes GET_LOCK before the first one releases it (3 and 6 are
process ID's):

021010 21:44:38       6 Query       SELECT
GET_LOCK('Apache-Session-d4af5bc838bb5e843eebed1542c21e3d', 3600)

021010 21:44:41       3 Query       SELECT
GET_LOCK('Apache-Session-d4af5bc838bb5e843eebed1542c21e3d', 3600)

-Victor

[Openinteract-help] upgrading 1.36->1.52

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

Hi,

I upgraded my installation from 1.36 to 1.52, however now something is not
working right with sessions. Now, clicking on any link causes the browser to
perpatually wait for the server. In the mean time, here's what's happening
in the log:

---------------
OpenInteract::find_action_handler (232) >> Found OpenInteract::UI::Main //
handler for conductor
Found item: Apache::DBI::db
(eval) (257) >> Trying to use cookie class:  OpenInteract::Cookies::Apache
OpenInteract::Cookies::Apache::parse (21) >> Getting cookie session to
d4af5bc838bb5e843eebed1542c21e3d
(eval) (259) >> Cookies in: $VAR1 = {
          'session' => 'd4af5bc838bb5e843eebed1542c21e3d'
        };

(eval) (260) >> Trying to use session class:  OpenInteract::Session::DBI
OpenInteract::Session::DBI::_create_session (25) >> Using MySQL session
store, with LockHandle parameter
OpenInteract::Session::DBI::_create_session (28) >> Trying to fetch session
[d4af5bc838bb5e843eebed1542c21e3d]
-------------

And it just sits there, doing nothing. The only query running inside MySQL
is SELECT GET_LOCK('Apache-Session-d4af5bc838bb5e843eebed1542c21e3d', 3600).

Any ideas as to what might be happening? I made all the required changes in
my config file, as far as I can tell there really wasn't anything mandatory
with session management. Any help would be greatly appreciated. Thanks.

-Victor

Re: [Openinteract-help] Changing base_main template dynamically from a handler...

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

On Tue, 2002-09-24 at 19:54, Arva, Adrian wrote:
> I have a handler that I would also like to use a different master template
> than base_main.
> Is it this possible to dynamically change it?

You bet. It's somewhat esoteric, but you can set:

 # if the main template is in a package
 $R->{page}->{_template_name_} = 'pkg::template';

 # if thie main template is not in a package (like 'base_main')
 $R->{page}->{_template_name_} = 'template';

If this is not set, OI checks $R->{page}->{_simple_} -- if that is set,
it uses the value of the theme key 'simple_template', otherwise (most of
the time) it uses the theme key 'main_template'.

Chris

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

[Openinteract-help] Changing base_main template dynamically from a handler...

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

Hi,

I have a handler that I would also like to use a different master template
than base_main.
Is it this possible to dynamically change it?

Thank you,
Adrian