thr3ads.net - Rails - permissions for an sqlite3 db? rake aborted [Nov 2007]

If this information is useful, please help other people find it:
Share via:

Thufir

2007-Nov-29 08:36 UTC

permissions for an sqlite3 db? rake aborted

It''s not clear to me why the rake fails.  Would it be helpful to post
the
trace?  seemed spammy.  I assume it''s some sort of permissions issue, 
although a google search turned up other ideas (which seemed unlikely so 
I won''t repeat them).

Any and all thoughts please!



thufir@arrakis ~/rubyCode/straw $ 
thufir@arrakis ~/rubyCode/straw $ ll db/
total 4
drwxr-xr-x 2 thufir users 4096 Nov 29 00:31 migrate
-rw-rw-rw- 1 thufir users    0 Nov 29 00:31 straw.db
thufir@arrakis ~/rubyCode/straw $ 
thufir@arrakis ~/rubyCode/straw $ sqlite3 db/straw.db 
SQLite version 3.4.1
Enter ".help" for instructions
sqlite> .schema
sqlite> .quit
thufir@arrakis ~/rubyCode/straw $ cat config/database.yml 

development:
        adapter:        sqlite3
        dbfile:         /home/thufir/straw/db/straw.db
test:
        adapter:        sqlite3
        dbfile:         /home/thufir/straw/db/straw.db
production:
        adapter:        sqlite3
        dbfile:         /home/thufir/straw/db/straw.db
thufir@arrakis ~/rubyCode/straw $ 
thufir@arrakis ~/rubyCode/straw $ cat db/migrate/001_feeds.rb 

class Feeds < ActiveRecord::Migration
        def self.up
                create_table :feeds do |table|
                        table.column :title,            :string
                        table.column :location,         :string
                        table.column :category_id,      :integer
                end
        end
        def self.down
                drop_table :feeds
        end
end
thufir@arrakis ~/rubyCode/straw $ 
thufir@arrakis ~/rubyCode/straw $ rake db:migrate
(in /home/thufir/rubyCode/straw)
rake aborted!
could not open database

(See full trace by running task with --trace)
thufir@arrakis ~/rubyCode/straw $ 




thanks,

Thufir


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Greg Donald

2007-Nov-29 16:15 UTC

head link

Re: permissions for an sqlite3 db? rake aborted

On Nov 29, 2007 2:36 AM, Thufir
<hawat.thufir-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:> thufir@arrakis ~/rubyCode/straw $ rake db:migrate
> (in /home/thufir/rubyCode/straw)
> rake aborted!
> could not open database
I had this problem once a while ago.  My Ruby had sqlite version 2
support instead of version 3 or something like that.  My point is it
was giving me what looked like permission errors but it was really a
sqlite version conflict.  Hope that helps.


-- 
Greg Donald
http://destiney.com/

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Thufir

2007-Nov-29 20:46 UTC

head link

Re: permissions for an sqlite3 db? rake aborted

Oddly enough, I get the same error if the db, straw.db, is entirely
missing!

Thanks for the info about the versions.




-Thufir
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Thufir

2007-Nov-30 05:16 UTC

head link

Re: permissions for an sqlite3 db? rake aborted

On Thu, 29 Nov 2007 10:15:48 -0600, Greg Donald wrote:

> I had this problem once a while ago.  My Ruby had sqlite version 2
> support instead of version 3 or something like that.  My point is it was
> giving me what looked like permission errors but it was really a sqlite
> version conflict.  Hope that helps.
I have no idea what the problem was, but the solution was to not create 
the db myself but to have the migration do it (and the rails command 
create the database.yml automagically!):


thufir@arrakis ~/rubyCode $ 
thufir@arrakis ~/rubyCode $ cat sqLiteStraw.rb 
require ''fileutils''
require ''sqlite3''

FileUtils.rmtree ''straw''
system("rails straw --database=sqlite3")
FileUtils.cd(''straw'', :verbose => true)

