[00:02:26] <bd808>	 Krenair: there are some worries about tools having hard coded http resource links I think
[00:02:42] <bd808>	 so mixed content warning/nothing renders
[06:27:16] <zhuyifei1999_>	 jynus: could you clarify the difference between `VARCHAR(255) BINARY` and `VARBINARY(255)`? I'm getting `ERROR 1071 (42000) at line 3: Specified key was too long; max key length is 767 bytes` if I try to create the quarry table with utf8mb4 with the former
[08:06:30] <wikibugs_>	 (03PS1) 10Giuseppe Lavagetto: Add mock CA infrastructure for mcrouter [labs/private] - 10https://gerrit.wikimedia.org/r/436738
[08:07:13] <wikibugs_>	 (03CR) 10Giuseppe Lavagetto: [V: 032 C: 032] Add mock CA infrastructure for mcrouter [labs/private] - 10https://gerrit.wikimedia.org/r/436738 (owner: 10Giuseppe Lavagetto)
[09:46:44] <DatGuy>	 Getting https://i.imgur.com/nYMe0oE.png when trying to ssh in with WinSCP
[09:50:10] <jynus>	 I got this https://winscp.net/eng/docs/message_unexpected_close
[09:51:21] <arturo>	 to which host?
[10:00:57] <DatGuy>	 login.tools.wmflabs.org
[10:02:16] <DatGuy>	 found it. had shell set to sudo su - instead of default
[10:02:21] <arturo>	 DatGuy: what's your username?
[10:02:35] <arturo>	 oh, ok
[10:22:55] <zhuyifei1999_>	 jynus: you saw my message ~4hrs go?
[10:24:40] <jynus>	 no
[10:24:43] <jynus>	 but I see it now
[10:25:42] <jynus>	 utf8mb4 uses up to 4 byes per lenght
[10:25:50] <jynus>	 binary uses 1 byte per length
[10:26:11] <jynus>	 if that goes over the limit on a non-dynamic table
[10:26:16] <jynus>	 it complains
[10:26:16] <zhuyifei1999_>	 so VARCHAR(255) BINARY would be 255*4 bytes long?
[10:26:36] <jynus>	 it depends on the actual charset used
[10:26:46] <zhuyifei1999_>	 what's the significance if 'BINARY' in this case?
[10:26:50] <jynus>	 no idea
[10:27:04] <zhuyifei1999_>	 hmm
[10:27:05] <jynus>	 I guess it is a collation?
[10:27:08] <jynus>	 I don't know
[10:27:17] <jynus>	 I degine charset on db, table or with charset
[10:28:02] <jynus>	 alternatively, you may use larger indexes up to 30XX byes with large_prefix_index
[10:28:19] <jynus>	 (depends on your configuration and how that the table is defined)
[10:28:42] <zhuyifei1999_>	 (googling)
[10:31:33] <zhuyifei1999_>	 https://github.com/wikimedia/mediawiki/blob/master/maintenance/tables.sql#L63 mediawiki uses `varchar(255) binary` just fine
[10:32:26] <jynus>	 yes, but it setups the charset on the table creation
[10:33:14] <zhuyifei1999_>	 does mediawiki use utf8mb4?
[10:33:29] <zhuyifei1999_>	 it doesn't seem to be defined in tables.sql
[10:33:58] <jynus>	 no
[10:34:02] <jynus>	 it uses binary
[10:34:15] <zhuyifei1999_>	 like charset=binary?
[10:34:19] <jynus>	 yes
[10:34:35] <jynus>	 $wgDBTableOptions = "ENGINE=InnoDB, DEFAULT CHARSET=binary";
[10:34:39] <zhuyifei1999_>	 ok
[10:34:46] <jynus>	 ^
[10:35:28] <jynus>	 if 767 bytes is too small, you can allways use dynamic row format, too
[10:35:46] <jynus>	 e.g. https://gerrit.wikimedia.org/r/#/c/436592/
[10:36:03] <zhuyifei1999_>	 seems quite a log if stuffs needed to get that work https://stackoverflow.com/a/43403017
[10:36:30] <zhuyifei1999_>	 (looking)
[10:37:29] <jynus>	 "Beginning with 5.7.7, the system defaults correctly to handle larger fields."
[10:37:39] <jynus>	 I think on mariadb 10.3, too
[10:37:52] <jynus>	 but we are not yet there, so it is messy right now
[10:39:38] <zhuyifei1999_>	 I don't think quarry servers have new mariadbs
[10:41:07] <zhuyifei1999_>	 I guess I'm going with changing the charset to binary
[10:41:20] <jynus>	 it is possible, it is just requires more configuration
[11:03:13] <paladox>	 jynus: heh mariadb 10.3 recently became stable, it’s on homebrew now :)
[11:07:04] <jynus>	 They saying 10.3 is stable and actually being is a different thing
[11:18:30] <paladox>	 Konversation?
[11:18:41] <paladox>	 Is that Conversation?
[11:19:18] <paladox>	 jynus: yep though I did have a problem once I upgraded
[11:19:28] <paladox>	 Two of the variable were removed
[11:19:41] <paladox>	 Causing it to fail to start unless I removed them
[11:19:53] <paladox>	 But they became default values anyways
[11:19:59] <jynus>	 oh, that is normal
[11:20:15] <jynus>	 the problem is the issues you didn't notice, do you know those?
[11:21:10] <paladox>	 Um nope
[11:21:20] <paladox>	 It started which what mattered to me :)
[11:21:42] <jynus>	 that is because there are know unknowns, and unknow unknowns :-)
[11:21:57] <paladox>	 But homebrew does not install this mariadb on a Mac like Linux so I have to go searching for logs
[11:22:00] <paladox>	 Lol
[11:22:12] <jynus>	 if you have a single database you have 1 problem
[11:22:26] <paladox>	 I have a ton
[11:22:29] <jynus>	 but if you have like me, 200 databases, you have 200 problems
[11:22:30] <paladox>	 Phabricator
[11:22:35] <paladox>	 And terror 
[11:22:41] <paladox>	 Terror = gerrit 
[11:22:44] <paladox>	 Auto spell
[11:23:38] <jynus>	 so I am happy you are beta testing mariadb for me
[11:23:53] <jynus>	 I will upgrade when you have run into all the bugs :-)
[11:23:58] <paladox>	 Lol
[11:24:47] <paladox>	 I’ve been running 10.2 for quite some time too
[11:25:04] <jynus>	 we will skip 10.2 completely
[11:25:10] <paladox>	 Let’s hope java 9 won’t come to homebrew anytime soon otherwise I’m buggered 
[11:25:28] <jynus>	 we have a test host on 8.0
[11:25:41] <jynus>	 and I guess will create a mariadb package from 10.3 too
[11:25:59] <paladox>	 MySQL 8.0?
[11:26:00] <jynus>	 I want to have options
[11:26:02] <jynus>	 yes
[11:26:10] <paladox>	 Wow I wonder what is new to make that big bump
[11:26:18] <jynus>	 marketing
[11:26:19] <paladox>	 8 years since 2010
[11:26:43] <jynus>	 there are cool features on both releases
[11:27:04] <paladox>	 jynus: I did run mariadb 10.2 in labs on a gerrit-mysql host but it just broke
[11:27:10] <paladox>	 I found way to many bugs
[11:27:15] <paladox>	 (2 at least)
[11:27:19] <paladox>	 Year ago or 2
[11:27:27] <jynus>	 which is why we wait
[11:27:36] <jynus>	 databases need mainly 2 things
[11:27:37] <paladox>	 A lib problem
[11:27:39] <jynus>	 write data
[11:27:41] <jynus>	 and read data
[11:27:47] <paladox>	 Then php-mysql causing segfaulta
[11:27:51] <paladox>	 Segfaulta
[11:28:00] <paladox>	 Segfaults
[11:28:11] <paladox>	 But I think it’s stable now
[11:28:16] <paladox>	 So may upgrade to it 
[11:28:26] <paladox>	 Again
[11:28:50] <paladox>	 I did here that mariadb has sequence mode now
[11:28:55] <paladox>	 Like PostgreSQL 
[11:30:30] <addshore>	 is php7 possible for a tool webservice yet? :/
[11:37:28] * addshore makes https://phabricator.wikimedia.org/T196155
[11:50:48] <arturo>	 addshore: would it be better in the grid or in kubernetes?
[11:51:05] <addshore>	 no preference :)
[11:51:45] <addshore>	 web tools running in kubernetes can still save tmp files right? ;) (my single dumb check) :D
[12:09:07] <addshore>	 aaah arturo https://phabricator.wikimedia.org/T195691 is the blocker
[12:09:58] <arturo>	 oh I see
[12:10:16] <arturo>	 then please interlink or delete T196155
[12:10:17] <stashbot>	 T196155: Request php7 tool forge webservice - https://phabricator.wikimedia.org/T196155
[14:06:17] <addshore>	 arturo: already done
[21:16:00] <addshore>	 wow, it has been quiet in here today
[21:28:21] <hare>	 it's friday :]
[21:49:04] <wikibugs_>	 (03PS1) 10Krinkle: Add more Gerrit repos to #wikimedia-perf-bots [labs/tools/wikibugs2] - 10https://gerrit.wikimedia.org/r/436926
[22:10:22] <wikibugs_>	 (03CR) 10Krinkle: [C: 032] Add more Gerrit repos to #wikimedia-perf-bots [labs/tools/wikibugs2] - 10https://gerrit.wikimedia.org/r/436926 (owner: 10Krinkle)
[22:10:49] <wikibugs_>	 (03Merged) 10jenkins-bot: Add more Gerrit repos to #wikimedia-perf-bots [labs/tools/wikibugs2] - 10https://gerrit.wikimedia.org/r/436926 (owner: 10Krinkle)
[22:10:58] <wikibugs_>	 (03CR) 10jenkins-bot: Add more Gerrit repos to #wikimedia-perf-bots [labs/tools/wikibugs2] - 10https://gerrit.wikimedia.org/r/436926 (owner: 10Krinkle)
[22:55:37] <bd808>	 !log matrix Added BryanDavis (self) as projectadmin
[22:55:38] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Matrix/SAL
[23:02:35] <bd808>	 !log matrix Usurped empty project for T193964. Added Chico Venancio, Cicalese, Gergő Tisza, and MarkAHershberger as admins
[23:02:36] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Matrix/SAL
[23:02:36] <stashbot>	 T193964: Request creation of matrix VPS project - https://phabricator.wikimedia.org/T193964