[01:20] <drab> meh
[01:20] <drab> spent 2hrs trying to figure out a problem with samba mounting a share and then remembered I'm in a container :....(
[01:20] <drab> le sigh
[01:50] <compdoc> drab, check to make sure you arent in a container
[12:49] <nickjj> hey, does anyone know of a good lightweight gpg keyring loader/manager? i just set up ubuntu server and having to type my massively long gpg passphrase is killing me on the inside -- looking for a solution where it just saves it and loads it every time i login to the server
[13:58] <MrHooper> When is iptables going to be phased out in favor of nftables?
[13:59] <ikonia> seems a long way away in general, let alone ubuntu
[13:59] <MrHooper> seems that way, doesn't it? :(
[14:35] <jge> hey all good morning, I was hoping someone could help. I had a lonely server running with a LAMP stack hosting a few things for me (including owncloud) but for some reason my ESXi host had an issue the other day and had to reboot. When my ubuntu instance came back up, mysql does not even show as installed!
[14:35] <jge> I can see mysql files under /var/lib/mysql
[14:37] <jge> dpkg -l shows mysql-common installed but as "rc"
[15:26] <drab> jge: I'd mv my data away from /var/lib/mysql to say /var/lib/mysql.old and then reinstall mysql
[15:27] <drab> after that you can possibly copy back the old mysql and see if ti starts at all
[15:27] <drab> you may have problems with innodb log sizes etc, but that can be worked through. if your data is there, in a sense, you're fine.
[15:31] <jge> drab: should I remove /var/lib/mysql after backing up and then installing again?
[15:31] <jge> or just leave it there
[15:32] <jge> it looks like it was mariadb that was running
[15:32] <drab> yeah that's what is generally installed these days, on ubuntu at least
[15:33] <drab> once you've backed it up, I don' think you have anything to lose to leave it there and see if it gets picked up
[15:33] <drab> it depends how much customized things there
[15:33] <drab> even a password set may cause trouble with maintenance routines for example
[15:34] <drab> also what you need to restore it depends on what you had set up. For example if you had created additional users those will need to be restored in mysql.users
[15:34] <drab> same for table privs etc
[15:34] <drab> I believe the pkg is set up well enough to deal with an existing mysql dir, so I'd try that and see what happens
[15:36] <jge> umm ok, yeah my installation was pretty vanilla .. just damn strange it would do this
[15:36] <drab> agreed, I've no idea how that could have ahppened
[15:36] <jge> scary! :)
[15:37] <drab> pretty sure something else is going on, but I can understand it's not worth finding out or even possible
[15:37] <drab> even if an old snapshot of sort was restored, previous to mysql that is, then /var/lib/mysql should have been missing
[15:38] <drab> the packages being in rc literally means that they have been removed but no purged
[15:38] <drab> so it's like someone literally ran apt-get remove mariadb
[15:38] <jge> I do have unattended-upgrades on, so I'm thinking maybe something related to an upgrade gone bad but my logs show mariadb upgraded fine back in april
[15:38] <jge> and has not been touched since then
[15:38] <drab> /var/log/apt/history.log should tell you if that was the case
[15:39] <jge> let me check
[15:48] <jge> interesing, I see a Commandline: apt-get install mariadb-server -y (back in april 25th, at 15:18) then a Commandline: apt-get purge mariadb-server a few minutes later
[15:48] <jge> done by me!
[15:48] <jge> da heck
[15:49] <jge> why would I do that.. yikes
[15:49] <jge> even then, my app was working fine just a few days ago
[15:49] <jge> before i rebooted
[15:49] <drab> the purge does not stop processes, not necessarily at least
[15:49] <jge> ahh
[15:49] <drab> so the process may had still eben running
[15:49] <drab> which is why problems started after reboot
[15:50] <jge> wow, ok..
[15:51] <jge> well, I'll try to install again and see what happens.. thank you drab
[15:51] <drab> np, yw, hope reinstall works, best of luck
[15:51] <drab> afk
[16:18] <jge> hooray, reinstalling worked like a charm
[17:54] <FMan> hey
[20:15] <drab> jge: glad to hear it worked
[23:21] <SupaYoshi> anyone here who can help me with some iptables rules?
[23:21] <SupaYoshi> hi, i'm trying to route all traffic over a certain port over a certain tun interface. I've already marked the traffic with iptables.
[23:21] <SupaYoshi> 	sudo iptables -A PREROUTING -t mangle -p tcp --dport 51413 -j MARK --set-mark 1
[23:21] <SupaYoshi>  want that traffic (dport and sport 51413 to go to tun1
[23:21] <SupaYoshi> anyone here that can lean me a hand?
[23:26] <ikonia> try #netfilter