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