Clearing single record from RA cache file

  1. Download SQLite tools for windows. On a page https://www.sqlite.org/download.html it is tools: https://www.sqlite.org/2024/sqlite-tools-win-x64-… Unzip content to c:\temp\

  2. Start cmd.exe as administrator, change directory to c:\temp

  3. Stop IIS by command
    IISRESET /STOP

  4. Open C:\Program Files\VeridiumID\RAEPServer\RaWebApp\Web.config and find line with CacheFile. Default is:

  5. <add key="CacheFile" value="c:\windows\temp\RA.sqlite" />

  6. Type 
    sqlite3 c:\windows\temp\RA.sqlite

  7. Type check entries for user you like to delete cached certificate: 
    select * from certcache where upn = 'user principal name';

  8. if records matching your exectations, you can delete rows based on upn:

  9. delete from certcache where upn = 'user principal name';

  10. start IIS again by command:

  11. IISRESET /START

Last updated: