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

[Openinteract-help] server load - help!

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

Hello,

I have a particular action within a package I wrote that tends to drive
server load up (quite a bit) every time it is run.  Just wondering about the
best way to determine what exactly is going on.  I have DEBUG => 5 in all my
queries, but I don't see anything out of the ordinary.

Note that I am using iterators wherever possible and also that the ping_log
table referenced below has > 70000 records.

This is the log of a single run of the procedure - 

trying to setup cookies/session
SPOPS::SQLInterface::db_select (86) >> No SQL passed in to execute directly;
building.
SPOPS::SQLInterface::db_select (107) >> SQL for select:
           SELECT  monitored_hosts.monitored_host_id,
monitored_hosts.customer_id, monitored_ho
sts.host, monitored_hosts.ping_type, monitored_hosts.is_alive,
monitored_hosts.email, monitored
_hosts.pager_number, monitored_hosts.paging_configuration_id
             FROM monitored_hosts
            WHERE customer_id = ?

            ORDER BY monitored_host_id

SPOPS::SQLInterface::db_select (125) >> Values bound:  -1
SPOPS::SQLInterface::db_select (141) >> Returning statement handle (after
prepare/execute)
SPOPS::SQLInterface::db_select (86) >> No SQL passed in to execute directly;
building.
SPOPS::SQLInterface::db_select (107) >> SQL for select:
           SELECT  ping_log_id
             FROM ping_log
            WHERE monitored_host_id = ?



SPOPS::SQLInterface::db_select (125) >> Values bound:  46
SPOPS::SQLInterface::db_select (141) >> Returning statement handle (after
prepare/execute)
SPOPS::SQLInterface::db_select (86) >> No SQL passed in to execute directly;
building.
SPOPS::SQLInterface::db_select (107) >> SQL for select:
           SELECT  ping_log.ping_log_id, ping_log.monitored_host_id,
ping_log.was_alive, ping_l
og.ping_time, ping_log.additional_info
             FROM ping_log
            WHERE monitored_host_id = ?

            ORDER BY ping_time DESC

SPOPS::SQLInterface::db_select (125) >> Values bound:  46
SPOPS::SQLInterface::db_select (141) >> Returning statement handle (after
prepare/execute)
trying to setup cookies/session
Chris 

AW: [Openinteract-help] Install: "Cannot create object"

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

Hi Greg,

did you install the base yet? Before you can run create_website you =
need to
run oi_manage install --base_dir=3D/whereever while beeing in the =
source
directory.=20

Maybe this helped.

Andreas

-----Urspr=FCngliche Nachricht-----
Von: greg strockbine [mailto:gs...@de...]
Gesendet am: Mittwoch, 20. Februar 2002 15:50
An: ope...@li...
Betreff: [Openinteract-help] Install: "Cannot create object"

while doing a new website install as root,
using OpenInteract-1.37 on Red Hat 7.0
I got this error:
----
server1:OpenInteract-1.37 [148] oi_manage
--base_dir=3D/usr/local/src/OpenInteract-1.37 \
> --website_name=3DLinuxCom \
> --website_dir=3D/home/landy/linux-commerce.com create_website
Running create_website...
=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
Cannot create object without existing file or 'new' permission=20
[/usr/local/src/OpenInter\act-1.37/conf/package_repository.perl] =
[write]
----

But I went ahead any way, following the instructions in
INSTALL.website.  I modified config files, passed the sql
test.  And then bombed again when doing an install_sql:
---
server1:OpenInteract-1.37 [154] oi_manage  \
--website_dir=3D/home/landy/linux-commerce.com \
> --package=3DINITIAL 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
=20
Cannot create object without existing file or 'new' permission=20
[/home/landy/linux-comm\erce.com/conf/package_repository.perl] [write]
Issuing rollback() for database handle bei\ng DESTROY'd without =
explicit=20
disconnect(), <CONF> line 22.
---

