Reply to thread

Message

<blockquote data-quote="mythtified" data-source="post: 163968" data-attributes="member: 25097">I am having a similar issue.&nbsp; I looked in the error log for mediaportal.&nbsp; Right away the log says that it cannot connect to the database.&nbsp; It goes on to list the server it is trying to connect to.&nbsp; 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.&nbsp; Once the server connection is established, is the local server name overwriting what we are entering during setup?&nbsp; 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.&nbsp; Now where did that come from?&nbsp; I did not enter it.&nbsp; It can only be coming from the remote tvserver on the local network.&nbsp; I try to change gentle.conf and it is overwritten each time I start mediaportal.&nbsp; Because of this I never see any attempt to connect to the database server through my remote firewall/router.&nbsp; Here is part of the error log file that mediaportal creates.2007-07-15 16:36:03.187500 [ERROR][MPMain]: Exception&nbsp;&nbsp; :Error: DatabaseUnavailableUnclassifiedGentle.Common.GentleException: The database backend (provider MySQL) could not be reached.Check the connection string: Server=mediaportal2k3;Database=TvLibrary;User ID=--------;Password=-------; ---&gt; MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts ---&gt; System.Net.Sockets.SocketException: No such host is known&nbsp;&nbsp; at System.Net.Dns.InternalGetHostByName(String hostName, Boolean includeIPv6)&nbsp;&nbsp; at System.Net.Dns.GetHostByName(String hostName)&nbsp;&nbsp; at MySql.Data.Common.StreamCreator.GetStream(Int32 timeOut)&nbsp;&nbsp; at MySql.Data.MySqlClient.NativeDriver.Open()&nbsp;&nbsp; --- End of inner exception stack trace ---&nbsp;&nbsp; at MySql.Data.MySqlClient.NativeDriver.Open()&nbsp;&nbsp; at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()&nbsp;&nbsp; at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()&nbsp;&nbsp; at MySql.Data.MySqlClient.MySqlPool.GetConnection()&nbsp;&nbsp; at MySql.Data.MySqlClient.MySqlPoolManager.GetConnection(MySqlConnectionString settings)&nbsp;&nbsp; at MySql.Data.MySqlClient.MySqlConnection.Open()&nbsp;&nbsp; at Gentle.Provider.MySQL.MySQLProvider.GetConnection()&nbsp;&nbsp; --- End of inner exception stack trace ---&nbsp;&nbsp; at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)&nbsp;&nbsp; at Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)&nbsp;&nbsp; at Gentle.Provider.MySQL.MySQLAnalyzer.Analyze(String tableName)&nbsp;&nbsp; at Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)&nbsp;&nbsp; at Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)&nbsp;&nbsp; at Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)&nbsp;&nbsp; at Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)&nbsp;&nbsp; at Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)&nbsp;&nbsp; at TvPlugin.ChannelNavigator.ReLoad()MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts ---&gt; System.Net.Sockets.SocketException: No such host is known&nbsp;&nbsp; at System.Net.Dns.InternalGetHostByName(String hostName, Boolean includeIPv6)&nbsp;&nbsp; at System.Net.Dns.GetHostByName(String hostName)&nbsp;&nbsp; at MySql.Data.Common.StreamCreator.GetStream(Int32 timeOut)&nbsp;&nbsp; at MySql.Data.MySqlClient.NativeDriver.Open()&nbsp;&nbsp; --- End of inner exception stack trace ---&nbsp;&nbsp; at MySql.Data.MySqlClient.NativeDriver.Open()&nbsp;&nbsp; at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()&nbsp;&nbsp; at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()&nbsp;&nbsp; at MySql.Data.MySqlClient.MySqlPool.GetConnection()&nbsp;&nbsp; at MySql.Data.MySqlClient.MySqlPoolManager.GetConnection(MySqlConnectionString settings)&nbsp;&nbsp; at MySql.Data.MySqlClient.MySqlConnection.Open()&nbsp;&nbsp; at Gentle.Provider.MySQL.MySQLProvider.GetConnection()System.Net.Sockets.SocketException: No such host is known&nbsp;&nbsp; at System.Net.Dns.InternalGetHostByName(String hostName, Boolean includeIPv6)&nbsp;&nbsp; at System.Net.Dns.GetHostByName(String hostName)&nbsp;&nbsp; at MySql.Data.Common.StreamCreator.GetStream(Int32 timeOut)&nbsp;&nbsp; at MySql.Data.MySqlClient.NativeDriver.Open()It is returning the local name of the server rather than my port forwarded URL.&nbsp; I realize I can probably get this to work through a VPN connection but I was trying to avoid that.</blockquote>

[QUOTE="mythtified, post: 163968, member: 25097"] 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=[B][I][U]mediaportal2k3[/U][/I][/B];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. [/QUOTE]

Verification