Re: sqlite3 connection problem
Thanks Jonathan - that's done the trick. (BTW my previous fumble was an attempt to pinpoint my problem by connecting without Camping.) With the idea of using this as the simplest possible 'Camping with SQLite' example for beginners (or testing new setups), I've adjusted and pastied it: http://pastie.textmate.org/509724 Comments welcome - Dave ___ Camping-list mailing list Camping-list@rubyforge.org http://rubyforge.org/mailman/listinfo/camping-list
Re: sqlite3 connection problem
On Tue, Jun 09, 2009 at 11:35:26AM +0100, Dave Everitt wrote:
Any feedback appreciated on the following. My most recent attempt to
identify the issue is a minimal Ruby/SQLite/ActiveRecord script, Pastied
here: http://pastie.textmate.org/492514 which brings up the following
when run from the command line (an empty database file already exists):
$ ./simple_db.rbx
[SNIP]/active_record/connection_adapters/sqlite3_adapter.rb:29:in
`table_structure': Could not find table 'users'
(1) Not really a 'camping' related pastie. See (3) for the same thing
done the 'camping way'.
(2) There seems to be nothing in the code above telling activerecord
to create your database schema unless you're doing seperate rake
db:migrate scripts outside of this script. My suspicion, therefore is
that the 'users' table simply does not exist in your database.
(3) This is a full working solution for camping 1.5:
#!/usr/bin/env ruby
$:.unshift File.dirname(__FILE__) + "/../../lib"
require 'camping'
Camping.goes :Dave
module Dave::Models
class User < Base
end
class CreateTables < V 1.0
def self.up
create_table :dave_users, :force => true do |t|
t.column :id, :integer, :null => false
t.column :name, :string, :limit => 255
t.column :password, :string, :limit => 255
end
def self.down
drop_table :dave_users
end
end
end
end
module Dave::Controllers
class Index < R '/'
def get
user = User.new()
user.id = "dave"
user.name = "Dave Everitt"
user.password = "davepass"
user.save
# user = User.find("dave")
# user.destroy()
render :fin
end
end
end
module Dave::Views
def fin
"Finished, no errors"
end
end
def Dave.create
Dave::Models.create_schema :assume => (Dave::Models::User.table_exists? ? 1.0
: 0.0)
end
***
Save this file as dave.rb. Note the Dave::Models.create_schema call
(as per point 2 above)
To get this to work I have the following gems installed:
$ gem list
*** LOCAL GEMS ***
activerecord (2.3.2)
activesupport (2.3.2)
builder (2.1.2)
camping (1.5.180)
markaby (0.5)
metaid (1.0)
sqlite3-ruby (1.2.4)
I run it with:
camping dave.rb
I then visited http://localhost:3301/ with my browser (which showed
"Finished, no errors").
To confirm that there is a table in the sqlite database with the
correct fields and with one record:
$ sqlite3 ~/.camping.db
SQLite version 3.6.10
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .tables
dave_schema_infos dave_users sessions
sqlite> .header on
sqlite> select * from dave_users;
id|name|password
0|Dave Everitt|davepass
Hope some of the above points you in the 'right' direction.
Cheers,
Jonathan.
___
Camping-list mailing list
Camping-list@rubyforge.org
http://rubyforge.org/mailman/listinfo/camping-list
Re: sqlite3 connection problem
Dave - to answer: 1. sqlite3-ruby (1.2.4), 2. I installed an updated Ruby (1.8.6) some time ago (can't recall how!), 3. sqlite3 (3.1.3) is already on OS X 10.4.11, 4. I don't use a package manager (or ports or fink), and know nothing about sqlite header files. I was thinking of installing a newer sqlite3 (keeping the existing), which might do the trick? Although using the OS X version lowers the entry bar, and I'm trying to make this easy for students. Dave What version of the gem are you using? 1.2.4? I'm assuming you compiled ruby yourself based off of its location, did you compile sqlite as well or get it through your OS package manager? In either case, I've found you'll need the sqlite header files for the gem to work correctly. In your package manager they're probably called sqlite-devel or something like that. ___ Camping-list mailing list Camping-list@rubyforge.org http://rubyforge.org/mailman/listinfo/camping-list
Re: sqlite3 connection problem
Increasing permissions (currently 755) makes no difference. I can use the DB fine from the sqlite3 cl tool - Dave On 9 Jun 2009, at 13:26, Eric Mill wrote: Are the permissions on the file set right? What happens if you try to access the file with rhe sqlite3 command line tool and run the query yourself? ___ Camping-list mailing list Camping-list@rubyforge.org http://rubyforge.org/mailman/listinfo/camping-list
Re: sqlite3 connection problem
What version of the gem are you using? 1.2.4? I'm assuming you
compiled ruby yourself based off of its location, did you compile
sqlite as well or get it through your OS package manager? In either
case, I've found you'll need the sqlite header files for the gem to
work correctly. In your package manager they're probably called
sqlite-devel or something like that.
Dave
On Tue, Jun 9, 2009 at 8:26 AM, Eric Mill wrote:
> Are the permissions on the file set right? What happens if you try to
> access the file with rhe sqlite3 command line tool and run the query
> yourself?
>
> -- Eric
>
> On Tue, Jun 9, 2009 at 6:35 AM, Dave Everitt wrote:
>> Any feedback appreciated on the following. My most recent attempt to
>> identify the issue is a minimal Ruby/SQLite/ActiveRecord script, Pastied
>> here: http://pastie.textmate.org/492514 which brings up the following when
>> run from the command line (an empty database file already exists):
>>
>> $ ./simple_db.rbx
>> [SNIP]/active_record/connection_adapters/sqlite3_adapter.rb:29:in
>> `table_structure': Could not find table 'users'
>> (ActiveRecord::StatementInvalid)
>> from
>> /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.3.2/lib/active_support/core_ext/object/misc.rb:39:in
>> `returning'
>> from
>> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/sqlite3_adapter.rb:28:in
>> `table_structure'
>> from
>> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/sqlite_adapter.rb:213:in
>> `columns'
>> from
>> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:1276:in
>> `columns'
>> from
>> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:3008:in
>> `attributes_from_column_definition_without_lock'
>> from
>> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/locking/optimistic.rb:66:in
>> `attributes_from_column_definition'
>> from
>> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:2435:in
>> `initialize'
>> from ./simple_db.rbx:10:in `new'
>> from ./simple_db.rbx:10
>>
>> The adapted blog example code I want to run for my students as an example is
>> Pastied at: http://pastie.org/492517 so I'd appreciate the identification of
>> any glaring errors (currently Camping 1.5 under plain CGI):
>>
>> The errors in the server log read:
>> [SNIP]/activerecord-2.3.2/lib/active_record/connection_adapters/abstract_adapter.rb:212:in
>> `log': SQLite3::SQLException: unable to open database file: CREATE TABLE
>> "blogtiny_schema_infos" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
>> "version" float) (ActiveRecord::StatementInvalid)
>> from
>> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/sqlite_adapter.rb:157:in
>> `execute'
>> from
>> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/sqlite_adapter.rb:402:in
>> `catch_schema_changes'
>> from
>> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/sqlite_adapter.rb:157:in
>> `execute'
>> from
>> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/schema_statements.rb:114:in
>> `create_table'
>> from
>> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/migration.rb:352:in
>> `send'
>> from
>> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/migration.rb:352:in
>> `method_missing'
>> from
>> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/migration.rb:328:in
>> `say_with_time'
>> from /usr/local/lib/ruby/1.8/benchmark.rb:293:in `measure'
>> from
>> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/migration.rb:328:in
>> `say_with_time'
>> from
>> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/migration.rb:348:in
>> `method_missing'
>> from (eval):71:in `create_schema'
>> from
>> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/schema.rb:43:in
>> `instance_eval'
>> from
>> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/schema.rb:43:in
>> `define'
>> from (eval):70:in `create_schema'
>> from /Users/deveritt/Sites/cgi-bin/camping/blogtiny.rbx:71:in
>> `create'
>> from /Users/deveritt/Sites/cgi-bin/camping/blogtiny.rbx:77
>> [Thu May 28 12:18:13 2009] [error] [client 127.0.0.1] malformed header from
>> script. Bad header=-- create_table("blogtiny_sche:
>> /Users/deveritt/Sites/cgi-bin/camping/blogtiny.rbx
>>
>> Note the odd truncation of 'blogtiny_sche' in the final line.
>>
>> And one dumb question:
>> I don't have to 'require sqlite3-ruby', right?
>>
>> Dave
>>
>> ___
>> Camping-list mailing list
>> Camping-li
Re: sqlite3 connection problem
Are the permissions on the file set right? What happens if you try to
access the file with rhe sqlite3 command line tool and run the query
yourself?
-- Eric
On Tue, Jun 9, 2009 at 6:35 AM, Dave Everitt wrote:
> Any feedback appreciated on the following. My most recent attempt to
> identify the issue is a minimal Ruby/SQLite/ActiveRecord script, Pastied
> here: http://pastie.textmate.org/492514 which brings up the following when
> run from the command line (an empty database file already exists):
>
> $ ./simple_db.rbx
> [SNIP]/active_record/connection_adapters/sqlite3_adapter.rb:29:in
> `table_structure': Could not find table 'users'
> (ActiveRecord::StatementInvalid)
> from
> /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.3.2/lib/active_support/core_ext/object/misc.rb:39:in
> `returning'
> from
> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/sqlite3_adapter.rb:28:in
> `table_structure'
> from
> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/sqlite_adapter.rb:213:in
> `columns'
> from
> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:1276:in
> `columns'
> from
> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:3008:in
> `attributes_from_column_definition_without_lock'
> from
> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/locking/optimistic.rb:66:in
> `attributes_from_column_definition'
> from
> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:2435:in
> `initialize'
> from ./simple_db.rbx:10:in `new'
> from ./simple_db.rbx:10
>
> The adapted blog example code I want to run for my students as an example is
> Pastied at: http://pastie.org/492517 so I'd appreciate the identification of
> any glaring errors (currently Camping 1.5 under plain CGI):
>
> The errors in the server log read:
> [SNIP]/activerecord-2.3.2/lib/active_record/connection_adapters/abstract_adapter.rb:212:in
> `log': SQLite3::SQLException: unable to open database file: CREATE TABLE
> "blogtiny_schema_infos" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
> "version" float) (ActiveRecord::StatementInvalid)
> from
> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/sqlite_adapter.rb:157:in
> `execute'
> from
> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/sqlite_adapter.rb:402:in
> `catch_schema_changes'
> from
> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/sqlite_adapter.rb:157:in
> `execute'
> from
> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/schema_statements.rb:114:in
> `create_table'
> from
> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/migration.rb:352:in
> `send'
> from
> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/migration.rb:352:in
> `method_missing'
> from
> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/migration.rb:328:in
> `say_with_time'
> from /usr/local/lib/ruby/1.8/benchmark.rb:293:in `measure'
> from
> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/migration.rb:328:in
> `say_with_time'
> from
> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/migration.rb:348:in
> `method_missing'
> from (eval):71:in `create_schema'
> from
> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/schema.rb:43:in
> `instance_eval'
> from
> /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/schema.rb:43:in
> `define'
> from (eval):70:in `create_schema'
> from /Users/deveritt/Sites/cgi-bin/camping/blogtiny.rbx:71:in
> `create'
> from /Users/deveritt/Sites/cgi-bin/camping/blogtiny.rbx:77
> [Thu May 28 12:18:13 2009] [error] [client 127.0.0.1] malformed header from
> script. Bad header=-- create_table("blogtiny_sche:
> /Users/deveritt/Sites/cgi-bin/camping/blogtiny.rbx
>
> Note the odd truncation of 'blogtiny_sche' in the final line.
>
> And one dumb question:
> I don't have to 'require sqlite3-ruby', right?
>
> Dave
>
> ___
> Camping-list mailing list
> Camping-list@rubyforge.org
> http://rubyforge.org/mailman/listinfo/camping-list
>
___
Camping-list mailing list
Camping-list@rubyforge.org
http://rubyforge.org/mailman/listinfo/camping-list
sqlite3 connection problem
Any feedback appreciated on the following. My most recent attempt to
identify the issue is a minimal Ruby/SQLite/ActiveRecord script,
Pastied here: http://pastie.textmate.org/492514 which brings up the
following when run from the command line (an empty database file
already exists):
$ ./simple_db.rbx
[SNIP]/active_record/connection_adapters/sqlite3_adapter.rb:29:in
`table_structure': Could not find table
'users' (ActiveRecord::StatementInvalid)
from /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.3.2/
lib/active_support/core_ext/object/misc.rb:39:in `returning'
from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/
lib/active_record/connection_adapters/sqlite3_adapter.rb:28:in
`table_structure'
from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/
lib/active_record/connection_adapters/sqlite_adapter.rb:213:in `columns'
from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/
lib/active_record/base.rb:1276:in `columns'
from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/
lib/active_record/base.rb:3008:in
`attributes_from_column_definition_without_lock'
from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/
lib/active_record/locking/optimistic.rb:66:in
`attributes_from_column_definition'
from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/
lib/active_record/base.rb:2435:in `initialize'
from ./simple_db.rbx:10:in `new'
from ./simple_db.rbx:10
The adapted blog example code I want to run for my students as an
example is Pastied at: http://pastie.org/492517 so I'd appreciate the
identification of any glaring errors (currently Camping 1.5 under
plain CGI):
The errors in the server log read:
[SNIP]/activerecord-2.3.2/lib/active_record/connection_adapters/
abstract_adapter.rb:212:in `log': SQLite3::SQLException: unable to
open database file: CREATE TABLE "blogtiny_schema_infos" ("id"
INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "version" float)
(ActiveRecord::StatementInvalid)
from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/
active_record/connection_adapters/sqlite_adapter.rb:157:in `execute'
from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/
active_record/connection_adapters/sqlite_adapter.rb:402:in
`catch_schema_changes'
from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/
active_record/connection_adapters/sqlite_adapter.rb:157:in `execute'
from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/
active_record/connection_adapters/abstract/schema_statements.rb:
114:in `create_table'
from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/
active_record/migration.rb:352:in `send'
from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/
active_record/migration.rb:352:in `method_missing'
from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/
active_record/migration.rb:328:in `say_with_time'
from /usr/local/lib/ruby/1.8/benchmark.rb:293:in `measure'
from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/
active_record/migration.rb:328:in `say_with_time'
from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/
active_record/migration.rb:348:in `method_missing'
from (eval):71:in `create_schema'
from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/
active_record/schema.rb:43:in `instance_eval'
from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/
active_record/schema.rb:43:in `define'
from (eval):70:in `create_schema'
from /Users/deveritt/Sites/cgi-bin/camping/blogtiny.rbx:71:in `create'
from /Users/deveritt/Sites/cgi-bin/camping/blogtiny.rbx:77
[Thu May 28 12:18:13 2009] [error] [client 127.0.0.1] malformed
header from script. Bad header=-- create_table("blogtiny_sche: /Users/
deveritt/Sites/cgi-bin/camping/blogtiny.rbx
Note the odd truncation of 'blogtiny_sche' in the final line.
And one dumb question:
I don't have to 'require sqlite3-ruby', right?
Dave
___
Camping-list mailing list
Camping-list@rubyforge.org
http://rubyforge.org/mailman/listinfo/camping-list
Re: sqlite3 connection problem
In order to create the necessary tables you'll have to run Blogtiny::Models.create_schema. The prefered way is define a create-method like this: def Blogtiny.create Blogtiny::Models.create_schema end All servers or setups using Camping should then call Blogtiny.create on startup after the app is loaded (so yes, you still have to call this yourself). //Magnus Holm On Mon, May 18, 2009 at 16:35, Dave Everitt wrote: > Many attempts (3 days now) to get even a single sqlite3 example running... > I've got a little further by creating the database file from the sqlite3 > shell. Now the app connects to an empty db and I get: > > ActiveRecord::StatementInvalid SQLite3::SQLException: no such table: > blogtiny_posts: SELECT * FROM "blogtiny_posts" : > > I am I right to expect that Camping will create the necessary tables when > run as CGI? > > Weird. I've used sqlite3 on the SQLite which follows with 10.4 earlier. >> Could you paste the code you use to connect to the database? >> >> //Magnus Holm >> >> I'm running it as a cgi app (no problem with Camping itself, just any >>> apps that need sqlite3) under Apache, OS X 10.4.11... sqlite 3.1.3 (the one >>> that comes with the system and OS X uses)? >>> >>> Dave Everitt >>> >> ___ > Camping-list mailing list > Camping-list@rubyforge.org > http://rubyforge.org/mailman/listinfo/camping-list > ___ Camping-list mailing list Camping-list@rubyforge.org http://rubyforge.org/mailman/listinfo/camping-list
Re: sqlite3 connection problem
Many attempts (3 days now) to get even a single sqlite3 example running... I've got a little further by creating the database file from the sqlite3 shell. Now the app connects to an empty db and I get: ActiveRecord::StatementInvalid SQLite3::SQLException: no such table: blogtiny_posts: SELECT * FROM "blogtiny_posts" : I am I right to expect that Camping will create the necessary tables when run as CGI? Weird. I've used sqlite3 on the SQLite which follows with 10.4 earlier. Could you paste the code you use to connect to the database? //Magnus Holm I'm running it as a cgi app (no problem with Camping itself, just any apps that need sqlite3) under Apache, OS X 10.4.11... sqlite 3.1.3 (the one that comes with the system and OS X uses)? Dave Everitt ___ Camping-list mailing list Camping-list@rubyforge.org http://rubyforge.org/mailman/listinfo/camping-list
Re: sqlite3 connection problem
Weird. I've used sqlite3 on the SQLite which follows with 10.4 earlier.
Could you paste the code you use to connect to the database?
//Magnus Holm
On Mon, May 18, 2009 at 11:22, Dave Everitt wrote:
> Regarding the post below: in case anyone was going to reply about SWIG, I
> checked and found this on the sqlite3-ruby GIT pages:
>
> "the gem ships with the C source-code pre-built, so (as of version 1.1.1)
> you no longer need to have SWIG installed."
>
> So my problem is obviously elsewhere... sqlite3 works fine, I'm using Ruby
> 1.8.6... will keep trying, unless anyone has helpful suggestions? I'm just
> getting my head around Camping, so it could well be me, somewhere... here's
> my Gem list:
>
> activerecord (2.3.2)
> activesupport (2.3.2)
> acts_as_versioned (0.2.3)
> builder (2.1.2)
> camping (1.5)
> cgi_multipart_eof_fix (2.5.0)
> cheat (1.2.1)
> daemons (1.0.10)
> fastthread (1.0.7, 1.0.1)
> gem_plugin (0.2.3)
> innate (2009.05)
> markaby (0.5)
> metaid (1.0)
> mongrel (1.1.5)
> rack (1.0.0, 0.4.0)
> ramaze (2009.05, 2008.11)
> rubygems-update (1.3.3, 1.3.1)
> sources (0.0.1)
> sqlite3-ruby (1.2.4)
>
> I'm wary of updating sqlite 3.1.3 to 3.6.10, as OS X uses it... just need
> to know if Camping has a problem with sqlite 3.1.3? I don't use ports, but
> happy to go /ursr/local.
>
> Dave Everitt
>
> Hi
>>
>> after many attempts to get the sqlite3 examples running ("unable to open
>> database file:"), I found this:
>>
>> "sqlite3-ruby won’t even link against your libsqlite3 unless SWIG is
>> installed."
>> (http://www.baconbear.com/articles/2006/12/06/osx-sqlite3-and-rails)
>>
>> Anyone shed any light on this?
>>
>> I'm running it as a cgi app (no problem with Camping itself, just any apps
>> that need sqlite3) under Apache, OS X 10.4.11... sqlite 3.1.3 (the one that
>> comes with the system and OS X uses)?
>>
>> Dave Everitt
>>
>
> ___
> Camping-list mailing list
> Camping-list@rubyforge.org
> http://rubyforge.org/mailman/listinfo/camping-list
>
___
Camping-list mailing list
Camping-list@rubyforge.org
http://rubyforge.org/mailman/listinfo/camping-list
sqlite3 connection problem
Regarding the post below: in case anyone was going to reply about
SWIG, I checked and found this on the sqlite3-ruby GIT pages:
"the gem ships with the C source-code pre-built, so (as of version
1.1.1) you no longer need to have SWIG installed."
So my problem is obviously elsewhere... sqlite3 works fine, I'm using
Ruby 1.8.6... will keep trying, unless anyone has helpful
suggestions? I'm just getting my head around Camping, so it could
well be me, somewhere... here's my Gem list:
activerecord (2.3.2)
activesupport (2.3.2)
acts_as_versioned (0.2.3)
builder (2.1.2)
camping (1.5)
cgi_multipart_eof_fix (2.5.0)
cheat (1.2.1)
daemons (1.0.10)
fastthread (1.0.7, 1.0.1)
gem_plugin (0.2.3)
innate (2009.05)
markaby (0.5)
metaid (1.0)
mongrel (1.1.5)
rack (1.0.0, 0.4.0)
ramaze (2009.05, 2008.11)
rubygems-update (1.3.3, 1.3.1)
sources (0.0.1)
sqlite3-ruby (1.2.4)
I'm wary of updating sqlite 3.1.3 to 3.6.10, as OS X uses it... just
need to know if Camping has a problem with sqlite 3.1.3? I don't use
ports, but happy to go /ursr/local.
Dave Everitt
Hi
after many attempts to get the sqlite3 examples running ("unable to
open database file:"), I found this:
"sqlite3-ruby won’t even link against your libsqlite3 unless SWIG
is installed."
(http://www.baconbear.com/articles/2006/12/06/osx-sqlite3-and-rails)
Anyone shed any light on this?
I'm running it as a cgi app (no problem with Camping itself, just
any apps that need sqlite3) under Apache, OS X 10.4.11... sqlite
3.1.3 (the one that comes with the system and OS X uses)?
Dave Everitt
___
Camping-list mailing list
Camping-list@rubyforge.org
http://rubyforge.org/mailman/listinfo/camping-list
