I am flamboozled by this error. I am running GRASS GIS 6.4 on Windows 7 32 bit.
I am running this command (user ID and password redacted):
v.in.ogr -o “dsn=PG:dbname=‘de’ host=localhost port=5432 user=‘XXX’ password=‘YYY’ sslmode=disable” layer=consistent.master output=master_grass4 --verbose
Here’s the result:
Over-riding projection check
Layer: consistent.master
Width for column school_zone set to 255 (was not specified by OGR), some strings may be truncated!
Width for column vehicle_color set to 255 (was not specified by OGR), some strings may be truncated!
Width for column offense_location set to 255 (was not specified by OGR), some strings may be truncated!
Width for column work_zone set to 255 (was not specified by OGR), some strings may be truncated!
DBMI-Postgres driver error:
Cannot connect to Postgres: fe_sendauth: no password
supplied
Unable to open database <host=localhost,dbname=de> by driver
ERROR: Unable open database <host=localhost,dbname=de> by driver
I don’t understand why I am getting the highlighted error. I am supplying the user ID and password for the DB’s root and only user. I know these are correct; I’ve triple-checked. And it’s able to read the database; otherwise it wouldn’t be able to see those four columns and complain about the width.
Am I missing something?
Aren Cambre
Well, this is weird. If I add -t (“Do not create attribute table” per http://grass.osgeo.org/grass64/manuals/html64_user/v.in.ogr.html), it all works.
I’m guessing this is a bug, so I’ve filed a report at http://trac.osgeo.org/grass/ticket/1274.
Aren
On Sun, Feb 6, 2011 at 4:57 PM, Aren Cambre <aren@arencambre.com> wrote:
I am flamboozled by this error. I am running GRASS GIS 6.4 on Windows 7 32 bit.
I am running this command (user ID and password redacted):
v.in.ogr -o “dsn=PG:dbname=‘de’ host=localhost port=5432 user=‘XXX’ password=‘YYY’ sslmode=disable” layer=consistent.master output=master_grass4 --verbose
Here’s the result:
Over-riding projection check
Layer: consistent.master
Width for column school_zone set to 255 (was not specified by OGR), some strings may be truncated!
Width for column vehicle_color set to 255 (was not specified by OGR), some strings may be truncated!
Width for column offense_location set to 255 (was not specified by OGR), some strings may be truncated!
Width for column work_zone set to 255 (was not specified by OGR), some strings may be truncated!
DBMI-Postgres driver error:
Cannot connect to Postgres: fe_sendauth: no password
supplied
Unable to open database <host=localhost,dbname=de> by driver
ERROR: Unable open database <host=localhost,dbname=de> by driver
I don’t understand why I am getting the highlighted error. I am supplying the user ID and password for the DB’s root and only user. I know these are correct; I’ve triple-checked. And it’s able to read the database; otherwise it wouldn’t be able to see those four columns and complain about the width.
Am I missing something?
Aren Cambre