CAcert Code Development list.

[Mario Lipinski <mario AT cacert.org>]

Hi Dirk,

Am 07.05.10 16:42, schrieb dirk astrath:
> i don't think, that it is a good idea to copy the database out of the 
> security area to run sql-queries to it ...

I was talking about test systems to develop such a query before giving
the query to the critical team for information retrieval.
I don't know how there are security areas involved. There should be test
systems available for such tasks.

> we should think about a query telling us how many members are affected by 
> the revocation of thawte-points ...
> 
> something like
> 
> select userid,sum(points),sum(granted) from notary where userid != notaryid 
> ... ... ...

I was more thinking about sth like SELECT COUNT(1) AS 'Thawte users who
will lose assurer status with having thawte points removed' FROM users u
WHERE EXISTS (SELECT 1 FROM assurances WHERE usersid=u.id type LIKE
'thawte') AND NOT EXISTS (SELECT 1 FROM assurances WHERE usersid=u.id
AND type NOT LIKE 'thawte' AND SUM(points) < 100 GROUP BY usersid).

But I do not know the CAcert database so I need a db where I can test
this query against.

So just a statistical query without any reference to accounts involved.

-- 
Mit freundlichen Grüßen / Best regards

Mario Lipinski
Board member,                       E-Mail: 
mario AT cacert.org
Organisation Assurer (Germany),     Internet: http://www.cacert.org
Wiki/Issue admin
CAcert

Support CAcert: http://www.cacert.org/index.php?id=13
                http://wiki.cacert.org/wiki/HelpingCAcert