Search found 1871 matches

by bill6502
Thu Feb 04, 2021 11:46 pm
Forum: Troubleshooting
Topic: [solved] mythweb Access denied for user 'mythtv'@'localhost'
Replies: 16
Views: 398
United States of America

Re: mythweb Access denied for user 'mythtv'@'localhost'

mythtv-backend.service doesn't need to point to config.xml. Either the User= $HOME is used (your case) or MYTHCONFDIR can override it (yours doesn't). EnvironmentFile can contain values for $ADDITIONAL_ARGS for the ExecStart line and isn't in play here. Clearly, the backend will look at ~mythtv/.myt...
by bill6502
Thu Feb 04, 2021 9:17 pm
Forum: Troubleshooting
Topic: [solved] mythweb Access denied for user 'mythtv'@'localhost'
Replies: 16
Views: 398
United States of America

Re: mythweb Access denied for user 'mythtv'@'localhost'

If the backend works, then it appears that you're using the wrong password. I'll guess that Mint uses systemd. This will help you find the config.xml file in use: systemctl cat mythtv-backend (Mint may use another service name though. I don't know.) Look for the User= line. It's probably mythtv. Als...
by bill6502
Thu Feb 04, 2021 7:19 pm
Forum: Linux
Topic: MythTV Upgrade from v28 to v30
Replies: 2
Views: 235
United States of America

Re: MythTV Upgrade from v28 to v30

Can the failing remote frontend connect to the DB with this:

Code: Select all

mysql --user=mythtv --password=yours --host=localhost mythconverg
Until that works, MythTV won't. I'd start by verifying the password
in ~/.mythtv/config.xml (assuming your user starts the frontend).
by bill6502
Thu Feb 04, 2021 7:05 pm
Forum: Troubleshooting
Topic: [solved] mythweb Access denied for user 'mythtv'@'localhost'
Replies: 16
Views: 398
United States of America

Re: mythweb Access denied for user 'mythtv'@'localhost'

@ Linuxgrrl, do this from the command line on the host that the backend is running on: mysql --user=mythtv --password=<yours from config.xml in use> --host=localhost mythconverg Take MythTV out of the picture. If the above doesn't work, then MythTV/mythweb won't. If you're connecting to mythweb from...
by bill6502
Thu Feb 04, 2021 12:15 am
Forum: General Discussion
Topic: Recording options
Replies: 9
Views: 383
United States of America

Re: Recording options

@pinnerite, modifying any recording rule template affects the template itself and
any future recording rules using the template. Existing rules aren't affected.
by bill6502
Thu Feb 04, 2021 12:11 am
Forum: Troubleshooting
Topic: [solved] mythweb Access denied for user 'mythtv'@'localhost'
Replies: 16
Views: 398
United States of America

Re: mythweb Access denied for user 'mythtv'@'localhost'

I've never seen GRANT USAGE. The MythTV recommendation is here:
https://code.mythtv.org/cgit/mythtv/tre ... ase/mc.sql

And if you look at the mysql site (search for: no privileges):
https://dev.mysql.com/doc/refman/5.7/en/grant.html
by bill6502
Wed Jan 27, 2021 1:29 am
Forum: Linux
Topic: MythTV Upgrade from v29 to v31 - MySQL FROZEN
Replies: 8
Views: 444
United States of America

Re: MythTV Upgrade from v29 to v31 - MySQL FROZEN

MySQL v8 can read mythconverg.

Include the output of this please: dpkg -l mariadb-server mysql-server
and may as well see: systemctl status --full --no-pager mysql mysqld mariadb

Looking to see if MariaDB got installed.

FYI only, the 0.n prefix went away after 0.28.
by bill6502
Sat Jan 23, 2021 6:39 am
Forum: Troubleshooting
Topic: V32 Mytharchive installed but no entry in menus(SOLVED)
Replies: 30
Views: 1205
United States of America

Re: V32 Mytharchive installed but no entry in menus

The output of this please: curl --header Accept:application/json localhost:6544/Myth/GetSetting?Key=MythArchiveTempDir
by bill6502
Thu Jan 21, 2021 2:50 am
Forum: Troubleshooting
Topic: V32 Mytharchive installed but no entry in menus(SOLVED)
Replies: 30
Views: 1205
United States of America

Re: V32 Mytharchive installed but no entry in menus

@vidtek: It would also help if the log snippet had more lines, so that we
could see the timestamp. I'm guessing that the attachment above is
stale. It it's still happening each time the frontend is started, then it's
a bug - and one I didn't see (and don't see in my tree).
by bill6502
Sun Jan 17, 2021 9:26 pm
Forum: General Discussion
Topic: DataBase login/Connection failing
Replies: 13
Views: 833
United States of America

Re: DataBase login/Connection failing

Change the ALTER line to this: ALTER USER 'mythtv'@'localhost' IDENTIFIED BY 'KCd22fwc';

Ref: https://dev.mysql.com/doc/refman/8.0/en/alter-user.html
by bill6502
Sun Jan 17, 2021 6:55 pm
Forum: General Discussion
Topic: DataBase login/Connection failing
Replies: 13
Views: 833
United States of America

Re: DataBase login/Connection failing

No, the backend doesn't have to be running in order to use SQL. I appears, from the above, that the root SQL access issue is solved. You could: DROP USER mythtv and start over. MySQL v8 has a different syntax, # localhost user creation. CREATE USER IF NOT EXISTS 'mythtv'@'localhost' IDENTIFIED WITH ...
by bill6502
Tue Jan 12, 2021 4:31 am
Forum: Troubleshooting
Topic: Struggling with v31
Replies: 12
Views: 591
United States of America

Re: Struggling with v31

When the frontend is failing and before using the mythtv-setup kludge, I'd
restart the frontend with: mythfrontend --logpath /tmp and post the results
here or on google. Let's see the reason the FE is failing.
by bill6502
Tue Jan 12, 2021 4:10 am
Forum: Troubleshooting
Topic: Mythweb Backend Status page uses an old IP address
Replies: 1
Views: 291
United States of America

Re: Mythweb Backend Status page uses an old IP address

The setting used by that page is the deprecated MasterServerIP near as I can tell. I recall that it's currently preserved for things that may use it. Mine is set to the correct value. The hostname is NULL and my value is really an IP(v6). You could check here, but I'm not sure it's used on that page...
by bill6502
Sat Jan 09, 2021 10:22 pm
Forum: Linux
Topic: upgrade from scratch
Replies: 7
Views: 737
United States of America

Re: upgrade from scratch

I recommend https://www.mythtv.org/wiki/Release_Notes_-_31 . Especially the Major Changes
and Special Notices & Instructions (which has a link to backup and restore).