[solved] TV Server IP change (1 Viewer)

[regeszter]

How do I know which DB I'm using? Microsoft or MySQL?

The our installer installs only MySQL.

 

[HTPCSourcer]

MS SQL can be edited by installing the Microsoft SQL Management Console.


Gesendet von iPhone mit Tapatalk

 

[azzuro]

Should we fix it?

See my post above for mysql. For mssql i dont know

 

[Stéphane Lenclud]

Thanks guys I could edit that MySQL database by installing the latest MyQL Workbench.
From MySQL Workbench you just need to select the local database and provide the password which is MediaPortal unless you've changed it.
Then go to the server table as explained on that wiki page @azzuro mentioned and edit your IP as needed.
I've actually put my hostname in there rather than any IP I figured that should give me more flexibility. It works just fine to far.
So again here it goes for the record:

• By default MP1 is using a MySQL database. To edit it you need MySQL Workbench.
• Make sure you stop the TV Service.
• Open local database through MySQL Workbench by providing MediaPortal as password.
• Locate the server table and replace your IP by your hostname, apply changes.
  
• Close MySQL Workbench.
• Start TV Service.
• You're good to go.

 

[azzuro]

All these step are not described in the wiki?

 

[Stéphane Lenclud]

All these step are not described in the wiki?

In some way yes, but having a condensed version here won't harm.

 

[azzuro]

i think, you can use command line, directly, with mysql command console, without use Workbench,