Hi Edward,
    This could be one of two things!  Either the permissions are stopping
apache from reading the database or when you migrated the database you were
still using the development environment.

If Apache doesn't have permissions to access the database the following
command should fix it:

*chmod 766 db/production.sqlite3*

In the case you're using the wrong environment (I think this is what's
happening in your case)

If you ran *rake db:migrate* chances are you've only created the structure
for 'db/development.sqlite3'

If this is the problem the run the following command:

*rake db:migrate RAILS_ENV=production*

One last thing to note that may help you or someone else reading this is
that passenger sets everything up to use the production environment by
default.  If you want passenger to use the development environment then you
need to make a change in the appropriate httpd.conf file.

When I was testing this I was using Apache2 with Ubuntu.  Because Ubuntu is
Debian based the Apache webserver is configured in a slightly different way.
 The file you need to edit in this situation is
'/etc/apache2/sites-enabled/000-default'

This should be created automatically by passenger and somewhere the file
will have:

*<VirtualHost *:80>*
*        *
*
*
*        RailsEnv production*
*
*
*...*

This is where passenger finds out which environment to use.  If you want to
use the development environment change:

*RailsEnv production*

to:

*RailsEnv development*

Then restart the Apache webserver.

Hope this helps, and again please let me know how you get on.

Cheers,
Patrick

On Tue, Dec 8, 2009 at 8:59 AM, Edward Samokhvalov <[email protected]>wrote:

