I have recently detected that I might have personal data within some page url's and I need to delete them from the archived blobs.

Is there any solution for this already?

Thes URL's was removed from the site but we waited too long too long to remove them 🤦🏻‍♂️.

• Matomo Version: >=4.7.1-stable,<5.0.0-b1"
• PHP Version: >=8.0
• Server Operating System: Linux/Alpine
• Additionally installed plugins: PrivacyManager

As far as I know, the GDPR tool only works when I still have raw data.

I noticed that the blobs in the archive tables are serialized with PHP functions and Mysql works a bit differently. So I'm suspecting that it needs to be done in PHP to be able to unserialize and then serialized back again.

Any advice would be appreciated.

This is what I got so far(work in progress):

    public function checkForPiiInBlob()
    {
        Piwik::checkUserHasSuperUserAccess();
        $dataRows = $this->db->getBlob();
        echo "<pre>";
        foreach ($dataRows as $row) {
            $needle = "?IDENTIFIER=";
            $chunks = gzuncompress($row['value']);
            if (strpos($chunks,$needle)){
                $unserialized_multi = Common::safe_unserialize($chunks);
                foreach ($unserialized_multi as $serialized) {
                    if (strpos($serialized, $needle)){
                        $chunk = Common::safe_unserialize($serialized);
                        print_r($chunk);
                        echo "\n";
                    }
                }
            }
        }
        echo "</pre>";
    }

Obviously I'm running this locally only to practice and learning about the archiving semantics.

Best regards, Jorge