##############################################

system("script/generate migration feeds")
system("script/generate migration categories")
system("script/generate migration items")
system("script/generate migration nodes")

##################################################

FileUtils.rm ''db/migrate/001_feeds.rb'', :force => true
_001_feeds = File.open(''db/migrate/001_feeds.rb'',
''w'')
_001_feeds.puts "
class Feeds < ActiveRecord::Migration
        def self.up
                create_table :feeds do |table|
                        table.column :title,            :string
                        table.column :location,         :string
                        table.column :category_id,      :integer
                end
        end
        def self.down
                drop_table :feeds
        end
end"
_001_feeds.close

################################################

FileUtils.rm ''db/migrate/002_categories.rb'', :force => true
_002_categories = File.open(''db/migrate/002_categories.rb'',
''w'')
_002_categories.puts "
class Categories < ActiveRecord::Migration
        def self.up
                create_table :categories do |table|
                        table.column :parent_id,        :integer
                        table.column :title,            :string
                end
        end
        def self.down
                drop_table :categories
        end
end"
_002_categories.close

########################################

FileUtils.rm ''db/migrate/003_items.rb'', :force => true
_003_items = File.open(''db/migrate/003_items.rb'',
''w'')
_003_items.puts "
class Items < ActiveRecord::Migration
        def self.up
                create_table :items do |table|
                        table.column :title,            :string
                        table.column :feed_id,          :integer
                        table.column :is_read,          :integer
                        table.column :link,             :string
                        table.column :pub_date,         :string
                        table.column :description,      :string
                end
        end
        def self.down
                drop_table :items
        end
end"
_003_items.close

########################################3

FileUtils.rm ''db/migrate/004_nodes.rb'', :force => true
_004_nodes = File.open(''db/migrate/004_nodes.rb'',
''w'')
_004_nodes.puts "
class Nodes < ActiveRecord::Migration
        def self.up
                create_table :nodes do |table|
                        table.column :obj_id,           :string
                        table.column :norder,           :string
                        table.column :type,             :string
                end
        end
        def self.down
                drop_table :nodes
        end
end"
_004_nodes.close

#############################################

system("rake db:migrate VERSION=0")
system("rake db:migrate")

##########################################

system("script/generate scaffold feed")
system("script/generate scaffold category")
system("script/generate scaffold item")
system("script/generate scaffold node")

##########################################

FileUtils.rm ''app/models/feed.rb'', :force => true
modelsFeed = File.open(''app/models/feed.rb'',
''w'')
modelsFeed.puts "
class Feed < ActiveRecord::Base
        has_many :items
end"
modelsFeed.close

#############################################

FileUtils.rm ''app/models/item.rb'', :force => true
modelsItem = File.open(''app/models/item.rb'',
''w'')
modelsItem.puts "
class Item < ActiveRecord::Base
        belongs_to :feeds
end"
modelsItem.close

#############################################
puts "@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@"
puts "\t\t\thttp://localhost:3000/feeds"
puts "\t\t\thttp://localhost:3000/items"
puts "\t\t\thttp://localhost:3000/categories"
puts "\t\t\thttp://localhost:3000/nodes"
puts "@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@"

system("script/server webrick --environment=development")
thufir@arrakis ~/rubyCode $ 




-Thufir


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Thufir

2007-Nov-30 05:16 UTC

head link

Re: permissions for an sqlite3 db? rake aborted

On Thu, 29 Nov 2007 10:15:48 -0600, Greg Donald wrote:

> I had this problem once a while ago.  My Ruby had sqlite version 2
> support instead of version 3 or something like that.  My point is it was
> giving me what looked like permission errors but it was really a sqlite
> version conflict.  Hope that helps.
I have no idea what the problem was, but the solution was to not create 
the db myself but to have the migration do it (and the rails command 
create the database.yml automagically!):


