cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
568
Views
0
Helpful
2
Replies

eapAuthentication field

Hi

I need to update the field eapAuthentication in all ip phones by sql. But I'm not able to found the table of eapAuthentication field is presented.

Could you know what is the table?

2 Replies 2

dstaudt
Cisco Employee
Cisco Employee

Looking at the UI and Data Dictionary, it appears:

- device.fkwirelesslanprofilegroup indicates the device's 'Wireless LAN Profile Group'.  If the WLAN group/profiles have already been configured, then you probably only need to update this field

- wirelesslanprofilegroupmember.fkwirelesslanprofile points to the individual profile

- wirelesslanprofile.tkwifiauthenticationmethod indicates the type of auth, i.e. one of:

select * from typewifiauthenticationmethod

enum name          moniker                                  displayorder

==== ============= ======================================== ============

0    None          WIFI_AUTHENTICATION_METHOD_NONE          6          

1    WEP           WIFI_AUTHENTICATION_METHOD_WEP           5          

2    PSK           WIFI_AUTHENTICATION_METHOD_PSK           4          

3    EAP-FAST      WIFI_AUTHENTICATION_METHOD_EAP_FAST      1          

4    PEAP-MSCHAPv2 WIFI_AUTHENTICATION_METHOD_PEAP_MSCHAPV2 2          

5    PEAP-GTC      WIFI_AUTHENTICATION_METHOD_PEAP_GTC      3          

Note, to set the reverse password for a Wireless Lan Profile, you will likely need to use the <updateWLANProfile> request, which will properly hash the password into the table.