Mailing List Archive: cant access some recordings wneh I changed my machine's hostname and domain name

cant access some recordings wneh I changed my machine's hostname and domain name

cmisip at insightbb

Apr 19, 2003, 3:10 PM

Post #1 of 6 (1841 views)

I can access recordings earlier than March 18 or around that time.
After that, mythtv cannot see the files. I know it is pointed to the
right directory because I can access earlier than Mar 18 recordings. I
think it has something to do with Myth .8 associating a hostname to a
recording entry somewhere in the database. When the hostname changedk,
it cannot find the recordings. Prior to .8, this tracking was not
necessary as myth expects to run in one machine only. Is there a way
that I might be able to delete this hostname info (if I am even on the
right track here) so I can access my recordings past March 18? Any
future recordings will point to my new hostname so that should not be a
problem. Thanks

Re: cant access some recordings wneh I changed my machine's hostname and domain name [ In reply to ]

joelf at altelco

Apr 19, 2003, 4:16 PM

Post #2 of 6 (1769 views)

I'd use run an UPDATE on the recorded table and SET hostname = "whatever"

It might screw-up the starttimes because they seem to update to NOW for
some reason. Atleast they did on my machine. I had to go in and change
them to what was in the filenames. Luckily I only had 3 files.

Joel Feenstra

cmisip wrote:
> I can access recordings earlier than March 18 or around that time.
> After that, mythtv cannot see the files. I know it is pointed to the
> right directory because I can access earlier than Mar 18 recordings. I
> think it has something to do with Myth .8 associating a hostname to a
> recording entry somewhere in the database. When the hostname changedk,
> it cannot find the recordings. Prior to .8, this tracking was not
> necessary as myth expects to run in one machine only. Is there a way
> that I might be able to delete this hostname info (if I am even on the
> right track here) so I can access my recordings past March 18? Any
> future recordings will point to my new hostname so that should not be a
> problem. Thanks
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users@snowman.net
> http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users
>
>

Re: cant access some recordings wneh I changed my machine's hostname and domain name [ In reply to ]

edward.wildgoose at frmhedge

Apr 19, 2003, 4:22 PM

Post #3 of 6 (1780 views)

> I'd use run an UPDATE on the recorded table and SET hostname = "whatever"
>
> It might screw-up the starttimes because they seem to update to NOW for
> some reason. Atleast they did on my machine. I had to go in and change
> them to what was in the filenames. Luckily I only had 3 files.

perhaps something like

update table
set hostname = "whatever",
starttime=startime

Updating the field to be the original value *may* stop it changing...

Re: cant access some recordings wneh I changed my machine's hostname and domain name [ In reply to ]

joelf at altelco

Apr 19, 2003, 4:26 PM

Post #4 of 6 (1778 views)

Why does it change, does anyone know? Is it something that's setup that
way in the database? I use PhPMyAdmin so maybe it's that. I don't know.

Joel Feenstra

Edward Wildgoose wrote:
>
>>I'd use run an UPDATE on the recorded table and SET hostname = "whatever"
>>
>>It might screw-up the starttimes because they seem to update to NOW for
>>some reason. Atleast they did on my machine. I had to go in and change
>>them to what was in the filenames. Luckily I only had 3 files.
>
>
> perhaps something like
>
> update table
> set hostname = "whatever",
> starttime=startime
>
> Updating the field to be the original value *may* stop it changing...
> _______________________________________________
> mythtv-users mailing list
> mythtv-users@snowman.net
> http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users
>
>

Re: cant access some recordings wneh I changed my machine's hostname and domain name [ In reply to ]

Apr 19, 2003, 4:32 PM

Post #5 of 6 (1779 views)

On Saturday 19 April 2003 07:26 pm, Joel Feenstra wrote:
> Why does it change, does anyone know? Is it something that's setup that
> way in the database? I use PhPMyAdmin so maybe it's that. I don't know.

Because it's a timestamp field. There was much discussion of this on the list
a month or two ago, and a patch was promised, but, of course, nothing came of
that.

Isaac

Re: cant access some recordings wneh I changed my machine's hostname and domain name [ In reply to ]

cmisip at insightbb

Apr 20, 2003, 10:42 AM

Post #6 of 6 (1779 views)

I did not quite know how to do that update thing. I looked at the
0-7-to-0-8.sql file and figured to delete the hostname column in
recorded and then to create it again. It worked. At least there are no
side effects that I am aware of.

Thanks
On Sat, 2003-04-19 at 18:32, Isaac Richards wrote:
> On Saturday 19 April 2003 07:26 pm, Joel Feenstra wrote:
> > Why does it change, does anyone know? Is it something that's setup that
> > way in the database? I use PhPMyAdmin so maybe it's that. I don't know.
>
> Because it's a timestamp field. There was much discussion of this on the list
> a month or two ago, and a patch was promised, but, of course, nothing came of
> that.
>
> Isaac
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users@snowman.net
> http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users