Search found 21 matches

by aartimus
Thu Sep 18, 2014 6:57 pm
Forum: Troubleshooting
Topic: Remote frontend can't access backend MySQL
Replies: 36
Views: 7218
United States of America

Re: Remote frontend can't access backend MySQL

Yes! It appears that the problem was %STARTTIMEUTC%. I made the change and successfully ran the user job from the "Watch Recordings" pop-up (thanks for the hint). Indeed, mythlink.pl fails silently. The log now shows: Link destination directory: /home/mythtv/links /home/mythtv/links/The Colbert Repo...
by aartimus
Thu Sep 18, 2014 7:50 am
Forum: Troubleshooting
Topic: Remote frontend can't access backend MySQL
Replies: 36
Views: 7218
United States of America

Re: Remote frontend can't access backend MySQL

I captured the output mythlink runs as a user job with verbose set (--verbose). This is the only thing sent to stdout and stderr: Link destination directory: /home/mythtv/links This is the correct destinaiton directory, but no symlink is created in that directory or anywhere else on the computer. Th...
by aartimus
Wed Sep 17, 2014 9:15 pm
Forum: Troubleshooting
Topic: Remote frontend can't access backend MySQL
Replies: 36
Views: 7218
United States of America

Re: Remote frontend can't access backend MySQL

Thanks for the suggestion. It looks link mythlink.pl logs to standard out when --verbose is specified. I added this to the user job command and redirected to a log file owned by mythtv. I'll see what happens when the next scheduled program is recorded.
by aartimus
Wed Sep 17, 2014 12:38 am
Forum: Troubleshooting
Topic: Remote frontend can't access backend MySQL
Replies: 36
Views: 7218
United States of America

Re: Remote frontend can't access backend MySQL

Myth has extensive logging available - see "mythfrontend -v help" Try: mythfrontend -v general, database, network --loglevel debug on the frontend to check that it is configured correctly and doing what you expect. And you can get detailed MySQL logs by adjusting your my.cnf. Maybe they will help y...
by aartimus
Wed Sep 17, 2014 12:20 am
Forum: Troubleshooting
Topic: Remote frontend can't access backend MySQL
Replies: 36
Views: 7218
United States of America

Re: Remote frontend can't access backend MySQL

MythTV Andriod Frontend (and likely others) access the backend using the Services API. It does not connect to mysql. The Services API running in the backend accesses the DB as needed. Thanks for the information. I kind of thought it was something like that. That method seems to he a lot less troubl...
by aartimus
Tue Sep 16, 2014 8:07 am
Forum: Troubleshooting
Topic: Remote frontend can't access backend MySQL
Replies: 36
Views: 7218
United States of America

Re: Remote frontend can't access backend MySQL

All that data looks good, except the ipv4 address is 192.168.0.120, not .119. Connecting to the backend server from a remote is pretty simple. All you need to do is make sure the ports are open, it listens for the addresses that try to connect to it, and you have the correct user name and password....
by aartimus
Tue Sep 16, 2014 6:07 am
Forum: Troubleshooting
Topic: Remote frontend can't access backend MySQL
Replies: 36
Views: 7218
United States of America

Re: Remote frontend can't access backend MySQL

Not a MythTV usability issue, a packagers usability issue. Contact your packager, or change to a different packager, or do your own packaging. The project (itself) does not ship a package that overwrites your configurations. This is clearly a packaging proble and no criticism of MythTV was implied....
by aartimus
Tue Sep 16, 2014 5:29 am
Forum: Troubleshooting
Topic: Remote frontend can't access backend MySQL
Replies: 36
Views: 7218
United States of America

Re: Remote frontend can't access backend MySQL

Any idea why I'm getting the localhost errors in the remote frontend log: I MythCoreContext: Connecting to backend server: localhost:6543 (try 1 of 1) E Unable to connect to database! and No address defined for host: localhost It's as if the frontend is trying to connect to a local backend, which d...
by aartimus
Fri Sep 12, 2014 5:48 pm
Forum: Troubleshooting
Topic: Remote frontend can't access backend MySQL
Replies: 36
Views: 7218
United States of America

Re: Remote frontend can't access backend MySQL

The Ubuntu "mythtv-database" package installs/overwrites /etc/mysql/conf.d/mythtv.cnf. There's probabaly a good reason, but it's a symptom of MythTV's usability problem. Common things like accessing a remote frontend accessing the backend should "just work" and not turn into computer science project...
by aartimus
Fri Sep 12, 2014 4:30 pm
Forum: Troubleshooting
Topic: Remote frontend can't access backend MySQL
Replies: 36
Views: 7218
United States of America

Re: Remote frontend can't access backend MySQL

Yea, that was a typo. You're right about overwrighting config files. It's sloppy packaging. In my experience MythTV in general is a handfull. Before MythTV I used the commercial package SageTV. It did about the same thing as MythTV but was much easier to manage. MythTV is a terrific product, but I w...
by aartimus
Fri Sep 12, 2014 8:11 am
Forum: Troubleshooting
Topic: Remote frontend can't access backend MySQL
Replies: 36
Views: 7218
United States of America

Re: Remote frontend can't access backend MySQL

forget the ipv6 thing. That was another problem. Every time you upgrade mythtv, mythtv.cnf gets overwritten and the bind address will be commented out. Just comment out the bind-address in my.cnf and mythtv.cnf and try that. That is supposed to open up all ports to both ipv4 and ipv6 addresses. And...
by aartimus
Thu Sep 11, 2014 11:10 pm
Forum: Troubleshooting
Topic: Remote frontend can't access backend MySQL
Replies: 36
Views: 7218
United States of America

Re: Remote frontend can't access backend MySQL

Did you try commenting out the bind-address directive? Also just noticed your ipv6 address. It didn't work right with my right ipv6 address either. had to change it in mythtv-setup to ::1 Do you have a firewall set? That's all I can think of at the moment. Do you mean to comment-out bind-address in...
by aartimus
Thu Sep 11, 2014 8:13 am
Forum: Troubleshooting
Topic: Remote frontend can't access backend MySQL
Replies: 36
Views: 7218
United States of America

Re: Remote frontend can't access backend MySQL

Tried bind-address = 0.0.0.0 in conf.d with bind-address in my.cnf set to its original value of 127.0.0.1. Got the same result. The frontend still can't contact the server.
by aartimus
Thu Sep 11, 2014 2:17 am
Forum: Troubleshooting
Topic: Remote frontend can't access backend MySQL
Replies: 36
Views: 7218
United States of America

Re: Remote frontend can't access backend MySQL

In mythtv-setup, you define the address of the master backend. The first time you run mythtv-setup or mythfrontend, it lets you specify the address of the database, and subsequently stores that in config.xml. It sounds like you have a bad value in your config.xml. That's what I thought at first. Bu...
by aartimus
Thu Sep 11, 2014 12:06 am
Forum: Troubleshooting
Topic: Remote frontend can't access backend MySQL
Replies: 36
Views: 7218
United States of America

Re: Remote frontend can't access backend MySQL

It looks like you specified your local IP address as the address of your MySQL server. That's what I thought when I saw it, but I defintely specify the IP of the backend (192.168.0.101) in setup. My suspsion is that there's a config flie somewhere that's not getting updated, but I can't find it. To...