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

[Openinteract-help] More install problems

[Drew T. <dr...@dr...>]

Hi, it's me again. :-)

Now I'm running into errors running oi_manage install_sql. The tables are 
created properly:
oi_home=> \dt
            List of relations
       Name      | Type  |    Owner
----------------+-------+--------------
  content_type   | table | openinteract
  object_keys    | table | openinteract
  object_track   | table | openinteract
  page           | table | openinteract
  page_content   | table | openinteract
  page_directory | table | openinteract
  sessions       | table | openinteract
  sys_error      | table | openinteract
  sys_group      | table | openinteract
  sys_group_user | table | openinteract
  sys_security   | table | openinteract
  sys_user       | table | openinteract
  template       | table | openinteract
  theme          | table | openinteract
  theme_prop     | table | openinteract
(15 rows)

But I get this error when trying to create the super user. And then for the 
various packages I get errors trying to create a SPOPS object. Any ideas? 
I'm assuming this is a showstopper. I don't remember having this much 
trouble w/ the Mysql based SPOPS.

-----ERROR OUTPUT-----
Cannot create admin user! Error: $VAR1 = {
           'user_msg' => 'DBD::Pg::st execute failed: ERROR:  ExecAppend: 
Fail to add null value in not null attribute user_id at 
/usr/local/lib/perl5/site_perl/5.6.1/SPOPS/SQLInterface.pm line 288.
',
           'line' => 19,
           'extra' => undef,
           'filename' => 
'/usr/local/lib/perl5/site_perl/5.6.1/SPOPS/Exception/DBI.pm',
           'system_msg' => 'DBD::Pg::st execute failed: ERROR:  ExecAppend: 
Fail to add null value in not null attribute user_id at 
/usr/local/lib/perl5/site_perl/5.6.1/SPOPS/SQLInterface.pm line 288.
',
           'method' => 'spops_dbi_error',
           'package' => 'SPOPS::Exception::DBI',
           'type' => undef
         };

Status of the packages requested for SQL install:

base (1.67)
   OK:

       Structure:
         * Created table from (sessions.sql): ok
         * Created table from (object_keys.sql): ok
       Data:
         * install_data for Pg: no action taken
       Security:
         * Error: Cannot create SPOPS object!
       Basic: DBD::Pg::st execute failed: ERROR:
       ExecAppend: Fail to add null value in not null
       attribute sid at
       /usr/local/lib/perl5/site_perl/5.6.1/SPOPS/SQLInterfa
       ce.pm line 288.

       Error: DBD::Pg::st execute failed: ERROR:
       ExecAppend: Fail to add null value in not null
       attribute sid at
       /usr/local/lib/perl5/site_perl/5.6.1/SPOPS/SQLInterfa
       ce.pm line 288.
======================================================================
Drew Taylor                  |  Freelance web development using
http://www.drewtaylor.com/   |  perl/mod_perl/MySQL/postgresql/DBI
mailto:dr...@dr...   |  Contact: jo...@dr...
----------------------------------------------------------------------
Speakeasy.net: A DSL provider with a clue. Sign up today.
http://www.speakeasy.net/refer/29655
======================================================================

[Openinteract-help] Changing SPOPS drivers

[Drew T. <dr...@dr...>]

I'm changing the SPOPS drivers to use Pg and found a problem. I was able to 
successfully change the driver the first time. But I didn't read the next 
paragraph to see the proper value I SHOULD have set. But subsequent runs of 
oi_manage change_spops_driver does not change any files. All the  ones that 
were first changed are listed under the "Not changed" section.

I've used the new override ability in 1.40 to fix the above bug. But I like 
to squash bugs, so tell me what you need from me to do so. :-)
======================================================================
Drew Taylor                  |  Freelance web development using
http://www.drewtaylor.com/   |  perl/mod_perl/MySQL/postgresql/DBI
mailto:dr...@dr...   |  Contact: jo...@dr...
----------------------------------------------------------------------
Speakeasy.net: A DSL provider with a clue. Sign up today.
http://www.speakeasy.net/refer/29655
======================================================================

[Openinteract-help] oi_manage test_db w/ Postgres

[Drew T. <dr...@dr...>]

Chris,

I am doing a fresh install of OI in anticipation of using it in a project. 
In getting things ready using postgres I noticed a problem. In 
OpenInteract::DBI.pm you have these lines:

if ( $db_info->{db_name} ) {
         DEBUG && _w( 1, "Use right database ($db_info->{db_name})." );
         my $rv = $db->do( "use $db_info->{db_name}" );
         unless ( $rv ) {
             my $msg = $DBI::errstr;
             $db->disconnect;
             die "Use database failed: $msg\n";
         }
}