Any ideas?

=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=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D
Hi, here I am brand new to Open Interact.
My first time with any content manager.
I have a client that needs "content managing"
so I looked around, 122 hits on freshmeat.net.
I looked at them all.  But I followed the link from
the perl.apache.org site for OpenInteract.

- greg strockbine

_______________________________________________
openinteract-help mailing list
ope...@li...
https://lists.sourceforge.net/lists/listinfo/openinteract-help

Re: [Openinteract-help] Install: "Cannot create object"

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

On Wed, 2002-02-20 at 09:49, greg strockbine wrote:
> while doing a new website install as root,
> using OpenInteract-1.37 on Red Hat 7.0
> I got this error:
> ----
> server1:OpenInteract-1.37 [148] oi_manage --base_dir=/usr/local/src/OpenInteract-1.37 \
> > --website_name=LinuxCom \
> > --website_dir=/home/landy/linux-commerce.com create_website
> Running create_website...
> =========================
> Cannot create object without existing file or 'new' permission 
> [/usr/local/src/OpenInter\act-1.37/conf/package_repository.perl] [write]
> ----

Strange. Do either of the following files exist?

  /usr/local/src/OpenInter\act-1.37/conf/package_repository.perl
  /home/landy/linux-commerce.com/conf/package_repository.perl

Chris

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

[Openinteract-help] Install: "Cannot create object"

[greg s. <gs...@de...>]

while doing a new website install as root,
using OpenInteract-1.37 on Red Hat 7.0
I got this error:
----
server1:OpenInteract-1.37 [148] oi_manage --base_dir=/usr/local/src/OpenInteract-1.37 \
> --website_name=LinuxCom \
> --website_dir=/home/landy/linux-commerce.com create_website
Running create_website...
=========================
Cannot create object without existing file or 'new' permission 
[/usr/local/src/OpenInter\act-1.37/conf/package_repository.perl] [write]
----

But I went ahead any way, following the instructions in
INSTALL.website.  I modified config files, passed the sql
test.  And then bombed again when doing an install_sql:
---
server1:OpenInteract-1.37 [154] oi_manage  \
--website_dir=/home/landy/linux-commerce.com \
> --package=INITIAL install_sql
Running install_sql...
=========================
 
Cannot create object without existing file or 'new' permission 
[/home/landy/linux-comm\erce.com/conf/package_repository.perl] [write]
Issuing rollback() for database handle bei\ng DESTROY'd without explicit 
disconnect(), <CONF> line 22.
---

Any ideas?

=================================================
Hi, here I am brand new to Open Interact.
My first time with any content manager.
I have a client that needs "content managing"
so I looked around, 122 hits on freshmeat.net.
I looked at them all.  But I followed the link from
the perl.apache.org site for OpenInteract.

- greg strockbine

[Openinteract-help] Re: openinteract-help -- confirmation of subscription -- request 861630

[greg s. <gs...@de...>]

On Sun, 17 Feb 2002 21:18:44 -0800
ope...@li... wrote:

> openinteract-help -- confirmation of subscription -- request 861630
> 
> We have received a request from 216.101.220.23 for subscription of
> your email address, <gs...@de...>, to the
> ope...@li... mailing list.  To confirm the
> request, please send a message to
> ope...@li..., and either:
> 
> - maintain the subject line as is (the reply's additional "Re:" is
> ok),
> 
> - or include the following line - and only the following line - in the
> message body: 
> 
> confirm 861630
> 
> (Simply sending a 'reply' to this message should work from most email
> interfaces, since that usually leaves the subject line in the right
> form.)
> 
> If you do not wish to subscribe to this list, please simply disregard
> this message.  Send questions to
> ope...@li....

Re: [Openinteract-help] ini file resolution

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

