home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
Support
Installation, configuration support
TvService seems to fail connecting MySQL
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="kasukka" data-source="post: 533493" data-attributes="member: 99512"><p><strong>MediaPortal Version</strong>: MediaPortalSetup_1.1.0_BETA-1_rev23491</p><p><strong>MediaPortal Skin</strong>: </p><p><strong>Windows Version</strong>: windows xp sp2</p><p><strong>CPU Type</strong>: athlon xp</p><p><strong>HDD</strong>: </p><p><strong>Memory</strong>: 1gb</p><p><strong>Motherboard</strong>: </p><p><strong>Video Card</strong>: radeon 9600</p><p><strong>Video Card Driver</strong>: </p><p><strong>Sound Card</strong>: </p><p><strong>Sound Card AC3</strong>: </p><p><strong>Sound Card Driver</strong>: </p><p><strong>1. TV Card</strong>: msi digivox mini ii v2</p><p><strong>1. TV Card Type</strong>: </p><p><strong>1. TV Card Driver</strong>: </p><p><strong>2. TV Card</strong>: </p><p><strong>2. TV Card Type</strong>: </p><p><strong>2. TV Card Driver</strong>: </p><p><strong>3. TV Card</strong>: </p><p><strong>3. TV Card Type</strong>: </p><p><strong>3. TV Card Driver</strong>: </p><p><strong>4. TV Card</strong>: </p><p><strong>4. TV Card Type</strong>: </p><p><strong>4. TV Card Driver</strong>: </p><p><strong>MPEG2 Video Codec</strong>: </p><p><strong>MPEG2 Audio Codec</strong>: </p><p><strong>h.264 Video Codec</strong>: </p><p><strong>Satelite/CableTV Provider</strong>: </p><p><strong>HTPC Case</strong>: </p><p><strong>Cooling</strong>: </p><p><strong>Power Supply</strong>: </p><p><strong>Remote</strong>: </p><p><strong>TV</strong>: </p><p><strong>TV - HTPC Connection</strong>: </p><p></p><p>My problem is I just can't get TvService running. It's the same for stable version as well as this</p><p>Beta1 version. It always comes to the error below. Everything else with the database seems</p><p>to go right: I always get schema initialized/upgraded with MP's tables. Only when there's</p><p>just the startup left, the tvservice will quit.</p><p></p><p>Could anyone help me? I'm getting desperate <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile :)" loading="lazy" data-shortname=":)" /></p><p></p><p></p><p>Thanks!!</p><p></p><p>Kasukka</p><p></p><p></p><p></p><p>FROM TV.LOG (a piece of text that will repeat multiple times):</p><p>------------------------------------------------</p><p></p><p>2009-11-12 00:17:48.703125 [5]: TV service: Starting</p><p>2009-11-12 00:17:49.109375 [TVService]: TVService v1.0.4.23491 is starting up on Windows XP ( Service Pack 2 ) [5.1.2600.131072]</p><p>2009-11-12 00:17:49.125000 [PowerEventThread]: TV service PowerEventThread message loop is running</p><p>2009-11-12 00:17:49.140625 [TVService]: Controller: Initializing TVServer</p><p>2009-11-12 00:17:49.140625 [TVService]: Controller: 1 init attempt</p><p>2009-11-12 00:17:49.171875 [TVService]: C:\Documents and Settings\All Users.WINDOWS\Application Data\Team MediaPortal\MediaPortal TV Server\gentle.config</p><p>2009-11-12 00:17:49.187500 [TVService]: Controller: using MySQL database connection: Server=perskeles;Database=MpTvDb;User ID=root;Password</p><p>2009-11-12 00:17:49.187500 [TVService]: ----------------------------</p><p>2009-11-12 00:17:49.203125 [TVService]: TvControllerException: Error: DatabaseUnavailableUnclassified</p><p>Gentle.Common.GentleException: The database backend (provider MySQL) could not be reached.</p><p>Check the connection string: Server=perskeles;Database=MpTvDb;User ID=root;Password=MediaPortal;charset=utf8;Connection Timeout=300; ---> MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts. ---> System.Net.Sockets.SocketException: The attempted operation is not supported for the type of object referenced</p><p> at System.Net.Sockets.Socket.get_ConnectEx()</p><p> at System.Net.Sockets.Socket.BeginConnectEx(EndPoint remoteEP, Boolean flowContext, AsyncCallback callback, Object state)</p><p> at System.Net.Sockets.Socket.BeginConnect(EndPoint remoteEP, AsyncCallback callback, Object state)</p><p> at MySql.Data.Common.StreamCreator.CreateSocketStream(IPAddress ip, UInt32 port, Boolean unix)</p><p> at MySql.Data.Common.StreamCreator.GetStream(UInt32 timeOut)</p><p> at MySql.Data.MySqlClient.NativeDriver.Open()</p><p> --- End of inner exception stack trace ---</p><p> at MySql.Data.MySqlClient.NativeDriver.Open()</p><p> at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()</p><p> at MySql.Data.MySqlClient.MySqlPool.GetConnection()</p><p> at MySql.Data.MySqlClient.MySqlConnection.Open()</p><p> at Gentle.Provider.MySQL.MySQLProvider.GetConnection()</p><p> --- End of inner exception stack trace ---</p><p> at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)</p><p> at Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)</p><p> at Gentle.Provider.MySQL.MySQLAnalyzer.Analyze(String tableName)</p><p> at Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)</p><p> at Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)</p><p> at Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)</p><p> at Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)</p><p> at Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)</p><p> at TvDatabase.TvBusinessLayer.GetSetting(String tagName, String defaultValue)</p><p> at TvLibrary.Implementations.TvCardCollection..ctor(IEpgEvents epgEvents)</p><p> at TvService.TVController.InitController()MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts. ---> System.Net.Sockets.SocketException: The attempted operation is not supported for the type of object referenced</p><p> at System.Net.Sockets.Socket.get_ConnectEx()</p><p> at System.Net.Sockets.Socket.BeginConnectEx(EndPoint remoteEP, Boolean flowContext, AsyncCallback callback, Object state)</p><p> at System.Net.Sockets.Socket.BeginConnect(EndPoint remoteEP, AsyncCallback callback, Object state)</p><p> at MySql.Data.Common.StreamCreator.CreateSocketStream(IPAddress ip, UInt32 port, Boolean unix)</p><p> at MySql.Data.Common.StreamCreator.GetStream(UInt32 timeOut)</p><p> at MySql.Data.MySqlClient.NativeDriver.Open()</p><p> --- End of inner exception stack trace ---</p><p> at MySql.Data.MySqlClient.NativeDriver.Open()</p><p> at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()</p><p> at MySql.Data.MySqlClient.MySqlPool.GetConnection()</p><p> at MySql.Data.MySqlClient.MySqlConnection.Open()</p><p> at Gentle.Provider.MySQL.MySQLProvider.GetConnection()System.Net.Sockets.SocketException: The attempted operation is not supported for the type of object referenced</p><p> at System.Net.Sockets.Socket.get_ConnectEx()</p><p> at System.Net.Sockets.Socket.BeginConnectEx(EndPoint remoteEP, Boolean flowContext, AsyncCallback callback, Object state)</p><p> at System.Net.Sockets.Socket.BeginConnect(EndPoint remoteEP, AsyncCallback callback, Object state)</p><p> at MySql.Data.Common.StreamCreator.CreateSocketStream(IPAddress ip, UInt32 port, Boolean unix)</p><p> at MySql.Data.Common.StreamCreator.GetStream(UInt32 timeOut)</p><p> at MySql.Data.MySqlClient.NativeDriver.Open()</p><p> at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)</p><p> at Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)</p><p> at Gentle.Provider.MySQL.MySQLAnalyzer.Analyze(String tableName)</p><p> at Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)</p><p> at Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)</p><p> at Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)</p><p> at Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)</p><p> at Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)</p><p> at TvDatabase.TvBusinessLayer.GetSetting(String tagName, String defaultValue)</p><p> at TvLibrary.Implementations.TvCardCollection..ctor(IEpgEvents epgEvents)</p><p> at TvService.TVController.InitController()</p><p></p><p></p><p>FROM ERROR.LOG:</p><p>----------------------------------------------</p><p></p><p>2009-11-12 00:17:49.093750 [5]: applyProcessPriority: exception is at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)</p><p> at Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)</p><p> at Gentle.Provider.MySQL.MySQLAnalyzer.Analyze(String tableName)</p><p> at Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)</p><p> at Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)</p><p> at Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)</p><p> at Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)</p><p> at Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)</p><p> at TvDatabase.TvBusinessLayer.GetSetting(String tagName, String defaultValue)</p><p> at TvService.Service1.applyProcessPriority()</p></blockquote><p></p>
[QUOTE="kasukka, post: 533493, member: 99512"] [b]MediaPortal Version[/b]: MediaPortalSetup_1.1.0_BETA-1_rev23491 [b]MediaPortal Skin[/b]: [b]Windows Version[/b]: windows xp sp2 [b]CPU Type[/b]: athlon xp [b]HDD[/b]: [b]Memory[/b]: 1gb [b]Motherboard[/b]: [b]Video Card[/b]: radeon 9600 [b]Video Card Driver[/b]: [b]Sound Card[/b]: [b]Sound Card AC3[/b]: [b]Sound Card Driver[/b]: [b]1. TV Card[/b]: msi digivox mini ii v2 [b]1. TV Card Type[/b]: [b]1. TV Card Driver[/b]: [b]2. TV Card[/b]: [b]2. TV Card Type[/b]: [b]2. TV Card Driver[/b]: [b]3. TV Card[/b]: [b]3. TV Card Type[/b]: [b]3. TV Card Driver[/b]: [b]4. TV Card[/b]: [b]4. TV Card Type[/b]: [b]4. TV Card Driver[/b]: [b]MPEG2 Video Codec[/b]: [b]MPEG2 Audio Codec[/b]: [b]h.264 Video Codec[/b]: [b]Satelite/CableTV Provider[/b]: [b]HTPC Case[/b]: [b]Cooling[/b]: [b]Power Supply[/b]: [b]Remote[/b]: [b]TV[/b]: [b]TV - HTPC Connection[/b]: My problem is I just can't get TvService running. It's the same for stable version as well as this Beta1 version. It always comes to the error below. Everything else with the database seems to go right: I always get schema initialized/upgraded with MP's tables. Only when there's just the startup left, the tvservice will quit. Could anyone help me? I'm getting desperate :) Thanks!! Kasukka FROM TV.LOG (a piece of text that will repeat multiple times): ------------------------------------------------ 2009-11-12 00:17:48.703125 [5]: TV service: Starting 2009-11-12 00:17:49.109375 [TVService]: TVService v1.0.4.23491 is starting up on Windows XP ( Service Pack 2 ) [5.1.2600.131072] 2009-11-12 00:17:49.125000 [PowerEventThread]: TV service PowerEventThread message loop is running 2009-11-12 00:17:49.140625 [TVService]: Controller: Initializing TVServer 2009-11-12 00:17:49.140625 [TVService]: Controller: 1 init attempt 2009-11-12 00:17:49.171875 [TVService]: C:\Documents and Settings\All Users.WINDOWS\Application Data\Team MediaPortal\MediaPortal TV Server\gentle.config 2009-11-12 00:17:49.187500 [TVService]: Controller: using MySQL database connection: Server=perskeles;Database=MpTvDb;User ID=root;Password 2009-11-12 00:17:49.187500 [TVService]: ---------------------------- 2009-11-12 00:17:49.203125 [TVService]: TvControllerException: Error: DatabaseUnavailableUnclassified Gentle.Common.GentleException: The database backend (provider MySQL) could not be reached. Check the connection string: Server=perskeles;Database=MpTvDb;User ID=root;Password=MediaPortal;charset=utf8;Connection Timeout=300; ---> MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts. ---> System.Net.Sockets.SocketException: The attempted operation is not supported for the type of object referenced at System.Net.Sockets.Socket.get_ConnectEx() at System.Net.Sockets.Socket.BeginConnectEx(EndPoint remoteEP, Boolean flowContext, AsyncCallback callback, Object state) at System.Net.Sockets.Socket.BeginConnect(EndPoint remoteEP, AsyncCallback callback, Object state) at MySql.Data.Common.StreamCreator.CreateSocketStream(IPAddress ip, UInt32 port, Boolean unix) at MySql.Data.Common.StreamCreator.GetStream(UInt32 timeOut) at MySql.Data.MySqlClient.NativeDriver.Open() --- End of inner exception stack trace --- at MySql.Data.MySqlClient.NativeDriver.Open() 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 TvDatabase.TvBusinessLayer.GetSetting(String tagName, String defaultValue) at TvLibrary.Implementations.TvCardCollection..ctor(IEpgEvents epgEvents) at TvService.TVController.InitController()MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts. ---> System.Net.Sockets.SocketException: The attempted operation is not supported for the type of object referenced at System.Net.Sockets.Socket.get_ConnectEx() at System.Net.Sockets.Socket.BeginConnectEx(EndPoint remoteEP, Boolean flowContext, AsyncCallback callback, Object state) at System.Net.Sockets.Socket.BeginConnect(EndPoint remoteEP, AsyncCallback callback, Object state) at MySql.Data.Common.StreamCreator.CreateSocketStream(IPAddress ip, UInt32 port, Boolean unix) at MySql.Data.Common.StreamCreator.GetStream(UInt32 timeOut) at MySql.Data.MySqlClient.NativeDriver.Open() --- End of inner exception stack trace --- at MySql.Data.MySqlClient.NativeDriver.Open() 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.Net.Sockets.SocketException: The attempted operation is not supported for the type of object referenced at System.Net.Sockets.Socket.get_ConnectEx() at System.Net.Sockets.Socket.BeginConnectEx(EndPoint remoteEP, Boolean flowContext, AsyncCallback callback, Object state) at System.Net.Sockets.Socket.BeginConnect(EndPoint remoteEP, AsyncCallback callback, Object state) at MySql.Data.Common.StreamCreator.CreateSocketStream(IPAddress ip, UInt32 port, Boolean unix) at MySql.Data.Common.StreamCreator.GetStream(UInt32 timeOut) at MySql.Data.MySqlClient.NativeDriver.Open() 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 TvDatabase.TvBusinessLayer.GetSetting(String tagName, String defaultValue) at TvLibrary.Implementations.TvCardCollection..ctor(IEpgEvents epgEvents) at TvService.TVController.InitController() FROM ERROR.LOG: ---------------------------------------------- 2009-11-12 00:17:49.093750 [5]: applyProcessPriority: exception is 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 TvDatabase.TvBusinessLayer.GetSetting(String tagName, String defaultValue) at TvService.Service1.applyProcessPriority() [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Support
Installation, configuration support
TvService seems to fail connecting MySQL
Contact us
RSS
Top
Bottom
