[00:11:36] 10Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for rstearns - https://phabricator.wikimedia.org/T329130 (10Dwisehaupt) [00:19:31] (03CR) 10Damilare Adedoyin: [C: 04-1] "Thanks for the work on this, I did a few tests on the updated patch following your response and it the exception was still thrown. I added" [wikimedia/fundraising/tools/DjangoBannerStats] - 10https://gerrit.wikimedia.org/r/885435 (https://phabricator.wikimedia.org/T301905) (owner: 10Jgreen) [00:57:43] 10Fundraising Sprint Can't touch $this, 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Run some queries to find where our dupes are - https://phabricator.wikimedia.org/T328369 (10Eileenmcnaughton) a:03Eileenmcnaughton @shust I am looking in the DB & have put a couple of contacts that are dedupeabl... [02:46:53] 10Fundraising Sprint Can't touch $this, 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Run some queries to find where our dupes are - https://phabricator.wikimedia.org/T328369 (10Eileenmcnaughton) Am making temp tables with queries ` INSERT INTO eileen_temp_dupe_contacts SELECT c1.id, c1.first_nam... [03:58:11] !log payments-wiki upgraded from 53d1a58d to 61ea310d, config revision changed from 5e707565 to 4d90c211 [03:58:12] Logged the message at https://wikitech.wikimedia.org/wiki/Server_Admin_Log [05:07:02] 10Fundraising Sprint Can't touch $this, 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Run some queries to find where our dupes are - https://phabricator.wikimedia.org/T328369 (10Eileenmcnaughton) OK that create was way too slow - breaking it up INSERT INTO eileen_temp_dupe_pairs Select DISTINCT c1... [05:38:40] 10Fundraising Sprint Can't touch $this, 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Run some queries to find where our dupes are - https://phabricator.wikimedia.org/T328369 (10Eileenmcnaughton) INSERT INTO eileen_temp_dupe_pairs Select DISTINCT c1.id as id1, c2.id as id2, c1.first_name, c1.last_n... [05:58:38] (03PS6) 10AndyRussG: [WIP] jobs service [wikimedia/fundraising/dev] - 10https://gerrit.wikimedia.org/r/841441 (https://phabricator.wikimedia.org/T301905) [14:32:33] (03PS1) 10Jgleeson: Add dlocal TestGetPaymentStatus script [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/887788 (https://phabricator.wikimedia.org/T328963) [15:28:51] (03CR) 10Damilare Adedoyin: [C: 04-1] "As a follow on to my previous CR, kindly find another recommendation inline." [wikimedia/fundraising/tools/DjangoBannerStats] - 10https://gerrit.wikimedia.org/r/885435 (https://phabricator.wikimedia.org/T301905) (owner: 10Jgreen) [15:41:34] (03CR) 10Damilare Adedoyin: [C: 04-1] WIP: first pass at porting to python3 (031 comment) [wikimedia/fundraising/tools/DjangoBannerStats] - 10https://gerrit.wikimedia.org/r/885435 (https://phabricator.wikimedia.org/T301905) (owner: 10Jgreen) [16:01:56] Hi fr-tech, will we have the cross training today? [16:03:19] hi wfan hope you're feeling better today! [16:03:25] hmm I don't see anyone else in the meeting yet [16:18:08] (03PS1) 10Wfan: Add smashpig function to see if payment method use direct or indirect for createPayment [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/887799 (https://phabricator.wikimedia.org/T324276) [16:19:04] (03PS2) 10Wfan: Add smashpig function to see if payment method use direct or indirect for createPayment [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/887799 (https://phabricator.wikimedia.org/T324276) [16:26:53] 10Fundraising Sprint Can't touch $this, 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Run some queries to find where our dupes are - https://phabricator.wikimedia.org/T328369 (10SHust) @Eileenmcnaughton Thanks for the updates, I look forward to seeing what you might find :) [16:34:23] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10Patch-For-Review: GatewayChooser: No supported gateway for parameters - https://phabricator.wikimedia.org/T326666 (10AnnWF) @Pcoombe as discussed during today's meeting, we can use UZS for country UZ, and potentially check other countries that use RUB... [16:45:29] (03CR) 10Wfan: [C: 03+2] "LGTM, tested with the Maintaince script HealthCheck by update method name and param" [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/887313 (https://phabricator.wikimedia.org/T328963) (owner: 10Jgleeson) [16:49:19] 10Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for ppenloglou - https://phabricator.wikimedia.org/T328984 (10Dwisehaupt) SSL certificate renewed and sent via email. Password sent via SMS. [16:56:02] thanks for the review wfan ! [17:01:31] (03CR) 10Wfan: "LGTM, just a suggestion which we might want to add another unit test with other status https://docs.dlocal.com/reference/payment-status-co" [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/887345 (https://phabricator.wikimedia.org/T328963) (owner: 10Jgleeson) [17:10:28] 10Fundraising Sprint Can't touch $this, 10Fundraising-Backlog, 10FR-Smashpig, 10FR-dlocal, 10MediaWiki-extensions-DonationInterface: Implement 3DSecure for DLocal cards - https://phabricator.wikimedia.org/T324302 (10jgleeson) a:05jgleeson→03None [17:11:02] 10Fundraising Sprint Can't touch $this, 10Fundraising-Backlog, 10FR-Smashpig, 10FR-dlocal: Update DLocal createPayment for UPI / DIRECT method - https://phabricator.wikimedia.org/T324294 (10AnnWF) a:03AnnWF [17:41:21] 10Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for nngu - https://phabricator.wikimedia.org/T328994 (10Dwisehaupt) SSL certificate renewed and sent via email. Password sent via SMS. [17:45:16] 10Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for jkim - https://phabricator.wikimedia.org/T328823 (10Dwisehaupt) SSL certificate renewed and sent via email. Password sent via SMS. [17:47:58] 10Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for ejohnston - https://phabricator.wikimedia.org/T328990 (10Dwisehaupt) SSL certificate renewed and sent via email. Password sent via SMS. [18:20:16] (03PS7) 10AndyRussG: [WIP] jobs service [wikimedia/fundraising/dev] - 10https://gerrit.wikimedia.org/r/841441 (https://phabricator.wikimedia.org/T301905) [18:24:40] damilare: ^ added a script to refresh the database, including populating the country table [18:25:07] Thanks AndyRussG, I'd check it out [18:25:23] for my next batch of tests [18:25:55] okii thank u! :) see the etherpad for details. Also on the etherpad is a one-liner to create a log file for testing with just the last n lines of another log file [18:28:24] awesome! [18:44:32] ooops it didn't like that new filename [18:47:10] 10fundraising-tech-ops, 10FR-Tech-Analytics: superset_query_deathray No Longer Running - https://phabricator.wikimedia.org/T329208 (10Dwisehaupt) 05Open→03Resolved a:03Dwisehaupt All fixed and deployed. `[frack::puppet] 319ce404 Update superset_query_deathray to set python version` [18:59:00] damilare: updated the etherpad one-liners for creating test log files, since the filename format must be preserved. apparently they work now ;) [19:00:16] ohh I haven't checked it yet as we are just leaving the dlocal meeting [19:05:36] ah oki yeah it turns out you can't get creative with the log filenames heh [19:07:26] ohh I haven't checked it yet as we are just leaving the dlocal meetingnah I think it uses it to differentiate which is banner or landingpages [19:08:56] also to note, with just the 100-line samples I created, I didn't see the Language object error you mentioned on Gerrit, but I haven't dug in in detail to try to understand why or how to reproduce it [19:09:30] still if you have a sample log line (remember to redact IP and user agent) to reproduce it easily on hand that might be helpful? thx in advance :) [19:11:47] hmmm I got the error with this command [19:12:13] /srv/django-banner-stats/manage.py LoadBannerImpressions2Aggregate --verbose --file="/srv/archive/banner_logs/2022/beaconImpressions-samplefile [19:12:33] It didn't break with the other cmd and landing page [20:01:29] 10Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for sharonr - https://phabricator.wikimedia.org/T328722 (10Dwisehaupt) SSL certificate renewed and sent via email. Password sent via SMS. [20:22:22] damilare: hmmm that filename i think would break in any case? [20:23:53] see LoadBannerImpressions2Aggregate.py line 124, squid_log.timestamp = squid_log.filename2timestamp() [20:24:17] or maybe when you ran it you did have a different file with a valid filename? [20:24:47] no those were filenames [20:25:04] beaconImpressions* and landingpages.tsv* [20:26:03] oh with the wildcard that's ok [20:26:27] so long as the script can parse the fn [20:27:14] oh no I was just tooo lazy to type the entire file name [20:51:46] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10Patch-For-Review: GatewayChooser: No supported gateway for parameters - https://phabricator.wikimedia.org/T326666 (10Pcoombe) Thanks @AnnWF, I updated Uzbekistan to use UZS https://donate.wikimedia.org/?country=UZ Also found Turkmenistan was using RU... [20:58:27] 10Fundraising Tech - Chaos Crew, 10Fundraising-Backlog, 10Patch-For-Review: GatewayChooser: No supported gateway for parameters - https://phabricator.wikimedia.org/T326666 (10AnnWF) >>! In T326666#8599465, @Pcoombe wrote: > Thanks @AnnWF, I updated Uzbekistan to use UZS https://donate.wikimedia.org/?country=... [21:37:39] (03PS2) 10Jgleeson: Add dlocal TestGetPaymentStatus script [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/887788 (https://phabricator.wikimedia.org/T328963) [21:37:41] (03PS1) 10Jgleeson: Add tests for dlocal getPaymentStatus failure [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/887834 (https://phabricator.wikimedia.org/T328963) [21:38:33] 10Fundraising-Backlog, 10fundraising-tech-ops: Issue new SSL Client Certificate for dbautista - https://phabricator.wikimedia.org/T328985 (10Dwisehaupt) SSL certificate renewed and sent via email. Password sent via SMS. [21:40:44] (03PS16) 10Jgreen: WIP: first pass at porting to python3 [wikimedia/fundraising/tools/DjangoBannerStats] - 10https://gerrit.wikimedia.org/r/885435 (https://phabricator.wikimedia.org/T301905) [21:41:04] (03CR) 10CI reject: [V: 04-1] WIP: first pass at porting to python3 [wikimedia/fundraising/tools/DjangoBannerStats] - 10https://gerrit.wikimedia.org/r/885435 (https://phabricator.wikimedia.org/T301905) (owner: 10Jgreen) [21:44:14] (03CR) 10Jgleeson: "Thanks for the review Wfan! I responded inline." [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/887345 (https://phabricator.wikimedia.org/T328963) (owner: 10Jgleeson) [21:45:11] (03CR) 10Wfan: [C: 03+2] "Awesome! looks good then :P" [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/887345 (https://phabricator.wikimedia.org/T328963) (owner: 10Jgleeson) [21:45:14] (03PS17) 10Jgreen: WIP: first pass at porting to python3 [wikimedia/fundraising/tools/DjangoBannerStats] - 10https://gerrit.wikimedia.org/r/885435 (https://phabricator.wikimedia.org/T301905) [21:45:34] (03CR) 10CI reject: [V: 04-1] WIP: first pass at porting to python3 [wikimedia/fundraising/tools/DjangoBannerStats] - 10https://gerrit.wikimedia.org/r/885435 (https://phabricator.wikimedia.org/T301905) (owner: 10Jgreen) [21:46:05] 10Fundraising Sprint Can't touch $this, 10Fundraising-Backlog, 10FR-Smashpig, 10FR-dlocal, 10MediaWiki-extensions-DonationInterface: Implement 3DSecure for DLocal cards - https://phabricator.wikimedia.org/T324302 (10jgleeson) a:03jgleeson [21:47:24] (03PS18) 10Jgreen: WIP: first pass at porting to python3 [wikimedia/fundraising/tools/DjangoBannerStats] - 10https://gerrit.wikimedia.org/r/885435 (https://phabricator.wikimedia.org/T301905) [21:47:29] (03CR) 10Wfan: [C: 03+2] Add tests for dlocal getPaymentStatus failure [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/887834 (https://phabricator.wikimedia.org/T328963) (owner: 10Jgleeson) [21:48:07] thanks wfan :) [21:52:17] (03CR) 10Wfan: [C: 03+2] "The script it self looks nice, similar to the one I tested for HealthCheck haha, tested with php PaymentProviders/dlocal/Maintenance/TestG" [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/887788 (https://phabricator.wikimedia.org/T328963) (owner: 10Jgleeson) [21:53:13] (03CR) 10Wfan: [C: 03+2] Remove array that is immediately overwritten [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/887315 (owner: 10Jgleeson) [21:53:45] (03Merged) 10jenkins-bot: Remove array that is immediately overwritten [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/887315 (owner: 10Jgleeson) [21:55:36] (03CR) 10Wfan: [C: 03+2] Add dlocal cash PaymentProvider config [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/886886 (https://phabricator.wikimedia.org/T324291) (owner: 10Jgleeson) [21:56:18] (03Merged) 10jenkins-bot: Add dlocal cash PaymentProvider config [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/886886 (https://phabricator.wikimedia.org/T324291) (owner: 10Jgleeson) [21:56:22] (03Merged) 10jenkins-bot: Add dlocal API getPaymentStatus call [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/887313 (https://phabricator.wikimedia.org/T328963) (owner: 10Jgleeson) [21:56:28] (03Merged) 10jenkins-bot: Add dlocal PaymentProvider getLatestPaymentStatus call [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/887345 (https://phabricator.wikimedia.org/T328963) (owner: 10Jgleeson) [21:56:30] (03Merged) 10jenkins-bot: Add tests for dlocal getPaymentStatus failure [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/887834 (https://phabricator.wikimedia.org/T328963) (owner: 10Jgleeson) [21:56:34] (03Merged) 10jenkins-bot: Add dlocal TestGetPaymentStatus script [wikimedia/fundraising/SmashPig] - 10https://gerrit.wikimedia.org/r/887788 (https://phabricator.wikimedia.org/T328963) (owner: 10Jgleeson) [22:01:31] thanks so much wfan !!!! [22:01:52] I'll return the favour first thing tomorrow and finish review on your config check patch [22:02:19] Ah thanks have a good night I might needs to update that a bit, no worry [22:02:21] also. I think we are going to switch the UPI ticket from DIRECT to REDIRECT but we can confirm with Evelyn tomorrow [22:02:38] We talked so much on today's call that I forgot to bring it up [22:03:10] we could have a call tomorrow if you like to talk through it and the likely changes needed [23:53:56] 10Fundraising Sprint Can't touch $this, 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Run some queries to find where our dupes are - https://phabricator.wikimedia.org/T328369 (10Eileenmcnaughton) OK running the above for BETWEEN 2000000 AND 3000000 found an insane number & seems to be a data issue.... [23:59:41] 10Fundraising Sprint Can't touch $this, 10Fundraising-Backlog, 10Wikimedia-Fundraising-CiviCRM: Run some queries to find where our dupes are - https://phabricator.wikimedia.org/T328369 (10Eileenmcnaughton) OK 1927 contacts with a last name of '.' - will remove those dots