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

RE: [Openinteract-help] second db connection - object keys

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

Hello,

I am using the approach described below for a new module I'm writing, =
and I
ran into a problem with object keys during a save.  My spops objects =
have
the datasource key defined and fetch works fine, but saves only half =
work.
The data gets inserted into the table fine but then I get an error =
saying
sdbname.object_keys does not exist, which of course is true.  I =
filtered
through the modules and docs and got around it by passing the
skip_object_key =3D> 1 with my save, but I'm wondering, is this right?  =
It
seems to me that all object key info should be kept in the same spot,
regardless of where the data tables reside.  Having said that, I don't =
know
much about what object keys are for, so maybe I'm way off base...

Anyway, just thought I'd ask.

Thanks,

Chris McDaniel

-----Original Message-----
From: And...@Be... =
[mailto:And...@Be...]
Sent: February 20, 2003 3:51 AM
To: Chris McDaniel; ope...@li...
Subject: AW: [Openinteract-help] second db connection


Hi Chris,

you are almost right:

- yes,  you can define more datasources in your server.ini / =
server.perl
like this

[db_info seconddb]
db_owner      =3D
username      =3D auser
password      =3D apassword
dsn           =3D host=3Dbigbox.dbs.com
db_name       =3D adbname
driver_name   =3D mysql
sql_install   =3D
long_read_len =3D 65536
long_trunc_ok =3D 0

- to access this, you do not have to do anything special in your =
handler
- all you have to do is add a key to the SPOPS definition ( i.e.
conf/spops.perl ) like this:

'datasource' =3D> 'scounddb',

Hope this gets you up and running,

regards,

Andreas
-----Urspr=FCngliche Nachricht-----
Von: Chris McDaniel [mailto:Chr...@te...]
Gesendet: Donnerstag, 20. Februar 2003 09:20
An: 'ope...@li...'
Betreff: [Openinteract-help] second db connection



Hello,

Hope I'm not making a nuisance of myself, but I have yet another =
question.
In the server.ini it says things like:
[datasource]
default_connection_db   =3D main
and
[db_info main]

which makes me think that you could have other non-default datasources =
and
do a [db_info whatever] type statement.  I'm not sure if this is =
something
that is meant to be done, but if so, are there any docs on it?  If not, =
what
would I need to add to my ini file and how would I access this =
secondary DB
from within a handler?

Thanks!=20

Chris McDaniel



-------------------------------------------------------
This SF.net email is sponsored by: SlickEdit Inc. Develop an edge.
The most comprehensive and flexible code editor you can use.
Code faster. C/C++, C#, Java, HTML, XML, many more. FREE 30-Day Trial.
www.slickedit.com/sourceforge
_______________________________________________
openinteract-help mailing list
ope...@li...
https://lists.sourceforge.net/lists/listinfo/openinteract-help

Re: [Openinteract-help] Trouble with oi_manage and create_website on Win32

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

David C. Reed wrote:
> Some people have written in regarding a problem with the create_website 
> command in the oi_manage batch program on Win32 systems.  After hunting 
> around a bit I think I have located the problem.  At line 30 
> of PackageRepository.pm there is a subroutine called "package_filename," 
> which in turn calls the method "catfile" in the "File::Spec" module.  
 > ...

Looks great! Thanks for the detective work -- patch applied.

Chris

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

[Openinteract-help] Trouble with oi_manage and create_website on Win32

[David C. R. <dr...@xo...>]

Hi:

Some people have written in regarding a problem with the create_website =
command in the oi_manage batch program on Win32 systems.  After hunting =
around a bit I think I have located the problem.  At line 30 of =
PackageRepository.pm there is a subroutine called "package_filename," =
which in turn calls the method "catfile" in the "File::Spec" module.  =
The "File::Spec" module is designed to handle OS-specific filesystem =
semantics, and the "catfile" method concatenates the arguments passed to =
it in an OS-correct way.   The subroutine "package_filename" in  =
PackageRepository.pm calls the "catfile" method with "/" as the first =
arg (I'm assuming to specify root on *nix machines).  This causes an =
error when prepended in a Windows environment  (i.e., it comes out as =
"/c:\path\to\OI\base\dir").  As a quick fix I replaced the line in  =
PackageRepository.pm with a Windows-appropriate one. My code looks like =
this:

#sub package_filename { return File::Spec->catfile( '/', $_[1], =
$PKG_DB_FILE ) } # original code
sub package_filename { return File::Spec->catfile($_[1], $PKG_DB_FILE ) =
} # new code without forward slash

A more robust fix in PackageRepository.pm might be to check if the base =
directory specified begins with "/" or "c:\" and prepend appropriately =
(or better yet have File::Spec figure this out itself).

