[horde] SQL backend for session storage

Chuck Hagenbuch chuck at horde.org
Wed Aug 21 09:10:39 PDT 2002


Quoting Igor Stroh <stroh at scan-plus.de>:

> I should check CVS from time to time :) There already is a sql driver
> for session storage in horde/lib/SessionHandler... works pretty good
> except the fact that the scripts/db/sessionhandler.sql script that
> creates the horde_sessionhandler table doesn't fit for my PostgreSQL
> (7.1.2). The field session_data is declared as LONGBLOB there. This data
> type (or its equivalent) is called BYTEA in pgsql. However, I don't know
> why serialized session data should be stored as binary string, so I just
> changed the type to TEXT and it works now (BYTEA values have to be
> escaped before any WRITE operations, but since the stuff is passed
> without any escaping directly to the DB, pgsql module raises an error).

If you want to submit a pgsql-specific .sql file, we'll include it in CVS.

-chuck

--
Charles Hagenbuch, <chuck at horde.org>
"After a few minutes the most aromatic and nice smelling Italian coffee 
 will come out of the exhaustpipe." - Our stove-top espresso pot


More information about the horde mailing list