PDO-psql cannot connect if password contains spaces

 [2012-07-04 12:29 UTC] brice at bmaron dot net

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

 [2012-09-17 19:38 UTC] willfitch@php.net

-Status: Open +Status: Verified -Assigned To: +Assigned To: willfitch

 [2012-09-17 19:39 UTC] willfitch@php.net

I have confirmed your findings. Let me do a little sniffing around and see what I 
can come up with.

 [2012-10-31 01:53 UTC] iliaa@php.net

I think the attached patch maybe slightly better than the one proposed, the 
attached patch also accounts for passwords that may contain \ character inside 
them.

 [2012-10-31 18:47 UTC] willfitch@php.net

Thanks Iliaa -

I will update the pull request to take into account escaping backslashes as well.

 [2013-07-22 04:37 UTC] stas@php.net

Will, any news on the updated patch?

 [2013-11-08 15:09 UTC] willfitch@php.net

@stas - last I heard we're taking Iliaa's patch that's attached here.

 [2014-01-01 12:37 UTC] felipe@php.net

-Package: PDO related +Package: PDO PgSQL

 [2014-01-08 15:22 UTC] willfitch@php.net

It doesn't look like any patch was applied and there are conflicts with both Iliaa's and my previous patches.  I'm going to merge the patches/conflicts and make a new PR on Github.

 [2014-01-18 22:05 UTC] willfitch@php.net

I plan on merging this tonight unless I have pushback.  This will go upstream from 5.3+

 [2014-01-19 01:40 UTC] ab@php.net

Hi,

i don't quite get why we need the PDOTEST_DSN along with PDO_PGSQL_TEST_DSN. Those would differentiate themselves only with the password= param. Maybe just cutoff the password param from PDO_PGSQL_TEST_DSN? Were simpler than having to set PDOTEST_DSN just for this one test. Will need to be fixed somewhen.

Cheers.

 [2014-01-19 01:43 UTC] willfitch@php.net

@ab - agreed.  Not sure where the logic was when that was created, but I avoid using it.