Re: camping app on elastic beanstalk
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.comwrote: 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
Re: camping app on elastic beanstalk
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
Re: camping app on elastic beanstalk
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
Re: camping app on elastic beanstalk
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
Re: camping app on elastic beanstalk
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
Re: camping app on elastic beanstalk
Do you actually call App.create? Camping will not do this for you automatically (unless you're using the Camping Server, aka bin/camping). // Magnus Holm On Fri, Jan 17, 2014 at 9:07 AM, 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 # Locate the connection of the nearest super class. This can be an # active or defined connection: if it is the latter, it will be # opened and set as the active connection for the class it was defined # for (not necessarily the current class). def retrieve_connection(klass) #:nodoc: pool = retrieve_connection_pool(klass) (pool pool.connection) or raise ConnectionNotEstablished... end # Returns true if a connection that's accessible to this class has # already been opened. def connected?(klass) conn = retrieve_connection_pool(klass) 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
Re: camping app on elastic beanstalk
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
Re: camping app on elastic beanstalk
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 app on elastic beanstalk
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
