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

Re: [Openinteract-help] Authorisation problem

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

On Wed, 2002-04-10 at 08:55, Jure Simsic wrote:
> ...
> No mention about cookies anywhere..
> 
> And another thing, as I try to add an user into "public" group i get:
> Found item: Apache::DBI::db
> OpenInteract::CommonHandler::edit (564) >> Object (group) save failed: 
> DBD::Pg::st execute failed: ERROR:  ExecAppend: Fail to add null value 
> in not null attribute name at 
> /usr/local/share/perl/5.6.1/SPOPS/SQLInterface.pm line 284.
>   (DBD::Pg::st execute failed: ERROR:  ExecAppend: Fail to add null 
> value in not null attribute name at 
> /usr/local/share/perl/5.6.1/SPOPS/SQLInterface.pm line 284.
> )
> 
> Does this ring any bells? Obviously something to do with a violation of 
> a table constraint..What pkg deals with adding users into groups?

This is strange. I don't know why the 'name' field would be null/empty.
What happens if you just try to edit the group without adding/removing
any users?

One thought: make sure you've run:

 > export OIWEBSITE=/path/to/yoursite
 > oi_manage change_spops_driver --driver=SPOPS::DBI::Pg

The next version of OI will do away with this, relying on the datasource
in the server configuration instead.

Chris

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

[Fwd: Re: [Openinteract-help] Authorisation problem]

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

Accidentally hit 'reply' instead of 'reply to all'...

-----Forwarded Message-----

From: Chris Winters <ch...@cw...>
To: Jure Simsic <jur...@li...>
Subject: Re: [Openinteract-help] Authorisation problem
Date: 10 Apr 2002 08:29:34 -0400

On Wed, 2002-04-10 at 07:10, Jure Simsic wrote:
> Hi, I'm just starting with OI and have installed a vanilla site. The 
> problem I have is tahat whenever I follow a link my login info is gone, 
> I get the login window again and when I login again, tha page gets 
> displayed as it should. In error log I get:
> 
> OpenInteract::UI::Main::handler (41) >> Action died. Here is what it 
> left: <div align="center">
> 
> <h1>Task is Forbidden</h1>...
> 
> In my server.ini I have:
> [session_info]
> class       = Apache::Session::Postgres
> expiration  = +3M
> params      =
> expires_in  = 0
> cache_user  = 30
> cache_group = 30
> cache_theme = 30
> 
> Can anyone point me in the right direction?

It sounds like your sessions aren't working or your browser isn't
accepting cookies. Are there any error messages in the log
($WEBSITE_DIR/log/error_log_modperl) to indicate that the cookies aren't
being saved? Such a message would be toward the end of a request. You
might also look in the 'sessions' table in your DB to see if there are
entries there.

Walking through this thread might also help:

http://sourceforge.net/mailarchive/forum.php?thread_id=536803&forum_id=3223

Chris

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

[Openinteract-help] Authorisation problem

[Jure S. <jur...@li...>]

Hi, I'm just starting with OI and have installed a vanilla site. The 
problem I have is tahat whenever I follow a link my login info is gone, 
I get the login window again and when I login again, tha page gets 
displayed as it should. In error log I get:

OpenInteract::UI::Main::handler (41) >> Action died. Here is what it 
left: <div align="center">

<h1>Task is Forbidden</h1>...

In my server.ini I have:
[session_info]
class       = Apache::Session::Postgres
expiration  = +3M
params      =
expires_in  = 0
cache_user  = 30
cache_group = 30
cache_theme = 30

Can anyone point me in the right direction?

Jure

[Openinteract-help] OI on Oracle

[Ben A. <be...@th...>]

I'm going ahead with using OI on this project, but need to use it with
Oracle (8i Enterprise). 
I understand SPOPS itself is okay with Oracle, but not OI yet. Is that
right?
I'm happy to do the work necessary to port OI to Oracle, but might need a
little help, as I don't have too much surplus time on this project.

I've been looking through the files in the website I've created with
oi_manage, to identify pieces of code which will need modification. The SQL
in the .sql files in /struct dirs mostly won't work with Oracle, these will
be easy to convert, however.

Could you help me identify any other places where DB-specific code is
located, and any new modules that will need to be created to handle
Oracle-specific code, and even any considerations you've come across in
porting OI between DBs?

----------------------------------------------------------------
Ben Avery			YouthNet UK	
Analyst/Programmer		2nd Floor
YouthNet UK			Broadmead House
Tel:+44 020 7925 2530		21 - 23 Panton Street
Fax:+44 020 7925 2830		London SW1Y 4DR              

