Commit Graph

153 Commits (fix-email-address-maintenance-bug-1543)

Author SHA1 Message Date
Jan Dittberner 6ddce57ded Merge branch 'main' into fix-email-address-maintenance-bug-1543 10 months ago
Jan Dittberner 10540621a8 Add migration script for missing users DEFAULTs
This commit adds a migration script to add missing DEFAULT values on the
users table. INSERTs into the users table fail without these DEFAULTs on
MariaDB in strict mode.
10 months ago
Jan Dittberner 733949e467 Add maintenance query to remove memid=0 emails
This commit introduces a fix for wrongly inserted email addresses that
have a memid=0 field because of MariaDBs strict mode that was enabled
after moving from MySQL to MariaDB.

Fixes https://bugs.cacert.org/view.php?id=1543
2 years ago
Wytze van der Raay dadc7dea1e Add scripts for mass info mailing on Sep 6 & 7, 2019. 5 years ago
Wytze van der Raay cf3d1470a2 Add mailing scripts for ATE at Nykobing F, Denmark in September 2015. 9 years ago
Wytze van der Raay 0fc491d308 Add mailing scripts for ATE at FrOsCon, Sankt Augustin, Germany in August 2015. 9 years ago
Wytze van der Raay 40322cf67d Add mailing script for ATE in Dresden, Germany. 9 years ago
Wytze van der Raay 669bb34002 Add mailing script for ATE in Bremen, Germany. 9 years ago
Wytze van der Raay 44a3943358 Fix for https://bugs.cacert.org/view.php?id=1341
"Rate limit for login attempts"
9 years ago
Wytze van der Raay d01b5efe5f Fix syntax problems before executing these two mailing scripts. 9 years ago
Wytze van der Raay 9c95fb7987 Add two scripts for mailing to members who have agreed to the CCA when
the wrong document was online for a short period at the beginning 2015.
9 years ago
Wytze van der Raay 912a5fb6bd Add new scripts for mass mailings permitted by CAcert arbitration. 9 years ago
Wytze van der Raay ece0f2b8ee Fix bug in the CCA Policy mailing script which obscured its logging somewhat
and essentially defeated the restart mechanism based on the 'lastid' file.
10 years ago
Wytze van der Raay add8566161 Fix for https://bugs.cacert.org/view.php?id=28
"Wrong language for ''you've been assured'' & ''[CAcert.org] Client Certificate'' emails"
10 years ago
Wytze van der Raay 4f70392a23 Fix for https://bugs.cacert.org/view.php?id=1273
"Replace all backtick operators with calls to runCommand() or shell_exec()"
10 years ago
Wytze van der Raay 13f78be640 Add mailing scripts for ATEs in Graz and Wien, Austria. 10 years ago
Wytze van der Raay 3af16578e4 Add script for informing all CAcert members about CCA Policy changes. 10 years ago
Wytze van der Raay cb1ee532ad There was a mistake in the php.txt file so the wrong text was sent as it took
the text for the 54-ATE in Linz. The mailing will be resent with a changed
subject line: ATE-Oberwart (Korrektur) - 27. Juni 2014.
10 years ago
Wytze van der Raay f69b3a9874 Add scripts for sending e-mail notification of CAcert ATE in Oberwart, AT on 27.06.2014. 10 years ago
Wytze van der Raay f358d22d9e Fix for https://bugs.cacert.org/view.php?id=1172
"Move the database engine from myISAM to InnoDB"
10 years ago
Wytze van der Raay 42f16aab95 Combined fixes for
- https://bugs.cacert.org/view.php?id=413
  "Add a web page indicating the certificate request is still pending"
- https://bugs.cacert.org/view.php?id=1138
  "Implement to log the SE activity"
- https://bugs.cacert.org/view.php?id=1221
  "Inconsistency in Assurance Management"
