Log in to ask questions, share your expertise, or stay connected to content. Don’t have a login? Join now.
Problem:
Sometimes we come across scenarios where we see the below error message in Visualrf, the reason for this error is because the Visualrf user is locked out from Airwave DB
To debug this issue we have to find the visualrf user from the Airwave database and enable it, if it have gone to disable state. To find the visualrf user we can follow the below steps, We can get more details from the Visualrf.log. We will see message like below,
2017-10-09 21:36:40,748 WARN HTTP[1] com.airwave.model.parsers.UserPreferenceParser error finding role java.lang.NullPointerException ae com.airwave.model.parsers.UserPreferenceParser.createUserPrefNodptions.MissingAuthorizationInfo: MissingAuthorizationInfo at com.airwave.model.parsers.UserPreferenceParser.createUserPrefNode(UserPreferenceParser.java:165) at com.airwave.model.parsers.UserPreferenceParser.createNodes(UserPreferenceParser.java:99) at com.airwave.svg.APIFacadeImpl.getUserPref(APIFacadeImpl.java:4351) at com.airwave.svg.APIFacadeImpl.getUserPref(APIFacadeImpl.java:224) at com.airwave.svg.init.RequestHandler.run(RequestHandler.java:2350) at com.airwave.svg.init.DelegateHttpHandler.handle(DelegateHttpHandler.java:39) at com.sun.net.httpserver.Filter$Chain.doFilter(Unknown Source) at sun.net.httpserver.AuthFilter.doFilter(Unknown Source) at com.sun.net.httpserver.Filter$Chain.doFilter(Unknown Source) at sun.net.httpserver.ServerImpl$Exchange$LinkHandler.handle(Unknown Source) at com.sun.net.httpserver.Filter$Chain.doFilter(Unknown Source) at com.airwave.svg.http.AMPContextFilter.doFilter(AMPContextFilter.java:65) at com.sun.net.httpserver.Filter$Chain.doFilter(Unknown Source) at sun.net.httpserver.ServerImpl$Exchange.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)
# dbc "select * from role where name = 'visualrf';"
-[ RECORD 3 ]------------------------+-------------------------------- id | 7 name | visualrf access_level | visualrf enabled | 1 rapids | 1 visualrf | helpdesk | 0 flash_enabled | 1 sponsor_allow_no_expiration | 1 sponsor_guest_lifetime_duration | sponsor_guest_lifetime_duration_text | sponsor_allow_sponsor_name_change | 0 sponsor_custom_message | mc_global | 1 guest_user_enabled | 1 allow_authorize_aps | allow_disable_timeout | 0 helpdesk_only | aruba_controller_role | Disabled allow_reboot_device | 0 apprf | 1 ucc | 1
From the above output we can see that visualrf role is 7 for this server. Now we can query against the user table for the user mapped to this role
# dbc "select * from users where role_id = '7';"
-[ RECORD 1 ]---+--------------------------------- id | 11 username | RzGTVzgjTK password | 112cd1aceab495ae7c2a530f9451012d role_id | 7 full_name | email | phone | notes | password_format | md5 login_attempts | 0 is_enabled | 0
Now we have found the visualrf user and we can see the field "is_enabled" is set to 0. We have to enable it to get the visualrf back up. We can execute the below command to enable the user. # dbc "update users set is_enabled = '1' where role_id = '7';"
© Copyright 2024 Hewlett Packard Enterprise Development LPAll Rights Reserved.