Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 

In Cisco Secure ACS, the LoggedAt column does not accept the date type during ODBC logging

Core issue

In this issue on Cisco Secure Access control Server (ACS), the LoggedAt column does not accept Date type, however, it does accept VARCHAR type.

On Cisco Secure ACS version 3.3, this issue is due to presence of Cisco bug ID CSCeh24726.

If ACS is at version 4.0.1.27 and later, then this issue is because of the Date type on the Open Database Connectivity (ODBC) database.

ACS sends Date in this format:

(DD/MM/YYYY HH:MM:SS)

On MySQL, by default, the date is in one of these formats:

  • (YYYY-MM-DD HH:MM:SS)
       
  • (YYYYMMDDHHMMSS)

Resolution

A possible workaround for this problem is to change the passedAuthentications and failedAttempts tables definition so that the LoggedAt field should be defined as VARCHAR instead of Date.

Note: This cannot be done on ACS. It must be done in the ODBC tables. Change the data type of the column of the tables in the database, from DATE to VARCHAR. It can be done when these tables are created or if you alter them.

1067
Views
0
Helpful
0
Comments