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

Re: [Openinteract-help] Using several content-generators for one action?

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

> I'm currently trying out Martin Kutters SOAP add on for OpenInteract2.
> My idea is to use soap as remote API for OI2. Thus I would like to have
> two content-generators for all packages, one giving the usual
> html-response, and the other one giving a soap response.

That's been my idea for SOAP as well.

> When I understand the current implementation of OI correct, then it is
> in principle possible to have several content generators in OI, but one
> action has exactly one content generator, defined by the action.ini
> file, not by the Response-type. I hope I'm wrong with this assumption,
> so my question is, how do I enable different content-generators for one
> action? Or is my understanding of an 'action' wrong?

Your understanding is right. But I think what's missing is you can map
multiple action specifications to the same class. For instance in an
action.ini you might have:

[foo]
class = OpenInteract2::Action::Foo
content_generator = TT

[bar]
class = OpenInteract2::Action::Foo
content_generator = SOAP

The same data are retrieved from the action + task, but they're passed off
to a different content generator depending on how they were invoked. Make
sense?

The 'news' package has some commented-out examples of doing this with
Text::Template and HTML::Template.

> And in some packages, I haven't seen the content_generator flag in the
> action.ini. Where is the default defined?

In server.ini:

[action_info default]
controller         = tt-template
content_generator  = TT

Hope this helps,

Chris

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

[Openinteract-help] Using several content-generators for one action?

[Heiko K. <Hei...@gm...>]

I'm currently trying out Martin Kutters SOAP add on for OpenInteract2. 
My idea is to use soap as remote API for OI2. Thus I would like to have 
two content-generators for all packages, one giving the usual 
html-response, and the other one giving a soap response.

When I understand the current implementation of OI correct, then it is 
in principle possible to have several content generators in OI, but one 
action has exactly one content generator, defined by the action.ini 
file, not by the Response-type. I hope I'm wrong with this assumption, 
so my question is, how do I enable different content-generators for one 
action? Or is my understanding of an 'action' wrong?

And in some packages, I haven't seen the content_generator flag in the 
action.ini. Where is the default defined?

Best regards,

Heiko

Re: AW: [Openinteract-help] Trouble getting an old server up

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

On Oct 1, 2004, at 3:56 PM, Vijai Rao wrote:
> well, I have had no luck.
>
> I tried reinstalling the whole thing and now get a whole bunch of
> errors with INITIAL install_sql
>
>  Structure:
>         * create_structure for mysql: no action taken
>       Data:
>         * Error: Cannot create SPOPS object!
>       Basic: DBD::mysql::st execute failed: Duplicate entry
>
> A lot of these...

Here's the standard way I run an install for PostgreSQL:

  # dropdb foo
  # createdb foo
  # ...edit conf/server.ini with db params...
  # ...edit conf/global_override.ini to set Postgres as db...
  # oi_manage install_sql --package=INITIAL

As Salve said, you might want to make sure you don't have an existing 
database with tables.

Then again, if you want to keep the data you don't need to run the 
'install_sql' piece at all.

Chris

--
Chris Winters
Creating enterprise-capable snack systems since 1988

Re: AW: [Openinteract-help] Trouble getting an old server up

[Salve J. N. <sal...@me...>]

Vijai Rao said:
> well, I have had no luck.
>
> I tried reinstalling the whole thing and now get a whole bunch of
> errors with INITIAL install_sql
>
>  Structure:
>         * create_structure for mysql: no action taken
>       Data:
>         * Error: Cannot create SPOPS object!
>       Basic: DBD::mysql::st execute failed: Duplicate entry
>
> A lot of these...

Try dropping the database before trying again... ;-)


- Salve

Re: AW: [Openinteract-help] Trouble getting an old server up

[Vijai R. <vij...@gm...>]

well, I have had no luck.

I tried reinstalling the whole thing and now get a whole bunch of
errors with INITIAL install_sql

 Structure:
        * create_structure for mysql: no action taken
      Data:
        * Error: Cannot create SPOPS object!
      Basic: DBD::mysql::st execute failed: Duplicate entry

A lot of these...

-v






On Thu, 23 Sep 2004 09:59:41 +0200, and...@be...
<and...@be...> wrote:
> Hi,
>=20
> Restart the apache services and look in the error.log file after that. I =
guess you will find complaints of perl packages, which could not be found.
>=20
> Regards,
>=20
> Andreas
>=20
> PS: if you do not know the exact file, then do ps ax|grep httpd , then fi=
nd a PID and do lsof -p PID
>=20
> -----Urspr=FCngliche Nachricht-----
> Von: ope...@li... [mailto:openinteract-h=
elp...@li...]
> Gesendet: Mittwoch, 22. September 2004 20:15
> An: ch...@cw...
> Cc: ope...@li...
> Betreff: Re: [Openinteract-help] Trouble getting an old server up
>=20
> On Mon, 20 Sep 2004 07:15:33 -0500 (EST), Chris Winters <chris@cwinters.c=
om> wrote:
> >
> > > Okay, I located the correct logs .
> > >
> > > The error is that it cant find packages that are already installed
> > > in /opt/OpenInteract . I have verified that the installs were
> > > succesful but the server can't seem to find it.
> >
> > At startup the server grabs all the package libraries and copies them
> > to a flattened temporary library directory. Typically this is
> > '$WEBSITE_DIR/tmplib' and in your case this appears to be
> > '/home/httpd/www.website.com/tmplib' -- see that the directory exists,
> > the webuser has permission to write, etc.
> >
> > Chris
>=20
> That error dissappeared after I appended default repository.perl to the o=
ld existing one.
>=20
> Now I get this ( in the virtualhost logs, not main server logs )
>=20
> Error: Can't locate object method "throw" via package "Website::ErrorObje=
ct"
>=20
> Im running suse 9.1 , apache 1.3 , oi 1.61 ,modperl  1.29 and apachestart=
up 1.26
>=20
> -v
>=20
> > --
> > Chris Winters (ch...@cw...)
> > Building enterprise-capable snack solutions since 1988.
> >
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 Projec=
t Admins to receive an Apple iPod Mini FREE for your judgement on who ports=
 your project to Linux PPC the best. Sponsored by IBM.
> Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php ______________=
_________________________________
> openinteract-help mailing list ope...@li...
> https://lists.sourceforge.net/lists/listinfo/openinteract-help
>

AW: [Openinteract-help] Trouble getting an old server up

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

Hi,

Restart the apache services and look in the error.log file after that. I =
guess you will find complaints of perl packages, which could not be =
found.

Regards,

Andreas

PS: if you do not know the exact file, then do ps ax|grep httpd , then =
find a PID and do lsof -p PID

-----Urspr=FCngliche Nachricht-----
Von: ope...@li... =
[mailto:ope...@li...]=20
Gesendet: Mittwoch, 22. September 2004 20:15
An: ch...@cw...
Cc: ope...@li...
Betreff: Re: [Openinteract-help] Trouble getting an old server up


On Mon, 20 Sep 2004 07:15:33 -0500 (EST), Chris Winters =
<ch...@cw...> wrote:
>=20
> > Okay, I located the correct logs .
> >
> > The error is that it cant find packages that are already installed=20
> > in /opt/OpenInteract . I have verified that the installs were=20
> > succesful but the server can't seem to find it.
>=20
> At startup the server grabs all the package libraries and copies them=20
> to a flattened temporary library directory. Typically this is=20
> '$WEBSITE_DIR/tmplib' and in your case this appears to be=20
> '/home/httpd/www.website.com/tmplib' -- see that the directory exists, =

> the webuser has permission to write, etc.
>=20
> Chris


That error dissappeared after I appended default repository.perl to the =
old existing one.

Now I get this ( in the virtualhost logs, not main server logs )


Error: Can't locate object method "throw" via package =
"Website::ErrorObject"=20

Im running suse 9.1 , apache 1.3 , oi 1.61 ,modperl  1.29 and =
apachestartup 1.26

-v






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


-------------------------------------------------------
This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 =
Project Admins to receive an Apple iPod Mini FREE for your judgement on =
who ports your project to Linux PPC the best. Sponsored by IBM.
Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php =
_______________________________________________
openinteract-help mailing list ope...@li...
https://lists.sourceforge.net/lists/listinfo/openinteract-help

Re: [Openinteract-help] Trouble getting an old server up

[Vijai R. <vij...@gm...>]

On Mon, 20 Sep 2004 07:15:33 -0500 (EST), Chris Winters
<ch...@cw...> wrote:
> 
> > Okay, I located the correct logs .
> >
> > The error is that it cant find packages that are already installed in
> > /opt/OpenInteract . I have verified that the installs were succesful
> > but the server can't seem to find it.
> 
> At startup the server grabs all the package libraries and copies them to a
> flattened temporary library directory. Typically this is
> '$WEBSITE_DIR/tmplib' and in your case this appears to be
> '/home/httpd/www.website.com/tmplib' -- see that the directory exists, the
> webuser has permission to write, etc.
> 
> Chris


That error dissappeared after I appended default repository.perl to
the old existing one.

Now I get this ( in the virtualhost logs, not main server logs )


Error: Can't locate object method "throw" via package "Website::ErrorObject" 

Im running suse 9.1 , apache 1.3 , oi 1.61 ,modperl  1.29 and
apachestartup 1.26

-v






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

[Openinteract-help] OI2 failed tests on win2K

[<Jod...@ne...>]

I have OI2 installed and running on a RedHat 9 box. I would like to also install it on a win2k machine for development. I could not locate a ppd file to install OI2 via ppm, so I used the Module::Build process

The command "perl .\Build.PL" does not list any dependencies (after installing them).

after "perl .\Build", I ran "perl .\Build test" and got many failures.

So I ran "perl .\Build test 1>testout.txt 2>&1"

you can see the output at:

http://waveright.homeip.net/~trwww/oi/testout.txt

I also noticed a file named oi2_tests.log, and you can see its contents here:

http://waveright.homeip.net/~trwww/oi/oi2_tests.log

TIA,

Todd W.



__________________________________________________________________
Switch to Netscape Internet Service.
As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register

Netscape. Just the Net You Need.

New! Netscape Toolbar for Internet Explorer
Search from anywhere on the Web and block those annoying pop-ups.
Download now at http://channels.netscape.com/ns/search/install.jsp

