CAcert Code Development list.

[Wytze van der Raay <wytze AT cacert.org>]

Hi Benny,

On 09/24/2014 09:00 AM, Benny Baumann wrote:
> there finally is a reviewed version of the CCA policy mailing script, to
> be sent out to our users ASAP. The script was reviewed by Dirk Astrath
> and me and is based on the script used in the Heartbleed mailing; except
> for the following changes:
> * No German or other non-English text version
> * Incorporated the speed-up to use 5 Mails per Second
> * Adopted a unique file name for the restart information
> * Some minor clean up in the script
> 
> Execution of the script has been agreed to by Eva.
> 
> The script can be found in the latest version of the release branch as
> scripts/send_policy_cca_20140916.php or attached to this mail.
> 
> Please report any issues with the execution of the script back to
> Software and the Policy Officer.

The script has been added to the CVS, and is currently running.
However, I need to point out that there is a bug in the script which
obscures its logging somewhat and essentially defeats the restart
mechanism based on the 'lastid' file:

> ID now: 0
> PHP Notice:  Undefined index: id in 
> /home/cacert/www/scripts/send_policy_cca_20140916.php on line 128
> PHP Notice:  Undefined index: id in 
> /home/cacert/www/scripts/send_policy_cca_20140916.php on line 132
> Sent 1th mail. User ID:
> PHP Notice:  Undefined index: id in 
> /home/cacert/www/scripts/send_policy_cca_20140916.php on line 128
> PHP Notice:  Undefined index: id in 
> /home/cacert/www/scripts/send_policy_cca_20140916.php on line 132

etc etc

This appears to be caused by the fact that the "id" variable is not set
by the SQL select statement at line 111 in the script; it is only used
for ordering.

Since the script is running already, and is pushing out the e-mails as
desired, there is no urgent need for a fix. But it would be wise to
push a bug fix some time sooner or later, so the archives will contain
a properly working version of the script, for possible future cases.

Regards,
-- wytze

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