Opened 6 years ago

Closed 6 years ago

Last modified 6 years ago

#572 closed defect (fixed)

Password whitespace for Shape File to PostGIS Importer not supported

Reported by: dandy Owned by: pramsey
Priority: medium Milestone: PostGIS 1.5.2
Component: postgis Version: 1.5.X
Keywords: password shapefile importer Cc:

Description

Shape File to PostGIS Importer tool does not handle passwords with white space correctly.

Connecting: user=postgres password= a brick port=5432 host=localhost dbname=postgis

Connection failed: missing "=" after "a" in connection info string

Change History (4)

comment:1 Changed 6 years ago by pramsey

Yes, the password string builder plops the password in verbatim, which means you get something like

  dbname=foo user=bar password=pass word

This link gives some advice on how to construct a string with spaces

http://php.net/manual/en/function.pg-connect.php

Since solution 'is to' use single-quotes, that means that passwords with single-quotes must be themselves escaped

  dbname=foo password='pass word\'s'

comment:2 Changed 6 years ago by robe

  • Milestone changed from PostGIS 1.5.2 to PostGIS 1.5.3

comment:3 Changed 6 years ago by mcayland

  • Milestone changed from PostGIS 1.5.3 to PostGIS 1.5.2
  • Resolution set to fixed
  • Status changed from new to closed

Fixed in 1.5 branch with r5983 and trunk in r5984. Regina, please can you confirm at your end?

comment:4 Changed 6 years ago by robe

I won't be able to until tomorrow. Besides I'd rather test on a packaged rc1 so I can test all the packaging and all the other fixes in one g. Can we have an rc1 please.

Note: See TracTickets for help on using tickets.