Opened 7 years ago

Closed 7 years ago

Last modified 7 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:


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 7 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

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 7 years ago by robe

Milestone: PostGIS 1.5.2PostGIS 1.5.3

comment:3 Changed 7 years ago by mcayland

Milestone: PostGIS 1.5.3PostGIS 1.5.2
Resolution: fixed
Status: newclosed

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

comment:4 Changed 7 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.