Lose tv service to clients when Internet connection dies (1 Viewer)

[ianc]

Really weird one this.
Everything works when my Internet connection is up. but I can't access tv from a client when it's down. Client error log is given below. Strangely it's trying to connect to "CINEMA-PC" whereas the Configuration.exe shows is as the IP address. I can't find "CINEMAPC" anywhere in the client configs other than gentle.config - and everytime I change it in there it just gets over written.

Thoughts?

2010-12-01 21:40:37.895400 [ERROR][MPMain(1)]: TVHome: Error in Reload
2010-12-01 21:40:37.927400 [ERROR][MPMain(1)]: Exception :Error: DatabaseUnavailableUnclassified
Gentle.Common.GentleException: The database backend (provider MySQL) could not be reached.
Check the connection string: Server=CINEMA-PC;Database=MpTvDb;User ID=root;Password=***;charset=utf8;Connection Timeout=300; ---> MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts. ---> System.Exception: Exception of type 'System.Exception' was thrown.
at MySql.Data.MySqlClient.NativeDriver.Open()
--- End of inner exception stack trace ---
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
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.Exception: Exception of type 'System.Exception' was thrown.
at MySql.Data.MySqlClient.NativeDriver.Open()
--- End of inner exception stack trace ---
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlConnection.Open()
at Gentle.Provider.MySQL.MySQLProvider.GetConnection()System.Exception: Exception of type 'System.Exception' was thrown.
at MySql.Data.MySqlClient.NativeDriver.Open()
2010-12-01 21:40:37.930400 [ERROR][MPMain(1)]: Exception :The database backend (provider MySQL) could not be reached.
Check the connection string: Server=CINEMA-PC;Database=MpTvDb;User ID=root;Password=***;charset=utf8;Connection Timeout=300;
2010-12-01 21:40:37.934400 [ERROR][MPMain(1)]: site :Void FailWith(Gentle.Common.Severity, Gentle.Common.Error, System.Exception, System.String)
2010-12-01 21:40:37.937400 [ERROR][MPMain(1)]: source :Gentle.Common
2010-12-01 21:40:37.940400 [ERROR][MPMain(1)]: stacktrace: 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()

MediaPortal Version: MP 1.1.1
MediaPortal Skin: Standard
Windows Version: W7 Ultimate latest patches & SP
CPU Type: Intel Q6600
HDD: ~2 TB
Memory: 2G
Motherboard: abit ab9 Quad GT
Video Card: Asus EAH4770 PCIe
Video Card Driver: 9.11
Sound Card: onboard
Sound Card AC3: Optical out
Sound Card Driver:
1. TV Card: FireDTV
1. TV Card Type: DVB-S2
1. TV Card Driver: 5.7
2. TV Card: Avermedia PCI
2. TV Card Type: DVB S
2. TV Card Driver: latest?
3. TV Card: Terratec Cinergy dual
3. TV Card Type: DVB-T
3. TV Card Driver: 1.1.0.284
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec: SAF 4 beta22 (recomended)
MPEG2 Audio Codec: SAF 4 beta22 (recomended)
h.264 Video Codec: SAF beta22 (recommended)
Satelite/CableTV Provider: 28.2
HTPC Case:
Cooling:
Power Supply:
Remote: MCE
TV: Panasonic ax200
TV - HTPC Connection: HDMI

 

[ianc]

Fixed.
Put an entry into HOSTS file to resolve the name to the IP address. Not sure why this is needed when there's no internet connection though.

 

[karniemi]

Hi,

I just spent half a day on the same issue.
-I suppose the problem is quite much related to the sql connection string having either a name or an ip.
-I experienced the same issue when changing it once in client side to IP number, the next time I looked at it-the value had been restored to the name of the server(which my home network is not able to resolve).
-I've had the same pain 3 times when I've installed MediaPortal in server/client configurations (the latest with 1.1.2 version)
-Either the client is somehow restoring old configs/fetching a wrong wrongly configured gentle.config from the server, or something.
-also, if the mysql server is not quickly&properly up (when using wake on lan for the server), the client seems get easily mixed up. Maybe with wake on lan, the server might also "Lock" access to mysql db and the client gets frustrated.

I don't know.... I really don't know... I'm afraid...I just really don't know.