[02:51:42] sooo it is now deployed? [02:52:45] idk lol [02:52:48] i havwn't deploted it [02:53:02] weren't you told about that previous time? [03:07:47] it is now. I deployed config now. [03:35:49] yup, now it works, thank you [03:37:16] i wonder if i should use https://github.com/miraheze/python-functions/pull/119 rn even though it's not merged or reviewed by other folx yet [03:45:43] tryon beta [03:49:18] uhhh sure [03:50:24] chat my facial recognition sucks T_T [03:52:44] state library is really unfiltered huh [03:52:46] wireguard works too [03:52:58] hmm... can't ssh to bast161 [03:54:08] so ssh on port 22 is blocked here [03:55:31] yo, we heard you liked jumping, so we decided to jump twice [03:55:35] > `ssh -J icecone,wikitidebast test151.wikitide.net` [03:59:47] UHH [03:59:51] > INVALID DATABASE! YOU CAN NOT USE THE DATABASE OF A DIFFERENT REALM! [03:59:57] WHY did this exit with return code 0?? [04:01:41] > Warning: fopen(importDump): Failed to open stream: No such file or directory in /srv/mediawiki/1.44/maintenance/importDump.php on line 291 [04:01:42] girl what [04:03:11] [1/4] ``` [04:03:11] [2/4] [blankeclair@test151:~/python-functions/miraheze/mediawiki]$ file /srv/mediawiki/1.44/maintenance/importDump.php [04:03:11] [3/4] /srv/mediawiki/1.44/maintenance/importDump.php: PHP script, Unicode text, UTF-8 text [04:03:12] [4/4] ``` [04:07:05] okay, so [04:07:06] mwscript works [04:07:08] why?? [04:07:50] HUH [04:08:00] the wiki argument must be after importDump?? [04:18:03] wireguard is magic lol [04:18:14] i put my laptop to sleep for a minute or so, and yet my ssh connection is still up [04:19:43] > Importing trump.jpg...failed. (The file /home/blankeclair/mwimport-test/images//trump.jpg does not exist.) [04:19:45] exits with 0 [04:19:48] who made these scripts??? [04:23:29] @blankeclair aight im heading out for the night [04:23:36] oki bye~ [04:23:41] remind me to ginish looking at your PR tmr [04:24:07] almost done converting my old project into a template a:YIPPEE: [04:24:31] more gay crime tmr minus the gay for me [04:25:16] _brings shotgun_ [04:25:22] i just wanna talk to the person who wrote importImages.php [04:25:42] git blame someone else girlfriend [04:25:47] ducks and hides [04:26:01] > Notice: DB transaction writes or callbacks still pending (MediaWiki\CommentStore\CommentStore::createComment, LocalFile::recordUpload3, MediaWiki\CommentStore\CommentStore::createComment, ManualLogEntry::insert, PortableInfobox\Helpers\PagePropsProxy::set, InsertRowIntoModerationTableConsequence::run) in /srv/mediawiki/1.44/includes/libs/rdbms/database/Database.php on line 3223 [04:26:03] oh fuck me [04:26:33] not to be confused with git-blame-someone-else [04:26:34] https://discord.com/channels/178359708581625856/178359708581625856/1347623066628259984 [08:35:42] https://issue-tracker.miraheze.org/p/Gxyzradio/ More Phorge spammers [08:58:09] Morning Frisk [08:59:56] Morning ^^ [10:14:53] [e7bbe26f0ca711b13e14afa4] 2025-03-08 10:14:10: Fatal exception of type "Wikimedia\Rdbms\DBQueryError" [10:14:57] when trying to login [10:15:06] in Special:Login [10:32:45] guess i'll get out of bed [10:37:09] https://cdn.discordapp.com/attachments/1006789349498699827/1347880815274758224/message.txt?ex=67cd6f54&is=67cc1dd4&hm=38f4bbbf528bddf4f14a383a5da1e3de3185680d15a44410df26ae3eab5cb4b9& [10:37:50] That's not supposed to happen [10:37:58] yeaaaaaah [10:38:00] Is that wiki in cw_wikis [10:38:02] @blankeclair [10:38:46] Nothing on Phorge https://issue-tracker.miraheze.org/search/query/K_NvE9n5T4x7/#R [10:39:27] [1/2] > [10:39:28] [2/2] 05:01 MirahezeLSBot: [agent@mwtask181] sudo -u www-data php /srv/mediawiki/1.43/maintenance/run.php CreateWiki:RenameWiki --wiki=loginwiki --rename mininggowiki rorwikwiki Agent_Isai (END - exit=0) [10:39:31] lemme check [10:39:49] So something has gone wrong [10:40:02] It says it finished fine though [10:40:40] @blankeclair can you sql.php to either of them with --wiki [10:40:59] The wiki database 'mininggowiki' was not found. [10:41:01] Or do I have to show you the hacks way [10:41:11] Wikimedia\Rdbms\DBConnectionError from line 1129 of /srv/mediawiki/1.43/includes/libs/rdbms/loadbalancer/LoadBalancer.php: Cannot access the database: Unknown database 'rorwikwiki' (db161) [10:41:28] guessing table didn't move over? [10:41:31] sorry, db* [10:41:31] @blankeclair okay find another wiki on db161 then [10:42:36] [1/14] tried on loginwiki: [10:42:36] [2/14] ``` [10:42:36] [3/14] > SELECT COUNT(*) FROM mininggowiki.actor; [10:42:37] [4/14] Wikimedia\Rdbms\DBQueryError: Error 1146: Table 'mininggowiki.actor' doesn't exist [10:42:37] [5/14] ... [10:42:37] [6/14] > SELECT COUNT(*) FROM rorwikwiki.actor; [10:42:38] [7/14] Wikimedia\Rdbms\DBQueryError: Error 1146: Table 'rorwikwiki.actor' doesn't exist [10:42:38] [8/14] ... [10:42:38] [9/14] > SELECT COUNT(*) FROM rainversewiki.actor; [10:42:38] [10/14] stdClass Object [10:42:39] [11/14] ( [10:42:39] [12/14] ... [10:42:40] [13/14] ) [10:42:40] [14/14] ``` [10:42:53] @blankeclair that's bad [10:42:57] yeah... [10:43:02] where tf did the database _go_ [10:43:06] It's supposed to exist on one of the databases [10:43:11] @reception123 help please [10:43:29] @agentisai please check that db renames actually work [10:44:22] @blankeclair I have zero clue where this has gone [10:44:28] me too wtf [10:44:31] lemme read the script [10:45:06] I do apologise for this [10:45:37] @blankeclair I would like to express how would I dislike the wiki rename script [10:45:50] I have only found error generation as a use for it [10:45:54] https://github.com/miraheze/CreateWiki/blob/e41d0cf8b35770dcb82f6c6e3cd4983cb110e4ee/maintenance/RenameWiki.php#L12-L16 [10:46:00] lemme just eye the sal real quick... [10:47:04] where is the start [10:47:05] why is it not logged [10:47:55] @blankeclair start isn't always logged [10:47:59] huh okay [10:48:01] Unless it's a long script [10:48:10] We only log start for explicitly defined scripts [10:48:16] ah okay [10:48:21] Because some scripts finish in seconds and we don't want to log that [11:05:33] @snowstacked fyi https://issue-tracker.miraheze.org/T13319 [11:20:44] does the wiki exist in swift i wonder [11:22:01] > for i in mininggowiki rorwikwiki; do curl https://static.wikitide.net/"$i"/c/c9/Logo.png?$RANDOM --no-progress-meter | file -; done [11:22:03] /dev/stdin: PNG image data, 512 x 512, 8-bit/color RGBA, non-interlaced [11:22:04] /dev/stdin: PNG image data, 512 x 512, 8-bit/color RGBA, non-interlaced [11:55:07] [1/12] for some extra headscratching: [11:55:08] [2/12] ``` [11:55:08] [3/12] > SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'mininggowiki'; [11:55:08] [4/12] Query OK, 0 row(s) affected [11:55:09] [5/12] > SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'rorwikwiki'; [11:55:09] [6/12] Query OK, 0 row(s) affected [11:55:09] [7/12] > SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'loginwiki'; [11:55:10] [8/12] stdClass Object [11:55:10] [9/12] ( [11:55:10] [10/12] [SCHEMA_NAME] => loginwiki [11:55:10] [11/12] ) [11:55:11] [12/12] ``` [12:09:33] i hope my hypothesis isn't right... [12:23:00] @blankeclair can you select all tables in a schema using that [12:23:06] yes i can [12:28:17] @blankeclair what does that say [12:28:35] i mean... it would be a giant dump of the database names [12:28:44] do you want me to put it in a phaste or so? [12:29:08] @blankeclair just select for them two wikis and loginwiki [12:29:15] But ye ohaste [12:29:16] i did it above though? [12:29:31] That's databases not tables [12:29:34] ah [12:29:51] if there's no db, then wouldn't there be no tables? [12:30:02] @blankeclair theoretically [12:30:08] okay ten [12:30:09] then [12:31:45] is acl*security okay? [12:32:20] @rhinosf1: ^ [12:33:53] Ye [12:35:37] https://issue-tracker.miraheze.org/P541 [12:39:41] @blankeclair okay I'm fairly sure this database just doesn't exist [12:39:49] yeah... [12:39:55] the main question is now _why_ [12:40:02] (and _what the fuck_ too) [13:07:41] @rhinosf1 did we lose a production wiki database [13:09:58] We've found it now with the help of a search party but in the sense of we didn't know where it had gone for a few hours yes [13:13:10] Oh thank Ward I did not want to add another post mortem to never be finished [13:17:07] verdict found: agent forgor to move the database [13:17:23] and i forgot that we have more than one database server, so i was checking against the wrong db server for its existence [13:17:28] @snowstacked apologies for the issues, they should now be fixed [13:17:35] paladox moved the db :3 [13:19:05] @blankeclair now go hug blahj and chill before eep time [13:19:12] i am chilling lol [13:19:27] i tend to be calm during disasters even [13:19:44] It's still 00:20 for you [13:19:50] Dandy [13:19:53] Less dandy [13:20:08] Also morning @pixldev [13:20:13] helpful when two friends you knew attempted suicide :3 [13:20:36] wait no... three? four? [13:20:51] Oh… that’s much less dandy…. [13:21:08] i think it's four... [13:21:21] I was talking to my uni study tutor about the stress of our final semester and went through all that happened in my last 2 years of high school and she was like ye I'm not surprised you think this is a breeze [13:21:22] Significantly less dandy [13:21:30] uh, at least it's not five? [13:21:43] I mean 4 is better than 5 [13:21:45] What [13:21:49] But 0 would be ideal [13:21:54] indeed [13:22:00] Thats actually kinda ridiculous [13:22:08] Have you not heard any of my tails of Henry? [13:22:12] yeah ikr, no checks on the second script [13:22:14] planning to add that myself [13:22:40] [1/2] Apples drag typing Is [13:22:40] [2/2] https://cdn.discordapp.com/attachments/1006789349498699827/1347922469671145513/image0.jpg?ex=67cd961f&is=67cc449f&hm=33fa861fa92b91feccdc6797f5d395b71430b82c157cb47c19b079d52e8c0b37& [13:22:41] Wood [13:23:14] I wonder what she'd have thought about my high school if I'd have told her everyone [13:23:20] No one died in our last 2 years [13:23:31] Which was somehow impressive [13:23:57] HUH [13:23:58] It was close [13:24:03] But everyone survived [13:24:36] THAT’S SUPPOSED TO BE IMPRESSIVE? [13:24:37] @pixldev my high school experience tested many of our school's ways of dealing with eventful things [13:24:53] Seems like an awfully low bar [13:26:02] suddenly reminded of someone who vandalised the wp page for VCE [13:26:13] My high school is in special measures lol [13:26:17] Has been since lime 2019 [13:26:22] https://www.theage.com.au/national/victoria/vce-scumbags-students-wikipedia-cry-for-help-20151030-gkmpny.html [13:26:37] @pixldev well a car crash, a long term hospital stay, raw chicken, appendicitis, sepsis, diving, a few flying chairs, a broken laptop, a bit of anxiety, ghosts etc, a few heart attacks will do that [13:26:59] Well it is Manchester [13:26:59] EXCUSE ME [13:27:08] IS THIS THE UK OR THE US [13:27:11] @originalauthority have you watched Waterloo road? [13:27:25] Nope but I put it on my watch list the other day! [13:27:28] Have yet to though [13:27:41] My high school was selected to be on Educating Greater Manchester lol [13:27:47] The UK [13:27:51] But they pulled out because they didnt want the bad publicity heh [13:28:28] @pixldev oh and a tile narrowly missing my head after a broken boiler leaked [13:28:39] I have a lot of stories [13:28:44] My American high school in rootin tootin America is less deadly then this [13:29:14] @pixldev well we didn't have any guns or anything [13:29:23] Exactly [13:29:29] Just a man swinging a knife around [13:29:29] Is it though? [13:29:37] I never had to worry about being shot at 830am [13:29:42] Requiring an external lockdown and a couple of armed police [13:29:47] And a bomb threat [13:30:00] But that was deemed to not be genuine before we opened for the morning [13:30:48] Or was it a gun threat [13:30:53] We didn’t have a car crash, a long term hospital stay, raw chicken, appendicitis, sepsis, diving, a few flying chairs, a broken laptop, a bit of anxiety, ghosts etc, and a few heart attacks [13:30:59] There was some threat to attack the school by a student [13:31:04] But it wasn't serious [13:31:16] Worrying but no one expected the little shit to actually do anything [13:31:26] He just got told to stay away for a few months [13:31:31] oh btw, our school had a shooting threat lol [13:31:44] apparently it was from a compromised email account that was used from the US [13:32:05] I think the one time my school had something like that it was a rumor [13:32:22] Ours was a little cunt in our year [13:32:29] [1/2] >>> The ensuing investigation determined the threat not to be credible. [13:32:29] [2/2] Rumors among the student body perpetuated this false alarm. No students were ever in harm's way, and the day commenced as scheduled. [13:32:39] I can't remember why [13:32:47] But he sent it the evening before [13:32:50] To students [13:33:06] He didn't even make it to school the next day [13:33:16] The knife wielding man is a more fun story [13:33:18] [1/10] > IMPORTANT - Concerning Email Possibly Received [13:33:19] [2/10] > [13:33:19] [3/10] > Dear parents/students [13:33:19] [4/10] > [13:33:20] [5/10] > This afternoon some students may have received a threatening/offensive email purportedly from a student. We are currently investigating the origin of the email address and whether it is compromised. We have informed Victoria Police and the Department of Education of the email and its contents. [13:33:20] [6/10] > [13:33:20] [7/10] > If you have received this email we ask that you delete it and not forward it on to other parties. [13:33:21] [8/10] > [13:33:21] [9/10] > Regards [13:33:21] [10/10] > [Shark Hugger] [13:33:43] i had to know about the contents from gossiping [13:33:53] Shark hugger???? [13:33:53] and even then i had the tl;dr :p [13:34:00] name of the principal [13:34:05] i changed it obv :p [13:34:09] Well yes [13:34:18] Shocked people listen to that [13:34:31] ? [13:34:33] @pixldev my high school experience was a learning experience for sure [13:34:41] Not sharing it around [13:34:44] More in dealing with shit hitting than fan in explosive ways [13:34:48] ..? [13:34:50] Not in the national curriculum [13:34:59] Although ngl my friends mother would probably know more then me anyways lmao [13:35:26] i should report the security issues i found in compass.education tbh [13:35:28] Schools are easy places for a lot of things to spread [13:35:31] but i'm too lazy [13:35:40] From colds and flus to rumours [13:35:48] Probably [13:35:50] Profit🤭 [13:35:57] yay thank you 🙂‍↕️ [13:36:21] for data scrapers, ig so?? [13:36:39] except that it's not even a lot of data [13:36:46] students can't grab other students' info usually >_> [13:39:35] a:asyncparrot: [13:39:39] Huh [13:39:53] @ stackd can you fix the css on this bird [13:40:21] I found smt that let me get the photo name and grade associated with an IS number [13:40:22] Bout it [13:40:33] IS? [13:40:37] ID* [13:40:49] :venniebwaah: [13:42:05] ah [13:42:17] speaking of info leaks, i managed to find an arbitrary file read on mw* as a mediawiki-admin [13:42:19] https://issue-tracker.miraheze.org/T13320 [13:51:43] Of course you did [13:53:31] sudo rules are dangerous [13:53:36] yeah ikr [13:53:44] at least environment variables weren't allowed to be passed [13:54:01] otherwise it would've been a simple `SYSTEMD_PAGERSECURE=0 journalctl` [13:55:24] also, weird that we give root for running journalctl instead of adding the users to the systemd-journal group [13:58:39] [1/2] > If status is a string, this function prints the status just before exiting. The exit code returned by PHP is 0. [13:58:39] [2/2] php, why are you like this