Ubuntu 14.04.6 upgrade to 16.04

Because of Ubuntu 14.04 no longer receiving security updates, I had to upgrade to 16.04. In general the experience went fairly smoothly, except for the heart wrenching error messages about sane failing to upgrade and leaving the system in a bad state. However, that did not seem to be the case, as the system was able to reboot fine.

However, not everything was working.

MythTV:

• Error: Webpages say: !!NoTrans: You are missing a php extension for mysql interaction. Please install php-mysqli or similar!!
• Install php mysql connector: sudo apt-get install php-mysql
• Restart Apache: sudo systemctl restart apache2
• Source: https://forum.mythtv.org/viewtopic.php?t=2511
• Error: Webpages say: contains nonaggregated column
• Edit /etc/mysql/mysql.conf.d/mythtv.conf to add: sql_mode=NO_ENGINE_SUBSTITUTION
• Restart mysql: sudo systemctl restart mysql
• Source: https://code.mythtv.org/trac/ticket/12713

Sane (scanning):

• I accidently left a computer running xsane connected, so that may have been the reason it failed
• It worked after telling systemd to start it
• sudo systemctl start saned.socket
• sudo systemctl enable saned.socket
• sudo systemctl status saned.socket

Web Services Dynamic Discovery (wsdd):

• Error: systemd would fail to start wsdd, but running it directly ran fine
• edited /etc/systemd/system/wsdd.service to change group from nobody to nogroup
• reloaded changes: sudo systemctl daemon-reload
• started daemon: sudo systemctl start wsdd
• checked status: sudo systemctl status wsdd

Software Updater:

• Error: Not all updates can be installed
• sudo apt dist-upgrade

Update 2020-05-30:
To fix wsdd, I also had to disable it listening on IP6 address. To do this I edited /etc/systemd/system/wsdd.service

• ExecStart=/usr/bin/wsdd --shortlog -4
• You could also have it just sleep before starting per this issue: https://github.com/christgau/wsdd/issues/18

Samba shares not showing up on Windows 10

I had an issue where my samba shares and printers stopped showing up on my Windows 10 machines. After doing some research, it seems to be due to Windows 10 disabling SMBv1 due to security concerns.
https://support.microsoft.com/en-us/help/4034314/smbv1-is-not-installed-by-default-in-windows

Now, I could just re-enable this, but I decided that wasn't the best idea due to the security concerns. However, if you want to here is the Microsoft support article about how to do it.
https://support.microsoft.com/en-us/help/2696547/how-to-detect-enable-and-disable-smbv1-smbv2-and-smbv3-in-windows-and

This forum thread (https://ubuntuforums.org/showthread.php?t=2409183) pointed me to a python package on github that enabled me to have my linux box show up on my Windows 10 machines. https://github.com/christgau/wsdd

Here are the steps that I used to install it on Ubuntu 14.04 that uses upstart:

• git clone https://github.com/christgau/wsdd.git
• cd wsdd
• sudo cp src/wsdd.py /usr/local/bin/wsdd
• sudo vi /etc/init/wsdd.conf
• sudo initctl start wsdd

Check that it is running as an unprivileged user:

• sudo initctl status wsdd
• ps aux | grep wsdd

Contents of wsdd.conf:

# Windows Discovery

description  "WSDD Server"

start on runlevel [2345]

stop on starting rc RUNLEVEL=[016]

respawn

respawn limit 2 5

kill timeout 300

exec start-stop-daemon --start --chuid nobody --exec /usr/local/bin/wsdd