/srv/irclogs.ubuntu.com/2017/10/15/#ubuntu-server.txt

=== notdaniel is now known as _notdaniel
drabmeh01:20
drabspent 2hrs trying to figure out a problem with samba mounting a share and then remembered I'm in a container :....(01:20
drable sigh01:20
compdocdrab, check to make sure you arent in a container01:50
nickjjhey, 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 server12:49
MrHooperWhen is iptables going to be phased out in favor of nftables?13:58
ikoniaseems a long way away in general, let alone ubuntu13:59
MrHooperseems that way, doesn't it? :(13:59
jgehey 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
jgeI can see mysql files under /var/lib/mysql14:35
jgedpkg -l shows mysql-common installed but as "rc"14:37
drabjge: I'd mv my data away from /var/lib/mysql to say /var/lib/mysql.old and then reinstall mysql15:26
drabafter that you can possibly copy back the old mysql and see if ti starts at all15:27
drabyou 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:27
jgedrab: should I remove /var/lib/mysql after backing up and then installing again?15:31
jgeor just leave it there15:31
jgeit looks like it was mariadb that was running15:32
drabyeah that's what is generally installed these days, on ubuntu at least15:32
drabonce you've backed it up, I don' think you have anything to lose to leave it there and see if it gets picked up15:33
drabit depends how much customized things there15:33
drabeven a password set may cause trouble with maintenance routines for example15:33
drabalso 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.users15:34
drabsame for table privs etc15:34
drabI believe the pkg is set up well enough to deal with an existing mysql dir, so I'd try that and see what happens15:34
jgeumm ok, yeah my installation was pretty vanilla .. just damn strange it would do this15:36
drabagreed, I've no idea how that could have ahppened15:36
jgescary! :)15:36
drabpretty sure something else is going on, but I can understand it's not worth finding out or even possible15:37
drabeven if an old snapshot of sort was restored, previous to mysql that is, then /var/lib/mysql should have been missing15:37
drabthe packages being in rc literally means that they have been removed but no purged15:38
drabso it's like someone literally ran apt-get remove mariadb15:38
jgeI 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 april15:38
jgeand has not been touched since then15:38
drab/var/log/apt/history.log should tell you if that was the case15:38
jgelet me check15:39
jgeinteresing, 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 later15:48
jgedone by me!15:48
jgeda heck15:48
jgewhy would I do that.. yikes15:49
jgeeven then, my app was working fine just a few days ago15:49
jgebefore i rebooted15:49
drabthe purge does not stop processes, not necessarily at least15:49
jgeahh15:49
drabso the process may had still eben running15:49
drabwhich is why problems started after reboot15:49
jgewow, ok..15:50
jgewell, I'll try to install again and see what happens.. thank you drab15:51
drabnp, yw, hope reinstall works, best of luck15:51
drabafk15:51
jgehooray, reinstalling worked like a charm16:18
FManhey17:54
=== JanC is now known as Guest41887
=== JanC_ is now known as JanC
drabjge: glad to hear it worked20:15
SupaYoshianyone here who can help me with some iptables rules?23:21
SupaYoshihi, 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
SupaYoshisudo iptables -A PREROUTING -t mangle -p tcp --dport 51413 -j MARK --set-mark 123:21
SupaYoshi want that traffic (dport and sport 51413 to go to tun123:21
SupaYoshianyone here that can lean me a hand?23:21
ikoniatry #netfilter23:26

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