Add input validation on installer to avoid iPSK database user and ISE ODBC user to be the same (leads to "Creation of Cisco ISE MySQL user failed")

CiscoDevNet / iPSK-Manager

Identity PSK (IPSK) Manager for Cisco ISE provides an example of how to manage the full Life Cycle of Wi-Fi Pre Shared Keys for supported Hardware/Software through Cisco ISE.

Apache License 2.0

30 stars 16 forks source link

Add input validation on installer to avoid iPSK database user and ISE ODBC user to be the same (leads to "Creation of Cisco ISE MySQL user failed") #21

Closed AnthoBalitrand closed 11 months ago

AnthoBalitrand commented 3 years ago

Issue

On installer, if "iPSK database username" and "Cisco ISE ODBC Username" have the same values, the install script indeed tries to create 2 mySQL users with the same username, which leads to the "Creation of Cisco ISE MySQL user failed" error. (On backend, mySQL error 1396).

Suggested solution

Add data validation on the installer form to avoid those 2 values to be the same.

ciesinsn commented 11 months ago

This will be added in the next commit.

ciesinsn commented 11 months ago

changes have been merged into master branch