Re: [Openinteract-help] Trouble getting an old server up

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

> Okay, I located the correct logs .
>
> The error is that it cant find packages that are already installed in
> /opt/OpenInteract . I have verified that the installs were succesful
> but the server can't seem to find it.

At startup the server grabs all the package libraries and copies them to a
flattened temporary library directory. Typically this is
'$WEBSITE_DIR/tmplib' and in your case this appears to be
'/home/httpd/www.website.com/tmplib' -- see that the directory exists, the
webuser has permission to write, etc.

Chris

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

Re: [Openinteract-help] Trouble getting an old server up

[Vijai R. <vij...@gm...>]

On Fri, 17 Sep 2004 21:51:22 -0400, Chris Winters <ch...@cw...> wrote:
> 
> 
> Vijai Rao wrote:
> > I have been handed an old OI server and Im trying to get it to work. I
> > had lots of problems with apache 2 , so I am running apache 1
> > seperately for this OI site.
> >
> > The server starts okay, but when I try to access any page, I get this
> > in my apache logs:
> >
> > [error] Undefined subroutine &OpenInteract::handler called.\n
> >
> > The website just says 500 server error.
> >
> > After a config test, I get this:
> >
> > OpenInteract::ApacheStartup::initialize (34) >> ApacheStartup: Reading
> > in information for configuration: /home/httpd/website/conf/base.conf
> > OpenInteract::ApacheStartup::initialize (40) >> SERVER INIT: base
> > configuration read in ok.
> > OpenInteract::ApacheStartup::initialize (55) >> SERVER INIT: apache
> > modules read in ok.
> > OpenInteract::ApacheStartup::initialize (69) >> SERVER INIT: installed
> > DBD driver (mysql) ok.
> > OpenInteract::ApacheStartup::initialize (76) >> Creating proxy subroutine
> > OpenInteract::ApacheStartup::initialize (79) >> SERVER INIT: installed
> > proxy subroutine ok.
> > Log4perl: Seems like no initialization happened. Forgot to call init()?
> > OpenInteract::ApacheStartup::initialize (112) >> SERVER INIT: Adding
> > ChildInitHandler for initialization
> > Syntax OK
> >
> >
> > Where should I be looking ?
> 
> Try looking in $VHOST_DIR/logs/error_log_modperl -- the messages above
> are from the server-wide initialization which only happens when each
> Apache child is created.
> 
> good luck
> 
> Chris
> 



Okay, I located the correct logs .

The error is that it cant find packages that are already installed in
/opt/OpenInteract . I have verified that the installs were succesful
but the server can't seem to find it.

Example:

OpenInteract::Startup::require_module (355) >>  --require error:
OpenInteract::Error::User                (from base_user): Can't
locate OpenInteract/Error/User.pm in @INC (@INC contains:
/home/httpd/www.website.com/tmplib /opt/OpenInteract/pkg
/home/httpd/www.website.com
/usr/lib/perl5/5.8.3/i586-linux-thread-multi /usr/lib/perl5/5.8.3
/usr/lib/perl5/site_perl/5.8.3/i586-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.3/i586-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3 /usr/lib/perl5/vendor_perl .
/usr/local/apache/ /usr/local/apache/lib/perl) at (eval 228) line 3.


But, I have the file in my system:

/opt/OpenInteract/pkg/base_user-1.64/OpenInteract # ls
.  ..  Error  Handler  SQLInstall  User  User.pm

-v

Re: [Openinteract-help] Trouble getting an old server up

[Vijai R. <vij...@gm...>]

On Fri, 17 Sep 2004 21:51:22 -0400, Chris Winters <ch...@cw...> wrote:
> 
> 
> Vijai Rao wrote:
> > I have been handed an old OI server and Im trying to get it to work. I
> > had lots of problems with apache 2 , so I am running apache 1
> > seperately for this OI site.
> >
> > The server starts okay, but when I try to access any page, I get this
> > in my apache logs:
> >
> > [error] Undefined subroutine &OpenInteract::handler called.\n
> >
> > The website just says 500 server error.
> >
> > After a config test, I get this:
> >
> > OpenInteract::ApacheStartup::initialize (34) >> ApacheStartup: Reading
> > in information for configuration: /home/httpd/website/conf/base.conf
> > OpenInteract::ApacheStartup::initialize (40) >> SERVER INIT: base
> > configuration read in ok.
> > OpenInteract::ApacheStartup::initialize (55) >> SERVER INIT: apache
> > modules read in ok.
> > OpenInteract::ApacheStartup::initialize (69) >> SERVER INIT: installed
> > DBD driver (mysql) ok.
> > OpenInteract::ApacheStartup::initialize (76) >> Creating proxy subroutine
> > OpenInteract::ApacheStartup::initialize (79) >> SERVER INIT: installed
> > proxy subroutine ok.
> > Log4perl: Seems like no initialization happened. Forgot to call init()?
> > OpenInteract::ApacheStartup::initialize (112) >> SERVER INIT: Adding
> > ChildInitHandler for initialization
> > Syntax OK
> >
> >
> > Where should I be looking ?
> 
> Try looking in $VHOST_DIR/logs/error_log_modperl -- the messages above
> are from the server-wide initialization which only happens when each
> Apache child is created.
> 
> good luck
> 
> Chris
> 
> 

