search

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
31 stars 16 forks source link

MySql 8 installation GRANT fails #2

Closed egreenspan2 closed 4 years ago

egreenspan2 commented 4 years ago

In installer.inc.php the GRANT to mysql.proc fails as that table has been finally retired.

$iseSqlPermissions[3] = "GRANT SELECT ON mysql.proc TO '{$_SESSION['iseusername']}'@'%'";

What are the thoughts on removing that line as the stored proc permissions should be granted by SELECT permission on the database.

uck9 commented 4 years ago

May be best to actually note that the MySQL version requirement should be 5.7 and not to run with v8. When trying to integrate the MySQL db with ISE and running the connection test while having Stored Procedures configured always shows the SP's as not existing.

Logging the queries on the mysql server shows the following query run as part of the connection test:

select name from mysql.proc where name='iPSK_FetchGroups' and db='ipsk' LIMIT 0, 25

Would appear that this reference to mysql.proc is hard coded in ISE (2.6 at least). I'd say just easier to stick with ver 5.7 for MySQL at this point.

egreenspan2 commented 4 years ago

Understood, thank you for the feedback