Tickets :: [#14175] oci8 driver session handler

6.0.0-beta1

7/16/25

Summary	oci8 driver session handler
Queue	Horde Framework Packages
Type	Bug
State	Resolved
Priority	2. Medium
Owners	jan (at) horde (dot) org
Requester	ico (at) cc (dot) upv (dot) es
Created	12/02/2015 (3514 days ago)
Due
Updated	12/17/2015 (3499 days ago)
Assigned	12/14/2015 (3502 days ago)
Resolved	12/17/2015 (3499 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch	No

12/17/2015 09:34:38 AM	Jan Schneider	Summary ⇒ oci8 driver session handler State ⇒ Resolved

12/16/2015 05:46:19 PM	Git Commit	Comment #4	Reply to this comment
Changes have been made in Git (master): commit 15e1cc1d2e4fc76214e1a40b55630b2fc85caec6 Author: Jan Schneider <jan@horde.org> Date: Wed Dec 16 18:38:47 2015 +0100 Use Horde_Db's blob features to improve Oracle compatibility (~~Bug #14175~~). ansel/lib/Faces/Base.php \| 27 +++++++++----- ansel/package.xml \| 2 +- .../ActiveSync/lib/Horde/ActiveSync/State/Sql.php \| 24 +++++------- framework/ActiveSync/package.xml \| 6 ++-- framework/Cache/lib/Horde/Cache/Storage/Sql.php \| 17 +++++---- framework/Cache/package.xml \| 6 ++-- .../lib/Horde/Imap/Client/Cache/Backend/Db.php \| 39 +++++++++----------- framework/Imap_Client/package.xml \| 4 ++- framework/Prefs/lib/Horde/Prefs/Storage/Sql.php \| 34 +++++++----------- framework/Prefs/package.xml \| 6 ++-- .../test/Horde/Prefs/Unit/Storage/Sql/Base.php \| 5 ++- .../test/Horde/Prefs/Unit/Storage/Sql/Oci8Test.php \| 23 ++++++++++++ 12 files changed, 107 insertions(+), 86 deletions(-) http://github.com/horde/horde/commit/15e1cc1d2e4fc76214e1a40b55630b2fc85caec6

12/14/2015 07:24:35 PM	Git Commit	Comment #3	Reply to this comment
Changes have been made in Git (master): commit 90a73b5f64d5059dcf143ab347dac534ed574f2b Author: Jan Schneider <jan@horde.org> Date: Mon Dec 14 18:01:19 2015 +0100 [jan] Fix writing big session data to Oracle (~~Bug #14175~~). .../lib/Horde/SessionHandler/Storage/Sql.php \| 32 +++++++------------- framework/SessionHandler/package.xml \| 4 +- .../test/Horde/SessionHandler/Storage/Sql/Base.php \| 2 +- .../Horde/SessionHandler/Storage/Sql/Oci8Test.php \| 10 ++++++ 4 files changed, 24 insertions(+), 24 deletions(-) http://github.com/horde/horde/commit/90a73b5f64d5059dcf143ab347dac534ed574f2b

12/14/2015 05:19:05 PM	Jan Schneider	Version ⇒ Queue ⇒ Horde Framework Packages

12/14/2015 05:12:03 PM	Jan Schneider	Priority ⇒ 2. Medium State ⇒ Assigned Assigned to Jan Schneider

12/04/2015 05:49:44 PM	ico (at) cc (dot) upv (dot) es	Comment #2	Reply to this comment
The same thing occurs when updating 'identities' with a large html signature (for example). That is, when the strings length of the serialized preferences array is greater than 1000 character. Dec 4 10:24:45 ERR: HORDE [imp] SQL QUERY FAILED: ORA-01704: string literal too long UPDATE horde_prefs SET pref_value = '613a313a7b693a303b613a31333a7b733a323a226964223b733a31363a22446566617 56c74204964656e74697479223b733a383a2266756c6c6e616d65223b733a31383a224 ... 63e0d0a3c6272202f3e0d0a223b7d7d' WHERE pref_uid = 'user@upv.es' AND pref_name = 'identities' AND pref_scope = 'horde' [pid 1849 on line 314 of "/usr/share/pear/Horde/Db/Adapter/Oci8.php"]

12/02/2015 04:24:30 PM	ico (at) cc (dot) upv (dot) es	Comment #1 Priority ⇒ 3. High Type ⇒ Bug Summary ⇒ oci8 driver sesion handler Queue ⇒ Horde Groupware Webmail Edition Milestone ⇒ Patch ⇒ No State ⇒ Unconfirmed	Reply to this comment
I think there's a bug passign sql sentence to oci9 driver. Oracle has a limit of 4000 when writting a blob. It seems to be needed binding data in Oracle. Here is the log: Dec 2 17:18:49 DEBUG: HORDE SQL (0,0006s) SELECT 1 FROM horde_sessionhandler WHERE session_id = 'e9o7r02bttkvltmr58ord29ap1' [pid 3399 on line 328 of "/usr/share/pear/Horde/Db/Adapter/Oci8.php"] Dec 2 17:18:49 DEBUG: HORDE SQL INSERT INTO horde_sessionhandler (session_id, session_data, session_lastmodified) VALUES ('e9o7r02bttkvltmr58ord29ap1', '5f627c693a313434393037333132393b5f727c693a313434393039343732393b686f7 ... 56e74697479223a22686f726465222c226c6173745f6c6f67696e7461736b73223a226 13a303a7b7d222c22757067726164655f7461736b73223a22613a303a7b7d227d5d7d2 23b733a31333a2273657373696f6e5f746f6b656e223b733a32343a22004679776c474 d545564386a5348465855466e3162526e7a223b7d', 1449073129) [pid 3399 on line 313 of "/usr/share/pear/Horde/Db/Adapter/Oci8.php"] Dec 2 17:18:49 ERR: HORDE SQL QUERY FAILED: ORA-01704: literal de cadena demasiado largo INSERT INTO horde_sessionhandler (session_id, session_data, session_lastmodified) VALUES ('e9o7r02bttkvltmr58ord29ap1', '5f627c693a313434393037333132393b5f727c693a313434393039343732393b686f7 ... c79706f736974696f6e223a22626f74746f6d222c2261637469766573796e635f69646 56e74697479223a22686f726465222c226c6173745f6c6f67696e7461736b73223a226 13a303a7b7d222c22757067726164655f7461736b73223a22613a303a7b7d227d5d7d2 23b733a31333a2273657373696f6e5f746f6b656e223b733a32343a22004679776c474 d545564386a5348465855466e3162526e7a223b7d', 1449073129) [pid 3399 on line 314 of "/usr/share/pear/Horde/Db/Adapter/Oci8.php"] Dec 2 17:18:49 DEBUG: HORDE Failed to write session data (e9o7r02bttkvltmr58ord29ap1) [pid 3399] Thank you.