[mythtv-users] Changing myth servers

[Kevin Kuphal]

Yan Seiner wrote:
> My old server is dying, so I am bringing  a new server on line.
>
> The old backend is running 0.18, and resides on tooth at 192.168.128.2.
>
> Tne new backend is running 0.20, and resides on dionysus at 192.168.128.3.
>
> I've copied all of the data from the old server, compiled myth 0.20 from 
> source on the new backend and new frontend, dumped the database into the 
> new server, and in general have everything almost working.
>
> The problem comes in the playback.
>
> On TV recordings, I can see the thumbnail, but when I go to play it I get:
>
> 2006-10-18 06:02:17.881 RemoteFile::openSocket(file data socket):
>                         Could not connect to server "192.168.128.2" @ 
> port 6543
> 2006-10-18 06:02:17.881 RingBuffer::RingBuffer(): Failed to open remote 
> file (myth://192.168.128.2:6543/1028_20061011080000_20061011083000.nuv)
>
> So... I suppose the database has an entry for each recording, along with 
> the backend where it is stored.  Is there some neat way to tell myth 
> that all of the recordings are now on dionysus (192.168.128.3) and not 
> tooth (192.168.128.2)?
>
> I am having a similar problem with movies; the new backend doesn't pick 
> them up at all, although they are on the local file system.  I haven't 
> looked at this yet (one issue at a time) but I suppose the solution will 
> be similar...
>
>   
Probably the best way is to follow the database section of the 
documentation for changing your hostname.  This will change all 
references to Host X to Host Y which should be what you want.  If you 
don't want to do it for the whole database then a simple SQL query 
executed at the command-line or via phpmyadmin, etc. would be :

UPDATE recorded SET hostname = 'dionysus' WHERE hostname = 'tooth'

Kevin