| Summary | Postgres Session Serialization strips char |
| Queue | Horde Base |
| Queue Version | 2.2.5 |
| Type | Bug |
| State | Resolved |
| Priority | 3. High |
| Owners | |
| Requester | kenneyw (at) first8 (dot) nl |
| Created | 03/30/2004 (7965 days ago) |
| Due | |
| Updated | 03/30/2004 (7965 days ago) |
| Assigned | |
| Resolved | 03/30/2004 (7965 days ago) |
| Github Issue Link | |
| Github Pull Request | |
| Milestone | |
| Patch | No |
State ⇒ Resolved
State ⇒ Unconfirmed
Priority ⇒ 3. High
Type ⇒ Bug
** 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