Hope this helps,
Dave Reed

[Openinteract-help] Re: [Openinteract-dev] question on package install

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

joseph speigle wrote:
> I feel sorry to have bothered on this one.  I'm working on just reinstalling it.
> I'm trying to track down the problem in  /usr/lib/perl5/site_perl/5.8.0/OpenInteract/PackageRepository.pm.  It is saying after  oi_manage --base_dir=/usr/local/openinteract/ --website_dir=/var/oi --package pkg_autoindex apply_package
> Running apply_package...
> =========================
> 
> MANIFEST: No such file or directory at /usr/lib/perl5/5.8.0/ExtUtils/Manifest.pm line 182.
> MANIFEST: No such file or directory at /usr/lib/perl5/5.8.0/ExtUtils/Manifest.pm line 182.
> OpenInteract::Package::install_to_website (502) >> Cannot copy MANIFEST.SKIP to /var/oi/pkg/-/MANIFEST.SKIP : No such file or directory
> OpenInteract::Package::install_to_website (502) >> Cannot copy package.conf to /var/oi/pkg/-/package.conf : No such file or directory
> Cannot save package repository: the OpenInteract base installation directory for package (-) is not specified or does not exist! at /usr/lib/perl5/site_perl/5.8.0/OpenInteract/PackageRepository.pm line 135.
> Status of the packages you requested to be applied:
> OK
> FAILED!: Package could not be verified -- either it doesn't exist in
>            base install or there's a problem with the base
>            install package.
> 
> I didn't find anything in the database about package indexes and theere 's nothing in the repository.perl so I deleted the directory - and was trying to install agagin.

The thing is, the $BASE_DIR/conf/package_repository.perl keeps 
track of all the packages installed. (It's just a serialized perl 
data structure.) If you just delete the directory it will get 
*very* confused.

One thing you might try is reinstalling the package *after* 
bumping up the version number. For example:

  $ cd pkg_autoindex
  $ emacs package.conf
    ... change the version to 0.02 ...
  $ oi_manage export_package
  $ export OPENINTERACT=/usr/local/openinteract
    ... assuming this is your repository/base directory ...
  $ oi_manage install_package \
       --package_file=pkg_autoindex-0.02.tar.gz

Now, look in your $BASE_DIR/conf/package_repository.perl and see 
if the pkg_autoindex-0.02 entry is in there. Additionally, see if 
$BASE_DIR/pkg/pkg_autoindex-0.02 directory exists and if it has 
all the same files.

If the entry is in the repository and the files in the directory 
all match up, try to apply the package and see what happens.

Chris

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

Re: [Openinteract-help] install OI on Win2K - ActiveState

[Cornel G. <cg...@cs...>]

Same thing happend to me last week but never tried to resolve the problem..


> oiser wrote:
> > I am having another problem though. Maybe you could help me with it. Now
> > I am trying to install a website. when running the command:
> >
> >         oi_manage ...... create_website
> >
> > I get this:
> >
> >         Cannot create object without existing file or 'new' permission
> >         [\c:\Apache\OI\conf/package_repository.perl] [write]
> >
> > It still fills the new directory, so I go on with the installation. the
> > test_db runs fine, but when running install_sql, I get the same error
> > message as above. Do you know how to fix this, or at least point me in
> > the right direction to some docs.
>
> Hm... I wonder if this has to do with path definitions. Can you
> define your website/repository directories like this instead:
>
>   --website_dir=c:/apache/OI/conf/package_repository.perl
>
> IIRC OI uses join( '/', $dir, $dir ) instead of File::Spec to
> create paths, and I think Win32 will do either '/' or '\' but not
> both in the same path.
>
> The fact that things worked is kind of weird though...
>
> Chris
>
> --
> Chris Winters (ch...@cw...)
> Building enterprise-capable snack solutions since 1988.
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Tablet PC.
> Does your code think in ink? You could win a Tablet PC.
> Get a free Tablet PC hat just for playing. What are you waiting for?
> http://ads.sourceforge.net/cgi-bin/redirect.pl?micr5043en
> _______________________________________________
> openinteract-help mailing list
> ope...@li...
> https://lists.sourceforge.net/lists/listinfo/openinteract-help

Re: [Openinteract-help] install OI on Win2K - ActiveState

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

oiser wrote:
> I am having another problem though. Maybe you could help me with it. Now
> I am trying to install a website. when running the command: 
> 
>         oi_manage ...... create_website
> 
> I get this:
> 
>         Cannot create object without existing file or 'new' permission
>         [\c:\Apache\OI\conf/package_repository.perl] [write]
> 
> It still fills the new directory, so I go on with the installation. the
> test_db runs fine, but when running install_sql, I get the same error
> message as above. Do you know how to fix this, or at least point me in
> the right direction to some docs.