Postgres apparently does not support the "use dbname" syntax because it was 
giving me an error. I had db_name set in the [db_info main] section within 
server.ini. Changing this to be blank fixed my problem. I don't know if 
there is a workaround for this, other than documentation, which seemed a 
little scarce in this area. I'll be sure to let you know of anything else I 
might find while diving into OI. I look forward to having to reinvent a 
much smaller portion of the wheel. :-)

Drew

[drew@nephi OpenInteract-1.40]$ oi_manage 
--website_dir=/home/openinteract/home/ test_db
Running test_db...
=========================

DBD::Pg::db do failed: ERROR:  parser: parse error at or near "use" 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 -- ERROR:  parser: parse
            error at or near "use"
            -- Create table: not attempted

=========================
Finished test_db!
======================================================================
Drew Taylor                  |  Freelance web development using
http://www.drewtaylor.com/   |  perl/mod_perl/MySQL/postgresql/DBI
mailto:dr...@dr...   |  Contact: jo...@dr...
----------------------------------------------------------------------
Speakeasy.net: A DSL provider with a clue. Sign up today.
http://www.speakeasy.net/refer/29655
======================================================================

RE: [Openinteract-help] broken images

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

On Tue, 2002-05-07 at 16:27, Mike Melillo wrote:
> Yeah now I cant bind to port 80 so the server won't stay
> up...everything's going wrong.

At this point, I'd just try and create a simple mod_perl handler that
generates some content that refers to an image. Like:

----------
package My::Foo;

use Apache::Constants qw( OK );

sub handler {
    my ( $r ) = shift;
    $r->send_http_header( 'text/html' );
    $r->print( qq(<p>Hi</p><img src="/images/oi_logo.gif">) );
    return OK;
}

1;
----------

Then refer to it in your conf:

----------
 <Location />
    SetHandler perl-script
    PerlHandler My::Foo
 </Location>
----------

And see what happens.

Chris

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

RE: [Openinteract-help] broken images

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

On Tue, 2002-05-07 at 15:54, Mike Melillo wrote:
> When <location />
> 
> Is commented out I get the directory listing for the DocumentRoot.  If I
> then click on the html directory I get the snippet of the index page
> that is served from within the template.
> 
> Something just dawned on me, shouldn't /images be aliased to
> $BASE_DIR/html/images?

DocumentRoot should be set to $BASE_DIR/html. If it is then /images
should automatically be at $BASE_DIR/html/images

Chris

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

RE: [Openinteract-help] broken images

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

On Tue, 2002-05-07 at 15:21, Mike Melillo wrote:
> 
> Chris, here are my versions...
> 
> apache-1.3.22-2
> Perl 5.6.1
> mod_perl-1.26-2
> 
> # /usr/sbin/httpd -l
> Compiled-in modules:
>   http_core.c
>   mod_so.c
> suexec: enabled; valid wrapper /usr/sbin/suexec
> 
> 
> apache/mod_perl/Perl are all RPM installations.  I hate RPMs but
> EVERYTIME I try and use my own builds of apache/mod_perl I have
> segmentation fault issues.  So I go with the way that at least gets me
> up and running.
> 
> I re-looked over the INSTALL.website docs and it looks like I didn't
> miss anything.  I have a feeling its something in a configuration file
> somewhere.  Unfortunately being so new to OI, I don't know where to
> start poking around.

Some more ideas:

 - What happens if you comment out the <Location /> directive entirely?

 - What happens if you replace it with something like:

   <Location />
     DirectoryIndex index.html
   </Location>

and some other foo to make Apache think it's just a normal Location?

Chris

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

RE: [Openinteract-help] broken images

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

On Tue, 2002-05-07 at 15:25, Mike Melillo wrote:
> Question,
> 
> I'm pulling in conf/httpd_modperl_solo.conf  in the "Main" section of
> httpd.conf
> 
> Is that correct or should it be in a specific place?  Also, I'm not
> using a virtual host, so I just have the content between the
> <VirtualHost> tags of the httpd_modperl_solo.conf file.  Is this also
> correct?

Umm... I'm not sure, actually. It's been so long -- literally, 3 or 4
years -- since I have switched to only using virtual hosts that I forget
what the differences are. Compare it with another Apache deployment you
have to look for differences -- maybe there's another directive
interfering with the <Location /images> directive. (grasping at
straws...)

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

RE: [Openinteract-help] broken images

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

On Tue, 2002-05-07 at 14:23, Mike Melillo wrote:
> 
> Well I quickly tried the proxy route, but was getting a proxy error, so
> I reverted back to the solo server way.
> 
> I flip-flopped the two Location statements but nothing changed.

