Oops, sorry! Disregard what I wrote. This was from running the GRASS GIS 6.4.0 that is packaged with QGIS 1.6.0. It appears this version of GRASS is suppressing error messages. I&#39;ve filed a bug report at <meta http-equiv="content-type" content="text/html; charset=utf-8"><a href="http://trac.osgeo.org/qgis/ticket/3470">http://trac.osgeo.org/qgis/ticket/3470</a> (GRASS error(s?) missing error details).<div>

<br></div><div>If you could, check the email that I sent about 15 hours ago titled <b>&quot;fe_sendauth: no password&quot; even though password supplied</b>. It&#39;s a more up-to-date version of this.</div><div><br></div>

<div>Thanks,<br><div><br></div><div>Aren<br><br><div class="gmail_quote">On Mon, Feb 7, 2011 at 8:17 AM, Micha Silver <span dir="ltr">&lt;<a href="mailto:micha@arava.co.il">micha@arava.co.il</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">



  
    
  
  <div style="direction:ltr" text="#000000" bgcolor="#ffffff"><div class="im">
    <p style="margin-bottom:0cm;margin-top:0pt">On 07/02/2011 16:03,
      Aren Cambre wrote:<br>
    </p>
    <blockquote type="cite">Thank you. This is a clean install of GRASS 6.4.0.</blockquote>
    <br></div>
    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&#39;re on Windows, do the equivalent with the gui, or with the
    correct env variable delimiter &#39;%&#39; and path separator &#39;\&#39;.<br>
    <br>
    Now try to import the Postgresql table.<div class="im"><br>
    <br>
    <blockquote 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&#39;t a big deal.</div>
      <div><br>
      </div>
    </blockquote>
    <br></div>
    I don&#39;t see any password error?<br>
    <br>
    -- <br><font color="#888888">
    Micha</font><div><div></div><div class="h5"><br>
    <br>
    <blockquote type="cite">
      <div>Aren<br>
        <br>
        <div class="gmail_quote">On Mon, Feb 7, 2011 at 4:54 AM, Micha
          Silver <span dir="ltr">&lt;<a href="mailto:micha@arava.co.il" target="_blank">micha@arava.co.il</a>&gt;</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>
                <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&#39;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
              (&#39;db.connect -p&#39;) 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&#39;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>
                    <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">&lt;<a href="mailto:aren@arencambre.com" target="_blank">aren@arencambre.com</a>&gt;</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&#39;s the command:
                          <div> <b><font face="&#39;courier new&#39;,
                                monospace">v.in.ogr -o
                                &quot;dsn=PG:dbname=&#39;de&#39; host=localhost
                                port=5432 user=&#39;[redacted]&#39;
                                password=&#39;[redacted]&#39; sslmode=disable&quot;
                                layer=consistent.master
                                output=master_grassX</font></b></div>
                          <div><br>
                          </div>
                          <div>This command was produced by QGIS&#39;s GRASS
                            Tools.</div>
                          <div><br>
                          </div>
                          <div>The problem is that I get an error but no
                            explanation at all. Here&#39;s the output:</div>
                          <blockquote style="margin:0pt 0pt 0pt 40px;border:medium none;padding:0px">
                            <div><img>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>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>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>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>Unable to
                                create table: &#39;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 ))&#39;</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 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&#39;t see
                              anything surprising. I&#39;ve attached the log
                              in case it&#39;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&#39;m new to GRASS, so I&#39;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 href="mailto:grass-user@lists.osgeo.org" target="_blank">grass-user@lists.osgeo.org</a>
<a 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 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 cols="62">-- 
Micha Silver
<a href="http://www.surfaces.co.il/" target="_blank">http://www.surfaces.co.il/</a>
Arava Development Co.  +972-52-3665918
</pre>
  </div></div></div>

</blockquote></div><br></div></div>