thufir@arrakis ~/rubyCode $ 
thufir@arrakis ~/rubyCode $ cat sqLiteStraw.rb 
require ''fileutils''
require ''sqlite3''

FileUtils.rmtree ''straw''
system("rails straw --database=sqlite3")
FileUtils.cd(''straw'', :verbose => true)

##############################################

system("script/generate migration feeds")
system("script/generate migration categories")
system("script/generate migration items")
system("script/generate migration nodes")

##################################################

FileUtils.rm ''db/migrate/001_feeds.rb'', :force => true
_001_feeds = File.open(''db/migrate/001_feeds.rb'',
''w'')
_001_feeds.puts "
class Feeds < ActiveRecord::Migration
        def self.up
                create_table :feeds do |table|
                        table.column :title,            :string
                        table.column :location,         :string
                        table.column :category_id,      :integer
                end
        end
        def self.down
                drop_table :feeds
        end
end"
_001_feeds.close

################################################

FileUtils.rm ''db/migrate/002_categories.rb'', :force => true
_002_categories = File.open(''db/migrate/002_categories.rb'',
''w'')
_002_categories.puts "
class Categories < ActiveRecord::Migration
        def self.up
                create_table :categories do |table|
                        table.column :parent_id,        :integer
                        table.column :title,            :string
                end
        end
        def self.down
                drop_table :categories
        end
end"
_002_categories.close

########################################

FileUtils.rm ''db/migrate/003_items.rb'', :force => true
_003_items = File.open(''db/migrate/003_items.rb'',
''w'')
_003_items.puts "
class Items < ActiveRecord::Migration
        def self.up
                create_table :items do |table|
                        table.column :title,            :string
                        table.column :feed_id,          :integer
                        table.column :is_read,          :integer
                        table.column :link,             :string
                        table.column :pub_date,         :string
                        table.column :description,      :string
                end
        end
        def self.down
                drop_table :items
        end
end"
_003_items.close

########################################3

FileUtils.rm ''db/migrate/004_nodes.rb'', :force => true
_004_nodes = File.open(''db/migrate/004_nodes.rb'',
''w'')
_004_nodes.puts "
class Nodes < ActiveRecord::Migration
        def self.up
                create_table :nodes do |table|
                        table.column :obj_id,           :string
                        table.column :norder,           :string
                        table.column :type,             :string
                end
        end
        def self.down
                drop_table :nodes
        end
end"
_004_nodes.close

#############################################

system("rake db:migrate VERSION=0")
system("rake db:migrate")

##########################################

system("script/generate scaffold feed")
system("script/generate scaffold category")
system("script/generate scaffold item")
system("script/generate scaffold node")

##########################################

FileUtils.rm ''app/models/feed.rb'', :force => true
modelsFeed = File.open(''app/models/feed.rb'',
''w'')
modelsFeed.puts "
class Feed < ActiveRecord::Base
        has_many :items
end"
modelsFeed.close

#############################################

FileUtils.rm ''app/models/item.rb'', :force => true
modelsItem = File.open(''app/models/item.rb'',
''w'')
modelsItem.puts "
class Item < ActiveRecord::Base
        belongs_to :feeds
end"
modelsItem.close

#############################################
puts "@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@"
puts "\t\t\thttp://localhost:3000/feeds"
puts "\t\t\thttp://localhost:3000/items"
puts "\t\t\thttp://localhost:3000/categories"
puts "\t\t\thttp://localhost:3000/nodes"
puts "@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@"

system("script/server webrick --environment=development")
thufir@arrakis ~/rubyCode $ 




-Thufir


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Rails - Nov 2007 - permissions for an sqlite3 db? rake aborted

permissions for an sqlite3 db? rake aborted

Re: permissions for an sqlite3 db? rake aborted

Re: permissions for an sqlite3 db? rake aborted

Re: permissions for an sqlite3 db? rake aborted

Re: permissions for an sqlite3 db? rake aborted