Should have asked this in my earlier post. What should I do to get it
to write in website_dir/logs/ ?

Just make apache write there and it will start giving more information
than usual? Write now I get nothing there

Thanks,

V

Re: [Openinteract-help] Trouble getting an old server up

[Vijai R. <vij...@gm...>]

On Fri, 17 Sep 2004 21:51:22 -0400, Chris Winters <ch...@cw...> wrote:
> 
> 
> Vijai Rao wrote:
> > I have been handed an old OI server and Im trying to get it to work. I
> > had lots of problems with apache 2 , so I am running apache 1
> > seperately for this OI site.
> >
> > The server starts okay, but when I try to access any page, I get this
> > in my apache logs:
> >
> > [error] Undefined subroutine &OpenInteract::handler called.\n
> >
> > The website just says 500 server error.
> >
> > After a config test, I get this:
> >
> > OpenInteract::ApacheStartup::initialize (34) >> ApacheStartup: Reading
> > in information for configuration: /home/httpd/website/conf/base.conf
> > OpenInteract::ApacheStartup::initialize (40) >> SERVER INIT: base
> > configuration read in ok.
> > OpenInteract::ApacheStartup::initialize (55) >> SERVER INIT: apache
> > modules read in ok.
> > OpenInteract::ApacheStartup::initialize (69) >> SERVER INIT: installed
> > DBD driver (mysql) ok.
> > OpenInteract::ApacheStartup::initialize (76) >> Creating proxy subroutine
> > OpenInteract::ApacheStartup::initialize (79) >> SERVER INIT: installed
> > proxy subroutine ok.
> > Log4perl: Seems like no initialization happened. Forgot to call init()?
> > OpenInteract::ApacheStartup::initialize (112) >> SERVER INIT: Adding
> > ChildInitHandler for initialization
> > Syntax OK
> >
> >
> > Where should I be looking ?
> 
> Try looking in $VHOST_DIR/logs/error_log_modperl -- the messages above
> are from the server-wide initialization which only happens when each
> Apache child is created.
> 
> good luck
> 
> Chris
> 
> 

Thanks for your response.

Nothing is showing up there...

The only error message generated is what I pasted earlier  '[error]
Undefined subroutine &OpenInteract::handler called.\n' from apache's
ErrorLog



V

Re: [Openinteract-help] Trouble getting an old server up

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

Vijai Rao wrote:
> I have been handed an old OI server and Im trying to get it to work. I
> had lots of problems with apache 2 , so I am running apache 1
> seperately for this OI site.
> 
> The server starts okay, but when I try to access any page, I get this
> in my apache logs:
> 
> [error] Undefined subroutine &OpenInteract::handler called.\n
> 
> The website just says 500 server error.
> 
> After a config test, I get this:
> 
> OpenInteract::ApacheStartup::initialize (34) >> ApacheStartup: Reading
> in information for configuration: /home/httpd/website/conf/base.conf
> OpenInteract::ApacheStartup::initialize (40) >> SERVER INIT: base
> configuration read in ok.
> OpenInteract::ApacheStartup::initialize (55) >> SERVER INIT: apache
> modules read in ok.
> OpenInteract::ApacheStartup::initialize (69) >> SERVER INIT: installed
> DBD driver (mysql) ok.
> OpenInteract::ApacheStartup::initialize (76) >> Creating proxy subroutine
> OpenInteract::ApacheStartup::initialize (79) >> SERVER INIT: installed
> proxy subroutine ok.
> Log4perl: Seems like no initialization happened. Forgot to call init()?
> OpenInteract::ApacheStartup::initialize (112) >> SERVER INIT: Adding
> ChildInitHandler for initialization
> Syntax OK
> 
> 
> Where should I be looking ?

Try looking in $VHOST_DIR/logs/error_log_modperl -- the messages above 
are from the server-wide initialization which only happens when each 
Apache child is created.

good luck

Chris

[Openinteract-help] Trouble getting an old server up

[Vijai R. <vij...@gm...>]

Greetings,

I have been handed an old OI server and Im trying to get it to work. I
had lots of problems with apache 2 , so I am running apache 1
seperately for this OI site.

The server starts okay, but when I try to access any page, I get this
in my apache logs:

[error] Undefined subroutine &OpenInteract::handler called.\n

The website just says 500 server error.



After a config test, I get this:

OpenInteract::ApacheStartup::initialize (34) >> ApacheStartup: Reading
in information for configuration: /home/httpd/website/conf/base.conf
OpenInteract::ApacheStartup::initialize (40) >> SERVER INIT: base
configuration read in ok.
OpenInteract::ApacheStartup::initialize (55) >> SERVER INIT: apache
modules read in ok.
OpenInteract::ApacheStartup::initialize (69) >> SERVER INIT: installed
DBD driver (mysql) ok.
OpenInteract::ApacheStartup::initialize (76) >> Creating proxy subroutine
OpenInteract::ApacheStartup::initialize (79) >> SERVER INIT: installed
proxy subroutine ok.
Log4perl: Seems like no initialization happened. Forgot to call init()?
OpenInteract::ApacheStartup::initialize (112) >> SERVER INIT: Adding
ChildInitHandler for initialization
Syntax OK