10 years ago
Wytze van der Raay a6ba72164b Add scripts for sending e-mail notification of CAcert ATE in Wiesbaden, DE on 22.05.2014. 10 years ago
Wytze van der Raay 40b001e59d Add scripts for sending e-mail notification of CAcert ATE in Linz, AT on 16.05.2014. 10 years ago
Mendel Mobach 1112d76dd5 fix for https://bugs.cacert.org/view.php?id=1272
"Arbitrary Code Execution via SQL injection on certain database fields"
10 years ago
Mendel Mobach 365a7272cf fix for https://bugs.cacert.org/view.php?id=1184
"hex2bin function"
10 years ago
Wytze van der Raay 772c4b577b Add script for sending out notification about OpenSSL Heartbleed bug,
per arbitration ruling a20140408.1 and https://bugs.cacert.org/view.php?id=1265
10 years ago
Wytze van der Raay 5e250eaf7c Fix for https://bugs.cacert.org/view.php?id=1135
"Extend database table AdminLog et al"
10 years ago
Wytze van der Raay 62c4a20a64 Add script for mailing for ATE in Amberg on January 6, 2014. 11 years ago
Wytze van der Raay 29722257a6 Fix for https://bugs.cacert.org/view.php?id=1064
"Review the code regarding the new point calculation in
./scripts/areacheck.php"
11 years ago
Wytze van der Raay 981cbc267f Fix for https://bugs.cacert.org/view.php?id=1045
"Review the code regarding the new point calculation in
./scripts/cron/removedead.php"
11 years ago
Wytze van der Raay 32fca654cb Fix for https://bugs.cacert.org/view.php?id=1004
"performance of CAcert webserver is hampered by simultaneous stats.php
execution"
11 years ago
Wytze van der Raay 7c019de59e Fix for https://bugs.cacert.org/view.php?id=1213
""certifictate" is spelt incorrectly"
11 years ago
Wytze van der Raay 8c125fd8c7 Fix for http://bugs.cacert.org/view.php?id=1003
"Provide a possibility to regularly review the permissions in the system"
11 years ago
Wytze van der Raay cbe64cbde4 Add scripts for mailing for ATE in Vienna on October 15, 2013. 11 years ago
Wytze van der Raay e025a30a13 Add scripts for mailing for ATE Graz on August 16, 2013. 11 years ago
Wytze van der Raay e870b86839 Improved fix for https://bugs.cacert.org/view.php?id=922
CAcert application code problem causing missing "certificate about to expire messages"
11 years ago
Wytze van der Raay d6c92c4877 Add script files for mailing for ATE event in Lubeck, Germany on June 7, 2013. 11 years ago
Wytze van der Raay 98c8c419c8 Fix for https://bugs.cacert.org/view.php?id=1121
"Record the CCA acception for the account creation"
11 years ago
Wytze van der Raay 1f82e05cfa Add script for mailing for LinuxTag Berlin 2013. 11 years ago
Wytze van der Raay 7c4577bede Add script for mailing for the CAcert ATE Kiel, Germany on February 11, 2013. 11 years ago
Wytze van der Raay 209f042b7c Fix for https://bugs.cacert.org/view.php?id=512
"Org admins must have 100 points"
11 years ago
Wytze van der Raay 47346d8bb0 Fix for http://bugs.cacert.org/view.php?id=1118
"Add new fields to the database"
11 years ago
Wytze van der Raay 74466542ec Add mailing script plus data for CAcert Assurance Event at the Fedora Users and
Developers Conference, University of Kansas, Lawrence, KS, USA on January 19, 2013.
11 years ago
Wytze van der Raay bd2f3898b4 Backing out the changes made earlier today for:
Fix for https://bugs.cacert.org/view.php?id=922
  "CAcert application code problem causing missing 'certificate about to expire'
messages"
since that new code is locking up the mysql server.
12 years ago
Wytze van der Raay 39e859c96c Fix for https://bugs.cacert.org/view.php?id=922
"CAcert application code problem causing missing 'certificate about to expire' messages"
12 years ago
Wytze van der Raay 7c873275ed Fix for https://bugs.cacert.org/view.php?id=1024
Assurer flag is not set correctly on updatesort.php run
12 years ago
Wytze van der Raay a0686d999d Add script for mailing for ATE in Raleigh, NC, USA on August 11, 2012. 12 years ago
Wytze van der Raay 4f15df58c2 Add mailing script for ATE-Melbourne event on July 28, 2012. 12 years ago
Wytze van der Raay eea8ed0d51 Fix for https://bugs.cacert.org/view.php?id=1003
Provide a possibility to regularly review the permissions in the system
12 years ago
Wytze van der Raay a697caab01 Add script + text for mailing for ATE at Duesseldorf on July 9, 2012. 12 years ago