[00:28:01] legoktm: Re error jobs, after waiting +/- 5 minutes, you can exec "qacct -j 669009". It says "failed 26 : opening input/output file". [00:28:59] legoktm: To clear, "qmod -rj 669009" should work (untested). [00:28:59] hey scfc_de [00:29:05] scfc_de: are you coming to wikimania? [00:29:10] YuviPanda: No. [00:29:15] :( ok [00:33:26] !ping [00:33:26] pong [00:33:31] hmm, my network's fine [00:33:46] :)) [00:34:03] just friday evening and no activity on IRC [00:34:08] i'm on like 15 channels, all dead [00:35:06] once I had an emergency and there was no online steward! none at all [00:35:13] I felt really lucky [00:35:21] heh [00:35:32] damn timezones [00:35:51] hell yeah [00:36:11] heh :D [00:38:07] I sometimes live in Europe timezone in order to be able to do my job (I mean I act like I'm in UTC tz, sleep 4 AM and wake up 12) [00:38:50] I'm switching to US TZ now :D [00:45:00] Amir1: hehe, I'm in India, so it is 6ish AM so very similar :) [00:45:20] Iran, now is 5:15 AM [00:45:34] I'll so you in Wikimania [00:45:39] *see [00:46:17] Amir1: you too! \o/ [00:48:44] :) [07:17:50] Change on 12mediawiki a page Talk:Developer access was modified, changed by Nemo bis link https://www.mediawiki.org/w/index.php?diff=741585 edit summary: [+256] /* There was either an authentication database error or you are not allowed to update your external account. */ temp? [09:10:33] [bz] (8NEW - created by: 2Chris McMahon, priority: 4Unprioritized - 6major) [Bug 50622] Special:NewPagesFeed intermittently fails on beta cluster; causes test failure - https://bugzilla.wikimedia.org/show_bug.cgi?id=50622 [12:03:20] [bz] (8NEW - created by: 2This, that and the other, priority: 4Unprioritized - 6normal) [Bug 51745] Implement a custom HTTP 500 error page on labs - https://bugzilla.wikimedia.org/show_bug.cgi?id=51745 [14:26:40] Well... [14:27:02] wm-bot is back, twice in some channels.. [14:55:29] wtf [14:55:41] Technical_13 what happened [14:57:44] wm-bot: left all channels on its own, but wm-bot2 stuck aroubd in an unresponsive state. [14:57:44] Hi Technical_13, there is some error, I am a stupid bot and I am not intelligent enough to hold a conversation with you :-) [14:58:21] Technical_13 ?? [14:58:29] Technical_13 how left? quit or part? [14:58:41] what you mean by is twice somewhere [14:58:51] No idea, happened before I got ob this morning. [14:58:52] who did restart it? [14:58:59] No idea. [14:59:05] so now it's not twice anywhere etc? [14:59:10] I asked in -labs [14:59:16] should I restart it once more? [14:59:16] Not as far as I know. [15:00:18] Well, it was in ##justberry twice, wm-bot2 finally timed out and I set the instance of wm-bot back to wm-bot2 for that channel. [15:11:13] I'll email you my log for what I have. [15:12:01] * YuviPanda pets grrrit-wm [15:13:42] YuviPanda what it does? how it work? [15:13:51] petan: I emailed wikitech-l :) [15:13:54] it's gerrit-wm replacement [15:14:02] running on toollabs [15:14:07] can it be customized per channel? [15:14:10] petan: yes [15:14:17] there's a config file [15:14:23] it already will put labs/* things here [15:14:43] ok but regular users can't change config files [15:15:03] indeed. and that's fine. it's a major improvement to what was before, which was hooks in the gerrit cluster [15:15:05] *shudder* [15:15:17] petan: want to setup tools-redis? [15:15:31] at some point hook in gerrit sounds pretty cool [15:15:36] that is something you can work with [15:15:51] err, gerrit hooks live in the operations/puppet repo. [15:15:54] if you would make some distributed feed like irc.wikimedia.org from gerrit [15:16:06] you could easily attach other bots to it [15:16:08] I already make those, and both my Gerrit bots read off those [15:16:29] SuchABot (Github -> Gerrit and Gerrit -> Github) and now this [15:16:42] almost exactly the same as irc.wikimedia.org :) [15:17:06] petan: also, tools-redis? [15:17:17] I don't know [15:17:21] let me check if it fixed itself [15:17:31] that bug in default image slowed me [15:17:47] like not being able to login kind of suck [15:17:51] yeah, it does [15:18:33] it seems it's broken [15:18:37] I can't ssh [15:18:43] meh [15:18:46] try restarting? [15:19:36] !log rebooting tools-redis [15:19:36] rebooting is not a valid project. [15:19:42] !log tools rebooting tools-redis [15:19:43] Logged the message, Master [15:23:17] petan: any luck now? [15:23:27] yes [15:23:30] let me set up sf [15:23:31] fs [15:23:49] nice [15:23:58] don't manually install anything, just apply the role. that *should* work [15:24:31] for redis i mena [15:31:09] YuviPanda I already applied it before [15:31:13] so should I run it as it is? [15:31:15] ah ok [15:31:17] yeah [15:31:36] run [15:31:45] try it? [15:32:04] how redis handle authentication btw [15:32:17] like how do people create private account for private data [15:32:28] !tools-help [15:32:28] https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Help [15:32:32] read the 'security' section :) [15:33:36] LOL [15:33:47] what is difference between this and memcache? [15:33:57] sharp memcache was even more secure then [15:34:22] we've been through this a lot of times before, so I'm not going to do this again [15:34:30] please read the redis documentation [15:34:57] I don't remember I have ever was discussing difference between memcache and redis with anyone but ok [15:35:22] it does a lot more things than memcached [15:35:22] if you really need to use prefix for keys as a security feature it definitely makes it worse... [15:35:38] queues, hashes, pubsub, etc. [15:35:38] but some people may need only the features that memcache provides [15:35:58] Redis provides a superset of those features. [15:36:00] isn't it possible to list all values [15:36:05] it isn't [15:36:15] because we have it disabled. That's the work I did, via puppet :) [15:36:28] check the code for the redis labs role :) [15:36:34] I should write a blog post about it at some point [15:36:45] we really need a solution that supports authentication [15:36:52] I'm sure Redis accepts patches [15:37:08] petan: you should look at Keystone, which is how OpenSTack does authentication [15:37:14] I know keystone [15:37:18] if there can be a redis layer behind Keystone, that should automatically work [15:37:21] for most tools, I thin [15:37:22] k [15:37:28] but question is if that supports redis [15:37:40] but prefix is SecureEnough(TM), if you use a secure enough prefix. [15:38:07] it's lame... and it also increases the amount of data transfered over network which kind of make stuff slower [15:38:13] memcache == super fast [15:38:17] every instruction matters [15:38:25] this is the conversation we've had many times [15:38:32] I never changed my mind [15:38:39] :) [15:40:02] petan: I mostly stopped trying a while ago [15:40:05] to change your mind, that is. [15:40:17] good :P [15:46:02] petan: what is your email to send my clients log for that channel so you can see what happened. [16:48:19] Could someone block User:Seoexpert001 on wikitech, please? [16:50:07] And User:Sidrakanwal774. [16:59:45] petan: You've got mail! [17:12:17] ;-) [17:13:00] Seoexpert ? [17:15:13] "001"! [18:18:18] And User:Sidrakanwal77412. [18:25:39] Ryan_Lane, are u at OSCON? [18:33:31] Uh, Geohack has been switched to Tools on dewp. Let the traffic begin :-). [18:48:11] scfc_de: I'll be switching it back when I get back to wiki work [19:06:06] Dispenser: Is it causing any problems? [19:07:34] 1) Its not official and not maintained 2) It was a simple copy and paste of the source code with Toolserver hooks still intact [19:08:14] AFAIK not even an SVN checkout [19:10:00] 3) The URL change wasn't verified and we likely have link all over the place (blame WMF devs propagation crashing) [19:15:10] Dispenser: Well, according to http://de.wikipedia.org/w/index.php?diff=119412505, it seems to be working successfully for over a month now. [19:16:51] It is making calls to the Toolserver [19:17:38] ergo not much of a point running on the Labs [19:20:00] Dispenser: Which calls do you mean? [19:20:36] It probably using para's Geo => Country code [19:23:05] In any case, its shoddily ported [19:23:51] And the two people have done zilch in maintenance of the past few years [19:24:49] Dispenser: Well, Magnus and Kolossos *do* have some street cred :-). I didn't want to imply that everything's peachy, but it seems to work. [19:26:22] They talk more, that all [19:26:35] I don't see traffic increased at all [19:27:05] !awstats [19:27:19] !awstats is http://tools.wmflabs.org/awstats/ [19:27:19] Key was added [19:27:24] petan: The bump would have been a month ago. [19:27:32] ah [19:27:37] well then [19:28:12] Pages-URL (Top 10) - Full list - Entry - Exit [19:28:14] 144 different pages-url Viewed Average size Entry [19:28:23] /geohack 2,332,846 17.95 KB 8 6 [19:28:29] cluebot 1,502,320 188 Bytes 62 63 [19:30:41] petan: So about 50 % of all accesses go to Geohack? [19:30:54] yes [19:31:08] you can grep more precise stats from /data/project/.system/logs [19:31:50] petan, can you install the package tclthread on tools? [19:31:56] sure [19:33:44] I need to fix that damn log [19:33:54] yay, thx [19:34:08] giftpflanze: you should still add it to puppet :P [19:34:26] me? [19:34:55] whoever [19:34:58] giftpflanze: want me to? or you want to practice? :) [19:35:51] scfc_de: Do you know who I am? [19:36:00] YuviPanda: you may do it ;) [19:36:10] !Dispenser [19:36:16] giftpflanze: what is the name of the package? [19:36:18] you are clearly someone wm-bot doesn't know [19:36:26] which makes you someone non-important XD [19:36:27] tclthread [19:37:14] btw it's installed [19:37:17] giftpflanze [19:37:23] i know :) [19:37:43] petan: you shouldn't really install things without putting them in puppet first. [19:37:46] Dispenser: You're the maintainer of Geohack on Toolserver, otherwise, nope. [19:38:08] YuviPanda: lol, that would slow down operation of tools project 2954368627 times [19:38:18] petan: You're admin on wikitech? [19:38:20] I don't know why I even bother anymore. [19:38:29] scfc_de: not real, but kind of [19:38:40] scfc_de: I can like delete pages, protect pages etc... [19:39:05] petan: doesn't mean you can'd add a patchset after installing. [19:39:05] I also run the coord extraction (used by Kolossos and dschwen) with the error detection and correction. I also have a bunch of tools. [19:39:13] petan: Block users? If so, please Seoexpert001, Sidrakanwal774 and Sidrakanwal77412. [19:39:21] giftpflanze: can you tell me the list of packages you've gotten installed so far, so I can add them all in one patch? [19:39:23] YuviPanda: I absolutely see your point, but problem is that when I add a patch there I have to wait typically 2 months for it to get merged [19:39:43] YuviPanda: then I have to do git-fu to revert the change in order to apply another change and stuff like that [19:39:48] petan: 1. Coren usually merges them as soon as he sees them (provided they are fine) 2. Install them and *then* add patches [19:40:05] petan: doing a 'git checkout' shouldn't be consiered 'git fu' [19:40:07] I'm was curious why you were dismissing my claims. I certainly how you aren't that way with vulnerabilities. [19:40:20] YuviPanda: this make me spend 5 hours with git and 10 minutes with actual works that matters, which make this forkflow non-sense [19:40:42] scfc_de: ok I hope that block feature is fixed :P [19:40:45] as I said, you've made it clear that there's nothing anyone can say that'll make you change the way you do things, so I've no idea why I even bother. [19:40:45] Dispenser: What was I dismissing? [19:40:55] last time I blocked spam-bot someone random got blocked [19:40:57] petan: Yes, Ryan_Lane did so the other day (apparently). [19:41:08] That GeoHack on the Labs is a shoddy port [19:41:08] I know that the toollabs project wouldn't be as fast as it is without you hanging around, petan. [19:41:13] doesn't make it any less frustrating :) [19:41:47] petan: wasn't there some tool that gave me a list of packages installed? I want to add all the tcl ones so they don't get lost [19:42:14] yes, it's called dpkg -l [19:42:47] also there is http://tools.wmflabs.org/admin/packages.html [19:42:50] but that needs a reload now [19:43:42] YuviPanda: yes I still see your point, but it's just incredibly annoying... I am just a poor volunteer, doing this requires huge amount of time (while onexec apt-get install takes like 10 seconds to me) I am actually doing it different way now [19:44:02] petan: at least poke me after you install things. I find it rather easy to make the patchsets. [19:44:07] YuviPanda: everytime there is need to create new exec node I create it, apply the puppet group, refresh diff of packages and mass-add all missing packages [19:44:37] that way it's million times faster, requires 1 git commit and result is same [19:44:37] that's a horrible horrible hack. [19:44:57] but it saves so much time... even days of work :D [19:45:07] Dispenser: I said it was working, and that it wasn't peachy. I'm pretty sure Kolossos and Magnus would appreciate your collaboration, but IIRC you indicated that you don't have any time. [19:45:26] YuviPanda: we might create a wikipage "packages to add in puppet" [19:45:39] I think we had one in past [19:45:50] petan: indeed. if you can create that, and make at least *that* up to date, I can add them in puppet later [19:45:57] Or just add them in puppet [19:46:13] Damianz: don't try to change petan's ways, it ends up in frustration only for yourself :) [19:46:23] git checkout -b is 'magic git fu' that takes 5 hours of work! [19:46:38] 5seconds of versioned controlled awesome [19:46:57] Takes me less than 5 hours to rebuild every single image for a mixing desk.... [19:46:57] Damianz: indeed. [19:47:08] you're no petan [19:48:27] Damianz: BTW, in mixing stuff do you still have knobs and other physical equipment, or is it just touchscreens now? [19:49:17] There's a physical interface with knobs and stuff, some companies have touch but it's for secondary stuff. [19:49:27] Mixing without the feedback from sliders would be horrible [19:49:53] giftpflanze: added https://gerrit.wikimedia.org/r/74856 :) [19:49:56] 833M access.log < still need logrotate [19:49:59] Damianz: Never tried that (besides adjusting the volume on a car radio :-)). [19:50:55] YuviPanda: Please no jokes in commit messages; when you look at them in a year, you don't have a clue what that's supposed to mean :-). [19:51:03] scfc_de: :P [19:51:18] no passive aggressiveness on gerrit? awww [19:51:23] YuviPanda: i use also mysqltcl [19:51:36] scfc_de: updated message [19:51:43] giftpflanze: okay, adding that [19:52:03] and Tcl 8.6 from the tip-386-impl branch, no idea what the package is named [19:52:05] YuviPanda: Already pushed? [19:52:16] scfc_de: yeah, it just came through [19:52:49] YuviPanda: Which tcl packages are not managed by Puppet at the moment? [19:53:07] scfc_de: I don't know. petan added a few before, apparently. [19:53:13] scfc_de: let me grep [19:53:21] hmm, apt-cache doesn't respond [19:53:44] NFS freeze again? [19:54:01] fs is slow [19:55:07] only tclodbc [19:55:16] i don't need that [19:55:47] giftpflanze: we should kill it then [19:55:52] scfc_de: can you purge tclodbc? [19:57:02] scfc_de: I think if we discount tclodbc then with the addition of mysqltcl then the tcl packages are complete [19:57:10] at least according to tools-login [19:57:31] scfc_de: amended commit message again [19:57:32] YuviPanda: Could you adapt the commit message then? [19:57:45] Hadron Collision :-). [19:57:47] :D [19:58:09] scfc_de: push came through. should be fine now. [19:58:22] YuviPanda: So I purge (= aptitude remove) tclodbc on all hosts? [19:58:28] scfc_de: yeah [20:00:17] I'm an idiot. On tools-login, the confirmation was for "The following packages will be REMOVED: apache2-utils{u} apache2.2-bin{u} libaprutil1-dbd-sqlite3{u} libaprutil1-ldap{u} tclodbc", and I said yes. Fuck. [20:00:32] scfc_de: .... how did that happen [20:01:01] scfc_de: and that's just on tools-login, right? [20:01:04] so shouldn't affect the webservers [20:01:14] GrumpyPanda: "Confirmation bias"? But I think I aborted before the actual removal. Let me see. [20:01:40] how did that happena s in more like how did it want to remove apache2-utils when you wanted to purge tclodbc :) [20:02:26] Okay, all packages still seem to be installed -- uff. [20:04:06] GrumpyPanda: When I "sudo aptitude remove tclodbc" on tools-login, only tclodbc is asked to be removed. When I instead from my box "ssh tools-login sudo aptitude remove tclodbc", I get the five packages listed above. What's the meaning of "{u}"? [20:04:18] not sure. [20:04:44] giftpflanze: BTW, is https://jira.toolserver.org/browse/TS-862 still current for you? [20:05:00] scfc_de: also why would tools-login have apache? [20:05:09] {u} is probably unused? [20:05:17] installed as dependencies of some other package, but that packages is gone now? [20:05:22] scfc_de: no idea [20:06:11] YuviPanda: http://algebraicthunk.net/~dburrows/blog/entry/aptitude-0.4.10-released/ says "unused". But what kind of status is that? [20:06:21] giftpflanze: But you are gifti on Toolserver? [20:06:34] yes [20:06:34] * Coren|Darkness still doesn't have power and it doesn't look good for getting it today either. [20:06:43] Yeay kickass storms uprooting trees and shit. [20:07:15] Coren|Darkness: don't die! [20:07:34] scfc_de: afaics i don't use that parameter anymore [20:07:40] scfc_de: probably packages that were auto-installed as dependencies and then the original package is uninstalled [20:07:47] Sorm is over but the power company's automated "when will it be fixed system" has "we got no idea" as ETA. [20:07:54] Coren|Darkness: Didn't you say you live in Canada? No reliable electricity there? [20:08:09] storms know no geography :) [20:08:38] scfc_de: First real outage in ~6 years, but Canada hasn't invented power distribusion systems that keep working even when the actual wrire and poles are uprooted. :-) [20:09:04] * Coren|Darkness has a generator, thank $deities. [20:09:11] giftpflanze: I'll close it as fixed then, because it worked for me last time I checked. Please reopen if you encounter the issue again. [20:09:24] * Damianz brings some light to Coren|Darkness's life [20:09:36] it probably won't happen ;) [20:09:56] I'm actually not in /real/ darkness. Much of my lighting is LED so I can actually power it from my modest power source. :-) [20:10:01] Coren|Darkness: Germany's solution to that are cities where lines are underground :-). [20:10:22] I got internetz, my workstation, and I can power the freezers so I won't loose food. [20:10:48] I'd totally have a little house that was all wood fire powered instead [20:10:52] India solves that particular power problem by going out so often that we'rea ll rather well practiced now [20:11:01] scfc_de: I'm in a suburb. :-) [20:11:38] * Coren|Darkness needs a bigger generator. 2.4KVA doesn't suffice. [20:11:55] It was cheap. :-) [20:12:52] Also there is no speed governor, my UPSes don't like it. [20:13:11] YuviPanda: My sisters went last year to India, and the electrical distribution lines about five meters above the street looked -- impressive :-). Here we use those only for christmas lighting and perhaps art :-). [20:13:31] scfc_de: :D they're also fairly dangerous since they get cut during storms and then just... lie there. [20:13:34] hopefully not live [20:13:37] dangling wires of doom! [20:13:46] My friend went to india and the power lines look like you've just run life wires without terminals all over the place [20:13:58] s/life/live/ [20:14:03] s/terminals/terminations/ [20:14:08] * Damianz can't type today [20:15:25] petan: scfc_de sorry if I was grumpy and unhelpful earlier. [20:16:08] YuviPanda: Well, you weren't, so don [20:16:12] 't feel sorry. [20:16:15] :) [20:16:28] Coren|Darkness: Do you have any advice on "{u}"? [20:17:19] ... I don't know what {u} /is/. My advice to you is, tell me what it is. :-) [20:19:22] When I "ssh tools-login sudo aptitude remove tclodbc", I am asked "The following packages will be REMOVED: apache2-utils{u} apache2.2-bin{u} libaprutil1-dbd-sqlite3{u} libaprutil1-ldap{u} tclodbc". http://algebraicthunk.net/~dburrows/blog/entry/aptitude-0.4.10-released/ says "{u}" means that the package is "unused". What does "unused" mean and is it safe to remove an "unused" package? [20:21:30] koolhead17: nope. not at oscon [20:22:40] Ah, okay, "man apt-get": "removing the unused dependency packages". So apparently Ubuntu tracks what packages are installed as a dependency, and if that dependency is no longer needed, they are called "unused". How does Puppet interact with that? [20:23:27] I. e. will Puppet mark all the packages it requires to be installed as not automatically installed even if in the past they were? [20:23:42] *they might have been. [20:28:13] Ryan_Lane, HK summit? [20:29:39] koolhead17: yep. I'll be there [20:29:58] cool. [20:30:08] scfc_de: puppet ignores those packages [20:30:19] scfc_de: and so does apt-get, unless you tell it to remove unused packages [20:30:30] Coren|Darkness: can you +2 https://gerrit.wikimedia.org/r/74856 if it isn't too dark? :) [20:32:14] YuviPanda: Done. [20:32:17] Coren|Darkness: ty [20:36:46] Ryan_Lane: No, I mean suppose Puppet installs package A that installs pkg B as a dep. Afterwards, Puppet is changed to require pkg B and no longer pkg A. After/when removing pkg A, will Puppet/Ubuntu mark pkg B as "used" in the Ubuntu sense or would it be removed by auto-remove? [20:37:44] scfc_de: I guess puppet calls apt-get internally and this shouldn't be a problem [20:38:22] YuviPanda: Yes, but if Puppet sees "Oh, pkg B is already installed", will it call apt-get at all? [20:38:36] hmm, that I've no answer to. [20:39:29] scfc_de: puppet has no clue about used and unused [20:39:58] it only does things with packages you list [20:40:23] dependencies will be installed with the package, but will not be removed when the dependent package is removed [20:41:47] scfc_de: so even if you uninstall them, puppet will re-install I guess [20:42:41] YuviPanda: That's clear, but uninstalling could mean config broken, etc. I'll leave my fingers from auto-remove for the moment :-). [20:42:56] :) [20:43:08] moral of the story being don't install anything without putting it in puppet? :) [20:44:29] YuviPanda: More important: Uninstall via "=> absent"? :-) [20:44:42] and then remove that in a while? :) [20:46:06] 35 minutes later? :-) [20:46:20] YuviPanda: yep. that's the moral [20:46:35] if the package is important it should be listed in puppet :) [20:46:54] are there any packages (that don't come with the system) that shouldn't be? [20:47:43] if they shouldn't be in puppet then they shouldn't be on the system, unless it comes with the system [20:51:00] :) [20:58:50] Internal Server Error [20:58:50] The server encountered an internal error or misconfiguration and was unable to complete your request. [20:58:50] Please contact the server administrator, mpelletier@wikimedia.org and inform them of the time the error occurred, and anything you might have done that may have caused the error. [20:58:50] More information about this error may be available in the server error log. [20:59:02] matanya: 500 error is a server side error, there must be trace in the log of the tool:) [20:59:28] it is one of magnus toys [20:59:39] matanya: Do you have a URL? [20:59:46] https://tools.wmflabs.org/commonshelper/?language=he&interface=he&project=wikipedia&&image=Shlomit%20Aharon.jpg&username=Matanya [21:03:18] matanya: Works for me, but I assume you are logged in via TUSC or something similar? (The URLs in the global_access.log are identical.) [21:03:31] yes, i am [21:06:03] matanya: I see some PHP errors in /data/project/commonshelper/php_error.log, but nothing that I could fix immediately. You probably need to contact Magnus directly about that (or ask Jan how commonshelper2 is coming along). [21:06:26] thanks a lot scfc_de [21:50:23] petan, ping [21:51:51] petan, how do I execute an SQL script on labs? [21:57:12] !petan... [21:57:13] OMG Petan deleted me and now he is going to have to spend 2 days trying to put me back together..... [21:57:34] Cyberpower678: use the 'sql' script? [21:57:46] hmm, that should be documented, I think [21:57:47] !tools-help [21:57:48] https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Help [21:57:56] YuviPanda, nevermind. I already figured it out. [21:58:00] Cyberpower678: :) [21:58:07] yeah, it's there [21:58:14] !Cyberpower678 [21:58:15] addshore, how do you rollback? with the rollback button? :D [22:10:54] YuviPanda, actually I do need your help I can't seem to get it to run. [22:11:02] what is happening, Cyberpower678 [22:11:07] Nothing, [22:11:11] sql enwiki_p < file.sql > output.txt [22:11:30] enwiki_p? [22:11:56] p isn't required, I think? [22:11:58] * YuviPanda logs in [22:12:09] Idk, I've memorized using _p. [22:12:17] legoktm, What am I supposed to do with enwiki_p? [22:12:27] That's the database you're running on. [22:12:32] file.sql is the query you want to run. [22:12:33] oh. [22:12:43] output.txt is where the results are dumped to. [22:12:57] That's what I've been doing. [22:13:31] Oh wait. The database name cybrbot would cause it to not work. ;p [22:14:45] Cyberpower678: :D [22:16:11] But it still doesn't seem to want to work. [22:16:26] Can someone give me a step by step guide. [22:16:28] ? [22:16:47] Cyberpower678: are you connecting to your own database? [22:16:50] Cyberpower678: is it on tools-db? [22:17:23] The database is cyberbot the file is called br.sql and is located in /data/project/cyberbot/bots [22:17:37] Database is located in tools-db [22:17:49] https://wiki.toolserver.org/view/MySQL_queries#Accessing_the_data [22:17:56]