Saturday, February 28, 2009

Permission denied - db/test.sqlite3

I'm investigating creating a plugin for Redmine and having a good old time when I decide to clear out the test database:

C:\dev\redmine>rake db:test:purge
(in C:/dev/redmine)
rake aborted!
Permission denied - db/test.sqlite3

Boo! 

I don't know what made me think of it but I tried unsetting my RAILS_ENV environment variable (I had it set to "test"):

C:\dev\redmine>set rails_env=

C:\dev\redmine>rake db:test:purge
(in C:/dev/redmine)

C:\dev\redmine>

Hurrah!

Posted by at
Labels: ,

5 comments :

  1. Titus BarikSeptember 14, 2010 at 6:38 PM

    Problem still exists for me in Ruby 1.8.7. Permission denied when using SQLite 3, but only when the target is test.

    rake db:test:purge may work, but db:test:prepare is not.

    ReplyDelete
  2. AnonymousSeptember 14, 2011 at 12:29 PM

    @Titus, do you have a console open in the test environment?

    http://stackoverflow.com/questions/1234471/rails-rake-testfunctionals-cannot-access-db-sqlite3-on-winxp

    ReplyDelete
  3. AnonymousFebruary 8, 2012 at 2:26 PM

    unsetting RAILS_ENV worked for me on rake db:test:prepare. Never would have found this without your post -- Thanks

    ReplyDelete
  4. AnonymousJuly 11, 2012 at 3:22 PM

    Here is another case when apatana locks the db and causes the error. See post: http://www.gyrotechie.com/2009/01/permissions-problem-with-rake-on-xp/

    ReplyDelete
  5. UnknownMarch 13, 2013 at 2:09 PM

    yep, this 100% works in windows. Amazing fix/hack. Yet so bad on the part of whoever caused this obscure issue.

    ReplyDelete

Subscribe to: Post Comments ( Atom )