Thanks for your help: it works !
I thought that the app.create  was automatically called...but i was wrong.
now i call the create methOd from config.ru. i don't know if it is the best
solution... but it works.

Francois


2014/1/17 Tim Uckun <timuc...@gmail.com>

> If you run the migrations it should create the database for you.
>
>
> On Sat, Jan 18, 2014 at 3:46 AM, arca0 <arcaz...@gmail.com> wrote:
>
>> ok, I'm an absolute newbie myself so I'm just guessing away here, but
>> since nobody else is responding, here goes ;D
>>
>> I can't see a single line of code that would be responsible for creating
>> the db file. Is the app.db file in your project directory on the instance?
>> If not, can you try copying it from the local environment to see if it
>> fixes the problem?
>> Also, are you sure sqlite3 gem has built native extensions properly?
>>
>> You really got me curious here ;D Please be sure to let me know if you
>> manage to solve the problem :)
>>
>>
>> On 17 January 2014 11:35, Francois Sery <sery.franc...@gmail.com> wrote:
>>
>>> yes ! the answer is 3.6.20
>>>
>>>
>>> 2014/1/17 arca0 <arcaz...@gmail.com>
>>>
>>>> does your elastic beanstalk instance have sqlite3 installed? can you
>>>> run sqlite3 --version on it?
>>>>
>>>>
>>>> On 17 January 2014 09:07, Francois Sery <sery.franc...@gmail.com>wrote:
>>>>
>>>>> Bonjour,
>>>>>  here is my app code and  the trace. thanks for your help.
>>>>>
>>>>>
>>>>>
>>>>> #app.rb
>>>>> require 'camping'
>>>>> require 'sqlite3'
>>>>>
>>>>> Camping.goes :App
>>>>>
>>>>>
>>>>>
>>>>>  module App::Models
>>>>>  #models
>>>>>
>>>>>
>>>>>     class Personne < Base
>>>>>
>>>>>     end
>>>>>
>>>>>  #migrations
>>>>>
>>>>>     class BasicFields < V 1.0
>>>>>         def self.up
>>>>>             create_table Personne.table_name do |t|
>>>>>                 t.string :nom
>>>>>                 t.text :prenom
>>>>>                 t.timestamps
>>>>>
>>>>>             end
>>>>>
>>>>>         end
>>>>>
>>>>>         def self.down
>>>>>             drop_table Personne.table_name
>>>>>
>>>>>         end
>>>>>
>>>>>
>>>>>     end
>>>>>
>>>>>
>>>>>  end
>>>>>
>>>>> module App::Controllers
>>>>>     class Index
>>>>>         def get
>>>>>
>>>>>         @env.inspect
>>>>>         end
>>>>>     end
>>>>>     class Create
>>>>>         def get
>>>>>         Personne.create :nom => 'super', :prenom =>'man'
>>>>>         redirect R(Index)
>>>>>
>>>>>         end
>>>>>     end
>>>>> end
>>>>>
>>>>>
>>>>> def App.create
>>>>>
>>>>>     App::Models::Base.establish_connection(
>>>>>         :adapter =>'sqlite3',
>>>>>         :database => 'app.db'
>>>>>
>>>>>     )
>>>>>
>>>>> end
>>>>>
>>>>>
>>>>> #########
>>>>> and the trace (546)
>>>>>
>>>>>    -
>>>>>    
>>>>> /usr/share/ruby/1.9/gems/1.9.1/gems/activerecord-4.0.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:
>>>>>    in retrieve_connection
>>>>>    1.
>>>>>       2. # Locate the connection of the nearest super class. This can
>>>>>       be an
>>>>>       3. # active or defined connection: if it is the latter, it will
>>>>>       be
>>>>>       4. # opened and set as the active connection for the class it
>>>>>       was defined
>>>>>       5. # for (not necessarily the current class).
>>>>>       6. def retrieve_connection(klass) #:nodoc:
>>>>>       7. pool = retrieve_connection_pool(klass)
>>>>>    1. (pool && pool.connection) or raise ConnectionNotEstablished...
>>>>>    1. end
>>>>>       2.
>>>>>       3. # Returns true if a connection that's accessible to this
>>>>>       class has
>>>>>       4. # already been opened.
>>>>>       5. def connected?(klass)
>>>>>       6. conn = retrieve_connection_pool(klass)
>>>>>       7. conn && conn.connected?
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> 2014/1/15 arca0 <arcaz...@gmail.com>
>>>>>
>>>>>> Hi Francois,
>>>>>> it looks like your db configuration is somehow wrong. Care to submit
>>>>>> more information about that? How does your db config look?
>>>>>> alex
>>>>>>
>>>>>> From: Francois Sery <sery.franc...@gmail.com>
>>>>>>> Date: 15 January 2014 08:10
>>>>>>> Subject: camping app on elastic beanstalk
>>>>>>> To: camping-list@rubyforge.org
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Bonjour les Campers,
>>>>>>>  i need help deploying a camping app on  AWS  with elastic beanstalk.
>>>>>>>  i can run a simple "hello camping app" with do database and only
>>>>>>> one controller on elasticbeanstalk.But when i add  migration, model 
>>>>>>> ,schema
>>>>>>> creation and update the  gemfile   it doesn't work anymore.
>>>>>>>  the app works fine on my local machine but not on beanstalk .I dont
>>>>>>> understand  what is different from my local machine ?
>>>>>>> Its the first time I deploy  an app so every advices are welcome.
>>>>>>> here is the message from the log
>>>>>>>
>>>>>>> *** Exception ActiveRecord::ConnectionNotEstablished in Rack 
>>>>>>> application object (ActiveRecord::ConnectionNotEstablished)
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Thanks
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> 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
>>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> 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
>>>>
>>>
>>>
>>> _______________________________________________
>>> 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
>>
>
>
> _______________________________________________
> 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

Reply via email to