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 126.96.36.199 and later, then this issue is because of the Date type on the Open Database Connectivity (ODBC) database.
ACS sends Date in this format:
On MySQL, by default, the date is in one of these formats:
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.
Dear All, Could you please let me know. What is the recommended combination of implementation authentication when PCs connected IP Phones? What is the logic behind using one as compare to the other? or drawbacks using one. As per my recom...
Hey All,I'm running an ASA 5550 out of my home network and, overall, things are pretty good. It acts as my gateway (ISP Gateway is in full passthrough mode, all frames get sent to the ASA), and does it's job well.I recently installed a 5508 WLC with 2206 ...
I've noticed that the latest suggested release of Firepower services (188.8.131.52) is only compatible with the larger 5508 and 5516-x firewalls. I have an environment with 2 5516-x, 2 5508-x and about 15 5506-x firewalls.I can't find a recommended "road...
Hi all,we have a cluster with 2 machines . Each of them have an own outgoing if . My Question is - is it possible to sent out specific mails to Domains e.g. all to @cisco.com via the secondary machine outgoing interface?I could not find that as i am...