MythWeb hostname/setting hostname comparison is not case-insensitive

[anonymous]

I recently rebuilt my mythtv box. I manually backed up and restored the database. I accidentally changed the host name from 'HTPC' to 'htpc'. This caused some minor issues with old recordings that still had the old hostname in the database. But hostnames are suppose to be case-insensitive. So 'HTPC' & 'htpc' should be the same.

This failure should be rare. But it was hard to diagnose because I didn't really change the hostname.

[ryan.goat@…]

Not reported by anonymous. Reported by me.

[Dibblah]

I am closing this as a feature request. If you come up with a patch, please comment on this ticket and it will be reopened.

[robertm]

Ryan,

can you be more specific about what the minor issues *were*? It would help a lot to narrow down where this issue lives...

[ryan.goat@…]

The failure I experienced was in mythweb. Mythweb failed to generate preview images on the "Recorded Programs" page for recordings with the old (all-caps) host name.

[robertm]

Is the only issue in Mythweb?

[ryan.goat@…]

That is the only verified error I found before I found the root cause and fixed the database entires.

I did not notice any related errors in mythfrontend. The old recordings played and generated preview pictures just fine. But I did not do a systematic search looking for errors.

[beirdo]

See also #6700

[Rob Smith]

We control this via the database:

mysql> SELECT DISTINCT hostname FROM settings\G
*************************** 1. row ***************************
hostname: jessica

mysql> SELECT COUNT(0) FROM settings WHERE hostname = 'JESSICA'\G
*************************** 1. row ***************************
COUNT(0): 340

mysql> SELECT COUNT(0) FROM settings WHERE hostname = 'JeSsIcA'\G
*************************** 1. row ***************************
COUNT(0): 340

So in short, fix the database and all should be wel.