Guest

Preview Tool

Cisco Bug: CSCvs56923 - SQL client not able to query FMC using external database access

Last Modified

Jun 17, 2020

Products (35)

  • Cisco Firepower Management Center
  • Cisco Firepower Management Center 4600
  • Cisco FirePOWER Appliance 8120
  • Cisco FirePOWER Appliance 8260
  • Cisco Firepower Management Center 2500
  • Cisco FirePOWER Appliance 8360
  • Cisco FirePOWER Appliance 7050
  • Cisco FirePOWER Appliance 8130
  • Cisco AMP 8150
  • Cisco FirePOWER Appliance 8350
View all products in Bug Search Tool Login Required

Known Affected Releases

6.4.0 6.5.0 6.6.0

Description (partial)

Symptom:
SQL client (i.e. SQL workbench/J) can't query FMC database getting error "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1 [SQL State=42000, DB Errorcode=1064]"

Conditions:
FMC database external access enabled
Bug details contain sensitive information and therefore require a Cisco.com account to be viewed.

Bug Details Include

  • Full Description (including symptoms, conditions and workarounds)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.