SQLite3::SQLException: unable to open database file


#1

Hi.
I was trying to code same as the rails guide : getting started.
I could follow steps to 6.3 Working with Posts in the Browser.
(setting home page, creating a resource, running a migration)

After clicked create button, errors are occured.
SQLite3::SQLException: unable to open database file: INSERT INTO
“posts” (“name”, “created_at”, “title”, “updated_at”, “content”) VALUES
(‘123123123’, ‘2009-04-25 22:23:51’, ‘12312312’, ‘2009-04-25
22:23:51’, ‘4123123123’)

There is a db file at db folder named development.sqlite3
what’s wrong with me?
Somebody help me, please.

Thanks in advance.


#2

serenobs wrote:

There is a db file at db folder named development.sqlite3

What does it say?


#3

serenobs wrote:

what’s wrong with me?
Somebody help me, please.

Also, looking over the directions in the guide, this part is plain
wrong:


3.3.1 Configuring a SQLite Database

If you don’t have any database set up, SQLite is the easiest to get
installed. If you’re on OS X 10.5 or greater on a Mac, you already have
it. Otherwise, you can install it using RubyGems:

$ gem install sqlite3-ruby

That does not install sqlite3. That installs a ruby interface to a
pre-existing installation of sqlite3. In other words, that gem provides
the means for ruby to talk to sqlite3. As the guide says at the
beginning:


1 This Guide Assumes

This guide is designed for beginners who want to get started with a
Rails application from scratch. It does not assume that you have any
prior experience with Rails. However, to get the most out of it, you
need to have some prerequisites installed:

The Ruby language
The RubyGems packaging system
A working installation of SQLite (preferred), MySQL, or PostgreSQL

Did you have a working installation of SQLite installed before you
started reading the guide?


#4

Of course ruby, ruby gems and sqlite3 are installed on my system
(CentOS 5.3)

#gem install sqlite3-ruby
Building native extensions. This could take a while…
Successfully installed sqlite3-ruby-1.2.4
1 gem installed
Installing ri documentation for sqlite3-ruby-1.2.4…
Installing RDoc documentation for sqlite3-ruby-1.2.4…

it is installed properly, isn’t it?
I can execute irb shell(ruby), sqlite3.

On Apr 26, 10:08 am, 7stud – removed_email_address@domain.invalid


#5

serenobs wrote:

SQLite3::SQLException: unable to open database file…

Me thinks it’s a permissions issue…

http://www.nigelthorne.com/2008/07/activerecord-sqlite3-unable-to-open.html


#6

On Apr 26, 12:25 am, serenobs removed_email_address@domain.invalid wrote:
.
.

There is a db file at db folder named development.sqlite3
what’s wrong with me?
Somebody help me, please.

Did your migration complete successfully? i.e. does the table posts
exist in your database?
Does your database.yml file point to your db file -
development.sqlite3? It should look something like this:
development:
adapter: sqlite3
database: db/development.sqlite3
pool: 5
timeout: 5000