How to find a visualrf user from Airwave DB

Aruba Employee
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
 



Diagnostics:

 

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)

 

 

  • First we have to find the role ID for the visualrf user. We can find it using the below command,

 

# 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

 

 



Solution

 

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';"

Version history
Revision #:
2 of 2
Last update:
4 weeks ago
Updated by:
 
Labels (1)
Contributors
Search Airheads
cancel
Showing results for 
Search instead for 
Did you mean: