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