Hm... I wonder if this has to do with path definitions. Can you 
define your website/repository directories like this instead:

  --website_dir=c:/apache/OI/conf/package_repository.perl

IIRC OI uses join( '/', $dir, $dir ) instead of File::Spec to 
create paths, and I think Win32 will do either '/' or '\' but not 
both in the same path.

The fact that things worked is kind of weird though...

Chris

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

[Openinteract-help] YAPC 2003

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

Good news -- I'm going to be able to make it to YAPC::NA this year! 
(Anyone else?) I'm preparing a submission for a talk on 
OpenInteract2 and am curious to hear if you have anything you'd like 
to hear about, or that you think would be good to emphasize.

Thanks,

Chris

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

Re: [Openinteract-help] install OI on Win2K - ActiveState

[oiser <oi...@ir...>]

Chris Winters <ch...@cw...> writes:

> Randy Kobes has compiled mod_perl, Apache::Request and a number of
> other modules into PPM format. You can grab them at:
> 
> http://theoryx5.uwinnipeg.ca/ppmpackages/
> 
> Note that Apache::Request is listed as libapreq.
> 
That's where I got my mod_perl ppm. I checked there last night, but
didn't see the libapreq package. I guess I didn't look hard enough. 

I got OI installed. Nmake worked like a charm. Thanks for your help.
-- 
Matt
oi...@ir...

Re: [Openinteract-help] install OI on Win2K - ActiveState

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

oiser wrote:
> Thanks for the link Chris. Nmake works fine. I used it to install
> Apache-Session and Date-Format, which were the only mods I couldn't
> get via ppm. The problem I'm having now is trying to get
> Apache-Request (libapreq) installed. This is the final requirement for
> me to install OI. The problem is that I found a ppm package for
> mod_perl, and so I don't have the source. Of course Makefile.PL
> complains about this, and I am unable to install libapreq. I realy
> don't want to have to compile Apache & mod_perl from source. Is there
> a way around this?

Randy Kobes has compiled mod_perl, Apache::Request and a number 
of other modules into PPM format. You can grab them at:

http://theoryx5.uwinnipeg.ca/ppmpackages/

Note that Apache::Request is listed as libapreq.

Chris

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

Re: [Openinteract-help] install OI on Win2K - ActiveState

[oiser <oi...@ir...>]

Chris Winters <ch...@cw...> writes:

> oiser wrote:

> > But there is no ppm available for OI itsself. Why would they provide
> > ppm's for people without a compiler, but still expect them to be able
> > to compile OI?
> 
> Believe it or not, nobody's ever brought that up before. Probably
> because you can download the 'nmake' utility from Microsoft and do the
> normal 'perl Makefile.PL; nmake; nmake install' without problem.
> 
> You can get nmake at:
> 
> http://download.microsoft.com/download/vc15/Patch/1.52/W95/EN-US/Nmake15.exe

<snip> 

> If using nmake doesn't work for you, ping the list back and I'll see
> what I can do.
> 

Thanks for the link Chris. Nmake works fine. I used it to install
Apache-Session and Date-Format, which were the only mods I couldn't
get via ppm. The problem I'm having now is trying to get
Apache-Request (libapreq) installed. This is the final requirement for
me to install OI. The problem is that I found a ppm package for
mod_perl, and so I don't have the source. Of course Makefile.PL
complains about this, and I am unable to install libapreq. I realy
don't want to have to compile Apache & mod_perl from source. Is there
a way around this?

Thanks IA. 
-- 
Matt
oi...@ir...

Re: [Openinteract-help] install OI on Win2K - ActiveState

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

oiser wrote:
> Is there a ppm for OI. I am trying to install on a Win2K laptop for
> use as a development environment. I don't have a compiler (I have
> cygwin, but make never works). I am a little confused by the INSTALL
> file. It says:
> 
 > ...
> 
> But there is no ppm available for OI itsself. Why would they provide
> ppm's for people without a compiler, but still expect them to be able
> to compile OI?

Believe it or not, nobody's ever brought that up before. Probably 
because you can download the 'nmake' utility from Microsoft and 
do the normal 'perl Makefile.PL; nmake; nmake install' without 
problem.

You can get nmake at:

http://download.microsoft.com/download/vc15/Patch/1.52/W95/EN-US/Nmake15.exe

It expands to nmake.exe, nmake.err and a README. Stick the .exe 
and .err files somewhere in your path (even in \perl\bin) and you 
should be golden.

Note that the CPAN shell (a Perl hacker's best friend) is also 
quite happy to use nmake.

One of the problems with creating a PPM is that there are a few 
additional files required (all the package tarballs) along with a 
script you need to install somewhere in your path (oi_manage). 
I'm not sure how to get PPM to do this, and since nobody's asked 
before I'm kind of inclined to remain ignorant of that knowledge.

If using nmake doesn't work for you, ping the list back and I'll 
see what I can do.

Chris

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

[Openinteract-help] install OI on Win2K - ActiveState

[oiser <oi...@ir...>]

Is there a ppm for OI. I am trying to install on a Win2K laptop for
use as a development environment. I don't have a compiler (I have
cygwin, but make never works). I am a little confused by the INSTALL
file. It says:

        (1) Run the normal perl install

        perl Makefile.PL
        make
        make test (no tests yet...)
        make install

Which of course I can't do. Then further down it says:

        OpenInteract uses a number of libraries, and all of them are
        readily available via CPAN. For those on Win32 systems without
        a compiler, most of them are also available via the PPM
        installation system. Some modules requiring compilation are
        not available via PPM and are available at:

        http://openinteract.sourceforge.net/

But there is no ppm available for OI itsself. Why would they provide
ppm's for people without a compiler, but still expect them to be able
to compile OI?

Am I missing something? Thanks in advance for any help.

-- 
Matt
oi...@ir...

Re: [Openinteract-help] Job tracking system

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

Thomas Whitney wrote:
> Chris,
> 
> Thanks for your prompt reply.   A few more questions.
> 
> I'm currently using  AuthDBI for security on the sight.  Can I use that
> database?

No, but it would be a piece of cake to migrate the data. OI uses 
session-based authentication with cookies rather than HTTP 
authentication.

> I'm using Apaceh::Session for session stuff and mySQL for the database.
> Overall I guess I wondering on the learning curve of OI and the porting from
> my current site to OI.  Will I have to port everything to use it?  One last
> question.  Does OI impose much overhead on the system?

Since OI uses standard Perl modules for many of the pieces -- 
session handling uses Apache::Session, view processing uses the 
Template Toolkit, parameter parsing (etc.) uses Apache::Request, 
etc. -- the only porting for those pieces should be simple, 
assuming that you've kept them fairly separate.

Porting your business logic (or whatever you'd like to call it) 
will be more of an effort. How much depends on the degree you've 
separated your tasks out already. So if you have a single method 
that does all create/update/delete actions for a single record, 
you will have quite a bit of work. But if you're using the same 
sort of paradigm that CGI::Application uses, it shouldn't be 
difficult at all.

As for the load: to my knowledge Andreas Nolte and his crew have 
  built the largest and most used system based on OI. If he says 
it scales well, I tend to believe him :-) What's useful is that 
all the helpful hints in the mod_perl guide are directly 
applicable, and OI comes out of the box configured to use the 
dual-server proxy setup the guide recommends.

Good luck!

Chris

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

Re: [Openinteract-help] Using SPOPS across multiple tables

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