e-mail:be...@th...
www.thesite.org.uk 
www.do-it.org.uk
www.youthnet.org.uk
----------------------------------------------------------------

Re: [Openinteract-help] where is base_main?

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

[cc'd back to openinteract-help list]

On Thu, 2002-03-21 at 14:15, tr...@ab... wrote:
> ...
> But I need to ask you a question or two, if you don't mind.
> 
> OI seems really to have alot..
> I need OI or something like it ( eg Zope? ) I need to get my app off the
> ground fast ... like to be able to have sessin handling, user, app dev
> logging ....
> 
> trying to find a infrastructure to build an open source chemical tracking
> system.
> 
> anyway... can you explain something ?
> How do you seperate the logon for site management and login for application
> usage ....

If I understand what you're saying correctly, you don't. The users for
site management and the site users are drawn from the same pool.
Generally, you assign the users you want to admin the site to the 'site
admin' group -- most admin actions are already setup so that members of
this group have appropriate permission.
 
> when I go to the base url .. you are logged into OI...
> I don't want that to be the default ... I want my app to be the default and
> url/admin to take me to the OI interface.

It sounds like you want to modify the boxes displayed by URL. Or do you
want the full template to change based on URL?

> How to build by own web app on top of OI? This is the part giving me
> trouble...
> I have been looking at so many tools my head is spinning ...
> Can you clear it up for me.

Generally, your app is in one or more packages. For instance, I'm
developing a contact database -- people, phone numbers, addresses, email
addresses, etc -- in the package 'contact'. In that package I have a
file (conf/action.perl) that maps top-level URLs to code, something
like:

$action = {
   person => {
      class => 'OpenInteract::Handler::Person',
      method => 'handler',
   },
};
 
In that package I create a module 'OpenInteract::Handler::Person' which
inherits from either 'OpenInteract::Handler::GenericDispatcher' or
'OpenInteract::CommonHandler' (more high-level stuff). These packages
look at the URL and dispatch the request to the appropriate subroutine.
So:

  http://mysite/Person/show/

Generally gets sent to OpenInteract::Handler::Person->show()

From there you have access to the OI environment (user, theme, session,
security, templating) from which you generate content.

It's probably easiest to look at an example. Take a look at the
'classified' package that's shipped with OI.

Good luck!

Chris 

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

Re: [Openinteract-help] where is base_main?

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

On Wed, 2002-03-20 at 14:28, tr...@ab... wrote:
> Why is it that base_main template that is in the Templates Used box,
> not show no the List Templates command?

Currently the website templates (those that don't belong to a package)
are not editable via the web interface. You need to edit them via the
filesystem -- directly using an editor or locally and then FTP them to
your site.

> How do create a web site that is empty ... would this still contain the
> login and such ... (eg the splash about OI with going to that URL )?

Just edit the 'base_main' template and everything should be clear. All
it really needs to display content is the '[% page.content %]' tag -- in
fact that's pretty much all the 'base_simple' template has.

Chris

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

[Openinteract-help] where is base_main?

[<tr...@ab...>]

Why is it that base_main template that is in the Templates Used box,
not show no the List Templates command?

How do create a web site that is empty ... would this still contain the
login and such ... (eg the splash about OI with going to that URL )?

RE: [Openinteract-help] OI fruit example problem

[Ben A. <be...@th...>]

Chris,

thanks for the quick response again.


> 
> BTW: Can you tell me the difference between 'varchar' and 
> 'varchar2' in
> Oracle? Why did they use this datatype when every other database I've
> used has found 'varchar' sufficient for their needs?

varchar is an ANSI standard, which Oracle's datatype doesn't _exactly_
match. to quote from my Oracle Bible, 'Mastering Oracle 8i' by R. Freeman:
currently, VARCHAR is synonymous with VARCHAR2. However, in future releases
of PL/SQL, to accommodate emerging SQL standards, VARCHAR might become a
separate datatype with different comparison semantics. So, it is a good idea
so use VARCHAR2 rather than VARCHAR.

I'm no expert, but feel free to throw any Oracle questions my way, and I'll
see what I can do.


> 
> >       Data: 
> >         * Error: Cannot create SPOPS object!
> >       Basic: DBD::Oracle::db prepare failed: ORA-00942:
> >       table or view does not exist (DBD ERROR:
> >       OCIStmtExecute/Describe) at
> >       /usr/local/lib/perl5/site_perl/5.6.1/SPOPS/SQLInterfa
> >       ce.pm line 116.
> >       
> >       Error: DBD::Oracle::db prepare failed: ORA-00942:
> >       table or view does not exist (DBD ERROR:
> >       OCIStmtExecute/Describe) at
> >       /usr/local/lib/perl5/site_perl/5.6.1/SPOPS/SQLInterfa
> >       ce.pm line 116.
> 
> This is the third error. I'd guess that maybe oracle expects 
> a different
> table name? Does oracle use a user.table or schema.table syntax for
> referring to tables in a INSERT/SELECT fashion?
> 
> What happens when you do a table descriptor operation in SQL-Plus?
> (Sorry for the inexact terminology, I'm not familiar with Oracle at
> all.) Do you see the 'fruit' table? What happens if you try to insert
> values to the 'fruit' table from the SQL-Plus tool?
> 
SQL*Plus is a command line SQL and PL/SQL language interface and reporting
tool, which allows SQL statements, PL/SQL (Procedural Language extension to
SQL), and also SQL*Plus interface control commands.
For this case, you can assume I'm only using it to run standard SQL
statements.
You can run any SELECT, INSERT SQL commands through it, just as - I imagine
- with other databases.

The Oracle errors above have occurred where a SELECT, INSERT etc statement
has been called on a table which doesn't exist in the database.

Do you know what SQL the 'oi_manage [...] install_sql' command is attempting
to run here?



> > What is the 'page' object it is trying to access in the 
> database? Where does
> > it get this from?
> 
> First error explained: This probably means you haven't run install_sql
> for all the other packages. When OI starts up it tries to dynamically
> find the fields in a number of tables, one of which is the 
> 'page' table.
> 
> However, if you do run 'install_sql' for the other packages you might
> run into the same issue.
> 
yep, trying to run oi_manage [...] install_sql for the page package also
gives me the following error:

WARNING executing manipulate_configuration for test_cares::Page
Cannot discover fields
 -> SELECT * FROM page WHERE 1 = 0
 -> DBD::Oracle::db prepare failed: ORA-00942: table or view does not exist
(DBD ERROR: OCIStmtExecute/Describe) at
/usr/local/lib/perl5/site_perl/5.6.1/OpenInteract/SPOPS/DBI.pm line 56.

this seems a circular problem! does the OI Developer's Guide fruit example
run exactly as given on other DBs? or am I supposed to install these other
packages as well?
how do other DB-based systems avoid this problem? does running oi_manage
start up OI? and if not, why does it looks for the page table, among others?

has anyone else shared similar setup difficulties?


----------------------------------------------
Ben Avery, 	Analyst/Programmer,   YouthNet UK	
		

Re: [Openinteract-help] OI fruit example problem

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

On Wed, 2002-03-20 at 08:16, Ben Avery wrote:
> I'm still working through the fruit example, and have hit another problem:
> everything is fine, until the SQL Install stage.
> 
> I'm pretty sure I've followed the example exactly, but I get this error:
> 
> 
> $ oi_manage --package fruit install_sql
> [oi_manage]: Using (/export/home/openinteract) for 'base_dir'.
> [oi_manage]: Using (/export/home/cares/test) for 'website_dir'.
> Running install_sql...
> =========================
> 
> OpenInteract::DBI::connect (41) >> DBI::connect >> Connected ok
> OpenInteract::DBI::connect (41) >> DBI::connect >> Connected ok
> WARNING executing manipulate_configuration for test_cares::Page
> Cannot discover fields
>  -> SELECT * FROM page WHERE 1 = 0
>  -> DBD::Oracle::db prepare failed: ORA-00942: table or view does not exist
>
> (DBD ERROR: OCIStmtExecute/Describe) at
> /usr/local/lib/perl5/site_perl/5.6.1/OpenInteract/SPOPS/DBI.pm line 56.
> 
> Process will continue
> Status of the packages requested for SQL install:

Right -- this is one error (explained below).

> fruit (0.06)
>   OK: 
>       
>       Structure:
>         * Cannot execute table SQL
>       CREATE TABLE fruit (
>       id NUMBER(10),
>       name VARCHAR2(255),
>       taste VARCHAR2(255),
>       price VARCHAR2(255)
>       )
>       
>       Error: DBD::Oracle::db do failed: ORA-00955: name is
>       already used by an existing object (DBD ERROR:
>       OCIStmtExecute) at
>       /usr/local/lib/perl5/site_perl/5.6.1/OpenInteract/SQL
>       Install.pm line 136.

This is the second error, and sounds like the fruit table already
exists.

BTW: Can you tell me the difference between 'varchar' and 'varchar2' in
Oracle? Why did they use this datatype when every other database I've
used has found 'varchar' sufficient for their needs?

>       Data: 
>         * Error: Cannot create SPOPS object!
>       Basic: DBD::Oracle::db prepare failed: ORA-00942:
>       table or view does not exist (DBD ERROR:
>       OCIStmtExecute/Describe) at
>       /usr/local/lib/perl5/site_perl/5.6.1/SPOPS/SQLInterfa
>       ce.pm line 116.
>       
>       Error: DBD::Oracle::db prepare failed: ORA-00942:
>       table or view does not exist (DBD ERROR:
>       OCIStmtExecute/Describe) at
>       /usr/local/lib/perl5/site_perl/5.6.1/SPOPS/SQLInterfa
>       ce.pm line 116.

This is the third error. I'd guess that maybe oracle expects a different
table name? Does oracle use a user.table or schema.table syntax for
referring to tables in a INSERT/SELECT fashion?

What happens when you do a table descriptor operation in SQL-Plus?
(Sorry for the inexact terminology, I'm not familiar with Oracle at
all.) Do you see the 'fruit' table? What happens if you try to insert
values to the 'fruit' table from the SQL-Plus tool?

> What is the 'page' object it is trying to access in the database? Where does
> it get this from?

First error explained: This probably means you haven't run install_sql
for all the other packages. When OI starts up it tries to dynamically
find the fields in a number of tables, one of which is the 'page' table.

However, if you do run 'install_sql' for the other packages you might
run into the same issue.

I might see if I can learn just enough about Oracle to try this myself.
I think we still have an Oracle database instance running somewhere
around here.

Thanks,

Chris

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

[Openinteract-help] OI fruit example problem

[Ben A. <be...@th...>]

I'm still working through the fruit example, and have hit another problem:
everything is fine, until the SQL Install stage.

I'm pretty sure I've followed the example exactly, but I get this error:


$ oi_manage --package fruit install_sql
[oi_manage]: Using (/export/home/openinteract) for 'base_dir'.
[oi_manage]: Using (/export/home/cares/test) for 'website_dir'.
Running install_sql...
=========================

OpenInteract::DBI::connect (41) >> DBI::connect >> Connected ok
OpenInteract::DBI::connect (41) >> DBI::connect >> Connected ok
WARNING executing manipulate_configuration for test_cares::Page
Cannot discover fields
 -> SELECT * FROM page WHERE 1 = 0
 -> DBD::Oracle::db prepare failed: ORA-00942: table or view does not exist
(DBD ERROR: OCIStmtExecute/Describe) at
/usr/local/lib/perl5/site_perl/5.6.1/OpenInteract/SPOPS/DBI.pm line 56.

Process will continue
Status of the packages requested for SQL install:

fruit (0.06)
  OK: 
      
      Structure:
        * Cannot execute table SQL
      CREATE TABLE fruit (
      id NUMBER(10),
      name VARCHAR2(255),
      taste VARCHAR2(255),
      price VARCHAR2(255)
      )
      
      Error: DBD::Oracle::db do failed: ORA-00955: name is
      already used by an existing object (DBD ERROR:
      OCIStmtExecute) at
      /usr/local/lib/perl5/site_perl/5.6.1/OpenInteract/SQL
      Install.pm line 136.
      
      Data: 
        * Error: Cannot create SPOPS object!
      Basic: DBD::Oracle::db prepare failed: ORA-00942:
      table or view does not exist (DBD ERROR:
      OCIStmtExecute/Describe) at
      /usr/local/lib/perl5/site_perl/5.6.1/SPOPS/SQLInterfa
      ce.pm line 116.
      
      Error: DBD::Oracle::db prepare failed: ORA-00942:
      table or view does not exist (DBD ERROR:
      OCIStmtExecute/Describe) at
      /usr/local/lib/perl5/site_perl/5.6.1/SPOPS/SQLInterfa
      ce.pm line 116.
      
      
What is the 'page' object it is trying to access in the database? Where does
it get this from?

----------------------------------------------------------------
Ben Avery			YouthNet UK	
Analyst/Programmer		2nd Floor
YouthNet UK			Broadmead House
Tel:+44 020 7925 2530		21 - 23 Panton Street
Fax:+44 020 7925 2830		London SW1Y 4DR              

e-mail:be...@th...
www.thesite.org.uk 
www.do-it.org.uk
www.youthnet.org.uk
----------------------------------------------------------------

RE: [Openinteract-help] Oracle DB setup problems --sorted!

[Ben A. <be...@th...>]

On Mon, 2002-03-18 at 13:27, Ben Avery wrote:
> does anyone have experience of setting up OI on Oracle?
> 
> I am still working through the 'fruit' test package, but cannot manage to
> build a database table.
> this is the output from the test_db stage:
> 
> /export/home/oi_dev/fruit $ oi_manage --package fruit test_db
> 
> [oi_manage]: Using (/export/home/openinteract) for 'base_dir'.
> [oi_manage]: Using (/export/home/cares/test) for 'website_dir'.
> Running test_db...
> =========================
> 
> DBD::Oracle::db do failed: ORA-00900: invalid SQL statement (DBD ERROR:
> OCIStmtExecute) at
/usr/local/lib/perl5/site_perl/5.6.1/OpenInteract/DBI.pm
> line 47.
> Status of the database test:
> 
> FAILED!: 
>            Status of connection <<main>> (default
>            connection) 
>            =========================
>            -- Basic connect: ok
>            -- Use database: failed -- ORA-00900: invalid
>            SQL statement (DBD ERROR: OCIStmtExecute)
>            -- Create table: not attempted
> 
> =========================

Unfortunately you're going to be a bit of a guinea pig here, since I've
never installed OI on Oracle before.

However, you can probably get around this error by leaving the
'db_info.main.db_name' key empty in the server configuration. IIRC,
Oracle generally specifies this in the DSN or an environment variable,
so you don't need to do so.

Chris

___________

Chris, 

yep, spot on! (it actually took me longer to find out what IIRC meant :-)


Oracle has no 'use' command, and OpenInteract::DBI will die() if the db_name
key is set in conf/server.ini.

making a connection to Oracle requires 3 parameters: username/password@host
So, for example, if I connected to Oracle with: oi_test/PaSsWoRd@TEST1
then the db_info section of my conf/server.ini file would look like this:

[db_info main]
db_owner      =
username      =oi_test
password      =PaSsWoRd
dsn           =TEST1
db_name       =
driver_name   =Oracle


cheers,

Ben

Re: [Openinteract-help] How does my httpd_static.conf & httpd_modperl.conf with my httpsd.conf

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

On Mon, 2002-03-18 at 14:26, tr...@ab... wrote:
> Let see if I understand ... every website with have there own
> httpd_static.conf &
> httpd_modperl.conf
> 
> These files are edited to match site.
> 
> Then they must be include in the real httpsd.conf
> 
> how are rest of you doing this ...
> cut and paste
> some kind of include feature
> 
> help clarification will be appreciated

The real httpd.conf (or httpsd.conf) just has something like:

# Static/proxy configuration 
Include /home/httpd/mysite/conf/httpd_static.conf

# Modperl configuration
Include /home/httpd/mysite/conf/httpd_modperl.conf

Works like a charm. For more information on the Include directive, see:

 http://httpd.apache.org/docs/mod/core.html#include

And for more about all the directives:

 http://httpd.apache.org/docs/mod/directives.html

Chris

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

[Openinteract-help] How does my httpd_static.conf & httpd_modperl.conf with my httpsd.conf

[<tr...@ab...>]

Let see if I understand ... every website with have there own
httpd_static.conf &
httpd_modperl.conf

These files are edited to match site.

Then they must be include in the real httpsd.conf

how are rest of you doing this ...
cut and paste
some kind of include feature

help clarification will be appreciated

thanks

Re: [Openinteract-help] Oracle DB setup problems

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

On Mon, 2002-03-18 at 13:27, Ben Avery wrote:
> does anyone have experience of setting up OI on Oracle?
> 
> I am still working through the 'fruit' test package, but cannot manage to
> build a database table.
> this is the output from the test_db stage:
> 
> /export/home/oi_dev/fruit $ oi_manage --package fruit test_db
> 
> [oi_manage]: Using (/export/home/openinteract) for 'base_dir'.
> [oi_manage]: Using (/export/home/cares/test) for 'website_dir'.
> Running test_db...
> =========================
> 
> DBD::Oracle::db do failed: ORA-00900: invalid SQL statement (DBD ERROR:
> OCIStmtExecute) at /usr/local/lib/perl5/site_perl/5.6.1/OpenInteract/DBI.pm
> line 47.
> Status of the database test:
> 
> FAILED!: 
>            Status of connection <<main>> (default
>            connection) 
>            =========================
>            -- Basic connect: ok
>            -- Use database: failed -- ORA-00900: invalid
>            SQL statement (DBD ERROR: OCIStmtExecute)
>            -- Create table: not attempted
> 
> =========================
> Finished test_db!
> 
> the table SQL is:
> 
> /export/home/oi_dev/fruit $ cat struct/create-table-fruit.sql   
> create table fruit (
> id NUMBER(10),
> name VARCHAR2(255),
> taste VARCHAR2(255),
> price VARCHAR2(255)
> )
> 
> this SQL creates the table with no problems in SQL*PLUS.
> 
> does anyone have any ideas? do I have to format or terminate the SQL in a
> certain way?

Unfortunately you're going to be a bit of a guinea pig here, since I've
never installed OI on Oracle before.

However, you can probably get around this error by leaving the
'db_info.main.db_name' key empty in the server configuration. IIRC,
Oracle generally specifies this in the DSN or an environment variable,
so you don't need to do so.

Chris

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

[Openinteract-help] Oracle DB setup problems

[Ben A. <be...@th...>]

does anyone have experience of setting up OI on Oracle?

I am still working through the 'fruit' test package, but cannot manage to
build a database table.
this is the output from the test_db stage:

/export/home/oi_dev/fruit $ oi_manage --package fruit test_db

[oi_manage]: Using (/export/home/openinteract) for 'base_dir'.
[oi_manage]: Using (/export/home/cares/test) for 'website_dir'.
Running test_db...
=========================

DBD::Oracle::db do failed: ORA-00900: invalid SQL statement (DBD ERROR:
OCIStmtExecute) at /usr/local/lib/perl5/site_perl/5.6.1/OpenInteract/DBI.pm
line 47.
Status of the database test:

FAILED!: 
           Status of connection <<main>> (default
           connection) 
           =========================
           -- Basic connect: ok
           -- Use database: failed -- ORA-00900: invalid
           SQL statement (DBD ERROR: OCIStmtExecute)
           -- Create table: not attempted

=========================
Finished test_db!

the table SQL is:

/export/home/oi_dev/fruit $ cat struct/create-table-fruit.sql   
create table fruit (
id NUMBER(10),
name VARCHAR2(255),
taste VARCHAR2(255),
price VARCHAR2(255)
)

this SQL creates the table with no problems in SQL*PLUS.

does anyone have any ideas? do I have to format or terminate the SQL in a
certain way?


----------------------------------------------------------------
Ben Avery			YouthNet UK	
www.thesite.org
----------------------------------------------------------------

[Openinteract-help] RE: DBI.pm Test failed .... I got it ... dns must be dbname=

[<tr...@ab...>]

this was just a little confusing

[Openinteract-help] Failed Postgres testdb -DBD Pg 1.01 / DBI 1.21 (error in DBI.pm)

[<tr...@ab...>]

[root@iota oi]# oi_manage --website_dir=/u01/www/prod/oiRunning test_db...
=========================

DBI->connect(pgsql) failed: missing "=" after "pgsql" in/DBI.pm line 39
Status of the database test:

FAILED!:
           Status of connection <<main>> (default
           connection)
           =========================
           -- Other failure: Can't call method "do" on a           undefined
value at
           /usr/lib/perl5/site_perl/5.6.1/OpenInteract/D           pm line
           47.

=========================
Finished test_db!


any idea's

Re: [Openinteract-help] Can't "Make" 1.39 Openinteract ? template.pm required ???

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

On Wed, 2002-03-13 at 13:27, tr...@ab... wrote:
> Need a little clarification
> 
> I think ... after 2 days go all the modules for Openinteract
> I wish there was a bundle with all that in it ....

Well, there is a 'Bundle::OpenInteract' you can use from your CPAN shell
or via the command line:

 $ perl -MCPAN -e 'install Bundle::OpenInteract'

This should install all the necessary modules for you.

> Anyway ... it still comlains about template.pm ... and I am not sure what is
> talking about ... the one on CPAN for Openinteract says its depreicated
> the others template seem to be part of something else ....
> Openinteract says in contains template .....

You probably need to install the Template Toolkit, which is available
via CPAN as well.

Chris

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

[Openinteract-help] Can't "Make" 1.39 Openinteract ? template.pm required ???

[<tr...@ab...>]

Need a little clarification

I think ... after 2 days go all the modules for Openinteract
I wish there was a bundle with all that in it ....

Anyway ... it still comlains about template.pm ... and I am not sure what is
talking about ... the one on CPAN for Openinteract says its depreicated
the others template seem to be part of something else ....
Openinteract says in contains template .....

Any idea's

Re: [Openinteract-help] Can make SPOPS ... Storable 1 not found

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

On Tue, 2002-03-12 at 17:49, tr...@ab... wrote:
> Writing Makefile for Bundle::SPOPS
> [root@iota Bundle-SPOPS-1.10]# make
> cp SPOPS.pm blib/lib/Bundle/SPOPS.pm
> Manifying blib/man3/Bundle::SPOPS.3pm
> [root@iota Bundle-SPOPS-1.10]# make install
> Installing /usr/lib/perl5/site_perl/5.6.0/Bundle/SPOPS.pm
> Installing /usr/share/man/man3/Bundle::SPOPS.3pm
> Writing /usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/Bundle/SPOPS/.packlist
> Appending installation info to /usr/lib/perl5/5.6.0/i386-linux/perllocal.pod
> [root@iota Bundle-SPOPS-1.10]# cd ..
> [root@iota cpan]# cd ../SPOPS-0.57
> [root@iota SPOPS-0.57]# perl Makefile.PL
> You appear to have an existing configuration file. Re-use it? (Y/n) <Y>
> Warning: prerequisite Storable 1 not found. We have 0.611 at
> /usr/lib/perl5/5.6.0/ExtUtils/MakeMaker.pm line 274, <STDIN> line 1.
> Writing Makefile for SPOPS
> 
> Anybody seen this?

Can you install a new version of Storable? 0.611 is pretty old...

C

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

[Openinteract-help] Can make SPOPS ... Storable 1 not found

[<tr...@ab...>]

Writing Makefile for Bundle::SPOPS
[root@iota Bundle-SPOPS-1.10]# make
cp SPOPS.pm blib/lib/Bundle/SPOPS.pm
Manifying blib/man3/Bundle::SPOPS.3pm
[root@iota Bundle-SPOPS-1.10]# make install
Installing /usr/lib/perl5/site_perl/5.6.0/Bundle/SPOPS.pm
Installing /usr/share/man/man3/Bundle::SPOPS.3pm
Writing /usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/Bundle/SPOPS/.packlist
Appending installation info to /usr/lib/perl5/5.6.0/i386-linux/perllocal.pod
[root@iota Bundle-SPOPS-1.10]# cd ..
[root@iota cpan]# cd ../SPOPS-0.57
[root@iota SPOPS-0.57]# perl Makefile.PL
You appear to have an existing configuration file. Re-use it? (Y/n) <Y>
Warning: prerequisite Storable 1 not found. We have 0.611 at
/usr/lib/perl5/5.6.0/ExtUtils/MakeMaker.pm line 274, <STDIN> line 1.
Writing Makefile for SPOPS

Anybody seen this?

Re: [Openinteract-help] Can't locate loadable object for HTML::Parser

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

On Tue, 2002-03-12 at 14:39, Matt Olson wrote:
> Okay... now I'm getting a bunch of "can't insert duplicate key"
> type errors from the partial success of previous runs, that's
> (I guess) acceptable.  And I get a superuser username and a
> random password.  Not bad!

Excellent! If you want a clean run (which is probably a good idea), then
you can just drop the database, recreate it and run install_sql again.
 
> Moral of this story: if you've (well, I've :-) just installed
> something, and it isn't working, check file permissions.
> Especially if the error is "can't locate" or "can't open".

I've actually never had this problem. Not because I'm thorough or
anything, I just figured the 'make install' process ensures that file
permissions are at least 444 for everything a module needs. Maybe this
is a umask issue. (I'm seeing umask issues around every corner now :-).

Chris

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

Re: [Openinteract-help] Can't locate loadable object for HTML::Parser

[Matt O. <ma...@sh...>]

On Mon, Mar 11, 2002 at 11:19:34PM -0500, Chris Winters wrote:

> > What's bugging me is that, as far as I can tell, HTML::Parser
> > is properly installed.
>  
> Weird. One question: how do you know it's installed? 

root@shub-niggurath:~ #perl -MCPAN -e "install HTML::Parser"
CPAN: Storable loaded ok
Going to read /root/.cpan/Metadata
HTML::Parser is up to date.

matt@shub-niggurath:~>find /usr/local/lib/perl5 -name "Parser.pm" -print
/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/HTML/Parser.pm

Ah... but that find(1) produced a _lot_ of permission-denieds in
/usr/local/lib/perl5/.../auto.  

(su... chmod... exit)

Okay... now I'm getting a bunch of "can't insert duplicate key"
type errors from the partial success of previous runs, that's
(I guess) acceptable.  And I get a superuser username and a
random password.  Not bad!

Moral of this story: if you've (well, I've :-) just installed
something, and it isn't working, check file permissions.
Especially if the error is "can't locate" or "can't open".

> > I'm running Perl 5.005_03 on an x86 FreeBSD 4.5 box.
> 
> I know OI runs ok on FreeBSD and Perl 5.5.3, so those shouldn't be an
> issue.

Good to hear.

> > (Irritatingly, some of the dependencies for Bundle::SPOPS and
> > Bundle::OpenInteract want to install 5.6.1... so far, I've
> > told them not to.)
> 
> Older versions of CPAN used to do this when a module became part of the
> core. If you install a new version of CPAN the shell won't automatically
> do this. (It caused me a ton of pain as well.)

Installing a new version of CPAN tried to do the same... argh.
Oh well.  5.8.0's just a couple of months away, right? :-)

Thanks for the help!

Cheers,
    Matt

Re: [Openinteract-help] Undefined subroutine &OpenInteract::handler called.

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

On Mon, 2002-03-11 at 14:15, Magnus Espeland wrote:
> I finally figured out what was wrong, thanks to your tips :-)
> 
> My problem was that I'm using Trustix (the redhat based distribution with
> focus on security), for the first time in a year and a half, and had
> forgotten how secure it really is.. problem was that both cpan and
> oi_manage ran with a umask of 077. Took me a while to figure out that cpan
> didn't change the umask. 
>
> But now everything is working!
> I have a little wish list though ;-)
> - Could you make oi_manage change it's umask when we run it? Maybe it's
> best to make it an option?

Ah, I'll bet that was fun to debug!

Maybe it would be a good idea instead to create wrappers on your system
that do something like:

-----/usr/local/bin/cpan-----
#!/bin/sh
umask 022
perl -MCPAN -e shell
----------


(rename oi_manage to oi_manage.pl)
-----/usr/local/bin/oi_manage-----
#!/bin/sh
umask 022
perl /usr/local/bin/oi_manage $*
----------

Since this is the first time this has popped up, I'd rather not put this
sort of stuff (security) into OI if I can help it.

> - ApacheStartup.pm or Startup.pm creates tmplib, it should check it's
> uid/gid and umask. My apache runs as uid/gid=httpd but the tmplib dir
> shows up with 700 root.root, and that doesn't work very well ;-) I just
> hacked the module to change umask one line before it creates the
> directory, but I reckon it should be done elsewhere and a little more
> though-thru...

Excellent point. I'll check that and ensure that the umask allows at
least read access by everyone.

> - Could you make oi_manage understand relative --website_dir (like
> --website_dir=.)?

That's a good idea. I'll put this down to check as well.

> Bugs:
> - Typo at line 15 in event-1.20/struct/event.sql (varchar not varcar)

Fixed in CVS! Thanks.

Chris

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

Re: [Openinteract-help] Can't locate loadable object for HTML::Parser

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

