Join us now at the IRC channel.
*oarion7 (~ryan@mfmwu5c33pkb2.irc) has joined #tuxmachines | Oct 12 00:27 | |
*MinceR gives voice to oarion7 | Oct 12 01:28 | |
*oarion7 has quit (Quit: Running IRC on a charmed medieval abacus.) | Oct 12 02:16 | |
*psydruid (~psydruid@jevhxkzmtrbww.irc) has left #tuxmachines | Oct 12 02:23 | |
*psydruid (~psydruid@jevhxkzmtrbww.irc) has joined #tuxmachines | Oct 12 02:24 | |
*MinceR gives voice to psydruid | Oct 12 02:28 | |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): SparkyLinux 2023.10 Brings Linux Kernel 6.5, Latest Debian 13 βTrixieβ Updates β¨ http://news.tuxmachines.org/n/2023/10/12/SparkyLinux_2023_10_Brings_Linux_Kernel_6_5_Latest_Debian_13_Tr.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/SparkyLinux_2023_10_Brings_Linux_Kernel_6_5_Latest_Debian_13_Tr.gmi β | Oct 12 02:31 |
---|---|---|
techrights-news | Techrights β Years After Calling for Removal of Richard Stallman, Both SFC and FSFE Misuse 'Code of Conduct' to Do the Same to Eben Moglen β¨ http://news.techrights.org/n/2023/10/12/Years_After_Calling_for_Removal_of_Richard_Stallman_Both_SFC_an.shtml | βΎ Gemini address: gemini://gemini.techrights.org/n/2023/10/12/Years_After_Calling_for_Removal_of_Richard_Stallman_Both_SFC_an.gmi β | Oct 12 02:31 |
techrights-news | Techrights β IRC Proceedings: Wednesday, October 11, 2023 β¨ http://news.techrights.org/n/2023/10/12/IRC_Proceedings_Wednesday_October_11_2023.shtml | βΎ Gemini address: gemini://gemini.techrights.org/n/2023/10/12/IRC_Proceedings_Wednesday_October_11_2023.gmi β | Oct 12 03:11 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (UPDATE): GNOME is Planning to Drop X.Org. Is it too soon to bid farewell? β¨ http://news.tuxmachines.org/n/2023/10/10/GNOME_is_Planning_to_Drop_X_Org_Is_it_too_soon_to_bid_farewell.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/10/GNOME_is_Planning_to_Drop_X_Org_Is_it_too_soon_to_bid_farewell.gmi β | Oct 12 03:12 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Ardour 8.0 β¨ http://news.tuxmachines.org/n/2023/10/12/Ardour_8_0.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/Ardour_8_0.gmi β | Oct 12 03:12 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Today's ππΆπΉ ππ’π€π©πͺπ―π¦π΄ HowTos β¨ http://news.tuxmachines.org/n/2023/10/12/today_s_howtos.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/today_s_howtos.gmi β | Oct 12 03:12 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Audiocasts/Shows: Ubuntu 23.10, Linux Out Loud, and mintCast β¨ http://news.tuxmachines.org/n/2023/10/12/Audiocasts_Shows_Ubuntu_23_10_Linux_Out_Loud_and_mintCast.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/Audiocasts_Shows_Ubuntu_23_10_Linux_Out_Loud_and_mintCast.gmi β | Oct 12 03:12 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Mozilla talks about "beauty of the open internet" while helping Google undermine it β¨ http://news.tuxmachines.org/n/2023/10/12/Mozilla_talks_about_beauty_of_the_open_internet_while_helping_G.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/Mozilla_talks_about_beauty_of_the_open_internet_while_helping_G.gmi β | Oct 12 03:12 |
DaemonFC | MinceR, The best people do. | Oct 12 03:17 |
DaemonFC | The only people who say they will for years on end and don't are people like Lobster. Holding themselves hostage for crazy checks. | Oct 12 03:18 |
DaemonFC | I mean, some people say they want to because of stress or a bout of depression or something. | Oct 12 03:18 |
DaemonFC | But then there's people who call the police in the UK and say arrest someone who called me by my "deadname" or I might kill myself. | Oct 12 03:19 |
DaemonFC | And it's so obvious what that is. | Oct 12 03:19 |
DaemonFC | Most people who do end up committing suicide say little or nothing about it. | Oct 12 03:20 |
DaemonFC | One of the red flags to look out for is someone who has been depressed for years suddenly acting like they're okay or relieved. | Oct 12 03:20 |
DaemonFC | It's because they've made the decision and they're relieved that the pressure is off. | Oct 12 03:21 |
DaemonFC | When someone who has been depressed for years is suddenly happy, that's when you should be alarmed. | Oct 12 03:21 |
DaemonFC | There's no point in threatening to do anything of the sort. That's counterproductive. People who want to die know that screaming they'll do it is how you get committed. | Oct 12 03:23 |
DaemonFC | Then they won't be able to. They're not stupid. | Oct 12 03:23 |
DaemonFC | Most people who are actually suicidal or close to it will do anything to avoid drawing attention to how bad things are actually getting and they won't admit it to anyone. | Oct 12 03:24 |
DaemonFC | It's pretty well known, at least in this country, is that if someone calls the police on you and says they're worried, deny deny deny. | Oct 12 03:24 |
DaemonFC | Eventually, they turn around and leave and quit heckling you, and you can decide to do whatever you want then. | Oct 12 03:25 |
MinceR | it's better to kill authoritarians than to kill oneself | Oct 12 03:26 |
MinceR | the more the better | Oct 12 03:26 |
MinceR | and if we run out of humans, too fucking bad. | Oct 12 03:27 |
schestowitz-pi | [cat] | Oct 12 04:10 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Wayland Display Server on openSUSE Tumbleweed in 2023 β¨ http://news.tuxmachines.org/n/2023/10/12/Wayland_Display_Server_on_openSUSE_Tumbleweed_in_2023.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/Wayland_Display_Server_on_openSUSE_Tumbleweed_in_2023.gmi β | Oct 12 04:11 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Smaller is Fast, Fast is Beautiful β¨ http://news.tuxmachines.org/n/2023/10/12/Smaller_is_Fast_Fast_is_Beautiful.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/Smaller_is_Fast_Fast_is_Beautiful.gmi β | Oct 12 04:11 |
techrights-news | Techrights β Wayland: Over a Decade of Self-Fulfilling Prophecies and User-Shaming β¨ http://news.techrights.org/n/2023/10/12/Wayland_Over_a_Decade_of_Self_Fulfilling_Prophecies_and_User_Sh.shtml | βΎ Gemini address: gemini://gemini.techrights.org/n/2023/10/12/Wayland_Over_a_Decade_of_Self_Fulfilling_Prophecies_and_User_Sh.gmi β | Oct 12 04:11 |
techrights-news | Techrights β Older for Suckers β¨ http://news.techrights.org/n/2023/10/12/Older_for_Suckers.shtml | βΎ Gemini address: gemini://gemini.techrights.org/n/2023/10/12/Older_for_Suckers.gmi β | Oct 12 04:11 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Devices: Linux in Vehicles, Ubuntu, Arduino, and Raspberry Pi β¨ http://news.tuxmachines.org/n/2023/10/12/Devices_Linux_in_Vehicles_Ubuntu_Arduino_and_Raspberry_Pi.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/Devices_Linux_in_Vehicles_Ubuntu_Arduino_and_Raspberry_Pi.gmi β | Oct 12 04:39 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): The Challenge of Patching Curl β¨ http://news.tuxmachines.org/n/2023/10/12/The_Challenge_of_Patching_Curl.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/The_Challenge_of_Patching_Curl.gmi β | Oct 12 04:39 |
schestowitz-pi | the new workflow is fantastic | Oct 12 04:53 |
schestowitz-pi | helps us focus on what matters | Oct 12 04:53 |
schestowitz-pi | and not do manually what can be automated | Oct 12 04:53 |
schestowitz-pi | irc has been calm and mostly off-topic | Oct 12 04:53 |
schestowitz-pi | which is what we lacked since 2022 | Oct 12 04:53 |
schestowitz-pi | the stories i have to tell are all written down | Oct 12 04:53 |
schestowitz-pi | but not the best time to publish them atm | Oct 12 04:54 |
schestowitz-pi | keeping temp. low | Oct 12 04:54 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Games: GNU/Linux Before Apple, Lots of Steam Stuff, and More β¨ http://news.tuxmachines.org/n/2023/10/12/Games_GNU_Linux_Before_Apple_Lots_of_Steam_Stuff_and_More.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/Games_GNU_Linux_Before_Apple_Lots_of_Steam_Stuff_and_More.gmi β | Oct 12 04:54 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Today's ππΆπΉ ππ’π€π©πͺπ―π¦π΄ HowTos β¨ http://news.tuxmachines.org/n/2023/10/12/today_s_howtos.1.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/today_s_howtos.1.gmi β | Oct 12 05:12 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Security Leftovers and Windows TCO β¨ http://news.tuxmachines.org/n/2023/10/12/Security_Leftovers_and_Windows_TCO.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/Security_Leftovers_and_Windows_TCO.gmi β | Oct 12 05:12 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Events: R Conference 2023, All Things Open, Innovation Marathon Hack Week β¨ http://news.tuxmachines.org/n/2023/10/12/Events_R_Conference_2023_All_Things_Open_Innovation_Marathon_Ha.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/Events_R_Conference_2023_All_Things_Open_Innovation_Marathon_Ha.gmi β | Oct 12 05:12 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Free, Libre, and Open Source Software Leftovers β¨ http://news.tuxmachines.org/n/2023/10/12/Free_Libre_and_Open_Source_Software_Leftovers.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/Free_Libre_and_Open_Source_Software_Leftovers.gmi β | Oct 12 05:12 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Software: NetworkManager, Spot, Warehouse, ORLA, SSH System Administration Tool, Zsync, goread, FreshRSS, DAR, and More β¨ http://news.tuxmachines.org/n/2023/10/12/Software_NetworkManager_Spot_Warehouse_ORLA_SSH_System_Administ.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/Software_NetworkManager_Spot_Warehouse_ORLA_SSH_System_Administ.gmi β | Oct 12 05:12 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (UPDATE): Microsoft gives unexpected tutorial on #HowTo install Linux β¨ http://news.tuxmachines.org/n/2023/10/11/Microsoft_gives_unexpected_tutorial_on_how_to_install_Linux.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/11/Microsoft_gives_unexpected_tutorial_on_how_to_install_Linux.gmi β | Oct 12 05:12 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Today in Techrights β¨ http://news.tuxmachines.org/n/2023/10/12/Today_in_Techrights.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/Today_in_Techrights.gmi β | Oct 12 05:24 |
techrights-news | Techrights β Links 12/10/2023: EDRI on Privacy, Unpacking California's SB 244 β the βRight to Repair Actβ β¨ http://news.techrights.org/n/2023/10/12/Links_12_10_2023_EDRI_on_Privacy_Unpacking_California_s_SB_244_.shtml | βΎ Gemini address: gemini://gemini.techrights.org/n/2023/10/12/Links_12_10_2023_EDRI_on_Privacy_Unpacking_California_s_SB_244_.gmi β | Oct 12 05:25 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Microsoft Tax Evasion β¨ http://news.tuxmachines.org/n/2023/10/12/Microsoft_Tax_Evasion.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/Microsoft_Tax_Evasion.gmi β | Oct 12 05:42 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Overhaul of Thelio internals and new band Theliohead β¨ http://news.tuxmachines.org/n/2023/10/12/Theliohead.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/Theliohead.gmi β | Oct 12 05:43 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Red Hat Official Blog: The Latest β¨ http://news.tuxmachines.org/n/2023/10/12/Red_Hat_Official_Blog_The_Latest.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/Red_Hat_Official_Blog_The_Latest.gmi β | Oct 12 05:57 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Security Leftovers and Microsoft/Windows TCO β¨ http://news.tuxmachines.org/n/2023/10/12/Security_Leftovers_and_Microsoft_Windows_TCO.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/Security_Leftovers_and_Microsoft_Windows_TCO.gmi β | Oct 12 06:29 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Digital Restrictions (DRM) Troubles β¨ http://news.tuxmachines.org/n/2023/10/12/Digital_Restrictions_DRM_Troubles.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/Digital_Restrictions_DRM_Troubles.gmi β | Oct 12 06:29 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): LWN: Linux ecosystem contributions from SteamOS and kernel's preemption model β¨ http://news.tuxmachines.org/n/2023/10/12/LWN_Linux_ecosystem_contributions_from_SteamOS_and_kernel_s_pre.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/LWN_Linux_ecosystem_contributions_from_SteamOS_and_kernel_s_pre.gmi β | Oct 12 06:30 |
techrights-news | Techrights β Links 12/10/2023: TikTok Under More Fire β¨ http://news.techrights.org/n/2023/10/12/Links_12_10_2023_TikTok_Under_More_Fire.shtml | βΎ Gemini address: gemini://gemini.techrights.org/n/2023/10/12/Links_12_10_2023_TikTok_Under_More_Fire.gmi β | Oct 12 07:33 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Today's ππΆπΉ ππ’π€π©πͺπ―π¦π΄ Leftovers β¨ http://news.tuxmachines.org/n/2023/10/12/today_s_leftovers.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/today_s_leftovers.gmi β | Oct 12 07:33 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Lubuntu 23.10 "Mantic Minotaur": Best New Features β¨ http://news.tuxmachines.org/n/2023/10/12/Lubuntu_23_10_Mantic_Minotaur_Best_New_Features.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/Lubuntu_23_10_Mantic_Minotaur_Best_New_Features.gmi β | Oct 12 07:34 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): A Social Meeting Between French-Speaking Mageians β¨ http://news.tuxmachines.org/n/2023/10/12/A_Social_Meeting_Between_French_Speaking_Mageians.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/A_Social_Meeting_Between_French_Speaking_Mageians.gmi β | Oct 12 07:34 |
techrights-sec | all articles about DDoS via HTTP/2 blame the protocol and completely neglect | Oct 12 07:36 |
techrights-sec | mention of the Windoze Bot Nets (tm) which make the attacks possible. | Oct 12 07:36 |
techrights-sec | HTTP/2 is not blameless, but it is wrong to use it as a distraction from | Oct 12 07:36 |
techrights-sec | the Windoze systems which have been (inappropriately) connected to the net | Oct 12 07:36 |
techrights-sec | instead of replaced with secure systems. | Oct 12 07:36 |
techrights-sec | ^ topic ? | Oct 12 07:36 |
schestowitz-pi | i noticed the same | Oct 12 07:37 |
schestowitz-pi | sod em | Oct 12 07:37 |
schestowitz-pi | best we can do is, | Oct 12 07:37 |
schestowitz-pi | respond on our own | Oct 12 07:37 |
schestowitz-pi | just refresh my rss feeds for second time in a day | Oct 12 07:37 |
schestowitz-pi | (7am) | Oct 12 07:37 |
schestowitz-pi | that's how slow news is | Oct 12 07:37 |
techrights-sec | One refresh per 24-hour period is usually more than enough unless loading | Oct 12 07:39 |
techrights-sec | in new feeds or removing old feeds. | Oct 12 07:39 |
schestowitz-pi | yes, i was raising my brows, too | Oct 12 07:41 |
schestowitz-pi | maybe it's a sign that time can and should not be devoted to the capsule, site etc. | Oct 12 07:41 |
schestowitz-pi | i long planned to leave my job to focus on this | Oct 12 07:41 |
schestowitz-pi | btw, can logrotate of agate logs have more permissive access, like 644 for log (and .gz) files? | Oct 12 07:41 |
techrights-sec | sorry ctry ce in another terminal -- just as it closed and so focus shifte to | Oct 12 07:42 |
techrights-sec | this window | Oct 12 07:42 |
schestowitz-pi | I am already working on: | Oct 12 07:43 |
schestowitz-pi | Focus on the Windows Botnets (Microsoft/NSA Backdoors), Not the Weaknesses of the Protocols the Botnets Constantly Exploit (Quantity/Brute Force Always Defy Good Design at Scale) | Oct 12 07:46 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): GNU40 USA: Meeting with old and new friends, and some first few steps on the freedom ladder β¨ http://news.tuxmachines.org/n/2023/10/12/GNU40_USA_Meeting_with_old_and_new_friends_and_some_first_few_s.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/GNU40_USA_Meeting_with_old_and_new_friends_and_some_first_few_s.gmi β | Oct 12 07:49 |
techrights-sec | More context is needed about why SFC and FSFE are wrong: | Oct 12 08:33 |
techrights-sec | >http://techrights.org/n/2023/10/12/Years_After_Calling_for_Removal_of_Richard_Stallman_Both_SFC_an.shtml | Oct 12 08:33 |
techrights-sec | and why FSFE is inappropriately misappropriating the very name | Oct 12 08:33 |
techrights-sec | ^ topic | Oct 12 08:33 |
techrights-sec | ? | Oct 12 08:33 |
techrights-sec | misc: /tmp/tr.icons.tar.gz on the rpi here | Oct 12 08:33 |
schestowitz-pi | back | Oct 12 08:34 |
schestowitz-pi | scrubbing oily surfaces today | Oct 12 08:35 |
schestowitz-pi | among other things | Oct 12 08:35 |
schestowitz-pi | <techrights-news> Utah Sues βIncredibly Dangerousβ TikTok Over Alleged Harmful Impact on Children and Teens β https://www.digitalmusicnews.com/2023/10/11/utah-tiktok-lawsuit/ | Oct 12 08:38 |
schestowitz-pi | -TechrightsBot-tr/#techrights- ( status 520 @ https://www.digitalmusicnews.com/2023/10/11/utah-tiktok-lawsuit/ ) | Oct 12 08:38 |
schestowitz-pi | <techrights-news> Utah sues TikTok over βdeceptiveβ business practices that βmanipulate childrenβ β https://www.jurist.org/news/2023/10/utah-sues-tiktok-over-deceptive-business-practices-that-manipulate-children/ | Oct 12 08:38 |
schestowitz-pi | -TechrightsBot-tr/#techrights- www.jurist.org | Utah sues TikTok over 'deceptive' business practices that 'manipulate children' - JURIST - News | Oct 12 08:38 |
schestowitz-pi | <techrights-news> Beijing is amplifying divisive, malicious, racist "press" β https://pressgazette.co.uk/social_media/daily-mail-tiktok-news/ | Oct 12 08:38 |
schestowitz-pi | -TechrightsBot-tr/#techrights- pressgazette.co.uk | How Daily Mail went from voice of Middle England to Tiktok sensation - Press Gazette | Oct 12 08:38 |
techrights-sec | The snow is now melting so the roads will be very slushy. | Oct 12 08:38 |
techrights-sec | Dangerously they've started salting them in recent years so that the | Oct 12 08:38 |
techrights-sec | cars rust badly and quickly. | Oct 12 08:38 |
schestowitz-pi | it is 8:30am | Oct 12 08:41 |
schestowitz-pi | i am done with everything deemed "essensial" | Oct 12 08:41 |
schestowitz-pi | plus extra housework | Oct 12 08:41 |
schestowitz-pi | and am now doing a _second_ round of rss | Oct 12 08:41 |
schestowitz-pi | een weekends were not this quiet | Oct 12 08:41 |
schestowitz-pi | you gave me 2 topics we can cover | Oct 12 08:41 |
schestowitz-pi | one i will target at TM readers | Oct 12 08:41 |
schestowitz-pi | who don't know fsfe well | Oct 12 08:41 |
schestowitz-pi | is there a logrotate arg that sets file perms? | Oct 12 08:41 |
schestowitz-pi | <techrights-news> Trying hard a "positive" spin (so that even negatives sound like positives) β https://itwire.com/hardware-and-storage/global-pc-shipments-continue-to-fall,-but-downward-trend-slows.html | Oct 12 08:43 |
schestowitz-pi | am has not been active this past month | Oct 12 08:43 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): #HowTo Upgrade Raspberry Pi OS to Debian Bookworm from Bullseye β¨ http://news.tuxmachines.org/n/2023/10/12/How_To_Upgrade_Raspberry_Pi_OS_to_Debian_Bookworm_from_Bullseye.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/How_To_Upgrade_Raspberry_Pi_OS_to_Debian_Bookworm_from_Bullseye.gmi β | Oct 12 08:58 |
techrights-sec | checking logrotate now, got side tracked ... | Oct 12 09:11 |
techrights-sec | you're in group adm already and so should be able to read agate's logs | Oct 12 09:11 |
techrights-sec | can make them world-readable though if that's really needed. | Oct 12 09:11 |
techrights-sec | Who also needs access? | Oct 12 09:11 |
schestowitz-pi | gemini could use access | Oct 12 09:11 |
schestowitz-pi | to demonstrate that gemini is not small | Oct 12 09:11 |
schestowitz-pi | by continuing the daily stat reports (numbers only) | Oct 12 09:11 |
techrights-sec | which user? | Oct 12 09:25 |
techrights-sec | (the top of the paste is off the top of the screen) | Oct 12 09:25 |
schestowitz-pi | SFC and FSFE, Funded by Microsoft, Tell You That Eben Moglen is a Bad Man (They're Wrong) | Oct 12 09:26 |
techrights-sec | which script? gemini is the account for privilege separation for the | Oct 12 09:28 |
techrights-sec | agate server and that should have minimal access, so there is likely | Oct 12 09:28 |
techrights-sec | another way with the specific script | Oct 12 09:28 |
techrights-sec | (good title, to the point!) | Oct 12 09:28 |
schestowitz-pi | https://news.tuxmachines.org/n/2023/10/12/SFC_and_FSFE_Funded_by_Microsoft_Tell_You_That_Eben_Moglen_is_a.shtml | Oct 12 09:33 |
schestowitz-pi | fnny enough; i saw similar tactics sgainst us, but mentioning it would be spun as paranoia or | Oct 12 09:33 |
schestowitz-pi | high self esteem | Oct 12 09:33 |
techrights-sec | interesting | Oct 12 09:34 |
techrights-sec | /etc/cron.d/tr-gemini-planet | Oct 12 09:34 |
techrights-sec | /home/gemini/bin/tr-gemini-update-planet.sh | Oct 12 09:34 |
techrights-sec | renamed the script in Git now | Oct 12 09:51 |
techrights-sec | back up complete | Oct 12 09:51 |
techrights-sec | """ | Oct 12 09:51 |
techrights-sec | reminder | Oct 12 09:51 |
techrights-sec | that "Code of Conduct" was always about censorship of | Oct 12 09:51 |
techrights-sec | one's critics, in this case corporate mouthpieces funded | Oct 12 09:51 |
techrights-sec | by large corporations, including Microsoft and Google. | Oct 12 09:51 |
techrights-sec | """ | Oct 12 09:51 |
techrights-sec | awkward phrasing, it could be more clear about who is doing the censoring | Oct 12 09:51 |
techrights-sec | and who is being censored | Oct 12 09:51 |
techrights-sec | anyway, it is an important topic and Eben is worthy of support having | Oct 12 09:51 |
techrights-sec | been so productive in the FOSS world for decades | Oct 12 09:51 |
techrights-sec | biab | Oct 12 10:05 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): SFC and FSFE, Funded by Microsoft, Tell You That Eben Moglen is a Bad Man (They're Wrong) β¨ http://news.tuxmachines.org/n/2023/10/12/SFC_and_FSFE_Funded_by_Microsoft_Tell_You_That_Eben_Moglen_is_a.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/SFC_and_FSFE_Funded_by_Microsoft_Tell_You_That_Eben_Moglen_is_a.gmi β | Oct 12 10:18 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): ππΆπΉ ππ’π€π©πͺπ―π¦π΄: Google Android Leftovers β¨ http://news.tuxmachines.org/n/2023/10/12/Android_Leftovers.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/Android_Leftovers.gmi β | Oct 12 10:18 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): "Birds that are born in a cage think that freedom is a crime" β¨ http://news.tuxmachines.org/n/2023/10/12/_Birds_that_are_born_in_a_cage_think_that_freedom_is_a_crime.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/_Birds_that_are_born_in_a_cage_think_that_freedom_is_a_crime.gmi β | Oct 12 10:18 |
techrights-news | Techrights β Wars and Conflicts Likely to Accelerate Adoption of GNU/Linux Because Countries Pursue Security and Privacy Rather Than Hegemony β¨ http://news.techrights.org/n/2023/10/12/Wars_and_Conflicts_Likely_to_Accelerate_Adoption_of_GNU_Linux_B.shtml | βΎ Gemini address: gemini://gemini.techrights.org/n/2023/10/12/Wars_and_Conflicts_Likely_to_Accelerate_Adoption_of_GNU_Linux_B.gmi β | Oct 12 10:18 |
techrights-sec | back | Oct 12 10:54 |
schestowitz-pi | leave this with me, i am confident | Oct 12 12:29 |
schestowitz-pi | will write more articles soon | Oct 12 12:29 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (UPDATE): SparkyLinux 2023.10 Brings Linux Kernel 6.5, Latest Debian 13 βTrixieβ Updates β¨ http://news.tuxmachines.org/n/2023/10/12/SparkyLinux_2023_10_Brings_Linux_Kernel_6_5_Latest_Debian_13_Tr.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/SparkyLinux_2023_10_Brings_Linux_Kernel_6_5_Latest_Debian_13_Tr.gmi β | Oct 12 12:32 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Announcing Istio 1.19.3, 1.18.5, and 1.17.8 β¨ http://news.tuxmachines.org/n/2023/10/12/Announcing_Istio_1_19_3_1_18_5_and_1_17_8.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/Announcing_Istio_1_19_3_1_18_5_and_1_17_8.gmi β | Oct 12 12:32 |
techrights-news | Techrights β Links 12/10/2023: Hardware Sales Still Falling, Samsung Profits to Fall to Almost Nothing β¨ http://news.techrights.org/n/2023/10/12/Links_12_10_2023_Hardware_Sales_Still_Falling_Samsung_Profits_t.shtml | βΎ Gemini address: gemini://gemini.techrights.org/n/2023/10/12/Links_12_10_2023_Hardware_Sales_Still_Falling_Samsung_Profits_t.gmi β | Oct 12 14:14 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Today's ππΆπΉ ππ’π€π©πͺπ―π¦π΄ HowTos β¨ http://news.tuxmachines.org/n/2023/10/12/today_s_howtos.2.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/today_s_howtos.2.gmi β | Oct 12 14:15 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): IPFire 2.27 - Core Update 180 released β¨ http://news.tuxmachines.org/n/2023/10/12/IPFire_2_27_Core_Update_180_released.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/IPFire_2_27_Core_Update_180_released.gmi β | Oct 12 14:15 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Security Leftovers β¨ http://news.tuxmachines.org/n/2023/10/12/Security_Leftovers.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/Security_Leftovers.gmi β | Oct 12 14:15 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): KDE Gear 23.08.2 Released with More Fixes for Your Favorite KDE Apps β¨ http://news.tuxmachines.org/n/2023/10/12/KDE_Gear_23_08_2_Released_with_More_Fixes_for_Your_Favorite_KDE.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/KDE_Gear_23_08_2_Released_with_More_Fixes_for_Your_Favorite_KDE.gmi β | Oct 12 14:15 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Devices and Open Hardware/Modding: Wind River Linux, RISC-V, Raspberry Pi, and Arduino β¨ http://news.tuxmachines.org/n/2023/10/12/Devices_and_Open_Hardware_Modding_Wind_River_Linux_RISC_V_Raspb.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/Devices_and_Open_Hardware_Modding_Wind_River_Linux_RISC_V_Raspb.gmi β | Oct 12 14:15 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Software: FOSS Weekly, KDE, GNOME, and More β¨ http://news.tuxmachines.org/n/2023/10/12/Software_FOSS_Weekly_KDE_GNOME_and_More.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/Software_FOSS_Weekly_KDE_GNOME_and_More.gmi β | Oct 12 14:15 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Today's ππΆπΉ ππ’π€π©πͺπ―π¦π΄ Leftovers β¨ http://news.tuxmachines.org/n/2023/10/12/today_s_leftovers.1.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/today_s_leftovers.1.gmi β | Oct 12 14:15 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): ππΆπΉ ππ’π€π©πͺπ―π¦π΄ Programming Leftovers β¨ http://news.tuxmachines.org/n/2023/10/12/Programming_Leftovers.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/Programming_Leftovers.gmi β | Oct 12 14:16 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Links 12/10/2023: Hardware Sales Still Falling, Samsung Profits to Fall to Almost Nothing β¨ http://news.tuxmachines.org/n/2023/10/12/Links_12_10_2023_Hardware_Sales_Still_Falling_Samsung_Profits_t.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/Links_12_10_2023_Hardware_Sales_Still_Falling_Samsung_Profits_t.gmi β | Oct 12 14:16 |
schestowitz-pi | <techrights-news> EU works for Famous Criminal Bill Gates β https://ec.europa.eu/commission/presscorner/detail/en/STATEMENT_23_4902 "European Commission Statement Brussels, 11 Oct 2023 Dear Bill Gates," https://www.nytimes.com/2019/10/12/business/jeffrey-epstein-bill-gates.html | Oct 12 14:26 |
techrights-sec | back | Oct 12 15:27 |
techrights-sec | the EC 'letter' is a variant of billsez and tries to paint him as an expert | Oct 12 15:27 |
techrights-sec | in anything other than being a crook. | Oct 12 15:27 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): YouTube Is Pushing Ads Once Again β¨ http://news.tuxmachines.org/n/2023/10/12/YouTube_Is_Pushing_Ads_Once_Again.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/YouTube_Is_Pushing_Ads_Once_Again.gmi β | Oct 12 15:30 |
techrights-news | Techrights β Links 12/10/2023: Hardware Sales Still Falling, Samsung Profits to Fall to Almost Nothing β¨ http://news.techrights.org/n/2023/10/12/Links_12_10_2023_Hardware_Sales_Still_Falling_Samsung_Profits_t.shtml | βΎ Gemini address: gemini://gemini.techrights.org/n/2023/10/12/Links_12_10_2023_Hardware_Sales_Still_Falling_Samsung_Profits_t.gmi β | Oct 12 15:31 |
techrights-news | Techrights β Techrights Upgrade Report: Gemini Capsule for Techrights Almost Fully Upgraded (Debian 12) and Further Improved β¨ http://news.techrights.org/n/2023/10/12/Techrights_Upgrade_Report_Gemini_Capsule_for_Techrights_Almost_.shtml | βΎ Gemini address: gemini://gemini.techrights.org/n/2023/10/12/Techrights_Upgrade_Report_Gemini_Capsule_for_Techrights_Almost_.gmi β | Oct 12 15:31 |
techrights-news | Techrights β They Won't Leave Software Freedom Fighters Alone Until They Are Dead β¨ http://news.techrights.org/n/2023/10/12/They_Won_t_Leave_Software_Freedom_Fighters_Alone_Until_They_Are.shtml | βΎ Gemini address: gemini://gemini.techrights.org/n/2023/10/12/They_Won_t_Leave_Software_Freedom_Fighters_Alone_Until_They_Are.gmi β | Oct 12 15:31 |
schestowitz-pi | brought to you by Club battistelli | Oct 12 15:32 |
schestowitz-pi | anyway, EU is losing me as a proponent | Oct 12 15:32 |
schestowitz-pi | i just did some more articles | Oct 12 15:32 |
schestowitz-pi | rianne did one in TM | Oct 12 15:32 |
techrights-sec | checking (using new computer glasses!) | Oct 12 15:32 |
schestowitz-pi | based on the time, rianne thinks it triggered the crazies | Oct 12 15:33 |
schestowitz-pi | (the moglen responses) | Oct 12 15:33 |
techrights-sec | Moglen is very important, especially in light of how very much he has advanced | Oct 12 15:33 |
techrights-sec | software freedom in the world over many decades. | Oct 12 15:33 |
schestowitz-pi | i will look to see if phony "journalists" amplifyu the "press release" | Oct 12 15:34 |
schestowitz-pi | maybe SJVN | Oct 12 15:34 |
schestowitz-pi | i can respond again and again | Oct 12 15:34 |
techrights-sec | It's very likely they will. | Oct 12 15:34 |
schestowitz-pi | i think restoring the wiki access would be a priorityu higher than the other tasks | Oct 12 15:41 |
schestowitz-pi | as sometimes i want to link to some wiki page | Oct 12 15:41 |
schestowitz-pi | i assume we do not want "going back to php" as the solution | Oct 12 15:41 |
schestowitz-pi | downloading all the pages "by hand" is feasible, but requires first running ~/wiki on some VM | Oct 12 15:41 |
techrights-sec | Windoze TCO: https://svenska.yle.fi/a/7-10043330 | Oct 12 15:48 |
techrights-sec | How should the Wiki get re-created? The tables don't seem to hold the desired | Oct 12 15:48 |
techrights-sec | data at all. I have them in a db here and can make an account for you to dig | Oct 12 15:48 |
techrights-sec | around to see if you can find a pattern. Once I know which tables and columns, | Oct 12 15:48 |
techrights-sec | it is then easy to write a shortish perl script to extract to static HTML. | Oct 12 15:48 |
schestowitz-pi | i have to go in a minute | Oct 12 15:49 |
schestowitz-pi | i wonder if running it and saving the pages would be a lot faster | Oct 12 15:49 |
techrights-sec | it might be, but only if accessed via localhost | Oct 12 15:49 |
techrights-sec | "Potential measures that Russia may take against Finland include information influencing and undermining bilate | Oct 12 16:56 |
techrights-sec | ral links, such as by withdrawing from remaining treaties. Denial of service (DoS) attacks can also give an imp | Oct 12 16:56 |
techrights-sec | ression that infrastructure and services are vulnerable, even without causing any real damage." Alvari explaine | Oct 12 16:56 |
techrights-sec | d." | Oct 12 16:56 |
techrights-sec | https://yle.fi/a/74-20054918 | Oct 12 16:56 |
techrights-sec | -- all hot air if the public and busineses and schools are not given strict | Oct 12 16:56 |
techrights-sec | guidance to fire the quisling microsofters which make the country's computers | Oct 12 16:56 |
techrights-sec | super vulnerable to abuse and exploitation. A complete pivot away from M$ is | Oct 12 16:56 |
techrights-sec | the essential first step towards online survival. | Oct 12 16:56 |
techrights-sec | s/which/who/ | Oct 12 16:56 |
techrights-sec | DeRaadt's comment on GNOME vs X11 is a possible topic, too. | Oct 12 16:57 |
schestowitz-pi | thanks for the topic suggestion | Oct 12 16:57 |
schestowitz-pi | while out I was thinking about wiki approches | Oct 12 16:57 |
schestowitz-pi | checking now a bunch of thoughts for actual assessment in online forums etc. | Oct 12 16:57 |
techrights-sec | NATO is in between a rock and a hard place with so many Windoze deployments | Oct 12 16:58 |
techrights-sec | ^ topic ? | Oct 12 16:58 |
schestowitz-pi | added | Oct 12 16:59 |
schestowitz-pi | got 3 things on my plate now | Oct 12 16:59 |
schestowitz-pi | btw, got for 1.50 what would cost about 15 otherwise | Oct 12 16:59 |
schestowitz-pi | right place, right time | Oct 12 16:59 |
schestowitz-pi | they also open a new shop near us soon | Oct 12 16:59 |
schestowitz-pi | some good things happening | Oct 12 16:59 |
schestowitz-pi | and in the context of wars and cuts anything good is a blessing at this point | Oct 12 16:59 |
*wallacer has quit (connection closed) | Oct 12 17:09 | |
*wallacer (~quassel@8k53v3b3bgq6i.irc) has joined #tuxmachines | Oct 12 17:10 | |
schestowitz-pi | http://techrights.org/n/2023/10/12/OpenBSD_Founder_Theo_de_Raadt_Says_Wayland_is_an_Attack_Softwar.shtml | Oct 12 17:28 |
schestowitz-pi | i was thinking of the wiki while walking | Oct 12 17:32 |
schestowitz-pi | as it seemed that maybee trhat version keeps full copy of each revision, not deltas or diffs | Oct 12 17:32 |
schestowitz-pi | and maybe some table has an ordered list of the versions | Oct 12 17:32 |
schestowitz-pi | wikis are a gimmick, in retrospect | Oct 12 17:32 |
schestowitz-pi | they become a pain to patch and mainstain | Oct 12 17:32 |
schestowitz-pi | https://github.com/SolidCharity/exportMediaWiki2HTML/blob/main/exportMediaWiki2Html.py | Oct 12 17:36 |
schestowitz-pi | https://github.com/SolidCharity/exportMediaWiki2HTML/blob/main/exportMediaWiki2Html.py | Oct 12 17:38 |
schestowitz-pi | better (from DB to hugo): | Oct 12 17:38 |
schestowitz-pi | https://gitlab.apertis.org/docs/mediawiki-to-hugo-conversion | Oct 12 17:38 |
techrights-news | Techrights β OpenBSD Founder Theo de Raadt Says Wayland is an Attack Software Choice and a Push Towards "Vertical Software Monocultures" β¨ http://news.techrights.org/n/2023/10/12/OpenBSD_Founder_Theo_de_Raadt_Says_Wayland_is_an_Attack_Softwar.shtml | βΎ Gemini address: gemini://gemini.techrights.org/n/2023/10/12/OpenBSD_Founder_Theo_de_Raadt_Says_Wayland_is_an_Attack_Softwar.gmi β | Oct 12 17:43 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Ubuntu 23.10 Official Flavors Are Now Available for Download, Hereβs Whatβs New β¨ http://news.tuxmachines.org/n/2023/10/12/Ubuntu_23_10_Official_Flavors_Are_Now_Available_for_Download_He.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/Ubuntu_23_10_Official_Flavors_Are_Now_Available_for_Download_He.gmi β | Oct 12 17:43 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Ubuntu 23.10 (Mantic Minotaur) Officially Released with Linux 6.5 and GNOME 45 β¨ http://news.tuxmachines.org/n/2023/10/12/Ubuntu_23_10_Mantic_Minotaur_Officially_Released_with_Linux_6_5.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/Ubuntu_23_10_Mantic_Minotaur_Officially_Released_with_Linux_6_5.gmi β | Oct 12 17:43 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Ubuntu 23.10 is Now Available For Download. This is What's New. β¨ http://news.tuxmachines.org/n/2023/10/12/Ubuntu_23_10_is_Now_Available_For_Download_This_is_What_s_New.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/Ubuntu_23_10_is_Now_Available_For_Download_This_is_What_s_New.gmi β | Oct 12 17:44 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): #HowTo Upgrade to Ubuntu 23.10 from 23.04 β¨ http://news.tuxmachines.org/n/2023/10/12/How_to_Upgrade_to_Ubuntu_23_10_from_23_04.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/How_to_Upgrade_to_Ubuntu_23_10_from_23_04.gmi β | Oct 12 17:44 |
techrights-sec | mariadb is there ^ | Oct 12 18:05 |
techrights-sec | archive has read-only access to everything, I use that for scripting to | Oct 12 18:05 |
techrights-sec | avoid breaking | Oct 12 18:05 |
techrights-sec | anything by accident | Oct 12 18:08 |
techrights-sec | but 'archive' does read it all anyway | Oct 12 18:08 |
psydruid | whatever can be done with wiki software can be done using versioning software too, can't it? | Oct 12 18:10 |
psydruid | and without the complexity of a wiki software stack to support it | Oct 12 18:10 |
schestowitz-pi | MariaDB [wiki]> SHOW tables; | Oct 12 18:12 |
schestowitz-pi | +-------------------+ | Oct 12 18:12 |
schestowitz-pi | | Tables_in_wiki | | Oct 12 18:12 |
schestowitz-pi | +-------------------+ | Oct 12 18:12 |
schestowitz-pi | | archive | | Oct 12 18:12 |
schestowitz-pi | | category | | Oct 12 18:12 |
schestowitz-pi | | categorylinks | | Oct 12 18:12 |
schestowitz-pi | | externallinks | | Oct 12 18:12 |
schestowitz-pi | | image | | Oct 12 18:12 |
schestowitz-pi | | imagelinks | | Oct 12 18:12 |
schestowitz-pi | | interwiki | | Oct 12 18:12 |
schestowitz-pi | | ipblocks | | Oct 12 18:12 |
schestowitz-pi | | langlinks | | Oct 12 18:12 |
schestowitz-pi | | logging | | Oct 12 18:12 |
schestowitz-pi | | objectcache | | Oct 12 18:12 |
schestowitz-pi | | oldimage | | Oct 12 18:12 |
schestowitz-pi | 14123 rows in revision | Oct 12 18:12 |
schestowitz-pi | page seems to be list of all objects/pages | Oct 12 18:12 |
schestowitz-pi | select | Oct 12 18:12 |
schestowitz-pi | * | Oct 12 18:12 |
schestowitz-pi | from | Oct 12 18:12 |
schestowitz-pi | page LIMIT 20; | Oct 12 18:12 |
schestowitz-pi | psydruid: yes | Oct 12 18:12 |
schestowitz-pi | but we need to 'evacuate' all the data | Oct 12 18:12 |
schestowitz-pi | and this includes images, categories etc. | Oct 12 18:13 |
schestowitz-pi | we can keep some in private old archive (db) | Oct 12 18:13 |
schestowitz-pi | and do it simpler | Oct 12 18:13 |
schestowitz-pi | | wiki | objectcache | 3.95549774 | | Oct 12 18:23 |
schestowitz-pi | | wiki | text | 1065.63499069 | | Oct 12 18:23 |
schestowitz-pi | | wiki | page | 0.25188065 | | Oct 12 18:23 |
schestowitz-pi | | wiki | logging | 3.06293488 | | Oct 12 18:23 |
schestowitz-pi | | wiki | revision | 2.16442871 | | Oct 12 18:23 |
schestowitz-pi | | wiki | watchlist | 0.02304840 | | Oct 12 18:24 |
schestowitz-pi | | wiki | interwiki | 0.00893402 | | Oct 12 18:24 |
schestowitz-pi | select count(*) row_count from text; | Oct 12 18:24 |
schestowitz-pi | +-----------+ | Oct 12 18:24 |
schestowitz-pi | | row_count | | Oct 12 18:25 |
schestowitz-pi | +-----------+ | Oct 12 18:25 |
schestowitz-pi | | 17724 | | Oct 12 18:25 |
schestowitz-pi | +-----------+ | Oct 12 18:25 |
schestowitz-pi | awful wiki software that stores 18k versions, adding up to 1+ GB of text | Oct 12 18:25 |
techrights-sec | old_id ? | Oct 12 18:32 |
schestowitz-pi | select * from text where old_id = 17699; | Oct 12 18:32 |
schestowitz-pi | i think i got it | Oct 12 18:36 |
schestowitz-pi | select | Oct 12 18:36 |
schestowitz-pi | * | Oct 12 18:36 |
schestowitz-pi | from | Oct 12 18:36 |
schestowitz-pi | page LIMIT 20; | Oct 12 18:36 |
schestowitz-pi | take note of field "page_latest" | Oct 12 18:36 |
schestowitz-pi | for "IBM": | Oct 12 18:36 |
schestowitz-pi | select | Oct 12 18:36 |
schestowitz-pi | * | Oct 12 18:36 |
schestowitz-pi | from | Oct 12 18:36 |
schestowitz-pi | revision | Oct 12 18:36 |
schestowitz-pi | where | Oct 12 18:36 |
schestowitz-pi | rev_id = 17698; | Oct 12 18:36 |
schestowitz-pi | take note of field "rev_text_id " | Oct 12 18:36 |
schestowitz-pi | select | Oct 12 18:42 |
schestowitz-pi | * | Oct 12 18:42 |
schestowitz-pi | from | Oct 12 18:42 |
schestowitz-pi | text | Oct 12 18:42 |
schestowitz-pi | where | Oct 12 18:42 |
schestowitz-pi | old_id = 17681; | Oct 12 18:42 |
schestowitz-pi | that seens like latest ibm | Oct 12 18:42 |
schestowitz-pi | revision.rev_text_id -> old_id | Oct 12 18:42 |
schestowitz-pi | select * from text where old_id = 17724; | Oct 12 18:57 |
schestowitz-pi | the last edit | Oct 12 18:57 |
schestowitz-pi | they get stored in full | Oct 12 18:57 |
schestowitz-pi | select | Oct 12 18:57 |
schestowitz-pi | * | Oct 12 18:57 |
schestowitz-pi | from | Oct 12 18:57 |
schestowitz-pi | page WHERE page_title="DuckDuckGo"; | Oct 12 18:57 |
techrights-sec | great | Oct 12 18:57 |
techrights-sec | checking | Oct 12 18:57 |
techrights-sec | is page.page_latest equal to revision.rev_id ? | Oct 12 18:57 |
techrights-sec | revision.rev_text_id == page.page_latest ? | Oct 12 18:57 |
techrights-sec | Can you formulate a JOIN statement? | Oct 12 18:57 |
techrights-sec | right but if revision.rev_text_id has the latest revision id and | Oct 12 18:57 |
techrights-sec | can be used to look up text.old_id then a join statement can be written | Oct 12 18:57 |
techrights-sec | 1) on long phone call atm and useless for deep thought | Oct 12 18:57 |
techrights-sec | 2) not personally familiar with the content | Oct 12 18:57 |
*MinceR gives voice to wallacer | Oct 12 19:02 | |
techrights-sec | select page.page_latest from page group by page_title; ? | Oct 12 19:04 |
schestowitz-pi | select | Oct 12 19:04 |
schestowitz-pi | * | Oct 12 19:04 |
schestowitz-pi | from | Oct 12 19:05 |
schestowitz-pi | page WHERE page_title="EPO"; | Oct 12 19:05 |
schestowitz-pi | select | Oct 12 19:05 |
schestowitz-pi | * | Oct 12 19:05 |
schestowitz-pi | from | Oct 12 19:05 |
schestowitz-pi | revision | Oct 12 19:05 |
schestowitz-pi | where | Oct 12 19:05 |
schestowitz-pi | rev_id = 17608; | Oct 12 19:05 |
schestowitz-pi | select | Oct 12 19:05 |
schestowitz-pi | * | Oct 12 19:05 |
schestowitz-pi | from | Oct 12 19:05 |
schestowitz-pi | text | Oct 12 19:05 |
schestowitz-pi | where | Oct 12 19:05 |
schestowitz-pi | old_id = 17591; | Oct 12 19:05 |
techrights-sec | select page_id, page_latest, left(page_title,50), left(old_text, 150) from page left join text on page_latest = | Oct 12 19:08 |
techrights-sec | old_id; | Oct 12 19:08 |
techrights-sec | ?? | Oct 12 19:08 |
techrights-sec | the left() functions can be removed if the above is correct | Oct 12 19:08 |
techrights-sec | Does the above join find the latest content (aka text.old_text) ? | Oct 12 19:08 |
techrights-sec | select page_id, page_latest, left(page_title,50), left(old_text, 150) from page left join text on page_latest = | Oct 12 19:11 |
techrights-sec | old_id group by page_title order by old_id; | Oct 12 19:11 |
techrights-sec | ? | Oct 12 19:11 |
schestowitz-pi | checking | Oct 12 19:17 |
schestowitz-pi | the things near the bottom seem to correspond to more recent edits and/or additions | Oct 12 19:17 |
schestowitz-pi | so we seem to be very close now :-) | Oct 12 19:17 |
schestowitz-pi | i think there might be a mimatch there in the numbers | Oct 12 19:19 |
schestowitz-pi | ok, the number in the second column is revision.rev_id | Oct 12 19:22 |
schestowitz-pi | from there, there needs to be a hop to text.old_id | Oct 12 19:22 |
schestowitz-pi | for latest contents for each given page | Oct 12 19:22 |
techrights-sec | which table is rev_id in? | Oct 12 19:24 |
techrights-sec | If you can formulate a join statement, I can figure the rest out. | Oct 12 19:24 |
schestowitz-pi | i think it can be done procedurally in 3 steps | Oct 12 19:29 |
schestowitz-pi | without a join: | Oct 12 19:29 |
schestowitz-pi | page.page_latest (for 1765 rows) | Oct 12 19:29 |
schestowitz-pi | where revision.rev_id=[value above] | Oct 12 19:29 |
techrights-sec | left join produces the simplest output to work with, otherwise | Oct 12 19:29 |
techrights-sec | the script has to do the join and that is extra work and a PITA and | Oct 12 19:29 |
techrights-sec | duplicating the work of SQL. | Oct 12 19:29 |
techrights-sec | select page.page_latest, page.page_title from page left join revision on revision.rev_id=page.page_latest; | Oct 12 19:34 |
techrights-sec | ?? | Oct 12 19:34 |
schestowitz-pi | just started my percolator | Oct 12 19:35 |
schestowitz-pi | been over 20 years since i did JOINS | Oct 12 19:35 |
schestowitz-pi | you are miles better at sql queries and optimisation | Oct 12 19:35 |
schestowitz-pi | trying the latest query now | Oct 12 19:35 |
techrights-sec | which table + column has the actual content though? | Oct 12 19:37 |
schestowitz-pi | text.old_id | Oct 12 19:38 |
schestowitz-pi | the old_id number corresponds to revision.rev_text_id | Oct 12 19:38 |
schestowitz-pi | i did manual checks and it makes perfect sense | Oct 12 19:38 |
schestowitz-pi | it does in fact give you the _full_ latest latest version for each in page.page_latest (for 1765 rows) | Oct 12 19:38 |
schestowitz-pi | from there we can just process the text | Oct 12 19:38 |
techrights-sec | select page.page_latest, page.page_title, left(text.old_text, 200) from page left join revision on revision.rev | Oct 12 19:49 |
techrights-sec | _id=page.page_latest left join text on text.old_id = revision.rev_id; | Oct 12 19:49 |
techrights-sec | ^ does that get the first 200 chars of the post? | Oct 12 19:49 |
schestowitz-pi | i am trying to trace back the numbers | Oct 12 19:53 |
schestowitz-pi | and it confuses me | Oct 12 19:53 |
schestowitz-pi | trying something... | Oct 12 19:53 |
schestowitz-pi | select page.page_latest, page.page_title, left(text.old_text, 200) from page left join revision on revision | Oct 12 19:53 |
schestowitz-pi | .rev_id=page.page_latest left join text on text.old_id = revision.rev_text_id; | Oct 12 19:53 |
*schestowitz-TR has quit (Ping timeout: 2m30s) | Oct 12 20:24 | |
*schestowitz-TR has quit (Ping timeout: 120 seconds) | Oct 12 20:25 | |
techrights-sec | great, will work it into a script tomorrow | Oct 12 20:28 |
techrights-sec | afk | Oct 12 20:28 |
*libertybox has quit (Ping timeout: 2m30s) | Oct 12 20:30 | |
*libertybox_ has quit (Ping timeout: 2m30s) | Oct 12 21:18 | |
*libertybox__ has quit (Ping timeout: 2m30s) | Oct 12 21:18 | |
*Techrights-sec2 has quit (Ping timeout: 2m30s) | Oct 12 21:19 | |
*roy has quit (Ping timeout: 2m30s) | Oct 12 21:19 | |
*Techrights-sec2 (~quassel@3stvfjh5iuw88.irc) has joined #tuxmachines | Oct 12 21:19 | |
*libertybox_ (~schestowitz_log@3stvfjh5iuw88.irc) has joined #tuxmachines | Oct 12 21:19 | |
*libertybox (~schestowitz_log@3stvfjh5iuw88.irc) has joined #tuxmachines | Oct 12 21:19 | |
*libertybox__ (~schestowitz_log@3stvfjh5iuw88.irc) has joined #tuxmachines | Oct 12 21:19 | |
*schestowitz-TR (~acer-box@3stvfjh5iuw88.irc) has joined #tuxmachines | Oct 12 21:19 | |
*schestowitz-TR (~acer-box@freenode/user/schestowitz) has joined #tuxmachines | Oct 12 21:19 | |
*208A2YENU has quit (Ping timeout: 120 seconds) | Oct 12 21:20 | |
*311EH523Y has quit (Ping timeout: 120 seconds) | Oct 12 21:20 | |
*roy (~quassel@3stvfjh5iuw88.irc) has joined #tuxmachines | Oct 12 21:20 | |
*Techrights-sec (~quassel@freenode-clchr3.71tb.6ao7.hij1op.IP) has joined #tuxmachines | Oct 12 21:20 | |
*311EI4T5J (~quassel@freenode-clchr3.71tb.6ao7.hij1op.IP) has joined #tuxmachines | Oct 12 21:20 | |
*MinceR gives voice to libertybox__ schestowitz-TR libertybox_ | Oct 12 21:42 | |
*MinceR gives voice to Techrights-sec2 libertybox roy | Oct 12 21:42 | |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Security: Patches, Linux Long-Term Support, and Windows TCO/Incidents β¨ http://news.tuxmachines.org/n/2023/10/12/Security_Patches_Linux_Long_Term_Support_and_Windows_TCO_Incide.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/Security_Patches_Linux_Long_Term_Support_and_Windows_TCO_Incide.gmi β | Oct 12 22:16 |
techrights-news | β² πΏππ πΈπππππππ ⨦ (NEW): Today's ππΆπΉ ππ’π€π©πͺπ―π¦π΄ HowTos β¨ http://news.tuxmachines.org/n/2023/10/12/today_s_howtos.3.shtml | βΎ Gemini address: gemini://gemini.tuxmachines.org/n/2023/10/12/today_s_howtos.3.gmi β | Oct 12 22:16 |
techrights-news | Techrights β Windows Works for Moscow (When Russia's Enemies Use It) β¨ http://news.techrights.org/n/2023/10/12/Windows_Works_for_Moscow_When_Russia_s_Enemies_Use_It.shtml | βΎ Gemini address: gemini://gemini.techrights.org/n/2023/10/12/Windows_Works_for_Moscow_When_Russia_s_Enemies_Use_It.gmi β | Oct 12 22:16 |
techrights-news | Techrights β In North America GNU/Linux is Already at 10% Market Share on Laptops and Desktops, Shows Survey of Web-Connected Clients β¨ http://news.techrights.org/n/2023/10/12/In_North_America_GNU_Linux_is_Already_at_10_Market_Share_on_Lap.shtml | βΎ Gemini address: gemini://gemini.techrights.org/n/2023/10/12/In_North_America_GNU_Linux_is_Already_at_10_Market_Share_on_Lap.gmi β | Oct 12 22:16 |
techrights-news | Techrights β The Wiki Will Likely Return Shortly (Sans the PHP Back End That Caused Terrible Load Spikes) β¨ http://news.techrights.org/n/2023/10/12/The_Wiki_Will_Likely_Return_Shortly_Sans_the_PHP_Back_End_That_.shtml | βΎ Gemini address: gemini://gemini.techrights.org/n/2023/10/12/The_Wiki_Will_Likely_Return_Shortly_Sans_the_PHP_Back_End_That_.gmi β | Oct 12 22:16 |
*psydruid (~psydruid@jevhxkzmtrbww.irc) has left #tuxmachines | Oct 12 23:03 | |
*psydruid (~psydruid@jevhxkzmtrbww.irc) has joined #tuxmachines | Oct 12 23:06 | |
*MinceR gives voice to psydruid | Oct 12 23:06 |
Generated by irclog2html.py 2.6 by Marius Gedminas - find it at mg.pov.lt!