6.0.0-beta1
7/5/25

[#11436] PDOException when using SQL-Sessionhandler with Postgresql
Summary PDOException when using SQL-Sessionhandler with Postgresql
Queue Horde Base
Queue Version 4.0.15
Type Bug
State Resolved
Priority 2. Medium
Owners jan (at) horde (dot) org
Requester piper (at) hrz (dot) uni-marburg (dot) de
Created 09/19/2012 (4672 days ago)
Due 09/20/2012 (4671 days ago)
Updated 10/15/2012 (4646 days ago)
Assigned
Resolved 09/24/2012 (4667 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
10/15/2012 08:39:52 PM Git Commit Comment #4 Reply to this comment
Changes have been made in Git (develop):

commit edf903da8bca7480b07a19d57c83c6098a6e7916
Author: Jan Schneider <jan@horde.org>
Date:   Mon Sep 24 15:51:48 2012 +0200

     Fix using PostgreSQL as the session handler backend (Bug #11436).

     Conflicts:

             framework/Core/package.xml

  .../Core/lib/Horde/Core/Factory/SessionHandler.php |    4 +++-
  framework/Core/package.xml                         |    1 +
  2 files changed, 4 insertions(+), 1 deletions(-)

http://git.horde.org/horde-git/-/commit/edf903da8bca7480b07a19d57c83c6098a6e7916
09/24/2012 01:54:50 PM Jan Schneider Assigned to Jan Schneider
State ⇒ Resolved
Priority ⇒ 2. Medium
Patch ⇒ No
 
09/24/2012 01:54:37 PM Git Commit Comment #3 Reply to this comment
Changes have been made in Git (master):

commit edf903da8bca7480b07a19d57c83c6098a6e7916
Author: Jan Schneider <jan@horde.org>
Date:   Mon Sep 24 15:51:48 2012 +0200

     Fix using PostgreSQL as the session handler backend (Bug #11436).

     Conflicts:

             framework/Core/package.xml

  .../Core/lib/Horde/Core/Factory/SessionHandler.php |    4 +++-
  framework/Core/package.xml                         |    1 +
  2 files changed, 4 insertions(+), 1 deletions(-)

http://git.horde.org/horde-git/-/commit/edf903da8bca7480b07a19d57c83c6098a6e7916
09/24/2012 01:54:18 PM Git Commit Comment #2 Reply to this comment
Changes have been made in Git (FRAMEWORK_4):

commit a66453bf3b289aa20f0d7ef8e719ef8f0a1cd7f7
Author: Jan Schneider <jan@horde.org>
Date:   Mon Sep 24 15:51:48 2012 +0200

     Fix using PostgreSQL as the session handler backend (Bug #11436).

  .../Core/lib/Horde/Core/Factory/SessionHandler.php |    4 +++-
  framework/Core/package.xml                         |    2 ++
  2 files changed, 5 insertions(+), 1 deletions(-)

http://git.horde.org/horde-git/-/commit/a66453bf3b289aa20f0d7ef8e719ef8f0a1cd7f7
09/19/2012 12:35:56 PM piper (at) hrz (dot) uni-marburg (dot) de Comment #1
Priority ⇒ 3. High
Type ⇒ Bug
Summary ⇒ PDOException when using SQL-Sessionhandler with Postgresql
Due ⇒ 09/20/2012
Queue ⇒ Horde Base
Milestone ⇒
Patch ⇒ Yes
New Attachment: Horde_Db_Adapter_Pdo_Base.php.patch Download
State ⇒ Unconfirmed
Reply to this comment
When using "conf ['sessionhandler']['type'] = 'Sql';" with a 
Postgresql Database, I am getting these errors:

EMERG: HORDE Could not instantiate PDO with DSN 
"pgsql:driverconfig=horde;umask=63;host=db.hrz.uni-marburg.de;dbname=horde".   
PDOException: SQLSTATE[08006] [7] invalid connection option 
"driverconfig" [pid 26846 on line 46 of 
"/var/www/horde/pear/php/Horde/Db/Adapter/Pdo/Base.php"]

EMERG: HORDE Could not instantiate PDO with DSN 
"pgsql:umask=63;host=db.hrz.uni-marburg.de;dbname=horde".   
PDOException: SQLSTATE[08006] [7] invalid connection option "umask" 
[pid 13889 on line 46 of 
"/var/www/horde/pear/php/Horde/Db/Adapter/Pdo/Base.php"]

Clearing the options 'driverconfig' and 'umask' in 
pear/php/Horde/Db/Adapter/Pdo/Base.php solves this issue, see attached 
patch.

A predecessor to this bug is #8239.

Saved Queries