Join us now at the IRC channel.
| *superkuh (~superkuh@unaffiliated/superkuh) has joined #techrights | Apr 12 00:04 | |
| *smnthermes (976c22869c@xmpp.snopyta.org) has left #techrights | Apr 12 00:06 | |
| *smnthermes (976c22869c@xmpp.snopyta.org) has joined #techrights | Apr 12 00:07 | |
| *balrog has quit (Quit: Bye) | Apr 12 00:20 | |
| *balrog (~balrog@unaffiliated/balrog) has joined #techrights | Apr 12 00:26 | |
| MinceR | (audio:silent) https://www.youtube.com/watch?v=1kt3OVwGPtM | Apr 12 00:31 |
|---|---|---|
| -TechrightsBot-tr/#techrights-Time lapse of Undulatus Asperatus clouds in Augusta, Georgia - YouTube | Apr 12 00:31 | |
| *smnthermes (976c22869c@xmpp.snopyta.org) has left #techrights | Apr 12 00:39 | |
| *smnthermes (976c22869c@xmpp.snopyta.org) has joined #techrights | Apr 12 00:45 | |
| MinceR | https://ircz.de/p/19110318 | Apr 12 00:56 |
| -TechrightsBot-tr/#techrights-ircz.de | IRCZ makes your life worth living Post object (4102414) | Apr 12 00:56 | |
| *smnthermes (976c22869c@xmpp.snopyta.org) has left #techrights | Apr 12 00:58 | |
| *smnthermes (976c22869c@xmpp.snopyta.org) has joined #techrights | Apr 12 00:59 | |
| *smnthermes (976c22869c@xmpp.snopyta.org) has left #techrights | Apr 12 01:08 | |
| *psydread (eace4d91cc@2a01:7c8:aab8:6b9:5054:ff:fec9:fd84) has left #techrights | Apr 12 01:12 | |
| *smnthermes (976c22869c@xmpp.snopyta.org) has joined #techrights | Apr 12 01:21 | |
| *psydread (eace4d91cc@2a01:7c8:aab8:6b9:5054:ff:fec9:fd84) has joined #techrights | Apr 12 01:25 | |
| -viera/#techrights-Tux Machines: #Android Leftovers http://www.tuxmachines.org/node/136282 [https://pleroma.site/objects/36f60d0d-1ab2-4836-b8a9-bd0f0c5f402f] | Apr 12 01:25 | |
| -viera/#techrights-Tux Machines: More #Android Leftovers http://www.tuxmachines.org/node/136279 [https://pleroma.site/objects/182e2445-52f1-4b69-92d0-d40df464d9ee] | Apr 12 01:28 | |
| -viera/#techrights-Tux Machines: Exaile is an open source and cross platform music player for Windows, macOS and Linux http://www.tuxmachines.org/node/136276 [https://pleroma.site/objects/ee65b6cd-0792-4958-b425-6af2db1085c7] | Apr 12 01:30 | |
| *psydread (eace4d91cc@2a01:7c8:aab8:6b9:5054:ff:fec9:fd84) has left #techrights | Apr 12 01:30 | |
| -viera/#techrights-Tux Machines: 15 Useful Examples of touch Command in Linux System http://www.tuxmachines.org/node/136275 [https://pleroma.site/objects/c67ca7a2-6e66-4938-b60e-9b5f444f7d71] | Apr 12 01:31 | |
| *psydread (eace4d91cc@2a01:7c8:aab8:6b9:5054:ff:fec9:fd84) has joined #techrights | Apr 12 01:35 | |
| *psydread (eace4d91cc@2a01:7c8:aab8:6b9:5054:ff:fec9:fd84) has left #techrights | Apr 12 01:37 | |
| *psydread (eace4d91cc@2a01:7c8:aab8:6b9:5054:ff:fec9:fd84) has joined #techrights | Apr 12 01:37 | |
| -viera/#techrights-Tux Machines: Fedora Silverblue is an amazing immutable desktop http://www.tuxmachines.org/node/136283 [https://pleroma.site/objects/36021e96-f34a-403d-beae-3623de2e353f] | Apr 12 01:42 | |
| MinceR | https://ircz.de/p/19110315 | Apr 12 01:45 |
| -TechrightsBot-tr/#techrights-ircz.de | IRCZ makes your life worth living Post object (4102360) | Apr 12 01:45 | |
| -viera/#techrights-Tux Machines: Latte bug fix release v0.9.11 https://psifidotos.blogspot.com/2020/04/latte-bug-fix-release-v0911.html [https://pleroma.site/objects/ada75ae0-844d-4aee-86e9-51d99d065ae3] | Apr 12 01:46 | |
| *mmu_man has quit (Ping timeout: 258 seconds) | Apr 12 01:49 | |
| -viera/#techrights-Tux Machines: today's howtos http://www.tuxmachines.org/node/136284 [https://pleroma.site/objects/01275f3c-c6e6-4443-819f-e28e0d497e5e] | Apr 12 02:02 | |
| *smnthermes (976c22869c@xmpp.snopyta.org) has left #techrights | Apr 12 02:16 | |
| -viera/#techrights-Tux Machines: Raspberry PI Imager: new SD flashing tool from RPI Foundation http://www.tuxmachines.org/node/136285 [https://pleroma.site/objects/fc562188-b081-4251-84d1-150a3bfdd464] | Apr 12 02:22 | |
| -viera/#techrights-Tux Machines: KDE: Forking Qt, Plasma Bigscreen and Release of Latte Dock 0.9.11 http://www.tuxmachines.org/node/136286 [https://pleroma.site/objects/bec9d98f-d514-4fea-97ae-895b64d0e80a] | Apr 12 02:30 | |
| -viera/#techrights-Tux Machines: Programming: Rust, Git, Perl and Python http://www.tuxmachines.org/node/136287 [https://pleroma.site/objects/8b7720c9-fc95-440a-8cc8-326814cb5e8d] | Apr 12 02:34 | |
| cubexyz | eh, it's been a bit dull lately | Apr 12 02:54 |
| *smnthermes (976c22869c@xmpp.snopyta.org) has joined #techrights | Apr 12 02:55 | |
| schestowitz | [20:57] <scientes> https://meduza.io/en/feature/2020/04/09/the-only-option-is-to-walk-six-days-to-kathmandu | Apr 12 03:21 |
| -TechrightsBot-tr/#techrights-meduza.io | NO TITLE | Apr 12 03:21 | |
| schestowitz | yeah, I saw that... | Apr 12 03:21 |
| *swaggboi has quit (Quit: C-x C-c) | Apr 12 03:21 | |
| *smnthermes (976c22869c@xmpp.snopyta.org) has left #techrights | Apr 12 03:23 | |
| *swaggboi (~swaggboi@slackware.uk/supporter/swaggboi) has joined #techrights | Apr 12 03:27 | |
| DaemonFC[m] | Christians are still trying to contact tribes in Brazil who have never seen modern humans and have no antibodies for any of our diseases, much less COVID. | Apr 12 03:27 |
| DaemonFC[m] | Could end up wiping out their entire civilization to try to talk about God. | Apr 12 03:27 |
| -viera/#techrights-Tux Machines: EndeavourOS: The April release has arrived http://www.tuxmachines.org/node/136288 [https://pleroma.site/objects/52762065-c572-4f8e-8213-0cbc06ba4691] | Apr 12 03:27 | |
| *smnthermes (976c22869c@xmpp.snopyta.org) has joined #techrights | Apr 12 03:27 | |
| *brendyyn (~brendyyn@14.2.166.143) has joined #techrights | Apr 12 03:28 | |
| oiaohm | DaemonFC[m]: to be correct the risk is double sided as well they could have a disease none of us have seen eithr. | Apr 12 03:30 |
| -viera/#techrights-Tux Machines: NetworkManager 1.24 Coming Soon With VRF Support, Opportunistic Wireless Encryption http://www.tuxmachines.org/node/136289 [https://pleroma.site/objects/59879ace-4ff1-4c80-b2ab-2bb5ab574120] | Apr 12 03:43 | |
| *TechrightsBot-tr has quit (Ping timeout: 256 seconds) | Apr 12 03:55 | |
| DaemonFC[m] | > DaemonFC: to be correct the risk is double sided as well they could have a disease none of us have seen eithr. | Apr 12 03:57 |
| DaemonFC[m] | I'm pretty sure that modern humans have unleashed most of the nasties out there already. | Apr 12 03:57 |
| DaemonFC[m] | SARS kept coming up but the US never took it seriously due to bad leadership. | Apr 12 03:57 |
| DaemonFC[m] | The Pentagon even warned about pandemic SARS in 2017 and Trump just crumpled it up and tossed it in the garbage on the way to the golf course. | Apr 12 04:00 |
| *smnthermes (976c22869c@xmpp.snopyta.org) has left #techrights | Apr 12 04:03 | |
| *smnthermes (976c22869c@xmpp.snopyta.org) has joined #techrights | Apr 12 04:03 | |
| *TechrightsBot-tr (~TR@199.19.78.19) has joined #techrights | Apr 12 04:09 | |
| TechrightsBot-tr | Hello World! I'm TechrightsBot-tr running phIRCe v0.77 | Apr 12 04:09 |
| *smnthermes (976c22869c@xmpp.snopyta.org) has left #techrights | Apr 12 04:09 | |
| *TechrightsBot-tr has quit (Ping timeout: 265 seconds) | Apr 12 04:47 | |
| *psydread (eace4d91cc@2a01:7c8:aab8:6b9:5054:ff:fec9:fd84) has left #techrights | Apr 12 04:53 | |
| *psydread (eace4d91cc@2a01:7c8:aab8:6b9:5054:ff:fec9:fd84) has joined #techrights | Apr 12 04:53 | |
| *TechrightsBot-tr (~TR@199.19.78.19) has joined #techrights | Apr 12 04:58 | |
| TechrightsBot-tr | Hello World! I'm TechrightsBot-tr running phIRCe v0.77 | Apr 12 04:58 |
| schestowitz | DaemonFC[m]: some islanders have legit reasons to drive away 'invaders'... esp. the germ aspect | Apr 12 05:10 |
| schestowitz | I read about some remote islanders near India | Apr 12 05:10 |
| schestowitz | they have experience getting plagues when even one outsider comes calling | Apr 12 05:11 |
| schestowitz | with or without a holy book at hand | Apr 12 05:11 |
| *Hail_Spacecake has quit (Remote host closed the connection) | Apr 12 05:25 | |
| *Hail_Spacecake (~weechat@lobsters/users/hailspacecake/x-84238744) has joined #techrights | Apr 12 05:26 | |
| *TechrightsBot-tr has quit (Remote host closed the connection) | Apr 12 05:51 | |
| *TechrightsBot-tr (~TR@199.19.78.19) has joined #techrights | Apr 12 05:52 | |
| TechrightsBot-tr | Hello World! I'm TechrightsBot-tr running phIRCe v0.77 | Apr 12 05:52 |
| *CrystalMath has quit (Quit: Support Richard Stallman and other victims of cancel culture! | https://sterling-archermedes.github.io/) | Apr 12 06:03 | |
| schestowitz | Ariadne: are you around at the moment? | Apr 12 06:23 |
| DaemonFC[m] | schestowitz: Trying to make sense of all these Trump -10 through -15 polls. | Apr 12 06:28 |
| *vallor has quit (Quit: No Ping reply in 180 seconds.) | Apr 12 06:28 | |
| *vallor (~Ponzo@pdpc/supporter/monthlygold/vallor) has joined #techrights | Apr 12 06:28 | |
| DaemonFC[m] | Is it because people are angry at him or that old folks are dying off en masse while nobody wants to say it's COVID and that's why they're not answering the polls? | Apr 12 06:29 |
| DaemonFC[m] | Both maybe? | Apr 12 06:29 |
| DaemonFC[m] | Honestly, if the election gets thrown and Trump and his people are gone forever, at least some good came out of this. | Apr 12 06:30 |
| DaemonFC[m] | Most of the Republican voter suppression tactics can reduce turnout a percent or two, but they can't bring back hundreds of thousands of their voters from the dead. | Apr 12 06:30 |
| DaemonFC[m] | Nor can they prevent everyone who is pissed off about the ruined economy from heading to the voting booth. | Apr 12 06:31 |
| DaemonFC[m] | So they may very well start losing elections in some unexpected states. | Apr 12 06:31 |
| DaemonFC[m] | I think, honestly, enough people will die that it could very well change the election outcome in Biden's favor even without the shit economy and everything like that. | Apr 12 06:32 |
| *schestowitz has quit (Read error: Connection reset by peer) | Apr 12 06:34 | |
| *schestowitz (~schestowi@host81-154-172-215.range81-154.btcentralplus.com) has joined #techrights | Apr 12 06:34 | |
| *schestowitz has quit (Changing host) | Apr 12 06:34 | |
| *schestowitz (~schestowi@unaffiliated/schestowitz) has joined #techrights | Apr 12 06:34 | |
| -viera/#techrights-Tux Machines: #Android Leftovers http://www.tuxmachines.org/node/136290 [https://pleroma.site/objects/10ecb124-8b7f-4254-a43e-6f75453c1042] | Apr 12 08:39 | |
| schestowitz | Ariadne: we need very urgent help, the VM is in a poor state for techrights and we may need to urgently replace it | Apr 12 09:05 |
| *liberty_box has quit (Ping timeout: 258 seconds) | Apr 12 09:18 | |
| *rianne has quit (Ping timeout: 260 seconds) | Apr 12 09:18 | |
| *sb0_ (~lekernel@138019142104.ctinets.com) has joined #techrights | Apr 12 09:42 | |
| Ariadne | we can probably work on that this week sometime | Apr 12 09:57 |
| schestowitz | thank you!! | Apr 12 09:58 |
| schestowitz | is it possible to do also today? We'll pay fro the time | Apr 12 09:58 |
| schestowitz | I spent ages trying to find email address for you | Apr 12 09:59 |
| schestowitz | I reckon we can do a lot of the recovery with a little help here and there, esp. vm config and copying /home across to the new VM | Apr 12 09:59 |
| Ariadne | today is not particularly great for me | Apr 12 09:59 |
| schestowitz | it can be any distro you think would be good, maybe Alpine or Debian or Debuan | Apr 12 10:00 |
| schestowitz | *Devuan | Apr 12 10:00 |
| schestowitz | I think the site will be offline until we have something to replace it | Apr 12 10:00 |
| schestowitz | and that would devastate us... also, we'd pay for the time | Apr 12 10:00 |
| Ariadne | what exactly is the issue with the VM | Apr 12 10:01 |
| schestowitz | well... /var ran out of space | Apr 12 10:01 |
| schestowitz | because of a VM crash | Apr 12 10:01 |
| schestowitz | apparently it crashed while doing mysql repair | Apr 12 10:01 |
| schestowitz | and then it filled up /var after the reboot | Apr 12 10:01 |
| schestowitz | I think the DB itself might be recoverable, we tried all sorts of things for 5 hours now | Apr 12 10:01 |
| Ariadne | my suggestion would be to recover the database and bring the site back up for today. tomorrow I can work on it | Apr 12 10:02 |
| schestowitz | but the /var partition is too small to deal with such edge cases | Apr 12 10:02 |
| schestowitz | OK, Ariadne, we'll try that | Apr 12 10:02 |
| *liberty_box (~liberty@host81-154-172-215.range81-154.btcentralplus.com) has joined #techrights | Apr 12 10:02 | |
| *rianne (~rianne@host81-154-172-215.range81-154.btcentralplus.com) has joined #techrights | Apr 12 10:02 | |
| schestowitz | Ariadne: what time (roughly) tomorrow? | Apr 12 10:02 |
| Ariadne | whenever is good for you. I spent the past 24 hours playing final fantasy 7 remake through entirely end to end with only a few naps and now welp, I really need to sleep | Apr 12 10:04 |
| Ariadne | you don't want me doing sysadmin right now, it will be fucked up for sure | Apr 12 10:04 |
| schestowitz | Ah, OK, when you say tomorrow you mean Monday? | Apr 12 10:04 |
| schestowitz | (it's 10am in England, the issue started around 4am) | Apr 12 10:05 |
| Ariadne | yes. today is already sunday | Apr 12 10:05 |
| schestowitz | I thought maybe you stayed up very late and meant Saturday. OK, I'll see if I can bring the site back up safety as sort of read-only, for now... | Apr 12 10:06 |
| schestowitz | Like I said, we'll pay for your time, we really appreciate everything! | Apr 12 10:06 |
| Ariadne | well really I mean whenever I wake up | Apr 12 10:06 |
| Ariadne | so like later today really | Apr 12 10:06 |
| schestowitz | aha :-) | Apr 12 10:09 |
| schestowitz | cheers! | Apr 12 10:09 |
| schestowitz | have a good sleep, the site will take a holiday ;-) | Apr 12 10:09 |
| schestowitz | the upgrades/migrations to another OS were well oversue anyway, a lot of packages were well out of date and disk space a bit tight (we just passed the VMs as they were from prior HV) | Apr 12 10:10 |
| Ariadne | also at some point, a datacenter upgrade will happen | Apr 12 10:10 |
| Ariadne | there is a DC in Cheyenne about 30 minutes from where I live. I intend to set up new hardware there and decomission the stuff at fiberhub | Apr 12 10:11 |
| schestowitz | If it's all VMs, then migrating them should be OK (or containers) | Apr 12 10:12 |
| Ariadne | with containers I suggest that we set up a shared container for mysql | Apr 12 10:12 |
| schestowitz | no issue, what scares me most is just data loss, not downtimes ;-) | Apr 12 10:12 |
| Ariadne | and then individual containers for techrights and tuxmachines | Apr 12 10:12 |
| schestowitz | sure, I trust you know how to manage containers | Apr 12 10:13 |
| Ariadne | and then have a container for load balancing / ssl | Apr 12 10:13 |
| schestowitz | we need to add httpd to those at some stage. With old (but supported) centos we lacked some packages | Apr 12 10:13 |
| Ariadne | what we can do is have a backend network some sort of 10.x ips | Apr 12 10:13 |
| schestowitz | that would be a step forward, yes... | Apr 12 10:14 |
| Ariadne | and I guess use either traefik or nginx for that | Apr 12 10:14 |
| Ariadne | instead of apache | Apr 12 10:14 |
| schestowitz | we always had them as VMs, in 2007 it was still shared hosting | Apr 12 10:14 |
| Ariadne | I like traefik because it has some ddos mitigations built into it | Apr 12 10:14 |
| schestowitz | apache isn't hard-coded into anything we use | Apr 12 10:14 |
| schestowitz | (except the way I use apachetop to monitor the sites) | Apr 12 10:15 |
| Ariadne | both traefik and nginx have statsd support | Apr 12 10:16 |
| schestowitz | I see... | Apr 12 10:16 |
| Ariadne | we can set up prometheus to collect those stats and have a nice dashboard | Apr 12 10:16 |
| schestowitz | well, all sounds good, a much-needed modernisation | Apr 12 10:16 |
| schestowitz | it's like we use old centos and LTSes of Drupal and WordPress | Apr 12 10:16 |
| schestowitz | the CMSs are safe, the underlying OSes less so, so the migrations would help | Apr 12 10:17 |
| schestowitz | I looked into prometheus some months ago before using apachetop instead | Apr 12 10:17 |
| Ariadne | anyway nini | Apr 12 10:22 |
| schestowitz | speak soon | Apr 12 10:22 |
| schestowitz | I'll stay home today | Apr 12 10:22 |
| *liberty_box has quit (Ping timeout: 240 seconds) | Apr 12 11:23 | |
| *rianne has quit (Ping timeout: 264 seconds) | Apr 12 11:23 | |
| *tdemin has quit (Remote host closed the connection) | Apr 12 11:24 | |
| *rianne (~rianne@host81-154-172-215.range81-154.btcentralplus.com) has joined #techrights | Apr 12 11:29 | |
| *liberty_box (~liberty@host81-154-172-215.range81-154.btcentralplus.com) has joined #techrights | Apr 12 11:29 | |
| MinceR | 12 042732 < DaemonFC[m]> Could end up wiping out their entire civilization to try to talk about God. | Apr 12 12:08 |
| MinceR | even the memes they carry are deadly | Apr 12 12:08 |
| *sb0_ has quit (Ping timeout: 250 seconds) | Apr 12 12:08 | |
| -viera/#techrights-Tux Machines: Top 5 Linux Distros That Offer Cutting Edge Updates http://www.tuxmachines.org/node/136291 [https://pleroma.site/objects/d2cef2ac-ea7e-445b-9256-379241ead70e] | Apr 12 12:57 | |
| *gde33 (~gde333@84-106-154-98.cable.dynamic.v4.ziggo.nl) has joined #techrights | Apr 12 12:57 | |
| MinceR | (cat) https://full.pr0gramm.com/2020/01/30/4c61021a8ded54cd.jpg | Apr 12 13:01 |
| oiaohm | MinceR: now that would make a warped movie. A movie where every time a char saw a meme that came the end of them in some way. | Apr 12 13:01 |
| MinceR | most of the memes christianity is made of are more often heard or read than seen :> | Apr 12 13:04 |
| -viera/#techrights-Tux Machines: This week in KDE: Libinput scroll speed, Dolphin remote access improvements, and more http://www.tuxmachines.org/node/136292 [https://pleroma.site/objects/e0d88c73-2f2e-41aa-a8fd-407fb3b110bc] | Apr 12 13:05 | |
| MinceR | https://ircz.de/p/19103148 | Apr 12 13:12 |
| -TechrightsBot-tr/#techrights-ircz.de | IRCZ makes your life worth living Post object (4095516) | Apr 12 13:12 | |
| XRevan86 | MinceR: They want to keep us on our knees! The time to rise is now! | Apr 12 13:15 |
| MinceR | :> | Apr 12 13:16 |
| -viera/#techrights-Tux Machines: KDE Finally Has Support For Configuring The Scroll Speed... http://www.tuxmachines.org/node/136292#comment-24566 [https://pleroma.site/objects/617be305-6d4f-48b9-aaa5-efcdf61491ef] | Apr 12 13:18 | |
| -viera/#techrights-Tux Machines: today's howtos http://www.tuxmachines.org/node/136293 [https://pleroma.site/objects/44007822-6fbf-4c52-b59c-067381abafad] | Apr 12 13:21 | |
| *a1batross (f99f96a489@gateway/shell/jabberfr/x-jhrirywidvjfjfhh) has joined #techrights | Apr 12 13:23 | |
| kingoffrance | lol ff7...i saw john wick 3 fighting on a motorcycle with a sword, wonder if keanu studied cloud | Apr 12 13:23 |
| -viera/#techrights-Tux Machines: Software Releases: PyPy, Nageru and man-pages http://www.tuxmachines.org/node/136294 [https://pleroma.site/objects/a2d0af06-3c58-4817-b6eb-6a895b9d7510] | Apr 12 13:25 | |
| -viera/#techrights-Tux Machines: Audiocasts/Shows: #Ubuntu Podcast, Remote Play #PS4 with #Linux , Full Circle Weekly News http://www.tuxmachines.org/node/136295 [https://pleroma.site/objects/74c82b20-7a84-46dd-9c17-530312a70ac7] | Apr 12 13:37 | |
| *rianne has quit (Ping timeout: 240 seconds) | Apr 12 13:38 | |
| *liberty_box has quit (Ping timeout: 260 seconds) | Apr 12 13:39 | |
| -viera/#techrights-Tux Machines: Programming and Development Leftovers http://www.tuxmachines.org/node/136296 [https://pleroma.site/objects/b7693010-545c-4528-a2ce-71b351ebb433] | Apr 12 13:42 | |
| *Cradamy has quit (Quit: Cradamy) | Apr 12 13:42 | |
| *Cradamy (~Cradamy@ip96.ip-137-74-57.eu) has joined #techrights | Apr 12 13:43 | |
| *tdemin (~tdemin@2a02:2698:882a:138f::209) has joined #techrights | Apr 12 13:47 | |
| *mmu_man (~revol@vaf26-2-82-244-111-82.fbx.proxad.net) has joined #techrights | Apr 12 13:56 | |
| *smnthermes (976c22869c@xmpp.snopyta.org) has joined #techrights | Apr 12 14:09 | |
| MinceR | https://ircz.de/p/1910311 | Apr 12 14:15 |
| -TechrightsBot-tr/#techrights-ircz.de | IRCZ makes your life worth living Post object (4094294) | Apr 12 14:15 | |
| *rianne (~rianne@host81-154-172-215.range81-154.btcentralplus.com) has joined #techrights | Apr 12 14:31 | |
| *liberty_box (~liberty@host81-154-172-215.range81-154.btcentralplus.com) has joined #techrights | Apr 12 14:32 | |
| *brendyyn has quit (Ping timeout: 256 seconds) | Apr 12 14:54 | |
| *CrystalMath (~coderain@reactos/developer/theflash) has joined #techrights | Apr 12 15:08 | |
| *Cradamy has quit (Quit: Cradamy) | Apr 12 15:10 | |
| *Cradamy (~Cradamy@ip96.ip-137-74-57.eu) has joined #techrights | Apr 12 15:10 | |
| *gde33 has quit (Read error: Connection reset by peer) | Apr 12 15:27 | |
| *smnthermes (976c22869c@xmpp.snopyta.org) has left #techrights | Apr 12 15:37 | |
| *smnthermes (976c22869c@xmpp.snopyta.org) has joined #techrights | Apr 12 15:37 | |
| *a1batross (f99f96a489@gateway/shell/jabberfr/x-jhrirywidvjfjfhh) has left #techrights | Apr 12 15:46 | |
| *a1batross (f99f96a489@gateway/shell/jabberfr/x-jhrirywidvjfjfhh) has joined #techrights | Apr 12 15:54 | |
| *gde33 (~gde333@84-106-154-98.cable.dynamic.v4.ziggo.nl) has joined #techrights | Apr 12 16:18 | |
| *liberty_box has quit (Ping timeout: 265 seconds) | Apr 12 16:24 | |
| *rianne has quit (Ping timeout: 264 seconds) | Apr 12 16:24 | |
| -viera/#techrights-Tux Machines: Proprietary Stuff and Abuse http://www.tuxmachines.org/node/136297 [https://pleroma.site/objects/423cb69d-a786-41bf-8484-c7522a2fe529] | Apr 12 16:38 | |
| *smnthermes (976c22869c@xmpp.snopyta.org) has left #techrights | Apr 12 16:39 | |
| -viera/#techrights-Tux Machines: Do You Plan to Upgrade to or Install Ubuntu 20.04 LTS? [Poll] http://www.tuxmachines.org/node/135958#comment-24567 [https://pleroma.site/objects/f117bdd9-2865-488c-9154-fb5e2ec74abe] | Apr 12 16:42 | |
| *smnthermes (976c22869c@xmpp.snopyta.org) has joined #techrights | Apr 12 16:42 | |
| *libertybox_ (~schestowi@host81-154-172-215.range81-154.btcentralplus.com) has joined #techrights | Apr 12 16:46 | |
| *acer-box__ (~acer-box@host81-154-172-215.range81-154.btcentralplus.com) has joined #techrights | Apr 12 16:46 | |
| *acer-box__ has quit (Changing host) | Apr 12 16:46 | |
| *acer-box__ (~acer-box@unaffiliated/schestowitz) has joined #techrights | Apr 12 16:46 | |
| *libertybox has quit (Ping timeout: 250 seconds) | Apr 12 16:49 | |
| *acer-box has quit (Ping timeout: 258 seconds) | Apr 12 16:49 | |
| *rianne (~rianne@host81-154-172-215.range81-154.btcentralplus.com) has joined #techrights | Apr 12 16:53 | |
| *liberty_box (~liberty@host81-154-172-215.range81-154.btcentralplus.com) has joined #techrights | Apr 12 16:54 | |
| -viera/#techrights-Tux Machines: SUSE and Red Hat Leftovers http://www.tuxmachines.org/node/136299 [https://pleroma.site/objects/ab285e5d-4ff8-4f7c-a040-6e0ead2fb00c] | Apr 12 17:10 | |
| -viera/#techrights-Tux Machines: Alexander Mikhaylenko: On windows and titlebars http://www.tuxmachines.org/node/136300 [https://pleroma.site/objects/e3dcc49c-fa94-4860-b941-0ea857cc3713] | Apr 12 17:13 | |
| schestowitz | Ariadne: ready when you are.... ;-) no rush, I put a placeholder status HTML in all the site's pages for now, to say we're upgrading/migrating today | Apr 12 17:15 |
| -viera/#techrights-Tux Machines: Games: Anodyne, Valve and Easter Game http://www.tuxmachines.org/node/136301 [https://pleroma.site/objects/c7cf1fcb-09b3-4f3b-888f-4b330a634717] | Apr 12 17:32 | |
| *smnthermes (976c22869c@xmpp.snopyta.org) has left #techrights | Apr 12 17:34 | |
| -viera/#techrights-Tux Machines: Openwashing Leftovers http://www.tuxmachines.org/node/136302 [https://pleroma.site/objects/dd47d127-af10-4258-93c9-8c0bf302e01f] | Apr 12 17:34 | |
| -viera/#techrights-Tux Machines: OSS Leftovers http://www.tuxmachines.org/node/136303 [https://pleroma.site/objects/371e823a-70dc-4adb-a814-177159e40117] | Apr 12 17:41 | |
| -viera/#techrights-Tux Machines: Docker builds open source community around Compose Specification http://www.tuxmachines.org/node/136304 [https://pleroma.site/objects/54782405-9f7e-4982-a2dc-f0df956542df] | Apr 12 18:19 | |
| -viera/#techrights-Tux Machines: The New Features Of The Linux 5.7 Kernel http://www.tuxmachines.org/node/135850#comment-24569 [https://pleroma.site/objects/98efc6da-622b-4f2c-b3e2-963a102ea38d] | Apr 12 18:21 | |
| -viera/#techrights-Tux Machines: Benchmarks and Graphics: Google Research, Phoronix Test Suite and "High Performance" DG2 GPU http://www.tuxmachines.org/node/136305 [https://pleroma.site/objects/01624264-035b-4e5c-b773-2bf8ee7a5aa9] | Apr 12 18:27 | |
| -viera/#techrights-Tux Machines: today's howtos http://www.tuxmachines.org/node/136306 [https://pleroma.site/objects/9e6d8a61-c9fc-4da2-95c0-63a556d0337c] | Apr 12 18:30 | |
| -viera/#techrights-Tux Machines: More OSS Leftovers http://www.tuxmachines.org/node/136307 [https://pleroma.site/objects/a3e5e6dc-a4c0-4f42-b737-53b0c6177aed] | Apr 12 18:36 | |
| *smnthermes (976c22869c@xmpp.snopyta.org) has joined #techrights | Apr 12 18:47 | |
| -viera/#techrights-Tux Machines: Open Access/Content/Data: Free Universal Sound Separation, Open Source Cookbook, OER and GreenLight http://www.tuxmachines.org/node/136308 [https://pleroma.site/objects/367f135f-55e8-48c4-8372-0a8eb2a11148] | Apr 12 18:53 | |
| *schestowitz has quit (Quit: Konversation term) | Apr 12 19:07 | |
| *schestowitz (~schestowi@unaffiliated/schestowitz) has joined #techrights | Apr 12 19:08 | |
| *paradigm has quit (Quit: leaving) | Apr 12 19:37 | |
| Ariadne | scientes: ok | Apr 12 20:12 |
| Ariadne | schestowitz: ok | Apr 12 20:12 |
| Ariadne | schestowitz: what VM are we fixing | Apr 12 20:12 |
| schestowitz | hi | Apr 12 20:15 |
| schestowitz | it's the techrigths VM | Apr 12 20:16 |
| Ariadne | oh no | Apr 12 20:17 |
| schestowitz | .78.19 | Apr 12 20:17 |
| Ariadne | ok | Apr 12 20:17 |
| Ariadne | i think we should create a container, copy the database files into it and try to recover the database first | Apr 12 20:17 |
| Ariadne | then get the VM back up and running using that external DB | Apr 12 20:17 |
| Ariadne | what do you think | Apr 12 20:18 |
| schestowitz | yeah, let's try the DB first | Apr 12 20:18 |
| Ariadne | ok | Apr 12 20:18 |
| schestowitz | the db is on /var/lib/mysql | Apr 12 20:18 |
| Ariadne | i'm going to create an internal network that is NAT | Apr 12 20:18 |
| schestowitz | we made a copy offsite of it | Apr 12 20:18 |
| Ariadne | that way the DB is not exposed | Apr 12 20:19 |
| schestowitz | cheers, Ariadne | Apr 12 20:19 |
| -viera/#techrights-Tux Machines: Ubuntu 20.04 + Deepin — Perfect combination for a beautiful Linux distro http://www.tuxmachines.org/node/135958#comment-24570 [https://pleroma.site/objects/e7f6b55c-1061-4a89-a0a2-b25b34f60685] | Apr 12 20:26 | |
| schestowitz | Ariadne: there are 3 mariadb DBs, sizes of them are as follows | Apr 12 20:28 |
| schestowitz | 957416 ./boycottn_wiki | Apr 12 20:29 |
| schestowitz | 1622652 ./boycottn_wrdp1 | Apr 12 20:29 |
| schestowitz | 1032 ./boycottn_drupal | Apr 12 20:29 |
| schestowitz | the wiki is compressible, about 200mb compressed, wrdp = wordpress about 1000mb when compressed, 5gb or so when expanded | Apr 12 20:31 |
| schestowitz | drupal is lighter and compressible, it's mostly front page stuff for new visitors. At the moment the /var partition is about 18gb in size and ibdata1 became too big, about 14 gb and even more | Apr 12 20:32 |
| schestowitz | our suspicion is: | Apr 12 20:32 |
| schestowitz | server/vm crashed, we then did DB repair, then during the repair it crashed again, when never happened before. So back online, the server had the repair run again and ibdata1 then grew so large, in the process, that it overran partition size | Apr 12 20:33 |
| schestowitz | then we put the file's copy under /home, symlinked it, attempted a repair again, but somehow /var itself ran out of space again | Apr 12 20:34 |
| schestowitz | so whether the DB is recoverable from the old ibdata1 we do not know for sure, but we hope so. Failing that, we have a day-old dumb of all three DBs (but would rather attempt to first recover the live DB, not restore from backups, for a number of reasons) | Apr 12 20:35 |
| -viera/#techrights-Tux Machines: #Android Leftovers http://www.tuxmachines.org/node/136309 [https://pleroma.site/objects/ebb636a0-9bdc-439d-ab5f-823fe3996f95] | Apr 12 20:37 | |
| *liberty_box has quit (Ping timeout: 258 seconds) | Apr 12 20:43 | |
| *rianne has quit (Ping timeout: 256 seconds) | Apr 12 20:44 | |
| Ariadne | ok | Apr 12 20:47 |
| Ariadne | hopefully you did not damage the databases :( | Apr 12 20:47 |
| schestowitz | hopefully | Apr 12 20:48 |
| schestowitz | but if it's damaged, we can restore | Apr 12 20:48 |
| schestowitz | I made about 8 articles since then, but I have a copy from Google Cache of these | Apr 12 20:48 |
| Ariadne | hmm | Apr 12 20:49 |
| schestowitz | which would take 1-2 hours of work to somehow merge back in.... but it's better than nothing | Apr 12 20:49 |
| Ariadne | schestowitz: i forgot what the root password on the hypervisor is | Apr 12 20:49 |
| schestowitz | I have it, but how to send it? | Apr 12 20:49 |
| Ariadne | wait no | Apr 12 20:49 |
| Ariadne | nevermind | Apr 12 20:49 |
| Ariadne | i got in | Apr 12 20:49 |
| schestowitz | /img | Apr 12 20:50 |
| schestowitz | localhost:~# uptime | Apr 12 20:50 |
| schestowitz | 19:49:58 up 501 days, 22:28, load average: 1.61, 1.47, 1.57 | Apr 12 20:50 |
| schestowitz | oh, wow. 500 days. Long live Alpine! | Apr 12 20:50 |
| Ariadne | maybe we should update the software while here | Apr 12 20:50 |
| schestowitz | can do... | Apr 12 20:50 |
| Ariadne | going to run apk upgrade to latest stable and reboot | Apr 12 20:50 |
| Ariadne | actually | Apr 12 20:51 |
| Ariadne | going to get the ipmi IP first | Apr 12 20:51 |
| Ariadne | before i do anything | Apr 12 20:51 |
| Ariadne | and make sure i can console it | Apr 12 20:51 |
| -viera/#techrights-Tux Machines: #Linux 5.7 Will Let You Setup A Swap File Over A Network With SMB http://www.tuxmachines.org/node/135850#comment-24571 #kernel [https://pleroma.site/objects/52643bfb-7eda-409d-b321-f97300b27ca9] | Apr 12 20:51 | |
| Ariadne | because i am not looking to make a road trip to vegas at this time | Apr 12 20:51 |
| schestowitz | good idea... | Apr 12 20:52 |
| Ariadne | wut | Apr 12 20:52 |
| Ariadne | i have this ipmi internet-facing | Apr 12 20:52 |
| *rianne (~rianne@host81-154-172-215.range81-154.btcentralplus.com) has joined #techrights | Apr 12 20:53 | |
| schestowitz | with password hopefully ;-) | Apr 12 20:53 |
| Ariadne | yeah but i forgot it | Apr 12 20:54 |
| Ariadne | resetting with ipmitool | Apr 12 20:54 |
| schestowitz | cool, thanks | Apr 12 20:54 |
| Ariadne | i'll set it to something and give it to you | Apr 12 20:54 |
| Ariadne | hahahaha | Apr 12 20:54 |
| *liberty_box (~liberty@host81-154-172-215.range81-154.btcentralplus.com) has joined #techrights | Apr 12 20:54 | |
| schestowitz | I guess we do some housekeeping while at it all... I did sometimes wonder about HV patches, inc. some which affected qemu and were considered serious a year ago | Apr 12 20:54 |
| Ariadne | oh right now i remember | Apr 12 20:56 |
| Ariadne | i was having issues with my wireguard setup | Apr 12 20:56 |
| Ariadne | so i just had fiberhub make the ipmi public when they racked that machine | Apr 12 20:56 |
| Ariadne | ok | Apr 12 20:57 |
| Ariadne | updating | Apr 12 20:57 |
| Ariadne | to alpine 3.11 | Apr 12 20:57 |
| Ariadne | from 3.8 | Apr 12 20:57 |
| Ariadne | then i will set up the lxc | Apr 12 20:57 |
| schestowitz | cheers, tuxmachines VM is still running and is online as a site, techrights just serves a static page to say 'back soon' | Apr 12 20:59 |
| Ariadne | okay | Apr 12 20:59 |
| Ariadne | going to have to shut those VMs down to reboot | Apr 12 20:59 |
| schestowitz | the past week techrights did about 60GB in daily traffic, as it keeps growing in impact thankfully | Apr 12 20:59 |
| schestowitz | can you shut down those VMs from your end? | Apr 12 21:00 |
| schestowitz | to boot tuxmachines we still access it over vnc to press ENTER at boot, techrights does not have this issue | Apr 12 21:00 |
| Ariadne | well | Apr 12 21:02 |
| Ariadne | once its all on containers | Apr 12 21:02 |
| Ariadne | those issues go away | Apr 12 21:02 |
| Ariadne | :p | Apr 12 21:02 |
| *TechrightsBot-tr has quit (Remote host closed the connection) | Apr 12 21:02 | |
| schestowitz | yeah, I really look forward to it | Apr 12 21:02 |
| Ariadne | ok rebooting into alpine 3.11 | Apr 12 21:02 |
| Ariadne | we were on kernel 4.14 | Apr 12 21:02 |
| Ariadne | now on 5.4 | Apr 12 21:03 |
| schestowitz | bear in mind these VMs still 'crash' for no reason every now and then, sometimes weeks apart, sometimes days apart, we never knew why | Apr 12 21:03 |
| schestowitz | :-) 5.4 | Apr 12 21:03 |
| schestowitz | Torvalds is 50 now | Apr 12 21:03 |
| Ariadne | well they are hacks on hacks at this point | Apr 12 21:03 |
| schestowitz | he moved a number up to avoid 2.40 when he turned 40 | Apr 12 21:03 |
| schestowitz | it was the easy time to migrate from the DC at the time... but huge technical debt | Apr 12 21:04 |
| schestowitz | we never had security breaches in either site and want to keep it that way. tuxmachines turns 16 next month. | Apr 12 21:04 |
| Ariadne | tuxmachines coming up | Apr 12 21:07 |
| Ariadne | feel free to VNC it | Apr 12 21:08 |
| schestowitz | done :-) | Apr 12 21:08 |
| *TechrightsBot-tr (~TR@199.19.78.19) has joined #techrights | Apr 12 21:08 | |
| TechrightsBot-tr | Hello World! I'm TechrightsBot-tr running phIRCe v0.77 | Apr 12 21:08 |
| schestowitz | techrigths reruns these on boot | Apr 12 21:08 |
| Ariadne | adding 10.163.214.0/24 to the vlan for internal | Apr 12 21:09 |
| Ariadne | please add 10.162.214.10/24 to the techrights machine | Apr 12 21:10 |
| Ariadne | mysql will be at 10.162.214.20 | Apr 12 21:10 |
| Ariadne | i enabled unattended upgrades on the hv | Apr 12 21:11 |
| schestowitz | cheers | Apr 12 21:11 |
| schestowitz | when you say add to the techrights machines you mean resolve.conf? | Apr 12 21:12 |
| schestowitz | or db, or notes, or...? | Apr 12 21:12 |
| Ariadne | i mean to the /etc/sysconfig/network | Apr 12 21:12 |
| schestowitz | ah, I see | Apr 12 21:12 |
| Ariadne | because i have no clue how to do it in redhat :D | Apr 12 21:12 |
| Ariadne | maybe add something to /etc/rc.local | Apr 12 21:12 |
| schestowitz | # Created by anaconda | Apr 12 21:12 |
| schestowitz | that's all that file says in the path you mentioned, I forgot which one it turned out to be, we did it in 2018 | Apr 12 21:13 |
| Ariadne | yeah | Apr 12 21:13 |
| Ariadne | i don't know how to add multiple IPs on redhat anymore | Apr 12 21:13 |
| Ariadne | i haven't touched centos on a server in over a decade | Apr 12 21:13 |
| schestowitz | let me check... | Apr 12 21:13 |
| Ariadne | wuh | Apr 12 21:14 |
| Ariadne | hang on | Apr 12 21:14 |
| Ariadne | i gotta reboot again | Apr 12 21:14 |
| schestowitz | ok | Apr 12 21:14 |
| Ariadne | it didnt update kernel because the package name changed | Apr 12 21:14 |
| *TechrightsBot-tr has quit (Remote host closed the connection) | Apr 12 21:15 | |
| schestowitz | ok, at least we know nothing major broken and both machines came back ok, rianne checked tuxmachines the site after the reboot and all was fine | Apr 12 21:15 |
| Ariadne | ok | Apr 12 21:18 |
| DaemonFC[m] | It's almost impossible to get a handle on COVID, even if you are trying your damndest to stop it, which the US isn't. | Apr 12 21:18 |
| Ariadne | now on 5.4.27 | Apr 12 21:18 |
| DaemonFC[m] | So it's clear it's not going away anytime soon. | Apr 12 21:18 |
| Ariadne | ok tuxmachines is all set | Apr 12 21:19 |
| Ariadne | before bringing techrights up | Apr 12 21:19 |
| Ariadne | i was thinking | Apr 12 21:19 |
| Ariadne | maybe we should copy its database files | Apr 12 21:19 |
| Ariadne | straight to the container | Apr 12 21:19 |
| schestowitz | cheers, I pressed ENTER | Apr 12 21:20 |
| schestowitz | rianne will check the site again | Apr 12 21:20 |
| schestowitz | I will look into techrights to see where to change networking | Apr 12 21:20 |
| DaemonFC[m] | There's now enough known cases in the US that over 200,000 would die even if new infections stopped right now. | Apr 12 21:20 |
| Ariadne | ok | Apr 12 21:20 |
| schestowitz | ah, you can get the db | Apr 12 21:20 |
| schestowitz | if back online the site would not serve much anyway, just one static page | Apr 12 21:21 |
| Ariadne | i would like to rebuild techrights as container this week anyway | Apr 12 21:21 |
| *TechrightsBot-tr (~TR@199.19.78.19) has joined #techrights | Apr 12 21:21 | |
| TechrightsBot-tr | Hello World! I'm TechrightsBot-tr running phIRCe v0.77 | Apr 12 21:21 |
| schestowitz | what you want is in /var/lib/mysql | Apr 12 21:21 |
| DaemonFC[m] | There's going to be a noticeable drop in old people. | Apr 12 21:21 |
| schestowitz | Ariadne: cool, thanks! | Apr 12 21:21 |
| Ariadne | going to set up lxc | Apr 12 21:22 |
| *a1batross (f99f96a489@gateway/shell/jabberfr/x-jhrirywidvjfjfhh) has left #techrights | Apr 12 21:22 | |
| schestowitz | rianne days tuxmachines is fine -- comments, screenshot galleries etc. | Apr 12 21:23 |
| schestowitz | it had a good week despite the slow news | Apr 12 21:23 |
| schestowitz | almost all-time record, I think we're doing a lot better than LXer and LinuxToday, Linux.com etc. Faster and broader scope | Apr 12 21:24 |
| schestowitz | I will check techrights networking file/path, I remember it was some odd file with a digit in it | Apr 12 21:24 |
| Ariadne | DaemonFC[m]: maybe old people should stay the fuck at home | Apr 12 21:24 |
| schestowitz | some share the home with younger people like their kids or co-tenants here in council housing | Apr 12 21:25 |
| Ariadne | i have a daily ritual now, my grandparents call me, and they tell me there is a thing called COVID-19 killing people, and that i should see a doctor if i get sick, and then i ask them where they are, and they say "walmart" or something | Apr 12 21:25 |
| Ariadne | and i'm just like "..." | Apr 12 21:25 |
| Ariadne | i've done what i can | Apr 12 21:25 |
| schestowitz | network-scripts/ifcfg-eth0:IPADDR=199.19.78.19 | Apr 12 21:26 |
| schestowitz | network-scripts/ifcfg-eth0:GATEWAY=199.19.78.17 | Apr 12 21:26 |
| schestowitz | network-scripts/ifcfg-ens6:IPADDR=199.19.78.19 | Apr 12 21:26 |
| schestowitz | network-scripts/ifcfg-ens6:GATEWAY=199.19.78.17 | Apr 12 21:26 |
| Ariadne | yeah | Apr 12 21:26 |
| Ariadne | i don't know | Apr 12 21:26 |
| schestowitz | from grep -R ".19" | Apr 12 21:26 |
| Ariadne | we can just add something to /etc/rc.local i guess | Apr 12 21:26 |
| schestowitz | should I change IPADDR in both? | Apr 12 21:27 |
| Ariadne | no | Apr 12 21:27 |
| Ariadne | leave it alone | Apr 12 21:27 |
| schestowitz | OK | Apr 12 21:27 |
| Ariadne | i will hack up a solution | Apr 12 21:27 |
| schestowitz | cheers! | Apr 12 21:27 |
| Ariadne | ok installed iptables and set up the NAT for 10.163.214.0/24 | Apr 12 21:30 |
| Ariadne | which is a random /24 i pulled out of my ass | Apr 12 21:30 |
| XRevan86 | Ariadne: Still using iptables, eh? | Apr 12 21:30 |
| Ariadne | i checked to make sure it wasn't in use | Apr 12 21:30 |
| Ariadne | XRevan86: i have a template for this container setup | Apr 12 21:31 |
| schestowitz | excellent! | Apr 12 21:31 |
| Ariadne | i should update to nftables | Apr 12 21:31 |
| Ariadne | but | Apr 12 21:31 |
| Ariadne | now is not the time | Apr 12 21:31 |
| XRevan86 | Ariadne: With new iptables you can add it and then export the result %) | Apr 12 21:31 |
| *Digit has quit (Read error: Connection reset by peer) | Apr 12 21:32 | |
| *Ariadne lxc-create -t alpine -n mysql-shared | Apr 12 21:33 | |
| schestowitz | just to note, Ariadne: | Apr 12 21:34 |
| schestowitz | lrwxrwxrwx. 1 root root 34 Apr 12 06:29 ibdata1 -> /home/boycottn/tmp_mariadb/ibdata1 | Apr 12 21:34 |
| schestowitz | -rw-rw----. 1 mysql mysql 14320467968 Apr 12 06:04 ibdata1.orig | Apr 12 21:34 |
| Ariadne | ok | Apr 12 21:35 |
| schestowitz | from /var/lib/mysql/ | Apr 12 21:35 |
| schestowitz | the symlink is to a likely more broken file | Apr 12 21:35 |
| Ariadne | where is ibdata1.orig | Apr 12 21:35 |
| schestowitz | the .orig we might be able to do recovery from | Apr 12 21:35 |
| schestowitz | from /var/lib/mysql/ | Apr 12 21:35 |
| Ariadne | ok | Apr 12 21:35 |
| Ariadne | i'll see what is up in a moment | Apr 12 21:35 |
| schestowitz | I think recovery upon a failed recovery made it too big for this partition, but it's only a theory, I'm not familiar with innodb internals | Apr 12 21:36 |
| schestowitz | (also: at one stage after failed recovery we mistakenly put httpd up and it looked like things were OK...) | Apr 12 21:37 |
| *Digitteknohippie (~user@fsf/member/digit) has joined #techrights | Apr 12 21:37 | |
| Ariadne | ok | Apr 12 21:39 |
| Ariadne | OK: 139 MiB in 31 packages | Apr 12 21:40 |
| Ariadne | that's the mysql container | Apr 12 21:40 |
| Ariadne | 139MB disk usage for mysql :D | Apr 12 21:40 |
| Ariadne | 8MB without | Apr 12 21:40 |
| Ariadne | ahahaha | Apr 12 21:40 |
| Ariadne | ok | Apr 12 21:41 |
| *Digitteknohippie has quit (Read error: Connection reset by peer) | Apr 12 21:41 | |
| Ariadne | now going to take tuxmachines down | Apr 12 21:41 |
| schestowitz | finally modern versions :-) | Apr 12 21:41 |
| Ariadne | er not tuxmachines | Apr 12 21:41 |
| Ariadne | techrights | Apr 12 21:41 |
| schestowitz | OK, techrights | Apr 12 21:41 |
| *TechrightsBot-tr has quit (Remote host closed the connection) | Apr 12 21:41 | |
| schestowitz | rianne was going to post the 5.7 rc1 announcement | Apr 12 21:41 |
| schestowitz | (20 minutes ago) | Apr 12 21:42 |
| Ariadne | yeah only taking techrights down | Apr 12 21:42 |
| Ariadne | tuxmachines staying up | Apr 12 21:42 |
| schestowitz | cheers | Apr 12 21:42 |
| schestowitz | I thought maybe you wanted to 'export' TM's DB as well... it's a lot smaller, about 300MB compressed | Apr 12 21:42 |
| Ariadne | wait | Apr 12 21:42 |
| Ariadne | fuck | Apr 12 21:42 |
| Ariadne | h/o | Apr 12 21:42 |
| Ariadne | wait no | Apr 12 21:42 |
| Ariadne | nevermind | Apr 12 21:42 |
| schestowitz | hehe | Apr 12 21:42 |
| *schestowitz confused | Apr 12 21:43 | |
| Ariadne | how much disk should we provision for mysql? | Apr 12 21:43 |
| schestowitz | the terminals here say techrights is down now | Apr 12 21:43 |
| Ariadne | say 50GB? | Apr 12 21:43 |
| *Digitteknohippie (~user@fsf/member/digit) has joined #techrights | Apr 12 21:43 | |
| schestowitz | yes, please | Apr 12 21:43 |
| Ariadne | we have 450GB available | Apr 12 21:43 |
| Ariadne | so i will do 100 | Apr 12 21:43 |
| schestowitz | it took 13.5 years to take up ~15 GB | Apr 12 21:43 |
| schestowitz | with 100MB we can fit the DB dumps/backups on the same partition/containers | Apr 12 21:44 |
| Ariadne | localhost:~# lvcreate -L 100G -n mysql-shared vg0 | Apr 12 21:45 |
| Ariadne | Logical volume "mysql-shared" created. | Apr 12 21:45 |
| Ariadne | localhost:~# mkfs.ext4 /dev/vg0/mysql-shared | Apr 12 21:45 |
| Ariadne | yes | Apr 12 21:45 |
| Ariadne | the idea is to have a common mysql container for all of your projects | Apr 12 21:45 |
| Ariadne | that way we only have to keep one mysql up to date | Apr 12 21:45 |
| schestowitz | tuxmachines DBs are about 8gb, I think, mostly as Gallery2 stores the distro screenshots in the DB | Apr 12 21:45 |
| schestowitz | tuxmachines ~]# mysql --version | Apr 12 21:46 |
| schestowitz | mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1 | Apr 12 21:46 |
| Ariadne | alpine is mariadb | Apr 12 21:47 |
| Ariadne | but its compatible | Apr 12 21:47 |
| Ariadne | mariadb is basically mysql without oracle | Apr 12 21:47 |
| schestowitz | it's mariadb in techrights as well, IIRC | Apr 12 21:47 |
| schestowitz | both centos releases run out of support within months, so it's a good time to migrate away from centos | Apr 12 21:47 |
| Ariadne | indeed, your /var is at 100% utilization | Apr 12 21:48 |
| schestowitz | it has long been starving for space, every weekend I'd flush out the week's log-rotated httpd log files | Apr 12 21:48 |
| Ariadne | yeah, if we use latest-stable and unattended updates on techrights/tuxmachines | Apr 12 21:48 |
| Ariadne | it should just continue working forever | Apr 12 21:48 |
| Ariadne | in theory | Apr 12 21:49 |
| schestowitz | we have scripts we made for many things like nightly backups, backups across VMs, DB repairs etc. | Apr 12 21:49 |
| schestowitz | also sending emails out and there's monitoring we can port over to whatever setup... some of these are over a decade old | Apr 12 21:50 |
| Ariadne | so on the HV | Apr 12 21:52 |
| Ariadne | container status can be checked with | Apr 12 21:52 |
| Ariadne | lxc-ls -F | Apr 12 21:52 |
| Ariadne | container is presently down because i am preparing its /var/lib/mysql | Apr 12 21:52 |
| schestowitz | I'll add to my notes | Apr 12 21:53 |
| Narrator | was tune2fs used? | Apr 12 21:57 |
| Narrator | ;-) | Apr 12 21:57 |
| -viera/#techrights-Tux Machines: Linux 5.7-rc1 http://www.tuxmachines.org/node/136310 [https://pleroma.site/objects/94123332-050b-41e6-ad52-39b706d44c50] | Apr 12 21:57 | |
| Narrator | sometimes there is plenty of space reserved on some partitions | Apr 12 21:58 |
| Ariadne | Narrator: yes | Apr 12 21:59 |
| Ariadne | Narrator: it was literally at 100% utilization | Apr 12 21:59 |
| schestowitz | all partitions are space-right on techrights, for historical reasons | Apr 12 21:59 |
| schestowitz | when one came close to running out we adapted with what was left | Apr 12 21:59 |
| Ariadne | hmm | Apr 12 22:00 |
| Ariadne | i wonder how to recover this | Apr 12 22:00 |
| schestowitz | Ariadne: in this case it's because the file grew unexpectedly after the second repair attempt (first one interrupted by VM crash) | Apr 12 22:00 |
| schestowitz | Ariadne: not to recover from the synlinked file | Apr 12 22:00 |
| Ariadne | innodb_force_recovery=1 | Apr 12 22:00 |
| schestowitz | better from the .old file | Apr 12 22:00 |
| Ariadne | yeah | Apr 12 22:01 |
| Ariadne | i am using the .old | Apr 12 22:01 |
| -viera/#techrights-Tux Machines: 13 ways to use the ls command to list files on Linux http://www.tuxmachines.org/node/136311 [https://pleroma.site/objects/dab79dbb-396c-4c47-97d2-35b1d06faf44] | Apr 12 22:02 | |
| Ariadne | * ERROR: mariadb failed to start | Apr 12 22:02 |
| Ariadne | hmm | Apr 12 22:02 |
| XRevan86 | =2 ? | Apr 12 22:02 |
| Ariadne | i went all the way to 6 | Apr 12 22:02 |
| XRevan86 | There are many levels. | Apr 12 22:02 |
| XRevan86 | oh | Apr 12 22:02 |
| XRevan86 | Ariadne: Does it talk about InnoDB being corrupted? | Apr 12 22:03 |
| Ariadne | pr 12 21:01:57 mysql-shared daemon.err mysqld: 2020-04-12 21:01:57 0 [ERROR] mysqld: File '/var/lib/mysql/aria_log_control' not found (Errcode: 13 "Permission denied") | Apr 12 22:03 |
| Ariadne | ahh | Apr 12 22:03 |
| schestowitz | I think group and permissions were changed | Apr 12 22:03 |
| schestowitz | by my friend | Apr 12 22:03 |
| Ariadne | ya | Apr 12 22:03 |
| schestowitz | to avert risk of the orig being tinkered further with | Apr 12 22:04 |
| Ariadne | what is the mysql password | Apr 12 22:04 |
| Ariadne | for root | Apr 12 22:04 |
| schestowitz | wait... | Apr 12 22:04 |
| Ariadne | ok | Apr 12 22:05 |
| Ariadne | i recovered your DB | Apr 12 22:05 |
| schestowitz | YES! | Apr 12 22:05 |
| schestowitz | I'll do lots of tire-kicking with it before writing any further articles to it :-) | Apr 12 22:06 |
| Ariadne | ok | Apr 12 22:06 |
| Ariadne | so now | Apr 12 22:07 |
| XRevan86 | innodb_undo_tablespaces can only be changed before InnoDB is initialised on MariaDB, so if you're going to remake it, I recommend setting it to 2. | Apr 12 22:07 |
| XRevan86 | A little touch, but very annoying to re-do later. | Apr 12 22:07 |
| XRevan86 | Helps keeping ibdata1 small. | Apr 12 22:07 |
| schestowitz | I shared some web pages about it this morning | Apr 12 22:07 |
| Ariadne | XRevan86: we aren't going to remake it i don't think | Apr 12 22:07 |
| Ariadne | just leave it as it is | Apr 12 22:07 |
| Ariadne | the new stuff i am going to be setting up | Apr 12 22:08 |
| schestowitz | we pondered either moving to newer mariadb or splitting the massive file on a per-table basis, using some option | Apr 12 22:08 |
| schestowitz | but did not wish to do this on a live db/site | Apr 12 22:08 |
| Ariadne | will have NAS with 2x10G | Apr 12 22:08 |
| schestowitz | cheers | Apr 12 22:08 |
| Ariadne | ok | Apr 12 22:08 |
| Ariadne | now | Apr 12 22:08 |
| schestowitz | soooo happy | Apr 12 22:08 |
| XRevan86 | Oh, I thought you'll be fixing this stuff now. If not, then never mind. | Apr 12 22:08 |
| Ariadne | we need to make techrights talk to the db server | Apr 12 22:08 |
| Ariadne | XRevan86: nah i will optimize it later | Apr 12 22:08 |
| schestowitz | three CMSs speak to localhost, wiki, drupal, wordpress | Apr 12 22:09 |
| schestowitz | unless we can alias localhost for DB port | Apr 12 22:09 |
| Ariadne | they will need to speak to 10.163.214.20 | Apr 12 22:09 |
| Ariadne | can probably do something with iptables to forward it but seems icky | Apr 12 22:09 |
| schestowitz | techrights is not reachable for me at the moment, I think intentionally so (VM offline) | Apr 12 22:10 |
| Ariadne | yes | Apr 12 22:10 |
| Ariadne | i havent started it back up yet | Apr 12 22:10 |
| schestowitz | cool | Apr 12 22:10 |
| schestowitz | it doesn't do much either, we disabled the cron jobs to avoid damage to it, e.g. /home running out of space | Apr 12 22:10 |
| schestowitz | BTW, all: | Apr 12 22:12 |
| schestowitz | yesterday a person from the UK offered her help as a summer intern for techrights, coding and stuff | Apr 12 22:13 |
| Ariadne | $IPADDR0 and $IPADDR1 | Apr 12 22:14 |
| schestowitz | parameters? | Apr 12 22:14 |
| XRevan86 | Ariadne: "nah i will optimize it later" – then that advice is for then :) | Apr 12 22:14 |
| Ariadne | ok | Apr 12 22:17 |
| Ariadne | techrights VM starting up | Apr 12 22:17 |
| schestowitz | cheers, what next? Changing to remote IP DB? | Apr 12 22:18 |
| Ariadne | cool | Apr 12 22:18 |
| Ariadne | ok | Apr 12 22:18 |
| cubexyz | I have to keep an eye on my server too | Apr 12 22:18 |
| Ariadne | now i need to make mysql listen on 10.163.214.20 | Apr 12 22:18 |
| cubexyz | some of the drives are +95% full | Apr 12 22:18 |
| schestowitz | cubexyz: might be ok for some drive types, but /var was the last thing we wanted to run out of space and were sure had enough... but sometimes things go wrong, due to bugs | Apr 12 22:19 |
| Ariadne | schestowitz: in meantime, please ping 10.163.214.20 from inside techrights VM to verify it is accessible | Apr 12 22:20 |
| schestowitz | last year we did mysql dump and it went on and on endlessly until /home ran out of space, leaving 20gb dumps instead of 300mb for some reason | Apr 12 22:20 |
| schestowitz | Ariadne: ok, logging back in | Apr 12 22:20 |
| schestowitz | I wonder why the bot did not come back yet... | Apr 12 22:20 |
| Ariadne | hmm | Apr 12 22:21 |
| Ariadne | because it has no gateway | Apr 12 22:21 |
| cubexyz | tons of emails to root, most are useless | Apr 12 22:21 |
| Ariadne | grr | Apr 12 22:21 |
| schestowitz | the VM cannot be sshed to | Apr 12 22:21 |
| Ariadne | hang on | Apr 12 22:21 |
| schestowitz | a.b.c. 19 | Apr 12 22:21 |
| schestowitz | https://bluesabre.org/2020/04/12/xubuntu-20-04-in-screenshots-the-installer/ | Apr 12 22:22 |
| schestowitz | ot, to rianne | Apr 12 22:22 |
| Ariadne | ok | Apr 12 22:23 |
| Ariadne | now it has gateway | Apr 12 22:23 |
| *TechrightsBot-tr (~TR@199.19.78.19) has joined #techrights | Apr 12 22:24 | |
| TechrightsBot-tr | Hello World! I'm TechrightsBot-tr running phIRCe v0.77 | Apr 12 22:24 |
| Ariadne | schestowitz: now, please verify that while i make mysql listen on 0.0.0.0 | Apr 12 22:24 |
| Ariadne | ok | Apr 12 22:25 |
| Ariadne | cool | Apr 12 22:25 |
| cubexyz | I backup my drupal database one every 24 hours | Apr 12 22:25 |
| cubexyz | it has gone bad a couple of times since 2004 | Apr 12 22:26 |
| schestowitz | ok, logged back in | Apr 12 22:26 |
| schestowitz | 64 bytes from 10.163.214.20: icmp_seq=1 ttl=64 time=0.146 ms\ | Apr 12 22:26 |
| schestowitz | cubexyz: same here, twice since 2006 | Apr 12 22:27 |
| Ariadne | now | Apr 12 22:27 |
| Ariadne | mysql -h 10.162.214.20 -u root -p | Apr 12 22:27 |
| Ariadne | try that | Apr 12 22:27 |
| schestowitz | pw? | Apr 12 22:27 |
| Ariadne | the one you gave me | Apr 12 22:27 |
| schestowitz | seems to hang sort of.. | Apr 12 22:28 |
| schestowitz | with some escaped characters as output | Apr 12 22:28 |
| schestowitz | ^[[O^[[I^[[O^[[I | Apr 12 22:29 |
| Ariadne | hmm | Apr 12 22:30 |
| Ariadne | you should get an error | Apr 12 22:30 |
| schestowitz | ^[[O^[[I^[[O^[[I^[[O^[[I^[[OERROR 2003 (HY000): Can't connect to MySQL server on '10.162.214.20' (110) | Apr 12 22:30 |
| schestowitz | took like 2 mins | Apr 12 22:30 |
| Ariadne | 110 is timeout | Apr 12 22:31 |
| -viera/#techrights-Tux Machines: Programming: 10 Recommended Programming Tools for Kids, Perl, Django http://www.tuxmachines.org/node/136313 [https://pleroma.site/objects/60e2f306-4cc3-4003-946a-cb3f9e4fe37b] | Apr 12 22:31 | |
| Ariadne | grrr | Apr 12 22:31 |
| Ariadne | how can i ssh into tuxmachines | Apr 12 22:31 |
| Ariadne | er | Apr 12 22:31 |
| Ariadne | techrights | Apr 12 22:31 |
| Ariadne | they both start with t it trips me up | Apr 12 22:31 |
| cubexyz | there was some mention of the microsoft dirty tricks archives disappearing a while back | Apr 12 22:32 |
| schestowitz | which username did you try? | Apr 12 22:32 |
| Ariadne | i don't know usernames | Apr 12 22:32 |
| Ariadne | i have forgotten :p | Apr 12 22:32 |
| schestowitz | you can sudo su from it, I'll send it to you | Apr 12 22:32 |
| Ariadne | ok | Apr 12 22:33 |
| -viera/#techrights-Tux Machines: Xubuntu 20.04 In Screenshots: Installation http://www.tuxmachines.org/node/136312 [https://pleroma.site/objects/b37ce46d-1e5f-45cd-a0c9-7b81ec4cb12a] | Apr 12 22:38 | |
| Ariadne | irony: systemd was created for fast boot, but alpine usually boots much faster than systemd | Apr 12 22:40 |
| Ariadne | admittedly, it boots less | Apr 12 22:40 |
| cubexyz | http://antitrust.slated.org/www.iowaconsumercase.org/ | Apr 12 22:42 |
| -TechrightsBot-tr/#techrights-antitrust.slated.org | Comes v. Microsoft | Apr 12 22:42 | |
| cubexyz | some stuff still archived here as they say it's in the public record | Apr 12 22:42 |
| cubexyz | not that easy to find | Apr 12 22:42 |
| schestowitz | we have copies | Apr 12 22:42 |
| schestowitz | techrights has important PDFs copied locally with articles that give commentary and HTML versions | Apr 12 22:43 |
| schestowitz | those took a long time and volunteers to produce | Apr 12 22:43 |
| schestowitz | that's why I am exxxxxxxxxxxxxxtremely sensitive about data integrity | Apr 12 22:43 |
| cubexyz | sure | Apr 12 22:43 |
| cubexyz | stuff can disappear | Apr 12 22:43 |
| schestowitz | many people's work went into the site, not just my own, many at great personal risk like the leakers | Apr 12 22:43 |
| schestowitz | stuff does disappear | Apr 12 22:44 |
| schestowitz | many sites vanish these days | Apr 12 22:44 |
| schestowitz | linux.com's old articles vanish | Apr 12 22:44 |
| schestowitz | like the stuff about SCO | Apr 12 22:44 |
| schestowitz | INQ is dead | Apr 12 22:44 |
| schestowitz | LJ will die soon unless they manage to get the volunteers eager enough to keep it running | Apr 12 22:44 |
| schestowitz | about 5 days ago someone showed me groklaw.net was also rotting | Apr 12 22:44 |
| Ariadne | hmm | Apr 12 22:45 |
| cubexyz | there's a flame war in quora that appeared recently | Apr 12 22:45 |
| schestowitz | the Microsoft antitrust and court cases staff, e.g. Boreland, vanishing form history | Apr 12 22:45 |
| cubexyz | about Kildall and msdos & M$ | Apr 12 22:45 |
| schestowitz | so Enderle and gang casn rewrite history in new 'articles' in publishers like IDG and CBS tabloids | Apr 12 22:45 |
| cubexyz | M$ peons are defending Microsoft naturally | Apr 12 22:46 |
| schestowitz | some people linked to our articles about Gary last week... I saw that in Twitter | Apr 12 22:46 |
| schestowitz | well, their God Gates has a PR campaign running at the moment | Apr 12 22:46 |
| schestowitz | Professor William Gates | Apr 12 22:46 |
| schestowitz | specialists in infectious diseases | Apr 12 22:46 |
| schestowitz | saying things people told him | Apr 12 22:46 |
| Ariadne | well if those people know what they are talking about, who cares | Apr 12 22:47 |
| schestowitz | and TV not inviting them but prof. Gates instead | Apr 12 22:47 |
| schestowitz | Prof. Gates never even graduated from collage | Apr 12 22:47 |
| schestowitz | *college | Apr 12 22:47 |
| schestowitz | Ariadne: but he does not | Apr 12 22:47 |
| schestowitz | the media plays the "bill says" game | Apr 12 22:47 |
| cubexyz | ha, Gates was stealing computer time from multiple places | Apr 12 22:47 |
| schestowitz | as if he's best at everything from medicine to economics | Apr 12 22:47 |
| schestowitz | they could instead invite actual experts | Apr 12 22:48 |
| schestowitz | but the big PR money, e.g. media 'grants' from the 'charity', has strings to it | Apr 12 22:48 |
| schestowitz | Gates even bribes BBC, NPR and PBC | Apr 12 22:48 |
| schestowitz | so-called 'public' broadcasters | Apr 12 22:48 |
| schestowitz | Gates was arrested several times, cubexyz | Apr 12 22:49 |
| Ariadne | schestowitz: what mysql users need to be created | Apr 12 22:49 |
| schestowitz | he also wrote a computer virus | Apr 12 22:49 |
| schestowitz | ok, about users, Ariadne | Apr 12 22:49 |
| Ariadne | writing computer viruses is cool | Apr 12 22:49 |
| Ariadne | well | Apr 12 22:49 |
| Ariadne | i guess it depends on what the virus does | Apr 12 22:49 |
| Ariadne | if it fucks shit up, not so cool | Apr 12 22:49 |
| schestowitz | CREATE USER 'boycottn_wki' | Apr 12 22:50 |
| schestowitz | CREATE USER 'boycottn_wrdp1 | Apr 12 22:50 |
| schestowitz | CREATE USER 'boycottn_drupal' | Apr 12 22:50 |
| Ariadne | ok | Apr 12 22:51 |
| Ariadne | one user per db | Apr 12 22:51 |
| Ariadne | where are the config files so i can find the passwords | Apr 12 22:51 |
| Ariadne | or should i just generate new ones | Apr 12 22:51 |
| schestowitz | pwd | Apr 12 22:51 |
| schestowitz | /home/schestowitz | Apr 12 22:51 |
| schestowitz | localhost:~$ nano pw | Apr 12 22:51 |
| schestowitz | all three commands | Apr 12 22:51 |
| Ariadne | ok | Apr 12 22:52 |
| Ariadne | er | Apr 12 22:52 |
| Ariadne | stupid bold | Apr 12 22:52 |
| schestowitz | I assume the DBs are already there, so no need to | Apr 12 22:52 |
| schestowitz | create database boycottn_wiki; | Apr 12 22:52 |
| schestowitz | create database boycottn_wrdp1; | Apr 12 22:52 |
| schestowitz | create database boycottn_drupal; | Apr 12 22:52 |
| Ariadne | users have been created | Apr 12 22:53 |
| XRevan86 | schestowitz: "techrights being rebuilt with containers" – reads as docker, expect the "you were the chosen one!" type of comments %) | Apr 12 22:54 |
| schestowitz | cool, thank you! | Apr 12 22:54 |
| schestowitz | Ariadne wants to rebuild like this, since even before the migration in 2018 | Apr 12 22:54 |
| schestowitz | My experience with containers is limited to our Drupal site at $Employer | Apr 12 22:55 |
| Ariadne | yes, using VMs is unnecessary performance hit when all we need is isolated security domains | Apr 12 22:55 |
| Ariadne | lxc is sufficient | Apr 12 22:55 |
| schestowitz | We've used VMs since 2008 or 2009 | Apr 12 22:55 |
| schestowitz | prior to that shared hosting until we got DDOSed to hell | Apr 12 22:56 |
| Ariadne | cleaner to use containers, but containers are well | Apr 12 22:56 |
| schestowitz | and then tessier kindly offered to host for us for a decade | Apr 12 22:56 |
| Ariadne | containers on linux were complicated in 2008 | Apr 12 22:56 |
| Ariadne | there were linux-vserver and openvz but both are quite awful really | Apr 12 22:56 |
| Ariadne | lxc is pretty clean | Apr 12 22:56 |
| Ariadne | ok | Apr 12 22:57 |
| XRevan86 | Even today when OpenVZ moved to LXC mostly in kernelspace, it's still on an ancient kernel for some reason. | Apr 12 22:57 |
| Ariadne | looks like techrights VM users are working | Apr 12 22:57 |
| Ariadne | XRevan86: well, LXC is unsuitable for situations where you have hostile users | Apr 12 22:58 |
| Ariadne | OpenVZ locks down things LXC does not | Apr 12 22:58 |
| Ariadne | in our case it is fine though | Apr 12 22:58 |
| *schestowitz does not think any one us has potential/motivation to do malice | Apr 12 22:59 | |
| XRevan86 | Ariadne: Hm, that explains why LXC servers aren't in the wild | Apr 12 22:59 |
| schestowitz | but seeing how RMS web pages were repeatedly defaces, one must wonder if his emacs old school ways are still secure in 2020 | Apr 12 22:59 |
| schestowitz | *defaced | Apr 12 22:59 |
| XRevan86 | schestowitz: His server was severely outdated, but IIRC that was an inside job, so that doesn't matter much | Apr 12 23:00 |
| schestowitz | yeah, an outsider would do more damage than this | Apr 12 23:00 |
| XRevan86 | It's still old, by the way. | Apr 12 23:00 |
| XRevan86 | I really hope he's using ELTS… | Apr 12 23:01 |
| schestowitz | We have leaks from Microsoft showing them gloating about GNU servers having security incidents | Apr 12 23:01 |
| schestowitz | Brad Kuhn found it interesting when we published those docs | Apr 12 23:02 |
| XRevan86 | "And why worry about a speck in your friend's eye when you have a log in your own?" | Apr 12 23:03 |
| XRevan86 | (at least one good line in the Bible) | Apr 12 23:03 |
| XRevan86 | It got proverbial in Russian. | Apr 12 23:04 |
| XRevan86 | But then again, Windows isn't exactly known for its good logging. | Apr 12 23:05 |
| Ariadne | schestowitz: where is drupal config files | Apr 12 23:05 |
| XRevan86 | Maybe MinceR will appreciate this terrible, terrible pun :) | Apr 12 23:05 |
| schestowitz | Ariadne: drupal is in /home/boycottn/public_html/home | Apr 12 23:06 |
| Ariadne | ok | Apr 12 23:06 |
| -viera/#techrights-Tux Machines: Red Hat’s new CEO talks about navigating the gradual recovery from the coronavirus http://www.tuxmachines.org/node/136314 [https://pleroma.site/objects/468f32f3-a531-4fe9-85a4-4b65f3aa22ee] | Apr 12 23:06 | |
| Ariadne | schestowitz: i need the password again for techrights | Apr 12 23:07 |
| schestowitz | I have put it back in pw | Apr 12 23:08 |
| -viera/#techrights-Tux Machines: Linux 5.7-rc1 Kernel Released http://www.tuxmachines.org/node/136310#comment-24573 by @MichaelLarabel - later than usual [https://pleroma.site/objects/fa254a7e-65f5-4382-a5ab-a7ab1609660c] | Apr 12 23:09 | |
| Ariadne | ok drupal moved over | Apr 12 23:12 |
| schestowitz | http://techrights.org/home/\ | Apr 12 23:12 |
| -TechrightsBot-tr/#techrights- ( status 404 @ http://techrights.org/home/\ ) | Apr 12 23:12 | |
| schestowitz | cool | Apr 12 23:12 |
| schestowitz | http://techrights.org/home/ | Apr 12 23:12 |
| -TechrightsBot-tr/#techrights-techrights.org | Techrights | People's rights in the digital age | Plutocracy threatened by freedom, democracy, privacy & civil rights | Apr 12 23:12 | |
| schestowitz | seems to work correctly and all | Apr 12 23:12 |
| schestowitz | when we move the rest over to containers we can get the packages we need to finish configuring httpd | Apr 12 23:13 |
| schestowitz | *https | Apr 12 23:13 |
| Ariadne | ok | Apr 12 23:14 |
| Ariadne | ok wordpress, wiki and drupal all moved | Apr 12 23:14 |
| Ariadne | and i killed the mysql on techrights | Apr 12 23:14 |
| Ariadne | dunno how your redirect is working | Apr 12 23:14 |
| Ariadne | so you'll want to revert your .htaccess | Apr 12 23:14 |
| schestowitz | Yeah, I was JUST... | Apr 12 23:14 |
| schestowitz | about to do that | Apr 12 23:14 |
| schestowitz | To avoid the php index file being picked I renamed index.php and if it's renamed back it'll be chosen instead | Apr 12 23:15 |
| schestowitz | mv index.php index.php-delthis | Apr 12 23:15 |
| schestowitz | to get back to normal mode | Apr 12 23:15 |
| schestowitz | mv index.php-delthis index.php | Apr 12 23:15 |
| schestowitz | Also remove the following lines in /home/boycottn/public_html/.htaccess | Apr 12 23:15 |
| schestowitz | Apr 12 23:15 | |
| schestowitz | Apr 12 23:15 | |
| schestowitz | RewriteEngine on | Apr 12 23:15 |
| schestowitz | RewriteCond %{REQUEST_URI} !^/index.html$ | Apr 12 23:15 |
| schestowitz | RewriteRule . /index.html [R=302,L] | Apr 12 23:15 |
| Ariadne | ok | Apr 12 23:16 |
| Ariadne | looks like its all working | Apr 12 23:16 |
| schestowitz | I will edit htaccess | Apr 12 23:17 |
| Ariadne | next i believe we should migrate tuxmachines database to the new container | Apr 12 23:17 |
| Ariadne | i already edited htaccess | Apr 12 23:17 |
| Ariadne | :) | Apr 12 23:17 |
| schestowitz | ah | Apr 12 23:17 |
| schestowitz | ok, that explains why nano warns me ;-) | Apr 12 23:17 |
| schestowitz | did you remove those 3 lines? | Apr 12 23:18 |
| Ariadne | i commented them out | Apr 12 23:18 |
| schestowitz | oh, I see what's going on now | Apr 12 23:22 |
| schestowitz | I could not see an image | Apr 12 23:22 |
| schestowitz | then I realised it could not fetch username | Apr 12 23:22 |
| schestowitz | it was in my todo list | Apr 12 23:22 |
| schestowitz | This happens when table wp_users needs repairing | Apr 12 23:22 |
| schestowitz | at least that's what happened in the past | Apr 12 23:22 |
| schestowitz | can we maybe do repair on the wordpress db? It can take a while, but it's probably crucial to do this, I cannot even log in, it's a familiar scenario | Apr 12 23:23 |
| DaemonFC[m] | https://www.businessinsider.com/trump-considered-allowing-the-coronavirus-to-wash-over-the-us-2020-4?r=MX&IR=T | Apr 12 23:23 |
| -TechrightsBot-tr/#techrights-www.businessinsider.com | Trump considered allowing the coronavirus to 'wash over' the US - Business Insider | Apr 12 23:23 | |
| DaemonFC[m] | I'm just still trying to wrap my head around "What fucking politician wants their base dead well ahead of election day!?". | Apr 12 23:24 |
| schestowitz | mysqlcheck -u root -p --auto-repair --check --all-databases | Apr 12 23:24 |
| schestowitz | it should give output, sometimes it says some tables like caches were marked as crashed, but as long as key tables aren't corrupted or not repairable I think we're OK | Apr 12 23:24 |
| XRevan86 | DaemonFC[m]: You've probably already noticed that Trump is a very special boy. | Apr 12 23:25 |
| schestowitz | wp_posts table is vast and can take a long time to check, but at least by checking it we know 27,000+ posts are in good shape | Apr 12 23:26 |
| schestowitz | ^to Ariadne as I don't think I have access to the DB container | Apr 12 23:27 |
| Ariadne | schestowitz: lxc-attach -n mysql-shared from the hv | Apr 12 23:27 |
| *gde33 has quit (Read error: Connection reset by peer) | Apr 12 23:28 | |
| schestowitz | ok, thanks | Apr 12 23:28 |
| *gde34 (~gde333@84-106-154-98.cable.dynamic.v4.ziggo.nl) has joined #techrights | Apr 12 23:28 | |
| schestowitz | Ariadne: so far, so good... | Apr 12 23:32 |
| schestowitz | table-wise | Apr 12 23:32 |
| Ariadne | great | Apr 12 23:32 |
| schestowitz | a friend thought it was maybe due to the DB being read-only | Apr 12 23:32 |
| Ariadne | well now you can just delete | Apr 12 23:33 |
| schestowitz | now it's coming to the biggest tables, I just hope it doesn't struggle | Apr 12 23:33 |
| Ariadne | the stuff on /var | Apr 12 23:33 |
| schestowitz | let it settle for a bit to see if we don't need that as a backup........ | Apr 12 23:33 |
| schestowitz | boycottn_wrdp1.wp_posts OK | Apr 12 23:34 |
| schestowitz | I want it to taker issue with wp_users and correct it, I saw this kind of symptom half a year ago and it took me hours to figure out | Apr 12 23:34 |
| schestowitz | boycottn_wrdp1.wp_usermeta | Apr 12 23:36 |
| schestowitz | warning : Table is marked as crashed and last repair failed | Apr 12 23:36 |
| schestowitz | warning : 1 client is using or hasn't closed the table properly | Apr 12 23:36 |
| schestowitz | warning : Size of indexfile is: 473318400 Should be: 2048 | Apr 12 23:36 |
| schestowitz | error : Record-count is not ok; is 14934070 Should be: 0 | Apr 12 23:36 |
| schestowitz | warning : Found 14934076 key parts. Should be: 6478786 | Apr 12 23:36 |
| schestowitz | error : Corrupt | Apr 12 23:36 |
| schestowitz | boycottn_wrdp1.wp_users | Apr 12 23:36 |
| schestowitz | warning : Table is marked as crashed and last repair failed | Apr 12 23:36 |
| schestowitz | status : OK | Apr 12 23:36 |
| schestowitz | Repairing tables | Apr 12 23:36 |
| schestowitz | fingers crossed now... | Apr 12 23:36 |
| schestowitz | if this fixes things, I'll post the guest articles I got, daily links, then go to bed | Apr 12 23:37 |
| schestowitz | boycottn_wrdp1.wp_usermeta | Apr 12 23:38 |
| schestowitz | warning : Number of rows changed from 0 to 14934070 | Apr 12 23:38 |
| schestowitz | status : OK | Apr 12 23:38 |
| schestowitz | mysql-shared:/# | Apr 12 23:38 |
| schestowitz | :D :D :D :D :D :D :D :D :D :D :D :D :D :D :D :D :D :D | Apr 12 23:38 |
| schestowitz | I'm back in, too | Apr 12 23:39 |
| schestowitz | will share some notes with my friend who has access, then do today's posts... | Apr 12 23:40 |
| Ariadne | ok | Apr 12 23:40 |
| Ariadne | next up i suggest we do tuxmachines migration to this shared infra | Apr 12 23:40 |
| Ariadne | then we can look at building containers for the websites | Apr 12 23:40 |
| Ariadne | and finally, a container to terminate the https traffic at edge | Apr 12 23:41 |
| Ariadne | we can set up proper caching and things that way | Apr 12 23:41 |
| Ariadne | will reduce CPU load | Apr 12 23:41 |
| schestowitz | cheers | Apr 12 23:42 |
| schestowitz | when will be a good time for you? | Apr 12 23:42 |
| Ariadne | probably tomorrow afternoon | Apr 12 23:44 |
| schestowitz | cheers | Apr 12 23:45 |
| -viera/#techrights-Tux Machines: Minimalism, Practicality and Deleting GitHub http://techrights.org/2020/04/12/minimalism/ [https://pleroma.site/objects/ef94617d-8d9e-42d0-855a-c6f35f6ee0d6] | Apr 12 23:52 | |
Generated by irclog2html.py 2.6 by Marius Gedminas - find it at mg.pov.lt!
