From: Patrick Doyle <wpdster@...>
Date: 2009-02-06T22:02:59+09:00
Subject: Re: sqlite3/activer record permissions problem (no ror)

--0003255760ce617c4704623fa646
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

My guess is that the sqlite database is owned by root (or by anybody other
than the user 'Apache') and does not have world write privileges.  Look at
the permissions on the database file.

--wpd


On Thu, Feb 5, 2009 at 10:02 PM, Doug Jolley <ddjolley@gmail.com> wrote:

> I'm using Ruby and ActiveRecord in a web environment (no ror). The
> database is sqlite3.  sqlite3-ruby is installed.  I can add records to
> the database from Ruby scripts using ActiveRecord just fine provided
> that I am root.  However, as any other user it bombs out with the error
> message shown below.  If this is going to work for me, I need to have
> the user 'Apache' be able to add records to the database.  Can anyone
> please tell me what the problem is and how I might fix it.  Thanks for
> any input.  Here is the relevant part of the error message:
>
>
> /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract_adapter.rb:150:in
> `log': SQLite3::SQLException: SQL logic error or missing database:
> INSERT INTO news
> --
> Posted via http://www.ruby-forum.com/.
>
>

--0003255760ce617c4704623fa646--