Profile manager login not working after update

[plsfcn]

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?

Edited October 20, 2014 by plsfcn

[furby]

http://www.edugeek.net/forums/mac/142254-bug-os-x-server-v3-2-1-a.html perhaps?

 

Suspect just rolling back the server.app wouldn't work. You could 'just' reload the OS from Recovery mode and then choose an earlier time machine backup. I feel like I was able to choose several dates last time I restored my server, can someone else confirm that, I feel unsure now that I'm typing it out

[plsfcn]

I solved it by restoring my server from Time machine backup.

[SeanIT]

Im having the same issue. Can you tell me the exact steps you used to perform the Time Machine Restore? We have around 5000 devices connected to profile manager and I dont want to make a stupid mistake....

 

Thanks

[plsfcn]

I created a usb-stick with Maverick-installation and booted the server with this. In the menu you can choose to restore from Time Machine backups.

[ste1988]

Having the same issue, only a restore hasn't resolved the issue, just trying to locate the post about completely removing server app and all of its data but unable to find the post on here, if you simply delete the app and reinstall, it saves all previous data used, i would like to do a complete fresh install of server app.

 

Any one know how to do this?

 

Cheers