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

Hotkey

MP Donator
  • Premium Supporter
  • July 18, 2007
    254
    6
    42
    Dortmund
    Germany Germany
    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()



    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
     

    Users Who Are Viewing This Thread (Users: 0, Guests: 1)

    OP Similar threads Forum Replies Date
    G MP1 TV Server "failed to upgrade the database" using MS Sql Server Installation, configuration support 3
    R Mp2.2 verschiedene (neue) probleme, server nicht gefunden, client stürzt bei tv ab, timeshift... Allgemeines Support- und Diskussionsforum 1
    E [solved] TV-Server Configuration Missing TV-Server 9
    F MediaPortal 1.16 server crashing due to user error? General Support 5
    E TV-SERVER control TV-Server 3
    CanadianEh MP TV server rebuild with Colossus 2 - Kodi clients receive PMT error when playing videos recoreded by Colossus 2 TV-Server 1
    M 1.25.0 Tv Server Configuration Italian Dvb-t2 test channel preview error Television (MyTV frontend and TV-Server) 8
    M TV Server Preview Window is blank, sounds works Television (MyTV frontend and TV-Server) 3
    catalpa ...immer mal wird der Server abgekoppelt :( Allgemeines Support- und Diskussionsforum 0
    A Keine Verbindung mit Kodi auf Server Allgemeines Support- und Diskussionsforum 11
    CyberSimian Unhandled exception in TV Server TV-Server 0
    Grisu002 Failed to startup - TV Server funktioniert nicht Allgemeines Support- und Diskussionsforum 0
    ajs [WiP] 5030: Add UHD Thumb size to TV Server MediaPortal 1 0
    toricred [solved] Configuring TV Server to use NAS General 5
    T Client / Server slow channel-to-channel change (zapping) General Support 1
    T Server / client channel logo location Installation, configuration support 6
    framug [solved] Some changes/fix in MP1 configuration client and server Submit: code patches (MediaPortal/TV-Server/etc.) 14
    S TV-Server MP1 - Automatic search doesn't work Installation, configuration support 2
    M TV Server can't tune to some DVB-S multiplexes while other software can General 0
    J TV Server setup question Newcomers Forum 0
    D [solved] Changed username in Win10, now TV Server config crashes on fresh install Installation, configuration support 1
    I [solved] Connection to TV Server MySQL General Support 8
    mrmojo666 [Tv Server Plugin ]Direct Show Video Control Plugin 0.0.0.1 for Hauppauge PVR cards MediaPortal 1 Plugins 0
    F After resume, TV Server connection screen is shown General Support 4
    R TV server crash with WintTV quadHD General 0
    Similar threads

























    Top Bottom