On Sat, 2002-02-16 at 07:52, John Sequeira wrote:
> This wasn't a permission problem.  In the throws of installing oi on a
> server I don't have root on,  I went through the create_website process a
> couple of times and used a slightly different website name.  That's why it
> couldn't find the theme - the object_keys class field was incorrect.
> 
> On the plus side,  I'm learning alot about the toolkit.  :-)

I'd probably be shocked by how little I know if I eliminated everything
I learned due to configuration or other mistakes :-)

Chris

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

Re: [Openinteract-help] caching turn-off-able?

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

On Sat, 2002-02-16 at 08:11, John Sequeira wrote:
> I'm pretty much at the last step in the docs.  I know I need to change
> permissions to set the web server as owner of the cache/html/uploads
> directories.  At the moment,  I don't have permission to do it.
> 
> Is there any way to disable template caching to get the system running?  I
> tried setting [template_info]cache_size = 0,  but I get the error below
> whether it has a value or not?

TT has both caching (in-memory) and compiling (to-disk). (This is
confusing when mixed with OI terminology like 'cache_tt'...) You want to
turn off the latter, but the former is still useful.

Currently you cannot do this. But I just committed a change to
OpenInteract/Template/Process.pm which turns off compiling if the
'dir->cache_tt' configuration setting is undefined.

I don't know if you have permission to change this file. If not, you
might be able to put it in a local directory that gets @INC'd before the
main system directory.

Chris

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

[Openinteract-help] caching turn-off-able?

[John S. <js...@me...>]

I'm pretty much at the last step in the docs.  I know I need to change
permissions to set the web server as owner of the cache/html/uploads
directories.  At the moment,  I don't have permission to do it.

Is there any way to disable template caching to get the system running?  I
tried setting [template_info]cache_size = 0,  but I get the error below
whether it has a value or not?


"OpenInteract::UI::Main::handler (41) >> Action died. Here is what it left:
Cannot process template!file error - cache failed to write anon_1.ttc:
Permiss
ion denied at
/usr/local/lib/perl5/site_perl/5.005/OpenInteract/Template/Process.pm line
165."

Thanks,

JS

[Openinteract-help] ini file resolution

[John S. <js...@me...>]

Chris,

This wasn't a permission problem.  In the throws of installing oi on a
server I don't have root on,  I went through the create_website process a
couple of times and used a slightly different website name.  That's why it
couldn't find the theme - the object_keys class field was incorrect.

On the plus side,  I'm learning alot about the toolkit.  :-)

JS


> -----Original Message-----
> From: Chris Winters [mailto:ch...@cw...]
> Sent: Friday, February 15, 2002 8:23 AM
> To: jo...@po...
> Cc: ope...@li...
> Subject: Re: [Openinteract-help] RE: openinteract-help digest, Vol 1 #98
> - 4 msgs
>
>
> * John Sequeira (js...@me...) [020215 07:43]:
> > Chris,
> >
> > I'm setting up a new website.  I've changed the driver to
> postgres and got
> > the initial package install to work.  The database is populated with the
> > system tables,  which have data,  and test_db works fine. "perl -wc
> > server.perl" also works okay.
> >
> > I'm getting a few errors.  When Apache starts up,  it complains "Use of
> > uninitialized value in ....Config/Ini.pm".  This looks like it could be
> > basic "warnings on" message for a line in the config file
> without a value,
> > but I wanted to make sure.
>
> I think this is the problem -- are you using server.ini or server.perl
> to hold your config? You say above that you syntax-checked server.perl
> but OI thinks you're using server.ini from these error messages.
>
> If you want to use server.perl, change the relevant lines in
> conf/base.conf:
>
>   config_type      perl
>   config_class     OpenInteract::Config::PerlFile
>   config_dir       conf
>   config_file      server.perl
>
> Or copy over the relevant info to server.ini. Then delete the
> server.blah file that you're not using to avoid further confusion :-)
>
> Chris
>

Re: [Openinteract-help] Ini file issue

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

