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.
For weeks now I have been running issues with some different user workstations working in the Home Office mode that use the Cisco VPN Version 4.2 client by throwing the message I have added to this forum, providing support for restarting a computer or pc,...
I have a setup with 2 FTD's- primary and secondary and 2 ISP's. When my primary ISP fails, while we still have internet access via the secondary ISP, I loose vpn access. Can you recommend a setup that if my primary ISP fails, vpn would still work and publ...
I my firewall (Firewpower) in the G0/0 I configured the interface 192.168.100.250/24, this is directly connected do my router 192.168.100.245/24 , from the Firewall I can ping my interface but I cant ping the ip from the router, I also tried this ...
Since upgrading to AnyConnect 4.10.05095 our Azure AD authentication for VPN has broken because the login fails the Conditional Access policy. We found that the Windows 10 clients no longer report device information as part of the SAML sign-in proces...