> Hi Patrick, I've set the permissions, and now I guess it can't find
> the users' table.
> When i run it under MOngrel, it all works ok, and it recognizes even
> me as already logged in user.
> But under apache it can't find the db.
>
> In the database.yml I have
> production:
>  adapter: sqlite3
>  database: db/production.sqlite3
>  pool: 5
>  timeout: 5000
>
>
> On Dec 7, 12:15 pm, Patrick Fitzgerald <[email protected]> wrote:
> > Hi Edward,
> >    This is most likely a permissions issue, I have sent a more detailed
> > reply to your previous question, let me know how it goes.
> >
> > Cheers,
> > Patrick
> >
> > On Mon, Dec 7, 2009 at 9:59 AM, Edward Samokhvalov <[email protected]
> >wrote:
> >
> > > Dear All,
> > > I've installed passenger and created a test hobo app by "hobo
> > > test_app", started it and got the r4ed message
> >
> > > We're sorry, but something went wrong.
> >
> > > We've been notified about this issue and we'll take a look at it
> > > shortly.
> >
> > > in the production.log there's the following
> >
> > > Processing FrontController#index (for 10.0.133.8 at 2009-12-07
> > > 11:32:58) [GET]
> > > Rendering front/
> > > index
> > >  DRYML: Compiled /usr/lib/ruby/gems/1.8/gems/hobo-0.9.102/taglibs/
> > > core.dryml in 0.02s
> > >  DRYML: Compiled /usr/lib/ruby/gems/1.8/gems/hobo-0.9.102/taglibs/
> > > rapid_core.dryml in 0.20s
> > >  DRYML: Compiled /usr/lib/ruby/gems/1.8/gems/hobo-0.9.102/taglibs/
> > > rapid_support.dryml in 0.01s
> > >  DRYML: Compiled /usr/lib/ruby/gems/1.8/gems/hobo-0.9.102/taglibs/
> > > rapid_document_tags.dryml in 0.03s
> > >  DRYML: Compiled /usr/lib/ruby/gems/1.8/gems/hobo-0.9.102/taglibs/
> > > rapid_pages.dryml in 0.15s
> > >  DRYML: Compiled /usr/lib/ruby/gems/1.8/gems/hobo-0.9.102/taglibs/
> > > rapid_editing.dryml in 0.11s
> > >  DRYML: Compiled /usr/lib/ruby/gems/1.8/gems/hobo-0.9.102/taglibs/
> > > rapid_forms.dryml in 0.22s
> > >  DRYML: Compiled /usr/lib/ruby/gems/1.8/gems/hobo-0.9.102/taglibs/
> > > rapid_navigation.dryml in 0.04s
> > >  DRYML: Compiled /usr/lib/ruby/gems/1.8/gems/hobo-0.9.102/taglibs/
> > > rapid_plus.dryml in 0.17s
> > >  DRYML: Compiled /usr/lib/ruby/gems/1.8/gems/hobo-0.9.102/taglibs/
> > > rapid_generics.dryml in 0.03s
> > >  DRYML: Compiled /usr/lib/ruby/gems/1.8/gems/hobo-0.9.102/taglibs/
> > > rapid_lifecycles.dryml in 0.01s
> > >  DRYML: Compiled /usr/lib/ruby/gems/1.8/gems/hobo-0.9.102/taglibs/
> > > rapid_summary.dryml in 0.14s
> > >  DRYML: Compiled /usr/lib/ruby/gems/1.8/gems/hobo-0.9.102/taglibs/
> > > rapid_user_pages.dryml in 0.18s
> > >  DRYML: Compiled /usr/lib/ruby/gems/1.8/gems/hobo-0.9.102/taglibs/
> > > rapid.dryml in 1.29s
> >
> > > ActionView::TemplateError (No such taglib: /home/es-server/test_app/
> > > app/views {:template_dir=>"app/views/
> > > taglibs", :type=>:include, :src=>"taglibs/auto/rapid/cards"} /home/es-
> > > server/test_app/app/views/taglibs/auto/rapid/cards.dryml) in app/views/
> > > front/
> > > index.dryml:
> >
> > >    hobo (0.9.102) lib/hobo/dryml/taglib.rb:45:in `taglib_filename'
> > >    hobo (0.9.102) lib/hobo/dryml/taglib.rb:12:in `get'
> > >    hobo (0.9.102) lib/hobo/dryml/dryml_builder.rb:121:in
> > > `import_taglib'
> > >    hobo (0.9.102) lib/hobo/dryml/dryml_builder.rb:94:in `build'
> > >    hobo (0.9.102) lib/hobo/dryml/dryml_builder.rb:78:in `each'
> > >    hobo (0.9.102) lib/hobo/dryml/dryml_builder.rb:78:in `build'
> > >    hobo (0.9.102) lib/hobo/dryml/template.rb:73:in `compile'
> > >    hobo (0.9.102) lib/hobo/dryml/taglib.rb:91:in `load'
> > >    hobo (0.9.102) lib/hobo/dryml/taglib.rb:53:in `initialize'
> > >    hobo (0.9.102) lib/hobo/dryml/taglib.rb:17:in `new'
> > >    hobo (0.9.102) lib/hobo/dryml/taglib.rb:17:in `get'
> > >    hobo (0.9.102) lib/hobo/dryml/dryml_builder.rb:121:in
> > > `import_taglib'
> > >    hobo (0.9.102) lib/hobo/dryml/dryml_builder.rb:76:in `build'
> > >    hobo (0.9.102) lib/hobo/dryml/dryml_builder.rb:76:in `each'
> > >    hobo (0.9.102) lib/hobo/dryml/dryml_builder.rb:76:in `build'
> > >    hobo (0.9.102) lib/hobo/dryml/template.rb:73:in `compile'
> > >    hobo (0.9.102) lib/hobo/dryml.rb:173:in `compile_renderer_class'
> > >    hobo (0.9.102) lib/hobo/dryml.rb:159:in `make_renderer_class'
> > >    hobo (0.9.102) lib/hobo/dryml.rb:112:in `page_renderer'
> > >    hobo (0.9.102) lib/hobo/dryml.rb:78:in
> > > `page_renderer_for_template'
> > >    hobo (0.9.102) lib/hobo/dryml/template_handler.rb:19:in
> > > `render_for_rails22'
> > >    hobo (0.9.102) lib/hobo/dryml/template_handler.rb:142:in
> > > `render_dryml'
> > >    hobo (0.9.102) lib/hobo/dryml/template_handler.rb:138:in
> > > `render_dryml'
> > >    hobo (0.9.102) lib/hobo/dryml/template_handler.rb:106:in `render'
> > >    hobo (0.9.102) lib/hobo/dryml/template_handler.rb:83:in
> > > `render_for_file'
> > >    hobo (0.9.102) lib/hobo/controller.rb:23:in `call'
> > >    hobo (0.9.102) lib/hobo/controller.rb:23:in `included_in_class'
> > >    passenger (2.2.7) lib/phusion_passenger/rack/request_handler.rb:
> > > 95:in `process_request'
> > >    passenger (2.2.7) lib/phusion_passenger/
> > > abstract_request_handler.rb:207:in `main_loop'
> > >    passenger (2.2.7) lib/phusion_passenger/railz/
> > > application_spawner.rb:374:in `start_request_handler'
> > >    passenger (2.2.7) lib/phusion_passenger/railz/
> > > application_spawner.rb:332:in `handle_spawn_application'
> > >    passenger (2.2.7) lib/phusion_passenger/utils.rb:184:in
> > > `safe_fork'
> > >    passenger (2.2.7) lib/phusion_passenger/railz/
> > > application_spawner.rb:330:in `handle_spawn_application'
> > >    passenger (2.2.7) lib/phusion_passenger/abstract_server.rb:352:in
> > > `__send__'
> > >    passenger (2.2.7) lib/phusion_passenger/abstract_server.rb:352:in
> > > `main_loop'
> > >    passenger (2.2.7) lib/phusion_passenger/abstract_server.rb:196:in
> > > `start_synchronously'
> > >    passenger (2.2.7) lib/phusion_passenger/abstract_server.rb:163:in
> > > `start'
> > >    passenger (2.2.7) lib/phusion_passenger/railz/
> > > application_spawner.rb:209:in `start'
> > >    passenger (2.2.7) lib/phusion_passenger/spawn_manager.rb:262:in
> > > `spawn_rails_application'
> > >    passenger (2.2.7) lib/phusion_passenger/
> > > abstract_server_collection.rb:126:in `lookup_or_add'
> > >    passenger (2.2.7) lib/phusion_passenger/spawn_manager.rb:256:in
> > > `spawn_rails_application'
> > >    passenger (2.2.7) lib/phusion_passenger/
> > > abstract_server_collection.rb:80:in `synchronize'
> > >    passenger (2.2.7) lib/phusion_passenger/
> > > abstract_server_collection.rb:79:in `synchronize'
> > >    passenger (2.2.7) lib/phusion_passenger/spawn_manager.rb:255:in
> > > `spawn_rails_application'
> > >    passenger (2.2.7) lib/phusion_passenger/spawn_manager.rb:154:in
> > > `spawn_application'
> > >    passenger (2.2.7) lib/phusion_passenger/spawn_manager.rb:287:in
> > > `handle_spawn_application'
> > >    passenger (2.2.7) lib/phusion_passenger/abstract_server.rb:352:in
> > > `__send__'
> > >    passenger (2.2.7) lib/phusion_passenger/abstract_server.rb:352:in
> > > `main_loop'
> > >    passenger (2.2.7) lib/phusion_passenger/abstract_server.rb:196:in
> > > `start_synchronously'
> >
> > > please help
> > > thx in advance
> >
> > > --
> >
> > > You received this message because you are subscribed to the Google
> Groups
> > > "Hobo Users" group.
> > > To post to this group, send email to [email protected].
> > > To unsubscribe from this group, send email to
> > > [email protected]<hobousers%[email protected]>
> <hobousers%[email protected]<hobousers%[email protected]>
> >
> > > .
> > > For more options, visit this group at
> > >http://groups.google.com/group/hobousers?hl=en.
>
> --
>
> You received this message because you are subscribed to the Google Groups
> "Hobo Users" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected]<hobousers%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/hobousers?hl=en.
>
>
>

--

You received this message because you are subscribed to the Google Groups "Hobo 
Users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/hobousers?hl=en.


Reply via email to