[10:38:00] !log openstack add `arturo-k8s-test` puppet prefix and switch all VMs to the project puppetmaster: `openstack-puppetmaster-01` [10:38:01] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Openstack/SAL [11:22:31] !log openstack test with SANs hiera keys in the `arturo-k8s-test` puppet prefix [11:22:32] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Openstack/SAL [16:43:01] Puppet hasn't run on one of my instances for a week; `puppet agent --test` says that the certificate from the master doesn't match the agent's private key. Is this a known general issue? [16:44:46] what instance is it? [16:45:00] not aware of any known general issues in this area [16:45:35] Krenair: visualeditor-test2.visualeditor.eqiad.wmflabs [16:46:42] it should just be using the ordinary central master right? [16:47:06] what does `grep server /etc/puppet/puppet.conf` say its actually trying to talk to? [16:47:23] labs-puppetmaster.wikimedia.org [16:47:44] should work... [16:48:07] dont know why it would have a different cert [16:48:12] It wants me to delete the certificate for ve-test2 on the puppet master. [16:48:24] Which I'm pretty sure I shouldn't have access to. [16:48:29] okay well you can't do that [16:48:33] Yeah. [16:48:34] but [16:49:00] you might be able to delete/move the copy of the certs on the client and get it to generate new keys/certs etc. [16:49:24] it is autosigning so the server will probably accept the new one as a replacement [16:49:42] No, it gives parallel client and server instructions; when I ran the client-side deletion, it re-generated a client cert and then failed again. [16:49:55] bah [16:50:02] andrewbogott? [16:50:04] https://www.irccloud.com/pastebin/ulQNd3u5/ [16:50:11] I don't currently have access to that [16:50:35] ohhhh wait [16:50:41] James_F, you need to run puppet as root [16:51:02] Ha, of course I do. [16:51:25] you'll hopefully find a different error [16:51:55] James_F: I'm doing a bunch of things at once right now, but I can poke at it [16:52:00] Notice about requires_os dropping a reference to Trusty. Otherwise it worked fine. Odd. [16:52:10] ok, so, nevermind? [16:52:49] Maybe? If I keep getting auto-nags that puppet has failed I'll come back. :-) [16:54:03] works for me! [22:48:57] Hello all. Could someone tell me how to run bash commands now in @tools [22:50:07] I was able to run a bash file with commands like this, but now I just get command not found: sql enwiki_p 'select * from logging where log_title = "A.S._Roma" and log_namespace = 0 and log_timestamp > 20160101000 and log_act [22:50:36] n = "move"' > A.S._Roma.txt; [23:05:32] tomthirteen_, well there is definitely an sql command in tools [23:05:34] tomthirteen_, what host are you on? [23:07:28] Thank you, Krenair [23:07:44] I am tomthirteen@tools-login.wmflabs.org [23:08:25] which leads you to tools-sgebastion-07 right? [23:08:48] yes, that's right [23:09:06] krenair@tools-sgebastion-07:~$ sql enwiki_p 'select * from logging where log_title = "A.S._Roma" and log_namespace = 0 and log_timestamp > 20160101000 and log_actn = "move"' [23:09:07] ERROR 1054 (42S22) at line 1: Unknown column 'log_actn' in 'where clause' [23:09:53] I can't get any bash to work [23:10:06] tomthirteen_, please send a screenshot [23:10:11] tom29739: what error does it give you? [23:10:19] oops, nvm [23:10:31] even sql enwiki_p "select * from logging limit 100" > example.txt doesn't work [23:10:41] Please send a screenshot. [23:11:50] For this sql enwiki_p "select * from logging limit 100" > example.txt; [23:12:06] I get [23:12:22] How do I send a screenshot? [23:12:35] -bash: sql: command not found -bash: select * from logging limit 100: command not found [23:16:34] tomthirteen_, sounds like maybe you have a semi-colon or something after the sql part [23:16:43] take screenshot, save to file [23:16:49] upload file to some image host [23:16:58] ok [23:17:02] like imgur.com [23:17:03] send link to file [23:21:58] tomthirteen_? [23:22:09] One sec. Sorry [23:23:55] Krenair > https://imgur.com/a/6seVoBU [23:24:48] wow [23:25:06] that version of windows [23:25:08] ok [23:25:39] what's the content of that file? [23:26:49] because this works for me: [23:26:50] krenair@tools-sgebastion-07:~$ cat blocked_test.txt [23:26:50] sql enwiki 'select * from logging limit 100' [23:26:50] krenair@tools-sgebastion-07:~$ source blocked_test.txt [23:26:50] +--------+----------+------------+----------------+----------+-----------+---------------+-----------------------------------------------------+----------------+------------+-------------+---------------+----------+ [23:26:51] | log_id | log_type | log_action | log_timestamp | log_user | log_actor | log_namespace | log_title | log_comment_id | log_params | log_deleted | log_user_text | log_page | [23:28:35] Krenair > https://imgur.com/a/6Rso9U8 [23:28:50] That used to work [23:29:01] tomthirteen_, what if you run 'cat blocked_test.txt' ? [23:30:09] It print the sql command in the prompt window and returns an empty file [23:31:01] and the text is not altered in any way? [23:32:01] no [23:32:28] and if you run this command directly inside the prompt it is fine? [23:32:42] yes [23:32:50] wait [23:33:29] what if you put 'which sql' inside the file and source that? [23:33:29] if I put "cat blocked_test.txt" at the beginning of the file's coding and run "source blocked_test.txt" it works [23:33:40] uh what? [23:33:51] and then says command not found [23:34:01] you're saying you put "cat blocked_test.txt" *inside* blocked_test.txt? [23:34:22] yes lol and it worked... [23:34:28] what? [23:35:23] it makes no sense to do that [23:35:34] yes, i'm completely confused [23:36:24] I tried which sql enwiki_p "select * from logging limit 100" > example.txt; and it just produced an empty file [23:36:35] with a command not found [23:36:50] that does not make sense [23:36:54] which sql enwiki_p ... ??? [23:37:03] it was 'which sql' [23:37:08] the use of `source` to execute commands from a text file is not a really typical thing. I'm not sure why off the top of my head that it would misbehave like this, but it is something to be suspect of [23:37:38] what should i do? [23:38:06] tomthirteen_: have you done much shell scripting before? [23:38:23] * bd808 is trying to think of where to start this conversation [23:38:54] krenair> well, with these types of commands about a year ago. It worked, but now it doesn't [23:39:17] yes, you said that [23:39:28] it's not immediately obvious why you've got an error [23:39:57] I would check the contents of the file you're running [23:40:02] but my permissions don't permit that :) [23:40:58] the file seems to have disappeared, so I can't check either :) [23:41:29] I'm reloading [23:41:39] trying to refresh [23:43:35] krenair > ugh now it doesn't even produce the file when I run cat blocked_test.txt [23:43:54] that would suggest the file is empty [23:44:09] it printed the command in the prompt [23:44:17] I wonder if the DOS line endings in the file have something to do with this [23:44:38] if you 'stat blocked_test.txt' it will tell you the file size [23:44:43] bd808, I thought of that [23:45:13] look at the one in my home dir [23:45:26] 00000000: 7371 6c20 656e 7769 6b69 2027 7365 6c65 sql enwiki 'sele [23:45:26] 00000010: 6374 202a 2066 726f 6d20 6c6f 6767 696e ct * from loggin [23:45:26] 00000020: 6720 6c69 6d69 7420 3130 3027 0d0a g limit 100'.. [23:45:33] source on that file works fine [23:46:02] when I try stat it says file not found... [23:46:19] ls says it's there [23:47:07] uh [23:47:26] are you sure there are no typos? [23:48:43] I don't know what's up with it, but it has something to do with the file contents. And in a weird way I think. [23:49:19] Krenair, do you work for Wikipedia? I know last time when something weird was happening, they did a kinda hard restart for my directory and it did the trick [23:49:28] no [23:49:29] I copied the file to my home dir and it fails with the same "sql: command not found". Then I opened vim and did :r name_of_file to read it into the buffer. Saved that and it works [23:49:53] bd808, what does xxd on the file show? [23:49:57] I'm sorry. I didn't follow that [23:50:29] when something on tool labs gives up a 500 ISE (https://tools.wmflabs.org/global-search/) do the logs go somewhere i can see, or only the tool owner? or nowhere? [23:50:33] hmmmm... byte order marks at the start of the file maybe? [23:50:45] xxd blocked_test.txt says no such file [23:50:49] Krenair: first line of the dump is "00000000: efbb bf73 716c 2065 6e77 696b 695f 7020 ...sql enwiki_p" [23:50:53] if there is an unprintable character at the beginning, [23:51:01] that would most likely explain it [23:51:45] EF BB BF is UTF-8 BOM [23:51:50] ebernhardson: they would go into the $HOME of the tool. Probably to $HOME/error.log, but maybe ot another file [23:51:56] so yea [23:52:54] bd808: ok, i'll poke musik to maybe add me to the tool. [23:52:55] tomthirteen_: ok. One issue here is that the text editor you are using on your laptop is adding in invisible characters that the unix shell does not know how to deal with [23:53:32] yes, I was starting to think that [23:53:34] ebernhardson: I can add you too. You're getting blamed in the HTML footer so you should be able to defend yourself ;) [23:53:47] but the files that I used a year ago are also not working [23:53:49] bd808: sure, that works :) [23:54:01] tomthirteen_: notepad++ is one windows editor that I have had a good experience with in the past [23:54:49] !log tools.global-search Added Ebernhardson as co-maintainer [23:54:53] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.global-search/SAL [23:55:21] ebernhardson: you'll need to log out of the bastion and back in to get that to take effect for `become` [23:55:31] bd808: alright, thanks! [23:55:57] * bd808 grumbles about group membership being fixed at loging [23:57:03] ok, something is seriously wrong [23:57:21] when I run cat blocked_test.txt i get [23:57:25] tomthirteen@tools-sgebastion-07:~$ cat blocked3.txt sql enwiki_p "Select * from logging limit 100" > t.txttomthirteen@tools-sgebastion-07:~$ [23:57:35] and the answer is, xtools thinks labswiki isn't a real wiki :) [23:58:14] ebernhardson: oh... yeah. wikitech isn't in the replicas so xtools probably knows nothing about it [23:58:47] yes indeed, XTools looks at the meta_p.wiki table [23:59:06] im lost [23:59:21] tomthirteen_: this FAQ kind of tells your problem -- https://unicode.org/mail-arch/unicode-ml/y2002-m04/0064.html -- Windows Notepad sticks invisible characters at the start of unicode text files. Linux does not know what to do with those characters. [23:59:26] krenair> what do you think I shoul do?