On Fri, 2002-02-15 at 08:42, John Sequeira wrote:
> Oops - my intent was to use server.ini.  I didn't realize the files were
> redundant.  I thought the latter was generated to validate the former,  but
> obviously I didn't think about it too hard.
> 
> Anyway,  conf/base.conf points to the ini file that I've correctly (AFAIK)
> set up.  But I'm still getting the "Fundamental part of OpenInteract
> (themes) not functioning" error.
> 
> Is there a way to validate or troubleshoot the ini file or otherwise figure
> out why the apache startup is carping?  Or do I want to look somewhere else?

There's no validation for the ini file. The 'Fundamental part of
OpenInteract...' error in pre 1.37 versions used to point to a database
misconfiguration error. In 1.37 I changed the Apache handler
(OpenInteract.pm) to first check whether it could connect to the
database. If not, it should report that error rather than the themes
error.

One thing to check: see whether removing 'SPOPS::Secure' from the
'theme' key in base_theme-x.xx/conf/spops.perl (then restarting the
server) makes things work. If so, then there's something fishy about
fetching information from the security table for the theme. 

Chris

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

[Openinteract-help] Ini file issue

[John S. <jo...@am...>]

Chris,

Oops - my intent was to use server.ini.  I didn't realize the files were
redundant.  I thought the latter was generated to validate the former,  but
obviously I didn't think about it too hard.

Anyway,  conf/base.conf points to the ini file that I've correctly (AFAIK)
set up.  But I'm still getting the "Fundamental part of OpenInteract
(themes) not functioning" error.

Is there a way to validate or troubleshoot the ini file or otherwise figure
out why the apache startup is carping?  Or do I want to look somewhere else?

JS



> -----Original Message-----
> From: Chris Winters [mailto:ch...@cw...]
> Sent: Friday, February 15, 2002 8:23 AM
> To: jo...@po...
> Cc: ope...@li...
> Subject: Re: [Openinteract-help] RE: openinteract-help digest, Vol 1 #98
> - 4 msgs
>
>
> * John Sequeira (js...@me...) [020215 07:43]:
> > Chris,
> >
> > I'm setting up a new website.  I've changed the driver to
> postgres and got
> > the initial package install to work.  The database is populated with the
> > system tables,  which have data,  and test_db works fine. "perl -wc
> > server.perl" also works okay.
> >
> > I'm getting a few errors.  When Apache starts up,  it complains "Use of
> > uninitialized value in ....Config/Ini.pm".  This looks like it could be
> > basic "warnings on" message for a line in the config file
> without a value,
> > but I wanted to make sure.
>
> I think this is the problem -- are you using server.ini or server.perl
> to hold your config? You say above that you syntax-checked server.perl
> but OI thinks you're using server.ini from these error messages.
>
> If you want to use server.perl, change the relevant lines in
> conf/base.conf:
>
>   config_type      perl
>   config_class     OpenInteract::Config::PerlFile
>   config_dir       conf
>   config_file      server.perl
>
> Or copy over the relevant info to server.ini. Then delete the
> server.blah file that you're not using to avoid further confusion :-)
>
> Chris
>
>

[Openinteract-help] RE: openinteract-help digest, Vol 1 #98 - 4 msgs

[John S. <js...@me...>]

Chris,

I'm setting up a new website.  I've changed the driver to postgres and got
the initial package install to work.  The database is populated with the
system tables,  which have data,  and test_db works fine. "perl -wc
server.perl" also works okay.

I'm getting a few errors.  When Apache starts up,  it complains "Use of
uninitialized value in ....Config/Ini.pm".  This looks like it could be
basic "warnings on" message for a line in the config file without a value,
but I wanted to make sure.

