Cisco Cisco NAC Appliance 4.9.1 Information Guide

After the password is changed, enter reboot in order to reboot the box.

8. 

There is no standard procedure to recover the admin password. The only procedure available is for the CLI
ROOT password.

Connect to the CLI and issue these commands:

[root@cca−3390−cam ~]#  psql −h 127.0.0.1 controlsmartdb −U postgres

controlsmartdb=# select * from admin_account;

You should now see a list of users, similar to this:

id |    name    |                 password                 | 

group_name     | enable |      admin_desc

−−−−+−−−−−−−−−−−−+−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−+−−−−−−−−−−−−−−−−−−−−+−−−−−−−−+−−−−−−−−−−−−−−−−−−−−−−−

  0 | admin      | 96208ed2256706e8d8b29c1bf58d10c4a07267b4c1 | 

Full−Control Admin |      1 | Primary admin account

  1 | localadmin | b0f3e23dcd1046d1dbf4e095186d5cb54e47963690 | 

GuestLobby         |      1 | only local users

  2 | admin1     | 96208ed225670d688bs29c1bf58d10c4a07267b4c1 | 

Full−Control Admin |      1 | admin test user

(3 rows)

1. 

You need to see the highest id value and increment it (in this example, the new value is 3).

2. 

Insert the new user with the command:

insert into admin_account(id, name, password, group_name, enable) 

values ('3', 'recover', 'cisco123', 'Full−Control Admin', '1');

3. 

Verify if the recover user is in the DB:

controlsmartdb=# select * from 

admin_account;                                    id |    name 

|                 password                 |     group_name     | enable 

|      admin_desc

−−−−+−−−−−−−−−−−−+−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−+−−−−−−−−−−−−−−−−−−−−+−−−−−−−−+−−−−−−−−−−−−−−−−−−−−−−−

  0 | admin      | 96208ed225670688b29c1bf58d10c4a07267b4c1 | 

Full−Control Admin |      1 | Primary admin account

  1 | localadmin | b0f3e23dcd10461db4e095186d5cb54e47963690 | 

GuestLobby         |      1 | only local users

  2 | admin1     | 96208ed225670688b29c1bf58d10c4a07267b4c1 | 

Full−Control Admin |      1 | admin test user

  3 | recover    | cisco123                                 | 

Full−Control Admin |      1 |

(4 rows)

4. 

Login to the GUI with this new user.

5. 

Use the SQL command to delete the admin user.

Enter the SQL command line:

[root@cca−3390−cam ~]#  psql −h 127.0.0.1 controlsmartdb −U postgres

1. 

Delete the admin user (id=0).

controlsmartdb=# delete from admin_account where id='0';  

2.