Where should I be looking ?


Regards,

Vijai

Re: [Openinteract-help] OpenInteract as CMS

[Andreas N. <an...@kl...>]

Hi Heiko,

from our experiences with OI 1 you should be able to do that. We are 
planning to release a package called roma at some point of time, which is 
our solution for CMS and other topics. Currently, we are still using OI 1 
though, but roma is not tightly bound to OI 1.

What it does is a framework to define content types and links between 
content items.
Each content type can have attributes which you assign can assign s.th. like 
htmlarea ( we use the commercial tool Editlet, but htmlarea also works ).
From these links you can create trees of content including security stuff 
( not sys_security... ) and full text search.

The system is in production use BUT... there is not much documentation. If 
you are interested and /or would like to contribute ( .. like documentation 
;-) ), then we can send you the package. But be warned: it has a learning 
curve..

For the other question: you could use Chris Winters Workflow.pm from CPAN to 
create CMS workflows. Alternatively we have a framework for this called 
NATS - but it also lacks documentation. We will merge this with Workflow.pm 
at some point of time.

cheers

Andreas
----- Original Message ----- 
From: "Heiko Klein" <Hei...@gm...>
To: <ope...@li...>
Sent: Friday, September 10, 2004 2:49 PM
Subject: [Openinteract-help] OpenInteract as CMS


> Hi,
>
> I'm new to openinteract and just ran the tutorial of OI2. OI2 seems to be 
> a very nice perl application server and I would like to continue with it. 
> My main application running on OI2 should be a CMS system, with some 
> applications added later.
>
> Does there exist a CMS framework on top of OI2? (Similar to plone for 
> Zope, OpenCMS for J2EE, ...) OI2 has its 'pages'-example, but I wouldn't 
> call those a full CMS, since they are more or less just a different way of 
> accessing the file-system. I would like to have:
>
> 1) access-restrictions of pages/directories (with users only seeing the 
> places they are allowed to write to)
> 2) setting of expiration dates (with notification when page expires)
> 3) web-based page editor GUI
> 4) versioning system for all pages (pagewise)
> 5) batch uploading of files (i.e. graphics, older pages...)
>
> 1) and 2) seem to be partly included. 3) could be as simple as a 
> javascript-tool, i.e. 
> http://www.interactivetools.com/products/htmlarea/license.html
> 4) shouldn't be to much work. 5) could be solved by uploading zip files, 
> which get unpacked. But I would prefer a API to OI2 (i.e. SOAP) to be able 
> to script OI2 from a remote machine.
>
> I would like to hear if this will be possible for me (decent perl 
> programmer without experience in OI but some experience in 
> web-applications/databases) to create with OI2 within the next 3-6month, 
> or if I should use a specialized CMS i.e. Bricolage for the static pages, 
> and OI2 for the dynamic applications (news/blogs/fora/etc.)
>
> Best regards,
>
> Heiko
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> Project Admins to receive an Apple iPod Mini FREE for your judgement on
> who ports your project to Linux PPC the best. Sponsored by IBM. Deadline: 
> Sept. 13. Go here: http://sf.net/ppc_contest.php
> _______________________________________________
> openinteract-help mailing list
> ope...@li...
> https://lists.sourceforge.net/lists/listinfo/openinteract-help
> 

Re: [Openinteract-help] OpenInteract as CMS

[Andreas N. <an...@kl...>]

Hi Heiko,

from our experiences with OI 1 you should be able to do that. We are 
planning to release a package called roma at some point of time, which is 
our solution for CMS and other topics. Currently, we are still using OI 1 
though, but roma is not tightly bound to OI 1.

What it does is a framework to define content types and links between 
content items.
Each content type can have attributes which you assign can assign s.th. like 
htmlarea ( we use the commercial tool Editlet, but htmlarea also works ).
From these links you can create trees of content including security stuff 
( not sys_security... ) and full text search.

The system is in production use BUT... there is not much documentation. If 
you are interested and /or would like to contribute ( .. like documentation 
;-) ), then we can send you the package. But be warned: it has a learning 
curve..

For the other question: you could use Chris Winters Workflow.pm from CPAN to 
create CMS workflows. Alternatively we have a framework for this called 
NATS - but it also lacks documentation. We will merge this with Workflow.pm 
at some point of time.

cheers

Andreas
----- Original Message ----- 
From: "Heiko Klein" <Hei...@gm...>
To: <ope...@li...>
Sent: Friday, September 10, 2004 2:49 PM
Subject: [Openinteract-help] OpenInteract as CMS


