[08:55:53] (03PS1) 10Alexandros Kosiaris: cxserver: Add lingocloud key [labs/private] - 10https://gerrit.wikimedia.org/r/455779 [11:04:26] !log admin T202549 eqiad1 databases are all now running in m5-master. Mysql has been cleaned from cloudcontrol100[3,4] [11:04:28] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Admin/SAL [11:04:29] T202549: cloudvps: eqiad1: move nova db to m5-master - https://phabricator.wikimedia.org/T202549 [15:30:12] anomie: quick question, what var type do you use to store usernames in the MW DB? [15:31:34] https://github.com/wikimedia/mediawiki/blob/master/maintenance/tables.sql#L63 [15:31:57] Cyberpower678: varchar(255) binary is what's in tables.sql. The live DBs say varbinary(255), I forget whether there's a very minor difference or if they're identical. [15:32:47] Well Varchar is not working for my DB as it's corrupting non-latin usernames. So I'm altering the table to fix that. [15:33:00] * anomie thinks there might be some difference in default collation or something, which doesn't matter for us since we use "binary" collation too. [15:33:51] anomie: do you know if altering the table from varchar to varbinary requires me dumping the table first, or will it successfully convert? [15:34:29] Cyberpower678: If you're going to use non-binary varchar, you'd need to make sure to use the utf8mb4 character set. And likely a binary collation of some sort, to avoid potential weirdness with stuff like "ß" and "ss" being considered the same (note I don't know if that specific example would actually be affected) [15:35:09] Cyberpower678: It shouldn't require a dump in MySQL, but it could be slow and/or take a bunch of disk space if the table is large. [15:35:31] "ß" and "ss" are the same though. [15:35:55] No, it isn't. It's just a basic user table [15:37:19] varchar(255) with binary gets interpreted as varbinary [15:37:51] as in, running the first will show the second [15:37:58] "ß" is one character U+00DF (or two bytes in UTF-8, 0xc3 0x9f), while "ss" is two U+0073 (or two bytes, 0x73 0x73). Depending on the collation they might or might not be considered the same. MediaWiki generally assumes they won't be. [15:38:20] yes, binary charset implies binary collation [15:38:39] but you can have non-binary collation on non-binary charsets too [15:39:12] doing as anomie says [15:39:50] the main issue is that usually mysql is lagging on implementing the latest unicode standards [15:40:09] so you want to use a recent mysql or mariadb version for non-binary collations [15:40:20] e.g. 10.3 or 8.0 [15:47:22] jynus: MariaDb [15:47:26] is what IABot uses. [15:47:49] I think I'll just convert it varbinary, as long as I can still index it. [15:47:50] same applies [15:48:19] it may be better because some plugins are not compatible with utf8mb4 [15:49:02] (they are compatible, but needs extra config due to character/byte size [16:01:39] !log graphql Created project and set dbarratt and tpt as admins (T202603) [16:01:41] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Graphql/SAL [16:01:41] T202603: Request creation of graphql VPS project - https://phabricator.wikimedia.org/T202603 [16:01:44] (03CR) 10Lokal Profil: "did you revert the dev/test change or is my gerrit just confused?" [labs/tools/heritage] - 10https://gerrit.wikimedia.org/r/455015 (owner: 10Jean-Frédéric) [16:04:09] (03CR) 10Lokal Profil: "> Patch Set 3:" [labs/tools/heritage] - 10https://gerrit.wikimedia.org/r/455015 (owner: 10Jean-Frédéric) [16:05:23] (03CR) 10Lokal Profil: "> Patch Set 3:" [labs/tools/heritage] - 10https://gerrit.wikimedia.org/r/455015 (owner: 10Jean-Frédéric) [17:37:26] !log antiharassment Created project and set dbarratt, dmaza, and aezell as admins (T202675) [17:37:29] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Antiharassment/SAL [17:37:29] T202675: Request creation of antiharassment VPS project - https://phabricator.wikimedia.org/T202675 [19:03:51] jynus: anomie: Thanks for the help. Fixed all of my problems for Russian and Bengali users. :-) [20:41:22] (03PS3) 10Jean-Frédéric: Bump pywikibot to latest version 3.0.20180823 [labs/tools/heritage] - 10https://gerrit.wikimedia.org/r/455016 (https://phabricator.wikimedia.org/T202378) [20:44:19] (03CR) 10Jean-Frédéric: "> did you revert the dev/test change or is my gerrit just confused?" [labs/tools/heritage] - 10https://gerrit.wikimedia.org/r/455015 (owner: 10Jean-Frédéric) [20:46:11] (03PS5) 10Jean-Frédéric: Use Pipenv to manage requirements [labs/tools/heritage] - 10https://gerrit.wikimedia.org/r/455015 [21:26:15] Hello Cloud people, what does Stephane (sbisson) need to do to make himself exist in Toolforge? I'm trying to add him as a maintainer for a project, but his name isn't coming up in the suggestions [21:31:29] RoanKattouw: does he have a developer (LDAP/wikitech/gerrit) account? [21:31:32] think? [21:34:22] Yes [21:34:41] He has a Gerrit account at least, that he's submitted patches through, and he shows up in Special:Listusers on wikitech [21:34:49] krenair@bastion-01:~$ id sbisson [21:34:50] uid=11999(sbisson) gid=500(wikidev) groups=1003(wmf),50062(project-bastion),50120(project-deployment-prep),500(wikidev) [21:34:54] needs adding to tools [21:35:16] How do I do that? I tried to find documentation about that but failed [21:35:31] oh, he should request through striker [21:35:36] https://toolsadmin.wikimedia.org/ [21:35:45] he can log into that with his SUL account