Guest

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

2.6(0.906)

Description (partial)

Symptom:
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(UrlParser.java:208)
      at org.mariadb.jdbc.UrlParser.parse(UrlParser.java:154)
      at org.mariadb.jdbc.Driver.connect(Driver.java:95)
      at java.sql.DriverManager.getConnection(DriverManager.java:664)
      at java.sql.DriverManager.getConnection(DriverManager.java:208)
      at com.cisco.cpm.odbcidstore.impl.MySQLDbAccess.connect(MySQLDbAccess.java:63)
      at com.cisco.cpm.odbcidstore.impl.OdbcConnection.connect(OdbcConnection.java:76)
      at com.cisco.cpm.odbcidstore.impl.OdbcIdStore.performTest(OdbcIdStore.java:374)
      at com.cisco.cpm.odbcidstore.impl.OdbcIdStore.testConnectionAndConfiguration(OdbcIdStore.java:466)
      at com.cisco.cpm.odbcidstore.impl.OdbcIdStoreManager.testConnectionAndConfiguration(OdbcIdStoreManager.java:87)
      at com.cisco.cpm.admin.ac.actions.ODBCLPInputAction.testConnection(ODBCLPInputAction.java:753)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

Conditions:
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 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.