"Use of uninitialized value at
/usr/local/lib/perl5/site_perl/5.005/OpenInteract/Config/Ini.pm line 130,
<CONF> chunk 188.
Use of uninitialized value at
/usr/local/lib/perl5/site_perl/5.005/OpenInteract/Config/Ini.pm line 134,
<CONF> chunk 188.
Use of uninitialized value at
/usr/local/lib/perl5/site_perl/5.005/OpenInteract/Config/Ini.pm line 134,
<CONF> chunk 188."

Then when I try to load the home page:
"Fundamental part of OpenInteract (themes) not functioning; please contact
the system administrator  ..."


Here's something fishy in the error log (can't fetch ?)
ZipCelebrity::Security::fetch_by_object (75) >> All security:  $VAR1 = {
          'u' => undef,
          'g' => {},
          'w' => undef
        };

ZipCelebrity::ErrorObject::initialize (50) >> Initializing new error:  $VAR1
= {
          'line' => 321,
          'filename' =>
'/usr/local/lib/perl5/site_perl/5.005/OpenInteract.pm',
          'code' => 404,
          'package' => 'OpenInteract',
          'action' => undef
        };

I've set the debug level to 5 in the server.ini file.

Any ideas?

Re: [Openinteract-help] Document control system?

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

On Tue, 2002-02-12 at 18:13, Bryce Harrington wrote:
> Thanks for the quick reply.
> 
> Is there a demo available of the simple file index and file uploader?
> I didn't notice it on the openinteract.org site.

Both the websites are fairly out of date -- I think they're running a
year-old version of OI :-)

Getting a demo up would be great. I seem to remember that one of the PHP
content management systems (Midgard?) had a site up where you could play
around with the system but every night all data got wiped and replaced
with the default. That would be pretty nifty....

Chris

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

[Openinteract-help] Re: Questions about OpenInteract

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

On Tue, 2002-02-12 at 20:08, Thomas A. Lowery wrote:
> Chris,
> 	I'm looking at OpenInteract as an application framework to replace
> 	a currently running cold fusion server.
> 
> 	I've the "basic" installed completed, however now I'm not sure
> 	where to go with the product.  The documentation is very confusing
> 	on starting a new application.
> 
> 	Is OpenInteract about to interface with a database without
> 	predefining all the tables and structures?  Learn what the
> 	database contains upon connection?
> 
> 
> 	Where do I start defining a simple interface to a person table?
> 
> 	person (
> 		  person_pk	number not null
> 		, first_name varchar(36)
> 		, last_name  varchar(36)
> 	)
> 
> 
> 	Out of all the "frameworks" I've reviewed (Perl based, as I enjoy
> 	developing in Perl), yours works (the demo site), now I need to
> 	know how to start an application using it!

Hi Tom,

(cc'd to openinteract-help)

Clearly, this is an area where docs would help. So here's a quickstart
guide to developing an application. Note that a good example for the
handler and templates is the 'classified' package, which ships with OI.

1) cd to your dev directory

2) $ export OPENINTERACT=/path/to/base_install
   $ oi_manage create_skeleton --package=myapp

3) edit conf/spops.perl:
     - set 'base_table' to your table
     - set 'id_field' to your PK field
     - add 'field_discover => "yes"' so you don't have to 
       list the individual fields
     - set your appropriate DB driver in the 'isa' (e.g., change 
       'SPOPS::DBI::MySQL' to 'SPOPS::DBI::Pg' for Postgres)

4) edit OpenInteract/Handler/Myapp.pm to include the sample code from
OpenInteract::CommonHandler. (I don't have a template for this yet,
sorry.) Decide if you want to have search/display/edit/remove
capabilities and modify the various items as necessary.

5) create templates in template/ for the search_form, search results and
record display. (Borrow from 'classified' package where appropriate)

6) edit conf/action.perl to associate your handler with a URL

7) edit doc/myapp.pod with information about your package

8) edit Changes with the changes you've made

9) edit package.conf with contact information and a package description

10) check the package: 
    $ oi_manage check_package

