Security

Reply
New Contributor
Posts: 1
Registered: ‎03-18-2008

ODBC driver for MySQL

ClearPass team,

 

We're trying to set up ClearPass for a simple MAC AUTH scenario, querying an existing MySQL database of "registered" hosts as an auth source.  Despite the documentation and product marketing saying it will support "any ODBC-compliant SQL server", there only appear to be ODBC drivers built in for MSSQL and Postgres.  Where can we get access to a MySQL driver?  Beta code is fine - we're happy to help test. Thanks!

 

 

Guru Elite
Posts: 20,002
Registered: ‎03-29-2007

Re: ODBC driver for MySQL

We can upload your SQL driver and it will show up as a source in the dropdown.

 

Please contact support about this.


Colin Joseph
Aruba Customer Engineering

Looking for an Answer? Search the Community Knowledge Base Here: Community Knowledge Base

Validated Reference Design Guides : http://community.arubanetworks.com/t5/Validated-Reference-Design/tkb-p/Aruba-VRDs
Super Contributor I
Posts: 289
Registered: ‎02-07-2013

Re: ODBC driver for MySQL

Hi,

I also need a driver for MySQL for my 6.3.3 clearpass setup.... Well its actually an eval at the moment but we'll be purchasing clearpass in the nect couple of weeks

Rgds

A

Guru Elite
Posts: 7,853
Registered: ‎09-08-2010

Re: ODBC driver for MySQL

[ Edited ]

Contact Aruba TAC for latest enablement patch.

 

<EDIT> The current version is available on the support site:

 

http://support.arubanetworks.com/ToolsResources/tabid/76/DMXModule/514/Command/Core_Download/Default.aspx?EntryId=13130

 

 


Tim Cappalli | Aruba ClearPass TME
@timcappalli | ACMX #367 / ACCX #480 / ACEAP / CWSP
Frequent Contributor I
Posts: 66
Registered: ‎08-16-2011

Re: ODBC driver for MySQL

To echo what the other's have said, call TAC. 

 

I had the same issue & was able to get w/ TAC to resolve it.  Make sure you've downloaded the correct driver for your version of CPPM from the support site.  They are in the ClearPass folder under the "Tools & Resources"  Tab, not software (as one would suppose).

 

Once you've downloaded it, depending on your version of CPPM you may or may not be able to import it as an update.  CPPM > Administration > Agents and Software Updates > Software Updates.  

 

If you run into issues (as I did) call TAC.  

 

They essentially had me upload the update to the CPPM server via the CLI using the arubasupport user (which you'll have to enable to get shell access to your CPPM server).  I used SCP.

 

$ scp CPPM-x86_64-20140218-mysql-support-patch.zip.signed arubasupport@<YOUR CPPM IP>:~/. 
CPPM-x86_64-20140218-mysql-support-patch.zip. 100%  210KB 209.8KB/s   00:00    
$

 

Once you have that done, login to your CPPM using the arubasupport user & launch a shell.  Then copy the file to the update directory : 

 

[arubasupport@CPPM ~]$ sudo sh

sh-4.1# ls 
bin  CPPM-x86_64-20140218-mysql-support-patch.zip.signed
sh-4.1# cp CPPM-x86_64-20140218-mysql-support-patch.zip.signed /var/avenda/platform/store/updates/
sh-4.1# 

 

Then, open a new shell & login as the appadmin user.  Apply the update.  

 

[appadmin@CPPM]# system update -i CPPM-x86_64-20140218-mysql-support-patch.zip.signed


Installing patch from=CPPM-x86_64-20140218-mysql-support-patch.zip.signed
Extracting patch...
INFO - CPPM-x86_64-20140218-mysql-support-patch.zip.signed is signed
INFO: Preparing ...
INFO: Running pre-install scripts ...
INFO: Applying patch ...
INFO: Recording patch ...
INFO: Running post-install scripts ...
Preparing...                ########################################### [100%]
   1:mysql-connector-odbc   ########################################### [100%]
Success: Usage count is 1
INFO: Patching complete with status - 0
Exiting with 0
[appadmin@CPPM]#

 

That did it for me, now on to configuration, Policy Simulation, & testing.

 

 

 

--Raf
Search Airheads
Showing results for 
Search instead for 
Did you mean: