* 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 ''[[Arbitrations/a20150114.3|a20150114.3]]: Dispute against the Arbitrator and CM of [[Arbitrations/a20150114.1|a20150114.1]]'' to related cases list

== Private Part ==

 * '''Link to Arbitration case [[Arbitrations/priv/a20150114.1|a20150114.1 (Private Part)]], Access for (CM) + (A) only'''

## ==> INCLUDE SECTION BOT
<<Include(Arbitrations/priv/a20150114.1)>>  
## <== INCLUDE SECTION EOT

==== 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 ==

|| [[Arbitrations/a20130530.1|a20130530.1]] || [[Arbitrations/a20130530.1|AdHoc SQL Query to get info about accounts with DOB in the future.]] ||
|| [[Arbitrations/a20130521.1|a20130521.1]] || [[Arbitrations/a20130521.1|Adhoc SQL query: Dispute to get some statisical data (U18)]] ||
|| [[Arbitrations/a20090424.1|a20090424.1]] || [[Arbitrations/a20090424.1|Ad hoc SQL query requested]] ||
|| [[Arbitrations/a20090427.2|a20090427.2]] || [[Arbitrations/a20090427.2|Ad hoc SQL query requested]] ||
|| [[Arbitrations/a20090518.2 |a20090518.2 ]] || [[Arbitrations/a20090518.2 |SQL: mail addresses of former assurers without the CATS passed]] ||
|| [[Arbitrations/a20090525.1|a20090525.1]] || [[Arbitrations/a20090525.1|Event officer request recurrent notification to assurers near the location of the following ATEs]] ||
|| [[Arbitrations/a20090810.3|a20090810.3]] || [[Arbitrations/a20090810.3|User requests a list of people who have more than 150 points]] ||
|| [[Arbitrations/a20090902.1|a20090902.1]] || [[Arbitrations/a20090902.1|request list of OA]] ||
|| [[Arbitrations/a20091221.1|a20091221.1]] || [[Arbitrations/a20091221.1|U18 query]] ||
|| [[Arbitrations/a20100822.1|a20100822.1]] || [[Arbitrations/a20100822.1|SQL query]] ||
|| [[Arbitrations/a20101114.1|a20101114.1]] || [[Arbitrations/a20101114.1|Addtl. adhoc interactive sql-query]] ||
|| [[Arbitrations/a20110413.1|a20110413.1]] || [[Arbitrations/a20110413.1|How many users using sample pwd]] ||
|| [[Arbitrations/a20110221.1|a20110221.1]] || [[Arbitrations/a20110221.1|PII and problematical sys settings on 1057 of 1074 deleted accounts cases still remains in database]] ||
|| [[Arbitrations/a20150114.3|a20150114.3]] || [[Arbitrations/a20150114.3|Dispute against the Arbitrator and CM of [[Arbitrations/a20150114.1|a20150114.1]] ||
|| [[Arbitrations/a20150114.3|a20150114.3]] || [[Arbitrations/a20150114.3|Dispute against the Arbitrator and CM of [[Arbitrations/a20150114.1|a20150114.1]] ||
|| [[Arbitrations/a20150116.1|a20150116.1]] || [[Arbitrations/a20150116.1|Appeal against [[Arbitrations/a20150114.1|a20150114.1]] ||



----
 . CategoryArbitration
 . CategoryArbCaseOthers
 . CategoryArbCaseExternal