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.

Reply via email to