Zertifikat in Firefox löschen

# common name of certificate to delete
$commonname = 'user@domain.de'  
# ================================
# sqlite dlls laden
# download hier www.nuget.org/packages/System.Data.SQLite.x64
Add-Type -Path "$psscriptroot\System.Data.SQLite.dll"  
# download hier www.nuget.org/api/v2/package/SQLite.Interop.dll
Add-Type -Path "$psscriptroot\SQLite.Interop.dll"  

# stop on errors
$ErrorActionPreference = 'Stop'  
# get each certificate db from all profiles of the current user
$certdbs = Get-ChildItem "$env:APPDATA\Mozilla\Firefox\profiles\*\cert9.db" -file -EA SilentlyContinue  
if (!$certdbs){
    write-host "No Firefox certificate databases found!" -F Yellow  
    return
}
foreach($db in $certdbs){
    write-host "Opening certificate database '$($db.Fullname)'" -F Green  
    $conn = $null;$cmd = $null
    try{
        # create connection to database file
        $conn = New-Object System.Data.SQLite.SQLiteConnection "Data Source=$($db.Fullname);Version=3"  
        # open connection
        $conn.Open()
        write-host "Removing Certificate with common name '$commonname' from database file $($db.Fullname) ..." -F Green  
        # sql command to remove certificate
        $cmd = New-Object System.Data.SQLite.SQLiteCommand "DELETE FROM nssPublic WHERE a101 LIKE '%$commonname%'",$conn  
        [void]$cmd.ExecuteNonQuery()
    }catch{
        write-host "Error: $($_.Exception.Message)" -F Red  
    }finally{
        if($cmd){$cmd.Dispose()}        
        if ($conn){$conn.Close();$conn.Dispose()}
    }
}