11) if not ok, fix; if ok:
    $ oi_manage export_package
    $ oi_manage install_package --package_file=myapp-0.01.tar.gz
    $ export OIWEBSITE=/path/to/mysite
    $ oi_manage apply_package --package=myapp

12) restart your web server

The next version of OI will do much of 3-5 automatically, creating a 
handler based on CommonHandler; creating templates for searching,
displaying search results, and detail/editing screens, and modifying
your SPOPS object definition. But that's a few months off.

Thanks,

Chris

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

Re: [Openinteract-help] Document control system?

[Bryce H. <br...@ne...>]

Thanks for the quick reply.

Is there a demo available of the simple file index and file uploader?
I didn't notice it on the openinteract.org site.

Bryce

On 12 Feb 2002, Chris Winters wrote:
> On Tue, 2002-02-12 at 14:50, Bryce Harrington wrote:
> > Hi Chris,
> >
> > On the openinteract.com site it lists a "Document Manager" that sounds
> > exactly what I need, yet I can find no further mention of it.  Is this
> > actually available, or is it more of a wishlist item?  I'd love to try
> > it out if it exists.  :-)
>
> I think it was a wishlist item. The .com website was done quite some
> time ago and not by me :-) Both the websites need updating, actually.
>
> That said, I think what we had in mind for the document manager is much
> like what the current version (1.37) has in place with the simple file
> index and file upload scheme.
>
> Chris
>
>

Re: [Openinteract-help] Document control system?

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

On Tue, 2002-02-12 at 14:50, Bryce Harrington wrote:
> Hi Chris,
> 
> On the openinteract.com site it lists a "Document Manager" that sounds
> exactly what I need, yet I can find no further mention of it.  Is this
> actually available, or is it more of a wishlist item?  I'd love to try
> it out if it exists.  :-)

I think it was a wishlist item. The .com website was done quite some
time ago and not by me :-) Both the websites need updating, actually.

That said, I think what we had in mind for the document manager is much
like what the current version (1.37) has in place with the simple file
index and file upload scheme.

Chris

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

[Openinteract-help] Document control system?

[Bryce H. <br...@ne...>]

Hi Chris,

On the openinteract.com site it lists a "Document Manager" that sounds
exactly what I need, yet I can find no further mention of it.  Is this
actually available, or is it more of a wishlist item?  I'd love to try
it out if it exists.  :-)

Bryce

Re: AW: [Openinteract-help] CommonHandler Master-Detail Solution ?

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

On Tue, 2002-02-12 at 07:53, Tho...@be... wrote:
> Yes I read about it.
> 
> I tried like this :
> 
> In my handler called 'Nips.pm':
> 
> sub MY_SEARCH_FIELDS           { return qw( ipnr dnsname comment
> nips_media.ipnr nips_media.rid) }
> sub MY_SEARCH_TABLE_LINKS      {      return ( nips_media => [ 'ipnr' ] ) }

This should either be a scalar or a two/three-item array reference. So
you might try:

sub MY_SEARCH_TABLE_LINKS {
    return { nips_media => [ 'ipnr', 'ipnr' ] ) };
}

Assuming that the two tables have the field 'ipnr' in common.

