Hi folks,
We would like to use EAP-PEAP/MsCHAPv2 authentication on our wireless networks and implement a CPPM server. We have a legacy external postgesql, but the user's passwords stored only with SHA256 hash in it. I made a query but I get a REJECT message with user not found description. But if I add a new user with plain text password the authentication works well. Can anyone help for me, how can I resolve this ?
Table structure:
userid | username | password | ssid | created | modified
Filter query: SELECT password AS User_Password, ssid AS SSID FROM Users WHERE username = '%{Authentication:Username}' AND ssid = LOWER('%{Radius:Aruba:Aruba-Essid-Name}');