TV Server 1.0 problem: The database backend (provider MySQL) could not be reached

Discussion in 'General Support' started by Hotkey, December 31, 2008.

  1. Hotkey
    • Premium Supporter

    Hotkey MP Donator

    Joined:
    July 18, 2007
    Messages:
    254
    Likes Received:
    3
    Gender:
    Male
    Occupation:
    IT
    Location:
    Dortmund
    Ratings:
    +5 / 0
    Home Country:
    Germany Germany
    Show System Specs
    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 (Text):
    1.  
    2. 2008-12-31 12:03:20.531250 [TVService]: Exception   :Error: DatabaseUnavailableUnclassified
    3. Gentle.Common.GentleException: The database backend (provider MySQL) could not be reached.
    4. 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)
    5.    bei MySql.Data.MySqlClient.PacketReader.CheckForError()
    6.    bei MySql.Data.MySqlClient.PacketReader.ReadHeader()
    7.    bei MySql.Data.MySqlClient.PacketReader.OpenPacket()
    8.    bei MySql.Data.MySqlClient.NativeDriver.Authenticate411()
    9.    bei MySql.Data.MySqlClient.NativeDriver.Authenticate()
    10.    bei MySql.Data.MySqlClient.NativeDriver.Open()
    11.    bei MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
    12.    bei MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
    13.    bei MySql.Data.MySqlClient.MySqlPool.GetConnection()
    14.    bei MySql.Data.MySqlClient.MySqlPoolManager.GetConnection(MySqlConnectionString settings)
    15.    bei MySql.Data.MySqlClient.MySqlConnection.Open()
    16.    bei Gentle.Provider.MySQL.MySQLProvider.GetConnection()
    17.  



    short update after further investigation:

    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 https://forum.team-mediaportal.com/installation-configuration-support-53/how-use-localhost-tv-database-server-51202/).

    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..


    Update 2, Problem solved
    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



    TV-Server Version: 1.0.0.0
    MediaPortal Version: 1.0.0.0
    MediaPortal Skin: Blue3Wide/Indigo
    Windows Version: XP SP2
    CPU Type: AMD X2 4400+
    HDD: Samsung SATA2 250GB
    Memory: 2gig
    Motherboard: P2-M2A690G
    Video Card: ATI 1250X onboard
    Video Card Driver: ATI Omega 4.8.442
    Sound Card: Radeon HD Audio
    Sound Card AC3: optical out
    Sound Card Driver: latest
    1. TV Card: AVermedia AVerTV DVB-S Pro
    1. TV Card Type: DVB-S
    1. TV Card Driver: latest bde
    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:
    h.264 Video Codec:
    Satelite/CableTV Provider:
    HTPC Case: ASUS P-P2-M2A690G
    Cooling: Boxed ASUS cooler
    Power Supply:
    Remote:
    TV: Toshiba 32EL66Z
    TV - HTPC Connection: VGA, HDMI - HDMI not working
     
Loading...

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!