[00:00] qswz your missing firmware, run "sudo apt-get install --reinstall linux-firmware" without the quotes [00:00] !ltse | qswz: maybe try linux 5.0, too [00:00] qswz: maybe try linux 5.0, too: The Ubuntu LTS enablement stacks provide newer kernel and X support for existing LTS releases, see https://wiki.ubuntu.com/Kernel/LTSEnablementStack [00:01] qswz I would also disable powersave, "sudo sed -i 's/wifi.powersave = 3/wifi.powersave = 2/' /etc/NetworkManager/conf.d/default-wifi-powersave-on.conf" [00:01] oh, thanks all, ok [00:01] then reboot [00:02] qswz: disable TKIP on the wifi router [00:02] anywho, my tuen to reboot [00:23] anyone have this "Qt: Session management error: Could not open network socket" when running sudo something on ubuntu 18.04 ; especially on a lenovo thinkpad when fingerprint-gui is installed? [00:33] Hello! I have a laptop running ubuntu 18.04 and it doesn't seem to be charging now. The battery indicator says "Charging" but charge doesn't increase beyond 0%. I haven't used the laptop for about 5 months. Is the battery dead :/? [00:40] I am running SCreensaver. Is there a way to disable screensaver when watching videos in Gnome MPV, VLC, and even YouTube in browser? [00:40] XScreensaver I meant. [00:41] um you could run up the blank time to the max like 7oo plus minutes [00:42] that will hold it off for a few hours [00:43] xBfrog: I hear uyou and it makes sense. but I was hoping to maintain the screensaver and screen lock function when I am not at the desktop without having to physically lock the screen. [00:44] ok, i dunno then, except resetting the time when video secession is over :) [00:44] HAHA! Coolion hehe [00:44] it wont affect your lock [00:45] 700 plus will give you over 11hrs [00:45] maybe not the best answer your looking for but it will work [00:48] or, In Display modes > Mode, select Disable Screen Saver. Otherwise, you can simply remove the package. I don't see any reason why it would disrupt anything. [00:49] xBfrog: Thank you. [00:49] ur welcome :) [01:09] dnivra: most laptops have battery information in the BIOS. I would check there for more information, Ubuntu should not prevent it from charging (especially when off) but might not show the charge level correctly. [01:30] https://termbin.com/g2o6 says I may have hit a bug or malfunctioned hardware which isn't very helpful, but then says the rest of the output will help me, but I have no idea how to read that, any thoughts? tomreyn [01:33] yelof: Thank you! I don't see the option to view battery information or run a diagnostic. I probably need to update the diagnostics software/bios probably. I'll check out how to do that on Ubuntu sometime. [01:45] jeremy31 I return once again because it still keeps prompting for password [01:58] any one with thoughts on how I can resolve this issue in my mysql error logs? https://termbin.com/g2o6 [01:58] Anyone else have any idea of why network manager keeps prompting for a password constantly? [01:58] ever since I upgraded to the latest ubuntu I can't get mysql to work [02:00] filifunky can you start mysql with gdb? [02:02] Gh0sT2242, hmmm...just looking at gdb for the first time right now [02:04] does it still crash in gdb, or are you just unfamiliar with it? [02:04] I am unfamiliar with it [02:05] ah we wont worry about it for now then [02:05] I just went "gdb mysql" and it said Reading symbols from mysql...(no debugging symbols found in mysql) [02:05] filifunky Stop the mysqld server with mysqladmin shutdown [02:07] Gh0sT2242 i ran mysqladmin -u root -p shutdown and got this:mysqladmin: connect to server at 'localhost' failed [02:07] error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' [02:07] Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! [02:10] Gh0sT2242, I have a feeling that some of the problem might be in my conf file. There wasn't anything in there after I upgraded. I added a bunch of different solutions on the internet but not sure its what it should be [02:11] filifunky might be as simple as "sudo service mysql start" [02:12] I get this: Job for mysql.service failed because the control process exited with error code. [02:12] See "systemctl status mysql.service" and "journalctl -xe" for details. [02:12] I will post the output of those [02:12] please do [02:13] systemctl status mysql.service: https://termbin.com/lfuqu [02:13] You said you updated to a new version recently, so it's possible that the MySQL server or the server host was killed in the middle of an update... [02:13] yeah it's possible [02:13] journalctl -xe: https://termbin.com/yxv8 [02:17] filifunkyI can't think of anything at the moment, if you have the time, I can do a bit of research and see if I can find an issue, but the easiest fix at the moment would be a clean install [02:17] Gh0sT2242 a clean install of mysql or ubuntu itself? I think I've done a clean install and i'm still having problems [02:18] I did a clean install but it asked me if I wanted to delete my databases, I said No [02:18] filifunky well then it may be a case of corrupt databases [02:19] Gh0sT2242 so I should do a clean re-install and delete the database? [02:19] I have a backup, just from almost a month ago unfortunately [02:19] try adding "[mysqld]innodb_force_recovery = 1" [02:19] hold on [02:20] i need to make a termbin [02:20] resolved defaults aren't applying working dns, help? [02:21] filifunky add to `/etc/mysql/my.cnf` https://termbin.com/yxv8 [02:22] codebam What are you trying to achieve? [02:23] Gh0sT2242 uh... working internet? [02:23] after rebooting the dns records are all messed up by resolved [02:23] and then I have to restart resolved before it applies them correctly [02:24] and when I restart resolved then it just replies with empty A records [02:24] Gh0sT2242 is that the right termbin? Its the same link I sent you earlier? [02:25] filifunky oop my bad, one sec [02:25] manually editing the /etc/resolve.conf does work temporarily, the internet does work, I can ping and download and do dns lookups manually with `dig @1.1.1.1 example.com` [02:25] filifunky https://paste.ubuntu.com/p/TmmyBrTGnH/ [02:25] codebam try `sudo dpkg-reconfigure resolvconf` [02:26] okay [02:26] okay done, rebooting [02:27] If it doesnt work, let me know, It might be dnsmasq [02:27] is this okay? https://paste.centos.org/view/b3a82e21 [02:28] after doing the reconfigure [02:28] and yeah that didn't fix it [02:28] should I start those services? [02:28] Gh0sT2242 i added that and got the same problem when I ran sudo service mysql start [02:28] Job for mysql.service failed because the control process exited with error code. [02:28] See "systemctl status mysql.service" and "journalctl -xe" for details. [02:28] codebam the reconfigure should have done it itself [02:29] oh yeah, it says loaded [02:29] Gh0sT2242 I found I get an error when I run it how i normally run it. The error is: [02:29] ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [02:29] codebam lets try disabling dnsmasq, Open /etc/NetworkManager/NetworkManager.conf [02:29] and I don't have /var/run/mysqld [02:30] so it can't connect to the socket because it doesn't exist [02:30] but how do I create that socket? [02:30] filifunky so we have to find the socket.... [02:30] okay [02:31] gimma a sec lol [02:31] there's no dnsmasq inside the networkmanager config [02:32] and dnsmasq isn't installed [02:32] codebam add it as https://paste.ubuntu.com/p/Y3FhyzMBrn/ [02:33] Gh0sT2242 okay [02:34] restarted networkmanager after doing that, still no working dns [02:35] codebam ...anything from dmesg? [02:35] filifunky to find the socket `sudo find / -type s` === zbenjamin_ is now known as zbenjamin [02:35] you mean journalctl? [02:36] codebam what version you running? [02:36] 19.10 on arm [02:36] armv7l [02:36] What's the output of both? [02:37] dmesg and journalctl? [02:37] just a sec [02:38] Gh0sT2242 there are a lot of sockets, but none of them say mysql if that is what I'm looking for [02:39] filifunky in /etc/my.cnf, where does `socket=` lead to? [02:39] by default it should be /var/lib/mysql/mysql.sock [02:40] dmesg: https://paste.ubuntu.com/p/FrzpwZV3k9/ journalctl: https://paste.ubuntu.com/p/Nz6dc8Xm77/ [02:40] Gh0sT2242 [02:41] test [02:41] it says /var/run/mysqld/mysqld.sock, but that doesn't actually exist lol [02:41] #ubuntu any update for raspberry pi 4 19.10 login cloud-init bug? [02:41] @ubuntu [02:41] codebam: What version of Ubuntu are you using? [02:41] codebam: And server or desktop? [02:41] whislock 19.10 [02:41] server [02:41] on the odroid xu4 [02:41] codebam: Did you install networkmanager after the install completed? [02:42] whislock no, it was there [02:42] It shouldn't have been. [02:42] filifunky does /var/lib/mysql/mysql.sock exist? [02:42] so... I should remove it? [02:42] Is your connection wired or wireless? [02:43] wired [02:43] Gh0sT2242, no. The folder exists, but mysql.sock does not [02:43] codebam: dpkg -l netplan.io [02:43] codebam: Do you get a package or an error? [02:44] filifunky19.10? [02:44] whislock I get a package [02:45] Gh0sT2242, yep [02:45] but I fixed dns by editing /etc/resolv.conf to fix dns temporarily [02:45] filifunky sudo find / -type s | grep mysqld.sock [02:45] codebam: Key word is "temporarily." Let's fix it properly. [02:45] yeah, needed internet to use pastebin [02:45] codebam: pastebin the contents of /etc/netplan/*.yaml [02:46] whislock there's nothing in that folder [02:47] And this was the default install? Was this preinstalled, or you installed it yourself? [02:47] Gh0sT2242, this is the result: find: ‘/run/user/1000/doc’: Permission denied [02:47] find: ‘/run/user/1000/gvfs’: Permission denied [02:47] find: ‘/media/pete/Seagate Backup Plus Drive1/.Trash-1000/expunged/2947542317/12/03’: Input/output error [02:47] I installed 17.04 or something way back and have been doing dist-upgrade [02:47] it's the image provided by odroid [02:47] codebam: Okay, that explains things. [02:48] filifunky you ran as root, correct? [02:48] codebam: I'm going to pastebin a template for you. What is the name of your wired interface? [02:48] eth0 [02:49] codebam: What's the MAC address? [02:49] 00:1e:06:32:d7:cf [02:49] Gh0sT2242 I ran it using sudo, that's the same right? [02:49] codebam: Static addressing or dhcp? [02:49] dhcp [02:50] I guess I could give it a static address though [02:50] Let's start simple. :) [02:50] codebam: Insert this into /etc/netplan/eth0.yaml: https://paste.ubuntu.com/p/zVjcK8c9Mb/ [02:51] I don't know what's wrong with it. it keeps locking up [02:51] just a sec [02:51] What's wrong with what? [02:52] filifunky `sudo apt purge mysql-server mysql-common` and `sudo apt autoremove mysql-server mysql-common` [02:52] the install. it keeps locking up after like 20 mins [02:52] and I have to power cycle [02:52] like the whole board just locks up [02:52] filifunky this deletes ALL mysql data, so backup tables thaty are important to you [02:53] codebam: Might I offer that it may be time for a clean install? [02:53] Gh0sT2242, ok, that's fine with me. I have a backup from a month ago. Can I backup what's there right now even though I can't get into mysql? [02:53] hmm I guess [02:53] but if I clean install the last image that odroid provides is 18.04 [02:55] filifunky I'll be honest with ya, I only know how to back them up from inside of mysql, but im sure binaries are somewhere on system [02:55] so I'd just have to dist-upgrade to get 19.10 anyways [02:55] I'm going to try backing up the sdcard and installing alpine maybe [02:55] !dist-upgrade | codebam [02:55] codebam: A dist-upgrade will install new dependencies for packages already installed and may remove packages if they are no longer needed. This will not bring you to a new release of Ubuntu, see !upgrade if that is your intention. [02:55] something minimal [02:56] ubottu yeah my bad I meant release-upgrade or whatever [02:56] codebam: I am only a bot, please don't think I'm intelligent :) [02:56] Gh0sT2242: Purging those packages does not remove mysql's table data. [02:56] Gh0sT2242 I just looked at my backup, and it looks like it was backedup wrong [02:56] whislock autoremove cleans tables doesnt it? [02:56] I have another backup from a while ago, I hopefully won't have to go back to that [02:57] but i will if i have to [02:57] Gh0sT2242: No. autoremove removes packages that were installed as dependencies that are no longer required. [02:57] well filifunky i suppose tables wont be touched by the two command... so hopefully your safe [02:58] Gh0sT2242 just to clarify you mean won't be touched by those two commands you shared? [02:59] If what Whislock said is true, perfectly safe filifunky [02:59] codebam: The latest arm server release that I see on the ubuntu website is 18.04. [02:59] Wait. Ignore what I just said. [02:59] The button for 19.10 is right there. [03:00] codebam: https://ubuntu.com/download/server/arm [03:00] ok, I'll give it a shot [03:00] whislock is there a release there for the exynos5422? [03:01] that is for arm64 [03:01] this is armv7l [03:01] Gh0sT2242 ok, did it [03:02] filifunky `sudo apt-get update` then `sudo apt-get install mysql-server` [03:03] done but got some errors [03:03] codebam: ARMv7 and ARMv7L aren't different architectures. Your CPU is ARMv7. [03:03] codebam: Pull down an image and try booting it. [03:03] You may be causing yourself more headache than you need. [03:03] filifunky errors? what kind? [03:04] Gh0sT2242: https://pastebin.com/jKF7DgUd [03:07] filifunky that ones new to me, apparmor parser error... [03:09] yeah no fun lol [03:10] filifunky `sudo apt-get purge mysql*`, `sudo apt-get autoremove`, `sudo apt-get autoclean`, after those three have run, `sudo apt-get dist-upgrade` [03:10] WAIT [03:11] after purging mysql restart machine filifunky [03:11] I just did sudo apt-get purge mysql* [03:11] and sudo apt-get autoremove [03:11] should i do the autoclean? [03:11] sure, then reboot [03:11] ok [03:12] brb [03:15] Gh0sT2242 back [03:15] am going to do sudo apt-get dist-upgrade [03:15] filifunky best of luck [03:16] Gh0sT2242 so I'm guessing the next step is to install mysql? [03:16] sudo apt-get install mysql-server [03:16] sure is [03:17] I still get the parser error [03:17] sudo apt purge apparmor [03:17] remove the problem and it cant be a problem anymore [03:18] then `sudo apt install mysql-common mysql-server` [03:18] after sudo apt purge apparmor: https://pastebin.com/uApRrzJr [03:19] sudo dpkg --configure -a [03:19] maybe [03:20] after sudo dpkg --configure -a: https://pastebin.com/yhGu0NUL [03:20] well we got an error log this time [03:21] you mean the systemctl status mysql.service? [03:21] lol my browser crashed, am back [03:22] can I see the output of `/var/log/mysql/error.log` filifunky ? [03:22] lol your browser is tired of this problem [03:22] sure [03:23] filifunky: Gh0sT2242:: "Package mysql-server-8.0 is not configured yet." try command ' sudo dpkg-reconfigure mysql-server-8.0 ' . [03:23] Bashing-om dpkg --configure -a configures all packages does it not? [03:23] https://termbin.com/is8y [03:23] wasn't it something like mysql-server-secure-setup or such? [03:24] mysql_secure_installation [03:24] in cli [03:26] revolt112 he cant even get the service to start, let alone have it run secure setup [03:26] Gh0sT2242 should I try what Bashing-om is suggesting? [03:26] or crap my fault (just woke up about 10 min ago) was too lazy to check backlog [03:27] filifunky give it a shot [03:27] ok [03:27] (in Ger it is 04:26) [03:27] this is what I get: /usr/sbin/dpkg-reconfigure: mysql-server-8.0 is broken or not fully installed [03:28] sudo apt --fix-broken install [03:28] looks familiar: https://pastebin.com/ZK4RQmKa [03:29] filifunky, do you have some databases already? if not tried: apt remove --purge mysql-server* || apt install mysql-server* [03:29] revolt112 tried it already, as well as purging apparmor [03:30] uff [03:30] revolt112, I do, and would prefer not destroying those. The most recent backup I have doesn't look good. I have an older backup that looks decent although old [03:30] even dropping apt cache before reinstalling? (apt clean) [03:30] filifunky sudo apt upgrade and try again? [03:31] ill be honest, this one's got me stumped atm [03:31] I just did sudo apt upgrade and get the errors again "error processing package mysql-server-8.0 [03:31] " [03:32] Gh0sT2242, I appreciate the effort [03:32] I get a feeling tomreyn might know a way out of this [03:33] filifunky the definition of insanity, doing the ame thing over and over again, try `sudo apt-get purge mysql*` [03:33] there was a parameter to get apt to be more verbose [03:33] ok then install it again? [03:34] sudo apt-get install mysql-client mysql-server libmysqlclient-dev [03:34] sudo apt-get -o Debug::pkgProblemResolver=true -o Debug::Acquire::http=true [03:34] same errors [03:34] may including this [03:35] filifunky i, am, lost [03:35] lol [03:35] all I can assume at this point is what the error doubts [03:35] no problem [03:35] hardware issue [03:36] i hope not, but yeah it's a possibility [03:36] well, I am exhausted unless someone else has any other ideas [03:36] filifunky, do you have tried mariadb before? dpkg -l || grep mariadb-* [03:37] filifunky Well, I'm sorry I couldn't help you out, but im sure some of these other great minds could help ya out [03:37] revolt112, no i haven't [03:37] i'll give that a shot [03:37] Maria is a great idea actually [03:37] but imma head out, good luck [03:38] revolt112: https://pastebin.com/7N22jRYj [03:40] i think grep screwed up with the dash symbol [03:40] try installing mariadb [03:40] should be compatible with mysql dbs [03:41] revolt112: sudo apt install mariadb-client-core-10.3 ?? [03:41] filifunky, you need server also and there are metapackages [03:42] mariadb-client mariadb-server [03:42] ok [03:44] revolt112: looks like some error when installing mariadb-server [03:44] https://pastebin.com/DzsE3w35 [03:45] systemctl status mariadb.service: https://termbin.com/p0m2 [03:46] ./var/lib/mysql: found previous version 5.7 [03:46] that could be the reason [03:47] sudo mv /var/lib/mysql /var/lib/mysql.bak [03:47] I just went into /var/lib/mysql and can at least see my databases! I'm happy it doesn't look like it has been deleted and lost [03:47] and give it next try [03:48] ok [03:49] maybe you need to remove --purge again and reinstall [03:49] your databases are backed up [03:49] i did the sudo mv /var/lib/mysql /var/lib/mysql.bak [03:49] check first with cd into it [03:49] wait to make a backup wouldn't i need to cp instead of mv? [03:50] when the directory is renamed would be enough but cp anyway [03:51] cp /var/lib/mysql.bak /var/lib/mysql [03:51] you can cp -R /var/lib/mysql.bak ~ [03:51] no i want the directory /var/lib/mysql not existing anymore before installing mariadb [03:52] oh ok [03:52] then we should try a fresh install then reimporting needed tables one by one [03:52] alright, I am going to try and install maria server again because maria client seemed to install just fine? [03:53] yes [03:53] ok [03:54] i did a sudo apt install mariadb-server, it finished but didn't really do anything...0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. [03:54] or do I have to get rid of it first then install it [03:54] it is installed [03:54] yes including --purge [03:54] apt remove --purge mariadb-server* [03:55] ok, yeah feel free to just tell me the commands [03:55] done [03:55] service up and running now? [03:55] install again? [03:55] yes [03:56] apt install mariadb-server [03:56] done and looks like no errors [03:57] systemctl status mariadb [03:58] some error: https://termbin.com/bkxb [04:00] but service is running [04:00] yea, it's a nice change [04:00] debian-sys-maint is missing in table mysql.users [04:01] systemctl stop mariadb [04:01] done [04:01] can you show me "ls -lisa /var/lib/mysql" [04:02] https://termbin.com/dcy8i [04:05] ok mv /var/lib/mysql/mysql then cp -R /var/lib/mysql.bak/mysql /var/lib/mysql [04:06] and start service [04:06] cp -R /var/lib/mysql.bak/mysql /var/lib/mysql/ [04:06] missing / at the end [04:06] ok [04:07] if service is crashing then your mysql database is corrupt and we need to fix [04:08] ok done [04:09] service running? [04:10] it says its down. But doesn't look like as bad as before [04:10] https://termbin.com/x349 [04:10] usually there is a red dot which I assume is worse [04:12] mysql_upgrade --port=3306 --user=root --password= [04:14] welp, back to the old error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [04:14] FATAL ERROR: Upgrade failed [04:14] if it fails we need to roll back to saved original mysql db and do mysql_secure_installation [04:14] yeah looks like it fails [04:16] how do I do the roll back and secure installation? [04:16] i need to lookup if we can have mysql (the one that comes with mariadb) and the renamed to something mysql from previous installation [04:17] ok [04:17] delete (if you cp and not mv) rm -R /var/lib/mysql/mysql and copy saved original from mariadb over [04:17] then service should start again [04:19] indeed we can have both just renamed [04:19] tell me if you are ready so far and service is running again [04:19] had to pee ^^ [04:20] so rm -R /var/lib/mysql/mysql and then cp /var/lib/msyql.bak/mysql /var/lib/mysql? [04:20] no in mysql.bak are your previous mysql tables [04:21] the one that comes with mariadb you copied to remember? [04:21] oh yeah [04:21] ok [04:23] check permissions with ls -lisa i got suspicious that the owner of the database could be root and not mysql anymore because of the copy command [04:23] if so that could be the reason for service crash because of failing upgrade [04:24] do I have to do cp -r when copying the mariadb files over? [04:24] jep [04:24] ok [04:24] ok just copied those files over to /var/lib/mysql [04:24] ls -lisa [04:25] in /var/llib/mysql [04:25] -l [04:25] https://termbin.com/fwvr [04:26] ohh crap as expected [04:26] looks like its root [04:26] i think you gonna hate me [04:26] =) [04:26] haha [04:26] no way you're helping me [04:26] remove mysql again and cp you myql.bak version over [04:26] hi [04:27] after that chown -R mysql:mysql mysql [04:27] sudo apt remove mysql? [04:27] and try starting service [04:27] nooo [04:27] ok [04:27] rm -R (if cp and not mv) /var/lib/mysql/mysql [04:28] cp -R /var/lib/mysql.bak/mysql /var/lib/mysql/ [04:28] then chown -R mysql:mysql /var/lib/mysql/mysql [04:28] systemctl start mariadb [04:28] then fingers crossed [04:30] ping [04:31] still there? [04:31] yeah still here [04:31] and? [04:31] nothing happened when I systemctl start mariadb [04:31] systemctl status mariadb [04:31] is that weird?> [04:32] good sign [04:32] oh [04:32]