> in my listing template:
> 
>   <td align="center"><font size="-1">[% nips_media.rid %]&nbsp;</font></td>
>  
>   <td align="center"><font size="-1">[% nips.rid %]&nbsp;</font></td>
>   <td align="center"><font size="-1">[% nips_media.ipnr %]&nbsp;</font></td>
> 
> but none of the fields are displayed :-(

The actions we're discussing here are only for searching, not display.
For display you'll have to use the normal SPOPS relationship stuff. For
example, if we had 'person' and 'address' objects, we might configure:

sub MY_SEARCH_FIELDS { return qw( first_name last_name address.city ) }

So we can search for people by their first and last names, plus the city
of one of their addresses. 

For linking, we'd setup:

sub MY_SEARCH_TABLE_LINKS { 
    return { address => [ 'person_id', 'person_id' ] };
}

But when we ran the search, we'd only get Person objects back. If we
wanted to find the primary address of one of these persons, we'd do
something like:

[% WHILE ( person = iterator.get_next ) %]
  [% address = person.primary_address -%]
  ...
[% END %]

Where 'primary_address()' is a method we've defined in the Person
object.

Hope that makes sense

Chris

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

AW: [Openinteract-help] CommonHandler Master-Detail Solution ?

[<Tho...@be...>]

Yes I read about it.

I tried like this :

In my handler called 'Nips.pm':

sub MY_SEARCH_FIELDS           { return qw( ipnr dnsname comment
nips_media.ipnr nips_media.rid) }
sub MY_SEARCH_TABLE_LINKS      {      return ( nips_media =3D> [ 'ipnr' =
] ) }

in my listing template:

  <td align=3D"center"><font size=3D"-1">[% nips_media.rid =
%]&nbsp;</font></td>
=20
  <td align=3D"center"><font size=3D"-1">[% nips.rid =
%]&nbsp;</font></td>
  <td align=3D"center"><font size=3D"-1">[% nips_media.ipnr =
%]&nbsp;</font></td>

but none of the fields are displayed :-(

-----Urspr=FCngliche Nachricht-----
Von: Chris Winters [mailto:ch...@cw...]
Gesendet: Dienstag, 12. Februar 2002 14:06
An: Neemann, Thomas, D22K-MSN
Cc: ope...@li...
Betreff: Re: [Openinteract-help] CommonHandler Master-Detail Solution ?


On Tue, 2002-02-12 at 07:21, Tho...@be... wrote:
> I've some questions, how to realise a master-detail solution with the
> CommonHandler.
>=20
> I've got a normal CommenHandler application, with search, edit and so =
on
...
>=20
> Now I want to Link the table of this apllikation with another table.
>=20
> For instance: Searching for an IP-number , CommonHandler looks for =
this IP
> in the main table, ok ... now CommonHandler should look for further
> information matching to this IP number in the other table and display =
all
> information in the default listing view.
>=20
> How can I realise this the best way ?

Using the MY_SEARCH_TABLE_LINKS option, CommonHandler will create JOIN
statements for you. As with any automated SQL-generation the setup is a
little tricky. See the POD for both MY_SEARCH_TABLE_LINKS and
MY_SEARCH_FIELDS for examples.

Chris

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

Re: [Openinteract-help] CommonHandler Master-Detail Solution ?

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

On Tue, 2002-02-12 at 07:21, Tho...@be... wrote:
> I've some questions, how to realise a master-detail solution with the
> CommonHandler.
> 
> I've got a normal CommenHandler application, with search, edit and so on ...
> 
> Now I want to Link the table of this apllikation with another table.
> 
> For instance: Searching for an IP-number , CommonHandler looks for this IP
> in the main table, ok ... now CommonHandler should look for further
> information matching to this IP number in the other table and display all
> information in the default listing view.
> 
> How can I realise this the best way ?

Using the MY_SEARCH_TABLE_LINKS option, CommonHandler will create JOIN
statements for you. As with any automated SQL-generation the setup is a
little tricky. See the POD for both MY_SEARCH_TABLE_LINKS and
MY_SEARCH_FIELDS for examples.

Chris

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

[Openinteract-help] CommonHandler Master-Detail Solution ?

[<Tho...@be...>]

Hi there.

I've some questions, how to realise a master-detail solution with the
CommonHandler.

I've got a normal CommenHandler application, with search, edit and so on ...

Now I want to Link the table of this apllikation with another table.

For instance: Searching for an IP-number , CommonHandler looks for this IP
in the main table, ok ... now CommonHandler should look for further
information matching to this IP number in the other table and display all
information in the default listing view.

How can I realise this the best way ?

Greets
Thomas

Re: [Openinteract-help] postgres test_db error

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

On Wed, 2002-02-06 at 08:00, John Sequeira wrote:
> I developed an OI site on mysql and am now putting it into production using
> PostgresSQL (not really by choice).
> 
> I'm having trouble with test_db.   The output is something like:
> "--Basic connect: ok
> -- Use database: ok
> -- Create table: failed -- Can't call method "do" on unblessed reference
> /usr/bin/oi_manage line 2590
> 
> (NOTE: Error trying to disconnect...)"
> 
> I looked at the source,  but was not enlightened.  I also confirmed that the
> user I was connecting as could 1) connect to the server and 2) create/drop
> tables.
> 
> I saw some earlier list comments about Pg problems,  but I don't think I've
> hit them yet (and I'm on the latest versions).

What does the configuration for this datasource look like?

Chris

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

[Openinteract-help] postgres test_db error

[John S. <js...@me...>]

I developed an OI site on mysql and am now putting it into production using
PostgresSQL (not really by choice).

I'm having trouble with test_db.   The output is something like:
"--Basic connect: ok
-- Use database: ok
-- Create table: failed -- Can't call method "do" on unblessed reference
/usr/bin/oi_manage line 2590

(NOTE: Error trying to disconnect...)"

I looked at the source,  but was not enlightened.  I also confirmed that the
user I was connecting as could 1) connect to the server and 2) create/drop
tables.

