[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