[GRASS-dev] [GRASS GIS] #920: db.tables is unable to open database in Grass 6.5 using sqlite

GRASS GRASS developer
1

#920: db.tables is unable to open database in Grass 6.5 using sqlite
----------------------+-----------------------------------------------------
Reporter: epatton | Owner: grass-dev@lists.osgeo.org
     Type: defect | Status: new
Priority: normal | Milestone: 6.5.0
Component: Database | Version: svn-develbranch6
Keywords: | Platform: Linux
      Cpu: x86-64 |
----------------------+-----------------------------------------------------
db.tables gives an error when I try to print a list of tables in my
current Location:

{{{
db.connect -p
driver:sqlite
database:/home/epatton/Projects/Canso/PERMANENT/databases/Canso.db
schema:
group:

db.tables -p
DBMI-SQLite driver error:
Unable to open database: unable to open database file

ERROR: Unable to open database
        </home/epatton/Projects/Canso/PERMANENT/databases/Canso.db>
}}}

The directory where my database is located is readable, writable, and
owned by me. I can also browse the database in question using
sqlitebrowser with no problems; I just can't access it through Grass.

Am I overlooking something simple?

~ Eric.

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/920&gt;
GRASS GIS <http://grass.osgeo.org>

2

#920: db.tables is unable to open database in Grass 6.5 using sqlite
-----------------------+----------------------------------------------------
  Reporter: epatton | Owner: grass-dev@lists.osgeo.org
      Type: defect | Status: new
  Priority: normal | Milestone: 6.5.0
Component: Database | Version: svn-develbranch6
Resolution: | Keywords: sqlite
  Platform: Linux | Cpu: x86-64
-----------------------+----------------------------------------------------
Changes (by neteler):

  * keywords: => sqlite

Comment:

Just for paranoia (copy-paste):

{{{
ls -la /home/epatton/Projects/Canso/PERMANENT/databases/Canso.db
}}}
?

and how about
{{{
sqlite3 /home/epatton/Projects/Canso/PERMANENT/databases/Canso.db
}}}
? (leave with CTRL-D).

and then
{{{
db.drivers -p
}}}

(perhaps SQLite support missing?)

Markus

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/920#comment:1&gt;
GRASS GIS <http://grass.osgeo.org>

3

#920: db.tables is unable to open database in Grass 6.5 using sqlite
-----------------------+----------------------------------------------------
  Reporter: epatton | Owner: grass-dev@lists.osgeo.org
      Type: defect | Status: closed
  Priority: normal | Milestone: 6.5.0
Component: Database | Version: svn-develbranch6
Resolution: invalid | Keywords: sqlite
  Platform: Linux | Cpu: x86-64
-----------------------+----------------------------------------------------
Changes (by epatton):

  * status: new => closed
  * resolution: => invalid

Comment:

Thanks for the clue! The problem was that my Grass location 'Canso' was
transferred from another computer, and I am now working with it on my
laptop; however, my username on the other PC is 'epatton', whereas it is
'eric' on the laptop, and the database connection was looking for epatton.

Thanks!

~ Eric.

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/920#comment:2&gt;
GRASS GIS <http://grass.osgeo.org>