Well, I just did a vanilla install using the httpd_modperl_solo.conf
file, no modifications, and everything worked ok. So I guess we need to
go a little lower level. What versions of the major players
(Perl/Apache/mod_perl) are you using? What happens when you run the
modperl binary with a '-l'? 

For comparison, here's my info:

--------------------
Perl 5.6.1
Apache 1.23
mod_perl 1.26
Output of httpd_modperl -l:

Compiled-in modules: 
  http_core.c 
  mod_env.c 
  mod_log_config.c 
  mod_mime.c 
  mod_negotiation.c 
  mod_status.c 
  mod_include.c 
  mod_autoindex.c 
  mod_dir.c 
  mod_cgi.c 
  mod_asis.c 
  mod_imap.c 
  mod_actions.c 
  mod_userdir.c 
  mod_alias.c 
  mod_access.c 
  mod_auth.c 
  mod_setenvif.c 
  mod_perl.c 
suexec: disabled; invalid wrapper /usr/local/apache/bin/suexec 
--------------------

Chris

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

RE: [Openinteract-help] broken images

[Mike M. <mme...@at...>]

Well I quickly tried the proxy route, but was getting a proxy error, so
I reverted back to the solo server way.

I flip-flopped the two Location statements but nothing changed.



-----Original Message-----
From: ope...@li...
[mailto:ope...@li...] On Behalf Of
Chris Winters
Sent: Tuesday, May 07, 2002 2:01 PM
To: Mike Melillo
Cc: ope...@li...
Subject: RE: [Openinteract-help] broken images

On Tue, 2002-05-07 at 13:17, Mike Melillo wrote:
> Thanks for the quick response...
> 
> The permissions are all fine....check.
> 
> I am using the http_modperl_solo file, and I did notice that </images>
> was set to use the default-handler, I even tried taking that out, but
I
> got the same result.
> 
> One thing that I have noticed is that nothing shows up in the error
> logs, just the access log.  
> 
> This machine is just a dev server by itself so I figured the proxy
> server wouldn't make sense.  Should I try that type of setup instead?
> Is it preferred?  I've never done anything with proxy's before.

No, the _solo file should work fine. I haven't used it for quite some
time. One thing to try, switch the ordering of the various directives.
So if you have:

 <Location />...</Location>
 <Location /images>...</Location>

Switch it to:

 <Location /images>...</Location>
 <Location />...</Location>

Otherwise, I'll try to set a site up here and see whether it works.

The fact the nothing shows up in the error log is normal -- the request
is being passed to OI which generates its own error message but not an
Apache error.

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


_______________________________________________________________

Have big pipes? SourceForge.net is looking for download mirrors. We
supply
the hardware. You get the recognition. Email Us:
ban...@so...
_______________________________________________
openinteract-help mailing list
ope...@li...
https://lists.sourceforge.net/lists/listinfo/openinteract-help

RE: [Openinteract-help] broken images

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

On Tue, 2002-05-07 at 13:17, Mike Melillo wrote:
> Thanks for the quick response...
> 
> The permissions are all fine....check.
> 
> I am using the http_modperl_solo file, and I did notice that </images>
> was set to use the default-handler, I even tried taking that out, but I
> got the same result.
> 
> One thing that I have noticed is that nothing shows up in the error
> logs, just the access log.  
> 
> This machine is just a dev server by itself so I figured the proxy
> server wouldn't make sense.  Should I try that type of setup instead?
> Is it preferred?  I've never done anything with proxy's before.

No, the _solo file should work fine. I haven't used it for quite some
time. One thing to try, switch the ordering of the various directives.
So if you have:

 <Location />...</Location>
 <Location /images>...</Location>

Switch it to:

 <Location /images>...</Location>
 <Location />...</Location>

Otherwise, I'll try to set a site up here and see whether it works.

The fact the nothing shows up in the error log is normal -- the request
is being passed to OI which generates its own error message but not an
Apache error.

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

Re: [Openinteract-help] broken images

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

On Tue, 2002-05-07 at 12:54, Mike Melillo wrote:
> I'm pretty new to OI.  I just got my install up and running after
> following all the instructions.and I got the welcome screen!  But the
> images are broken.when I look at the properties of the images, they
> coincide with the right url -> filesystem, but when I paste in the url,
> they aren't found.  What could I have screwed up?

Two thoughts:

1) Permissions: do the images have the correct permissions to be
displayed? They should either world-readable or readable by the user
and/or group the web server runs under (often 'nobody' and 'nogroup').
You should be able to tell if this is the issue from your access log.

