Opened 14 years ago
Closed 14 years ago
#8215 closed defect (invalid)
MythWeb hostname/setting hostname comparison is not case-insensitive
Reported by: | anonymous | Owned by: | Rob Smith |
---|---|---|---|
Priority: | minor | Milestone: | unknown |
Component: | Plugin - MythWeb | Version: | head |
Severity: | low | Keywords: | |
Cc: | Ticket locked: | no |
Description
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.
Change History (10)
comment:1 Changed 14 years ago by
comment:2 Changed 14 years ago by
Resolution: | → invalid |
---|---|
Status: | new → closed |
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.
comment:3 follow-up: 5 Changed 14 years ago by
Resolution: | invalid |
---|---|
Status: | closed → new |
Ryan,
can you be more specific about what the minor issues *were*? It would help a lot to narrow down where this issue lives...
comment:4 Changed 14 years ago by
Status: | new → infoneeded_new |
---|
comment:5 Changed 14 years ago by
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.
comment:7 Changed 14 years ago by
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.
comment:8 Changed 14 years ago by
Component: | MythTV - General → Plugin - MythWeb |
---|---|
Owner: | changed from Isaac Richards to Rob Smith |
Status: | infoneeded_new → new |
Summary: | Myth should interprate hostnames case-insensitivly → MythWeb hostname/setting hostname comparison is not case-insensitive |
comment:10 Changed 14 years ago by
Resolution: | → invalid |
---|---|
Status: | new → closed |
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.
Not reported by anonymous. Reported by me.