[02:32] <braves68> hello?
[02:33] <enigma9o7[m]> Hello braves68, welcome to Ubuntu's support channel on the libera chat network of Internet Relay Chat.
[02:33] <enigma9o7[m]> It is such a pleasure to have you here with us tonight, and if there are any ubuntu related questions you may have, please feel free to share.
[02:39] <braves68> thanks.  just installed 22.04 server and loaded the cinnamon desktop.  I have an ultrawide monitor.  Is it possible to get 2560 x 1080
[02:40] <enigma9o7[m]> I would think so, if your gpu drivers support it.  What happens when you try to set it?
[02:41] <braves68> i have a raspberry pi 400... so definitely pushing it :)
[02:42] <enigma9o7[m]> perhaps.  does it list it in the menu?  I'm not a cinnamin expert but if you cant find it just search for 'display' from your start menu.
[02:42] <enigma9o7[m]> If it doesnt list that resolution, you can try to set it from command line, assuming x11 then `xrandr -s 2560x1080` might work
[03:47] <tronic> sdy
[03:50] <oerheks> sdY means your target disk you want to move in. Please use "mount" or try to bing to know your sdX label of your system.
[04:35] <user|9> anyone can help me to fix my audio on my laptop? im sure its a hardware issue
[04:48] <deego> user|9: if you figure it out, let me know as well. My audio keeps dying randomly. What's your issue?
[04:50] <user|9> my audio is not working, i think is missing drivers or is not supported for my hardware
[06:28] <no_gravity> Hello! Often when I want to start a new Firefox window via the command line by typing "firefox<enter>" I get "Firefox is already running, but is not responding. To use Firefox, you must first close the existing Firefox process, restart your device, or use a different profile.". Why is that?
[06:52] <imi> hi, update-manager updated a package. can I somehow get a log from this package update? which deb file was downloaded from where, etc
[07:06] <bare_kz> Hello!
[07:07] <xeno33456653466> Hi
[07:15] <imi> hi, update-manager updated a package. can I somehow get a log from this package update? which deb file was downloaded from where, etc
[08:18] <guiverc> imi, /var/log/apt/history.log will contain the log of package upgrades/installs/removes etc... your sources are where it's from; so `apt-cache policy` etc can tell you where it'll come from if not already known
[08:26] <imi> guiverc: thanks
[08:26] <imi> how do I clean /var/cache/apt/archives from multiple (obsolete) versions of packages?
[08:28] <sagex_> does anyone experience resetting KDE wm applets for multiple monitors/resolutions thanks
[08:51] <julia-notbook> hallo
[08:52] <julia-notbook> hallo ist hier jemand
[09:00] <JerOfPanic> hi
[09:02] <saltd> hi
[09:48] <bobdobbs> Hi all. I'm a webdev, and I know just enough about mysql to install mariadb server locally. I run apache in order to work locally on (mostly) wordpress sites. A couple of hours ago mariadb server just stopped working.
[09:48] <bobdobbs> I tried to restart it. It wouldn't restart
[09:49] <bobdobbs> 'service mariadb status' returns this: https://hastebin.com/puzuhupexi.sql
[09:49] <bobdobbs> Now, I remember facing this issue previously. Maybe about a year ago. The only solution that worked at the time was to completely purge mariadb and reinstall it.
[09:49] <bobdobbs> But now I've got a bunch of databases installed. I don't want to have to reinstall
[09:51] <bobdobbs> When I google for the errors that show in this message, I see a few different fixes. The main one is the removal of couple of files in /var/mysql/lib. I've removed those files but the server startup still fails with the same error
[09:51] <bobdobbs> I'm running ubuntu 22.04
[09:52] <ravage> bobdobbs, try to remove /var/lib/mysql/ib_logfile* and check if the database starts again
[09:52] <ravage> in general mariadb does not just stop working
[09:53] <ravage> do you have enough free disk space and do you shut down the DB correctly?
[09:53] <bobdobbs> ravage: yeah, that's one of the files that various posts I discovered said that I should remove. I moved it to a backup folder. But starting the mariadb server still fails with the same error
[09:53] <bobdobbs> I do have plenty of disk space
[09:54] <bobdobbs> I don't usually manually shut down the db manually. It goes up and down with the system.
[09:54] <ravage> what about ram?
[09:55] <bobdobbs> The last time I had this issue it came out of nowhere as well, as far as I recall. I don't remember improperly shutting down the server.
[09:56] <bobdobbs> I should be good with ram. I think I've got 64GB RAM on this system, and all I'm running is chrome, emacs and a terminal basically.
[09:57] <bobdobbs> 'free -h' tells me that I've got 53G of RAM free
[09:57] <ravage> do you use any special storage for your database?
[09:57] <ravage> zfs or any other special filesystem?
[09:58] <bobdobbs> ravage: also, I can remove ib_logfile0. But whenever I attempt to restart the server, the restart fails and that file pops back into existence
[09:59] <bobdobbs> hmm... I'm not even sure what 'special storage' means. As far as I can recall I didn't depart from vanilla options when installing this system. (apart from setting it up to dual boot. It doubles as a windows gaming machine)
[09:59] <bobdobbs> I definitely didn't do anything special when installing maria
[10:00] <bobdobbs> Is there a way I can purge it and reinstall it, while keeping the databases?
[10:04] <ravage> purge for sure. but to get your data you need to start the server and do a backup first
[10:05] <bobdobbs> backing up now
[10:06] <ravage> what exactly are you backing up? :)
[10:06] <bobdobbs> ravage 'cp -r /var/lib/mysql ~/bk/db'
[10:07] <ravage> ok. that is a good idea. but it would be better to get a sql dump
[10:07] <ravage> you can try "innodb_force_recovery=1" in your mariadb config
[10:07] <ravage> and see if it starts up after you did the backup of the files
[10:08] <bobdobbs> I don't know how to dump each database. I've tried before and failed. I can do it with an individual database. But I'm not good enough at scripting to figure out how to dump every file.
[10:08] <bobdobbs> I could figure it out, but it would take days. And I really just need to get on with work.
[10:09] <bobdobbs> I honestly hate it when an actual critical software component just... falls over and dies in the middle of a work cycle
[10:09] <bobdobbs> Which conf file should that option go it? my.cnf?
[10:10] <bobdobbs> ooooh. Backing up 17G of databases  using that cp command was really fast. Thank Gad for SSD drives.
[10:10] <ravage> should be /etc/mysql/mariadb.conf.d/50-server.cnf
[10:10] <bobdobbs> ta
[10:12] <bobdobbs> Should it go anywhere in particular in that file? Or should I just try pasting it at the bottom?
[10:13] <ravage> look for anything that already starts with innodb
[10:13] <bobdobbs> ok, I pasted in at the bottom and restarted. Restart failed. Error persists.
[10:14] <ravage> is it the exact same error?
[10:14] <bobdobbs> yes
[10:15] <ravage> you can try a value of 4 or 5
[10:16] <ravage> that would start it in read-only mode
[10:16] <ravage> if that works you could still do a dump
[10:16] <bobdobbs> omg. One of the green-ticked stackoverflow responses to this issue says to 'rm -rf /var/lib/mysql'. That would wipe all databases.
[10:16] <ravage> that is correct
[10:16] <ravage> it "solves" the problem with the startup :P
[10:17] <bobdobbs> "... and now you have two problems..."
[10:18] <ravage> so you can remove the logfiles again and test higher values of the recovery parameter
[10:18] <bobdobbs> ok. I passed in '5' and 'service mysqld restart' just returns without messages to the console...
[10:18] <bobdobbs> k, mariadb now running
[10:19] <ravage> it is possible that is does not fork to the background in that mode yes
[10:19] <bobdobbs> geez. you really know your stuff
[10:19] <bobdobbs> k, I was able to open a local wordpress site
[10:20] <bobdobbs> So the server is in read only mode, you say?
[10:20] <ravage> yes
[10:20] <ravage> i think writing is not a good idea
[10:20] <ravage> i would get a full backup now and reinstall the databases then
[10:20] <bobdobbs> Honestly, how do you guys learn all this stuff? It's incredible.
[10:20] <ravage> 25 years of being a sysadmin helps :)
[10:20] <bobdobbs> wizardy
[10:20] <bobdobbs> *wizardry
[10:21] <ravage> lets do the backup
[10:22] <ravage> how many dbs are we talking about?
[10:22] <bobdobbs> wouldn't the copy operation have done that already? I copied everything from /var/lib/mysql
[10:22] <bobdobbs> dozens
[10:22] <ravage> you copied the damaged stage yes
[10:22] <ravage> *state
[10:22] <bobdobbs> ah, ok
[10:22] <ravage> sudo mysqldump -u root --all-databases --quick --lock-tables=false /root/alldbs.sql
[10:22] <ravage> does that do anything?
[10:22]  * bobdobbs digests...
[10:23] <ravage> oh
[10:23] <bobdobbs> before I run that command, what does it do exactly? I know 'mysqldump' from dumping individual databases.
[10:23] <ravage> sudo mysqldump -u root --all-databases --quick --lock-tables=false > /root/alldbs.sql
[10:23] <ravage> more like that
[10:23] <ravage> it should dump all your databases into one .sql file
[10:23] <bobdobbs> wow
[10:23] <bobdobbs> k, will do...
[10:25] <bobdobbs> "mysql: unknown option '--all-databases' "
[10:25] <ravage> did you write mysqldump? or mysql?
[10:25] <bobdobbs> oh, whoops
[10:26] <bobdobbs> ok, it stopped running with an error...
[10:26] <ravage> what error?
[10:26] <bobdobbs> https://hastebin.com/aberaxaqic.lua
[10:26] <bobdobbs> Honestly, I could just delete that particular database. I don't think I've touched it for five years
[10:27] <bobdobbs> I'll delete that database and try that command again
[10:28] <bobdobbs> lol. I can't delete it, cos mysql is running in read-only mdoe
[10:28] <bobdobbs> *mode
[10:28] <ravage> a backup for every db is better anyway
[10:28] <ravage> so do a "show databases;"
[10:28] <ravage> writ down the ones you need to backup
[10:29] <bobdobbs> aw man. There's way too many to do that manually
[10:29] <ravage> you can copy paste it in a notepad
[10:30] <ravage> but
[10:30] <ravage> you can add "-f" to the command
[10:30] <bobdobbs> It'd take an hour or more. I don't think you'd be around by the time I'm finished
[10:30] <ravage> that should continue on errors
[10:32] <bobdobbs> ok, trying that
[10:33] <bobdobbs> ok, that's running. It's output a bunch of errors related to that one particular db, but keeps running. Which is fine. I don't need that one pesky db.
[10:33] <ravage> ok. let it run. that will take a while
[10:33] <ravage> and we will see what comes out of the restore then
[10:34] <ravage> after the backup we can reset the database server and do the restore
[10:34] <ravage> you still have the backup of /var/lib/mysql so that is safe to do then
[10:35] <bobdobbs> k, it's finished running. I'm just gonna copy those terminal errors to a file. Might be useful to reference...
[10:35] <ravage> that was almost too fast
[10:35] <ravage> can you check the size of that sql file?
[10:35] <ravage> ls -alh  /root/alldbs.sql
[10:36] <bobdobbs> 5.2GB
[10:36] <ravage> fast system then :)
[10:36] <bobdobbs> Yeah, I dumped a lot of cash into this system. I wanted to have a proper modern gaming rig for once in my life.
[10:37] <bobdobbs> When I boot into windows, it runs Shadow Of War sooooo smoothly
[10:37] <bobdobbs> of course I am now living on ramen
[10:38] <ravage> :)
[10:38] <bobdobbs> ok, I've copied the errors. now what was the next step? Copying the data directory again?
[10:38] <ravage> ok so now lets purge that mariadb and restore the backup
[10:38] <ravage> stop the server first
[10:39] <ravage> ctrl-c may be enough for that if it still rund in foreground
[10:39] <ravage> *runs
[10:39] <bobdobbs> kk
[10:40] <bobdobbs> mariadb now stopped
[10:41] <ravage> https://p.haxxors.com/na5pxgsx.txt
[10:41] <bobdobbs> ok
[10:42] <bobdobbs> wait.. wouldn't an 'apt-purge' delete the contents of /var/lib/mysql?
[10:42] <bobdobbs> not that it matters anyway... I've got it all backed up twice
[10:42] <ravage> right
[10:42] <bobdobbs> so... I might as well push the big red button
[10:43] <bobdobbs> ah, I see. I misread the commands.
[10:45] <ravage> you should have an empty but running database server after that
[10:45] <bobdobbs> oh no :(
[10:45] <ravage> ?
[10:45] <bobdobbs> after purging, re-installing and restarting... I have exactly the same error
[10:46] <ravage> there must be something wrong with that system
[10:46] <bobdobbs> oh wait. I know why
[10:46] <ravage> ok?
[10:46] <bobdobbs> I didn't follow those instructions exactly, and I left the /var/lib/mysql directory
[10:46] <bobdobbs> sorry
[10:46] <bobdobbs> I'll go through those steps again
[10:49] <bobdobbs> ok. I've purged and reinstalled. The directories /var/lib/mysql and /etc/mysql no longer exist. After purging and reinstalling, the server doesn't start. Fails with a different error...
[10:50] <ravage> what error?
[10:50] <bobdobbs> https://hastebin.com/aretedayar.yaml
[10:51] <bobdobbs> line 19 is the interesting line, I think. 'faustina' is the hostname.
[10:51] <ravage> ok. it should have created that directory. but we can do that manually
[10:51] <bobdobbs> oh, of course
[10:51] <ravage> sudo mkdir /var/lib/mysql; sudo chown mysql:mysql /var/lib/mysql
[10:52] <bobdobbs> done. But... how certain are we with the 'mysql:mysql' bit? Is that the standard ubuntu owner?
[10:52] <bobdobbs> just wondering
[10:52] <ravage> it should be the mysql user the database runs on yes
[10:52] <bobdobbs> kk
[10:52] <ravage> do you have a new /etc/mysql folder?
[10:53] <bobdobbs> k. We are getting somewhere. New error: https://hastebin.com/uvozumexij.yaml
[10:53] <bobdobbs> heh. no. I haven't created it.
[10:53] <ravage> ok lets try this again
[10:54] <bobdobbs> ok.
[10:54] <ravage> sudo apt remove --purge mariadb-common mariadb-server
[10:55] <ravage> i hope that will remove a little more
[10:55] <bobdobbs> k. stopping the server first...
[10:55] <ravage> i dont think its running but ok :)
[10:55] <bobdobbs> oh yeah. duh.
[10:56] <bobdobbs> yeah. "148MB disk space will be freed". That's more than last time.
[10:56] <ravage> ok remove the packages
[10:56] <bobdobbs> more output from that command too
[10:56] <ravage> now lets remove that datadir again and reinstall
[10:57] <ravage> sudo rm -rf /var/lib/mysql
[10:57] <ravage> sudo apt install mariadb-server mariadb-client
[10:58] <bobdobbs> done
[10:58] <bobdobbs> no errors or nuffin
[10:58] <ravage> sounds good
[10:59] <ravage> sudo systemctl status mariadb-server
[10:59] <ravage> shows active running?
[10:59] <bobdobbs> 'service mysql status' returns an error. I'll pastebin it...
[10:59] <bobdobbs> https://hastebin.com/ebuqacejoh.yaml
[10:59] <ravage> you really should not use service anymore :)
[11:00] <bobdobbs> geez. When the db fell over, it really fell over hard
[11:00] <bobdobbs> what should I be using?
[11:00] <ravage> its ok for now
[11:00] <ravage> that is a funny error
[11:00] <ravage> one moment
[11:01] <ravage> does /etc/mysql exist now?
[11:02] <bobdobbs> yes
[11:02] <ravage> is there a /etc/mysql/my.cnf file?
[11:03] <bobdobbs> yes
[11:03] <ravage> ca you paste the content?
[11:04] <saltd> yes
[11:04] <bobdobbs> https://hastebin.com/ijejayazuc.shell
[11:06] <ravage> and does /etc/mysql/mariadb.conf.d/50-server.cnf exist?
[11:07] <bobdobbs> yup
[11:07] <ravage> this is really strange. try "sudo chown -R mysql:mysql /etc/mysql"
[11:07] <ravage> and restart the service
[11:07] <bobdobbs> kk
[11:08] <bobdobbs> restart fails
[11:08] <bobdobbs> checking error...
[11:08] <ravage> i will setup a 22.04 container and test a clean install
[11:08] <bobdobbs> same as that last error https://hastebin.com/marudeyuvo.apache
[11:08] <bobdobbs> :(
[11:09] <bobdobbs> aw, no way. It's already 11pm here. Surely there's a way to just purge everything and set it up from scratch
[11:09] <ravage> thats what we did really
[11:09] <ravage> 1 sec
[11:12] <ravage> sudo apt remove --purge libmariadb3:amd64 mariadb-client mariadb-client-10.6 mariadb-client-core-10.6 mariadb-common mariadb-server mariadb-server-10.6 mariadb-server-core-10.6
[11:12] <ravage> it should ask you to remove all databases. answer yes
[11:13] <bobdobbs> nuking from orbit...
[11:13] <bobdobbs> k, that has run
[11:13] <ravage> sudo rm -rf /etc/mysql/ /var/lib/mysql
[11:13] <ravage> heh
[11:14] <ravage> i get the same error. that is kind of good
[11:14] <bobdobbs> it's the only way to be sure
[11:14] <ravage> now i can fix it and tell you how :D
[11:14] <bobdobbs> heh
[11:14] <bobdobbs> I hope I don't end up inadvertantly dragging you into the quicksand
[11:14] <bobdobbs> brb, grabbing an instant coffee. Should be back in two or three minutes
[11:17] <bobdobbs> back
[11:17] <ravage> https://p.haxxors.com/7qiscwcw.txt
[11:18] <bobdobbs> kk
[11:19] <ravage> all that should not really be needed after a purge. i will try to see if that happens on debian too or 20.04
[11:19] <bobdobbs> That first command fails: "no such file or directory"
[11:19] <ravage> ok what does the second do?
[11:20] <bobdobbs> returns a long message with instructions... looking at it now
[11:20] <ravage> should show "Installing MariaDB/MySQL system tables in '/var/lib/mysql' ..." and then 2 lines later "OK"?
[11:20] <ravage> or is there an error?
[11:21] <bobdobbs> No errors. It returns the message you are indicating
[11:21] <ravage> ok then do the rest of the commands
[11:21] <bobdobbs> kk
[11:22] <bobdobbs> for the chown command: "invalid user: `mysql:mysql'"
[11:22] <ravage> what the hell :D
[11:22] <bobdobbs> looks like I no longer have that user on my system
[11:22] <bobdobbs> I swear, I haven't done anythign funky!
[11:24] <ravage> sudo id mysql
[11:24] <ravage> does that return anything?
[11:24] <bobdobbs> "id: 'mysql' no such user"
[11:25] <bobdobbs> no such user in /etc/passwd either
[11:25] <ravage> cat you show the output of "dpkg -l|grep mariadb" ?
[11:26] <bobdobbs> https://hastebin.com/ejijiceqex.apache
[11:26] <ravage> ok
[11:26] <ravage> that is not a lot
[11:26] <bobdobbs> I'm not sure what it is, tbh
[11:26] <ravage> sudo apt install mariadb-client-10.6 mariadb-client-core-10.6 mariadb-common mariadb-server mariadb-server-10.6 mariadb-server-core-10.6
[11:27] <bobdobbs> running...
[11:28] <bobdobbs> k, that completes with, uhm, warnings I think. Not errors. pastebinning...
[11:28] <bobdobbs> https://hastebin.com/emiholipil.sql
[11:29] <ravage> i think you had a linebreak somewhere
[11:29] <ravage> you missed some packages
[11:29] <bobdobbs> ah, yes. whoops. sorry
[11:29] <ravage> sudo apt install mariadb-server mariadb-server-10.6 mariadb-server-core-10.6
[11:29] <ravage> that should fix it
[11:30] <ravage> maybe you missed some before already :)
[11:30] <bobdobbs> k, that returns with no errors or warnings
[11:30] <bobdobbs> gawd, coffee is good
[11:30] <bobdobbs> WAYHAY!
[11:30] <ravage> ok does your server run my any chance now?
[11:31] <bobdobbs> I now have a running server!!
[11:31] <ravage> good :)
[11:31] <ravage> now lets just try
[11:31] <ravage> sudo mysql -u root < /root/alldbs.sql
[11:31] <bobdobbs> I'll pastebin the status output...
[11:31] <bobdobbs> https://hastebin.com/ociyakoqer.yaml
[11:31] <bobdobbs> that looks fine
[11:32] <bobdobbs> k, now where did I put my pesky backups...
[11:33] <bobdobbs> k, running that command
[11:33] <ravage> if it hangs for a while thats a good sign
[11:34] <bobdobbs> yup, hanging for a bit. I guess the db's are all being "shelved"
[11:34] <bobdobbs> bad metaphor, but you get what I mean
[11:35] <bobdobbs> oh, hit an error...
[11:35] <ravage> does it continue?
[11:35] <bobdobbs> https://hastebin.com/canamifuxi.apache
[11:36] <bobdobbs> no, it didn't continue
[11:36] <ravage> thy again with -f
[11:36] <bobdobbs> kk
[11:36] <bobdobbs> running
[11:38] <bobdobbs> ravage: btw, thank you so much for helping me with this. This is Deep Magic to me.
[11:39] <bobdobbs> I mean, I know just enough sysadmin stuff to get a db server running. But this stuff is freeky deeky
[11:39] <ravage> no problem. slow sunday here. nothing else to do :D
[11:41] <bobdobbs> I'm getting a few errors for another old db that I haven't accessed for years
[11:42] <ravage> did you upgrade that system to 22.04 from older versions over time?
[11:43] <ravage> it looks like there are some really old databases that did not get all the migrations needed for newer mysql server versions
[11:43] <bobdobbs> Huh. I just figured out how old that db is by googling. It was for the website for this play: https://www.nytimes.com/2015/10/13/theater/review-clever-little-lies-a-throwback-to-1960s-broadway.html
[11:43] <bobdobbs> ravage: no. It was a fresh install
[11:43] <ravage> and how did you migrate the databases?
[11:45] <bobdobbs> I had a new PC built for me. I transfered over the HD from my old system. My new system has an SSD. I mounted the drive and copied over the contents of /var/lib/mysql
[11:46] <ravage> uh ok
[11:46] <ravage> that may have caused trouble indeed
[11:46] <bobdobbs> Maybe. But its been working fine for months.
[11:47] <bobdobbs> Although I did have an issue shortly after I copied the db's over, and had to purge/reinstall mariadb
[11:47] <mythacker> anyone online?
[11:48] <lotuspsychje> !ask | mythacker
[11:48] <mythacker> !ask What is this hexchat?
[11:49] <lotuspsychje> mythacker: you joined the ubuntu support channel
[11:49] <lotuspsychje> mythacker: you can aks ubuntu related questions in here, and volunteers will try to help you
[11:50] <mythacker> !ask Is there any driver for AMD APU in Ubuntu?
[11:50] <mythacker> !help
[11:50] <mythacker> !patience
[11:55] <bobdobbs> ravage: how did you acquire your db skills?
[11:56] <ravage> i dont have any DB specific certificates. just practice over the decades really
[11:57] <mythacker> hey ravage
[11:58] <mythacker> can anyone see my messages?
[11:58] <bobdobbs> ravage: I've got this theory that it's pretty much impossible to read all the documentation that one needs in order to be a competent linux sysadmin. There's a level at which much of the necessary knowledge is just lore: basically shared by the internet version of word-of-mouth
[11:58] <bobdobbs> ravage: in other words, we already live in the 40k universe
[12:01] <ravage> did your command finish? or still running?
[12:01] <bobdobbs> ravage: still running
[12:07] <bobdobbs> ravage: the command finished running
[12:08] <ravage> ok
[12:08] <ravage> check if you can find anything useful on your phpmyadmin
[12:08] <bobdobbs> ooooh....
[12:08] <ravage> or check first if you can even login :)
[12:08] <bobdobbs> I don't have phpmyadmin installed. But one of my wp site is working
[12:09] <ravage> that is a good sign
[12:09] <bobdobbs> ravage: at the terminal, this works for the system root user: 'mysql -uroot -proot'
[12:09] <bobdobbs> 'show databases' works
[12:10] <bobdobbs> For the non-root user, I can also log in to mysql from the command line, using that same command
[12:10] <bobdobbs> so... it all looks good so far
[12:11] <ravage> im sure some of the old databases will have some missing data
[12:11] <ravage> maybe a good oppotunity to drop them :)
[12:11] <bobdobbs> Yeah, that's probably fine.
[12:12] <bobdobbs> The only warnings I got where from that old db. Which I can infer from the NYT article date is now about seven years old.
[12:14] <BluesKaj> Hi all
[12:16] <saltd> POPF
[12:17] <bobdobbs> ravage: thanks for your help. It's after midnight, Sunday here. So early Monday morning. I very much appreciate your help. I would have been utterly distressed without it.
[12:18] <ravage> you're welcome. its 2pm on sunday here. you better get some sleep :)
[12:18] <bobdobbs> :)
[12:20] <ravage> oh. and maybe cleanup those /var/lib/mysql.bak and /etc/mysql.bak dirs
[12:20] <ravage> you dont need those anymore
[12:20] <bobdobbs> kk
[12:25] <taholmes160> Hi folks -- i installed the XRDP and set it up as far as I can tell correctly, when I try to connect from my windows machine, I get a light blue screen with an Xrdp login screen, when I log in with the correct username and password, it disconnects
[12:25] <taholmes160> https://imgur.com/B8W7cMF
[12:26] <taholmes160> Can someone please point me in the right direction
[12:31] <agoodm> Is there some way to specify a default audio device when its available?  I've got a USB dock which connects two audio outputs and it *always* chooses the wrong one.
[12:31] <agoodm> I used to connect the USB devices so that the one it usually chose was correct, but thats no longer possible.
[12:42] <ravage> agoodm, https://extensions.gnome.org/extension/906/sound-output-device-chooser/ makes it easiert to switch
[12:43] <agoodm> thanks ravage; no way to automate it?
[12:43] <tomreyn> you can also set a default output sink https://wiki.archlinux.org/title/PulseAudio/Examples#Set_the_default_output_sink
[12:44] <agoodm> does that survive the output sync going away and reappearing?
[12:45] <tomreyn> the configuration file will prevail, i'm not sure how pulseaudio handles the situation where the default output sink disappears, i assume it falls back to another.
[12:48] <tomreyn> apparently you can also assign priorities to specific sinks https://superuser.com/questions/1026619/how-to-change-the-sink-priority-in-pulseaudio
[12:59] <agoodm_> tomreyn, so setting default in the config file doesnt seem to help - it still switches to the most recently connected device
[13:00] <ioria> agoodm_, try to run pactl set-default-sink -device-in at startup
[13:00] <agoodm_> Its not useful though... I donnect usb hub with multiple audio sources and every time I end up with a randomly selected output device, presumably the last to connect...
[13:01] <tomreyn> try priorities then
[13:01] <agoodm_> to be fair same issue in windows, but it feels like there should be a solution other than manually choosing the right output every time I plug into the dock
[13:02] <agoodm_> https://gitlab.freedesktop.org/pulseaudio/pulseaudio/-/issues/885 are priorities even implemented yet?
[13:02] <ioria> agoodm_, does 'pactl list short sinks' list your desired device ?
[13:03] <agoodm_> sort of alsa_output.usb-Yoyodyne_Consulting_ODAC-revB-01.analog-stereo - would prefer the spdif version?
[13:05] <tomreyn> agoodm_: looks like you already know more than i do regarding priorities.
[13:05] <agoodm_> haha I didnt know about priorities till you mentioned, but I cant see any way to set a priority...
[13:07] <tomreyn> as you pointed out, priorities are only used internally by PA and not user configurable.
[13:07] <root___> hi
[13:07] <Minor723> Anyone know why when i run this/ "sudo systemctl --user status minecraft.service" I get this. "Failed to connect to bus: $DBUS_SESSION_BUS_ADDRESS and $XDG_RUNTIME_DIR not defined (consider using --machine=<user>@.host --user to connect to bus of other user)"
[13:09] <tomreyn> Minor723: run it as the very user and without sudo
[13:10] <tomreyn> (or specify the target user via sudo -u <targetuser>)
[13:10] <Minor723> tomreyn thank you
[13:11] <tomreyn> you're welcome
[15:03] <jcolideles> hello
[15:03] <arraybolt3[m]> 👋
[15:03] <arraybolt3[m]> Anything we can help with?
[16:48] <meandrain> hi, I am trying to install Ubuntu 20.04 in a virtual machine, and I've noticed it does not create a swap space. Why is that ?
[16:52] <meandrain> ok so I found the answer here:     https://askubuntu.com/questions/1243247/does-ubuntu-20-04-installer-skip-creating-a-swap-partition
[16:52] <EriC^^> meandrain: maybe it created /swapfile ?
[16:53] <meandrain> I did not get there, I was at "creating partition" installation step.
[17:00] <macpro> hey
[17:18] <pjs> wow, upgrading to 22.04 and snap is required for things like firefox lmfao
[17:18] <pjs> what a stupid thing
[17:19] <pjs> I removed snap before because I don't want to use it.
[17:19]  * pjs rant over, sorry
[17:26] <InPhase> pjs: It has been a disruptive downgrade in functionality for firefox, but seems to be driven by upstream choices from Firefox.  I assume it will work normally later once the kinks are worked out.
[17:28] <InPhase> pjs: You can always build a thing yourself if you really don't want to use a default standard package, but I would advise coming back to try the snap version later, perhaps after the next point release or full release.  I think it is on its way to being a new standard, and thus should start working well.
[17:32] <InPhase> I've had access control and basic functionality issues with quite a number of snap packages, which I've had to swap out with non-snap sources just to make things work.  Firefox I'm still using the standard snap because the biggest issue is the slow first start after boot, which I'm just sighing my way through for now.
[17:32] <pjs> I'll definitely switch to a new distro vs. be forced to use snapd, which I view as totally unnecessary
[17:32] <tomreyn> alternatives to firefox snap: upstream builds (which have their own upgrade path), flatpack, PPAs, third party redistributions under different branding.
[17:33] <pjs> tomreyn: yea, I'll use a ppa
[17:33] <pjs> just annoying I had to reinstall snapd during the upgrade
[17:34] <InPhase> pjs: There is a logic to snap, which is why it's being embraced.  It gives a way to release consistent builds across distributions by internal managing of dependencies.
[17:34] <InPhase> pjs: This will distribute labor much more sensibly in the future, allowing a much wider collection of packages.
[17:35] <jhutchins> It's amusing how many of the complaints about the new packaging for firefox compare with the complaints about mozilla browser in the early 90s.
[17:35] <pjs> Oh I get it, it's just not something *I* need. I see it as useful for a large chunk of users
[17:37] <gordonjcp> I like snap packages
[17:37] <gordonjcp> it's nice to see Linux finally catching up with Haiku
[17:44] <jhutchins> gordonjcp: Maybe you mean catching up with Solaris?
[17:58] <gordonjcp> jhutchins: they're more like hpkgs but yeah they're similar to Solaris packages :-)
[18:02] <appu> Hi, can someone here help me with reporting a bug?
[18:03] <jhutchins> !reportbug
[18:03] <jhutchins> Poor bot.
[18:03] <appu> !reportbug
[18:03] <jhutchins> appu: What do you need help with?
[18:04] <oerheks> !bug
[18:04] <oerheks> make sure you have a launchpad account, for feedback
[18:04] <appu> I have a bug with the elantech touchpad
[18:04] <jhutchins> appu: What did you try to do?  How did you try to do it?  What did you expect to happen?  What happened instead?
[18:06] <appu> jhutchins: Toucpad seems to drop out of touchpad mode into mouse-mode randomly. Which disables multitouch and other functions.
[18:06] <appu> What surprises me is that, a suspend and resume fixes this temporarily.
[18:06] <jhutchins> appu: Does this happen in any particular application, or when switching applications?
[18:08] <appu> jhutchins: Hmm, I startup with firefox and a few others. I should try to see if the bug happens without firefox
[18:09] <appu> But can a software cause system-wide mouse problem?
[18:11] <jhutchins> appu: If it's controlling the I/O for the mouse, sure.
[18:11] <jhutchins> appu: Have you found any other reports of problems with this hardware?
[18:11] <oxfuxxx> only if it's driver related i'd say. low level software.
[18:12] <appu> jhutchins: Elantech touchpad seems to be a very problematic in general according  to google
[18:12] <oxfuxxx> otherwise it has no access to the hw control etc.
[18:13] <oxfuxxx> Canadian mouse tech.
[18:13] <appu> Also, this was on the console during suspend/resume
[18:13] <appu> i2c_hid_acpi i2c-ELAN0504:01: i2c_hid_get_input: IRQ triggered but there's no data
[18:14] <BlackMage> hello, i cant install package libapache2-mod-php5 or libapache2-mod-php5.6 in ubuntu 22.04
[18:14] <BlackMage> or libapache2-mod-php5
[18:15] <oerheks> libapache2-mod-php5 ? that is pretty old, trusty era
[18:15] <tomreyn> BlackMage: that's because there is no such package in 22.04. there are similar packages for higher php versions, though
[18:15] <pjs> re: upgrade, I removed snap again and installed ff via ppa, weird now both versions take about 30 seconds to start and previously it was instant.
[18:16] <appu> oxfuxxx: jhutchins: I found this https://askubuntu.com/questions/1033033/elantech-touchpad-does-not-work-i2c-hid
[18:16] <appu> so going to try that.
[18:19] <jhutchins> pjs: Instant start suggests that something is pre-loaded and running in the background.
[18:23] <goddard> any way to enable a lazy style loading for nautilus?
[18:26] <goddard> with many tools it is impossible to view files with 100s of thousands of files
[18:27] <pjs> jhutchins: maybe, I've had to troubleshoot ff before and never noticed anythingand even after a reboot it was bascially instant. Not a big deal, just find it strange
[18:27] <pjs> always some little kinks after an major update so I'll work them out slowly as they annoy me enough
[18:28] <tomreyn> goddard: hundreds of thousands of files in one directory is wrong in the first place. i think this had been discussed before.
[18:30] <ogra> not sure what kind of HW you have over there, but on most systems the FF snap cold start time should be below 5sec with anything above version 101 ... if it is still slow with the current verson, there is surely a bug (for me it starts withn ~3sec on all machines here)
[18:30] <goddard> tomreyn: with AI and large datasets it is impossible to work with them using Linux tools
[18:31] <goddard> at least the standard tools
[18:31] <pjs> jhutchins: https://askubuntu.com/questions/1406263/ubuntu-22-04-runs-too-slow
[18:31] <pjs> looks like it's not just me.
[18:31] <goddard> tomreyn: also with low memory devices it makes way more sense to use lazy loading instead of the current method
[18:32] <archi> Hi all :)
[18:33] <ogra> pjs, see what i wrote above .. the slow FF startup of the snap is supposed to be fixed since several versions ... (and is working well for most people)
[18:33] <pjs> ogra: it's not just FF.. Seems anything that uses GTK takes 30 seconds+ to load (ie, just loading the bluetooth devices)
[18:34] <pjs> there is a bug filed, https://bugs.launchpad.net/ubuntu/+source/linux/+bug/1973434
[18:34] <ogra> yeah, that doesnt sound about right ...
[18:34] <ogra> (and sounds really like a systemic prob not really like a snap issues either)
[18:34] <pjs> ogra: not blaming snap, I've already removed it completely
[18:35] <pjs> I just don't want to use snap, but I removed it immediately.
[18:36] <ogra> pjs, well, that bug is a mess ...
[18:37] <ogra> it looks like originally there is an issue with nvidia and wayland there ... but the further conversation kind of goes into asome "generally slow" relam with amd users and whatnot
[18:38] <ogra> try switching to xorg though (at the login screen) ... perhaps you have a driver issue with wayland ...
[18:40] <pjs> hrmm, afaik I'm using xorg.
[18:40] <pjs> or does that change during upgrade by default?
[18:40] <pjs> just tried the work around on the bug and the issue remains..
[18:53] <varaindemian> https://usercontent.irccloud-cdn.com/file/AsCa8qwR/image.png
[18:53] <varaindemian> any idea why I get this?
[18:53] <varaindemian> on VBox
[19:09] <rfm> varaindemian, it says pre-removal script failed, I don't know why the apport dialog popped up.  what were you trying to do and how?
[19:44] <cek> I'd like to make a wifi connection available to all users, thus I check the checkbox and I'm prompted for "Administrator" password, but there's none and I've got sudo config'ed. Is this the default config or did I change something?
[19:45] <cek> oh yeah, same happens when I click "unlock" in Settings. wtf have I changed?
[19:46] <oxfuxxx> set a passwd for root/admin and use it cek. some config requires passwd to be define for root.
[19:46] <oxfuxxx> sudo su, then passwd
[19:47] <cek> that's the easiest way. But I'm sure it had worked without asking for root pw (or was asking just for my user's pw)
[19:47] <cek> something has changed as I remember root not having any password since day 1
[19:49] <oxfuxxx> you should add a pass anyway in case a female would try to rape your hard drive anyway.
[19:49] <oxfuxxx> good lux ;]
[20:00] <cek> what?! anyway, can be solved by adding the user to `sudo` or `admin` group.
[21:13] <tripp4h> i keep getting 404 error when trying to install or remove programs in ubuntu, something's broken... https://paste.ubuntu.com/p/fWHfHtg968/
[21:14] <Habbie> tripp4h, did you type 'apt-get update' recently?
[21:17] <oerheks> Habbie, +1 most common cause to these dependencie issues
[21:17] <oerheks> and support for next hirsuite 22.10 in #ubuntu-next please
[21:17] <Habbie> well, +1 to many issues, but if not running apt-get update causes dependency issues, somebody messed up and it was not the user
[21:27] <tripp4h> Habbie: tried it but it didn't help, another paste: https://paste.ubuntu.com/p/KqNzfBKsZX/
[21:28] <oerheks> line 42 xenial??
[21:29] <oerheks> and deadsnakes ppa, oh dear..
[21:29] <oerheks> tripp4h, also, support for next hirsuite 22.10 in #ubuntu-next please
[21:30] <tripp4h> i would like to update but cannot right now
[21:30] <oerheks> yes, with that many ppa's and unsigned stuff, you have issues.
[21:30] <Habbie> tripp4h, update to what?
[21:31] <tripp4h> Habbie: to 21.10 and then 22.04
[21:31] <Habbie> right
[21:31] <tripp4h> or 22.04.1
[21:31] <oerheks> oh wait hirsuite is 21.10 ... EOL
[21:31] <oerheks> !eolupgrade
[21:31] <Habbie> (hirsute)
[21:31] <tripp4h> i'm bad with linux, kraah
[21:32] <oerheks> use the old-releases trick from that wiki
[21:33] <tripp4h> oerheks: do you mean that eolupgrades page?
[21:33] <oerheks> yes
[21:34] <oerheks> but with deathsnakes ppa installed, you might keep issues
[21:34] <tripp4h> i don't remember what i have it for.
[21:34] <tripp4h> maybe i'll disable it :-o
[21:35] <enigma9o7[m]> i think deathsnake is python
[21:36] <oerheks> do-release-upgrde should handle that, but as it is python, it can be an issue.
[21:44] <tripp4h> the deadsnake ppa isn't in sources.list, wonder where is it... searching
[21:45] <enigma9o7[m]> sources.list.d folder
[21:47] <oerheks> just removing that entry in sources.list.d  does not solve, one needs to use ppa-purge to reverse.
[21:48] <deego> tripp4h: did you remember to apt update?
[21:49] <jhutchins> oerheks: Doesn't update build a new index without the removed repo?
[21:50] <oerheks> jhutchins, i have seen many update issues with deadsnakes. i hope he tried with the old-rekleases trick first.
[21:52] <tripp4h> another paste, what do you recommend to remove from sources.list.d folder? https://paste.ubuntu.com/p/xDqMJNTZ9K/
[21:52] <tripp4h> deadsnake's no more
[21:53] <oerheks> they all will be disabled with do-release-upgrade, have fun!
[21:53] <johnfg> hi folks!
[21:54] <tripp4h> okie dokie. i did apt update deego. i can't update right now because my computer crashes from time to time...
[21:54] <johnfg> Just wanted to verify this here: I've got vino up and running and able (finally) to vnc into this machine.  There is nowhere that vino does logging as it is?
[21:58] <tripp4h> there should be an ubuntu and other linux's rescue cd, would be great.
[21:58] <johnfg> There's a workaround for having vino log, but not a feature to turn on/off, apparently.
[21:58] <tripp4h> other linux distributions
[21:58] <oerheks> rescue cd for EOL versions?
[21:58] <oerheks> lolz
[21:59] <oerheks> fix your hardware crashes, and update
[22:11] <tripp4h> oerheks: rescue cds for updaters and other problems
[22:12] <oerheks> just use a live iso for that..
[22:12] <tripp4h> oerheks: does it have something to fix problems if they occur? of course i can come here and ask :-)
[22:15] <oerheks> as you did not try to upgrade, why answer to non existing problems?
[22:16] <oerheks> i would download a fresh 22.04.1 and reinstall
[22:17] <laguna> oerheks how do i upgrade from 22.04 to 22.04.1
[22:17] <cbreak> tripp4h: the ubuntu installer usb image can install ubuntu, or boot an ubuntu live system (if you get the desktop installer)
[22:17] <cbreak> you obviously can also use it to rescue a system
[22:18] <enigma9o7[m]> laguna: using the software updater, or `sudo apt update;sudo apt dist-upgrade`
[22:18] <laguna> enigma ok thanks
[22:18] <enigma9o7[m]> If you do regular updates, you already have it.
[22:18] <laguna> enigma how can i tell
[22:19] <tripp4h> oerheks: i have before had problems with upgrading to a newer version. it was years ago tho.
[22:19] <enigma9o7[m]> hmmm maybe `lsb_release -a` ?
[22:19] <enigma9o7[m]> or from gui in help/about?
[22:19] <oerheks> good luck upgrading, tripp4h
[22:20] <laguna> enigma ok that says 22.04.1
[22:22] <laguna> oerheks i have a file called gnome-cards-data but what is the bin name to play the card game
[22:22] <enigma9o7[m]> sol
[22:23] <oerheks> should be in your menu somewhere
[22:23] <laguna> enigma oh yea it works thanks
[22:23] <laguna> enigma i like solitaire
[22:25] <enigma9o7[m]> I do too.  But I have not found a linux version as good as android versions :(    Things like click to place cards, and settings to only deal solvable games, etc.
[22:27] <cbreak> if you install steam, I'm sure you can find all the games you'll ever want :/
[22:27] <laguna> enigma i did not find the old epsxe emulator in the repos only pcsxr and it does not do a good job with ff7
[22:28] <laguna> epsxe had an option to enable some various graphics routines to  get ff7 to work correctly and pcsxr does not have those options
[22:28] <enigma9o7[m]> i use retroarch for that kinda stuff
[22:29] <laguna> enigma well retroarch is just a front end for various emulators....i would like to get the epsxe emulator version 1.6  or so working on this ubuntu
[22:30] <enigma9o7[m]> yeah there may be retroarch plugins for it, there are usually several different choices for each console if the first one doesnt work right
[22:31] <laguna> enigma oh i did not know that..i could take a look or just try to compile the epsxe tarball from scratch i guess with all the optional compiles
[22:32] <laguna> enigma i like the music in ff7 as you play through the game..and i can't afford a ps5 i saw selling for $700 plus to buy a new version of the game
[22:33] <enigma9o7[m]> Check out the libretro ppa, they may have the engine/core you're looking for if its not in regular ubuntu.
[22:33] <laguna> enigma
[22:34] <laguna> ok enigma thanks for the advices
[23:47] <Guest93> I have a Ubuntu 20.04.1 LTS release that I have updated the kernel on to linux 5.13 . However, <sys/syscall.h> is outdated; it does not include definitions for the more recent linux system calls that my applications depend on. How can I update my syscall.h on ubuntu?
[23:49] <oerheks> if you do a proper update; sudo apt update && sudo apt dist-upgrade, and reboot, you will have 20.04.5
[23:49] <oerheks> and how did you install 5.13?
[23:50] <Guest93> I already have Ubuntu 20.04.5 LTS installed. I upgraded to linux 5.13 using the package manager
[23:51] <Guest93> my uname-a is "Linux XXXXX 5.13.0-51-generic #58~20.04.1-Ubuntu SMP Tue Jun 14 11:29:12 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux"
[23:51] <oerheks> weird, HWE would give 5.15
[23:51] <oerheks> https://launchpad.net/ubuntu/focal/+package/linux-generic-hwe-20.04
[23:51] <guiverc[m]> the 5.13 kernel isn't supported anymore in Ubuntu; it no longer receives patches as reached EOL when 21.10 went EOL (it was a 21.10 kernel)
[23:52] <oerheks> normal focal gives 5.4 https://launchpad.net/ubuntu/+source/linux
[23:52] <oerheks> Guest93 so how did you install that kernel?
[23:53] <Guest93> I used some method of updating my kernel to 5.13 several months ago; I forget the exact nature of how I did it
[23:53] <Guest93> I used the package manager to do it, and some ubuntu documentation
[23:53] <oerheks> i bet you manually installed a random kernel from mainline
[23:53] <oerheks> !mainline
[23:53] <enigma9o7[m]> guest93: sudo apt install linux-generic-hwe-20.04
[23:53] <enigma9o7[m]> then reboot and all will be well
[23:53] <Guest93> it says: "linux-generic-hwe-20.04 is already the newest version (5.15.0.46.49~20.04.16)."
[23:54] <guiverc[m]> That means security fixes are on you; it's unsupported & thus unpatched by Ubuntu Guest93
[23:54] <enigma9o7[m]> if you have 5.15, grub shoulda booted into that.  have you messed with grub customization?
[23:54] <oerheks> oh, reboot, get into grub, and choose 5.15
[23:54] <enigma9o7[m]> grub usually boots into the newest kernel unless you tell it otherwise
[23:54] <Guest93> I don't have a bootloader installed. this is a VPS
[23:55] <enigma9o7[m]> sorry i dunno those letters
[23:56] <oerheks> ask your vps vendor howto get 5.15...
[23:56] <enigma9o7[m]> well i mean i know the letters, just not what they mean when combined
[23:56] <oerheks> he gets the money
[23:56] <Guest93> Virtual Private System; this is a virtual machine in some datacenter that I ssh into for a monthly fee