> Hi,
>
> I'm new to openinteract and just ran the tutorial of OI2. OI2 seems to be 
> a very nice perl application server and I would like to continue with it. 
> My main application running on OI2 should be a CMS system, with some 
> applications added later.
>
> Does there exist a CMS framework on top of OI2? (Similar to plone for 
> Zope, OpenCMS for J2EE, ...) OI2 has its 'pages'-example, but I wouldn't 
> call those a full CMS, since they are more or less just a different way of 
> accessing the file-system. I would like to have:
>
> 1) access-restrictions of pages/directories (with users only seeing the 
> places they are allowed to write to)
> 2) setting of expiration dates (with notification when page expires)
> 3) web-based page editor GUI
> 4) versioning system for all pages (pagewise)
> 5) batch uploading of files (i.e. graphics, older pages...)
>
> 1) and 2) seem to be partly included. 3) could be as simple as a 
> javascript-tool, i.e. 
> http://www.interactivetools.com/products/htmlarea/license.html
> 4) shouldn't be to much work. 5) could be solved by uploading zip files, 
> which get unpacked. But I would prefer a API to OI2 (i.e. SOAP) to be able 
> to script OI2 from a remote machine.
>
> I would like to hear if this will be possible for me (decent perl 
> programmer without experience in OI but some experience in 
> web-applications/databases) to create with OI2 within the next 3-6month, 
> or if I should use a specialized CMS i.e. Bricolage for the static pages, 
> and OI2 for the dynamic applications (news/blogs/fora/etc.)
>
> Best regards,
>
> Heiko
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> Project Admins to receive an Apple iPod Mini FREE for your judgement on
> who ports your project to Linux PPC the best. Sponsored by IBM. Deadline: 
> Sept. 13. Go here: http://sf.net/ppc_contest.php
> _______________________________________________
> openinteract-help mailing list
> ope...@li...
> https://lists.sourceforge.net/lists/listinfo/openinteract-help
> 

Re: [Openinteract-help] OpenInteract as CMS

[Andreas N. <an...@kl...>]

Hi Heiko,

from our experiences with OI 1 you should be able to do that. We are 
planning to release a package called roma at some point of time, which is 
our solution for CMS and other topics. Currently, we are still using OI 1 
though, but roma is not tightly bound to OI 1.

What it does is a framework to define content types and links between 
content items.
Each content type can have attributes which you assign can assign s.th. like 
htmlarea ( we use the commercial tool Editlet, but htmlarea also works ).
From these links you can create trees of content including security stuff 
( not sys_security... ) and full text search.

The system is in production use BUT... there is not much documentation. If 
you are interested and /or would like to contribute ( .. like documentation 
;-) ), then we can send you the package. But be warned: it has a learning 
curve..

For the other question: you could use Chris Winters Workflow.pm from CPAN to 
create CMS workflows. Alternatively we have a framework for this called 
NATS - but it also lacks documentation. We will merge this with Workflow.pm 
at some point of time.

cheers

Andreas
----- Original Message ----- 
From: "Heiko Klein" <Hei...@gm...>
To: <ope...@li...>
Sent: Friday, September 10, 2004 2:49 PM
Subject: [Openinteract-help] OpenInteract as CMS


> Hi,
>
> I'm new to openinteract and just ran the tutorial of OI2. OI2 seems to be 
> a very nice perl application server and I would like to continue with it. 
> My main application running on OI2 should be a CMS system, with some 
> applications added later.
>
> Does there exist a CMS framework on top of OI2? (Similar to plone for 
> Zope, OpenCMS for J2EE, ...) OI2 has its 'pages'-example, but I wouldn't 
> call those a full CMS, since they are more or less just a different way of 
> accessing the file-system. I would like to have:
>
> 1) access-restrictions of pages/directories (with users only seeing the 
> places they are allowed to write to)
> 2) setting of expiration dates (with notification when page expires)
> 3) web-based page editor GUI
> 4) versioning system for all pages (pagewise)
> 5) batch uploading of files (i.e. graphics, older pages...)
>
> 1) and 2) seem to be partly included. 3) could be as simple as a 
> javascript-tool, i.e. 
> http://www.interactivetools.com/products/htmlarea/license.html
> 4) shouldn't be to much work. 5) could be solved by uploading zip files, 
> which get unpacked. But I would prefer a API to OI2 (i.e. SOAP) to be able 
> to script OI2 from a remote machine.
>
> I would like to hear if this will be possible for me (decent perl 
> programmer without experience in OI but some experience in 
> web-applications/databases) to create with OI2 within the next 3-6month, 
> or if I should use a specialized CMS i.e. Bricolage for the static pages, 
> and OI2 for the dynamic applications (news/blogs/fora/etc.)
>
> Best regards,
>
> Heiko
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> Project Admins to receive an Apple iPod Mini FREE for your judgement on
> who ports your project to Linux PPC the best. Sponsored by IBM. Deadline: 
> Sept. 13. Go here: http://sf.net/ppc_contest.php
> _______________________________________________
> openinteract-help mailing list
> ope...@li...
> https://lists.sourceforge.net/lists/listinfo/openinteract-help
> 

[Openinteract-help] OpenInteract as CMS

[Heiko K. <Hei...@gm...>]

Hi,

I'm new to openinteract and just ran the tutorial of OI2. OI2 seems to 
be a very nice perl application server and I would like to continue with 
it. My main application running on OI2 should be a CMS system, with some 
applications added later.

Does there exist a CMS framework on top of OI2? (Similar to plone for 
Zope, OpenCMS for J2EE, ...) OI2 has its 'pages'-example, but I wouldn't 
call those a full CMS, since they are more or less just a different way 
of accessing the file-system. I would like to have:

