[bugs] [Tickets] New ticket (44): Postgres Session Serialization strips char

[bugs at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

-Ticket 44
-Queue: Horde Base
-Created By: 

-Summary:
Postgres Session Serialization strips char

Comment by kenneyw at first8.nl on Tue Mar 30 05:39:22 2004 (today):
I will describe symptoms, cause and fix (at least for my system):

** Symptoms:

Some links (the Password link for instance) don't work: you are redirected
back to /imp/mailbox.php. (After debugging I found that Auth::getAuth()
didn't work
after the first time)


** CAUSE

horde/lib/SQL.php, line 64, strips the first two chars of the value of the
session_data column (horde_sessionhandler table).

This only occurs when you use pgsql as dbsyntax (line 63: case 'pgsql': ).
This is strange since the store-code does not prepend any characters. This
seems to be a hack circumventing some problem (hard to believe it is a
deliberate bug!).

B.t.w., we use PostgreSQL 7.4.1, and the table looks like:

horde=# \d horde_sessionhandler
           Table "public.horde_sessionhandler"
        Column        |         Type          | Modifiers 
----------------------+-----------------------+-----------
 session_id           | character varying(32) | not null
 session_lastmodified | integer               | not null
 session_data         | bytea                 | 


** FIX:

replace
   $data = substr($result, 2);
by
   $data = $result;



Greetings,

   Kenney Westerhof

--


http://bugs.horde.org/details.php?id=44

-- 
This mail was automatically generated by Tickets (http://bugs.horde.org/).

If you believe you have recieved this mail in error, please contact Horde
Development Team <dev at lists.horde.org>.