ops issueshttps://lab.civicrm.org/infra/ops/-/issues2022-12-03T19:37:14Zhttps://lab.civicrm.org/infra/ops/-/issues/984civicrm.org: move off CiviSMTP by 2022-07-312022-12-03T19:37:14Zbgmcivicrm.org: move off CiviSMTP by 2022-07-31bgmbgmhttps://lab.civicrm.org/infra/ops/-/issues/951c.o: improve monitoring for ldapcivi2022-08-09T14:40:26Zbgmc.o: improve monitoring for ldapciviAdd a monitoring check for the REST endpoint on civicrm.org.
We had an issue last night where the LDAP service crashed because of a "composer update" that had been run automatically (#950) on civicrm.org (and the update failed).
While ...Add a monitoring check for the REST endpoint on civicrm.org.
We had an issue last night where the LDAP service crashed because of a "composer update" that had been run automatically (#950) on civicrm.org (and the update failed).
While we're going to remove those auto-updates, the LDAP service didn't throw any monitoring notifications.bgmbgmhttps://lab.civicrm.org/infra/ops/-/issues/776Membership not present, error messages indicate otherwise2022-08-08T19:34:51Zjoshjosh@civicrm.orgMembership not present, error messages indicate otherwiseContact ID 9001 should have an individual supporter membership, however no such membership is reflected. When attempting to add a membership, the following errors appear:
Duplicate Membership?
This contact has an existing Supporting Spo...Contact ID 9001 should have an individual supporter membership, however no such membership is reflected. When attempting to add a membership, the following errors appear:
Duplicate Membership?
This contact has an existing Supporting Sponsor membership at CiviCRM with Current status and end date of November 19th, 2017.
Renew the existing membership instead
View all existing and / or expired memberships for this contact
This is not a critical issue, however posting here in case it's indicative of a larger issue in c.ohttps://lab.civicrm.org/infra/ops/-/issues/827Country filtering broken on /partners-contributors2022-08-08T19:12:09ZnicolCountry filtering broken on /partners-contributorsThe country dropdown on the [Find an Expert](https://civicrm.org/partners-contributors) page shows countries that aren't there and doesn't show countries that should be there.
For e.g. Afghanistan, Vietnam, Dominican Republic, Indonesia...The country dropdown on the [Find an Expert](https://civicrm.org/partners-contributors) page shows countries that aren't there and doesn't show countries that should be there.
For e.g. Afghanistan, Vietnam, Dominican Republic, Indonesia and Hong Kong are shown in the dropdown, but there are no partners or contributors shown when these are selected. Conversely, Poland, Serbia and Brazil all have companies listed, but these countries aren't in the dropdown.
This has been the case long enough for it to not be a normal caching issue — beyond that I'm not sure what might be going wrong with the Civi/Views/Exposed Filters integration.
![image](/uploads/fc566711cbf324d307fbbe6d06cdc60a/image.png)https://lab.civicrm.org/infra/ops/-/issues/978Fraudulent activity on iATS2022-04-20T13:28:53Zjoshjosh@civicrm.orgFraudulent activity on iATSEmail received at info@ on 7/9/2021:
>iATS Account 3DJV: Fraud on 09.03.21 - 09.05.21 [ ref:_00DA0ZyVz._5003k1ztCqM:ref ]
>From 09/03/21 to 09/05/21, there were a few thousand fraud attempts to the organization’s account. I have attach...Email received at info@ on 7/9/2021:
>iATS Account 3DJV: Fraud on 09.03.21 - 09.05.21 [ ref:_00DA0ZyVz._5003k1ztCqM:ref ]
>From 09/03/21 to 09/05/21, there were a few thousand fraud attempts to the organization’s account. I have attached a >spreadsheet that shows the rejected transactions. Within the spreadsheet is a chart that shows the type of fraud you are >receiving, as each bank-rejected transaction can incur an Authorization Fee to the organization.
Included export of activity here: https://docs.google.com/spreadsheets/d/1jzPKnVeLIaoWo30hR7Ht5iYCvnFIEp5f/edit?usp=sharing&ouid=105885104964417198846&rtpof=true&sd=true
Associated contact record: https://civicrm.org/civicrm/contact/view?reset=1&cid=93228
I'll review and adjust the fraud tools in iATS admin based on the guidelines provided.joshjosh@civicrm.orgjoshjosh@civicrm.orghttps://lab.civicrm.org/infra/ops/-/issues/962c.o: sometimes the site crashes when we edit blog posts2020-11-07T01:54:21Zbgmc.o: sometimes the site crashes when we edit blog postsI don't know if it's linked to Gutenberg, but I only see this on blog posts:
* Try to add a new blog post
* or edit an existing blog post.
The site will spin for a while, and sometimes it will crash and cause a 404 (redirect to install...I don't know if it's linked to Gutenberg, but I only see this on blog posts:
* Try to add a new blog post
* or edit an existing blog post.
The site will spin for a while, and sometimes it will crash and cause a 404 (redirect to install.php).
It causes MySQL to crash completely, resulting in a few seconds of downtime.
In the site's error.log, I see this:
```
2020/11/06 19:30:04 [error] 11217#11217: *23884119 FastCGI sent in stderr: "PHP message: PDOException: SQLSTATE[HY000] [2002] Connection refused in /var/aegir/platforms/civicrm-d8/core/lib/Drupal/Component/DependencyInjection/PhpArrayContainer.php on line 79 #0 /var/aegir/platforms/civicrm-d8/core/lib/Drupal/Core/Database/Driver/mysql/Connection.php(416): PDO->__construct('mysql:host=127....', '..', '..', Array)
#1 /var/aegir/platforms/civicrm-d8/core/lib/Drupal/Core/Database/Database.php(371): Drupal\Core\Database\Driver\mysql\Connection::open(Array)
#2 /var/aegir/platforms/civicrm-d8/core/lib/Drupal/Core/Database/Database.php(166): Drupal\Core\Database\Database::openConnection('default', 'default')
#3 [internal function]: Drupal\Core\Database\Database::getConnection('default')
#4 /var/aegir/platforms/civicrm-d8/core/lib/Drupal/Component/DependencyInjection/PhpArrayContainer.php(79): call_user_func_array('Drupal\\Core\\Dat...', Array)
#5 /var/aegir/platforms/civicrm-d8/core/lib/Drupal/Component/DependencyInjection/Container.php(173): Drupal\Component\DependencyIn" while reading response header from upstream, client: 70.53.192.166, server: civicrm.org, request: "GET /blog/dev-team/civicrm-530-release HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php7.2-fpm.sock:", host: "civicrm.org"
2020/11/06 19:30:04 [error] 11217#11217: *23884119 FastCGI sent in stderr: "PHP message: PDOException: SQLSTATE[HY000] [2002] Connection refused in /var/aegir/platforms/civicrm-d8/core/lib/Drupal/Component/DependencyInjection/PhpArrayContainer.php on line 79 #0 /var/aegir/platforms/civicrm-d8/core/lib/Drupal/Core/Database/Driver/mysql/Connection.php(416): PDO->__construct('mysql:host=127....', '..', '..', Array)
#1 /var/aegir/platforms/civicrm-d8/core/lib/Drupal/Core/Database/Database.php(371): Drupal\Core\Database\Driver\mysql\Connection::open(Array)
#2 /var/aegir/platforms/civicrm-d8/core/lib/Drupal/Core/Database/Database.php(166): Drupal\Core\Database\Database::openConnection('default', 'default')
#3 [internal function]: Drupal\Core\Database\Database::getConnection('default')
#4 /var/aegir/platforms/civicrm-d8/core/lib/Drupal/Component/DependencyInjection/PhpArrayContainer.php(79): call_user_func_array('Drupal\\Core\\Dat...', Array)
#5 /var/aegir/platforms/civicrm-d8/core/lib/Drupal/Component/DependencyInjection/Container.php(173): Drupal\Component\DependencyIn" while reading response header from upstream, client: 70.53.192.166, server: civicrm.org, request: "GET /blog/dev-team/civicrm-530-release HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php7.2-fpm.sock:", host: "civicrm.org"
```
MySQL shows this:
```
MariaDB [civicrmorg]> show processlist;
+----+------------+-----------------+------------+---------+------+------------+------------------------------------------------------------------------------------------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+----+------------+-----------------+------------+---------+------+------------+------------------------------------------------------------------------------------------------------+----------+
| 58 | civicrmorg | localhost:57070 | civicrmorg | Query | 0 | init | show processlist | 0.000 |
| 66 | civicrmorg | localhost:57088 | civicrmorg | Query | 25 | statistics | SELECT cid, data, created, expire, serialized, tags, checksum FROM cache_entity WHERE cid IN ( 'valu | 0.000 |
+----+------------+-----------------+------------+---------+------+------------+------------------------------------------------------------------------------------------------------+----------+
2 rows in set (0.00 sec)
```
The query is too long to display the full version.bgmbgmhttps://lab.civicrm.org/infra/ops/-/issues/950Replace Aegir from www-prod-22020-10-23T13:06:43ZbgmReplace Aegir from www-prod-2We do not really use Aegir on www-prod-2. It was useful at some point for helping to clone dev sites, but now it's more in the way and causing trouble, rather than helping.
I would still like to make sure that a future setup will be ali...We do not really use Aegir on www-prod-2. It was useful at some point for helping to clone dev sites, but now it's more in the way and causing trouble, rather than helping.
I would still like to make sure that a future setup will be aligned with what Symbiotic uses, since I have to support both (and Spark, where Aegir is currently harder to replace). It will likely be based on the Ansible work by Megaphone Jon.bgmbgmhttps://lab.civicrm.org/infra/ops/-/issues/582INFRA-168 Extensions Review - Order by Post Date is wrong!2020-08-14T13:06:07ZlegacyINFRA-168 Extensions Review - Order by Post Date is wrong!I decided to jump on the extensions that need reviewing, and ordering by post date results in them being in a different order to that described by the Post Date.
Original author: johnffI decided to jump on the extensions that need reviewing, and ordering by post date results in them being in a different order to that described by the Post Date.
Original author: johnffhttps://lab.civicrm.org/infra/ops/-/issues/532INFRA-220 Smart groups fail on save2020-08-14T13:05:54Zjoshjosh@civicrm.orgINFRA-220 Smart groups fail on saveUsing the summary fields extension and the 12 month rolling soft credit field when searching yields results, however when attempting to smart group the results the process ends with:
No matches found for:
Total Soft Credits in the Last ...Using the summary fields extension and the 12 month rolling soft credit field when searching yields results, however when attempting to smart group the results the process ends with:
No matches found for:
Total Soft Credits in the Last 12 Months In ##, ##
Suggestions:
check your spelling
try a different spelling or use fewer letters
if you are searching within a Group or for Tagged contacts, try 'any group' or 'any tag'
add a New Individual, Organization or Household
make sure you have enough privileges in the access control system
Where ## is any range. Groups are formed (currently in c.o, "contributors - supporting", "contributors - empowering", "contributors - sustaining" all existed as a result of this process), however no records are grouped therein. Interestingly, the process was successful earlier, resulting in one contact in the "contributor - supporting" group (though there should be 2 present).https://lab.civicrm.org/infra/ops/-/issues/808civicrm.org/extensions: "Compatibility" filter does not work2020-08-14T13:01:23Zbgmcivicrm.org/extensions: "Compatibility" filter does not workOn https://civicrm.org/extensions, when the "Compatibility" filter is used, no results are returned.
Reported by @bails @davejOn https://civicrm.org/extensions, when the "Compatibility" filter is used, no results are returned.
Reported by @bails @davejhttps://lab.civicrm.org/infra/ops/-/issues/809Monitor the validity of the news RSS feed2020-08-14T13:00:59ZbgmMonitor the validity of the news RSS feedRelated to #807: an invalid news RSS can generate fatal errors on the CiviCRM dashboard (CRM-21355 also tries to address this). It has also happened in the past to have errors because of invalid entities in the feed content.
We should a...Related to #807: an invalid news RSS can generate fatal errors on the CiviCRM dashboard (CRM-21355 also tries to address this). It has also happened in the past to have errors because of invalid entities in the feed content.
We should add monitoring to ensure that the RSS feed is valid.https://lab.civicrm.org/infra/ops/-/issues/560INFRA-190 Display extension statistics on extension pages2020-08-14T12:58:35ZlegacyINFRA-190 Display extension statistics on extension pages[~nganivet] is working on INFRA-189, which will provide JSON files with statistics per extension. We should build a mechanism to display this data on each extension page on civicrm.org
The current vision is to use JavaScript to fetch th...[~nganivet] is working on INFRA-189, which will provide JSON files with statistics per extension. We should build a mechanism to display this data on each extension page on civicrm.org
The current vision is to use JavaScript to fetch the correct JSON file for the extension, parse the data, and display it on the page, as it is the simplest approach that will get us to the stated goal. Richer functionality later on may require a different approach, but we're aiming for useful results sooner rather than later.
Original author: allenshawhttps://lab.civicrm.org/infra/ops/-/issues/885Drupal8: add a download link to civicrm.org/download2020-03-15T17:02:30ZbgmDrupal8: add a download link to civicrm.org/downloadDepends on: https://lab.civicrm.org/dev/drupal/wikis/drupal8-composerDepends on: https://lab.civicrm.org/dev/drupal/wikis/drupal8-composerbgmbgmhttps://lab.civicrm.org/infra/ops/-/issues/935CiviCRM.org Birmingham civicamp registration regression putting people off bo...2020-02-13T08:05:24ZRichCiviCRM.org Birmingham civicamp registration regression putting people off bookingThis began here:
https://chat.civicrm.org/civicrm/pl/e35qafjbo7ywid769txf1waamw
(Various posts)
And continued on a private thread with Josh and Heather. Josh asked me to post here.
Basically: the billing name gets shown as the partici...This began here:
https://chat.civicrm.org/civicrm/pl/e35qafjbo7ywid769txf1waamw
(Various posts)
And continued on a private thread with Josh and Heather. Josh asked me to post here.
Basically: the billing name gets shown as the participant name on confirmation screen, but it does get properly entered if you confirm.
This is stopping at least one person booking - he's new to CiviCRM, new in his job and doesn't want to confirm a booking for what looks like his boss!
I did some testing and could not replicate on master.
But doing the same on 5.20 I see that it shows the wrong data on the confirmation screen.
Looks from my sniffer script that civicrm.org is running 5.21.beta1.
I found the [bug report](https://lab.civicrm.org/dev/event/issues/25) and the [pr that fixed it](https://github.com/civicrm/civicrm-core/pull/16140) which looks like it made it to 5.21 [with a patch for 5.20](https://github.com/civicrm/civicrm-core/pull/16147).
Do you think we could get the main site upgraded from the beta version to avoid this regression?https://lab.civicrm.org/infra/ops/-/issues/790Partner logo only show when logged into c.o2020-02-01T18:25:37Zjoshjosh@civicrm.orgPartner logo only show when logged into c.oNew partner Agiliway https://civicrm.org/providers/AgiliWay-Group%2C-Inc. (contact ide 49332) logo only appears when logged in on c.o.New partner Agiliway https://civicrm.org/providers/AgiliWay-Group%2C-Inc. (contact ide 49332) logo only appears when logged in on c.o.bgmbgmhttps://lab.civicrm.org/infra/ops/-/issues/775Current partners membership set to expired2020-02-01T18:24:11Zjoshjosh@civicrm.orgCurrent partners membership set to expiredContact IDs 5377, 5205, and 19719 are all current and up to date on payments, however the membership is set to expired. Adding additional payments or forcing an override do not update the status (for me). It seems like the contribution r...Contact IDs 5377, 5205, and 19719 are all current and up to date on payments, however the membership is set to expired. Adding additional payments or forcing an override do not update the status (for me). It seems like the contribution record (which is manually recorded, but that's a different issue) is not associated with and therefore isn't impacting the membership. I've come across this before with numerous other partners and used the following work around:
1. delete membership and corresponding contributions (including those that don't delete when the membership is deleted)
2. create new contact record
3. merge contacts
4. add new membership
5. renew membership payment manuallybgmbgmhttps://lab.civicrm.org/infra/ops/-/issues/929civicrm.org: registration failing for CiviCamp Birmingham2020-01-17T18:55:46Zbgmcivicrm.org: registration failing for CiviCamp BirminghamReported on mattermost:
> "Trying to register onto CiviCamp Birmingham and getting Invalid positive integer when I try to pay. Any ideas? " (@barijohn)
https://civicrm.org/civicrm/event/register?reset=1&id=1432Reported on mattermost:
> "Trying to register onto CiviCamp Birmingham and getting Invalid positive integer when I try to pay. Any ideas? " (@barijohn)
https://civicrm.org/civicrm/event/register?reset=1&id=1432bgmbgmhttps://lab.civicrm.org/infra/ops/-/issues/916Integrate timetrack with contributor log calculation2020-01-12T15:04:58Zjoshjosh@civicrm.orgIntegrate timetrack with contributor log calculationPreviously, contributors added their contributions via a contribution form. Summary fields then added their total financial support + contributions for a total amount "given to the project". The partner/contributor included contributors ...Previously, contributors added their contributions via a contribution form. Summary fields then added their total financial support + contributions for a total amount "given to the project". The partner/contributor included contributors where the total is > 40 hours over the past rolling 12 months as well as sorted based on the sumtotal.
With the change to Gitlab for time tracking, users no longer directly add in contributions, so the calculation is essentially reverting to financial support only. Contributors will fall off of the listing and the sorting will favor financial support only.
We need a way to rebalance contributions that come through Gitlab automatically.bgmbgmhttps://lab.civicrm.org/infra/ops/-/issues/604INFRA-141 Turning WYSIWYG on and off for blog "eats" formatting2020-01-12T14:59:19ZlegacyINFRA-141 Turning WYSIWYG on and off for blog "eats" formattingI'm trying to get a blog post done about GSoC and I'm finding CKEditor and IMCE really unusable. I can't upload images with the blog, so I have to post them on http://wiki.civicrm.org/. Then when I've set the alignment and HSPACE so th...I'm trying to get a blog post done about GSoC and I'm finding CKEditor and IMCE really unusable. I can't upload images with the blog, so I have to post them on http://wiki.civicrm.org/. Then when I've set the alignment and HSPACE so the post looks like it was composed after 1996, turning the WYSIWYG editor on and off deletes all the formatting forcing me to start over.
I can deal with this, but is we expect the GSoC students to blog about their projects on CiviCRM.org, the WYSIWYG and IMCE integration needs to be fixed.
Original author: kreynenhttps://lab.civicrm.org/infra/ops/-/issues/508INFRA-245 CiviCon Sponsor cannot choose logo2020-01-12T14:57:44ZlegacyINFRA-245 CiviCon Sponsor cannot choose logoWhen adding a sponsor node, there is a field for "Sponsor logo" with a link to "Select media". The link opens a modal labeled "Library", but it's otherwise empty and there's no way to upload anything.
Original author: andrewhuntWhen adding a sponsor node, there is a field for "Sponsor logo" with a link to "Select media". The link opens a modal labeled "Library", but it's otherwise empty and there's no way to upload anything.
Original author: andrewhunt