. '''To Software [[Software|Software]]''' - '''To Software-Assessment [[Software/Assessment|Software/Assessment]]''' - '''To [[Software/Assessment/20130604-S-A-MiniTOP|previous meeting]]''' - '''To [[Software/Assessment/20130618-S-A-MiniTOP|next meeting]]''' ---- = Minutes of the MiniTOP on the 2013-06-11 = == Setting == The MiniTOP will be held via telco 22:00 CEST (20:00 UTC) Participants: Uli, Marcus, Michael, BenBE, Magu, Marek, Reinhard, Dirk == Topics == (skip to [[#AGENDA|agenda]]) Action items from last meeting '''[[Software/Assessment/ActionItems|Meeting Action Items]]''' <> <> == Agenda == ## last full agenda https://wiki.cacert.org/Software/Assessment/20120228-S-A-MiniTOP === 1. Preface === 1. request to NEO: reduce keysize, increase expiration time on CACERT1 (current state) * can be reset, current state? === 2. Documentations === 1. Documentation - Review / Changes to add (relates to Policy Group SP review) * [[https://wiki.cacert.org/Software/Assessment/Documentation/UpdateCycle|Description of Software Development Update Cycle]] * further review required 1. Documentation - To-Do (relates to Policy Group SP review) * developer git repos under github * [[https://github.com/BenBE/CAcert/commits/bug-1131|bug #1131 history @ github]] * [[https://github.com/CAcertOrg|CAcertOrg @ github]] * see also [[Software/Assessment/ActionItems]] * relates to [[Software/DevelopmentWorkflow]] * Details documentation started under: [[Software/Assessment/Documentation/UpdateCycle/step1]] === 3. DEV on bug 1023/1054 "Thawte Patch" === * "Thawte points removal, final step" [[https://bugs.cacert.org/view.php?id=1023|bug #1023]] * bug #1023 Testing (6.php) * last patch transfered to production system 2012-05-30 * what are the next steps for thawte points revoke? * points settings codes eg 50 pts open gpg/pgp, which certs avail by how many pts * 15.php needs rename to 10.php * next step in: [[https://bugs.cacert.org/view.php?id=1054|bug #1054]] Review the code regarding the new point calculation in ./includes/general.php (current state: testing) * email debug notification, search for other solution * testing scenarios: see [[https://bugs.cacert.org/view.php?id=1054#c3163|bug note c3163]] * some explanations * assure someone - f2f, ttp, the sentence "Only tick the next box if the Assurance was face to face" is conflicting, fixed * new patches by dirk, pushed to cacert-devel, (update 2012-09-18) * tverify removed (?) * merge conflict with account id 60 (eg email removal), see [[https://bugs.cacert.org/view.php?id=823|bug #823]] * max_points() routine replaced by new max_points() routine * get_assurer_status(), output_summary_content() with parameter 0 replaced by max_points() * received_points() * Status testing ? * debug messages on testserver (1054) * test account 1 * variant 1 (pwd login): points3 (185/100) * variant 2 (cert login): points3 (185/100)points4 (185/100) * first value relates to wot.php?id=10 count of pts * test account 2 * points3 (350/394)points4 (350/394) * 484 AP, anderer weg 64 * 100 * test account 3 * points3 (200/662) * problem identified, fix transfered to testserver * current state: runs in debug mode points1, points2, points3, points4 that reflects conditions * conditions points1 and points2 yet undefined * [[Software/Assessment/20121211-S-A-MiniTOP|meeting 2012-12-11]] * identified points1 + points2 debug points in routine * Logged-in, My Details, Edit, change something, submit changes * calculate points will be used to select edit mode for name, dob * if points==0 edit allowed, otherwise edit prevented * Patch moved out from testserver * new testserver branch stable * reason: more and more merge conflicts caused by bug #1054 * patches to add: 1070 + 782 (?) * 2013-02-05 DEV on bug 1023/1054 "Thawte Patch" - no update * 2013-02-12 - no update * 2013-02-19 - no update * 2013-02-26 - no update * 2013-03-05 - no update * 15.php needs update: all ttp points starting 2013-01-01 with new ttp-assurance method 1. 1054 plan B ? 1. analyze -> identify all places where points calculation is referenced a. assure someone a. receive assurance a. is assurer? assurer status a. revoked assurance a. create certs (new points calculation, 0 pts, 50 pts, 100 pts) a. multitasking aware (revoke assurance, assurer assures but have required pts revoked) a. lazy value (eg menu rendering) a. session validate? (if database related) 1. bug-1177 Combine wot.inc.php, notary.inc..php and temp-function.php === 4. requires transfer to production === === 5. 2nd review of remaining patches === ||<#ff8080> '''Software-Assessors task''' || ==== 5.1 Michael's/Dirk's Task 2nd review ==== * 1008 * 1 patch that needs 2nd review (Michael, dirk, or ....) || inopiae || [[https://bugs.cacert.org/view.php?id=1008|bug #1008]] View for SE to see if user is Organisation Admin for which Organisation Accounts || needs 2nd review || {0} || === 6. Patches Overview - Testing, Development === 1. needs further testing 1. 918 .. keysize * Middle security mostly relates to keysize 1024, High security to 2048 but this all relates to crypto provider * needs testing 1. summary - state of patches 1. 782 needs work 1. 440 needs work (NEO) (see also below) * Patch bug #440 was defered (timo addtl. work), but this project stalls. What to do with bug #440 ? || gagern, neo || [[https://bugs.cacert.org/view.php?id=440|bug #440]] Problem with subjectAltName || tested, needs 2nd review, rejected, new deployment getcn/getalt procedure, relates to [[https://bugs.cacert.org/view.php?id=1101|bug #1101]] || {r} 2 || 1. 1004 needs work by neo 1. 1113 needs work by benbe, transfered to cacert-devel 1. 1017 needs work by neo 1. 1025 needs testing 1. [[https://bugs.cacert.org/view.php?id=1023|Bugs #1023]] re-opened * [[https://bugs.cacert.org/view.php?id=1112|Bugs #1112]] Exchange the text on the TTP page according to the new TTP programm, deployed 2013-04-24 * needs update of patch 1023 (new points calculation routine) * [[https://bugs.cacert.org/view.php?id=1023|Bugs #1023]] re-opened 1. Policy text and Arbitration ruling bug# fixes 1. Policy text changes * new [[https://bugs.cacert.org/view.php?id=1131|bug #1131]] Replace all policies from php to html || Inopiae || [[https://bugs.cacert.org/view.php?id=1131|Bugs #1131]] Rename PolicyOnPolicy.php and other Policies too to .html || || {0} || * dirk to review * PoP update running under [[https://wiki.cacert.org/PolicyDecisions#p20130223|Policy Decisions #p20130223]] * proposal to await final decision dated 2013-03-08 * to wait until end of p20130223 -> 2013-03-08 * POLICY images to transfer from www.cacert.org/images to www.cacert.org/policy/images -> img src="images/.." * url link * current: 3 variations a. href="//www.cacert.org/policy/PolicyOnPolicy.html" vs. a. href="http://www.cacert.org/policy/PolicyOnPolicy.html" vs. a. href="PolicyOnPolicy.html" * proposal a. absolute url * a. or b. ? * // ... after download http missing * so therefor https * b. as https://.. * BenBE: needs patches 1146, 1147, 1131 * all 3 patches attached as complete archive under [[https://bugs.cacert.org/view.php?id=1131|bug #1131]] as zip * BenBE: wants them in git * git guru: take over this task * Fix available: [[https://bugs.cacert.org/view.php?id=1131|bug #1131]] * https://github.com/magujs/cacert-devel/tree/bug-1131/www/policy 1. Arbitration ruling text fixes 1. [[https://bugs.cacert.org/view.php?id=879|bug #879]] . CAcert must update the web page on disputes, and include an explanation how to file a dispute (a20091206.1) 1. [[https://bugs.cacert.org/view.php?id=1004|bug #1004]] Stats page improvement || neo, BenBe || [[https://bugs.cacert.org/view.php?id=1004|bug #1004]] Stats page improvement || tested by 2, needs 2nd review || {0} || * stats, Marcus + Uli did some tests, one problem identified, fixed 2012-08-25 by NEO * fully re-tested by 2: 2012-08-25 (at froscon) * needs 2nd review * moved out to cron job routine * -> BenBe, assigned * 1004 ... on review by BenBe * checked BenBe * work done by NEO, pushed to cacert-devel, transfered to testserver * needs 2nd review, tested * current state: * open issues a. How are deleted users handled? a. Isn't "verified_certs" misleading as the affected tables also contain certs that failed to be signed? a. User Statistics don't take removed assurances into account (???) a. Why not calculate backwards in the year-dependent loop from the already known values? The loop runs backwards already anyway. * the latter is still open 1. [[https://bugs.cacert.org/view.php?id=1025|bug #1025]] Domain Dispute issue * BenBe will pickup for 2nd review * needs further testing * magu, inopiae, u60 -> testing https://bugs.cacert.org/view.php?id=1025 * several test accounts, variations of one or more email addresses, 0 or 1 domain added * test the full disputes procedure for all variations * tested by u60 1. [[https://bugs.cacert.org/view.php?id=1054|bug #1054, test 1054.3.6]], [[https://bugs.cacert.org/view.php?id=1035|bug #1035]] * create several types of certs (client certs, server certs, org client certs, org server certs) and analyse the content of the certs -> subjectAltName and CN with single SAN and multiple SANs * renew the certs * addtl. tests ? Marcus? Magu? BenBe? * 2012-10-02 dirk: problems with git push #1054, got fixed * DEV on bug 1023/1054 "Thawte Patch" * check last changes by dirk to transfer into test scenarios * [[Software/CurrentTest/bug1054|Bug #1054 test scenarios]] * see reference notes [[https://bugs.cacert.org/view.php?id=1101#c3225|note 3225 on bug #1101]] and [[https://bugs.cacert.org/view.php?id=1101#c3245|note 3245 on bug #1101]] 1. [[https://bugs.cacert.org/view.php?id=1017|bug #1017]] {o} , relates also to [[https://bugs.cacert.org/view.php?id=1054|bug #1054, test 1054.3.6]] - Chrome certificate enrollement (relates to #964 "Black Jack") --([[https://bugs.cacert.org/view.php?id=964|bug #964]])-- * create client certs, go to signing routine * new routine with 3 different potential signed public key download routines /account.php?id=6 list 3 options a. Install the certificate into your browser (tested) a. Download the certificate in PEM format a. Download the certificate in DER format * [[https://bugs.cacert.org/view.php?id=1017|bug #1017]] Chrome certificate enrollement * BenBe will pickup * [[https://bugs.cacert.org/view.php?id=1017|bug #1017]], doing some more tests? * new routine with 3 different potential signed public key download routines /account.php?id=6 list 3 options a. Install the certificate into your browser (tested) a. Download the certificate in PEM format a. Download the certificate in DER format * Alex, Marcus doing some more tests * BenBE to review * review bug #964 by Michael * bug #964 transfered, still open: bug #1017 * [[https://bugs.cacert.org/view.php?id=1017|bug #1017]] Chrome certificate enrollement * needs testing (lost by transfer to testserver stable) * commited 2012-09-04 * new commited 2013-02-13 * 964 create cert works, install into browser doesn't work 1. Marcus Bugs list * see [[Software/BugsOverview]] * according to [[https://bugs.cacert.org/view.php?id=976|Bugs # 976]] * 0000976: List of update request for webdb database structure upgrade with tables / fields * addtl_notes table hasn't been added in [[https://bugs.cacert.org/view.php?id=976|patch bug 976 on 2011-11-25]] * OU info from Org cert not stored * addtl_notes table hasn't been added in [[https://bugs.cacert.org/view.php?id=976|patch bug 976 on 2011-11-25]] * extend org certs table ? new bug? * OU in subject? * includes/account.php (17) * in org certs it is in subject * addtl. field ou ? new bug# ? * used bug #1010 1. new [[https://bugs.cacert.org/view.php?id=1095|bug #1095]] "Problems with creating server sertificate where the csr is created with Java SDK Tools" * cmdline sample: keytool -genkey -alias test.test.net -keyalg RSA -keystore test.test.net.ks -validity 1095 * NEO couldn't reproduce the problem using keytool, tested against production and testserver * identified as weak key usage: csr used MD2 encryption, not or no longer supported by openssl, add new error message 1. [[https://bugs.cacert.org/view.php?id=440|bug #440]], [[https://bugs.cacert.org/view.php?id=1101|bug #1101]] (extract CSR) (back under development) * ASN.1 format * CSR extract: needed for signing: email address, hostname * Timo will write a CSR parser * Current: * CN will be parsed * some information about public key * ASN.1 php library * Whats about UTF-8 ? * IDN's * Policy: [[PolicyDecisions#p20091108|p20091108]] CPS to drop assurer critieria and allow IDN certificates in specified TLD or single script character sets * [[FAQ/Privileges|FAQ Privileges]] * [[http://www.cacert.org/policy/CertificationPracticeStatement.php#p3.1|CPS 3.1.7]] * [[AssuranceHandbook2/SomeMoreInformation|Assurance Handbook - Some more Information]] {{{ Code signing and IDN certificates If you are an Assurer, you can get certificates signed/issued by CAcert for code signing and IDNs (International Domain Names). Due to the increased possibilities for abuse those certificates have additional requirements. The CPS states that this requires Assurer level, which you meet if you are reading this Handbook. However note that as of 20091106, there is a move to reduce these requirements. Watch this space. }}} * current only client and server certs, other options currently not selectable, except Code Signing * extensions currently not supported eg jabber * [[https://bugs.cacert.org/view.php?id=530|bug #530]] XMPP extension not present after renewal * [[https://bugs.cacert.org/view.php?id=87|bug #87]] Issuing certificates for Jabber servers/users * parameters: domains, current first becomes CN, others SANs * rebuild subject routine ... to check * Michael: shall we enforce cn from csr? * optional? * enforce copy cn to SAN * asn1 parse procedure, http://lapo.it/asn1js/ * getcn, getalt procedure * docs für extractit() und getcn(): [[https://github.com/timoahummel/CAcert/blob/bug-1101/includes/general.php#L230|general.php line.230]] * felicitus: how someone get "CN" from "commonName"? where is it documented that "CN" is "commonName"? * OID of commonName is 2.5.4.3, but there is nothing about "CN" * BenBE: see Header of OpenSSL-Header * Patch bug #440 was defered (timo's addtl. work), but this project stalls. What to do with bug #440 ? || gagern, neo || [[https://bugs.cacert.org/view.php?id=440|bug #440]] Problem with subjectAltName || tested, needs 2nd review, rejected, new deployment getcn/getalt procedure, relates to [[https://bugs.cacert.org/view.php?id=1101|bug #1101]] || {r} 2 || * comments [[https://bugs.cacert.org/view.php?id=440#c3243]], [[https://bugs.cacert.org/view.php?id=440#c3251]] checked? * Neo started some fixes (getcn and ...), to be continued * ASN.1 parser - planned: incorporate asn.1 from openssl 1. [[https://bugs.cacert.org/view.php?id=1101|bug #1101]] refactoring getalt getcn (Timo) * might [[http://bugs.cacert.org/view.php?id=1101#c3225|1101 comment c3225]] * tries to build a php library for openssl parsing replacement a. asn.1 parsing, own library a. ??? * openssl does escaping (per man page) (input? output?) * library test thru unit tests * openssl command for multiple san's ? * undocumented feature? * currently only known with -extfile [[http://therowes.net/~greg/2008/01/08/creating-a-certificate-with-multiple-hostnames/#comment-595|creating-a-certificate-with-multiple-hostnames]] 1. New patches 1. [[https://bugs.cacert.org/view.php?id=782|bug #782]] Add "notes" field to certificate information || inopiae || [[https://bugs.cacert.org/view.php?id=782|bug #782]] Add "notes" field to certificate information || || {0} || * moved to testserver * Client certs * Current: . Renew/Revoke/Delete | Status | Email Address | SerialNumber | Comment | Revoked | Expires | Login * move comment to end . Renew/Revoke/Delete | Status | Email Address | SerialNumber | Revoked | Expires | Login | Comment | edit * create new cert below all mandatory fields? * [[https://bugs.cacert.org/view.php?id=782|bug #782]] - Review by Benny * Field name mismatch between submitted field and value queried for store operation * Not deployed on testserver * fixed missing underscore * 2013-05-07: Review OK * 2013-05-14: review by benbe * reject * update by inopiae 1. GPG bugs 1. import prob (eg [[https://bugs.cacert.org/view.php?id=992|bug #992]] ) * rfc standards: a. rfc 4880, defaults to utf-8, section 5.11 * https://tools.ietf.org/html/rfc4880 * RFC 4880 updated by https://tools.ietf.org/html/rfc5581 a. email rfc-2822 1. delete/revoke GPG keys (eg [[https://bugs.cacert.org/view.php?id=1079|bug #1079]] ) * trust signatures can be revoked * CRL's have to be added to keyservers, but no one will check * revocation: 5 reasons given * should be possible, but project needs a developer 1. GPG bugs * OpenGPG parser project, reviewed by Michael last weekend * Michael remark: using 3x = (===) instead of 2x = (==) * unpack (N) 32bit unsigned may become a problem * relates to hardware platforms, signer has been replaced about 2 years ago, but needs to be used on both sides (webserver + signer). Webserver upgrade is WIP * in principle ok 1. BenBE: GPG/PGP parser * revoke gpg keys implemented * [[https://xkcd.com/1181/|1181]] 1. [[https://bugs.cacert.org/view.php?id=279|bug #279]] bad domains * .*top.* * regexp list * database table exist * update procedure? * whats about recuring distribution of update files via cabforum? * arbitration? * SE console for update? * critical admins? * check routine on add-domain * add domain under OA should be possible ... * one-time check of current existing domains ? 1. first time check against full filter list 1. individual check in event add domain 1. global check in event add entry to filter list 1. replace/update full filter list (case 1 + 4) * meta infos: a. datasources a. attributes (?) a. creation date a. delete entry / revocation date 1. [[https://bugs.cacert.org/view.php?id=1135|bug #1135]] SE activity audit tables * addtl. recording of arbitration numbers to members * results in long discussions * requirements, thought cases (eg name change request while another arbitration is running (-> uncritical)) * delete account requests handled under precedent case [[Arbitrations/a20111128.3|a20111128.3]]), one "critical" case (certs misusage) is turned in procedure: arbitrator has to follow "emergency case" procedure and to keep track of open "delete account" cases * interferance/interaction of 2 of the 3 powers (executive, judicate) (arbitration has to act as executive to forward all new cases to support team with list of open/running arbitration cases) * all ends on (arbitration) "critical" cases * "critical" cases will be handled under Arbitration eg. [[Arbitrations/a20111128.3|a20111128.3]] within reasonable (eg 48 hours) window * discussion defered * 1135 (BenBe) 2nd review by another SA before moving to testserver * Michael to review 1. [[https://bugs.cacert.org/view.php?id=1135|bug #1135]] Extend database table AdminLog et al 1. [[https://bugs.cacert.org/view.php?id=1136|bug #1136]] SE console, delete all certs of a member (instead of highjack an account) * probably 1 requirement: addtl. verification step * 2013-02-26: * bug #1136 - revoke certs doesn't work * server log shows no errors * and the fix: cacert-devel: testserver-stable 90bdd8cb Timestamp: 2013-02-26 23:32:07 * added to testers portal, needs testing, 2nd review * doesn't work as expected, needs work * bug-1136 ready to test. Error fixed * tested by magu 1. [[https://bugs.cacert.org/view.php?id=893|bug #893]] Extend Delete account feature for support || inopiae || [[https://bugs.cacert.org/view.php?id=893|bug #893]] Delete account rev 3 procedure || needs testing and 2nd review || {0} || * test 893 (delete account) with existing server certs, also gpg certs * gpg revocation is currently not avail ... * manual procedure: currently we hadn't such a case in manualy procedure * proposal: in production: set on hold until gpg key expires * for testing: gpg keys not expired -> stop procedure if remaining gpg keys not expired * if account is locked -> no special exception * org admin flag set -> procedure stop (includes Org certs avail) * related dispute bugs 1136? 1045? * from meeting 2013-04-30 * requires regexp to check validity: /^[a-z]\d{8}\.\d+\.\d+$/i * several tests and updates made 1. [[https://bugs.cacert.org/view.php?id=1137|bug #1137]] Record the CCA acception for entering an assurance || inopiae || [[https://bugs.cacert.org/view.php?id=1137|bug #1137]] Record the CCA acception for entering an assurance || needs testing and 2nd review || {0} || * 1137 "Record the CCA acception for entering an assurance" needs review testing * bug-1137 ready to test. Error fixed 1. [[https://bugs.cacert.org/view.php?id=1141|bug #1141]] If i delete Domains, no Servercerts for this domains are listet, even not the revoked * moved to testserver || NEO || [[https://bugs.cacert.org/view.php?id=1141|bug #1141]] If i delete Domains, no Servercerts for this domains are listet, even not the revoked || needs testing || {0} || * discusssions: arb case? privacy (eg PP 10.), data retention (-> Australien DPA) * Marcus to contact Benedikt 1. [[https://bugs.cacert.org/view.php?id=1008|bug #1008]] View for SE to see if user is Organisation Admin for which Organisation Accounts 1. what to do with [[https://bugs.cacert.org/view.php?id=1143|bug #1143]] Web site doesn't scale vertically 1. Advertisement * permission review script doesn't include ADadmin * relates to [[https://bugs.cacert.org/view.php?id=1003|bug #1003]] and Arbitration case [[Arbitrations/a20110118.1|a20110118.1]] * board motion? treasurer? adadmin? * Answers given by Intermediate ruling #7 under [[Arbitrations/a20110118.1|a20110118.1]] * Michael to pickup 1. [[https://bugs.cacert.org/view.php?id=901|bug #901]] Renewal of certificate with WIN 7 and IE8 1. Marcus: [[https://bugs.cacert.org/view.php?id=1160|bug #1160]] "Unable to import personal cert/key into Tunderbird or Evolution, hence unable to encrypt mail with CACert certificates" - needs feedback * does this have to do with the last patch install ? * Since install of patch [[https://bugs.cacert.org/view.php?id=964|bug #964]] (Black Jack) automatic client cert installation and renew into FF doesn't work (install to IE5 button doesn't work) * signed public client cert will be presented in ascii for copy and paste into a file, but this cert doesn't include the private key part, so the signed public key has to be marriaged with the private key * see also FAQ client certs [[https://wiki.cacert.org/Technology/KnowledgeBase/ClientCerts#Renew_Client_Certs_under_FF|Renew Client Certs under FF]] * patch [[https://bugs.cacert.org/view.php?id=1017|bug #1017]] includes an automatic install into Mozilla keystore, current code on production doesn't 1. Marcus: server.pl - [[https://bugs.cacert.org/view.php?id=1159|bug #1159]] - it might be possible to execute commands on the signing server * answered by Wytze * NEO tries a patch * server.pl issue .. review by Ben finished, ready to deploy [[https://bugs.cacert.org/view.php?id=1159|bug #1159]] 1. [[http://bugs.cacert.org/view.php?id=1172|bug #1172]] MySQL -> transactional, move isam to innodb * Switch MySQL to MariaDB ? 1. [[https://bugs.cacert.org/view.php?id=1094|bug #1094]] Wrong information shown when disputing a domain that is part of a organisation account - Review by Michael * Review by Michael + Test by Magu 1094 - OK. 1. [[https://bugs.cacert.org/view.php?id=28|bug #28]] Wrong language for ''you've been assured'' & ''[CAcert.org] Client Certificate'' emails - Review by Michael * Review 28 by Michael doesn't work. * Additional work required: Doc Comments in include/lib/l10n.php * Repaired by Benny for bug 28 * Ported patch by Marcus * Fixed parameter name and class refs in include/lib/l10n.php 1. [[https://bugs.cacert.org/view.php?id=872|bug #872]] Discuss over Software changes for PoJAM Policy 1. (BenBE) * UI with checkbox for PoJAM seen * for old cases take "not seen" as default * do mass-mailing for all PoJAM related to ask assurers to confirm they saw the Parental Consent form * ignore points from assurances under PoJAM (even after 18th birthday) when calculating permissions if no confirmation is present 1. Marcus * check only one case of PoJAM acceptions per user * once one is present count all assurances as valid 1. Michael * 2 or more Checked PoJAM Assurances for CAcert High Products 1. SQL query to critical: * Users below 18th birthday grouped by date -> counts of assurance points * From arb [[Arbitrations/a20091221.1 | a20091221.1]] 1. Uli (AO) * PoJAM assurance points received handling according to [[PolicyDrafts/LegacyPolicy#PoJAM|Legacy Policy - PoJAM]] 1. bug 872 for statiscs for PoJAM * file a dispute - SQLquery {{{#!highlight mysql SELECT count( `temp`.`no` ) as AffectedUsers, sum( `temp`.`assurances` ) as AffectedAssurances, if(points = 0, "No points", IF(points < 50, "1 < x < 50", IF(points < 100, "50 <= x < 100", "100 <= x"))) as ReceivedPoints FROM ( SELECT 1 AS no, count( 1 ) AS assurances, sum( `notary`.`points` ) AS points FROM `users`, `notary` WHERE YEAR(`users`.`dob`)>=1995 and `users`.`id`=`notary`.`to` GROUP BY `users`.`id` ) AS `temp` group by ReceivedPoints }}} 1. [[https://bugs.cacert.org/view.php?id=1140|bug #1140]] needs testing || Ted || [[https://bugs.cacert.org/view.php?id=1140|bug #1140]] Show if a test is passed in learnprogress || tested by 3, requires review || {0} || 1. [[https://bugs.cacert.org/view.php?id=500|bug #500]] needs testing || Ted || [[https://bugs.cacert.org/view.php?id=500|bug #500]] Get contact mail adress after resolving test || requires testing || tested by 3, requires review || {0} || 1. [[https://bugs.cacert.org/view.php?id=1139|bug #1139]] moved to ready to deploy || inopiae || [[https://bugs.cacert.org/view.php?id=1139|bug #1139]] Add new fields to the database || tests through #500 and #1140, 2nd review done, requires transfer || {0} || 1. [[https://bugs.cacert.org/view.php?id=999|bug #999]] When revoking an assurance in the SE console the messagebox is unclear * tested by werner, inopiae, magu * reviewed by dirk 2013-06-04, ready to deploy || neo || [[https://bugs.cacert.org/view.php?id=999|bug #999]] When revoking an assurance in the SE console the messagebox is unclear || tested by 3, 2nd review done, requires transfer || {0} || 1. [[https://bugs.cacert.org/view.php?id=1134|bug #1134]] Delete the board flag thourougly in all parts of our software || inopiae || [[https://bugs.cacert.org/view.php?id=1134|bug #1134]] Delete the board flag thourougly in all parts of our software || 2nd review done, requires testing || {0} || === 7. Long Term Projects === 1. NEO: "BlackJack" [[https://bugs.cacert.org/view.php?id=964|bug #964]] * NEO: "BlackJack" [[https://bugs.cacert.org/view.php?id=964|bug #964]] testing from last week -> error codes * started implementing * how does [[https://bugs.cacert.org/view.php?id=1017|bug #1017]] relate to this bug? * cert signing routine * ie5 ie6 automatic storage of signed key in local keystore * doesn't work under vista, win7 * msi package is to download and import the keys to the local keystore under vista, win7 * relates to [[https://bugs.cacert.org/view.php?id=1099|bug #1099]] but is quite different * neo sent msi package for testing to u60, benbe; test successful passed * bug #964 passed, #1017 still open * bug 964, has been passed to production, key generation works, transfer into browser not * BenBE: reviewed [[https://bugs.cacert.org/view.php?id=1099|bug #1099]] roots installer * [[https://cacert1.it-sls.de/index.php?id=3|Root Certificates]] * displays: "Windows installer package for browsers that use the Windows certificate store (for example Internet Explorer, Chrome on Windows and Safari on Windows)" * some ideas to move the installer to own section * Michael: reworks [[https://bugs.cacert.org/view.php?id=1099|bug #1099]] (roots download page), deployed 1. Marek's sql class project: * is working on charset replacement 1. api project, Carsten continues with portal project not waiting for vendor-api to be delivered * vendor-api delayed * no coders * other projects * related to sql class project * portal project continues with a workaround, needs an assurer * arbitration case on locations database orders outsourcing of find-an-assurer asap * with portal function, update of data is possible vs. update of data on critical system is difficult (keep data current for assurers) * relation to location database 1. website find an assurer 1. scripted mailing for ATE invitations * user check that data is still valid eg every 1 year * notification at login upto 6 months not online * notification by email if not logged in within last 6 months 1. Automated testing system * Timo: Unit-test testsystem, phpunit jenkins * [[http://ci.partkeepr.org/job/PartKeepr/]] * [[https://github.com/NEOatNHNG/cacert-frontendtests]] * can we merge both environments? frontend tests and unit tests? * Timo: automated testing systems are mergable * frontend test: java, may become a problem, alternate php version? * focus on unittests * dirk: code or screen? * code and screen * frontend and unit tests on one machine? * trial: port frontend tests 1. Timo: monitoring signer, not yet done * Probably Wytze monitors the systems externaly ?!? * see [[SystemAdministration/Systems|Systems overview]] * monitoring system eg Zabbix instead of Nagios? * BenBE: Icinga as alternate? * Zabbix agents: requires to be the same revision as server 1. TLS project * BenBe/Wytze talked @ fosdem * risks fairly low, awaiting fix 1. secure boot project (required steps?) (also relates to New Roots & Escrow) * we have * risk analyze * new roots procedure * required steps? * Escrow method to select * subroot under eg. org++ * cps changes * new roots? * new signer? * indirect crl's === 8. next meeting === * Tuesday, June 18, 2013 - 22:00 CEST (20 UTC) ? == Minutes == 1. patches * [[https://bugs.cacert.org/view.php?id=1137|bug #1137]], [[https://bugs.cacert.org/view.php?id=1162|bug #1162]] pushed to test server by BenBE * [[https://bugs.cacert.org/view.php?id=1172|bug #1172]], [[https://bugs.cacert.org/view.php?id=1135|bug #1135]] database updates * [[https://bugs.cacert.org/view.php?id=782|bug #782]] Comment fields for certificates * merge conflicts, repairing branches 1. short notes to secure-u meeting 1. request to NEO: reduce keysize, increase expiration time on CACERT1 (current state) can be reset, current state? * reset at 2013-06-04 been done 1. debian upgrade || NEO, BenBE || Debian upgrade of ca-mgr1, git-cacert (low prio) || {g} || * current state: * ca-mgr1 debian 6.0 * git-cacert debian 6.0 1. patches (cont.) * [[https://bugs.cacert.org/view.php?id=1173|Bug #1173]] on testserver * testscenario: {{{ try to dispute these emails and domains: test.de, 1test.de, test.block.1173@acme.com, test.lock.1172@acme.com The result should be: Message cannot be disputed for administrative reasons, contact support@c.o }}} * [[https://bugs.cacert.org/view.php?id=1064|Bug #1064]] and [[https://bugs.cacert.org/view.php?id=1045|Bug #1045]] results in merge conflict in www/wot.php - postponed, Various patches * merge conflicts, in www/wot.php 1. recuring error log review || NEO, BenBE || todo: monitor /home/cacert/var/log/apache2/error.log for php errors (recuring) || {0} || * [[https://bugs.cacert.org/view.php?id=1176|Bug #1176]] * BenBE prepared some fixes, but did not move them to testserver yet * https://github.com/BenBE/CAcert/commit/d3a8052057648d67b07350e9e6bb6b39276f75dc * https://github.com/BenBE/CAcert/commit/39e99197b2e6423339570154c218abd45de31997 * BenBE wonders why the software worked in the first place ... 1. In the pipeline ... * Updated bug 569 had been pushed to testserver already 1. reviews by dirk * [[https://bugs.cacert.org/view.php?id=1134|Bug #1134]] - done in prev week * [[https://bugs.cacert.org/view.php?id=1008|Bug #1008]] View for SE to see if user is Organisation Admin for which Organisation Accounts 1. reminder for NEO * [[https://bugs.cacert.org/view.php?id=1003|Bug #1003]] permissions review script * next run: 2013-06-30 * patch transfered to testserver, initiated schedule, mails sent 1. testing [[https://bugs.cacert.org/view.php?id=1008|Bug #1008]] View for SE to see if user is Organisation Admin for which Organisation Accounts * tested by 2, ready to deploy 1. [[https://bugs.cacert.org/view.php?id=1172|bug #1172]] Move the database engine from myISAM to InnoDB - and other plans for DB migrations * also long term project: "sql class project" * ongoing discussions about using stored procedures or not * voted: result: 1 aye, 4 naye, 1 abstain ==== Fixed Action Items since last or within meeting ==== || neo || [[https://bugs.cacert.org/view.php?id=922|bug #922]] CAcert application code problem causing missing "certificate about to expire" messages || problems in testing: untestable, 104 notifications for 1 client + 1 server cert is questionable /!\ <
>flooded with notifications<
>problem identified fixed<
>tested by 2, needs 2nd review, good to go<
>merge conflicts, needs work<
>updated<
>full re-test<
>good to go<
>deployed || {g} || || NEO || req: keysize limit to decrease temporarely for test purposes, same for time to expire certs<
>Testserver setting updated<
>new settings valid for period: Tue 2013-04-23 to Tue 2013-04-30 || effective reset at meeting 2013-06-04 || {g} || || NEO, BenBE || Renew of cert for secure1 || done around 2013-05-29 || {g} || || NEO, BenBE || Debian upgrade of ca-mgr1, git-cacert (low prio) || current state: both v6.0 || {g} || ==== Action Items New ==== Action items: '''[[Software/Assessment/ActionItems|Meeting Action Items]]''' ---- . CategorySoftwareAssessment