Opened 14 years ago

Closed 14 years ago

Last modified 14 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 by pramsey, 14 years ago

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

Milestone: PostGIS 1.5.2PostGIS 1.5.3

comment:3 by mcayland, 14 years ago

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

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.