I pointed you the the mc.sql for an example of the commands to use. Then, just above your last
post, I gave you the commands modified to work on your machine. Changing mc.sql does nothing,
unless it's fed to mysql (which is done when a mythbackend is installed). It isn't used at runtime.
At host origen:
Login to as the root SQL user (probably sudo mysql mysql on your machine).
Then enter the four commands at the bottom of: viewtopic.php?p=27733#p27733
You should restore mc.sql and the legacy file. You can find originals here: https://github.com/MythTV/mythtv/tree/m ... v/database
You can do that later because, again, they aren't being used now.
Still on host origen:
As to the bind-address. In file: /etc/mysql/mysql.conf.d/mysqld.cnf change the bind-address
from 192.168.1.% (as I said, the % sign isn't valid here) to * . Don't keep changing other files
or entries in mysqld.cnf:mysqlx files (you're just wasting time as they're not in play.)
[Solved] Switch Backends
Moderator: Forum Moderators
Re: Switch Backends
From Origen (192.168.1.5)
$sudo mysql mysql
brings up the mysql> prompt
I could not identify the four commands you referred to.
I did restore mc.sql and legacy.mc.sql to their original state.
I also amended the bind-address from 192.168.1.% to 192.168.1.*
$sudo mysql mysql
brings up the mysql> prompt
I could not identify the four commands you referred to.
I did restore mc.sql and legacy.mc.sql to their original state.
I also amended the bind-address from 192.168.1.% to 192.168.1.*
Re: Switch Backends
The bind-address should be *, not 192.168.1.*
You can test my other suggestion of 192.168.1.0/24 if you like. I just have
never tried it myself.
Here's the link again: viewtopic.php?p=27733#p27733
The commands are at the bottom of that post (CREATE ... FLUSH).
You can test my other suggestion of 192.168.1.0/24 if you like. I just have
never tried it myself.
Here's the link again: viewtopic.php?p=27733#p27733
The commands are at the bottom of that post (CREATE ... FLUSH).
Re: Switch Backends
A kernel update required a TV card driver update but the compilation program was incompatible.
It was some time before that could be remedied.
I have reconfigured everything so that both backend and frontend are on the same machine.
Its address is 192.168.1.100. Its hostname is "lakeland".
Both backend and frontend seem to be working properly,
EXCEPT that, although recordings are being made, "Watch Recordings" doesn't show them.
The backend web setup does.
Instead the top left pane shows "All Programmes - Deleted" and overlaying both panes is:
"There are no recordings in your current view"
The lower pane is headed "All Programmes - Deleted"
There is no recording in this display group.
It was some time before that could be remedied.
I have reconfigured everything so that both backend and frontend are on the same machine.
Its address is 192.168.1.100. Its hostname is "lakeland".
Both backend and frontend seem to be working properly,
EXCEPT that, although recordings are being made, "Watch Recordings" doesn't show them.
The backend web setup does.
Instead the top left pane shows "All Programmes - Deleted" and overlaying both panes is:
"There are no recordings in your current view"
The lower pane is headed "All Programmes - Deleted"
There is no recording in this display group.
Re: Switch Backends
Sounds like the Group Filter was changed to Deleted.
With All Programs - Deleted selected, press menu, select Change Group Filter to
whatever you like (All Programs [x] would be good). Be sure to mention the theme
you're using if this doesn't work. And this thread is closed based on the comment
above.
With All Programs - Deleted selected, press menu, select Change Group Filter to
whatever you like (All Programs [x] would be good). Be sure to mention the theme
you're using if this doesn't work. And this thread is closed based on the comment
above.