From: David Masover <ninja@...>
Date: 2010-03-25T12:50:07+09:00
Subject: Re: SQLite3 Exception

On Tuesday 23 March 2010 09:16:44 pm Miles Smith wrote:
> When I run as root, the db can be accessed fine, however, when I run it as
>  a normal user, I get a SQLite3::SQLException: unable to open database
>  file: error.

What happens when you try to access the file with the sqlite3 binary? Or with, 
say, the 'file' command? Are you sure it's a Unix permission issue?

> Now I've already chmoded the DB to 0777

Don't do that. Ever.

EVER.

> and set the owner to the user in
>  question,

Do that and set the DB to, say, mode 0600. That should be plenty.

>  however the issue still remains.
> 
> Any ideas?

Phrogz had a good idea with checking the directory, or parent directories.