Bug #62479 [Opn]: PDO-psql cannot connect if password contains spaces

From:	brice at bmaron dot net	Date:	Wed, 04 Jul 2012 12:29:56 +0000
Subject:	Bug #62479 [Opn]: PDO-psql cannot connect if password contains spaces
References:	1	Groups:	php.bugs
Request:	Send a blank email to php-bugs+get-171737@lists.php.net to get a copy of this message

Edit report at https://bugs.php.net/bug.php?id=62479&edit=1

 ID:                 62479
 User updated by:    brice at bmaron dot net
 Reported by:        brice at bmaron dot net
 Summary:            PDO-psql cannot connect if password contains spaces
 Status:             Open
 Type:               Bug
 Package:            PDO related
 Operating System:   Linux- Debian Stable
 PHP Version:        5.3.14
 Block user comment: N
 Private report:     N

 New Comment:

It seems to be a pdo-psql only ... not affecting other drivers like mysql


Previous Comments:
------------------------------------------------------------------------
[2012-07-04 08:56:06] brice at bmaron dot net

Description:
------------
When you try to connect to a Postgresql database with a password containing 1 or more spaces, pdo
will fail to connect.

You must escape yourself the user & password and put it into the dsn to make it work.

It may also be true for other databases ... it's not tested

Test script:
---------------
https://gist.github.com/3046155

Expected result:
----------------
See a connection and no error for both tries 

Actual result:
--------------
See an error for the first one and a correct result for the second one


------------------------------------------------------------------------



-- 
Edit this bug report at https://bugs.php.net/bug.php?id=62479&edit=1


   

Thread (16 messages)

• brice at bmaron dot netWed, 04 Jul 2012 08:56:06 +0000
  • brice at bmaron dot netWed, 04 Jul 2012 12:29:56 +0000Bug #62479 [Opn]: PDO-psql cannot connect if password contains spaces
  • willfitch@php.netMon, 17 Sep 2012 19:38:13 +0000Bug #62479 [Opn->Ver]: PDO-psql cannot connect if password contains spaces
  • willfitch@php.netMon, 17 Sep 2012 19:39:08 +0000Bug #62479 [Com]: PDO-psql cannot connect if password contains spaces
  • willfitch@php.netThu, 20 Sep 2012 20:12:00 +0000Bug #62479 [Ver]: PDO-psql cannot connect if password contains spaces
  • iliaa@php.netWed, 31 Oct 2012 01:51:40 +0000Bug #62479 [PATCH]: PDO-psql cannot connect if password contains spaces
  • iliaa@php.netWed, 31 Oct 2012 01:53:20 +0000Bug #62479 [Ver]: PDO-psql cannot connect if password contains spaces
  • willfitch@php.netWed, 31 Oct 2012 18:47:05 +0000Bug #62479 [Com]: PDO-psql cannot connect if password contains spaces
  • stas@php.netMon, 22 Jul 2013 04:37:36 +0000Bug #62479 [Ver]: PDO-psql cannot connect if password contains spaces
  • willfitch@php.netFri, 08 Nov 2013 15:09:29 +0000Bug #62479 [Com]: PDO-psql cannot connect if password contains spaces
  • willfitch@php.netWed, 08 Jan 2014 15:22:43 +0000Bug #62479 [Com]: PDO-psql cannot connect if password contains spaces
  • willfitch@php.netFri, 10 Jan 2014 02:49:05 +0000Bug #62479 [Com]: PDO-psql cannot connect if password contains spaces
  • willfitch@php.netSat, 18 Jan 2014 22:05:34 +0000Bug #62479 [Ver]: PDO-psql cannot connect if password contains spaces
  • willfitch@php.netSun, 19 Jan 2014 00:49:19 +0000Bug #62479 [Ver->Csd]: PDO-psql cannot connect if password contains spaces
  • ab@php.netSun, 19 Jan 2014 01:40:00 +0000Bug #62479 [Csd]: PDO-psql cannot connect if password contains spaces
  • willfitch@php.netSun, 19 Jan 2014 01:43:08 +0000Bug #62479 [Csd]: PDO-psql cannot connect if password contains spaces