I saw some earlier list comments about Pg problems,  but I don't think I've
hit them yet (and I'm on the latest versions).

Any idea what's wrong?

TIA,

JS

RE: [Openinteract-help] per-user rights on static pages

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

On Wed, 2002-01-30 at 16:17, Chris McDaniel wrote:
> Well, that sounds pretty cool too, but actually I wasn't clear on what I
> want to do. I just want to allow a certain user to edit the contents of a
> static page using your html editing form (like the admins can) without
> granting sitewide admin priveledges.  I am still using 1.21, so if this is
> something you've recently added, let me know.

Oh, sure, this shouldn't be a problem. (I have a proclivity to
complicate things sometimes :-)

First: I'd create a group explicitly for this purpose and assign the
user to the group. In very early versions of OI I had per-user security
setting but it made the listing of valid scopes in the security editor
extremely long for sites having a few users. So I took it out and try to
point folks to groups instead.

Second: Allow that group to have write access to the BasicPage handler
(or whatever its called). Normal security editing stuff.

Third: Set the security for the root directory so that only the 'site
admin' group has WRITE access, and then set the security for the
directory you want the user to be able to edit in to allow the created
group to have WRITE access.

To do this in version 1.21 you should be able to go to:

 http://.../Hierarchy/

type in the class to protect (YourSite::BasicPage, IIRC) and the
directory you want to protect as the object ID.

This is easier in later releases (>= 1.30) because the security editing
functions were integrated, but the above should work for you. Hope it
makes sense.

Chris

cc'd to -help for posterity

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

Re: [Openinteract-help] per-user rights on static pages

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

On Tue, 2002-01-29 at 16:11, Chris McDaniel wrote:
> Just wondering if there was a way I could set up per-user update rights on
> specific static pages using the existing page-edit interface.

I don't know your purpose, but do you really need per-*user* rights on
pages? In almost every case I've seen, it's better to use groups.

Do you mean you'd like to edit security within the page editing
interface in addition to using the normal security editing system? If
so, you can but it will take some work. I did some work a couple months
ago to make the security editing widget embeddable in another form, but
I don't know if I finished or not. (Lame...)

One of the issues with this is checking the security on who should be
allowed to use the security editor, and where. For instance, say you're
running a site where users can set security on their own news stories.
Should we put a check in the security editing function to ensure that
users viewing and modifying security for a news story have at least
WRITE permissions to it?

In any case, if this is what you're looking for let me know and I'll see
if it's working.

Chris

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