<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html style="direction: ltr;">
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body style="direction: ltr;" bidimailui-charset-is-forced="true"
bidimailui-detected-decoding-type="latin-charset" text="#000000"
bgcolor="#ffffff">
<p style="margin-bottom: 0cm; margin-top: 0pt;">On 07/02/2011 16:03,
Aren Cambre wrote:<br>
</p>
<blockquote
cite="mid:AANLkTi=4hWw9mjJP9n1Me1Pusdwrtti7=4KBzVLsAupo@mail.gmail.com"
type="cite">Thank you. This is a clean install of GRASS 6.4.0.</blockquote>
<br>
So you can set the local GRASS database to sqlite with the
db.connect command.<br>
I think you first need to create an empty sqlite database with:<br>
# first get the environment variables:<br>
eval `g.gisenv`<br>
# create a database file<br>
sqlite $GISDBASE/$LOCATION_NAME/$MAPSET/sqlite.db<br>
# Enter .q to leave the sqlite command line<br>
# Now change the default database settings<br>
db.connect driver=sqlite
database=$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite.db<br>
<br>
(If you're on Windows, do the equivalent with the gui, or with the
correct env variable delimiter '%' and path separator '\'.<br>
<br>
Now try to import the Postgresql table.<br>
<br>
<blockquote
cite="mid:AANLkTi=4hWw9mjJP9n1Me1Pusdwrtti7=4KBzVLsAupo@mail.gmail.com"
type="cite">
<div><br>
</div>
<div>I hear you on the column warnings, but does that explain a
missing password error? Seems like two different errors. I did
some Googling earlier and what I found suggests the column
warnings aren't a big deal.</div>
<div><br>
</div>
</blockquote>
<br>
I don't see any password error?<br>
<br>
-- <br>
Micha<br>
<br>
<blockquote
cite="mid:AANLkTi=4hWw9mjJP9n1Me1Pusdwrtti7=4KBzVLsAupo@mail.gmail.com"
type="cite">
<div>Aren<br>
<br>
<div class="gmail_quote">On Mon, Feb 7, 2011 at 4:54 AM, Micha
Silver <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:micha@arava.co.il">micha@arava.co.il</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left: 1ex;">
<div style="direction: ltr;" text="#000000"
bgcolor="#ffffff">
<div class="im">
<p style="margin-bottom: 0cm; margin-top: 0pt;">On
06/02/2011 07:35, Aren Cambre wrote:<br>
</p>
<blockquote type="cite">I think the problem may actually
be with the build of GRASS GIS shipped with QGIS. I
just installed 6.4.1 RC1 and now get a useful error.</blockquote>
<br>
</div>
Could be that you came across a bug, but...<br>
If you're trying to import a PostGIS table into GRASS as a
GRASS vector, then you need to note what database GRASS is
using. From the error below your GRASS db connection
('db.connect -p') is local dbf files. In that case I
believe that several of the column headers from the
original PostGIS table are too long for the dbf format.
That might be part of the problem... Also it could be that
some of the data types from PostGIS aren't accepted by
dbf.<br>
It might be best to move your whole GRASS database setup
to sqlite - more robust and full featured.<br>
<br>
<blockquote type="cite">
<div>
<div class="h5">
<div><br>
</div>
<div>Aren<br>
<br>
<div class="gmail_quote">On Sat, Feb 5, 2011 at
10:15 PM, Aren Cambre <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:aren@arencambre.com"
target="_blank">aren@arencambre.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:
0pt 0pt 0pt 0.8ex; border-left: 1px solid
rgb(204, 204, 204); padding-left: 1ex;">I am
running <b>v.in.ogr</b> to import a PostGIS
table. This table shows up fine in QGIS.
Here's the command:
<div> <b><font face="'courier new',
monospace">v.in.ogr -o
"dsn=PG:dbname='de' host=localhost
port=5432 user='[redacted]'
password='[redacted]' sslmode=disable"
layer=consistent.master
output=master_grassX</font></b></div>
<div><br>
</div>
<div>This command was produced by QGIS's GRASS
Tools.</div>
<div><br>
</div>
<div>The problem is that I get an error but no
explanation at all. Here's the output:</div>
<blockquote style="margin: 0pt 0pt 0pt 40px;
border: medium none; padding: 0px;">
<div><img moz-do-not-send="true">Width for
column school_zone set to 255 (was not
specified by OGR), some strings may be
truncated!</div>
<div>
<p style="margin: 0px; text-indent: 0px;">
<img moz-do-not-send="true">Width for
column vehicle_color set to 255 (was not
specified by OGR), some strings may be
truncated!</p>
</div>
<div>
<p style="margin: 0px; text-indent: 0px;">
<img moz-do-not-send="true">Width for
column offense_location set to 255 (was
not specified by OGR), some strings may
be truncated!</p>
</div>
<div>
<p style="margin: 0px; text-indent: 0px;">
<img moz-do-not-send="true">Width for
column work_zone set to 255 (was not
specified by OGR), some strings may be
truncated!</p>
</div>
<div>
<p style="margin: 0px; text-indent: 0px;">
<span>DBMI-DBF driver error:</span></p>
</div>
<div>
<p style="margin: 0px; text-indent: 0px;">
<span><br>
</span></p>
</div>
<div>
<p style="margin: 0px; text-indent: 0px;"><span><br>
</span></p>
</div>
<div>
<p style="margin: 0px; text-indent: 0px;"><img
moz-do-not-send="true">Unable to
create table: 'create table
master_grassX (cat integer,
offense_street_name varchar ( 30 ),
school_zone varchar ( 255 ),
defendant_dl varchar ( 20 ),
defendant_dl_state varchar ( 2 ),
vehicle_model varchar ( 20 ),
offense_code integer, vehicle_color
varchar ( 255 ), citation_id_base
varchar ( 20 ), vehicle_make varchar (
20 ), defendant_dob date, speed_limit
integer, source varchar ( 20 ),
vehicle_registration_expiration_date
date, offense_crossstreet_number varchar
( 10 ), defendant_sex varchar ( 1 ),
citing_jurisdiction integer,
offense_county varchar ( 10 ),
officer_id varchar ( 20 ),
offense_location varchar ( 255 ),
defendant_zip varchar ( 9 ),
vehicle_licenseplate_state varchar ( 2
), offense_street_number varchar ( 10 ),
offense_timestamp datetime,
citation_id_stub varchar ( 20 ),
offense_crossstreet_name varchar ( 30 ),
speed_alleged integer, vehicle_year
integer, vehicle_licenseplate varchar (
10 ), work_zone varchar ( 255 ),
defendant_race varchar ( 10 ))'</p>
</div>
<div>
<p style="margin: 0px; text-indent: 0px;"><span
style="font-weight: 600;">Finished
with error</span></p>
</div>
</blockquote>
<div>
<p style="margin: 0px; text-indent: 0px;">The
problem is I get no details at all on the
error cause. Yes, the driver error really
is blank.</p>
<p style="margin: 0px; text-indent: 0px;"><br>
</p>
<p style="margin: 0px; text-indent: 0px;"> I
turned postgres logging to log all queries
(following the recipe at <a
moz-do-not-send="true"
href="http://stackoverflow.com/questions/722221/how-to-log-postgres-sql-queries"
target="_blank">http://stackoverflow.com/questions/722221/how-to-log-postgres-sql-queries</a>).
I analyzed the queries and didn't see
anything surprising. I've attached the log
in case it's helpful.</p>
<p style="margin: 0px; text-indent: 0px;"><br>
</p>
<p style="margin: 0px; text-indent: 0px;"> I
checked the <b>/dbf</b> directory, and it
has no files. I also checked the <b>vector/master_grassX</b> directory
and found no problems, just four files (<b>coor</b>,
<b>dbln</b>, <b>head</b>, <b>hist</b>)
with unsurprising contents.</p>
<p style="margin: 0px; text-indent: 0px;"><br>
</p>
<p style="margin: 0px; text-indent: 0px;">
I'm new to GRASS, so I'm not sure what
else to check. Is there another log
source? Did I discover a bug that needs to
be filed?</p>
<p style="margin: 0px; text-indent: 0px;"> <br>
</p>
<font color="#888888">
<p style="margin: 0px; text-indent: 0px;">Aren
Cambre</p>
</font></div>
</blockquote>
</div>
<br>
</div>
<br>
</div>
</div>
This mail was received via Mail-SeCure System.<br>
<pre><fieldset></fieldset>
_______________________________________________
grass-user mailing list
<a moz-do-not-send="true" href="mailto:grass-user@lists.osgeo.org" target="_blank">grass-user@lists.osgeo.org</a>
<a moz-do-not-send="true" href="http://lists.osgeo.org/mailman/listinfo/grass-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/grass-user</a>
This mail was received via Mail-SeCure System.
</pre>
</blockquote>
<br>
<br>
<pre cols="62">--
Micha Silver
<a moz-do-not-send="true" href="http://www.surfaces.co.il/" target="_blank">http://www.surfaces.co.il/</a>
Arava Development Co. +972-52-3665918
</pre>
</div>
</blockquote>
</div>
<br>
</div>
<br>
This mail was received via Mail-SeCure System.<br>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="62">--
Micha Silver
<a class="moz-txt-link-freetext" href="http://www.surfaces.co.il/">http://www.surfaces.co.il/</a>
Arava Development Co. +972-52-3665918
</pre>
</body>
</html>