<div dir="ltr">Hi Markus,<div><br></div><div>Used 'db.connect' driver=sqlite database=$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db</div><div><br></div><div><u>I had to delete</u> 'database schema=grass_gis'</div><div><br></div><div><u>I had to delete</u> 'default group=postgis_reader'</div><div><br></div><div>Then 'RUN'</div><div><br></div><div>output:-</div><div><br></div><div><div>(Mon Jul 02 14:59:21 2018) </div><div>db.connect </div><div>(Mon Jul 02 14:59:22 2018) Command finished (1 sec) </div><div><br></div><div>now attempted 'r.to.vect' </div></div><div><br></div><div><div>r.to.vect input=APGB_aerial_2_i_segment_drained_peat_with_exposed_haggs@PERMANENT output=test1 type=area</div><div>DBMI-SQLite driver error:</div><div>Error in sqlite3_prepare():</div><div>unknown database <font color="#000000" style="background-color:rgb(255,255,0)">grass_gis</font></div><div>DBMI-SQLite driver error:</div><div>Error in sqlite3_prepare():</div><div>unknown database grass_gis</div><div>ERROR: Unable to create table: create table <span style="background-color:rgb(255,255,0)">grass_gis</span>.test1 ( cat integer, value integer, label varchar(10))</div><div>WARNING: Table <<span style="background-color:rgb(255,255,0)"><font color="#000000" style="">grass_gis</font></span>.test1> linked to vector map <test1> does not exist</div></div><div><br></div><div>
<div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial">Repeat as above!!</div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><br></div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial">Used 'db.connect' driver=sqlite database=$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db</div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><br></div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><u>I had to delete</u><span> </span>'database schema=grass_gis'</div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><br></div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><u>I had to delete</u><span> </span>'default group=postgis_reader'</div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><br></div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial">Then 'RUN'</div>
<br></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On 2 July 2018 at 14:41, Markus Metz <span dir="ltr"><<a href="mailto:markus.metz.giswork@gmail.com" target="_blank">markus.metz.giswork@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><br><br>On Mon, Jul 2, 2018 at 3:25 PM, Paul Shapley <<a href="mailto:p.shapley@gmail.com" target="_blank">p.shapley@gmail.com</a>> wrote:<br>><br>> Hi Markus,<br>><br><div>> I used 'db.connect' <br></div><div><br></div><div>which flags/options did you use?<br></div><div><br></div><div>> followed by 'db.login'</div><div><br></div><div>you don't need db.login for sqlite<br></div>><br>> Please see below:-<br>><br>> db.connect -p <br>> driver: sqlite<br>> database: C:\\TempLocation\PERMANENT\<wbr>sqlite\sqlite.db<br>> schema: grass_gis<br>> group: postgis_reader<br>> (Mon Jul 02 14:17:04 2018) Command finished (0 sec)<br>><br>> db.connect -d <br>> Default driver / database set to:<br>> driver: sqlite<br>> database: C:\\TempLocation\PERMANENT\<wbr>sqlite\sqlite.db<br>> (Mon Jul 02 14:19:40 2018) Command finished (0 sec)<br>><br><div>> Still holding 'schema' and 'group' details from PostGIS. Shouldn't these have been dropped when changing to sqlite which is perhaps why the connection is failing?</div><div><br></div><div>yes.</div><div><br></div><div>It seems that db.connect -g is better than db.connect -p to verify connection settings, e.g. I get in the North Carolina sample dataset</div><div><br></div><div>> db.connect -g<br>driver=sqlite<br>database=$GISDBASE/$LOCATION_<wbr>NAME/$MAPSET/sqlite/sqlite.db<br>schema=<br>group=<br></div><div><br></div><div>The database is not a real path but contains GRASS variables that are evaluated on the fly. This is the default connection.</div><div><br></div><div>Markus M</div><div><br></div>><br>> On 2 July 2018 at 14:10, Markus Metz <<a href="mailto:markus.metz.giswork@gmail.com" target="_blank">markus.metz.giswork@gmail.com</a><wbr>> wrote:<br>>><br>>><br>>><br>>> On Mon, Jul 2, 2018 at 2:00 PM, Paul Shapley <<a href="mailto:p.shapley@gmail.com" target="_blank">p.shapley@gmail.com</a>> wrote:<br>>> ><br>>> > Hi Users,<br>>> ><br>>> > I want to use 'r.to.vect' but it seems to default to a 'Postgis' table that has no geometry column just a table with a 'cat' id. I would like to export to 'sqlite'. I have both postgres an sqlite login details stored in 'db.login'. How do i switch between the two or at least make sqlite the default? If I change settings with 'db.connect' to 'sqlite'<br>>><br>>> what is the exact command you used to set the default connection to sqlite?<br>>><br>>> You can also try db.connect -d, otherwise you might need to specify the default database to be used.<br>>><br>>> In any case, please verify first with db.connect -p to see the connection details used when creating a new vector.<br>>><br>>> Markus M<br>>><br>>> > it fails (error below) but still keeps holding onto the 'grass_gis' schema form the Postgis connection!<br>>> ><br>>> > r.to.vect input=APGB_aerial_2_i_segment_<wbr>drained_peat_with_exposed_<wbr>haggs@PERMANENT output=test1 type=area<br>>> > DBMI-SQLite driver error:<br>>> > Error in sqlite3_prepare():<br>>> > unknown database grass_gis<br>>> > DBMI-SQLite driver error:<br>>> > Error in sqlite3_prepare():<br>>> > unknown database grass_gis<br>>> > ERROR: Unable to create table: create table grass_gis.test1 ( cat integer, value integer, label varchar(10))<br>>> > WARNING: Table <grass_gis.test1> linked to vector map <test1> does not exist<br>>> ><br>>> > Is there a preferred option to change databases more cleanly.<br>>> ><br>>> > Many thanks,<br>>> ><br>>> ><br>>> > --<br>>> > Paul J. Shapley MSc CGeog (GIS) FRGS<br>>> ><br>>> ><br>>> > ______________________________<wbr>_________________<br>>> > grass-user mailing list<br>>> > <a href="mailto:grass-user@lists.osgeo.org" target="_blank">grass-user@lists.osgeo.org</a><br>>> > <a href="https://lists.osgeo.org/mailman/listinfo/grass-user" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/grass-user</a><br>>><br>><br>><span class="HOEnZb"><font color="#888888"><br>><br>> --<br>> Paul J. Shapley MSc CGeog (GIS) FRGS<br>><br></font></span></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><b>Paul J. Shapley </b><span style="font-family:times new roman,serif"><font size="2"><span style="font-family:arial,helvetica,sans-serif">MSc CGeog (GIS) FRGS</span></font><br></span><b><br></b></div></div>
</div>