Serwer rzuca dziwnymi błędami związanymi z mysql

Zielona szkoła
1

hej,

mam app na local działa.

Po przeniesieniu na serwer dedykowany.

mam takie błędy:

activerecord (3.2.8) lib/active_record/connection_adapters/sqlite_adapter.rb:472:in `table_structure' activerecord (3.2.8) lib/active_record/connection_adapters/sqlite_adapter.rb:346:in `columns' activerecord (3.2.8) lib/active_record/connection_adapters/schema_cache.rb:12:in `block in initialize' activerecord (3.2.8) lib/active_record/model_schema.rb:228:in `yield' activerecord (3.2.8) lib/active_record/model_schema.rb:228:in `default' activerecord (3.2.8) lib/active_record/model_schema.rb:228:in `columns' activerecord (3.2.8) lib/active_record/model_schema.rb:243:in `column_defaults' activerecord (3.2.8) lib/active_record/base.rb:482:in `initialize' app/controllers/admin/auth_controller.rb:10:in `new' app/controllers/admin/auth_controller.rb:10:in `login' actionpack (3.2.8) lib/action_controller/metal/implicit_render.rb:4:in `send_action' actionpack (3.2.8) lib/abstract_controller/base.rb:167:in `process_action' actionpack (3.2.8) lib/action_controller/metal/rendering.rb:10:in `process_action' actionpack (3.2.8) lib/abstract_controller/callbacks.rb:18:in `block in process_action' activesupport (3.2.8) lib/active_support/callbacks.rb:425:in `_run__756997456091301135__process_action__3584465535325125094__callbacks' activesupport (3.2.8) lib/active_support/callbacks.rb:405:in `__run_callback' activesupport (3.2.8) lib/active_support/callbacks.rb:385:in `_run_process_action_callbacks' activesupport (3.2.8) lib/active_support/callbacks.rb:81:in `run_callbacks' actionpack (3.2.8) lib/abstract_controller/callbacks.rb:17:in `process_action' actionpack (3.2.8) lib/action_controller/metal/rescue.rb:29:in `process_action' actionpack (3.2.8) lib/action_controller/metal/instrumentation.rb:30:in `block in process_action' activesupport (3.2.8) lib/active_support/notifications.rb:123:in `block in instrument' activesupport (3.2.8) lib/active_support/notifications/instrumenter.rb:20:in `instrument' activesupport (3.2.8) lib/active_support/notifications.rb:123:in `instrument' actionpack (3.2.8) lib/action_controller/metal/instrumentation.rb:29:in `process_action' actionpack (3.2.8) lib/action_controller/metal/params_wrapper.rb:207:in `process_action' activerecord (3.2.8) lib/active_record/railties/controller_runtime.rb:18:in `process_action' actionpack (3.2.8) lib/abstract_controller/base.rb:121:in `process' actionpack (3.2.8) lib/abstract_controller/rendering.rb:45:in `process' actionpack (3.2.8) lib/action_controller/metal.rb:203:in `dispatch' actionpack (3.2.8) lib/action_controller/metal/rack_delegation.rb:14:in `dispatch' actionpack (3.2.8) lib/action_controller/metal.rb:246:in `block in action' actionpack (3.2.8) lib/action_dispatch/routing/route_set.rb:73:in `call' actionpack (3.2.8) lib/action_dispatch/routing/route_set.rb:73:in `dispatch' actionpack (3.2.8) lib/action_dispatch/routing/route_set.rb:36:in `call' journey (1.0.4) lib/journey/router.rb:68:in `block in call' journey (1.0.4) lib/journey/router.rb:56:in `each' journey (1.0.4) lib/journey/router.rb:56:in `call' actionpack (3.2.8) lib/action_dispatch/routing/route_set.rb:600:in `call' omniauth (1.1.1) lib/omniauth/strategy.rb:177:in `call!' omniauth (1.1.1) lib/omniauth/strategy.rb:157:in `call' omniauth (1.1.1) lib/omniauth/builder.rb:48:in `call' client_side_validations (3.2.0) lib/client_side_validations/middleware.rb:21:in `call' actionpack (3.2.8) lib/action_dispatch/middleware/best_standards_support.rb:17:in `call' rack (1.4.1) lib/rack/etag.rb:23:in `call' rack (1.4.1) lib/rack/conditionalget.rb:25:in `call' actionpack (3.2.8) lib/action_dispatch/middleware/head.rb:14:in `call' actionpack (3.2.8) lib/action_dispatch/middleware/params_parser.rb:21:in `call' actionpack (3.2.8) lib/action_dispatch/middleware/flash.rb:242:in `call' rack (1.4.1) lib/rack/session/abstract/id.rb:205:in `context' rack (1.4.1) lib/rack/session/abstract/id.rb:200:in `call' actionpack (3.2.8) lib/action_dispatch/middleware/cookies.rb:339:in `call' activerecord (3.2.8) lib/active_record/query_cache.rb:64:in `call' activerecord (3.2.8) lib/active_record/connection_adapters/abstract/connection_pool.rb:473:in `call' actionpack (3.2.8) lib/action_dispatch/middleware/callbacks.rb:28:in `block in call' activesupport (3.2.8) lib/active_support/callbacks.rb:405:in `_run__1396501287741122195__call__836070170362757632__callbacks' activesupport (3.2.8) lib/active_support/callbacks.rb:405:in `__run_callback' activesupport (3.2.8) lib/active_support/callbacks.rb:385:in `_run_call_callbacks' activesupport (3.2.8) lib/active_support/callbacks.rb:81:in `run_callbacks' actionpack (3.2.8) lib/action_dispatch/middleware/callbacks.rb:27:in `call' actionpack (3.2.8) lib/action_dispatch/middleware/reloader.rb:65:in `call' actionpack (3.2.8) lib/action_dispatch/middleware/remote_ip.rb:31:in `call' actionpack (3.2.8) lib/action_dispatch/middleware/debug_exceptions.rb:16:in `call' actionpack (3.2.8) lib/action_dispatch/middleware/show_exceptions.rb:56:in `call' railties (3.2.8) lib/rails/rack/logger.rb:26:in `call_app' railties (3.2.8) lib/rails/rack/logger.rb:16:in `call' actionpack (3.2.8) lib/action_dispatch/middleware/request_id.rb:22:in `call' rack (1.4.1) lib/rack/methodoverride.rb:21:in `call' rack (1.4.1) lib/rack/runtime.rb:17:in `call' activesupport (3.2.8) lib/active_support/cache/strategy/local_cache.rb:72:in `call' rack (1.4.1) lib/rack/lock.rb:15:in `call' actionpack (3.2.8) lib/action_dispatch/middleware/static.rb:62:in `call' railties (3.2.8) lib/rails/engine.rb:479:in `call' railties (3.2.8) lib/rails/application.rb:223:in `call' railties (3.2.8) lib/rails/railtie/configurable.rb:30:in `method_missing' passenger (3.0.18) lib/phusion_passenger/rack/request_handler.rb:96:in `process_request' passenger (3.0.18) lib/phusion_passenger/abstract_request_handler.rb:516:in `accept_and_process_next_request' passenger (3.0.18) lib/phusion_passenger/abstract_request_handler.rb:274:in `main_loop' passenger (3.0.18) lib/phusion_passenger/rack/application_spawner.rb:206:in `start_request_handler' passenger (3.0.18) lib/phusion_passenger/rack/application_spawner.rb:171:in `block in handle_spawn_application' passenger (3.0.18) lib/phusion_passenger/utils.rb:470:in `safe_fork' passenger (3.0.18) lib/phusion_passenger/rack/application_spawner.rb:166:in `handle_spawn_application' passenger (3.0.18) lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop' passenger (3.0.18) lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously' passenger (3.0.18) lib/phusion_passenger/abstract_server.rb:180:in `start' passenger (3.0.18) lib/phusion_passenger/rack/application_spawner.rb:129:in `start' passenger (3.0.18) lib/phusion_passenger/spawn_manager.rb:253:in `block (2 levels) in spawn_rack_application' passenger (3.0.18) lib/phusion_passenger/abstract_server_collection.rb:132:in `lookup_or_add' passenger (3.0.18) lib/phusion_passenger/spawn_manager.rb:246:in `block in spawn_rack_application' passenger (3.0.18) lib/phusion_passenger/abstract_server_collection.rb:82:in `block in synchronize' <internal:prelude>:10:in `synchronize' passenger (3.0.18) lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize' passenger (3.0.18) lib/phusion_passenger/spawn_manager.rb:244:in `spawn_rack_application' passenger (3.0.18) lib/phusion_passenger/spawn_manager.rb:137:in `spawn_application' passenger (3.0.18) lib/phusion_passenger/spawn_manager.rb:275:in `handle_spawn_application' passenger (3.0.18) lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop' passenger (3.0.18) lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously' passenger (3.0.18) helper-scripts/passenger-spawn-server:99:in `<main>'
app opiera się o mysql korzystam z GEM’a mysql2.

ustawienia bazy:

[code]development:
adapter: mysql2
encoding: utf8
reconnect: false
database: fb_dev
pool: 5
username: xxx
password: xxx
socket: /var/run/mysqld/mysqld.sock

…[/code]
GemFile

[code]source ‘https://rubygems.org’

gem ‘rails’, ‘3.2.9’

Bundle edge Rails instead:

gem ‘rails’, :git => ‘git://github.com/rails/rails.git’

gem “mysql2”

Gems used only for assets and not required

in production environments by default.

group :assets do

See https://github.com/sstephenson/execjs#readme for more supported runtimes

gem ‘therubyracer’, :platforms => :ruby
gem ‘coffee-rails’, ‘~> 3.2.1’

gem ‘uglifier’, ‘>= 1.0.3’

end
gem ‘will_paginate’, ‘~> 3.0’
gem ‘will_paginate-bootstrap’
gem ‘jquery-rails’
gem “dynamic_form”
gem ‘client_side_validations’
gem ‘simple_form’, ‘2.0’
gem “koala”
gem “paperclip”, “~> 3.0”
gem “magic_encoding”[/code]
Po przeniesieniu na serwer na tych ustawieniach co wyżej daje rake db:migrate tworzy mi tabele itp…

ale jak wchodzę już na URL mam błąd: Could not find table ‘admins’
Mimo, że tabela, baza istnieje. Czemu w ogóle w logu piszę coś o sqlitle??
Nie wiem czemu ale też tworzy plik z development.sqlite3 w db … a ustawione jest mysql2?

Zna ktoś przyczynę

2

Defaultowe rack_env i rails_env dla passengera to production, wygląda jakbyś miał nieustawioną sekcję production w database.yml

3

jest ustawione bez zmian… skąd tam te sqlitle w logu może Defaultowo passenger korzysta z tej bazy… ??

4

[quote=piotrstanek]Po przeniesieniu na serwer na tych ustawieniach co wyżej daje rake db:migrate tworzy mi tabele itp…

ale jak wchodzę już na URL mam błąd: Could not find table ‘admins’
Mimo, że tabela, baza istnieje. Czemu w ogóle w logu piszę coś o sqlitle??[/quote]
sprobuj

rake db:migrate RAILS_ENV=production

i przestaw w ymlu development na production, albo skonfiguruj odpowiednio passengera jesli na pewno chcesz zeby korzystal z dev

5

skonfigurowałem passengera

PS

rake db:migrate RAILS_ENV=production

nic nie dawało bo już próbowałem.

Ale teraz jest ok.