rename PC with TV-Server? (1 Viewer)

[Chri]

Hy Guy`s

I have to rename my installed HTPC (MP/TVs1.0RC2).
But when i just rename the computer the TV-server won`t work anymore.
When i first change only the name the TVservice seem`s to won`t start anymore (is hanging on "wird gestartet")
An the Configuration Tool show`s me this:

After changing all the values in the registry i found, the config tool ist starts with saying "unable to connect to (old computername) "
But the TVservice seem`s to run again.

What do i have to change to get it working again with another name ?

mfg Chri

 

[Gixxer]

why not install lastest svn thats working great to a lot of people, and see if that fixes it.

having changed the name first of course.

good luck

 

[Chri]

Hy

I Tried to update to the newest SVN but this will only work if i let the Setup kill the whole database of the tvserver

(the radio settings are not available so i don`t want to make the db new )
luckily i have a ghost image of the current system, so i can try also on the database, if you can give me hints what i have do change

mfg Chri

 

[mattsnuts]

I also had problems with the TV Server after I renamed my PC. I've had to re-install MediaPortal and lost everything just to figure it out, really quite annoying!!

Anyway, I finally figured it out. If you rename your TV Server you don't need to reinstall anything. But you do need to change one of the tables in your database. Open the "Server" table in your database and change the "hostname" to the new name.

If you don't know how to do that, you can run the following query on your SQL database:
UPDATE [Server] SET hostname = 'new_PC_name' where hostname = 'old_PC_name'

-Matt

 

[Chri]

thx , mattsnuts for the hint , i`ll try it out

mfg Chri

 

[Leon_Gjerland]

And here is a step-by-step discription: How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server (MS SQL Server 2005)

 

[greybox]

Anybody knows how to rename the TV Server with MySQL?

 

[mattsnuts]

greybox I don't know as I don't have MySQL installed, but you could try running the UPDATE command I posted earlier.

 

[hkjensen]

MySQL:

UPDATE server SET hostname = 'new_PC_name' where hostname = 'old_PC_name'

or

UPDATE server SET hostname = 'new_PC_name'

since there is only one record in the table server

Remember to commit you changes

 

[greybox]

I logged into "MySQL Command Line Client" and ran the commands:

Enter password: ***********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 22
Server version: 5.1.35-community MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> UPDATE server SET hostname = 'new_name' where hostname = 'old_name'
ERROR 1046 (3D000): No database selected
mysql>
mysql> use;
ERROR:
USE must be followed by a database name

How do I select the database?
How do I commit the changes?