Skip to Content.
Sympa Menu

cacert-sysadm - Re: Arbitration case a20090427.2 - "Ad hoc SQL query requested (locations database export)"

cacert-sysadm AT lists.cacert.org

Subject: CAcert System Admins discussion list

List archive

Re: Arbitration case a20090427.2 - "Ad hoc SQL query requested (locations database export)"


Chronological Thread 
  • From: Wytze van der Raay <wytze AT cacert.org>
  • To: ulrich AT cacert.org
  • Cc: gstark AT cacert.org, 'Philipp Gühring' <philipp AT cacert.org>, 'Markus Warg' <markus AT cacert.org>, 'dirk astrath' <dirk.astrath AT cacert.org>, 'Ian G' <iang AT cacert.org>, p.dunkel AT cacert.org, 'Andrea s Bäß' <andreas.baess AT cacert.org>, 'Michael Tänzer' <michael.taenzer AT cacert.org>, mario AT cacert.org, cacert-board AT lists.cacert.org, cacert-devel AT lists.cacert.org, cacert-sysadm AT lists.cacert.org, aphexer AT cacert.org
  • Subject: Re: Arbitration case a20090427.2 - "Ad hoc SQL query requested (locations database export)"
  • Date: Thu, 29 Jul 2010 14:53:38 +0200
  • Authentication-results: lists.cacert.org; dkim=pass (1024-bit key) header.i= AT cacert.org; dkim-asp=none
  • Organization: CAcert

Hi Ulrich,

On 07/29/2010 04:31 AM, 
ulrich AT cacert.org
 wrote:
> Regarding Arbitration case a20090427.2
> https://wiki.cacert.org/Arbitrations/a20090427.2

> ...
> There is a limitation set over the locations database set
>              "for CAcert usage only"

Not speaking as critical admin but as CAcert user and open source
advocate here: this statement about "limitation" seems at odds with
CAcert's general policies, so it would really be nice if this claim
is substantiated with clear facts - a license, sources of non-public
information, amount of it, etc. ...


> ...
> Recomendation:
> 
> To move the authority over the locations database set
> to the Software-Assessment team and turn the distribution
> order from live system to the outside to
> Software-Assessors to live system

Strong support from 
critical-admin AT cacert.org
 for this -- this data
is not critical and should not be managed by critical sysadmins.


> ...
> An initial complete export from the critical system to the
> Software-Assessment team is allowed to receive the current state of
> the locations database set. Critical team and Software-Assessment team
> have to deploy a transfer concept for the initial transfer.

The initial complete export can simply be dealt with by a mysqldump of
the countries, regions and location tables, which will be scp'ed to a
Software-Assessment designated location.

In return we'd expect updates to the live data to be supplied to us
by signed e-mail from the Software-Assesment team with mysql update
scripts for the above mentioned tables.

Regards,
-- wytze

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature




Archive powered by MHonArc 2.6.16.

Top of Page