[14:00:54] Technical Advice IRC meeting starting in 60 minutes in channel #wikimedia-tech, hosts: @amir1 & @ottomata - all questions welcome, more infos: https://www.mediawiki.org/wiki/Technical_Advice_IRC_Meeting [14:38:07] Hi All, I'm using a VPS and trying to create a unix user account for my app, but it wont allow me to do `newaccount@localhost` to become that newaccount. How do others create app-specific accounts on VPSs? Thanks in advance. [14:39:50] notconfusing: what do you mean by 'become that account'? sudo? [14:50:53] Technical Advice IRC meeting starting in 10 minutes in channel #wikimedia-tech, hosts: @amir1 & @ottomata - all questions welcome, more infos: https://www.mediawiki.org/wiki/Technical_Advice_IRC_Meeting [15:03:36] zhuyifei1999_: sorry. i mean that doing `ssh newaccount@localhost` fails (both with password and public key authentication). i could use `sudo su newaccount` but then if i run a screen session i would be "root" not "newaccount" in the screen session. [15:04:20] `sudo -- sudo -iu newaccount` [15:04:35] ^ that should get you to the account [15:04:54] idk if ssh would work, never tried that [15:27:25] notconfusing: screen with sudo can be a pain, tmux is similar to screen (different keybindings, ctrl+b default leader) but it should work better for you. [15:28:38] thanks zhuyifei1999_ , jeh I'll look into tmux/sudo thanks for the tip. [15:38:54] np [18:42:55] !help hello all, I have been running bash scripts successfully in my tomthirteen@tools-login.wmflabs.org. I have been using | tee, so whenever there was an error, it would just save the error to an output file and keep running. Now, it [18:42:55] tee, so whenever there was an error, it would just save the error to an output file and keep running. Now, it: tomthirteen: If you don't get a response in 15-30 minutes, please create a phabricator task -- https://phabricator.wikimedia.org/maniphest/task/edit/form/1/?projects=wmcs-team [18:43:30] it raises exceptions constantly and stops the script. Its very weird [18:47:51] tomthirteen: the first step is probably to produce a minimal example (like a 1-line bash script) that exhibits the change [18:49:20] i've tried. it's everything. I've used this same script with a different file, and it worked fine. Now it's constant errors. it's the file Im assuming, but I don't understand. [18:52:48] show me [18:59:15] thank you one sec [19:00:23] https://imgur.com/a/T8XUHIu [19:00:59] andrewbogott: when I run this as a bash I get -bash: revision3.txt: line 10: unexpected EOF while looking for matching `"'-bash: revision3.txt: line 11: syntax error: unexpected end of file [19:01:31] but I don't understand because these are a few lines from the very same script that runs just fine [19:03:54] I can't be sure but it looks like you have some quoting issues. For example I see three " marks in the first line I think? [19:04:08] andrewbogott I understand there are apostrophes in line 1 and 2, but usually when this happens it saves the error message to the output file and keeps working. now the whole script just stops [19:06:26] hmmm ok i took out the first two lines and now it works. i don't understand why this type of error would not crash the script before but now it does [19:08:13] When will this be deployed? https://phabricator.wikimedia.org/T227508 [19:08:26] tomthirteen: It's hard for me to know in this particular case. If you have 'set -e' that would definitely make it exit on any error [19:09:40] i don't believe there's an -e [19:27:50] gyan: I'm working on it. My QA environment for that application is busted, so I have to get that fixed first [19:29:05] gyan: I can manually create a git repo for you to get your project unblocked [20:40:42] Hello! Is there any plan for upgrading mariadb-servers? Asking because of recursive queries, which could be more than useful for category-trees. https://mariadb.com/kb/en/library/recursive-common-table-expressions-overview/ [20:45:34] Wurgl: Hey. There's currently work to move production to MariaDB 10.3: https://phabricator.wikimedia.org/T193224 I imagine that if we're OK with the performance characteristics of 10.3, we'll upgrade the whole fleet, and WMCS servers will be part of that. [20:46:00] Great! [20:46:02] Thanks [20:46:23] But no timeline, sorry. [20:46:27] The Quarry server ist the one. [20:46:43] I have no problem with a missing timeline [20:46:48] Yeah, I imagine that would benefit. [20:47:44] In scripts I can hack away that recursive problem, but not with quarry … (at least I do not know a way) [21:10:21] I would put more money on MySQL 8 than MariaDB 10.3, but time will tell [21:19:19] * James_F nods. [21:30:27] bd808: The wikimedia software is free software, it might be a licence problem to use a commercial product. And what bothers me more: When we run mysql and thousand of other wikis run mariadb … the chance is huge, that these wikis have errors we never experiance [21:39:49] Wurgl: both have FOSS and non-FOSS versions. Indications from MariaDB are that they are going more open core in the future (pay for 'enterprise' features) [21:40:46] sadly a lot of commercial FOSS projects are running to the open core model [21:41:15] or even worse, making up their own license