1) access-restrictions of pages/directories (with users only seeing the 
places they are allowed to write to)
2) setting of expiration dates (with notification when page expires)
3) web-based page editor GUI
4) versioning system for all pages (pagewise)
5) batch uploading of files (i.e. graphics, older pages...)

1) and 2) seem to be partly included. 3) could be as simple as a 
javascript-tool, i.e. 
http://www.interactivetools.com/products/htmlarea/license.html
4) shouldn't be to much work. 5) could be solved by uploading zip files, 
which get unpacked. But I would prefer a API to OI2 (i.e. SOAP) to be 
able to script OI2 from a remote machine.

I would like to hear if this will be possible for me (decent perl 
programmer without experience in OI but some experience in 
web-applications/databases) to create with OI2 within the next 3-6month, 
or if I should use a specialized CMS i.e. Bricolage for the static 
pages, and OI2 for the dynamic applications (news/blogs/fora/etc.)

Best regards,

Heiko

[Openinteract-help] SPOPS::LDAP implementation isn't robust

[Andrew S. H. <ste...@ci...>]

I'll admit right off the bat that I haven't checked the archives or 
looked much deeper than a couple of the docs, so this suggestion might 
be answered elsewhere.  I also don't know if this is most appropriate 
for openinteract-dev or openinteract-help, but since I'm not a 
developer, help seemed a little safer. Please shoot me down and redirect 
me if I'm in the wrong place or it's a solved problem. Thanks.

I just wanted to make a feature request that a future version of SPOPS 
include more robust multi-record querying, or (at least) an easily 
overridden method to handle the queries.  The problem I'm running into 
is that ActiveDirectory limits the query size limit to something 
insanely low (under 1,000, if memory serves).  It just croaks if you try 
to grab all of them at once: "Sizelimit exceeded".

The solution, is to request the records in batches of limited size.  
Net::LDAP::Control::Paged contains an example on how to do this. Here is 
the implementation I used for queries prior to switching to SPOPS:

    # This code is mostly ripped off from the Net::LDAP::Control::Paged POD
    my $page = Net::LDAP::Control::Paged->new(size => $page_size);
    my @args = (@_, control => [ $page ]);
    my $cookie;
    while (1) {
        my $mesg = $$self{ldap}->search(@args);
        $mesg->code and die "Error occurred during search: ",$mesg->error;
        my ($resp) = $mesg->control(LDAP_CONTROL_PAGED) or last;
        $cookie = $resp->cookie or last;
        $page->cookie($cookie);
    }

    # check for abnormal exit and cleanup if we have one
    if ($cookie) {
        $page->cookie($cookie);
        $page->size(0);
        $$self{ldap}->search(@args);

        return '';
    }

After a quick look through of SPOPS::LDAP, it should be easy enough to 
adapt SPOPS::LDAP::_execute_multiple_record_query to use paged rather 
than plain queries.  In fact, this is likely what I'll do as a stop 
gap---i.e., just redefine this method in my custom extensions.  However, 
that's digging inside of your code and will most certainly break some 
day when you guys change the internals.

So, my request is either to incorporate paging in the searches, or add 
an option:

   paged_queries => 'yes',
   paged_query_size => 500,

or something to that effect. OR, provide a standard place to override 
the query mechanism to replace it with a custom implementation in a 
derived class (or whatever).

SPOPS is the niftiest POOP I've used thus far, so keep up the good work.

Regards,
Sterling

Re: [Openinteract-help] SPOPS MySQL Question

[Timothy M. A. <ti...@ad...>]

On Wed, 2004-08-04 at 09:55, Nick Floersch wrote:
[SNIP]

> 2) There is some problem with the way the database connection is being setup or the SPOPS SQL execution is  taking place such that the query works by hand entry but not in the Perl Program.
> 
> I know there are a lot of variables and unknowns to you, the reader, but what I am really curious about is if anyone else ever has problems *like* this.

One of these would be the table type you're using. I've had issues with
locking under MySQL in the past with the ISAM and MyISAM table types. I
know that InnoDB was supposed to alleviate this issue, but at the time I
was playing with InnoDB support, it seemed to send the server into
never-never land far more frequently.

> My only way of describing the hang is this: When I execute a general, working query, the CPU history will show 100% usage for maybe 10-30 seconds (depending on the query) and then MySQL will return with the data. In this case, CPU usage goes to 100% for some period of time, and then drops down to %50 and just stays there until I end the query. MySQL itself remains completely useable for other connections (CLI client for example). So MySQL doesn't die. Its almost like there is some loop that just keeps running and running...

Again, I'm just guessing here, but have you tried executing the query
manually when the server is under load? This would be a sure pointer to
row or table locking issues.

Failing that, how about slapping together a quick Perl/DBI script with
the same SQL to see if it's an issue only when running a Perl program.
At the least, this would help to insure that it is, in fact, an SPOPS
issue.

[SNIP]

Personally, I run Postgres and haven't (yet) run into issues where the
SQL causes the server to run away. In quick (read: I tried two or three
times) tests, the generated SQL doesn't seem too different between the
databases. Now, my own Cartesean product-ridden SQL is another story. :)

Hope that helps!

/tma

[Openinteract-help] SPOPS MySQL Question

[Nick F. <Ni...@st...>]

Hi all,

I am working on an application that uses SPOPS and MySQL together.

