/srv/irclogs.ubuntu.com/2024/05/03/#ubuntu.txt

oerheksbut this happened on wayland too?00:00
ravageyes happens on wayland too00:00
ravagenot sure if maybe only with nvidia in general00:00
ravagehttps://bugs.launchpad.net/ubuntu/+source/gnome-shell-extension-tiling-assistant/+bug/206397000:01
-ubottu:#ubuntu- Launchpad bug 2063970 in gnome-shell-extension-tiling-assistant (Ubuntu) "Enhanced tiling orange shading that indicates what a window will resize to will persist even after I'm done with the adjustment." [Undecided, Confirmed]00:01
sarnoldravage: nice find00:03
kuiperanonHi. For some reason, my apt is giving 404 for IPs that I can ping. https://gist.github.com/kuiperanon/746561a7b533d467a19497716e734cac00:14
kuiperanonAnd I'm getting other errors00:14
patrick_somebodyare you running ubu as a virtual instance?00:15
tomreyn!kinetic | kuiperanon00:15
ubottukuiperanon: Ubuntu 22.10 (Kinetic Kudu) was the 37th release of Ubuntu, support ended on July 20, 2023. See !eol and https://lists.ubuntu.com/archives/ubuntu-announce/2023-July/000293.html00:15
patrick_somebodycan you do a basic ping and reach anything outside of your loopback?00:15
tomreynit's not a networking issue.00:16
kuiperanonI'm running ubu in digital ocean00:16
tomreynthe mirror server reports 404s because this is an unsupported release00:16
kuiperanon I'll see if I can migrate my stuff easily00:17
patrick_somebodynice00:17
patrick_somebodylet me guess, only 22.04 is supported00:17
tomreynsee the channel /topic00:17
patrick_somebodysorry. trying to be helpful00:18
patrick_somebodyill shut up00:18
tomreynno, no, please do try to help when you can00:18
Guest62Yay! ravage, disabling the enhanced tiling really solved the issue, thanks man!00:18
sarnoldravage: botsnack00:18
sarnoldkuiperanon: hopefully helpful https://help.ubuntu.com/community/EOLUpgrades00:19
ravagenice. mark yourself as affected on https://bugs.launchpad.net/ubuntu/+source/gnome-shell-extension-tiling-assistant/+bug/206397000:19
-ubottu:#ubuntu- Launchpad bug 2063970 in gnome-shell-extension-tiling-assistant (Ubuntu) "Enhanced tiling orange shading that indicates what a window will resize to will persist even after I'm done with the adjustment." [Undecided, Confirmed]00:19
oerheks!cookie | ravage00:28
ubotturavage: Wow! You're such a great helper, you deserve a cookie!00:28
ravage\o/ COOKIE!00:29
felcomarked as affected there00:48
felcohttps://bugs.launchpad.net/ubuntu/+source/remmina/+bug/206217700:56
-ubottu:#ubuntu- Launchpad bug 2062177 in remmina (Ubuntu) "Remmina crashes after RDP connection" [High, Fix Committed]00:56
felcoguys any eta to get this? :[00:56
sarnoldit looks like someone's verified the fix00:58
sarnoldso it'll probably land in a week00:58
tomreynit's also in -proposed and the projects' ppa according to comment 9, if you need it sooner00:59
felconiiicee01:19
applepearhello02:19
smoltalkHas anybody tried running subiquity 24.04.x for an ubuntu desktop 22.04 install? I'm writing a provisioning script for server 22.04 to help me set up LVM over LUKS on multiple disks. I got the partitions and volumes set up the way I like them via a bash script, but neither subiquity 22.04 or 24.04 on live server images gives me the option to select02:29
smoltalkthe (v)fat32 partition I set up as the system EFI partition (like I was able to do on desktop 22.04).02:29
smoltalkI'm thinking a good option for this that could be shared out later would be to create a script that generates autoinstall.yaml and then restarts the ubiquity snap to pick up the generated config. This also sidesteps the issue of having to have a plaintext key in autoinstall.yaml or include a keyfile on the CIDATA drive for LUKS partitions. I'm02:29
smoltalkhoping if I need to provision another desktop 22.04 machine, it would be usable there as well.02:29
smoltalkI was also thinking of trying to build this out as an addition to subiquity (ex: a guided partitioning option as a middle ground between manual partitioning and just picking a single drive for the OS installation), but I think my approach is too opinionated for a PR like that to make it upstream. Any thoughts/suggestions? Or experience using02:32
smoltalksubiquity on desktop 22.04?02:32
ravageIf you already got this far with a bash script add debootstrap and grub 02:37
ravageAnd you have a running system02:37
smoltalkravage I haven't heard of debootstrap before, and I see some folks have had success with setting up ubuntu on it. This sounds like a much less involved option than trying to rewrite half of my script to spit out a correct autoinstall.yaml. Thank you!02:41
sarnolddebootstrap has some problems with usrmerge I don't understand :/02:42
sarnoldhunt around a little bit to see if there's a good solution there02:42
sarnoldmmdebstrap is apparently much faster than debootstrap02:42
ravagehad no problem with debootstrap for my 24.04 setup02:43
ravagebut you should try to find the latest version02:43
ravagei think i actually used the noble one02:43
ravagedid the setup from a grml live iso02:44
smoltalkravage just out of curiosity, were you trying to do use debootstrap for a server or desktop install on 24.04?02:44
ravagedesktop02:44
smoltalksarnold I'll also check out mmdebstrap, thanks!02:44
ravagehttps://launchpad.net/ubuntu/noble/amd64/debootstrap/1.0.134ubuntu1 this one shoule do the job. i should check mmdebstrap02:45
smoltalkravage according to what I've read so far, it utilizes APT as part of its bootstrap process, so you can use multiple package sources. It also claims to be considerably faster.02:47
ravageand the reason for debootstrap was encrypted raid1 that was not possible the way i liked it with the installer02:47
ravageyes thats what i read too02:47
ravagebut speed is not that relevant02:47
ravageirs not like you install 1000 packages and i only need to do it once02:47
ravage*its02:47
ravagebut i also use it to install 24.04 on our dedicated servers02:48
ravageworks fine02:48
ravage(and 22.04 too)02:48
smoltalkEither seems like a good option for my use case. Glad I logged on when y'all were around! This has been really helpful, thanks!02:54
ravagegood luck. i could share my basic bash script if you need it03:08
ravagebut that does not use any encryption. so here the only tricky part is make sure you install cryprsetup and get the crypttab right03:09
cedarHello team03:25
smoltalkThanks ravage, I have that part all set, actually so I just need something that dove-tails into the actual installation portion. I'm also looking into cloud-init now in addition to debootstrap and mmdebstrap. I'm sort of confused as to why canonical forked their own project for subiquity, now. I've heard the subiquity autoinstall schema is a03:25
smoltalksuperset of cloud-init, but cloud-init seems like it can already handle a pretty wide variety of stuff. I can even bake in the server-specific setup that way03:25
lotuspsychjewelcome cedar03:26
cedarI want to upgrade my 22.04 LTS installation to 24.04 LTS but from what I've researched, it appears I have to either wait until August or upgrade to 23.10 first03:26
cedarWhat is the reason for waiting until August?  24.04 LTS has already replaced 22.04 on the main webpage03:27
ravageright now i would not recommend upgrading at all03:27
ravagethere are a few open bugs03:27
smoltalkI can share my script as well for LVM over LUKS with multiple disk support, but so far it's only managed to work on ubuntu desktop 22.04. The partitioning table isn't very customizable either03:27
ravagei am the wrong person to discuss the new installer. just not a fan of it in general.03:28
ravagethe UI they put on top of it looks nice but does not make the backend better03:29
smoltalkYeah, which is why I'm thinking a cloud-init-based setup could be pretty cool. With a few tweaks, it could hopefully be applied to more than just ubuntu/debian flavors03:29
ravageYou can do a full installation with cloud init 03:31
ravageBut ubuntu added a lot of custom stuff03:31
ravageAnd the problem is that's not trivial to figure out where that line is 03:32
smoltalkravage I agree. I've tried ubuntu server 22.04 (with subiquity 22.04 and 24.04), ubuntu desktop 22.04 (pre-subiquity), and ubuntu desktop 24.04. The install wizard on subiquity was fairly restrictive on all versions/variants, and it wasn't very intuitive to figure out how to iterate on autoinstall.yaml when it failed. I also had to dig through03:32
smoltalkmultiple levels of log files to find out what happened.03:32
ravageI'm not saying the Debian installer was great. But at least bendable to my needs with a little effort 03:33
smoltalkone of the servers I got running with a more basic setup has the auto-install conf sitting in /var/installer, and this also seems like it will be helpful: https://github.com/canonical/autoinstall-desktop03:33
lotuspsychje!discuss03:33
ubottuWant to talk about Ubuntu, but don't have a support question? /join #ubuntu-discuss for non-support Ubuntu discussion, or try #ubuntu-offtopic for general chat. Thanks!03:33
smoltalkThe `snaps` portion definitely seems subiquity-specific, but that also seems pretty easy to script03:34
lotuspsychjejoin over to the discuss channel please smoltalk03:34
ravageWe are discussing his Ubuntu installation 03:34
lotuspsychjenot really support?03:34
ravageShould be close enough to support 03:34
ravageAlso nothing else is going on here 03:35
smoltalklotuspsychje it's a bit of a hybrid thing? Subiquity has been doing me dirty, and I'm trying to figure out a good workaround that will hopefully be reusable for future provisioning efforts03:35
smoltalkbeen chewing on this for a day or two now. Much longer if you consider the desktop install. After finishing installation one ubuntu desktop machine, and getting halfway through one server installation with another to go, I've realized this is a general problem that I want to have a good solution for. That does require some more design-oriented03:37
smoltalkthinking, but it's still in service of solving a problem.03:37
smoltalkAnd considering how I shuffled around a considerable number of words in that message, sleep might be part of the solution...03:39
ravagemaybe not a bad idea. feel free to come back after some rest if you have more questions or maybe even a solution you can share 🙂03:39
smoltalkThanks for all of the help and feedback, ravage! I'm hoping to publish something to the wiki or github by the time I'm done. I'll be sure to ping you if you're around.03:42
cedarI am installing updates in TTY and the system prompted me to view the differences between my defaults.list and the one the package had. Anyways, I'm stuck in this text editor, I don't know what it is or the commands to escape it03:53
cedarHow do I get out of this text editor?03:53
lotuspsychjetry ESC or q cedar ?03:53
cedarthanks it was q03:54
cedarOne of my HDDs recently stopped showing up under Ubuntu.  While booting the system gets stuck for 1.5 minutes trying to mount it.  Perhaps it is dead?  Does not show up on lsblk at all03:56
lotuspsychjecedar: can you press F1 at booting, to switch to text boot, see if you can catch bottleneck errors03:57
lotuspsychjecedar: once in your desktop, investigate your dmesg03:57
cedaryes I did that while booting and it was stuck mounting the disk until it timed out04:02
cedarLooking in dmesg not sure what to look for04:02
lotuspsychjecedar: share with the volunteers in a !paste if you like04:04
=== SirCando is now known as EntropicReversal
lifehi04:38
lifeany one04:39
Bashing-om!ask | life04:41
ubottulife: Please don't ask to ask a question, simply ask the question (all on ONE line and in the channel, so that others can read and follow it easily). If anyone knows the answer they will most likely reply. :-) See also !patience04:41
lifeok04:41
lifeafter somany years i came here04:42
lifehello04:45
ituOMG, ALT+TAB suddenly no more working!06:06
=== remy_ is now known as Remy
jiggawattruh roh06:11
ituCoolSwitch is not working any more :-/ :-/06:17
=== LarsErik1 is now known as LarsErikP
levity"Everybody can be great...because anybody can serve(warez!). You don't have to have a college degree to serve. You don't have to make your subject and verb agree to serve. You only need a heart full of grace. A soul generated by LOVE(and archive.org  :P)."07:20
levity- Dr. Martin Luther King, Jr.07:20
levityhttp://fuckmoney.blog07:20
=== vyacheslav is now known as sogoodbestupid
ituhelp. ALT+TAB suddenly no more working ..08:02
itumaybe all navigation shortcuts are not functionally08:03
daryldHola08:35
NickNamehi. first time here. unsure what this channel is for09:00
lotuspsychje!support | NickName09:01
ubottuNickName: #ubuntu is the Ubuntu support channel, for all Ubuntu-related support questions. Please use #ubuntu-offtopic for other topics (though our !guidelines apply there too). Thanks!09:01
=== diogeness_ is now known as diogeness
filip_hey09:13
filip_help09:13
EriC^^!ask filip_09:13
EriC^^!ask | filip_09:13
ubottufilip_: Please don't ask to ask a question, simply ask the question (all on ONE line and in the channel, so that others can read and follow it easily). If anyone knows the answer they will most likely reply. :-) See also !patience09:13
johnsonmagicFucking niggggger ugly homo cunt09:37
johnsonmagicLinux has been poisoned by nigggers09:38
cbreak_linux is great.10:07
cbreak_is 24.04 safe to upgrade to by now?10:07
lotuspsychjecbreak_: you could try it from 23.10 if it works already and make a good backup in front10:10
toddccbreak_: all the basics work great just a few minor paper cuts depending on what you need most users should have no problems10:10
cbreak_nice10:10
cbreak_https://discourse.ubuntu.com/t/noble-numbat-release-notes/39890#heading--known-issues still mentions problems with upgrading the desktop install10:11
cbreak_but I guess I can try it already10:11
lotuspsychjecbreak_: safest way for now, would be clean install (full disk wipe) without too much other options10:13
cbreak_yeah... I kind of want to avoid that :)10:13
lotuspsychjeyeah well you prob want to avoid upgread breakage too :p10:14
=== cbreak_ is now known as cbreak
cbreakideally yes...10:15
Macerso i re-installed ubuntu on the macbook pro using luks+zfs (i think?) and the io problems seem to have vanished11:40
=== antonispgs5 is now known as antonispgs
negrogodhi11:40
siyouhello11:41
Maceralthough i also joined the AD with realm vs the built in gnome AD stuff since i always run into issues with sssd joining because some gpo permissive option in sssd.conf11:41
CosmicDJMacer: why luks and not just zfscrypto?11:41
=== siyou is now known as applepear
negrogodi have problem with obs, dont capture the windows, anybody can helpme11:41
MacerCosmicDJ i just used the installer. it seems like it still uses luks11:41
negrogodi use ubuntu studio11:41
Macerwith zfs underneath i guess11:41
Macerat least that is what the installer made it seem like since it said (zfs,luks) .. and you can see it using the dm-crypt mapper11:42
Macereither way. i have no idea what happened with the last install.. i just used the typical luks/lvm method and the io was really messed up. i was getting 60%+ wa11:43
Maceri also just realized that you can edit user-dirs.dirs in .config to change default dirs in home :/ i was totally doing that wrong for a long time.11:44
Maceri was doing the whole creating symlinks thing that would ruin nautilus .. it would work but i'd lose all the default icons.11:45
BluesKajHi all11:50
negrogodhi11:50
patf49Hello qui parle français ?12:29
patf49personne merci12:30
patf49c'est un chat privé ?12:30
felcopatf49 #ubuntu-fr12:32
patf49merci felco, j'arrive je suis de Suisse12:34
patf49je suis sur L-Ubintu12:35
patf49L-Ubuntu pardon12:35
felcoI do not speak french, I just pointed to you the channel were they speak french12:35
felcoHere is english only12:35
patf49ok thanks I can speak english too12:36
NeilRGCan I use the cuda toolkit for Ubuntu 22.04 on 24.04?14:44
NeilRGor else how do I get the latest cuda toolkit?14:44
pragmaticenigmaNeilRG: It can take a few months for developers to catch up to the latest version of Ubuntu. This is why most will recommend waiting to install the latest LTS release when the .1 release is made in late July.14:46
NeilRGpragmaticenigma, got it, thanks14:46
pragmaticenigmaNeilRG: Sometimes older packages can work on the latest version, but your milage may vary14:46
NeilRGis there a way to run linux within linux?14:47
NeilRGcan I run a different version of linux in docker?14:47
pragmaticenigmathat's not what docker is for14:47
leftyfbNeilRG: for what ourpose?14:48
pragmaticenigmadocker is for running containered applications, not operating systems14:48
NeilRGyes, but I want to run a container with a new CUDA14:48
leftyfbNeilRG: if you're thinking of running the cuda toolkit in a docker, that won't work the way you think it will14:48
NeilRGand that's not available on my OS yet14:48
NeilRGok14:49
pragmaticenigmayou can run another version of linux inside a VM, though getting direct hardware access will depend on the VM tooling used.14:49
=== lubuntu is now known as Pseudo
=== Pseudo is now known as lubuntu
JanCyou can run a different OS in a container, but not a different linux (=kernel)15:19
delsol_laptopJanC: yes, but there can be some gotchas there.15:25
JanCthe OS has to be compatible with the kernel obvious (as it can't change)15:27
JanC*obviously*15:27
delsol_laptoplike, if you're running linux containers on windows or mac.... obviously the linux container is going to effectively be a full VM....15:27
delsol_laptopand is going to have a different kernel than the host OS15:28
delsol_laptopbut yeah, arch container in ubuntu...   same kernel, no problem.15:28
JanCat that point it's no longer a container...15:32
delsol_laptopI mean, its still considered a container, its just got the extra QEMU->Linux kernel layer in there.15:40
delsol_laptopI don't think its actually QEMU though... been a while15:41
pragmaticenigmaA container carries only a minimal OS as part of the base image. There is no kernel attached, which means containers written for windows cannot and will not work on linux, and vice versus. There are some docker instances built for linux that run in windows, because of the WSL implementation on Windows platforms. Otherwise the best way to think of a container is this... it's just another running application. just that the applications15:43
pragmaticenigmahave no idea there are boundaries to what they can do, and have no idea what their state is within the host os.15:43
delsol_laptopright, but if you're running a linux container on a Mac host... its NOT using the mac kernel.15:44
delsol_laptopthere is an extra layer there to run the linux kernel... that THEN is shared by all the containers15:44
pragmaticenigmaThat would mean that what ever is running the container, is likely running inside a virtualized machine, something like a hypervisor15:44
=== PasiZ8 is now known as PasiZ
delsol_laptopYes.15:45
delsol_laptopWindows I believe uses virtualbox as the hypervisor15:45
delsol_laptopnot sure whats used on docker for mac15:45
pragmaticenigmahaha... no15:45
pragmaticenigmavirtualbox is oracle... and it's own game15:45
pragmaticenigma*its15:45
pragmaticenigmamicrosoft uses Hyper-V15:47
delsol_laptopAhh. Right.15:47
delsol_laptopI don't run windows really... so15:47
ArchDavehere's a way to run ubuntu on ubuntu https://ubuntu.com/server/docs/how-to-create-a-vm-with-multipass15:48
pragmaticenigmaThis is why we have the internet and search engines... to fill in the gaps of our knowledge (though search engines are clearly an endangered species)15:48
ArchDavethere's also https://canonical.com/lxd15:49
ArchDaveThe "Arch" in ArchDave is a reference to The St. Louis Arch, and not Arch Linux, btw ya'll15:51
tomreynthere's also https://linuxcontainers.org/incus/15:52
ArchDaveya really. once you can run a vm, how hard can it be to run a container?15:57
ash_worksido people normally set up a root password to copy ssh keys between machines?16:02
ash_worksiI am reading docs on pgbackrest and they suggest (basically) `ssh root@... cat /path/to/.ssh/id_rsa.pub >> authorized_keys`16:04
ash_worksinote that my account is neither the key owner nor recipient16:05
pragmaticenigmaash_worksi: a root account is not required to move keys between machines16:05
pragmaticenigmawhat ever that article is going on about, is very wrong from a view point of keeping systems secure.16:06
leftyfbash_worksi: you should never set a root password nor allow ssh as root16:07
ash_worksipragmaticenigma: so, not that I'm arguing that point, but lets just make things more concrete: the key owner is "postgres" and recipient is "pgbackrest"16:07
cbreakash_worksi: I would strongly advise against using passwords unless you REALLY have to16:08
leftyfbash_worksi: neither of those users should be doing anything with ssh16:08
cbreakI use ssh keys when ever I can, and only have a PW for emergency recovery somewhere in my pw manager16:08
leftyfbor setting passwords on root or system accounts16:08
cbreakash_worksi: I use yubikeys most of the time16:09
leftyfbash_worksi: can you explian what your end goal is you're trying to achieve?16:09
pragmaticenigmaash_worksi: those are system process users, they should be treated the same as root. there is absolutely no reason they should be given access or permitted to use SSH16:09
ash_worksiso much talking before I could reply, but here goes anyway:16:10
ash_worksipragmaticenigma: so, given I, as ash_m, have sudo, is the typical method for this `ash_m@db:~$ sudo cp /var/lib/postgresql/.ssh/id_rsa.pub .` then `ash_m@bak:~$ sudo ssh db cat /home/ash_m/id_rsa.pub >> /home/pgbackrest/.ssh/authorized_keys`16:10
leftyfbash_worksi: don't do that16:11
cbreakwhy sudo ssh?16:12
ash_worksicbreak: for the redirect16:12
cbreakseems silly16:12
ash_worksiI'm all ears16:12
cbreakyou can just cp the file later16:12
cbreakif you need it to be done with root16:12
leftyfbash_worksi: bind mount /var/lib/postgresql into a directory in pgbackrest's home dir16:12
leftyfband do not set a password or try to ssh as the postgresql user16:13
cbreakusually, when I set up a new user account, I log in as root, then I su to that specific user, and then copy the key into their .ssh/authorized_keys as that user itself16:13
ash_worksileftyfb: how do you do that?16:13
cbreakthis only needs to be done once for initial setup, or when users lose their keys...16:13
leftyfbash_worksi: https://www.baeldung.com/linux/bind-mounts16:14
leftyfbcbreak: the point is, they do not need to be ssh'ing in as a system account. No sense in going down the path of the best methods of doing that16:14
ash_worksileftyfb: and just to be clear, this is mounting (binding?) a dir on a remote machine right?16:14
leftyfbash_worksi: lets go over this 1 step at a time. You have a server running postgresql correct?16:15
ash_worksi(the dir is on a remote machine)16:15
ash_worksicorrect16:15
ash_worksiand another one with pgbackrest installed (and a pgbackrest user)16:15
ash_worksi(with no password)16:16
ash_worksianother one => another server16:16
ash_worksi(backup server)16:16
leftyfbash_worksi: https://pgbackrest.org/user-guide.html#repo-host/setup-ssh16:16
ash_worksileftyfb: yes, that is how I started the convo16:17
leftyfbsetup a pgbackrest account on the remote server and login as that. On that server, bind mount /var/lib/postgresql into /home/pgbackrest/postgresql or something16:18
leftyfbash_worksi: https://www.baeldung.com/linux/bind-mounts16:18
ash_worksileftyfb: yes but I am bindmounting pg-primary:/var/lib/postgresql right?16:18
ash_worksilike postgres run doesn't exist on the repository server16:19
leftyfbyou're bind mounting on the postgresql server16:19
leftyfbso the bgbackrest user you create on it doesn't need access to /var/lib/postgresql exactly (it will as part GID's though)16:20
ash_worksileftyfb: so the command runs on the db server (postgres) or the backup server (pgbackrest)?16:21
leftyfbthe point is to not allow root or postgresql to ssh to or from anything. Neither should be able to login to or from anything16:21
leftyfbash_worksi: you have a server with large storage running pgbackrest that is going to ssh to the postgresql server as a newly created pgbackrest user on the postgresql and backup the db located at /home/pgbackrest/postgresql due to the bind mount to /var/lib/postgresql16:22
ash_worksileftyfb: you don't need to sign me on, I was signed on the moment I read `root@` in the docs16:23
=== peer is now known as remote_host
=== remote_host is now known as peer
ash_worksileftyfb: so, are you saying the `mount` takes places between `db:/var/lib/postgresql/.ssh` and `db:/accessible/by/local/pgbackrest/acct` ?16:25
ash_worksi(`db` is the postgres server, `bak` is the pgbackrest server)16:25
leftyfbno16:25
leftyfbon the db server: sudo mount -o /var/lib/postgresql /home/pgbackrest/postgresql/16:26
ash_worksiI don't know how that's not what I said, but I'm following...16:27
leftyfbfrom the backup server, you login to the db server via ssh as pgbackrest@postgresql-server.host and it will have access to postgresql dir right there16:27
ash_worksileftyfb: but pgbackrest has no password16:27
ash_worksiit can't log in16:27
ash_worksi(nor, atm, does a pgbackrest acct even exist on the db server)16:28
leftyfbgood, use ssh keys. The private key on the backup server in ~/home/pgbackrest/.ssh/id_rsa and the public key on the db server at /home/pgbackrest/.ssh/id_rsa.pub16:28
leftyfbyou create one16:28
leftyfbyou create a pgbackrest user on the db server so you can login via ssh and backup the postgresql db files which are bind mounted to it's home dir16:29
ash_worksithe point of the bind mount is to set up ssh16:29
* leftyfb sigh16:29
leftyfbno16:29
ash_worksiokay hold on16:30
leftyfbthe point of the bind mount is to give the pgbackrest user (that you create) access to the postgresql files in pgbackrest's home dir without ssh'ing directly to /var/lib/postgresql or worse, ssh'ing AS postgrsql16:30
ash_worksileftyfb: let me paint the scenario for you and then you can tell me when I am going down the wrong path and what to do instead16:31
leftyfbunfortunately, I have to head out now. I'm hoping others are following the idea and can chime in16:33
ash_worksileftyfb: thanks for helping :)16:33
ash_worksiokay, just to finish my question I guess, I am really looking at this: https://pgbackrest.org/user-guide.html#repo-host/setup-ssh -- I don't like that it says "roo@" in the command of the 3rd block (red flag for me), but nonetheless, pgbackrest@bak needs postgres@db's public key in it's authorized_keys file. Neither have passwords or sudo; so the question is how to get the key from db to bak. I did by16:39
ash_worksiusing ash_m which does have sudo, to copy the key somewhere I have access to it; then I can `ssh ... cat` it to the authorized_keys file on bak (or scp it, and then `sudo cat >> .../authorized_keys`)16:39
ash_worksibut I didn't like having to cp the public key; so instead of that, I am now thinking I could do the exact same thing except bind-mount db:/var/lib/postgresql db:/home/ash_m/postgresql (this is not a command, the `db:` is just so you know what server I'm talking about)16:42
ash_worksianyway, if there's a better way than (1) db: mount /var/lib/postgresql /home/ash_m/postgresql (2 [essentially]) bak: sudo ssh db cat /home/ash_m/postgresql/.ssh/id_rsa.pub >> /home/pgbackrest/.ssh/authorized_keys -- then I want to hear it16:44
ash_worksii think leftyfb was too far ahead. "you create a pgbackrest user on the db server so you can login via ssh" assumes the key has been copied already16:46
younderubuntu 24.04 Why is distro-info-data on phased update?18:02
tomreynwhy shouldn't it be?18:07
ash_worksidoes anyone have any input on my "copying ssh keys" thing? I guess is, "it doesn't matter if you bind-mount or just cp to an accessible location"18:15
leftyfbash_worksi: set a password for the pgbackrest user on the db server, enable PasswordAuthentication on the server and then use ssh-copy-id to copy the public key to the db server. Then disable PasswordAuthentication18:20
NeilRGwhy is arch so much more popular now?18:25
NeilRGalmost as popular as ubuntu18:25
leftyfb!ot | NeilRG18:26
ubottuNeilRG: #ubuntu is the Ubuntu support channel, for all Ubuntu-related support questions. Please use #ubuntu-offtopic for other topics (though our !guidelines apply there too). Thanks!18:26
NeilRGok18:26
NeilRGsorry18:26
ash_worksileftyfb: and remove the password, right?18:28
ash_worksileftyfb: that that what you'd normally do?18:29
leftyfbyou don't need to. If anything, I would set it to some obscenely large randomly generated password18:30
ash_worksileftyfb: (also, would you diverge from the pgbackrest docs? they do not have a pgbackrest user on pg-primary. They just expect the postgres key to be used to login as pgbackrest)18:30
leftyfbin some cases, I do that and never save the password so even I don't know it18:30
leftyfbis pg_primary the backup server or the db?18:31
ash_worksi(that is to say, they expect `postgres@pg-primary:~$ ssh pgbackrest@repository` to work)18:31
leftyfbyou do not need the pgbackrest user on the backup server, just the db server18:31
leftyfbhold on18:32
leftyfbthe docs suggest you ssh FROM the db server TO the backup server???18:32
ash_worksithe docs suggest that to be possible such that the command `pgbackrest` can issue commands to the backup server over ssh18:32
ash_worksi(namely "archive")18:33
ash_worksibut it is prudent for the postgres user to be able to do this since that command will be used in postgresql configuration (backup_command=pgbackrest ... or whatever it is)18:34
leftyfbash_worksi: honestly, I think this pgbackrest is overkill for a simple backup. Just stick "pg_dump database_name > db_name_20240503.sql" and scp/rsync/whatever that file to some remote location. Run it as root or some new user that has access to the db which you can easily configure18:35
leftyfbyou do NOT want the postgres user doing anything except postgresql. No password, no ssh, no anything18:36
leftyfbit's a system user, leave it alone18:36
ash_worksian archive_command is native to postgres; it can be pg_dump if you wanted18:36
leftyfbgood luck. This pgbackrest has us going in circles.18:37
ash_worksino, you squared it all up for me really18:37
ash_worksiyou were just earlier sort of helping "ahead"... or I was "behind"...18:38
leftyfbsorry, I didn't actually read that pgbackrest doc. They suggest "unideal" ways of doing things18:39
* ash_worksi read that momentarily as uni-deal18:39
leftyfbun-ideal18:39
leftyfbbad18:39
ash_worksiis that your commentary or theirs?18:40
ash_worksi(not that I'm refuting it)18:41
leftyfbthe docs are doing dumb things18:41
leftyfbin my opinion18:41
leftyfbin my 20+ years experience18:41
ash_worksileftyfb: such as? (again, not refuting)18:45
leftyfbI don't know how many times I have to say it18:45
leftyfbthey have you ssh'ing as root and directly into /var/lib/postgresql18:46
leftyfband ssh'ing as the pastgresql user18:46
leftyfbthat doc should be set ablaze with napalm18:47
ash_worksiyes, that's just for the key exchange though. What I meant was, was there any other glaring problems that struck you or when you said the "unideal" comment you there was no new info from the docs for you18:48
ash_worksis/comment you/comment/18:49
leftyfbssh'ing in as postgresql isn't just for setting up the key18:49
leftyfbplease follow my advice above18:49
leftyfbthere's no point in repeating everything18:49
ash_worksik, sorry for being tedious, but I appreciate it. thanks again.18:51
ash_worksiI am pretty sure the only time (you) are ever supposed to type ssh in that entire doc though is to exchange keys and test the connection18:53
ash_worksiI searched the whole thing for ssh; and those were the only times I saw18:53
leftyfbone of those tests is: sudo -u pgbackrest ssh postgres@pg-primary18:55
leftyfbwhich assumes the posgresql account is able to ssh in. BAD18:55
ash_worksiif you do so, it will prompt you with a pgbackrest command18:56
ash_worksisince it cant do anything except that18:56
ash_worksithat's why they have that conveluded echo18:56
ash_worksiwhich is extremely conveluded18:57
leftyfbyou just want a backup of your db right?18:57
ash_worksiit should just be `key=$(ssh admin@pg-primary cat /path/to/accessible/key); printf 'no-agent-forwarding,...command="/usr/bin/pgbackrest ..." %s' "$key" >> .ssh/authorized_keys`18:58
leftyfbforget about this pgbackrest mess. Just dump the db and copy it somewhere on a schedule18:58
ash_worksiI mean, even the `archive_command = 'test ! -f /mnt/server/archivedir/%f && cp %p /mnt/server/archivedir/%f'  # Unix` in the postgresql docs is better than that since it wont take forever to restore18:59
ash_worksibut this takes care of scheduling, retention and other things we care about19:00
ash_worksiesp since a blow-up a few years ago with just dumps caused us to be down for over 2 days19:00
ash_worksi(yes, we have a standby now)19:00
leftyfbit took 2 days to restore a dump?19:01
ash_worksiyes19:01
ash_worksiit was sad19:01
leftyfbwhy?19:01
ash_worksiit was just a lot of data19:01
leftyfbyou know using pgbackrest isn't going to be much better right? It's still the same data19:02
leftyfbor you could get the DBA's to build a better solution that isn't so monolithic19:02
leftyfbyou could also do replication for hardware redundancy. I'm not that familiar with postgres, but with mysql you can stagger the replication so if someone drop'd the entire db, you'd have X amount of time to restore from the slave19:05
delsol_laptopleftyfb: I'm doing a bunch of DB replication with mariadb... but never time-delayed it.19:07
delsol_laptopbut nightly backups and binlogs going back a week gives you some options....19:08
leftyfbthat's fine for hardware or network redundancy. Not as any sort of backup though19:08
ash_worksileftyfb: using an archive rather than a dump file is going to be faster19:08
leftyfbash_worksi: and doesn't always work the way you think it does19:08
delsol_laptopleftyfb: yeah, replication isn't a backup, and backups aren't replication19:09
delsol_laptopbut with a bit of both, you should be able to cover your bases pretty well....19:09
ash_worksileftyfb: yes, well, at least we have a standby for those occasions19:09
leftyfbash_worksi: unless you turn off the db backup the files, they won't all be in sync19:09
leftyfb"turn off the db TO backup the files"19:09
ash_worksileftyfb: postgres has a workflow to produce archives in an uninterupted manner19:10
leftyfbit takes time to copy files, while that is happening, some of those files are still updating, creating discrepancies19:10
ash_worksiits WAL archiving19:10
leftyfbash_worksi: you'd have to lock or turn off the db19:10
pragmaticenigmaNo idea why companies do not replicate their DBs across multiple instances... 1 Live, 1 Readonly, 1 for Reports, and 1 as Backup. If Live ever goes down, there are three others to keep the company afloat19:10
delsol_laptopleftyfb: right, but thats why you don't just grab the files.... but instead use the tools your DB provides.19:11
ash_worksileftyfb: you start with a base_backup, then the archive_command in the setting will push changes to your backup in WAL segments19:11
delsol_laptopmysqldump --single-transaction19:11
delsol_laptopand keep the binlog location at that point.19:12
leftyfbright, same thing with the bin files in mysql19:12
ash_worksileftyfb: there are also settings for PITR to help with "oops" at a certain time crap, it just requires more storage19:12
leftyfba dump is still cleaner and guaranteed19:12
delsol_laptopleftyfb: only guaranteed if you remember to tail it....19:13
ash_worksidelsol_laptop: tail it?19:13
leftyfbyou mean lock the db and then do the dump :)19:13
leftyfbthat's what I used to do19:13
delsol_laptopash_worksi: mysqldump --single-transaction database > data.sql19:13
delsol_laptoptail data.sql19:14
delsol_laptoplook for the "-- Dump completed on 2024-05-03 12:42:32"19:14
ash_worksidelsol_laptop: but why?19:14
delsol_laptopor whatever the timestamp is.19:14
delsol_laptopBecause if it doesn't say dump completed, you don't have any guarantee the dump actually completed.19:14
delsol_laptopit could have bomb-dropped out of the operation 12 tables in...19:14
ash_worksioh19:14
ash_worksitil19:14
leftyfbthat's what exit codes are for19:15
leftyfbthe backup script makes sure the dump succeeded19:15
leftyfbbefore moving onto copying off the dump19:15
leftyfbI've never had it die part way though19:15
delsol_laptopleftyfb: seemed to be more common with mysql 5+ years ago...... less common with mariadb.19:16
delsol_laptopstill happens occasionally.19:16
leftyfbdelsol_laptop: it was over 10 years ago I was doing that lol19:16
delsol_laptopI've got 100+ machines out there doing a dump every morning at 5am19:17
ash_worksiI mean, maybe it's prudent to setup dumps also... in the event that an archive doesn't work; though I would hope that would still be possible from the standby (ie, dump and restore the standby)... though things get hairy, if I have to wait for 2 days, I'm sure there'd be a lot of changes. I guess I could promote the standby and reverse the roles in that case....19:17
delsol_laptopI get notification if/when they don't backup properly or don't finish ir right...19:17
leftyfbalso did mysql replication for an access control system where each door had a pi on it with a slaved db from the server. In case of a power or network outage, the doors still worked (PoE was on UPS)19:17
delsol_laptopAlso, file corruption can totally hose your ability to dump.19:18
delsol_laptopbut an on-site replication to a separate machine..... sidesteps that since it just read the binfiles when it happened... and thus the odds of same file corrupting in same way at same time is effectively zero.19:18
leftyfbash_worksi: in the end, you could probably still use pgbackrest, but by only loosely following it's documentation and not doing stupid things like ssh'ing as the postgres or root users and not sticking ssh keys in /var/lib/postgresql/19:20
windows11niggger need help on how to uninstall ubunto19:20
LuckyManwindows11niggger, easy way, insert a usb disk with windows and overwrite everything19:22
leftyfbLuckyMan: lets not encourage them19:22
LuckyManleftyfb, ok19:22
LuckyMansorry19:22
windows11nigggersend me usb over postal code19:22
ash_worksiLuckyMan: my only experience with OS+USB is ubuntu live19:23
windows11nigggeretcher doesnt work19:23
ash_worksiLuckyMan: yes, plz snail mail them a usb drive19:23
ash_worksiXD19:23
delsol_laptop......19:24
* delsol_laptop points at windows11n's racist and offensive as fuck name.19:24
leftyfbdelsol_laptop: lets just ignore them please19:24
windows11nigggergeorge soros paid me 500 bucks19:24
windows11nigggeryou can't blame honest work19:25
ash_worksileftyfb: btw, did my version of that `(echo ...` command make things more comprehensible overall?19:25
leftyfbash_worksi: can you login to both servers via ssh?19:26
windows11niggger+ i'm jewish nigggggerino i work for google19:26
windows11nigggerbring over your wife19:26
windows11nigggerfuck linux19:27
leftyfbash_worksi: just sudo su and write out the public ssh key as needed then change the permissions on it. Or follow my advice above and use ssh-copy-id and then disable PasswordAuthentication. Either way19:27
ash_worksileftyfb: I meant, did it help to see me write `key=$(ssh admin@pg-primary cat /path/to/accessible/key); printf 'no-agent-forwarding,...command="/usr/bin/pgbackrest ..." %s' "$key" >>19:28
ash_worksigr19:28
ash_worksileftyfb: I meant, did it help to see me write `key=$(ssh admin@pg-primary cat /path/to/accessible/key); printf 'no-agent-forwarding,...command="/usr/bin/pgbackrest ..." %s' "$key" >> .ssh/authorized_keys`19:28
ash_worksiI thought maybe it clarified what they're trying to have you do19:29
leftyfbash_worksi: is this server publicly accessible?19:30
ash_worksineither is; I have to connect to a vpn19:30
leftyfbash_worksi: honestly, for some reason you seem to prefer doing things in a very convoluted way. I prefer to keep things simple and do the quick and dirty work quick and dirty and not spend an hour going over 3 different ways to copy ssh keys19:32
PjoffHey! Trying to mount my secondary disk in ubuntu but getting "error mounting, wrong fs type, bad option, bad superblock etc20:51
oemrc.irc-hispano.org20:52
leftyfbPjoff: what command did you use to try to mount it? What filesystem should it be?20:54
PjoffJust used the gui and tried to mount it20:57
Pjoffhttps://dpaste.com/48RAY2FE320:59
JanCI assume you want to mount /dev/nvme1n1p3 ?21:01
leftyfbPjoff: what command did you use to try to mount it?21:02
leftyfboh right, the gui21:02
JanCGUI, so just click on it I suppose21:02
leftyfbwhich one were you trying to mount?21:02
PjoffThe 2TB one21:03
JanCoh21:03
Pjoff-> /dev/nvme0n121:03
leftyfbthat's 16M21:03
leftyfbyou mean nvme0n1p2 ?21:03
PjoffOh yeah. But its a 2TB disk, so I assumed it was the same hah21:04
leftyfbit's not the same21:04
PjoffYeah, must be that one21:04
JanCthere is a Windows filesystem & a linux filesystem on that disk21:04
PjoffIn windows my files are there, but for some reason it wount mount in ubuntu21:04
leftyfbPjoff: I would recommend putting this drive into a windows computer and running chkdsk /f /r /x on the partition, reboot and then do it again. Then power down completely and then you can try to mount it on your linux OS21:05
leftyfbsorry, run chkdsk /f /r /x, reboot, run chkdsk /f /r /x reboot, then power down21:05
JanCyou can probably do that from the GUI too  :)21:05
leftyfbfrom within Windows21:05
PjoffIsn't that the process which takes hours ?21:06
leftyfbnot linux21:06
leftyfbPjoff: it might. Depends on a lot of factors. Either way, that would be my next step21:06
oerheksmaybe fastboot keeps control over that disk21:06
leftyfbthat's also another possibility21:06
PjoffWill try to boot into windows and turn off fastboot21:06
Pjoffand do the chkdsk thing21:07
JanCBTW: you boot linux from that disk (but not from that filesystem)?21:07
PjoffYes21:08
=== y0sh- is now known as y0sh_
PjoffHey! Turning off fastboot did the trick guys. Thanks for the help :)21:16
oerhekshave fun!21:16
SwollenBernardhow is the new ubuntu lts22:02
NeilRGI like it22:18
NeilRGfixed the screen tearing, latency I was getting with VLC22:19
younder(org.shirakumo.machine-state:gc-room)22:30
=== guiverc2 is now known as guiverc
=== Maxpm5 is now known as Maxpm
=== trekkie1701c_ is now known as trekkie1701c
=== Fischer4 is now known as Fischer
=== kelvium_ is now known as kelvium
=== GenericPlayer18 is now known as GenericPlayer1
=== djhankb6 is now known as djhankb
=== ice9_ is now known as ice9
=== realivanjx9 is now known as realivanjx
=== p3lim3 is now known as p3lim
=== mcphail0 is now known as mcphail
=== din000 is now known as din0
=== ryan-c` is now known as ryan-c
=== andymandias_ is now known as andymandias
=== someperson is now known as Some_Person
=== rat2 is now known as roadkill
uzzIs it possible to make a launchpad account without making an ubuntu one account?23:22
sarnolduzz: not in any useful way, no23:36
=== JoeBk_ is now known as JoeBk
=== fastidio1 is now known as fastidious

Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!