000032637 - ODBC does not support MySQL community version in RSA Security Analytics

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000032637
Applies ToRSA Product Set: Security Analytics
RSA Version/Condition: 10.x
Platform:- CentOS
When trying to configure MySQL event source, the following error is returned:

Error! An error occurred creating an ODBC connection for DSN: DsnName The trapped error is: Unable to create an ODBC connection. DSN: DsnName; username: dbuser; reason: state: S1000; error-code: 0; description: [RSA][ODBC MySQL Wire Protocol driver]Connections to MySQL Community Servers are not supported. Please contact MySQL to obtain a MySQL Enterprise or Commercial version.
CauseMySQL has three different types of servers:
  • MySQL Community : These are the freely downloadable fully open sourced versions.
  • MySQL Standard: These are packaged versions of the Community server that you must purchase.
  • MySQL Enterprise : This is MySQL's newest offering.  It's a subscription based service where you pay for the server and in return you get quarterly service packs.
The ODBC drivers support 5.0 and later versions of MySQL Standard or MySQL Enterprise servers. They do NOT support any of the MySQL Community servers.
To check the version of the database, please login to your MySQL and issue the following query.
show variables like "%version%";
ResolutionIf it shows "MySQL Community Edition" in the "version_comment" row, then it is not supported.
Please ask the customer to upgrade to either Standard or Enterprise edition for the event source to be supported.