Opened 12 years ago

Closed 12 years ago

#920 closed defect (invalid)

db.tables is unable to open database in Grass 6.5 using sqlite

Reported by: epatton Owned by: grass-dev@…
Priority: normal Milestone: 6.5.0
Component: Database Version: svn-develbranch6
Keywords: sqlite Cc:
CPU: x86-64 Platform: Linux

Description

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.

Change History (2)

comment:1 Changed 12 years ago by neteler

Keywords: sqlite added

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

comment:2 Changed 12 years ago by epatton

Resolution: invalid
Status: newclosed

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.

Note: See TracTickets for help on using tickets.