●● IRC: #boycottnovell @ FreeNode: Tuesday, March 02, 2021 ●● ● Mar 02 [00:46] schestowitz__ I have just realised, by coincidence, that we have not been backing up the TR DBs at all. When mysql/mariadb was removed from that server it stopped having access to the mysql dump tools [00:50] schestowitz__ OK, I have just successfully taken backups of all 3 DBs. [00:50] schestowitz__ I noticed this only because I wanted to tinker with https://lists.orbitalfox.eu/archives/gemini/2021/005813.html https://git.sr.ht/~sbgodin/htmgem/refs [00:50] -TechrightsBN/#boycottnovell-lists.orbitalfox.eu | [ANN] HtmGem, Php program to view Gemini through HTTP [00:50] -TechrightsBN/#boycottnovell-git.sr.ht | ~sbgodin/htmgem refs - sourcehut git [00:50] schestowitz__ it's alpha so not wise to try on prod anyway ● Mar 02 [01:35] *liberty_box has quit (Ping timeout: 240 seconds) [01:35] *rianne__ has quit (Ping timeout: 264 seconds) [01:42] *rianne__ (~rianne@host81-154-169-167.range81-154.btcentralplus.com) has joined #boycottnovell [01:43] *liberty_box (~liberty@host81-154-169-167.range81-154.btcentralplus.com) has joined #boycottnovell ● Mar 02 [02:16] *liberty_box has quit (Ping timeout: 260 seconds) [02:16] *rianne__ has quit (Ping timeout: 260 seconds) [02:26] *rianne__ (~rianne@host81-154-169-167.range81-154.btcentralplus.com) has joined #boycottnovell [02:27] *liberty_box (~liberty@host81-154-169-167.range81-154.btcentralplus.com) has joined #boycottnovell ● Mar 02 [04:05] *liberty_box has quit (Ping timeout: 245 seconds) [04:05] *rianne__ has quit (Ping timeout: 245 seconds) [04:26] *rianne__ (~rianne@host81-154-169-167.range81-154.btcentralplus.com) has joined #boycottnovell [04:27] *liberty_box (~liberty@host81-154-169-167.range81-154.btcentralplus.com) has joined #boycottnovell ● Mar 02 [06:43] Techrights-sec the TM database is still on the localhost? [06:43] schestowitz__ Yes, and backups of it worked both locally and remotely, as the dumping is done on that host [06:59] schestowitz__ I've made a complete backup of pi:/home/* ● Mar 02 [07:30] *liberty_box has quit (Ping timeout: 240 seconds) [07:31] *rianne__ has quit (Ping timeout: 260 seconds) [07:36] *rianne__ (~rianne@host81-154-169-167.range81-154.btcentralplus.com) has joined #boycottnovell [07:38] *liberty_box (~liberty@host81-154-169-167.range81-154.btcentralplus.com) has joined #boycottnovell ● Mar 02 [08:00] Techrights-sec great [08:00] Techrights-sec that's abotu 1.2 GB [08:00] Techrights-sec though some of those would be hardlinks to the other directory [08:00] Techrights-sec I presume it was with tar, with or without --hard-dereference [08:00] Techrights-sec 2.3 GB for /home/ [08:02] schestowitz__ just 2.3 gb but about 100k files [08:02] schestowitz__ rsync took ages over this [08:31] Techrights-sec Ethernet is faster than wireless [08:31] Techrights-sec ssh pi@xx.yy.zz.aa 'sudo tar zcf - /home/' > home.tar.gz [08:31] Techrights-sec or [08:31] Techrights-sec ssh pi@xx.yy.zz.aa 'sudo tar cf - /home/' > home.tar; gzip home.tar [08:31] Techrights-sec depending on where the bottlneck is: CPU or bandwidth [08:31] Techrights-sec remember that tc is in place. it probably needs tuning. it definitely [08:31] Techrights-sec has a low limit on all network I/O [08:39] Techrights-sec I've added Lock_tables_priv to boycottn_wrdp1_ro, it can now do backups. [08:39] Techrights-sec Also, the backups run fine remotely so they don't need to be on the same [08:39] Techrights-sec machine any more, if it saves a step to move the scripts. Probably not though. [08:39] schestowitz__ in case of raid issues it might help to do a weekly db offsite backup [08:54] Techrights-sec I've updated get_dbs.sh [08:54] Techrights-sec it uses the ro user now [08:54] Techrights-sec We'll have to double check tomorrow to ensure that it did the backup ok. [08:54] Techrights-sec Offsite is done intermittently here. [08:54] Techrights-sec I don't remember often and that's mostly because when I do, it would [08:54] Techrights-sec interfere with site usage. The downloads were noticeable on the old server [08:54] Techrights-sec so there was only a narrow window of time each day when it was a good idea [08:54] Techrights-sec to try. I can see how it is now. [08:54] Techrights-sec I should get an additional drive for that, too, but it will have to [08:54] Techrights-sec wait until there is some kind of sale. There should be one before summer. [08:55] schestowitz__ after moving monitoring away from email and putting it in tmux the tmux pane was too small to read most things on. I will need to think of a contingency. ● Mar 02 [09:42] Techrights-sec resize tmux to the size needed [09:42] Techrights-sec 184x52 is max for me though [09:45] schestowitz__ in tmux the lower res user imposes the downscaling on the other. anyway, many of these checks (like disk space) are obsolete, it just helps to have sanity checks n DB dump size for TM and BN/TR, to avoid the worst of all catastrophes [09:46] schestowitz__ our ipfs expert is rebuilding his node as openbsd (tired of linux), so the ipfs pinned mirror is down for a few days and thus I run it locally throughout the day today, maybe tomorrow also [09:47] schestowitz__ in other new mjg is bored (unemployed I assume) and is trolling our irc channel more [09:47] schestowitz__ in other news, mjg is bored (unemployed I assume) and is trolling our irc channel more ● Mar 02 [13:50] Techrights-sec the good side is that he's not at Google any more. Goolge / Alphabet has become really a bad place. I do hope that he uses the [13:50] Techrights-sec time between jobs or at the new job to grow a bit. [13:50] Techrights-sec But after age 5 or so, peole usually don't change or improve [13:50] Techrights-sec just gain new skills only [13:50] Techrights-sec so one approach might be just to not waste time on interaction with him except in the few areas where there is established agree [13:50] Techrights-sec ment and opportunity for cooperation [13:51] schestowitz__ Yes, I try to get him on our side even if it seems hopeless (was done before) [13:52] Techrights-sec I'm not sure it is worth it to try to convince him of anything, jsut interact [13:52] Techrights-sec only where there is clear unity already. ● Mar 02 [16:06] schestowitz__ in the latest pocock piece i've copied the images across [16:49] Techrights-sec great