Removed from ThankYouEmail campaign notification but there are no other users on that notification. Just noting in case it is needed.

ipsets created and pushed to the hosts. config not updated yet.

Verified ssh and mysql access is working.

pubkey updated.

Key updated.

@Ejegg Let us know if there are any issues here. If none, it's closable at the end of sprint.

This was pushed on 13 Mar 2024

[frack::puppet] 12c170a84 Add localsettings favicon.ico to frdeploy donorwiki project. (Jeff Green:Jeff Green)

Pulling out of sprint in favor of a task to implement via adyen. If we decide to use this path we can bring it back to life.

wikimedia.4b69@litmusemail.com has been added as a valid address for sending mail off of the frdev host. It should be only be used with CID 165749 as stated above. https://phabricator.wikimedia.org/T358042#9634360

I have updated the data entries for CID 165749 to replace instances of the name with "Test User" and the address to the office address. Additionally updated some external entity identifiers to be "testuser". This has been codified in the staging_db_refresh script so that it will persist through data reloads.

@RLopez-WMF Thanks. I have added your wikimedia.org address so you can start testing now. We still need some more conversation internally on the external address. Will let you know when we know more.

Verified as working.

@EWilfong_WMF Ok, the change has been pushed. It should show up in DNS in a few minutes. Ends up we already had the validation CNAME record in place. Let me know how it goes.

Got it. Will get the process rolling. Thanks!

@EWilfong_WMF Just looking for a little clarity on this.

@Eileenmcnaughton The way process control is designed right now is to treat the command and slow-start bits of config in the same manner. It treats them both as a list since there can be multiple commands passed in a job.

Ok. This is now in place on both civi and frdev roles. frdev will probably throw an error related to watchdog() but that is known and independent of this.

Certificate renewed and sent via email. Password sent via SMS.

Tables were dropped in T334542.

Deleted yesterday. Dropped the 3 tables and 1 view:

Dropped the 3 tables and 1 view:

MariaDB [drupal]> drop view drupal.contribution_tracking_view;
Query OK, 0 rows affected (0.001 sec)

contribution_source has been backed up also. I will do the deletion tomorrow when it's not at the end of the work day.

I have combed through the available logs and couldn't find an entry as to what the deduper was trying to do. I noticed in the process that the slow query log was not turned on. I have enabled the slow query log so that we can capture that information in the future. For now, there is not much more to go off of. Perhaps we can schedule an attempt of the deduper while watching the DB to see what it may have been trying to do.

Renewed certificate and sent via email. Password sent via SMS.

@Eileenmcnaughton In addition to the contribution_tracking table, there are also contribution_tracking_owa_ref and contribution_tracking_view. Do those need to be backed up and dropped also?

I have not investigated yet. I attempted logging in this morning but ssh connections are getting shut down after the key is accepted for both myself and jgreen. I will plan a reboot of the host late this evening.

@RLopez-WMF The database load has finish. You can attempt to log in using your same credentials at: https://civicrm.frdev.wikimedia.org/ It will prompt for your ssl certificate in the same manner as when accessing the production civicrm and superset hosts.

Certificate not needed. It has expired and can be renewed in the future if access is needed again.

@fnegri Thanks for stepping in to restart mysql on this host.

All fr-tech devs have been granted reader access to the project. This does not apply permissions needed for the transition to the prod vps.

Cert info sent via email.