[horde] SQL backend for session storage

[Igor Stroh]

On Mit, 2002-08-21 at 14:40, Jon Parise wrote:
> 
> On Wed, Aug 21, 2002 at 10:32:01AM +0200, Igor Stroh wrote:
> 
> > I wonder if anyone's running horde with a RDBMS as session backend. I'm
> > about to move my session storage from FS to SQL and would like to know
> > if there are any existing solutions.
> 
> http://www.csh.rit.edu/~jon/projects/pgsql_session_handler/

Thanx.

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

Greetings,
Igor
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://lists.horde.org/archives/horde/attachments/20020821/7d8b44cc/attachment-0001.bin