<div class="gmail_quote">First off, thanks R.G. that was all very concise and helpful information, but I have a few issues with some of it (or should I say my setup does).<br><br>Let's say for just this response I have only the one MBE:<br>
<div> </div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
> select host,user,password from user; #Yes! there is a field called user, in a table called <br></blockquote><div><br>...tells me I have mythtv@% and mythtv@tv (my MBE's hostname). Per the documentation (<a href="http://www.mythtv.org/docs/mythtv-HOWTO-6.html#ss6.2">http://www.mythtv.org/docs/mythtv-HOWTO-6.html#ss6.2</a>), one could assume all I need is mythtv@% and generally makes sense for everywhere else I've used MySQL. However, the MBE won't start without mythtv@tv because:<br>
<br>2010-08-09 19:24:16.171 mythbackend version: branches/release-0-23-fixes [25364] <a href="http://www.mythtv.org">www.mythtv.org</a><br>2010-08-09 19:24:16.175 Using runtime prefix = /usr/local<br>2010-08-09 19:24:16.177 Using configuration directory = /home/mythtv/.mythtv<br>
2010-08-09 19:24:16.178 Empty LocalHostName.<br>2010-08-09 19:24:16.182 Using localhost value of tv<br>2010-08-09 19:24:16.195 New DB connection, total: 1<br>2010-08-09 19:24:16.202 Unable to connect to database!<br>2010-08-09 19:24:16.203 Driver error was [1/1045]:<br>
QMYSQL: Unable to connect<br>Database error was:<br>Access denied for user 'mythtv'@'tv' (using password: YES)<br><br>My config.txt says DBHostName=192.168.1.3 and config.xml says <DBHostName>192.168.1.3</DBHostName>.<br>
<br>Shouldn't mythtv@% cover that?<br><br>Additionally, I have mythweb on my MBE. MythWeb need mythtv@localhost in MySQL when using setenv db_server "localhost" in mythweb.conf, else I need to use the actual IP of the box setenv db_server "192.168.1.3" to satisfy mythtv@%.<br>
<br>I didn't have any of the duplication issue you describe in your settings table. It seems as though this is an issue with MySQL more than MythTV, but it's still unclear from the MythTV side how the MySQL calls have changed (if that's even the issue) from the release I'm using now (-fixes r25364) to the current release of -fixes. Furthermore, if there is a change in how MySQL is called from the backends, why doesn't it fail when the backend(s) start(s), as opposed to some seemingly random point later on.<br>
<br><br><br><br></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"> </blockquote><div><br><br> </div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
from this box would be rejected.<br>
<br>
Again, I wonder if that might not be the problem? So check that each slave's mysql.txt is pointing to the correct DbHostname (name or IP) and that each config.xml has the correct stanza:<br>
<DefaultBackend><br>
<DBHostName>localhost</DBHostName><br>
<DBUserName>mythtv</DBUserName><br>
<DBPassword>mythtv</DBPassword><br>
<DBName>mythconverg</DBName><br>
<DBPort>0</DBPort><br>
</DefaultBackend><br>
<br>
Note that /home/thisuser/mysql.txt is for this user, on this machine to be able to find the mysql server. Note that there is a line for localhostname (since it CAN differ from what hostname returns (yes! Asking for trouble...but some boxes get set up without a 'hosts' file).<br>
The config.xml file is a myth file.<br>
<br>
Way outside the screen we are looking at: do your slave machines NFS mount a directory on the master? Check that your slave's NFS mount includes 'actime0=0' along with the 'hard,nfsvers=3' and other mount options. You may have multiple slaves mounting the same point...but (improperly) caching data..<br>
<br>
<br>
Consider changing the user on each slave/frontend to distinctly identify the 'incoming caller' to the mysql server.<br>
<br>
This is just the mysql side of things and has nothing to do with the master backend/slave backend recording + tuner relationship within Myth. But the mysql setup HAS to be correct for Myth to work.<br>
<br>
I've never dealt with a slave backend nor for that matter with multiple frontends. I have only just played with access to a mysql server from a different box (ie access the desktop mysql server from the laptop), and once for a short time, played with using the laptop as a frontend to the desktop. (Of COURSE I have a full myth setup on my office desktop, AND the laptop. For "testing" purposes. That's my story and I'm sticking to it. Besides, I don't MESS with the mythbox. Messing with the WAF is definitely contra-indicated.)<br>
<br>
There are, however, places in the myth setup which affect how myth boxen talk to the backend. These are all in the mysql tables.<br>
<br>
Main databaes and tables to worry about:<br>
user table in the mysql database, as noted above and<br>
settings table in the mythconverg database.<br>
<br>
The settings table of the master mythconverg database holds all the individual settings. At the console:<br>
> use mythconverg; # switch database<br>
> select * from settings; # list settings or more precisely:<br>
> select value,data,hostname from settings;<br>
<br>
On my pure BE/FE system, this gave 562 rows!<br>
To check for conflicting entries on a single system, use:<br>
> select value,data,count(value) from settings group by value having count(value) > 1;<br>
<br>
On my backend, this gave me 14 duplicate 'value' entries, including (weirdly) 'ArchiveDBSchemaVer' with 'data' equal "1004" in one entry and "1005" in the other! The others were pure duplicates. (Since there is no PrimaryKey, mysql does not choke on these duplicates.)<br>
<br>
> delete from settings where value = "ArchiveDBSchemaVer" and data = "1004";<br>
<br>
Most had the same data value and I could drop one:<br>
> delete from settings where value = "TVVidModeResolution0" limit 1;<br>
<br>
Then look at:<br>
> select value,data,hostname from settings where value like "%Server%";<br>
This will show, among other things, the MasterServerIP and BackendServerIP addresses with hostname.<br>
There should be no duplicates of those.<br>
<br>
On a BE/FE machine you will have lots of entries where the hostname is "NULL". These a pure backend settings, as far as I can see.<br>
<br>
HOWEVER, where you have slave backends, and separate frontends, you will have entries relating to each machine.<br>
To separate each machine you can use:<br>
> select value,data,hostname,count(value) from settings group by value having count(value) > 1;<br>
then<br>
> select value,data,hostname,count(value) from settings where hostname = "<a href="http://slave1.mydomain.org" target="_blank">slave1.mydomain.org</a>" group by value having count(value) > 1;<br>
<br>
The first may show lots of 'duplicates' but the second will restrict each list to one slave.<br>
<br>
Clean up any duplicates relating to each slave (or defunct machines!) and then:<br>
> select value,data,hostname from settings where hostname="<a href="http://slave1.mydomain.org" target="_blank">slave1.mydomain.org</a>;<br>
<br>
I really have no idea what you will see in this sort of listing. For frontends, there will be all the VidMode and Resolution related entries. I assume that slave backends will have entries mapping things like the backend. The capturecard table has a 'hostname' field as does the storagegroup table.<br>
<br>
One useful clause of the select command is:<br>
> select value,data from settings where value like "A%";<br>
or<br>
> select value,data from settings where data like "%76%";<br>
which returns values beginning with A or all the VidMode/GUI/Resolution entries which have height or screen sizes with '768' or '1350x768' etc.<br>
<br>
And that's about all I know which could be useful. As noted, all my problems were with user authentication and I strongly suspect that that is your problem too. If each machine is a distinct mysql user (slave1, slave2, frontend1, livingroom etc) at least THAT possible error is averted. These are, after all, computers. The system is doing exactly what it has been told to do...just that we don't know what that was and it was wrong!<br>
<br>
Hope this helps!<br>
Geoff<div><div></div><div class="h5"><br>
<br>
<br>
R. Geoffrey Newbury <br>
<br>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br>
</div></div></blockquote></div>