[GRASS-user] Adding a point vector

[Markus Metz]

On Sun, Sep 25, 2011 at 12:40 AM, Markus Neteler <neteler at osgeo.org> wrote:
> Hi Kurt,
>
> I can understand your frustration. But...
>
> On Sat, Sep 24, 2011 at 9:06 PM, Kurt Springs <ferret_bard at mac.com> wrote:
>> Sorry about that.
>>
>> I meant to say.  I reran v.in.db with all other programs closed as Markus Metz suggested.  I still got the error message:
>>
>> GRASS 6.4.1 (Mega_Ireland):~ >
>
> This is really 6.4.1? We have made tons of fixes in 6.4.svn, if
> you could update it would be cool and would either already
> solve it for you are enable us to track it better down.
>
>> v.in.db --overwrite table=wedge_tomb driver=sqlite database=/Users/kurtsprings/Document/wedge.db x=nat_grid_e y=nat_grid_n key=cat output=wedge_tomb
>> WARNING: Vector map <wedge_tomb> already exists and will be overwritten
>> DBMI-SQLite driver error:
>> Unable to open database: unable to open database file
>
> With "lsof" you could check who has opened the file (dunno where lsof
> is on Mac), something like:
>
> /usr/sbin/lsof /Users/kurtsprings/Document/wedge.db
>
What I wanted to suggest was that another program but grass may keep
files in that folder, or even the sqlite database itself open.
You could try to close grass, open the database with sqlite or
sqlitebrowser and see if that works, then open grass and again try to
open the sqlite database not with grass but with sqlite or
sqlitebrowser. At least then we would know if the problem is with
sqlite or with grass.

In the hope that you're not giving up yet,

Markus M