2) If permissions are ok, you probably need to tell Apache to deal with
the items in /images using the default handler. If you're using the
dual-server setup (proxy server in front of modperl server) then this
should be done for you.

If you're just using a single server setup, then you might have used the
wrong configuration file: try using conf/httpd_modperl_solo.conf instead
of conf/httpd_modperl.conf.

If all of that seems ok, then we'll reset our criteria and try again.

Chris

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

[Openinteract-help] broken images

[Mike M. <mme...@at...>]

 

Hey,

 

I'm pretty new to OI.  I just got my install up and running after
following all the instructions.and I got the welcome screen!  But the
images are broken.when I look at the properties of the images, they
coincide with the right url -> filesystem, but when I paste in the url,
they aren't found.  What could I have screwed up?

 

Thanks,

 

Mike Melillo

 

[Openinteract-help] Multilingual site

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

I'm working on a site that is using several languages. Obviously I want 
to use the same set of packages, but would like a user to get the 
appropriate language template. The normal way of doing this up till now 
(before OI) was to have a different base language dir at the beginning, eg:
%docroot%/lang1
%docroot%/lang2

and then set the appropriate character set and similar according to this.
If I understand things correctly, this way is not really ok with OI, 
because the first dir-like part of url determines the module part of 
action and the rest is methods and params. There is the "redir" option 
in actions that could be used as a way of getting the same module 
regardless of language
( act_lang1 => {redir=>action},act_lang2 =>{redir=>action} )
, but how am I going to get the templates for the right language?

As I see, there is an language field in sys_user. Is this applied 
somwhere and could this be used to determine the language preferences of 
a user. Still, how do I cope witg getting the right templates out?

Tnx..

Jure

Re: [Openinteract-help] Authorisation problem

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

Chris Winters wrote:
> On Fri, 2002-04-12 at 09:15, Jure Simsic wrote:
> 
> The next step would be to create a brand new session in the test script,
> then retrieve that same session from the test script to see if it works
> ok. 
> 

Btw, if i do something like:

   tie %session, 'Apache::Session::Postgres',
     $SESSION_ID, { Handle => $R->db };
   $SESSION_ID = $session{'_session_id'};
   $session{'key_size'} = length($SESSION_ID);
   print Dumper( \%session );
   untie %session;

   print "\nRetrieving session:\n";
   tie %session, 'Apache::Session::Postgres',
      $SESSION_ID, { Handle => $R->db };
   print Dumper( \%session );
   untie %session;

..it does return me the extra supplied value ( $session{'key_size'} ):

$VAR1 = {
           '_session_id' => 'ae95a09eba71452658364aa7d1aee1d7',
           'key_size' => 32
         };

Retrieving session:
$VAR1 = {
           '_session_id' => 'ae95a09eba71452658364aa7d1aee1d7',
           'key_size' => 32
         };


So it seems as Apache session somewhat works..

j-)

Re: [Openinteract-help] Authorisation problem

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

Chris Winters wrote:
> On Fri, 2002-04-12 at 09:15, Jure Simsic wrote:
> 
>>Apart from first not being able to write to tmplib, I got:
>>
>>$ perl test/test2.pl
>>Hisa::User::_class_initialize (15) >> Set Hisa::User to use crypt (1)
>>$VAR1 = {
>>           '_session_id' => 'd90e4e7bb6458ebb69ae8fa9c330e341'
>>         };
>>
>>(i deleted my session and reinitialized it in between, so the ID is right)
>>
>>Any clues?
>>
> 
> The next step would be to create a brand new session in the test script,
> then retrieve that same session from the test script to see if it works
> ok. 
> 


So I did:
--
use strict;
use Apache::Session::Postgres;
use Data::Dumper qw( Dumper );
use OpenInteract::Startup;

my $WEBSITE_DIR = $ENV{OIWEBSITE};
#my $SESSION_ID  = 'd90e4e7bb6458ebb69ae8fa9c330e341';
my $SESSION_ID  = undef;

{
   my $R = OpenInteract::Startup->setup_static_environment(
                                    $WEBSITE_DIR );
   my ( %session );
   tie %session, 'Apache::Session::Postgres',
     $SESSION_ID, { Handle => $R->db };
   $SESSION_ID = $session{'_session_id'};
   print Dumper( \%session );
   untie %session;

    tie %session, 'Apache::Session::Postgres',
      $SESSION_ID, { Handle => $R->db };
   print Dumper( \%session );
}
--

and I get:
perl test2.pl
Hisa::User::_class_initialize (15) >> Set Hisa::User to use crypt (1)
$VAR1 = {
           '_session_id' => '80611dd437ef713d76bafe5997d3d7af'
         };
