Once I changed the db folder permissions, all worked great.
Thank you so much!
Steve
----- Original Message ----- From: "Clark Christensen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 22, 2004 11:49 AM
Subject: Re: [sqlite] unable to open database
--- Steven Lloyd <[EMAIL PROTECTED]> wrote:
I have been using SQLite successfully for quite some time. I recently installed it on a friends server in order to use it there.
While I am able to access the db file just fine when I run my perl script from the shell prompt I get the following error when trying to run it from a cgi-bin.
unable to open database file
This seems to be a permissions issue or something. I have given the db fill full permissions (777) but still no luck.
What else can I check?
Thanks.
Steve
Steve,
In my experience, these kinds of problems are either path, or permissions. I see from your other posts that you're fairly certain it's not path, or file permission on the DB file, so make sure the directory where the DB file lives allows rw for the Web server user (apache?).
If, for example, the db file is in your home dir, you'd need to allow the apache user to have rw premission there. Since that's probably not a good idea, you should consider putting it in its own dir where you can manipulate the permissions to suit.
-Clark
__________________________________ Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! http://my.yahoo.com
