• Arbitrations
• a20150114.1

• Case Number: a20150114.1
• Status: running
• Claimant: Marcus M
• Respondent: CAcert

• initial Case Manager: MartinGummi

• Case Manager: UlrichSchroeter

• Arbitrator: MartinGummi

• Date of arbitration start: 2015-01-14
• Date of ruling: 201Y-MM-DD
• Case closed: 201Y-MM-DD
• Complaint: query to get data for Web of trust Graph

History Log

• 2015-01-14 (issue.c.o): case [s20150114.29]
• 2015-01-14 (iCM): added to wiki, request for CM / A

• 2015-01-14 (A): I take care about this case as A and UlrichSchroeter is CM

• 2015-01-14 (A): Init mailing to (C)

• 2015-09-08 (CM): add a20150114.3: Dispute against the Arbitrator and CM of a20150114.1 to related cases list

Private Part

• Link to Arbitration case a20150114.1 (Private Part), Access for (CM) + (A) only

EOT Private Part

original Dispute

• Dear arbitration,
  
  please check if the following sql query can be sent to critical to get 
  the anonymised data to create a Web of Trust graph with graphviz.
  
  SELECT CONVERT(sha1(`n`.`from` + '$salt'+ sha1(u1.uniqueID) ) USING 
  utf8) as `f1`, CONVERT(sha1(`n`.`to` + '$salt' + sha1(u2.uniqueID)) 
  USING utf8) as `t1`
       FROM`notary` as `n`
          INNER JOIN `users` as `u1` on `u1`.`id` = `n`.`from`
          INNER JOIN `users` as `u2` ON `u2`.`id` = `n`.`to`
       WHERE `n`.`deleted` = 0
       GROUP BY `f1`, `t1`
       ORDER BY `t1`
  
  The salt is create in this way in php:
  $int = 20;
  $blnstrong = true;
  $salt = bin2hex(openssl_random_pseudo_bytes($int, $blnstrong));

Discovery

Ruling

Execution

Similiar Cases

• CategoryArbitration

• CategoryArbCaseOthers

• CategoryArbCaseExternal