Preview Tool

Cisco Bug: CSCvv07049 - ISE unable to connect with ODBC "Connection failed" with a port number

Last Modified

Oct 23, 2020

Products (1)

  • Cisco Identity Services Engine

Known Affected Releases


Description (partial)

trying to make a connection between ISE and an ODBC Identity Source (MySQL). we always get a "Connection failed" error.

Error message:
"Connection Failed"
Stored procedures could not be checked as connection with DB failed.

debugs as below:

WARN   [admin-http-pool37][] cisco.cpm.odbcidstore.impl.MySQLDbAccess -:eerdekens.s::- Connection to ODBC DB failed. Exception: java.sql.SQLException: For input string: "3336annr"
java.sql.SQLException: For input string: "3336annr"
      at org.mariadb.jdbc.UrlParser.parseInternal(
      at org.mariadb.jdbc.UrlParser.parse(
      at org.mariadb.jdbc.Driver.connect(
      at java.sql.DriverManager.getConnection(
      at java.sql.DriverManager.getConnection(
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

ISE 2.6 patch 6
a port number is configured in the ODBC ID source
ISE is not constructing the jdbc connection string properly, The databaseURL is missing a ‘/‘ (forward slash) between the TCP port number and the database name
Bug details contain sensitive information and therefore require a 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.