$VAR1 = {
           '_session_id' => '80611dd437ef713d76bafe5997d3d7af'
         };


What kind of result should I be expecting?



> AFAIK, I haven't seen any other problems with Postgres and
> Apache::Session. What versions of PostgreSQL, DBI, DBD::Pg and
> Apache::Session are you using?
> 



perl -MDBD::Pg -e' print $DBD::Pg::VERSION,"\n"'
1.01
perl -MApache::Session -e' print $Apache::Session::VERSION,"\n"'
1.54
postgresql-7.0.3


j-)

Re: [Openinteract-help] SPOPS-0.58 installation problem

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

On Sun, 2002-04-14 at 08:41, Florian Hellberg wrote:
> >It's strange the change worked. What versions of DBI and DBD::mysql are
> >you running?
> 
> That's what I thought, too :)
> - DBD::mysql is v2.0402 (the latest shipping for debian/potato)
> - DBI is v1.13 (the latest shipping for debian/potato)
> I also tested it with DBI v1.21 from CPAN but the same oddity occured.

Well then. Rather than wonder about why it's working now, I've just
modified the code to use either one. It's in CVS if you're curious. The
change will be in version 0.60, probably out fairly soon.

Thanks for the report.

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

Re: [Openinteract-help] SPOPS-0.58 installation problem

[Florian H. <fh...@fa...>]

At 23:08 13.04.2002 -0400, you wrote:
>On Sat, 2002-04-13 at 21:37, Florian Hellberg wrote:
> > Hi!
> >
> > I've been just installing SPOPS-0.58 and got some weird Errors while=
 'make
> > test' =3D> test 't/30_dbi':
> >
> > -------- BEGIN OF EXCERPT --------
> > t/30_dbi...............NOK 5#     Failed test (t/30_dbi.t at line 83)
> > Error saving object: Can't get DBI::db=3DHASH(0x83a8d40)->{Name}:
> > unrecognised attribute at blib/lib/SPOPS/SQLInterface.pm line 427.
> > ...
> > So I looked at 'SPOPS/SQLInterface.pm' and changed at line 427
> > '$db->{Name}' into '$db->{name}':
> >
> > 427    my $type_idx =3D join( '-', lc $db->{Name}, lc $table );
> > into
> > 427    my $type_idx =3D join( '-', lc $db->{name}, lc $table );
> >
> > With these minor change the 'make test' got OK:
> > 't/30_dbi...............ok'
> >
> > I'm using MySQL 3.22.32 on a debian machine. Is this a general fault or=
 is
> > it just my specific system configuration?
>
>It's strange the change worked. What versions of DBI and DBD::mysql are
>you running?

That's what I thought, too :)
- DBD::mysql is v2.0402 (the latest shipping for debian/potato)
- DBI is v1.13 (the latest shipping for debian/potato)
I also tested it with DBI v1.21 from CPAN but the same oddity occured.

Regards, Florian


-[ fast networx / Morseweg 3 / 23556 L=FCbeck ]-
-[ Tel. 0451.499 400-6 / Fax 0451.499 400-7 ]-
-[ fh...@fa...  /  www.fastnetworx.de ]-

Re: [Openinteract-help] SPOPS-0.58 installation problem

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

On Sat, 2002-04-13 at 21:37, Florian Hellberg wrote:
> Hi!
> 
> I've been just installing SPOPS-0.58 and got some weird Errors while 'make 
> test' => test 't/30_dbi':
> 
> -------- BEGIN OF EXCERPT --------
> t/30_dbi...............NOK 5#     Failed test (t/30_dbi.t at line 83)
> Error saving object: Can't get DBI::db=HASH(0x83a8d40)->{Name}: 
> unrecognised attribute at blib/lib/SPOPS/SQLInterface.pm line 427.
> ...
> So I looked at 'SPOPS/SQLInterface.pm' and changed at line 427 
> '$db->{Name}' into '$db->{name}':
> 
> 427    my $type_idx = join( '-', lc $db->{Name}, lc $table );
> into
> 427    my $type_idx = join( '-', lc $db->{name}, lc $table );
> 
> With these minor change the 'make test' got OK:
> 't/30_dbi...............ok'
> 
> I'm using MySQL 3.22.32 on a debian machine. Is this a general fault or is 
> it just my specific system configuration?

It's strange the change worked. What versions of DBI and DBD::mysql are
you running?

Chris

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

[Openinteract-help] SPOPS-0.58 installation problem

[Florian H. <fh...@fa...>]

Hi!

