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
General Support
TV Server 1.0 problem: The database backend (provider MySQL) could not be reached
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="Hotkey" data-source="post: 351983" data-attributes="member: 53751"><p>Hi all,</p><p></p><p>i've the problem that after the start of the computer im unable to watch tv. When i enter MyTV and select a channel i get the message "Timeshift could not be started, no free card available" (Translated from german).</p><p>An error.log is generated by the tvserver which states, that the database backend could not be reached. (see blow)</p><p>This entry exists 5 times, each with 3 seconds delay between. When i exit MP and restart the TVService everything works as it should. </p><p>It seems that the tvservice is starting prior the mysql service which are both set to automatic launch. </p><p>How can i solve this problem to make sure that the mysql Service starts first?</p><p></p><p>Hope someone can help me.</p><p></p><p>Thanks in advance and with best regards</p><p></p><p>Hotkey</p><p></p><p>[code]</p><p>2008-12-31 12:03:20.531250 [TVService]: Exception :Error: DatabaseUnavailableUnclassified</p><p>Gentle.Common.GentleException: The database backend (provider MySQL) could not be reached.</p><p>Check the connection string: Server=htpc;Database=MpTvDb;User ID=xxxx;Password=xxxx;charset=utf8;Connection Timeout=300; ---> MySql.Data.MySqlClient.MySqlException: #28000Access denied for user 'xxxx'@'localhost' (using password: YES)</p><p> bei MySql.Data.MySqlClient.PacketReader.CheckForError()</p><p> bei MySql.Data.MySqlClient.PacketReader.ReadHeader()</p><p> bei MySql.Data.MySqlClient.PacketReader.OpenPacket()</p><p> bei MySql.Data.MySqlClient.NativeDriver.Authenticate411()</p><p> bei MySql.Data.MySqlClient.NativeDriver.Authenticate()</p><p> bei MySql.Data.MySqlClient.NativeDriver.Open()</p><p> bei MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()</p><p> bei MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()</p><p> bei MySql.Data.MySqlClient.MySqlPool.GetConnection()</p><p> bei MySql.Data.MySqlClient.MySqlPoolManager.GetConnection(MySqlConnectionString settings)</p><p> bei MySql.Data.MySqlClient.MySqlConnection.Open()</p><p> bei Gentle.Provider.MySQL.MySQLProvider.GetConnection()</p><p>[/code]</p><p></p><p></p><p></p><p></p><p><strong>short update after further investigation:</strong></p><p></p><p>From the log above it seems, that the MySQL Server denied the connection to the user "htpc@localhost".</p><p>To clarify the current setting:</p><p>The MySQL User is configured as "htpc@%" (which should include "localhost")</p><p>MP and TS is installed on the same computer which is also named "htpc".</p><p>I used this hostname "htpc" during the configuration, since the setup didn't allowed me to use "localhost" or "127.0.0.1" (see <a href="https://forum.team-mediaportal.com/installation-configuration-support-53/how-use-localhost-tv-database-server-51202/" target="_blank">https://forum.team-mediaportal.com/installation-configuration-support-53/how-use-localhost-tv-database-server-51202/</a>).</p><p></p><p>From the logs it seems, that the TV Server tries to use the "htpc" as the servername, but the MySQL Error Message gives "localhost".</p><p></p><p>I'll do dome more investigation and report back..</p><p></p><p></p><p><strong>Update 2, Problem solved</strong></p><p>Ok, i fixed this problem. I've now added a second entry in the mysql users table, so i know have the user htpc with the host "%" and one with the host "localhost".</p><p>This solved the problem.</p><p></p><p>Nevertheless it seems, that TVServer uses different techniques when connecting to the database. Otherwhise one entry for one host should be enough to perform the connection. </p><p>This might also be the answer why a manual restard of the tvserver after the boot solved the problem also.</p><p></p><p>After booting: No TV, then exit MP, restart TV Service, start MP: TV working</p><p></p><p></p><p>Greets</p><p></p><p>Hotkey</p><p></p><p></p><p></p><p><strong>TV-Server Version</strong>: 1.0.0.0</p><p><strong>MediaPortal Version</strong>: 1.0.0.0</p><p><strong>MediaPortal Skin</strong>: Blue3Wide/Indigo</p><p><strong>Windows Version</strong>: XP SP2</p><p><strong>CPU Type</strong>: AMD X2 4400+</p><p><strong>HDD</strong>: Samsung SATA2 250GB</p><p><strong>Memory</strong>: 2gig</p><p><strong>Motherboard</strong>: P2-M2A690G</p><p><strong>Video Card</strong>: ATI 1250X onboard</p><p><strong>Video Card Driver</strong>: ATI Omega 4.8.442</p><p><strong>Sound Card</strong>: Radeon HD Audio</p><p><strong>Sound Card AC3</strong>: optical out</p><p><strong>Sound Card Driver</strong>: latest</p><p><strong>1. TV Card</strong>: AVermedia AVerTV DVB-S Pro</p><p><strong>1. TV Card Type</strong>: DVB-S</p><p><strong>1. TV Card Driver</strong>: latest bde</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>: ASUS P-P2-M2A690G</p><p><strong>Cooling</strong>: Boxed ASUS cooler</p><p><strong>Power Supply</strong>: </p><p><strong>Remote</strong>: </p><p><strong>TV</strong>: Toshiba 32EL66Z</p><p><strong>TV - HTPC Connection</strong>: VGA, HDMI - HDMI not working</p></blockquote><p></p>
[QUOTE="Hotkey, post: 351983, member: 53751"] Hi all, i've the problem that after the start of the computer im unable to watch tv. When i enter MyTV and select a channel i get the message "Timeshift could not be started, no free card available" (Translated from german). An error.log is generated by the tvserver which states, that the database backend could not be reached. (see blow) This entry exists 5 times, each with 3 seconds delay between. When i exit MP and restart the TVService everything works as it should. It seems that the tvservice is starting prior the mysql service which are both set to automatic launch. How can i solve this problem to make sure that the mysql Service starts first? Hope someone can help me. Thanks in advance and with best regards Hotkey [code] 2008-12-31 12:03:20.531250 [TVService]: Exception :Error: DatabaseUnavailableUnclassified Gentle.Common.GentleException: The database backend (provider MySQL) could not be reached. Check the connection string: Server=htpc;Database=MpTvDb;User ID=xxxx;Password=xxxx;charset=utf8;Connection Timeout=300; ---> MySql.Data.MySqlClient.MySqlException: #28000Access denied for user 'xxxx'@'localhost' (using password: YES) bei MySql.Data.MySqlClient.PacketReader.CheckForError() bei MySql.Data.MySqlClient.PacketReader.ReadHeader() bei MySql.Data.MySqlClient.PacketReader.OpenPacket() bei MySql.Data.MySqlClient.NativeDriver.Authenticate411() bei MySql.Data.MySqlClient.NativeDriver.Authenticate() bei MySql.Data.MySqlClient.NativeDriver.Open() bei MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection() bei MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() bei MySql.Data.MySqlClient.MySqlPool.GetConnection() bei MySql.Data.MySqlClient.MySqlPoolManager.GetConnection(MySqlConnectionString settings) bei MySql.Data.MySqlClient.MySqlConnection.Open() bei Gentle.Provider.MySQL.MySQLProvider.GetConnection() [/code] [b]short update after further investigation:[/b] From the log above it seems, that the MySQL Server denied the connection to the user "htpc@localhost". To clarify the current setting: The MySQL User is configured as "htpc@%" (which should include "localhost") MP and TS is installed on the same computer which is also named "htpc". I used this hostname "htpc" during the configuration, since the setup didn't allowed me to use "localhost" or "127.0.0.1" (see [URL="https://forum.team-mediaportal.com/installation-configuration-support-53/how-use-localhost-tv-database-server-51202/"]https://forum.team-mediaportal.com/installation-configuration-support-53/how-use-localhost-tv-database-server-51202/[/URL]). From the logs it seems, that the TV Server tries to use the "htpc" as the servername, but the MySQL Error Message gives "localhost". I'll do dome more investigation and report back.. [b]Update 2, Problem solved[/b] Ok, i fixed this problem. I've now added a second entry in the mysql users table, so i know have the user htpc with the host "%" and one with the host "localhost". This solved the problem. Nevertheless it seems, that TVServer uses different techniques when connecting to the database. Otherwhise one entry for one host should be enough to perform the connection. This might also be the answer why a manual restard of the tvserver after the boot solved the problem also. After booting: No TV, then exit MP, restart TV Service, start MP: TV working Greets Hotkey [b]TV-Server Version[/b]: 1.0.0.0 [b]MediaPortal Version[/b]: 1.0.0.0 [b]MediaPortal Skin[/b]: Blue3Wide/Indigo [b]Windows Version[/b]: XP SP2 [b]CPU Type[/b]: AMD X2 4400+ [b]HDD[/b]: Samsung SATA2 250GB [b]Memory[/b]: 2gig [b]Motherboard[/b]: P2-M2A690G [b]Video Card[/b]: ATI 1250X onboard [b]Video Card Driver[/b]: ATI Omega 4.8.442 [b]Sound Card[/b]: Radeon HD Audio [b]Sound Card AC3[/b]: optical out [b]Sound Card Driver[/b]: latest [b]1. TV Card[/b]: AVermedia AVerTV DVB-S Pro [b]1. TV Card Type[/b]: DVB-S [b]1. TV Card Driver[/b]: latest bde [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]: ASUS P-P2-M2A690G [b]Cooling[/b]: Boxed ASUS cooler [b]Power Supply[/b]: [b]Remote[/b]: [b]TV[/b]: Toshiba 32EL66Z [b]TV - HTPC Connection[/b]: VGA, HDMI - HDMI not working [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Support
General Support
TV Server 1.0 problem: The database backend (provider MySQL) could not be reached
Contact us
RSS
Top
Bottom