Tickets :: [#8599] Broken session data reading in MSSQL

6.0.0-beta1

7/18/25

Summary	Broken session data reading in MSSQL
Queue	Horde Base
Queue Version	3.3.5
Type	Bug
State	Resolved
Priority	2. Medium
Owners	selsky (at) columbia (dot) edu
Requester	moreda (at) allenta (dot) com
Created	09/23/2009 (5777 days ago)
Due
Updated	09/25/2009 (5775 days ago)
Assigned
Resolved	09/25/2009 (5775 days ago)
Github Issue Link
Github Pull Request
Milestone	3.3.6
Patch	Yes

09/25/2009 02:16:01 PM	CVS Commit	Comment #4	Reply to this comment
Changes have been made in CVS for this ticket: ~~Bug: 8599~~ BFN http://cvs.horde.org/diff.php/horde/docs/CHANGES?rt=horde&r1=1.1261&r2=1.1262&ty=u

09/25/2009 09:12:26 AM	Jan Schneider	Assigned to Matt Selsky State ⇒ Resolved Milestone ⇒ 3.3.6

09/25/2009 07:55:39 AM	CVS Commit	Comment #3	Reply to this comment
Changes have been made in CVS for this ticket: MFH: 1.54 ~~Bug: 8599~~ Submitted by: moreda@allenta.com http://cvs.horde.org/diff.php/framework/SQL/SQL.php?rt=horde&r1=1.30.2.21&r2=1.30.2.22&ty=u

09/25/2009 07:53:30 AM	CVS Commit	Comment #2	Reply to this comment
Changes have been made in CVS for this ticket: Pack data in readBlob() for mssql too. ~~Bug: 8599~~ Submitted by: moreda@allenta.com http://cvs.horde.org/diff.php/framework/SQL/SQL.php?rt=horde&r1=1.53&r2=1.54&ty=u

09/23/2009 05:07:25 PM	moreda (at) allenta (dot) com	Comment #1 Priority ⇒ 2. Medium New Attachment: fix-decoding-of-mssql-session-data.diff Patch ⇒ Yes Milestone ⇒ Summary ⇒ Broken session data reading in MSSQL Type ⇒ Bug State ⇒ Unconfirmed Queue ⇒ Horde Base	Reply to this comment
I'm using MSSQL to store session information through PEAR's DB abstraction layer. In lib/Horde/SQL.php there are two functions (insertBlob and upadteBlob) where session data is coded using bin2hex() to update the session_data field in the case of pgsql and mssql "dbsyntax" . In the complementary readBlob function there is no proper decoding for mssql "dbsyntax". See trivial patch attached.