P.S. One of the things that sent me down this rabbit hole was the Myth channel in Plex started ending playback after about roughly 15 minutes.
Also I can still connect to the mythconverg database from my laptop, user mythtv, via DBVisualizer database tool, if that is of any help in resolving the DB issue. (Users table only lists "admin" user, perhaps security works differently these days?) On Tue, Aug 2, 2016 at 1:08 PM, Paul Boniol <[email protected]> wrote: > Evidently I broke one of the rules. "Never upgrade a working Myth > system!". So far I ended up backing up, installing (from latest DVD ISO) > and restoring from backups. After much fiddling, I have a system that is > at least partially functional. (It records tv shows and I can access files > from another computer through shared folders.) > > I've got some vexing issues that still remain. > > #1 When going to the web interface, I get > > !!NoTrans: Access denied for user 'mythtv'@'localhost' (using password: > YES) [#1045] > > I know I solved this before, but it was so long ago I have no idea how. > I've scoured the web. Found lots of people reporting the issue, few > solutions and none that have worked for me yet. Root user couldn't even > log into the database, only mythtv which didn't have any grant permissions. > > Last thing I tried was killing the mysql instance and doing: > mysqld_safe --init-file=/home/paul/mythsetup.txt > > contents: > ALTER USER 'root'@'localhost' IDENTIFIED BY 'pwd'; > ALTER USER 'mythtv'@'localhost' IDENTIFIED BY 'pwd'; > ALTER USER 'paul'@'localhost' IDENTIFIED BY 'pwd'; > GRANT ALL ON *.* TO 'root'@'localhost' WITH GRANT OPTION; > GRANT ALL ON mythconverg.* TO 'mythtv'@'localhost' WITH GRANT OPTION; > FLUSH PRIVILEGES; > > root still says access denied when trying to open mythconverg database... > (mysql 5.7.13) > https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html > > #2 Finding the Myth channel for Plex so I can watch on Roku. Can't find > it in Plex's channel list and the link I found to download via web browser > redirects to the Plex website... Anyone know if it is still viable? > > #3 Fumble-fingers strikes again... I used tar to back up /home to another > partition (NTFS, that I rarely writte to). When going to restore some > files from the tgz file, I accidentally typed -c instead of a -x.... So the > file got overwritten... I deleted the (now teeny) file. I tried > sudo ntfsundelete /dev/sda1 > It shows me the teeny file, but not the "real" file. Is there any hope? > Not a terrible loss if I can't get the files back, would just be nice. > (Stuff like bookmarks, a few files, etc Nothing a terrible loss.) > > Paul > -- -- You received this message because you are subscribed to the Google Groups "NLUG" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nlug-talk?hl=en --- You received this message because you are subscribed to the Google Groups "NLUG" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
