[mythtv-users] Just upgraded to latest git and now I get "Protocol version check failure."

[R. G. Newbury]

On 05/19/2011 10:57 PM, Greg Grotsky wrote:
> Thanks for the response Geoffrey.  I've looked through your list and I
> wasn't able to find anything amiss :-/, see responses below.
>
> On Thu, May 19, 2011 at 8:27 AM, R. G. Newbury<newbury at mandamus.org>  wrote:
>
<big snip>
>> Eighth, restart the backend in a console with '-v all' checking that it
>> comes up properly. If so, restart it as a service, with at least '-v
>> database -l /var/log/mythbackend.log' and then check the log file (this
>> checks for misconfigurations in the /etc/sysconfig/mythbackend and
>> /etc/rc.d/init.d/mythbackend startup files (file locations for fedora)
>>
>> This is interesting, I did restart them with -v all and noticed that it
> reports specific mysql calls.  So I restarted with just -v database and I
> see it talking to the DB and getting results.  For some reason it still
> complains about not being able to talk to the server.
>
> 2011-05-19 20:10:10.701 mythfrontend version: master
> [v0.25pre-2003-gfd5e33a] www.mythtv.org
> 2011-05-19 20:10:10.708 Using runtime prefix = /mythtv/local64
> 2011-05-19 20:10:10.708 Using configuration directory =
> /home/spikeygg/.mythtv
> 2011-05-19 20:10:10.710 ThreadPool:HTTP: Initial 1, Max 25, Timeout 60000
> 2011-05-19 20:10:11.131 Empty LocalHostName.
> 2011-05-19 20:10:11.131 Using localhost value of mythbox
> 2011-05-19 20:10:11.131 Clearing Settings Cache.
> 2011-05-19 20:10:11.132 Testing network connectivity to '192.168.0.10'
> 2011-05-19 20:10:11.235 Clearing Settings Cache.
> 2011-05-19 20:10:11.260 New DB connection, total: 1
> 2011-05-19 20:10:11.263 Connected to database 'mythconverg' at host:
> 192.168.0.10
> 2011-05-19 20:10:11.266 Closing DB connection named 'DBManager0'
> 2011-05-19 20:10:11.267 Clearing Settings Cache.
> 2011-05-19 20:10:11.267 Connected to database 'mythconverg' at host:
> 192.168.0.10
> 2011-05-19 20:10:11.268 MSqlQuery::exec(DBManager0) SELECT data FROM
> settings WHERE value = 'language' AND hostname = 'mythbox'<<<<  Returns 1
> row(s)
> 2011-05-19 20:10:11.269 MSqlQuery::exec(DBManager0) SELECT data FROM
> settings WHERE value = 'country' AND hostname = 'mythbox'<<<<  Returns 1
> row(s)
> 2011-05-19 20:10:11.269 Current locale en_US
> 2011-05-19 20:10:11.269 Reading locale defaults from
> /mythtv/local64/share/mythtv//locales/en_us.xml
> 2011-05-19 20:10:11.270 MSqlQuery::exec(DBManager0) SELECT data FROM
> settings WHERE value = 'freqtable' AND hostname = 'mythbox'<<<<  Returns 0
> row(s)
> 2011-05-19 20:10:11.271 MSqlQuery::exec(DBManager0) SELECT data FROM
> settings WHERE value = 'freqtable' AND hostname IS NULL<<<<  Returns 1
> row(s)
> 2011-05-19 20:10:11.271 MSqlQuery::exec(DBManager0) SELECT data FROM
> settings WHERE value = 'iso639language0' AND hostname = 'mythbox'<<<<
> Returns 0 row(s)
> 2011-05-19 20:10:11.272 MSqlQuery::exec(DBManager0) SELECT data FROM
> settings WHERE value = 'iso639language0' AND hostname IS NULL<<<<  Returns 1
> row(s)
> 2011-05-19 20:10:11.272 MSqlQuery::exec(DBManager0) SELECT data FROM
> settings WHERE value = 'iso639language1' AND hostname = 'mythbox'<<<<
> Returns 0 row(s)
> 2011-05-19 20:10:11.273 MSqlQuery::exec(DBManager0) SELECT data FROM
> settings WHERE value = 'iso639language1' AND hostname IS NULL<<<<  Returns 1
> row(s)
>
>> Ninth, start the frontend also with logging, in a console and alt-tab to
>> the console to watch what happens.
>
>>
>> Yeah, I am always weary of upgrading the distro.  I didn't do anything like
> that this time though, it was a simple 'git pull' and recompile.  I don't
> really know what else to try...  Please help!

Wow this is weird. Except for your box apparently not having an explicit 
hostname set in networking there is nothing which stands out.

The only other thing I can think of is that you have duplicate entries 
in the settings table. You can have entries with the wrong hostname or 
even duplicated value entries with different data values....

Use 'select * from settings order by value into outfile "junk";'

This will leave the text file 'junk' in /var/lib/mysql/mythconverg. I 
have just run that on my laptop and get 759 rows! with a fair number of 
duplicates..Why? I have no idea.

Removing duplicates is a PITA. I will send you a script directly, which 
checks for duplicate hostnames, and for duplicate values. As written it 
brute force removes the first instance of any duplicate pair...on the 
assumption that the later on is the last choice.

Running the duplicate-removal script drops the count to 561 BTW.

On my actual mythbox, there are 563 rows in the settings table, and NO 
duplicates. But then, I don't actually mess around with the mythbox. The 
WAF says that that box MUST remain running!

Geoff