[00:10:07] I got a job fail on duplicate key - just looking [00:23:03] Fundraising-Backlog, fundraising-tech-ops: Move from phantomJS to grafana-image-renderer for frack grafana - https://phabricator.wikimedia.org/T250441 (Dwisehaupt) The image render plugin is used to take a graph and turn it into an image that can be saved. I'm not sure if anyone is currently using this.... [00:26:10] (CR) Ejegg: [C: -2] "Unfortunately, it looks like we can't go ahead with this approach." [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/609810 (https://phabricator.wikimedia.org/T251780) (owner: Mepps) [00:32:05] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising Sprint Grep works IRL, and 4 others: Implement redirect for hide banner cookie issue - https://phabricator.wikimedia.org/T251780 (Ejegg) @Krinkle explained in IRC that this a... [00:35:56] fundraising-tech-ops: Test and choose a benchmark to use for applying a machine standard - https://phabricator.wikimedia.org/T246841 (Dwisehaupt) [00:36:38] hmm it was a timing error - I think the upcoming changes will slightly improve - issue was we built during a merge while the contact temporarily had 2 emails [00:38:15] fundraising-tech-ops: Update documentation for mysql master swap - https://phabricator.wikimedia.org/T236849 (Dwisehaupt) Removing tag since this an fr-tech-ops task with nothing required from fr-tech in general. [00:38:49] eileen: oof, that's a fun edge case [00:39:30] ejegg: yep - I think the new method will help because see https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/tools/+/609238 - we do inserts, then updates, then deletes [00:39:42] so the delete will likely remove again [00:39:52] fundraising-tech-ops, observability, Epic: Capture metrics for postfix queue depth both overall and for specific queues and domains - https://phabricator.wikimedia.org/T235804 (Dwisehaupt) Removing tag since this an fr-tech-ops task with nothing required from fr-tech in general. [00:55:15] quick question - if the rabbit eats your to-do list do you still have to do it? Asking for a friend... [01:02:04] fundraising-tech-ops: Audit mysql grants and ensure the grant scripts reflect the current reality - https://phabricator.wikimedia.org/T243342 (Dwisehaupt) Removing tag since this an fr-tech-ops task with nothing required from fr-tech in general. [01:09:28] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising Sprint Grep works IRL, and 4 others: Implement redirect for hide banner cookie issue - https://phabricator.wikimedia.org/T251780 (AndyRussG) > He suggested we put the thank y... [01:29:10] (PS13) Eileen: Silverpop - build main table incrementally [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/609238 (https://phabricator.wikimedia.org/T253152) [01:34:31] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising Sprint Grep works IRL, and 4 others: Implement redirect for hide banner cookie issue - https://phabricator.wikimedia.org/T251780 (AndyRussG) Just another idea for the shortes... [06:29:29] (CR) jerkins-bot: [V: -1] Localisation updates from https://translatewiki.net. [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/611128 (owner: L10n-bot) [06:33:35] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising Sprint Grep works IRL, and 4 others: Implement redirect for hide banner cookie issue - https://phabricator.wikimedia.org/T251780 (AndyRussG) @Ejegg what about this option? We... [06:35:02] (CR) Raimond Spekking: [C: +2] "false positive" [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/611128 (owner: L10n-bot) [07:47:04] (PS14) Eileen: Silverpop - build main table incrementally [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/609238 (https://phabricator.wikimedia.org/T253152) [07:48:01] (CR) jerkins-bot: [V: -1] Silverpop - build main table incrementally [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/609238 (https://phabricator.wikimedia.org/T253152) (owner: Eileen) [07:50:25] (PS15) Eileen: Silverpop - build main table incrementally [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/609238 (https://phabricator.wikimedia.org/T253152) [07:54:37] (PS1) Eileen: Do an extra delete in case there was a timing issue [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/611188 (https://phabricator.wikimedia.org/T253152) [08:12:38] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, and 3 others: Q4 FY2019/20 investigate export and upload issues with the silverpop export - https://phabricator.wikimedia.org/T253152 (Eileenmcnaught... [13:29:30] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, and 3 others: Add and delete fields from the _all_Wikimedia database (civi export to ESP) - https://phabricator.wikimedia.org/T252245 (KHaggard) Ok... [13:31:38] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, and 3 others: Q4 FY2019/20 investigate export and upload issues with the silverpop export - https://phabricator.wikimedia.org/T253152 (KHaggard) Ok,... [13:41:13] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising Sprint Grep works IRL, and 4 others: Implement redirect for hide banner cookie issue - https://phabricator.wikimedia.org/T251780 (Ejegg) @AndyRussG Hmm, that cross-site cooki... [13:41:24] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising Sprint Grep works IRL, and 4 others: Implement redirect for hide banner cookie issue - https://phabricator.wikimedia.org/T251780 (spatton) I like that last idea (special cook... [14:16:38] Wikimedia-Fundraising-Banners: 2020-07-15 en6C pre-test: desktop large batch - https://phabricator.wikimedia.org/T257611 (jbolorinos-ctr) Screenshot Test Results Desktop - Control: https://app.crossbrowsertesting.com/public/i15b74a2dc92badb/screenshots/z467657d97aa3efdd75d [14:18:21] Wikimedia-Fundraising-Banners: 2020-07-15 en6C pre-test: desktop small batch - https://phabricator.wikimedia.org/T257510 (jbolorinos-ctr) Screenshot Test Results - Desktop - Control: https://app.crossbrowsertesting.com/public/i15b74a2dc92badb/screenshots/z1c7b30ff2d3ed5055ec [14:20:23] Wikimedia-Fundraising-Banners: 2020-07-15 en6C pre-test: mobile large batch - https://phabricator.wikimedia.org/T257612 (jbolorinos-ctr) Screenshot Test Results - Mobile: - Control: https://app.crossbrowsertesting.com/public/i15b74a2dc92badb/screenshots/za2cc039b81184de63c4 [14:22:09] Wikimedia-Fundraising-Banners: 2020-07-15 en6C pre-test: mobile small batch - https://phabricator.wikimedia.org/T257613 (jbolorinos-ctr) Screenshot Test Results - Mobile: - Control: https://app.crossbrowsertesting.com/public/i15b74a2dc92badb/screenshots/ze74b90593af9d11b75d [14:30:48] Fundraising-Backlog: Add two additional fields to silverpop export - https://phabricator.wikimedia.org/T257597 (KHaggard) On the Acoustic side, I've created the 2 new fields today so they're ready to be mapped to when the deployment rolls out. both_funds_latest_currency both_funds_latest_currency_symbol [14:35:23] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising Sprint Grep works IRL, and 4 others: Implement redirect for hide banner cookie issue - https://phabricator.wikimedia.org/T251780 (Pcoombe) Some quick thoughts on proposed sol... [14:36:26] (PS2) Ejegg: Remove unused parameters from txn building fns [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/584062 [14:36:59] (PS3) Ejegg: Set financial type ID on ContributionRecur record [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/579462 [14:37:14] (PS2) Ejegg: Fix method signature for newFailure [extensions/DonationInterface] - https://gerrit.wikimedia.org/r/580113 [14:38:35] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising Sprint Grep works IRL, and 4 others: Implement redirect for hide banner cookie issue - https://phabricator.wikimedia.org/T251780 (MBeat33) > Put a link in the thank-you page... [14:39:03] (PS3) Ejegg: Remove handling for bogus 'anonymous' and 'optout' fields [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/564274 [14:43:44] (CR) jerkins-bot: [V: -1] Set financial type ID on ContributionRecur record [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/579462 (owner: Ejegg) [14:54:51] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, and 3 others: Q4 FY2019/20 investigate export and upload issues with the silverpop export - https://phabricator.wikimedia.org/T253152 (KHaggard) Oh... [15:28:11] tzag fr-tech! [15:28:23] looks like there was lots going on yesterday after I logged off! [15:28:36] hi jgleeson [15:28:54] hey cstone :) [15:38:33] jgleeson cstone fr-tech hi! [15:39:04] Does anyone know how to read a 3rd party cookie in javascript? [15:40:03] That is, say you're on wikipedia, and you previously had a cookie set on donate wiki, could we somehow make the javascript you're running on wikipedia aware of the value of the donate wiki cookie? by some sort of background request to donate wiki? [15:40:40] sounds tricky [15:44:21] AndyRussG: doesn't safari dislike third party cookies? [15:48:03] fundraising-tech-ops: make kafkatee banner impression logs accessible from fundraising analytics server - https://phabricator.wikimedia.org/T257680 (Jgreen) [15:48:47] fr-tech I'm catching up on the hide cookie conversation. I have some wacky ideas but here they are. What if we made a subdomain "fundraising.wikipedia.org" that either: 1.) just hosted the TY pages or 2.) was the new home of donate wiki entirely? [15:49:45] dstrine yep, that's definitely a possibility [15:49:59] fundraising-tech-ops: make kafkatee banner impression logs accessible from fundraising analytics server - https://phabricator.wikimedia.org/T257680 (Jgreen) p:Triage→Medium [15:50:04] that's actually a great idea dstrine [15:50:06] supposedly not too hard to stand up a new static site [15:50:11] ejegg|afk: I feel like that's just an SRE task right? [15:50:18] and we probably need to change a bunch of code [15:50:30] just a setting for where to send the ty page [15:50:38] ejegg|afk: we could just move donate wiki [15:51:06] dstrine right, or make it answer to both .pedia and .media [15:51:39] this might make DS tickets less annoying for other reasons. people think we are fraudulent when they get directed to wikimedia domains [15:51:48] so only payments wiki will look weird [15:51:54] dstrine: yes I think that might be the best option [15:52:35] ok cool. We get to send the bat signal to all other teams. so if someone grumbles about this we get to push for help. Grant and lisa will totally help smooth this out [15:53:15] I have a meeting with dylan and erika this morning. I'll bring it up [15:53:20] Jeff_Green: any thoughts on how big of a task it'd be to set up fundraising.wikipedia.org, or donate.wikipedia.org, with something there, either a wiki or even static html? [15:54:50] I bet advancement will have feelings about naming so I will make sure they are looped in. [15:55:00] dstrine: thanks so much! also don't worry..... :) [15:55:22] AndyRussG: catching up on backscroll [15:55:32] Jeff_Green: thanks! [15:56:05] dwisehaupt: (since you missed backscroll) any thoughts on setting up some static html on donate.wikipedia.org or fundraising.wikipedia.org? [15:56:42] this is related to the cookie fun? [15:56:45] Jeff_Green: dwisehaupt donate.wikipedia.org currently exists and redirects to donate.wikimedia.org [15:56:52] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising Sprint Grep works IRL, and 4 others: Implement redirect for hide banner cookie issue - https://phabricator.wikimedia.org/T251780 (DStrine) Here is another option. We make a s... [15:57:01] dwisehaupt: yeah, the solution we were trying didn't work, unfortunately [15:57:22] AndyRussG: fundraising.wikimedia.org specifically is already in use, afaict it is still permanently tied to legacy paypal recurring donations and we can't repurpose it without breaking those [15:57:41] Jeff_Green: no, wikiPedia [15:57:43] right now it goes to a vhost on the payments listener that simply serves a redirect [15:57:46] oh P [15:58:16] so we can set the donor hide banner cookie directly from a *.wikipedia.org domain [15:58:30] yeah this^^^ [15:58:51] doesn't sound like a big deal to me, my main question would be where we host it, frack vs prod [15:59:10] the concern i would have with donate.wikipedia.org is if there is some communication or such that has links to that happen to work just because of the redirect. [15:59:34] mostly around images/js/css or such. [15:59:54] dwisehaupt: if we move all of donate wiki we won't need a redirect [15:59:59] still waking up a bit so my grammar should improve in a little. [16:00:07] jgleeson: the third party stuff is complicated, but as far as I understand, if a cookie is explicitly set in the right way when you visit an actual page on domain A, then if you go to domain B, and there a background request is performed to domain A, the previously set domain A cookie can at least be sent to the server of domain A on that request [16:00:26] jgleeson: see https://developer.mozilla.org/en-US/docs/Web/HTTP/Headers/Set-Cookie/SameSite [16:00:37] can't donate.wikipedia.org and donate.wikimedia.org be exactly the same site? [16:00:40] I don't know if that's something Safari specifically blocks additionally [16:00:57] i.e. in apache terms a serveralias? [16:01:05] AndyRussG: I think that depends on the samesite stuff [16:01:28] yeah I spent some time looking at that for another task a while back [16:01:31] jgleeson: right and we have control over that header on all domains [16:01:32] not sure if we updated that [16:01:35] Jeff_Green: from the apache side, that sounds like a good plan. [16:01:36] Jeff_Green: yeah but at this point, functionally we would probably stop anyone from visiting the wikimedia version [16:02:04] dwisehaupt: Jeff_Green: that'd be great, though there may be some additional wikimedia config to make it work [16:02:07] AndyRussG: I think we just left it alone if I remember rightly but this post shows where we can update that https://phabricator.wikimedia.org/T235204#5606408 [16:02:24] I guess it's confusing branding-wise [16:03:10] in general, i don't see any technical issue with it. the branding and consistency between both sites (if we maintain two) would be the bigger things [16:03:11] Jeff_Green: we're about to get a lot omre confusing brand wise and that will probably continue for a few years. Just add this to the list [16:03:28] but we got to keep our systems working properly [16:03:30] dstrine: I'm just gonna stay in denial about all this ;-P [16:03:55] Jeff_Green: I feel ya. I'm just kind of numb and waiting for branding to be done [16:05:54] dstrine i imagine it would be the same wiki, just answering to both addresses for now [16:05:59] going back to the original question, I don't feel like I understand the overall issue and production platform context well enough to think about whether fundraising.wp.o is a good solution [16:06:08] so it wouldn't get inconsistent [16:06:57] ejegg|afk: what about $wgDBserver and such? [16:07:09] sorry not that one [16:07:34] $wgServer [16:07:39] ejegg|afk: ok... Jeff_Green maybe another engineer can explain but basically modern browsers are not letting us set a wikipedia cookie from the current location of donate wiki. We are starting to get increasing DS tickets that banners are not being suppressed [16:07:50] and that DS burden will grow [16:07:55] ejegg|afk: and a few others I see in my local config that have to point to the domain (localhost here) [16:08:43] ejegg|afk: there might be a way to do it but I think it'll have some extra config setup stuff. It's on the main production cluster, no? We'll have to talk to operations/SRE [16:09:06] dstrine: ok that makes sense, so the idea would be that you stay on the *.wikipedia.org domain for the whole process until the handoff to payments.wm.o? [16:10:03] * Jeff_Green whoop, lunch whistle is sounding here, back in a bit [16:11:01] Jeff_Green: this is only for the thank-you page, which is where we'd set the banner hide cookie for donors [16:12:02] Jeff_Green: well you bounce back to doante.wikipedia.org for the ty page [16:12:15] lol typos [16:12:22] donate.wikipedia.org [16:12:39] doughnut.wikipedia.org should be a thing [16:13:06] heh [16:13:51] dante.wikipedia.org could be all about the divine comedy [16:15:37] and donate.wikipoohdia.org about fecal transplants? [16:15:48] ok we're done [16:16:01] AndyRussG: drew a line and then walked right past it [16:16:06] * AndyRussG is sorry [16:16:47] I tried to not say it but couldn't... [16:19:45] Jeff_Green: dwisehaupt: some notes about multiple domains for a single wiki: https://www.mediawiki.org/wiki/Topic:V3lut2rspqnrp1vc [16:20:24] https://www.mediawiki.org/wiki/Topic:Ro3dn1wmivlsqy6j [16:20:59] fr-tech ^ [16:21:16] Looks like it's possible but not totally straightforward... Maybe static html would be the fastest? [16:21:25] (in terms of setup time) [16:21:50] * Jeff_Green back [16:22:20] fr-tech i'm still waiting in a bank - looks like i'm gonna miss standup if yr doing that [16:23:00] dstrine: so you'd go en.wikipedia.org->donate.wikiMedia.org->payments.wikiMedia.org->donate.wikiPedia.org->cookieset? [16:23:49] Jeff_Green: that is one option if we only put the TY pages on donate.wikipedia.org [16:24:53] another option is for the whole donate wiki experience to be on wikipedia subdomain so: en.wikipedia.org->donate.wikiPedia.org->payments.wikiMedia.org->donate.wikiPedia.org [16:25:20] right now donate.wikipedia redirects to donate.wikimedia - we could switch that [16:25:58] I'm starting to like the idea of just moving donatewiki to donate.wikipedia.org [16:26:07] me too^^^ [16:26:10] ejegg|afk: you mean like just reverse the redirect, and make the whole wiki setup to donate.wikipedia.org [16:26:48] dstrine: ejegg|afk: Jeff_Green. doesn't doing that run much greater risk of blowback because it might seem like rebranding? [16:27:08] Like, there are other reasons people go to donate. wikimedia.org [16:27:20] For now I think we want to only send people to the ty page there? [16:27:44] I mean, I don't think we want to get advancement tangled in any rebranding controversies... [16:27:54] AndyRussG: I'm asking that very question in the email thread [16:28:50] dstrine: ok... just to note, I don't see much difficulty technically in only having a static site at donate. wikipedia.org that mimics the current ty page and sets the cookie [16:30:11] AndyRussG: I guess one big question is whether perceive it as an org/brand switch to go back and forth between wikimedia.org and wikipedia.org domains [16:31:54] Jeff_Green: right... I mean one question is what donors will think... we already do do that with them... and the other question is community (mostly not donors) controversies about rebranding [16:32:00] Jeff_Green: it already happens to some degree. AndyRussG and I are both saying that the lightest weight version is just to send people to the TY page on wikipedia. We'll get a bunch more people involved to help with that decision [16:32:12] fr-tech running a little late. wrapping up what should have been a short conversation on live chat to cancel my car insurance renewal [16:32:25] dstrine / AndyRussG yup yup [16:32:53] are we doing standup today or is are we still doing the silent friday thing? I keep losing track of where things are officiall at on that. [16:33:05] silent standup? [16:33:07] :-P [16:33:11] XenoRyet: cstone and I are on the call but I dunno [16:33:21] we could use sign [16:34:22] i have a radical idea, what if we redirect people back to where they were when they saw the banner and set the cookie there? [16:35:52] i.e. you depart from a banner at https://en.wikipedia.org/wiki/Toaster on a little detour through the donation process, and we return you there to a thank-you banner or similar [16:39:40] Fundraising-Backlog, fundraising-tech-ops: Setup civi access for Enloe Wilson - https://phabricator.wikimedia.org/T257256 (Dwisehaupt) [16:40:21] I think in the past there's been some privacy related reluctance to gather info on what specific articles donors are coming from. [16:40:38] Fundraising-Backlog, fundraising-tech-ops: Setup civi access for Enloe Wilson - https://phabricator.wikimedia.org/T257256 (Dwisehaupt) a:Dwisehaupt SSL client certificate created and sent via email. Password for certificate sent via SMS. Civicrm account created and new user email sent. [16:41:05] Fundraising-Backlog, fundraising-tech-ops: Setup civi access for Amy Parker - https://phabricator.wikimedia.org/T257255 (Dwisehaupt) a:Dwisehaupt SSL client certificate created and sent via email. Password for certificate sent via SMS. Civicrm account created and new user email sent. [16:41:26] Fundraising-Backlog, fundraising-tech-ops: Setup civi access for Amy Parker - https://phabricator.wikimedia.org/T257255 (Dwisehaupt) [16:41:42] XenoRyet: ah, that makes sense [16:43:28] yeah, you'd want to do it in a way that it is culled with the session and not captured with the user data. but that gets hard when looking at removing from logs and such. unless you get into a hashing scheme which complicates it even more. [16:44:43] rebooting to see if i can get 2 finger scrolling back on my trackpad. [16:44:44] Do the whole process in an iframe? /me ducks [16:45:12] fundraising-tech-ops: make kafkatee banner impression logs accessible from fundraising analytics server - https://phabricator.wikimedia.org/T257680 (Jgreen) [17:05:11] Jeff_Green: so the thing we attempted yesterday was to redirect through Wikipdia to set the cookie, and from there to donate.wikimedia.org. However it turns out that's a thing evil trackers do too, it's called bounce tracking, and it could get us blacklisted [17:05:25] Jeff_Green: however the t-y banner could work! I'll put that on the task as an option [17:17:13] PROBLEM - check_ipsec on frban1001 is CRITICAL: Strongswan CRITICAL - ok: 1 connecting: fran1001_v4 [17:17:25] Strongswan? [17:17:47] I've heard they can break your arm [17:19:03] https://habrastorage.org/getpro/habr/post_images/d3d/aaf/6f8/d3daaf6f8aff40b1681f868b619d020c.jpg [17:20:40] ok looks like that was a myth https://www.countrylife.co.uk/out-and-about/dogs/curious-questions-can-swan-really-break-arm-190943 [17:21:17] PROBLEM - check_puppetrun on fran1001 is CRITICAL: CRITICAL: Puppet has 1 failures. Last run 58 seconds ago with 1 failures. Failed resources (up to 3 shown): Mount[/srv/archive/banner_logs] [17:22:13] PROBLEM - check_ipsec on frban1001 is CRITICAL: Strongswan CRITICAL - ok: 1 connecting: fran1001_v4 [17:24:12] ACKNOWLEDGEMENT - check_puppetrun on fran1001 is CRITICAL: CRITICAL: Puppet has 1 failures. Last run 58 seconds ago with 1 failures. Failed resources (up to 3 shown): Mount[/srv/archive/banner_logs] Jeff_Green adjusting nfs config [17:24:52] ACKNOWLEDGEMENT - check_ipsec on frban1001 is CRITICAL: Strongswan CRITICAL - ok: 1 connecting: fran1001_v4 Jeff_Green adjusting nfs config [17:28:37] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising Sprint Grep works IRL, and 4 others: Implement redirect for hide banner cookie issue - https://phabricator.wikimedia.org/T251780 (AndyRussG) **One more option** (thanks to @J... [17:33:21] Fundraising Sprint Lazy Loading Life, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, and 3 others: Q4 FY2019/20 investigate export and upload issues with the silverpop export - https://phabricator.wikimedia.org/T253152 (KHaggard) Fre... [17:42:13] RECOVERY - check_ipsec on frban1001 is OK: Strongswan OK - 2 ESP OK [17:51:17] RECOVERY - check_puppetrun on fran1001 is OK: OK: Puppet is currently enabled, last run 24 seconds ago with 0 failures [17:58:55] fundraising-tech-ops: make kafkatee banner impression logs accessible from fundraising analytics server - https://phabricator.wikimedia.org/T257680 (Jgreen) [18:02:59] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising Sprint Grep works IRL, and 4 others: Implement redirect for hide banner cookie issue - https://phabricator.wikimedia.org/T251780 (Pcoombe) **Thank you banner** This certainly... [18:03:51] Seddon: I think it's only unsaved banner changes that require being logged in [18:04:12] this show up fine for me in an incognito window: https://en.wikipedia.org/wiki/NASA?banner=programmatic_mlWW_rsp_covid19&force=1&country=US [18:08:42] *shows [18:16:11] Fundraising-Backlog, fundraising-tech-ops: Setup civi access for Enloe Wilson - https://phabricator.wikimedia.org/T257256 (Dwisehaupt) [18:17:07] Fundraising-Backlog, fundraising-tech-ops: Setup civi access for Enloe Wilson - https://phabricator.wikimedia.org/T257256 (Dwisehaupt) Open→Resolved Verified access for Enloe via log files. Closing. [18:18:04] Fundraising-Backlog, fundraising-tech-ops: Setup civi access for Amy Parker - https://phabricator.wikimedia.org/T257255 (Dwisehaupt) [18:19:19] Fundraising-Backlog, fundraising-tech-ops: Setup civi access for Amy Parker - https://phabricator.wikimedia.org/T257255 (Dwisehaupt) Open→Resolved Worked with Amy on a meet call as her keychain was not accepting the cert via the application or command line. We loaded the certificate in firefox an... [18:25:24] AndyRussG: what do you think of that last suggestion on the ticket? set a cookie on *.wikimedia.org and have Special:BannerLoader from meta read it? [18:25:55] Would have to be a SameSite: none with Secure set [18:27:44] so that we can send it to meta.wikimedia.org [18:28:39] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising Sprint Grep works IRL, and 4 others: Implement redirect for hide banner cookie issue - https://phabricator.wikimedia.org/T251780 (AndyRussG) >>! In T251780#6297530, @Pcoombe... [18:31:02] ejegg: yes absolutely that's it [18:31:08] :) [18:31:42] so we do a quick bit of browser-sniffing on the TY page before we set it, to know whether the SameSite bit is supported [18:32:33] ejegg: ahhh right, I didn't fully understand how ell SameSite works, but yeah that sounds right [18:32:45] ejegg: gonna do some food consumption with my kids for a bit here, but yeah I think we can try to do that today [18:32:51] cool cool [18:33:02] unless there are some unforeseen objections, can't think of any though [18:33:25] fr-tech dstrine I think we have a solution, thanks so much pcoombe! ^ [18:56:08] fr-tech so the idea is to basically re-create the hide cookie parsing from hide.js inside of Special:BannerLoader [19:16:30] ejegg fr-tech So do we need any more investigation for this ^ solution? I can offer to code up something in Special:BannerLoader while others who know more about that side of things double-check the SameSite header stuff and try to get a sense of what proportion of supported browsers this'll work for? [19:17:19] AndyRussG: I'm playing with Special:BannerLoader a bit rn [19:17:33] Also, maybe it's a good time to seek Krinkle's input again? [19:17:43] ejegg: ah cool! want to jump on a video call? [19:18:04] sure - the daily meeting one from today? [19:18:11] okok yep! [19:18:12] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising Sprint Grep works IRL, and 4 others: Implement redirect for hide banner cookie issue - https://phabricator.wikimedia.org/T251780 (DStrine) It's great we are considering alter... [19:31:28] fundraising-tech-ops: make kafkatee banner impression logs accessible from fundraising analytics server - https://phabricator.wikimedia.org/T257680 (Jgreen) Open→Resolved [19:31:30] Fundraising-Backlog, fundraising-tech-ops, FR-Tech-Analytics: investigate moving non-essential databases (faulkner, pgehres, fredge) off of fundraising database cluster - https://phabricator.wikimedia.org/T255456 (Jgreen) [20:10:30] (CR) Jgleeson: [C: +2] "Working for me. Nice!" [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/611188 (https://phabricator.wikimedia.org/T253152) (owner: Eileen) [20:11:22] (Merged) jenkins-bot: Do an extra delete in case there was a timing issue [wikimedia/fundraising/tools] - https://gerrit.wikimedia.org/r/611188 (https://phabricator.wikimedia.org/T253152) (owner: Eileen) [20:16:05] dstrine: the best solution that we can think of still needs input and help from traffic team, fyi [20:17:27] (PS1) Jgleeson: Merge branch 'master' into deploy [wikimedia/fundraising/tools] (deploy) - https://gerrit.wikimedia.org/r/611419 [20:18:46] Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Nyan cats for everyone, Fundraising-Backlog, fundraising Sprint Grep works IRL, and 4 others: Implement redirect for hide banner cookie issue - https://phabricator.wikimedia.org/T251780 (Ejegg) @Pcoombe We started diving into this... [20:20:52] (CR) Jgleeson: [C: +2] Merge branch 'master' into deploy [wikimedia/fundraising/tools] (deploy) - https://gerrit.wikimedia.org/r/611419 (owner: Jgleeson) [20:21:05] (Merged) jenkins-bot: Merge branch 'master' into deploy [wikimedia/fundraising/tools] (deploy) - https://gerrit.wikimedia.org/r/611419 (owner: Jgleeson) [20:25:09] fr-tech I'm gonna deploy fundraising-tools to push out Eileen's latest silverpop export fix [20:26:17] !log updated fundraising-tools from 08ba1f6177 to f8e424fe32 [20:26:21] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [20:40:54] (PS2) Jgleeson: WIP: CiviCRM test fixes. This patch accompanies a mw-vagrant patch which fixes some default CiviCRM settings. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/602185 [20:47:11] (CR) jerkins-bot: [V: -1] WIP: CiviCRM test fixes. This patch accompanies a mw-vagrant patch which fixes some default CiviCRM settings. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/602185 (owner: Jgleeson) [20:56:11] Fundraising-Backlog, Epic: Q1 FY 20/21 epic for Q2 readiness - https://phabricator.wikimedia.org/T257707 (DStrine) [21:21:36] ejegg: just remembered that Special:BannerLoader does its own fancy stuff setting cache maxAge [21:22:25] but I guess what we can't ever control from php is what the front-end cache includes as part of the "key" for the item to cache [21:22:54] that is, whether the front-end-cache's "key" for the content is just the URL string, or the URL + a bit of the cookie [21:30:44] right [22:14:12] ok. the banner impressions processing has restarted. there are a few logs in the 20200710-19 and 20200710-20 hours that have been missed. is there a convenient way to backfill these? [22:19:45] ah. i think i found the answer.