Hi.
I have a mac server OS X 10.9.5 with Server-app. We enroll and administrate about 1000 ipads with Profile manager.
I ran the update of Server-app to 3.2.2 and now we no longer can login to the webinterface of profile manager or mydevices.
We get the message:
We're sorry, but something went wrong.
We'e been notified about this issue and we'll take a look at it shortly.
(if you're the administrator of this website, then please read the log file "profilemanager.log" to find out what went wrong.)
I have the Time machine running sence years back but i dont exactly know which files to recover. I don't know if i can safely remove Server-app and install it again without loseing the database of all devices etc.
This is the actions of the service log for Profile manager
## When I just browse to the webinterface of profilemanager
[2678] [2014/10/20 12:09:06.896] I: Processing MagicController#admin_will_load (for xxx.yyy.zzz.xxx at 2014-10-20 12:09:06)
[2678] [2014/10/20 12:09:06.898] I: auth_token doesn't exist
[2678] [2014/10/20 12:09:06.898] I: Filter chain halted as [:verify_auth_token] rendered_or_redirected.
[2678] [2014/10/20 12:09:06.898] I: Completed in 2ms (View: 0, DB: 2) | 403 Forbidden [https://xxx.zzz.yyy/magic/admin_will_load]
[2679] [2014/10/20 12:09:08.401] I: Processing MagicController#do_magic (for xxx.yyy.zzz.xxx at 2014-10-20 12:09:08)
[2679] [2014/10/20 12:09:08.403] I: auth_token doesn't exist
[2679] [2014/10/20 12:09:08.403] I: Filter chain halted as [:verify_auth_token] rendered_or_redirected.
[2679] [2014/10/20 12:09:08.403] I: Completed in 2ms (View: 0, DB: 2) | 403 Forbidden [https://xxx.zzz.yyy/magic/do_magic]
## When login with any account
[2680] [2014/10/20 12:11:15.983] I: Processing AuthenticationController#callback (for xxx.yyy.zzz.xxx at 2014-10-20 12:11:15) [GET]
[2680] [2014/10/20 12:11:16.272] F: ActiveRecord::StatementInvalid (PG::Error: ERROR: relation "view_all_user_groups_users_flat" does not exist
LINE 2: FROM view_all_user_groups_users_flat AS j
^
: SELECT COUNT(j.*)
FROM view_all_user_groups_users_flat AS j
WHERE j.user_id = 7
AND j.user_group_id = 802
LIMIT 1
):
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/connection_adapters/abstract_adapter.rb:227:in `rescue in log'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/connection_adapters/abstract_adapter.rb:204:in `log'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/connection_adapters/postgresql_adapter.rb:520:in `execute'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/connection_adapters/postgresql_adapter.rb:1002:in `select_raw'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/connection_adapters/postgresql_adapter.rb:989:in `select'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in `block in select_all_with_query_cache'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/connection_adapters/abstract/query_cache.rb:81:in `cache_sql'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in `select_all_with_query_cache'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/connection_adapters/abstract/database_statements.rb:13:in `select_one'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/connection_adapters/abstract/database_statements.rb:19:in `select_value'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/base.rb:920:in `count_by_sql'
app/models/user_group.rb:371:in `user_is_member_of_group'
app/models/user.rb:293:in `user_is_admin?'
app/controllers/application_controller.rb:258:in `verify_admin_logged_in'
vendor/ruby/1.9.1/gems/activesupport-2.3.18/lib/active_support/callbacks.rb:178:in `evaluate_method'
vendor/ruby/1.9.1/gems/activesupport-2.3.18/lib/active_support/callbacks.rb:166:in `call'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/filters.rb:225:in `call'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/filters.rb:629:in `run_before_filters'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/filters.rb:615:in `call_filters'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/filters.rb:610:in `perform_action_with_filters'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/benchmarking.rb:68:in `block in perform_action_with_benchmark'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/benchmarking.rb:68:in `perform_action_with_benchmark'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/rescue.rb:160:in `perform_action_with_rescue'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/flash.rb:151:in `perform_action_with_flash'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/base.rb:532:in `process'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/filters.rb:606:in `process_with_filters'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/base.rb:391:in `process'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/base.rb:386:in `call'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/routing/route_set.rb:438:in `call'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/dispatcher.rb:87:in `dispatch'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/dispatcher.rb:121:in `_call'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/dispatcher.rb:130:in `block in build_middleware_stack'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/string_coercion.rb:25:in `call'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/string_coercion.rb:25:in `call'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/params_parser.rb:15:in `call'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/session/abstract_store.rb:177:in `call'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/query_cache.rb:29:in `block in call'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/connection_adapters/abstract/query_cache.rb:34:in `cache'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/query_cache.rb:9:in `cache'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/query_cache.rb:28:in `call'
vendor/ruby/1.9.1/gems/activerecord-2.3.18/lib/active_record/connection_adapters/abstract/connection_pool.rb:361:in `call'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/failsafe.rb:26:in `call'
:10:in `synchronize'
vendor/ruby/1.9.1/gems/actionpack-2.3.18/lib/action_controller/dispatcher.rb:106:in `call'
vendor/ruby/1.9.1/gems/rails-2.3.18/lib/rails/rack/static.rb:31:in `call'
vendor/ruby/1.9.1/gems/rails-2.3.18/lib/rails/rack/log_tailer.rb:17:in `call'
vendor/ruby/1.9.1/gems/thin-1.5.1/lib/thin/connection.rb:81:in `block in pre_process'
vendor/ruby/1.9.1/gems/thin-1.5.1/lib/thin/connection.rb:79:in `catch'
vendor/ruby/1.9.1/gems/thin-1.5.1/lib/thin/connection.rb:79:in `pre_process'
vendor/ruby/1.9.1/gems/thin-1.5.1/lib/thin/connection.rb:54:in `process'
vendor/ruby/1.9.1/gems/thin-1.5.1/lib/thin/connection.rb:39:in `receive_data'
vendor/ruby/1.9.1/gems/eventmachine-1.0.3/lib/eventmachine.rb:187:in `run_machine'
vendor/ruby/1.9.1/gems/eventmachine-1.0.3/lib/eventmachine.rb:187:in `run'
vendor/ruby/1.9.1/gems/thin-1.5.1/lib/thin/backends/base.rb:63:in `start'
vendor/ruby/1.9.1/gems/thin-1.5.1/lib/thin/server.rb:159:in `start'
vendor/ruby/1.9.1/gems/thin-1.5.1/lib/thin/controllers/controller.rb:86:in `start'
vendor/ruby/1.9.1/gems/thin-1.5.1/lib/thin/runner.rb:187:in `run_command'
vendor/ruby/1.9.1/gems/thin-1.5.1/lib/thin/runner.rb:152:in `run!'
thin:11:in `'
[2680] [2014/10/20 12:11:16.273] I: Rendering /Applications/Server.app/Contents/ServerRoot/usr/share/devicemgr/backend/public/500.html (500 Internal Server Error)
Does anyone have a clue what we can do to fix this?