I've been just installing SPOPS-0.58 and got some weird Errors while 'make=
=20
test' =3D> test 't/30_dbi':

-------- BEGIN OF EXCERPT --------
t/30_dbi...............NOK 5#     Failed test (t/30_dbi.t at line 83)
Error saving object: Can't get DBI::db=3DHASH(0x83a8d40)->{Name}:=20
unrecognised attribute at blib/lib/SPOPS/SQLInterface.pm line 427.

$VAR1 =3D {
           'line' =3D> undef,
           'method' =3D> undef,
           'filename' =3D> undef,
           'type' =3D> undef,
           'system_msg' =3D> undef,
           'package' =3D> undef,
           'extra' =3D> undef,
           'user_msg' =3D> undef
         };

SPOPS::DBI::id_clause (164) >> Likely was not passed sufficient information=
=20
to  get infromation requested. Making a 'best guess'
-------- END OF EXCERPT --------

With 't/30_dbi' test 1-4 and 6 were then fine, 7-20 failed - probably due=20
to NOK in test 5.

So I looked at 'SPOPS/SQLInterface.pm' and changed at line 427=20
'$db->{Name}' into '$db->{name}':

427    my $type_idx =3D join( '-', lc $db->{Name}, lc $table );
into
427    my $type_idx =3D join( '-', lc $db->{name}, lc $table );

With these minor change the 'make test' got OK:
't/30_dbi...............ok'

I'm using MySQL 3.22.32 on a debian machine. Is this a general fault or is=
=20
it just my specific system configuration?

Best regards,
Florian


-[ fast networx / Morseweg 3 / 23556 L=FCbeck ]-
-[ Tel. 0451.499 400-6 / Fax 0451.499 400-7 ]-
-[ fh...@fa...  /  www.fastnetworx.de ]-

Re: [Openinteract-help] Authorisation problem

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

On Fri, 2002-04-12 at 09:15, Jure Simsic wrote:
> Apart from first not being able to write to tmplib, I got:
> 
> $ perl test/test2.pl
> Hisa::User::_class_initialize (15) >> Set Hisa::User to use crypt (1)
> $VAR1 = {
>            '_session_id' => 'd90e4e7bb6458ebb69ae8fa9c330e341'
>          };
> 
> (i deleted my session and reinitialized it in between, so the ID is right)
> 
> Any clues?

The next step would be to create a brand new session in the test script,
then retrieve that same session from the test script to see if it works
ok. 

AFAIK, I haven't seen any other problems with Postgres and
Apache::Session. What versions of PostgreSQL, DBI, DBD::Pg and
Apache::Session are you using?

Chris

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

Re: [Openinteract-help] Authorisation problem

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

Apart from first not being able to write to tmplib, I got:

$ perl test/test2.pl
Hisa::User::_class_initialize (15) >> Set Hisa::User to use crypt (1)
$VAR1 = {
           '_session_id' => 'd90e4e7bb6458ebb69ae8fa9c330e341'
         };

(i deleted my session and reinitialized it in between, so the ID is right)

Any clues?

Jure


Chris Winters wrote:
 >
> Let's try to isolate this. What happens when you do something like the
> following. (This is off the top of my head, so you may need to debug.)
> 
> ---
> use strict;
> use Apache::Session::Postgres;
> use Data::Dumper qw( Dumper );
> use OpenInteract::Startup;
> 
> my $WEBSITE_DIR = '/set/this/to/path/to/site';
> my $SESSION_ID  = '1f1371e8e525455823c78843bb724d70';
> 
> {
>   my $R = OpenInteract::Startup->setup_static_environment(
>                                    $WEBSITE_DIR );
>   my ( %session );
>   tie %session, 'Apache::Session::Postgres', 
>                 $SESSION_ID, { Handle => $R->db };
>   print Dumper( \%session );
> } 
> ---

Re: [Openinteract-help] Authorisation problem

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

