From: Dax Van Camp
Email: dax.van.camp@pioneeR.eu
Subject: please remove me from the database

Message:
I was lookign for a Cert solution but will not use your services.
Please remove my account information

Dax Van Camp

Before: Arbitrator MarioLipinski (A). Respondent: CAcert (R) Claimant: Dax Van Camp (C) Case: a20090703.2

History

Discovery

For discovery of the status of the account, the following SQL query was requested and executed:

SELECT id, fname, mname, lname, suffix, dob FROM `users` WHERE email = '<email>';
SELECT n.* FROM `users` u LEFT JOIN `notary` n ON n.`from`=u.`id` OR n.`to`=u.`id` WHERE u.`email` = '<email>';
SELECT d.`domain`, COUNT(dc.id) FROM `users` u LEFT JOIN `domains` d ON d.`memid`=u.`id` LEFT JOIN domaincerts dc ON dc.domid=d.id WHERE u.`email` = '<email>'  GROUP BY d.`id`;
SELECT COUNT(ec.id) FROM `users` u LEFT JOIN emailcerts ec ON ec.memid=u.id WHERE u.`email` = '<email>';

Ruling

The account was already deleted. After reviewing discovery, C binding to CCA is terminated.

a20091119.1

Account deletion

a20100108.1

Account deletion


Arbitrations/a20090703.2 (last edited 2011-11-21 22:31:31 by BernhardFröhlich)