On Tue, 2002-03-12 at 10:13, Matt Olson wrote:
> I've spent a frustrating couple of days trying to properly
> install and configure OpenInteract, but at least I've been
> making incremental progress.  My current issue is this
> error, during install_sql:
> 
> OpenInteract::Startup::require_module (354) >>  --require error: OpenInteract::SPOPS::DBI
> (from base_user): Can't locate loadable object for module HTML::Parser
> in @INC (@INC contains: ...
> BEGIN failed--compilation aborted at /usr/local/lib/perl5/site_perl/5.005/OpenInteract/SPOPS.pm line 8.
> BEGIN failed--compilation aborted at /usr/local/lib/perl5/site_perl/5.005/OpenInteract/SPOPS/DBI.pm line 6.
> 
> OpenInteract::Startup::main_initialize (82) >> Some classes were not required!

Sorry for your installation troubles.

Since your Perl seems to have some issues with HTML::Parser and/or
HTML::Entities, this will happen with any class that uses
OpenInteract::SPOPS as a parent, which is all of the SPOPS objects in
the system.

Ironically, HTML::Entities isn't even needed in that particular module
anymore, since the functions were moved to the Template Toolkit plugin
(OpenInteract::Template::Plugin). But you'd run into the error there
anyway, so it's worth solving.
 
> What's bugging me is that, as far as I can tell, HTML::Parser
> is properly installed.
 
Weird. One question: how do you know it's installed? What happens when
you do:

 $ perl -MHTML::Parser -e 'print HTML::Parser->VERSION, "\n"'
 $ perl -MHTML::Entities -e 'print HTML::Entities->VERSION, "\n"'

(I get 3.23 and 1.22, respectively)

or even:

 $ perldoc -l HTML::Parser
 $ perldoc -l HTML::Entities

> I'm running Perl 5.005_03 on an x86 FreeBSD 4.5 box.

I know OI runs ok on FreeBSD and Perl 5.5.3, so those shouldn't be an
issue.

> (Irritatingly, some of the dependencies for Bundle::SPOPS and
> Bundle::OpenInteract want to install 5.6.1... so far, I've
> told them not to.)

Older versions of CPAN used to do this when a module became part of the
core. If you install a new version of CPAN the shell won't automatically
do this. (It caused me a ton of pain as well.)

Chris

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