On Fri, 2002-04-12 at 08:34, Jure Simsic wrote:
> Here'tis:
> 
> +++++
> OpenInteract::Session::save (113) >> Saving new session
>   $VAR1 = {
> ...

Ok, this looks great.

> OpenInteract::Cookies::Apache::bake (36) >> Setting session to value 
> 1f1371e8e525455823c78843bb724d70
> (eval) (273) >> Cookies out: session = 1f1371e8e525455823c78843bb724d70

And so does this. But...

> +++++
> 
> But when I follow another link, I get again:
> 
> +++++
> (eval) (255) >> Trying to use session class:  OpenInteract::Session::DBI
> OpenInteract::Session::DBI::_create_session (26) >> Trying to fetch 
> session 1f1371e8e525455823c78843bb724d70
> OpenInteract::Session::parse (32) >> Retrieved session properly:  $VAR1 = {
>            '_session_id' => '1f1371e8e525455823c78843bb724d70'
>          };

This is the problem. For some reason the session isn't coming back
properly.

Let's try to isolate this. What happens when you do something like the
following. (This is off the top of my head, so you may need to debug.)

---
use strict;
use Apache::Session::Postgres;
use Data::Dumper qw( Dumper );
use OpenInteract::Startup;

my $WEBSITE_DIR = '/set/this/to/path/to/site';
my $SESSION_ID  = '1f1371e8e525455823c78843bb724d70';

{
  my $R = OpenInteract::Startup->setup_static_environment(
                                   $WEBSITE_DIR );
  my ( %session );
  tie %session, 'Apache::Session::Postgres', 
                $SESSION_ID, { Handle => $R->db };
  print Dumper( \%session );
} 
---

Later,

Chris

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

Re: [Openinteract-help] Authorisation problem

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

Here'tis:

+++++
OpenInteract::Session::save (113) >> Saving new session
  $VAR1 = {
           'user_id' => '1',
           '_oi_cache' => {
                            'group_refresh_on' => '1018616127',
                            'theme_refresh_on' => '1018614417',
                            'theme' => bless( {
                                                'parent' => '0',
                                                'description' => 'Your 
basic, parent of all themes. Main.',
                                                'title' => 'main',
                                                'credit' => 
'OpenInteract Developers <in...@op...>',
                                                'theme_id' => '1'
                                              }, 'Hisa::Theme' ),
                            'user_refresh_on' => '1018616127',
                            'group' => [
                                         bless( {
                                                  'notes' => 'Super 
group, can do anything',
                                                  'group_id' => '1',
                                                  'name' => 'admin'
                                                }, 'Hisa::Group' )
                                       ],
                            'user' => bless( {
                                               'first_name' => 'Super',
                                               'user_id' => '1',
                                               'title' => undef,
                                               'language' => 'en',
                                               'last_name' => 'User',
                                               'password' => 
'FTA656mFxR/LQ',
                                               'num_logins' => undef,
                                               'theme_id' => '1',
                                               'removal_date' => undef,
                                               'notes' => undef,
                                               'last_login' => undef,
                                               'email' => 
'adm...@si...',
                                               'login_name' => 'superuser'
                                             }, 'Hisa::User' )
                          },
           '_session_id' => '1f1371e8e525455823c78843bb724d70'
         };

OpenInteract::Cookies::Apache::bake (36) >> Setting session to value 
1f1371e8e525455823c78843bb724d70
(eval) (273) >> Cookies out: session = 1f1371e8e525455823c78843bb724d70
+++++

But when I follow another link, I get again:

+++++
(eval) (255) >> Trying to use session class:  OpenInteract::Session::DBI
OpenInteract::Session::DBI::_create_session (26) >> Trying to fetch 
session 1f1371e8e525455823c78843bb724d70
OpenInteract::Session::parse (32) >> Retrieved session properly:  $VAR1 = {
           '_session_id' => '1f1371e8e525455823c78843bb724d70'
         };

OpenInteract::Auth::user (63) >> No uid found in session. Finding login 
info.
OpenInteract::Auth::user (72) >> Creating the not-logged-in user.
OpenInteract::Auth::group (256) >> No logged-in user found, not 
retrieving groups.
+++++


and at the end:


+++++
(eval) (273) >> Cookies out:
OpenInteract::cleanup (425) >>

Errors:  $VAR1 = [
           bless( {
                    'user_id' => 99999,
                    'user_msg' => undef,
                    'code' => 305,
                    'filename' => 
'/usr/local/share/perl/5.6.1/OpenInteract/Handler/GenericDispatcher.pm',
                    'system_msg' => undef,
                    'session_id' => '1f1371e8e525455823c78843bb724d70',
                    'referer' => 'http://hisa.simsic.org/ObjectActivity/',
                    'url' => '/Security/',
                    'line' => 148,
                    'notes' => '8<br>
listing<br>
Hisa::Handler::Security<br>
1<br>
',
                    'package' => 'OpenInteract::Handler::GenericDispatcher',
                    'browser' => 'Mozilla/5.0 (X11; U; Linux i686; 
en-US; rv:0.9.8) Gecko/20020214',
                    'type' => 'n/a',
                    'error_time' => '2002-04-12 14:27:44',
                    'action' => 'n/a'
                  }, 'Hisa::ErrorObject' )
         ];


+++++


It seems it forgets about the ID instantly. Where is the ID info stored? 
In sessions.a_session field?