Sometimes when an SQL query is executed, MySQL hangs.

This often happens when the query involves checking SPOPS_Security info =
in the spops_security table.

I have looked at the SQL query log (which shows all the queries being =
executed in MySQL) to see which SQL queries are occurring just before =
MySQL hangs. When I find them, I can copy and past them into the MySQL =
cli client and execute them. They always work fine.

So, two things occur to me:

1) The query log is showing only queries that have completed =
successfully, and not the one MySQL is hanging on...

2) There is some problem with the way the database connection is being =
setup or the SPOPS SQL execution is  taking place such that the query =
works by hand entry but not in the Perl Program.

I know there are a lot of variables and unknowns to you, the reader, but =
what I am really curious about is if anyone else ever has problems =
*like* this.

My only way of describing the hang is this: When I execute a general, =
working query, the CPU history will show 100% usage for maybe 10-30 =
seconds (depending on the query) and then MySQL will return with the =
data. In this case, CPU usage goes to 100% for some period of time, and =
then drops down to %50 and just stays there until I end the query. MySQL =
itself remains completely useable for other connections (CLI client for =
example). So MySQL doesn't die. Its almost like there is some loop that =
just keeps running and running...

I admit that I am using version .79. This is because another developer =
started the project and wrote a bunch of stuff, and then when we tried =
upgrading SPOPS, certain things stopped working. I'm not sure on =
specifics, but I do know it would be extra work to move up.

MySQL 4.0.13

Thanks or any clues.

Re: [Openinteract-help] has_a definitions with OI2 ini files

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

On Jul 5, 2004, at 8:58 AM, Chris Winters wrote:
> ...
> Try out the attached class OpenInteract2::Config::Initializer. This 
> has a bunch of small actions that get run after the configuration has 
> been read and

Oops, forgot to attach the class...

Chris

Re: [Openinteract-help] has_a definitions with OI2 ini files

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

On Jul 4, 2004, at 6:26 AM, Antti V=E4h=E4kotam=E4ki wrote:
> Sorry to bother you.. I'm tired after a night of coding and thus=20
> probably I'm just missing the documentation or the google page.
>
> Would someone please point out where it is described how to create=20
> has_a  configurations with OpenInteract2 ini files which correspond to=20=

> the example shown in SPOPS::Manual::Relationships :
>
>  has_a =3D> {  'My::User'      =3D> { updater =3D> 'updated_by' } },

Sorry for the delay -- I'm in the middle of moving to a new house.

This functionality is not in the current OI2. However, adding some=20
rules to fake it isn't too hard.

Try out the attached class OpenInteract2::Config::Initializer. This has=20=

a bunch of small actions that get run after the configuration has been=20=

read and parsed but before it's passed off to the relevant processing=20
code. (In this case: SPOPS::Initialize.)

Here's the POD for the changes:

----------

=3Ditem B<'has_a' Munging>

Because we have restricted configurations to three levels deep some
features cannot be adequately representetd. Complicated 'has_a'
relationships are one of these.

In the Perl data structure you might have something like:

  {
    user =3D> {
      ...
      has_a =3D> {
         'My::User' =3D> {
            updater =3D> 'updated_by',
            poster  =3D> 'posted_by',
         },
      },
  }

But if you try to do this with an unmodified configuration you will
get this far:

  [user has_a]
  My::User =3D ARGH!

Instead you can use a shortcut:

  [user has_a]
  My::User =3D updater: updated_by; poster: posted_by

So each name and field is separated by a ':' and each set is separated
by a ';'.

Alternatively you can also represent them as a list:

  My::User =3D updater: updated_by
  My::User =3D poster: posted_by

And the system will do the right thing.

----------

If this seems to work for you I'll do the same for 'links_to' sections.

Thanks,

Chris

--
Chris Winters
Creating enterprise-capable snack systems since 1988

[Openinteract-help] has_a definitions with OI2 ini files

[Antti <an...@io...>]

Sorry to bother you.. I'm tired after a night of coding and thus probably I'm just missing the documentation or the google page.

Would someone please point out where it is described how to create has_a  configurations with OpenInteract2 ini files which correspond to the example shown in SPOPS::Manual::Relationships :

 has_a => {  'My::User'      => { updater => 'updated_by' } },

I need this because I need to have has_a and links_to relations to the same object type and thus can't rely on the default object name as accessor on both occasions.

If there are other ways to accomplish this separation I'd be delighted to know them :)

Also it would be nice to know how to define other more advanced links_to and has_a relations with OI2 ini files..

- Antti

Re: [Openinteract-help] Failure retrieving page with ASA

[Greg F. <gre...@ya...>]

--- Chris Winters <ch...@cw...> wrote:
> 
> I haven't looked at the code yet, but before I run out the door: does
> DBD::ASAny (or the ASA libraries) allow you to have multiple open 
> statement handles on the same database handle?
> 

Yes, but ASA itself limits the number of maximum prepared statements
per connection.  The default limit is 50 (per connection).  This can be
changed via the database option MAX_STATEMENT_COUNT (there is also
MAX_CURSOR_COUNT for governing the number of open cursors, also
defaults to 50 per connection).

greg_fenton.

=====
Greg Fenton
gre...@ya...

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com