Maximize your protection, eliminate business risks.
Optimize and modernize with cloud transformation.
Empower your people to work securely from anywhere.
Let us handle IT so you can focus on growing your business.
Get multichannel 24/7/365 expert end-user support.
Protect, detect, and respond—Dataprise keeps your business secure.
Maximize uptime with with industry-leading DRaaS.
Swiftly mitigate cyber threats and restore security.
Improve efficiency, productivity and outcomes with cloud.
Ensure all mobile devices, everywhere, are secure.
Gain a competitive edge with strategic IT solutions.
This battle-tested checklist enables your team to swiftly initiate a ransomware response.
IT for businesses of all sizes, in any industry.
Empower institution growth with custom IT solutions.
Ensure your firm is always in compliance.
Improve patient care and staff morale.
Deal with pressing legal matters, not IT.
Keep up with the evolving digital landscape.
Focus on your mission by outsourcing IT.
Keep production running with secure, always-on IT.
Accelerate PE client deals and secure data.
Empower Your Municipality with Secure, Reliable IT Services
Execute initiatives and develop IT strategies.
Get the latest industry insights and trends.
Join us at events in person and online.
Hear from clients and learn more about strategic IT.
See how Dataprise can make IT your greatest asset.
Get informative technical resources from IT experts.
Stay on stop of emerging cybersecurity threats.
Discover the key areas of DR your organization needs to address to ensure downtime is minimized.
Gain a strategic asset by bringing harmony to IT.
Ensure 24/7 support and security with dedicated teams.
Drive business forward by partnering with Dataprise.
Meet our one-of-a-kind leadership team.
Discover the recognition Dataprise has earned.
Help us help businesses with strategic IT.
Grow through acquisition and partnership with Dataprise.
Embracing different perspectives and backgrounds.
Find a Dataprise location near you.
Dataprise is committed to empowering more women to consider a career in technology.
Explore our trusted partnerships with leading tech innovators.
Posts
By: Stephanie Hamrick
Table of content
This document describes the creation of a freeradius server with mysql back-end to be used for dot1x authentication from a Cisco WLC serving guest wireless access for a series of Cisco Aironets. We will walk through compilation of the latest stable opennsl (1.1.1a) and freeradius 3.0.17, test authentication and then configure a mysql back-end radius clients, authentication and accounting.
root@Wireless-Svr:/tmp/openssl-1.1.1a# ./config –prefix=/apps/openssl-1.1.1a Operating system: x86_64-whatever-linux2 Configuring OpenSSL version 1.1.1a (0x1010101fL) for linux-x86_64 Using os-specific seed configuration Creating configdata.pm Creating Makefile
********************************************************************** *** *** *** OpenSSL has been successfully configured *** *** *** *** If you encounter a problem while building, please open an *** *** issue on GitHub <https://github.com/openssl/openssl/issues> *** *** and include the output from the following command: *** *** *** *** perl configdata.pm –dump *** *** *** *** (If you are new to OpenSSL, you might want to consult the *** *** ‘Troubleshooting’ section in the INSTALL file first) *** *** *** **********************************************************************
Looking for more posts like this one? Check out the Networking section of our blog for everything from networking basics to advanced configurations!
$username Cleartext-Password := $password (Cisco Controller) >test aaa radius username $username password $password wlan-id 3Radius Test Request Wlan-id…………………………………. 3 ApGroup Name…………………………….. none
Attributes Values ——-— —— User-Name $username Called-Station-Id 00-00-00-00-00-00:SGR_Guest Calling-Station-Id 00-11-22-33-44-55 Nas-Port 0x00000005 (5) Nas-Ip-Address $Cisco_WLC_IP NAS-Identifier $WLC_Hostname Airespace / WLAN-Identifier 0x00000003 (3) User-Password $password Service-Type 0x00000008 (8) Framed-MTU 0x00000514 (1300) Nas-Port-Type 0x00000013 (19) Tunnel-Type 0x0000000d (13) Tunnel-Medium-Type 0x00000006 (6) Tunnel-Group-Id 0x00000ce3 (3299) Cisco / Audit-Session-Id 0ac80119000003a35c3de9cc Acct-Session-Id 5c3de9cc/00:11:22:33:44:55/959
test radius auth request successfully sent. Execute ‘test aaa show radius’ for response root@Wireless-Svr:~# radiusd -X … port = 18120 } Listening on auth address * port 1812 bound to server default Listening on acct address * port 1813 bound to server default Listening on auth address :: port 1812 bound to server default Listening on acct address :: port 1813 bound to server default Listening on auth address 127.0.0.1 port 18120 bound to server inner-tunnel Listening on proxy address * port 56365 Listening on proxy address :: port 40764 Ready to process requests
(Cisco Controller) >test aaa radius username $username password $password wlan-id 3
Radius Test Request Wlan-id…………………………………. 3 ApGroup Name…………………………….. none
test radius auth request successfully sent. Execute ‘test aaa show radius’ for response
(Cisco Controller) >test aaa show radius
Radius Test Request Wlan-id…………………………………. 3 ApGroup Name…………………………….. none Radius Test Response
Radius Server Retry Status ———-— –— —— $FreeRadius_ServerIP 6 Success
Authentication Response: Result Code: Success No AVPs in Response
root@Wireless-Svr:~# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 3033 Server version: 5.5.50-0ubuntu0.14.04.1 (Ubuntu)Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the current input statement.
mysql> create database radius; Query OK, 1 row affected (0.00 sec)
mysql> quit Bye
mysql> GRANT ALL PRIVILEGES ON radius.* TO ‘radius’@’localhost’ IDENTIFIED by ‘$password’; Query OK, 0 rows affected (0.00 sec)mysql> flush privileges; Query OK, 0 rows affected (0.00 sec)
root@Wireless-Svr:~# mysql -u radius -p radius Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -AWelcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 3037 Server version: 5.5.50-0ubuntu0.14.04.1 (Ubuntu)
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
mysql> show tables; +——————+ | Tables_in_radius | +——————+ | nas | | radacct | | radcheck | | radgroupcheck | | radgroupreply | | radpostauth | | radreply | | radusergroup | +——————+ 8 rows in set (0.00 sec)
mysql> INSERT INTO radcheck (username, attribute, op, value) VALUES (‘$username’, ‘Cleartext-Password’, ‘:=’, ‘$password’); Query OK, 1 row affected (0.00 sec)
mysql>
mfuller, PEI
INSIGHTS
Subscribe to our blog to learn about the latest IT trends and technology best practices.