<div dir="ltr">Hi,<div><br></div><div>I run into this issue today:</div><div><br></div><div><p style="margin:0px 0px 0.714285em;padding:0px;border:0px;line-height:1.428571em;color:rgb(0,0,0);font-family:Helvetica,Arial,'Droid Sans',sans-serif;font-size:14px">r.to.vect input=tty output=tty type=area --o</p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px;line-height:1.428571em;color:rgb(0,0,0);font-family:Helvetica,Arial,'Droid Sans',sans-serif;font-size:14px">Extracting areas...<br clear="none">Writing areas...<br clear="none">dbmi: Protocol error<br clear="none">ERROR: Cannot insert new row: insert into tty values (3968805, 12, '')<br clear="none">dbmi: Protocol error</p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px;line-height:1.428571em;color:rgb(0,0,0);font-family:Helvetica,Arial,'Droid Sans',sans-serif;font-size:14px">Running db.connect -p I found out that my database was dbf. I'm running GRASS 7.1.svn (r65027). Naive question: default database is not sqlite?</p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px">db.connect --help</span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><span style="font-size:14px;line-height:19.9999942779541px;color:rgb(0,0,0);font-family:Helvetica,Arial,'Droid Sans',sans-serif">Description:</span><br></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px"> Prints/sets general DB connection for current mapset.</span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px"><br></span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px">Keywords:</span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px"> database, attribute table, connection settings</span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px"><br></span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px">Usage:</span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px"> db.connect [-pgcd] [driver=name] [database=name] [schema=name]</span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px">   [group=string] [--help] [--verbose] [--quiet] [--ui]</span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px"><br></span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px">Flags:</span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px">  -p   Print current connection parameters and exit</span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px">        Substitute variables in database settings</span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px">  -g   Print current connection parameters using shell style and exit</span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px">  -c   Check connection parameters, set if uninitialized, and exit</span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px">  -d   Set from default settings and exit</span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px">        Overwrite current settings if already initialized</span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px"> --h   Print usage summary</span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px"> --v   Verbose module output</span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px"> --q   Quiet module output</span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px"> --ui  Force launching GUI dialog</span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px"><br></span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px">Parameters:</span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px">    driver   Name of database driver</span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px">             options: ogr,sqlite,dbf</span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px">             default: sqlite</span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px">  database   Name of database</span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px">             <b>default: $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/</b></span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px">    schema   Database schema</span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px">              Do not use this option if schemas are not supported by driver/database server</span></font></p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px"><font color="#000000" face="Helvetica, Arial, Droid Sans, sans-serif"><span style="font-size:14px;line-height:19.9999942779541px">     group   Default group of database users to which select privilege is granted</span></font></p><div><br></div><p style="margin:0px 0px 0.714285em;padding:0px;border:0px;line-height:1.428571em;color:rgb(0,0,0);font-family:Helvetica,Arial,'Droid Sans',sans-serif;font-size:14px">I'm puzzled.</p><p style="margin:0px 0px 0.714285em;padding:0px;border:0px;line-height:1.428571em;color:rgb(0,0,0);font-family:Helvetica,Arial,'Droid Sans',sans-serif;font-size:14px">madi before massive morning coffee.</p><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr"><div><font color="#666666">Best regards,</font></div><div><font color="#666666"><br></font></div><div><font color="#666666">Dr. Margherita DI LEO    </font></div><div><span style="color:rgb(102,102,102);font-family:arial;font-size:small">Scientific / technical project officer</span><br></div><div><font color="#666666"><br></font></div><div><font color="#666666">European Commission - DG JRC </font></div><div><font color="#666666">Institute for Environment and Sustainability (IES)</font></div><div><font color="#666666">Via Fermi, 2749</font></div><div><font color="#666666">I-21027 Ispra (VA) - Italy - TP 261</font></div><div><font color="#666666">       </font></div><div><font color="#666666">Tel. +39 0332 78 3600   </font></div><div><font color="#666666"><a href="mailto:margherita.di-leo@jrc.ec.europa.eu" target="_blank">margherita.di-leo@jrc.ec.europa.eu</a></font></div><div><font color="#666666"><br></font></div><div><font color="#666666">Disclaimer: The views expressed are purely those of the writer and may not in any circumstance be regarded as stating an official position of the European Commission.</font></div></div></div>
</div></div>