Peter Dragon wrote:
> I've been trying to use SPOPS to retrieve fields from multiple tables, could
> you advise me on the best way to do this ?
> 
> It works fine for searching but I had difficuly getting fields from a
> secondary table, because they were not part of the primary SPOPS object. One
> way round it was to use the field alter in the SPOPS configuration file to
> assign the value to a new field, e.g when searching on a task but needing a
> related contact name.
>     'field_alter' => {
>       'tk_contact_name'       => 'contact.cn_name',
> 
> This worked alright on fetch but I couldn't get at contact name and SPOPS
> failed on the update even though I didn't want to update the secondary
> table.

SPOPS isn't really built to merge fields from multiple tables into a 
single object. Behind the scenes with SELECT statements it prepends 
the table name in front of everything so you can do a painless join 
statement in fetch_group().

That said, I'll look into it a little more deeply later.

Chris

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

AW: [Openinteract-help] Job tracking system

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

Hi Thomas,

within our division of arvato direct services - the Bertelsmann =
services
branch - we started using OpenInteract about 2 years ago and =
implemented as
one of our 1st applications an internal trouble ticketing system, which =
from
the start was designed to be a general tool to track anything, which is =
why
we called it NATS - Network Activity Tracking System.

The results were very successful and we now have even Callcenter
applications for e.g. bank or mobile phone customers of ours running on
OpenInteract or a Europe wide workflow system for controlling bills. In
short - OpenInteract is great !

On the downside is the usual bit: it is complex inside, which means =
that you
can write code, which does not scale well, if you are not carefully. =
Done
right though, OI scales pretty good.

Currently we are in the middle of a total rewrite of our first =
application
NATS to leverage our experience. The rollout is planned for April 1st. =
From
the design, NATS2 is a framework in itself, which has a concept of =
generic
task objects, which are handled in a business logic layer tuned for =
each
application. For example, one instance of NATS2 will be a =
troubleticketing
and billing system for our IT staff. Another instance will be a early =
flight
reservation system.

From reading through your notes, I think your app could fit in this. If =
you
are interested in this work, we are willing to share these efforts and
jointly work on this. But beware: there is not much of a documentation =
yet !

later,

Andreas Nolte
Leitung IT
-----------------------------------------------------------
arvato direct services=20
Olympiastra=DFe 1
26419 Schortens
Germany
http://www.arvato.com/

and...@be...
Phone   +49 (0) 4421 - 76- 84002
Fax	+49 (0) 4421 - 76- 84111



-----Urspr=FCngliche Nachricht-----
Von: Thomas Whitney [mailto:trw...@ce...]
Gesendet am: Freitag, 14. M=E4rz 2003 17:42
An: ope...@li...
Betreff: [Openinteract-help] Job tracking system

Hi,

I want to implement a job tracking and database publishing system and =
it is
going to be a fairly large task.  Therefore getting started on the =
right
path in the beginning is important.

My company does short run 4 color digital printing.  Because it is =
short urn
we handle multiple jobs every day.  I developed an online bidding =
system; it
use Apache, mod_perl, and  mysql.  Now I would like to move to tracking =
jobs
online; first, for internal purposes -- it would make the workflow much
easier to follow -- and later for customers to view the status of their =
jobs
on the web.  Each bid has about 38 data fields associated with it and =
each
job will have a few more fields along with an image file in the form of =
a
pdf.

I would like to create the job once approved from the bid.  Then each =
job
needs to be tracked through production with operators at each stage =
being
able to update its status or add notes.  After the job is finished an
invoice would be printed to go out with the job.  Web based =
applications are
good for this because we use Mac's and PC's, and both must be able to =
have
access to that job.

I currently use Template::Toolkit along with a few other Apache modules =
to
deal with the bidding. I could do all the programming myself-no single =
thing
it is that tough, naturally though, it would be helpful to have an =
existing
framework within which to develop.  It would help me to know what users =
of
OpenInteract think about its applicability to this project.

Thanks,
Thomas Whitney






-------------------------------------------------------
This SF.net email is sponsored by:Crypto Challenge is now open!=20
Get cracking and register here for some mind boggling fun and=20
the chance of winning an Apple iPod:
http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en
_______________________________________________
openinteract-help mailing list
ope...@li...
https://lists.sourceforge.net/lists/listinfo/openinteract-help

[Openinteract-help] Using SPOPS across multiple tables

[Peter D. <pet...@us...>]

I've been trying to use SPOPS to retrieve fields from multiple tables, could
you advise me on the best way to do this ?

It works fine for searching but I had difficuly getting fields from a
secondary table, because they were not part of the primary SPOPS object. One
way round it was to use the field alter in the SPOPS configuration file to
assign the value to a new field, e.g when searching on a task but needing a
related contact name.
    'field_alter' => {
      'tk_contact_name'       => 'contact.cn_name',

This worked alright on fetch but I couldn't get at contact name and SPOPS
failed on the update even though I didn't want to update the secondary
table.

Thanks,
Peter
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.443 / Virus Database: 248 - Release Date: 10/01/2003

Re: [Openinteract-help] Job tracking system

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

Thomas Whitney wrote:
 > ...
> I currently use Template::Toolkit along with a few other Apache modules to
> deal with the bidding. I could do all the programming myself-no single thing
> it is that tough, naturally though, it would be helpful to have an existing
> framework within which to develop.  It would help me to know what users of
> OpenInteract think about its applicability to this project.

I don't see anything in your explanation that would preclude OI. 
The benefits I see for you are:

  * You're already familiar with the Template Toolkit, so 
creating a new display, or porting your existing one, should be a 
piece of cake. OI makes some of the framework functionality 
available to your templates so any modifications would be 
additions to get new features.

  * Handlers (what actually does the work) generally concentrate 
on a small group of tasks (e.g., CRUD for a particular type of 
record) and have very little to do with the view. This makes it 
useful to divide-and-conquer with multiple developers.

  * OI has a simple but useful security model. This can be 
extremely useful when you're dealing with external users -- a 
bid, once accepted, could be turned into a job that only members 
of a 'employee' group (or something) can see. No worries about 
exposing internal process data to the user.

  * Processes can be secured in the same manner. So only 
employees could execute tasks which actually change the status of 
a job, for instance.

  * You don't have to deal with all the dispatching, 
authentication/authorization, session management, database 
management and other infrastructure items that can cause 
headaches. You're right that individually they aren't tough, but 
tying them all together can introduce some complexity.

As for similar applications I'm aware of: A German organization 
working for Bertelsmann created an IT trouble ticket management 
system for internal use. I've never seen it, but Andreas tells me 
it's pretty nifty [1].

Hope this was useful,

Chris

[1] 
https://sourceforge.net/mailarchive/forum.php?thread_id=557672&forum_id=3222

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

[Openinteract-help] Job tracking system

[Thomas W. <trw...@ce...>]

Hi,

I want to implement a job tracking and database publishing system and it is
going to be a fairly large task.  Therefore getting started on the right
path in the beginning is important.

My company does short run 4 color digital printing.  Because it is short urn
we handle multiple jobs every day.  I developed an online bidding system; it
use Apache, mod_perl, and  mysql.  Now I would like to move to tracking jobs
online; first, for internal purposes -- it would make the workflow much
easier to follow -- and later for customers to view the status of their jobs
on the web.  Each bid has about 38 data fields associated with it and each
job will have a few more fields along with an image file in the form of a
pdf.

I would like to create the job once approved from the bid.  Then each job
needs to be tracked through production with operators at each stage being
able to update its status or add notes.  After the job is finished an
invoice would be printed to go out with the job.  Web based applications are
good for this because we use Mac's and PC's, and both must be able to have
access to that job.

I currently use Template::Toolkit along with a few other Apache modules to
deal with the bidding. I could do all the programming myself-no single thing
it is that tough, naturally though, it would be helpful to have an existing
framework within which to develop.  It would help me to know what users of
OpenInteract think about its applicability to this project.

Thanks,
Thomas Whitney

[Openinteract-help] Re: SPOPS with more than one Database

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

Eric Veldhuyzen wrote:
> I am using SPOPS with PostgreSQL and so far it works great. I created a
> base class to have a global_datasource_handle and a lexical variable
> $DBH to contain the database handle, and all the real SPOPS classes use
> this class as a base class, just like in one of the examples.
> 
> But now I have the challange to copy some of the data from one database
> to another, and I would like to do that with SPOPS, but I don't want to
> create a separate database connection for each table (that wouldn't work
> anyway). So, does anyone here have any suggestions to solve this
> challange in a nice way?

You should just need one connection for each database. The easiest 
thing to do would probably be create two separate base classes with 
'global_datasource_handle' defined, each pointing to a different 
database. Then add the appropriate class as a parent in the 'isa' 
configuration list of the SPOPS class. For instance:

package My::DBOne;

use strict;
use DBI;

my ( $DBH );

sub global_datasource_handle {
     return $DBH if ( $DBH );
     $DBH = DBI->connect( ... );
     return $DBH;
}

package My::DBTwo;

use strict;
use DBI;

my ( $DBH );

sub global_datasource_handle {
     return $DBH if ( $DBH );
     $DBH = DBI->connect( ... );
     return $DBH;
}

Then:

my $config = {
    one => {
      class => 'originalOne',
      isa   => [ 'My::DBOne', 'SPOPS::DBI::Pg', 'SPOPS::DBI' ],
      ...
    },
    two => {
      class => 'copyTwo',
      isa   => [ 'My::DBTwo', 'SPOPS::DBI::Pg', 'SPOPS::DBI' ],
      ...
    },
};
SPOPS::Initialize->process({ config => $config });

  foreach my $orig ( @{ $one->fetch_group } ) {
      copyTwo->new( $orig )->save();
  }

Hope this makes sense...

Chris

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

[Openinteract-help] Job Tracking System

[Thomas W. <trw...@ce...>]

Hi,

I want to implement a job tracking system and it is going to be a fairly
large project.  Therefore getting started on the right path is important.

To that end I am looking at OpenInteract for this and would appreciate any
feedback from users as to how well they think it would fit my needs.

My company does short run 4 color digital printing.  Because it is short urn
we handle multiple jobs every day.  I developed an online bidding system; it
use Apache, mod_perl, and  mysql.  Now I would like to move to tracking jobs
online; first, for internal purposes -- it would make the workflow much
easier to follow -- and later for customers to view the status of their jobs
on the web.  Each bid has about 38 data fields associated with it and each
job will have a few more fields along with an image file in the form of a
pdf.

I would like to create the job once approved from the bid.  Then each job
needs to be tracked through production with operators at each stage being
able to update its status or add notes.  After the job is finished an
invoice would be printed to go out with the job.  Web based applications are
good for this because we use Mac's and PC's, and both must be able to have
access to that job.

I currently use Template::Toolkit along with a few other Apache modules to
deal with the bidding. I could do all the programming myself-no single task
seems that hard, naturally though, it would be helpful to have an existing
framework within which to develop.  It would help me to know what users of
OpenInteract think about its applicability to this project.

I would appreciate any thoughts or suggestions.

Thanks,
Thomas Whitney

Re: [Openinteract-help] typos in oi_manage --man

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

Jon wrote:
> In oi_manage --man, where the examples for remove_package are listed, 
> just after "if you want to truly eradicate your package" package is 
> spelt 'pacakage' twice in the shell examples.

Thanks for the pointer, will fix.

Chris

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

Re: [Openinteract-help] Serving a lot of sites within one OI system

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

Barry Hoggard wrote:
> I'm reading the documents, but before I get too deep, I want to see if 
> OI is likely to work for the system I'm designing.  I've started hosting 
> web sites for artists, and they each have a CMS for dealing with works, 
> images, etc.
> 
> I want to create a system where I only have one set of handlers, but 
> which CSS, HTML, and database records presented depend on the hostname. 
>  That is -- all of the sites point to one IP, and we switch depending on 
> which one it is.
> 
> Does it seems reasonable to build such a system with OI?  I'm wondering 
> about the ability to let someone only edit "their" objects within the 
> editing system using OI and SPOPS security.

It should be possible with a little work. I haven't done this 
before, but to get technical I think you'll have to do the following:

In the vhost config:

  * only set the 'PerlRequire' to execute on *one* vhost config
  * set all the other perl-specific entries in all vhost configs:
     <Perl>use lib...
     PerlSetVar
     <Location />...
  * add something like 'PerlSetVar CmsGroupId 4' to each one, 
varying the group ID based on the different vhost
  * add something like 'PerlSetVar CmsThemeId 4' to each one, 
varying the group ID based on the different vhost

Elsewhere:

  * create a group for each CMS defined
  * create a subclass of OpenInteract::Auth which overrides 
'group' and fetches the group object based on the CmsGroupId for 
that vhost
  * create a theme for each CMS defined; you can vary only the 
theme properties you need
  * create a subclass of OpenInteract that overrides 
'setup_theme' and fetches the theme object based on the 
CmsThemeId for that vhost
  * create a security policy so that every object that is secured 
sets the CmsGroupId to at least read and that the 'world' 
permissions are set to 'none'

The last one (relating to object security) is the only difficult 
one, and to be honest I've never tried implementing a security 
policy like this. In theory it's not that difficult, but...

Hope this helps,

Chris

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

Re: [Openinteract-help] oi_manage w/ apply_package, fails 'Website name not set in package object'

[Jon <jo...@3e...>]

At 22:57 10/03/2003 -0500, Chris Winters wrote:
>Jon wrote:
>>But All Of A Sudden:
>>[root@3evtowers demo]# oi_manage --base_dir=/usr/local/OpenInteract 
>>--website_dir=/home/httpd/OIdemo --package=demo apply_package
>>Running apply_package...
>>=========================
>>Status of the packages you requested to be applied:
>>demo (0.01)
>>   FAILED!: Cannot install package to website. Error: Website name not
>>            set in package object

{snip}

>That's very strange... this isn't set in the package itself (that is, the 
>'package.conf' file in the package), it's set into the information passed 
>to the relevant OI::Package routine. What's strange is that oi_manage 
>should read this information from your base configuration file -- sort of 
>a bootstrapping file that gets everything up and going. It should be in 
>$WEBSITE_DIR/conf/base.conf and have your website name defined. Does yours 
>have this field?

Mine didn't have the file, yet alone that field :)
I just posted the reason why in response to a message from Jan - 
essentially Apache hadn't been restarted fully and it had an old value for 
$BASE_CONFIG, so all bets were off.

But I still can't apply a package.  I deleted all of the web site 
directories and the dir where OI was installed, drop'ped the DB.  I went to 
the folder with the OI sources and reinstalled OI again.  Got it working 
fine with the base packages.  Went through the Developer's Guide, stuck 
again on apply_package:

[root@3evtowers oiOne]# oi_manage --website_dir /home/httpd/oi --package 
oiOne apply_package
[oi_manage]: Using (/usr/local/OpenInteract) for 'base_dir'.
Running apply_package...
=========================

Cannot save package repository: the OpenInteract base installation 
directory for package (-) is not specified or does not exist! at 
/usr/lib/perl5/site_perl/5.8.0/OpenInteract/PackageRepository.pm line 135.
Status of the packages you requested to be applied:
OK
FAILED!: Package could not be verified -- either it doesn't exist in
            base install or there's a problem with the base
            install package.{snip

That's essentially the problem, read on for more info}

[root@3evtowers oiOne]# oi_manage --website_dir=/home/httpd/oi 
--package=oiOne apply_package
[oi_manage]: Using (/usr/local/OpenInteract) for 'base_dir'.
Running apply_package...
=========================

Status of the packages you requested to be applied:
FAILED!: Cannot install package to website. Error: Package directory
            /home/httpd/oi/pkg/- already exists.
FAILED!: Package could not be verified -- either it doesn't exist in
            base install or there's a problem with the base
            install package.{snip}


[root@3evtowers oiOne]# oi_manage list_packages
[oi_manage]: Using (/usr/local/OpenInteract) for 'base_dir'.
Running list_packages...
{snip}
Package:   oiOne-0.01
Installed: 2003-03-11 15:55:31
Directory: /usr/local/OpenInteract/pkg/oiOne-0.01 {snip}

[root@3evtowers oiOne]# oi_manage --website_dir=/home/httpd/oi 
--package=oiOne test_db
{snip}
       -- Basic connect: ok
       -- Use database: ok
       -- Create table: ok {snip}

[root@3evtowers oiOne]# oi_manage --website_dir=/home/httpd/oi 
--package=oiOne install_sql
[oi_manage]: Using (/usr/local/OpenInteract) for 'base_dir'.
Running install_sql...
=========================

Cannot create object without existing file or 'new' permission 
[/home/httpd/oi/conf/package_repository.perl] [write] at 
/usr/lib/perl5/site_perl/5.8.0/SPOPS/Exception.pm line 80, <CONF> line 24.

[root@3evtowers oiOne]# ls -ls /home/httpd/oi/conf/package_repository*
   16 -rw-r--r--    1 root     root        15990 Mar 11 15:57 
/home/httpd/oi/conf/package_repository.perl.backup
   16 -rw-r--r--    1 root     root        15990 Mar 11 12:55 
/home/httpd/oi/conf/package_repository.perl.tmp

Looks like earlier barf left package_repository.perl nicely backed-up 
before a premature exit, so now the httpd wont start.

TIA
jon

[Openinteract-help] Re: Cannot find configuration object from stash class

[Jon <jo...@3e...>]

In this thread from Jan:

"Cannot find configuration object from stash class"
http://sourceforge.net/mailarchive/message.php?msg_id=2941630

FYI I got the same error.  As Chris mentions in his reply server (not 
vhost) error logs give me:

[Tue Mar 11 14:17:08 2003] [error] Cannot create base configuration from 
(/home/httpd/OItest)! at 
/usr/lib/perl5/site_perl/5.8.0/OpenInteract/ApacheStartup.pm

This explains a lot for me as /home/httpd/OItest was where my website 
*was*.   $BASE_CONFIG in conf/startup.pl was pointing at my new site 
however - so Apache/mod_perl still had the old value in memory.  As 
mentioned in the admin guide, you shouldn't restart the server with a HUP :)

I'm on RedHat 8 with Apache in /usr/local/, so I do:

[root@3evtowers oi]# /usr/local/apache/bin/apachectl stop
/usr/local/apache/bin/apachectl stop: httpd stopped
[root@3evtowers oi]# /usr/local/apache/bin/apachectl start
Using a hash as a reference is deprecated at 
/usr/lib/perl5/site_perl/5.8.0/SPOPS/HashFile.pm line 116.
/usr/local/apache/bin/apachectl start: httpd started

... instead of ..

[root@3evtowers oi]# /usr/local/apache/bin/apachectl restart
/usr/local/apache/bin/apachectl restart: httpd restarted
[root@3evtowers oi]#

The lack of the suprious warning message was a bit of a clue *not* to use 
'restart' :)

jon

  Chris McDaniel wrote:
  > After installing a new package and fixing a few bugs in it, I get -
  >
  > Cannot find configuration object from stash class (commerce::Stash). Cannot
  > continue! at /var/www/localperl/lib/site_perl/5.6.1/OpenInteract.pm 
line 91.
  >
  > on the website, but nothing in the logs.  This is OI-1.54 - Anyone know 
what
  > I did wrong?

  IIRC this means the stash wasn't created properly, which means
  something's borked in the startup procedure. Your server (not
  vhost) error logs should provide illumination.

  Chris W

[Openinteract-help] Serving a lot of sites within one OI system

[Barry H. <ba...@tr...>]

I'm reading the documents, but before I get too deep, I want to see if 
OI is likely to work for the system I'm designing.  I've started 
hosting web sites for artists, and they each have a CMS for dealing 
with works, images, etc.

I want to create a system where I only have one set of handlers, but 
which CSS, HTML, and database records presented depend on the hostname. 
  That is -- all of the sites point to one IP, and we switch depending 
on which one it is.

Does it seems reasonable to build such a system with OI?  I'm wondering 
about the ability to let someone only edit "their" objects within the 
editing system using OI and SPOPS security.


--
Barry Hoggard
Tristan Media LLC
e: ba...@tr...
aim: hoggardb