TV server across subnets? (1 Viewer)

[allanp81]

MediaPortal Version: 2.2
MediaPortal Skin:
Windows Version:
CPU Type:
HDD:
Memory:
Motherboard:
Motherboard Chipset:
Motherboard Bios:
Video Card:
Video Card Driver:
Sound Card:
Sound Card AC3:
Sound Card Driver:
1. TV Card:
1. TV Card Type:
1. TV Card Driver:
2. TV Card:
2. TV Card Type:
2. TV Card Driver:
3. TV Card:
3. TV Card Type:
3. TV Card Driver:
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec:
MPEG2 Audio Codec:
Satelite/CableTV Provider:
HTPC Case:
Cooling:
Power Supply:
Remote:
TV:
TV - HTPC Connection:

I have the server running just great, can connect from a client on the same subnet and also pick up the stream via vlc on a different machine on a different subnet. I can't get a full client to connect to the server though if it's on a different subnet. It says TV is connected but cannot connect to the database. Anyone know why? I've tried both mysql and sql express servers and have the same problem with both. Firewall is disabled on all servers and clients.

 

[NarkoKrig]

I had similar problems when trying to stream from the internet.

I had to use openVPN, and make routes in the router and clients in order to make this work.

 

[allanp81]

Yep, it looks like a UDP helper on the router(s) to forward port 1434 around the place for this to work.

 

[mythtified]

I am having a similar issue. I looked in the error log for mediaportal. Right away the log says that it cannot connect to the database. It goes on to list the server it is trying to connect to. The server name is the name of the machine I have on my local network rather than the name or ip address I have given it during the MyTv set up process. Once the server connection is established, is the local server name overwriting what we are entering during setup? I opened gentle.conf on my client machine( which is on the other end of an internet connection) and found the local name of the database server I am trying to connect to. Now where did that come from? I did not enter it. It can only be coming from the remote tvserver on the local network. I try to change gentle.conf and it is overwritten each time I start mediaportal. Because of this I never see any attempt to connect to the database server through my remote firewall/router. Here is part of the error log file that mediaportal creates.

2007-07-15 16:36:03.187500 [ERROR][MPMain]: Exception :Error: DatabaseUnavailableUnclassified
Gentle.Common.GentleException: The database backend (provider MySQL) could not be reached.
Check the connection string: Server=mediaportal2k3;Database=TvLibrary;User ID=--------;Password=-------; ---> MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts ---> System.Net.Sockets.SocketException: No such host is known
at System.Net.Dns.InternalGetHostByName(String hostName, Boolean includeIPv6)
at System.Net.Dns.GetHostByName(String hostName)
at MySql.Data.Common.StreamCreator.GetStream(Int32 timeOut)
at MySql.Data.MySqlClient.NativeDriver.Open()
--- End of inner exception stack trace ---
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlPoolManager.GetConnection(MySqlConnectionString settings)
at MySql.Data.MySqlClient.MySqlConnection.Open()
at Gentle.Provider.MySQL.MySQLProvider.GetConnection()
--- End of inner exception stack trace ---
at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
at Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)
at Gentle.Provider.MySQL.MySQLAnalyzer.Analyze(String tableName)
at Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)
at Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)
at Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)
at Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)
at Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)
at TvPlugin.ChannelNavigator.ReLoad()MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts ---> System.Net.Sockets.SocketException: No such host is known
at System.Net.Dns.InternalGetHostByName(String hostName, Boolean includeIPv6)
at System.Net.Dns.GetHostByName(String hostName)
at MySql.Data.Common.StreamCreator.GetStream(Int32 timeOut)
at MySql.Data.MySqlClient.NativeDriver.Open()
--- End of inner exception stack trace ---
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlPoolManager.GetConnection(MySqlConnectionString settings)
at MySql.Data.MySqlClient.MySqlConnection.Open()
at Gentle.Provider.MySQL.MySQLProvider.GetConnection()System.Net.Sockets.SocketException: No such host is known
at System.Net.Dns.InternalGetHostByName(String hostName, Boolean includeIPv6)
at System.Net.Dns.GetHostByName(String hostName)
at MySql.Data.Common.StreamCreator.GetStream(Int32 timeOut)
at MySql.Data.MySqlClient.NativeDriver.Open()

It is returning the local name of the server rather than my port forwarded URL. I realize I can probably get this to work through a VPN connection but I was trying to avoid that.

 

[allanp81]

So you either need to specify the full dns name or mediaportal needs to always use the ip rather than hostname and assuming it's on the same subnet.

 

[mythtified]

Well that is where the problem is isn't it? In order to use the fully qualifed name from within the subnet I would need to be connected to the mediaportal machine with a vpn of some sort. If I were to use the fully qualified domain name from outside the subnet and use port forwarding then changing the name of the server to the external name would cause problems inside the subnet. I tried to use port forwarding and because my wins server name was being returned I could never connect with mysql server. I have tried Hamachi with limited success. I can finally get the client to connect to the mysql database by bouncing the sql server, going to myplugins/my tv/tv guide, then out to my tv again. This usually allows me to connect to the mysql server and get access to the EPG data. If I shut down the client and start it again then I have to start the process over again. I do not know whether this is because of connecting across the internet or not. I have not been able to be home long enough to test this on the same subnet. I have the same problem streaming video to the client. The server, according to my logs, is returning the server's local ip address. I am not sure how this will be taken care of short of installing a vpn between my remote machine and my local network. But this has given me something to occupy my time with.

 

[kivlok]

I hope this is what i think it is, a possibility to share tv-server across the internet! I have looked for somethin like this, i need to be able to stream tv channels and movies and all, trough the internet to a front end with MAF (Mother Able-To-Use-It Factor) ;-)

Hope this is something that will be implemented! I have currently only found streaming solutions involving VLC or Orb, nothing with a nice Mediaportal Front-End! (Or at least something alike!)

Hi-Five!