I'm kinda lost here..

Tnx

Jure

Chris Winters wrote:
> On Fri, 2002-04-12 at 05:55, Jure Simsic wrote:
>>What does this mean? Also, is it ok not to have last_accessed field in 
>>sessions empty? Are there be any other tables where session info gets 
>>written (or not) to check?
>>
> 
> No, this is the only session table. Can you delete this cookie (or
> delete the session from the database) and login again, with DEBUG still
> set to 2. You should get a message before the session is created/saved
> telling you what's in the session.
> 

Re: [Openinteract-help] Authorisation problem

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

On Fri, 2002-04-12 at 05:55, Jure Simsic wrote:
> I have the same problem still. As I'm trying to dig out the problem I've 
> checked sessions in postgres and it seems that a session is written out 
> the first time i log in:
> ...
> And with DEBUGging turned to 2 I get this errors in my modperl log:
> 
> Found item: Apache::DBI::db
> (eval) (252) >> Trying to use cookie class:  OpenInteract::Cookies::Apache
> OpenInteract::Cookies::Apache::parse (21) >> Getting cookie session to 
> 532730127
> 96ad85a6a327ab7213feffd
> (eval) (254) >> Cookies in: $VAR1 = {
>            'session' => '53273012796ad85a6a327ab7213feffd'
>          };
> 
> (eval) (255) >> Trying to use session class:  OpenInteract::Session::DBI
> OpenInteract::Session::DBI::_create_session (26) >> Trying to fetch 
> session 53273012796ad85a6a327ab7213feffd
> OpenInteract::Session::parse (32) >> Retrieved session properly:  $VAR1 = {
>            '_session_id' => '53273012796ad85a6a327ab7213feffd'
>          };

Ah, here's the issue. There should be a 'user_id' entry in here, as the
log says...
 
> OpenInteract::Auth::user (63) >> No uid found in session. Finding login 
> info.
> OpenInteract::Auth::user (72) >> Creating the not-logged-in user.
> OpenInteract::Auth::group (256) >> No logged-in user found, not 
> retrieving groups.
> 
> What does this mean? Also, is it ok not to have last_accessed field in 
> sessions empty? Are there be any other tables where session info gets 
> written (or not) to check?

No, this is the only session table. Can you delete this cookie (or
delete the session from the database) and login again, with DEBUG still
set to 2. You should get a message before the session is created/saved
telling you what's in the session.

Chris

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

Re: [Openinteract-help] Authorisation problem

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

I have the same problem still. As I'm trying to dig out the problem I've 
checked sessions in postgres and it seems that a session is written out 
the first time i log in:
oi=# SELECT * from sessions ;
-[ RECORD 1 
]-+------------------------------------------------------------------------------
id            | 53273012796ad85a6a327ab7213feffd
a_session     | 
BQQDAAAAAQogNTMyNzMwMTI3OTZhZDg1YTZhMzI3YWI3MjEzZmVmZmQAAAALX3Nlc3Npb25faWQ=

last_accessed |

The table structure seems ok (according to 
Apache::Session::Store::Postgres):
oi=# \d sessions
            Table "sessions"
    Attribute   |   Type    | Modifier
---------------+-----------+----------
  id            | char(32)  | not null
  a_session     | text      |
  last_accessed | timestamp |
Index: sessions_pkey


And with DEBUGging turned to 2 I get this errors in my modperl log:

Found item: Apache::DBI::db
(eval) (252) >> Trying to use cookie class:  OpenInteract::Cookies::Apache
OpenInteract::Cookies::Apache::parse (21) >> Getting cookie session to 
532730127
96ad85a6a327ab7213feffd
(eval) (254) >> Cookies in: $VAR1 = {
           'session' => '53273012796ad85a6a327ab7213feffd'
         };

(eval) (255) >> Trying to use session class:  OpenInteract::Session::DBI
OpenInteract::Session::DBI::_create_session (26) >> Trying to fetch 
session 53273012796ad85a6a327ab7213feffd
OpenInteract::Session::parse (32) >> Retrieved session properly:  $VAR1 = {
           '_session_id' => '53273012796ad85a6a327ab7213feffd'
         };

OpenInteract::Auth::user (63) >> No uid found in session. Finding login 
info.
OpenInteract::Auth::user (72) >> Creating the not-logged-in user.
OpenInteract::Auth::group (256) >> No logged-in user found, not 
retrieving groups.

What does this mean? Also, is it ok not to have last_accessed field in 
sessions empty? Are there be any other tables where session info gets 
written (or not) to check?

Jure

Chris Winters wrote:

> 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
> 
>