uflogos.blogg.se

> CONSTRAINT `user_group_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) You can add other groups similarly and list the content of the table: mysql>Ĭreate table for mappings between users and groups mysql> > UNIQUE KEY `groupname_UNIQUE` (`groupname`)Ĭreate groups and add them into table: mysql> > `group_id` int(10) unsigned NOT NULL AUTO_INCREMENT, You can add other users similarly and list the content of the table (the same way as users, add MAC address for MAB authentication - password can stay blank): > UNIQUE KEY `username_UNIQUE` (`username`)Ĭreate users and add them into the table: mysql> > `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,

Mysql> GRANT USAGE ON *.* TO GRANT ALL PRIVILEGES ON `demo_db`.* TO GRANT SELECT ON *.* TO table of users: mysql> Mysql> CREATE USER 'cisco' IDENTIFIED BY 'cisco' You can turn off this feature to get a quicker startup with -AĬreate database user and grant him privileges: mysql> Reading table information for completion of table and column names To access MySQL database: mysql -u root -p 2. Install MySQL (you should be prompted for a password for root user during the installation): sudo apt-get install mysql-server Do not treat is as a Cisco recomendation. MySQL configuration presented is an example. This image illustrates the network topology that is used: On the ISE, MySQL is configured as an external identity store. The Wireless LAN (WLAN) on the WLC is configured in order to authenticate the users via the ISE. In this configuration example, the endpoint uses a wireless adapter in order to associate with the wireless network. More information can be found here: Configure Network Diagram This is a list database engines supported in ISE 2.2: ODBC identity source can be used in an identity store sequence and for Guest and Sponsor authentications. You can use ODBC as external identity source to authenticate users and endpoints similar to Active Directory (AD). ISE 2.2 supports multiple ODBC external sources, one of them is MySQL. If your network is live, make sure that you understand the potential impact of any command. All of the devices used in this document started with a cleared (default) configuration. The information in this document was created from the devices in a specific lab environment. Cisco Wireless LAN Controller (WLC) Version 8.0.100.0.The information this document is based on these software and hardware versions: Identity Services Engine (ISE) configuration.Prerequisites RequirementsĬisco recommends that you have knowledge of these topics: This document is valid for setups that use MySQL as the external identity source for the ISE authentication and authorization. This document describes how to configure a Cisco Identity Services Engine (ISE) 2.2 for integration with MySQL Open Database Connectivity (ODBC) external source.