[mythtv-users] using mythtv as clockradio

[Hika van den Hoven]

Hoi Michael,

Thursday, January 21, 2016, 1:25:17 PM, you wrote:

> On 01/21/2016 07:08 AM, Hika van den Hoven wrote:
>>> Ah you're right they are lowercase in the database. I'm so used that
>>> hostnames are case-insensitive and I always use the form with
>>> mnemonic capitals!
>>> config.xml has no hostname set on any machine. I have a very stable
>>> DNS, which also has the strings with the mnemonic capitals, so MythTV
>>> must have automatically reverted the dns names to lowercase!

> MythTV doesn't use DNS to generate the profile ID when one isn't given
> in config.xml.  It uses the gethostname() system call, which gives 
> exactly the same value given by the hostname command.  I'd guess it 
> does--or did at the time you first set up your system--give the 
> all-lowercase value.

The hostnames on the machines are setup exactly the same way:
pc-Hika, pc-Myth, GentooServer. I always and everywhere use the
capitalized versions and always make them equal to the dns names.
Somewhere along the way into the database they were converted to
lowercase. It doesn't really matter, just to know and be aware!

>> But what I then do not understand is why it accepts the capitalized
>> host when requesting the full list?
>>
>> <backend>:6544/Myth/GetSetting?HostName=pc-Hika
>>
>> and not when querying a specific value?

> Because when querying the whole list, we don't do any in-code (in-C++)
> comparisons, so the only comparison is by MySQL, and since we're using
> the utf8_general_ci (meaning UTF-8 general case-insensitive) collation
> for the settings table, it does case-insensitive comparisons.  This 
> inconsistency is yet another reason why the issue in #12320 is important.

I saw the issue was reported 14 month ago, with a very simple
proposed solution. Why then is it still hanging there in limbo??

I anyhow in the future will add a .lower() in my Python scripts to any
hostname! ;-) 

> Mike
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org





Tot mails,
  Hika                            mailto:hikavdh at gmail.com

"Zonder hoop kun je niet leven
Zonder leven is er geen hoop
Het eeuwige dilemma
Zeker als je hoop moet vernietigen om te kunnen overleven!"

De lerende Mens