[fixed] Trying To Connect to wrong database? (1 Viewer)

jameson_uk

Retired Team Member
  • Premium Supporter
  • January 27, 2005
    7,258
    2,528
    Birmingham
    Home Country
    United Kingdom United Kingdom
    Getting an error just opening up clean installed of 1.1 RC1. Looks like from error.log it is trying to connect to a SQLServer conection when install is on MySQL.

    Logs are from client just opening and closing. TV config app connects quite happily to MySQL database.
    Code:
    Gentle.Common.GentleException: The database backend (provider SQLServer) could not be reached.

    So I hacked gentle.config and changed
    Code:
    <Provider     name="SQLServer"  assembly="Gentle.Provider.SQLServer" />
    to
    Code:
        <Provider     name="SQLServer"  assembly="Gentle.Provider.MySQL.dll" />
        <!-- Provider     name="SQLServer"  assembly="Gentle.Provider.SQLServer" / -->

    Then I get
    Code:
    Gentle.Common.GentleException: show tables ---> MySql.Data.MySqlClient.MySqlException: No database selected

    Original errors as bak files and latest ones as log (these are only files as I accidently deleted install logs...)


    Odd thing is Live TV works too.... not sure where this error is coming from or what is trying to connect to what database...
     

    Attachments

    • MediaPortal.zip
      30.6 KB

    elliottmc

    Retired Team Member
  • Premium Supporter
  • August 7, 2005
    14,927
    6,061
    Cardiff, UK
    Home Country
    United Kingdom United Kingdom
    Getting an error just opening up clean installed of 1.1 RC1. Looks like from error.log it is trying to connect to a SQLServer conection when install is on MySQL.

    Logs are from client just opening and closing. TV config app connects quite happily to MySQL database.
    Code:
    Gentle.Common.GentleException: The database backend (provider SQLServer) could not be reached.

    MySQL is a SQL Server, as is MS SQL, or am I missing something?

    Does anything actually go wrong, other than an error in the log file?

    Mark
     

    jameson_uk

    Retired Team Member
  • Premium Supporter
  • January 27, 2005
    7,258
    2,528
    Birmingham
    Home Country
    United Kingdom United Kingdom
    MySQL is a SQL Server, as is MS SQL, or am I missing something?
    I am a DBA and believe me they are very different things... SQL Server is the MS product name. (the generic term is RDBMS or Relational Database Management System)....

    Does anything actually go wrong, other than an error in the log file?
    Not seen any side effects yet but obviously something is not doing what it should. Not really put RC1 through its paces yet so might pickup something that is broken down the line.

    I did look again at the MP log and I am not sure it is to do with the fixes put in to make TV client cope with loosing connection to server???
     

    infinite.loop

    Retired Team Member
  • Premium Supporter
  • December 26, 2004
    16,163
    4,133
    127.0.0.1
    Home Country
    Austria Austria
    So you did a installation where:
    - MP was not present
    - Tv-Server was not present
    - no SQL server was present
    - deploytool had to download and install everything?

    or was the (My)SQL server allready installed?
     

    jameson_uk

    Retired Team Member
  • Premium Supporter
  • January 27, 2005
    7,258
    2,528
    Birmingham
    Home Country
    United Kingdom United Kingdom
    So you did a installation where:
    - MP was not present
    - Tv-Server was not present
    - no SQL server was present
    - deploytool had to download and install everything?

    or was the (My)SQL server allready installed?

    Was using last public SVN . I did complete uninstall of MP (full to remove all setting etc). Did a standard uninstall of TV server (ie. leave MySQL database intact). I have not had SQLServer installed since MP used it as standard (definately not installed now).

    Deploy tool picked up that MySQL was already installed but did download MP and TVServer
     

    Marvman

    Retired Team Member
  • Premium Supporter
  • November 14, 2007
    1,163
    735
    Bavaria
    Home Country
    Germany Germany
    Your gentle.conf should look like mine..
    Have MySQL Server installed too.

    Code:
    <?xml version="1.0" encoding="utf-8"?>
    <Gentle.Framework>
      <!-- See the API documentation for the Gentle.Framework.GentleSettings class for
                     detailed information on the keys available in the Options section -->
      <Options>
        <!-- the default timeout value in seconds for IDbCommand instances created by Gentle -->
        <CommandTimeout>30</CommandTimeout>
        <!-- whether to enable support for Gentle-managed concurrency control columns -->
        <ConcurrencyControl>false</ConcurrencyControl>
        <!-- options: Attributes or XML (XML currently unused) -->
        <MasterDefinition>Attributes</MasterDefinition>
        <Analyzer>
          <!-- options: None, OnDemand (the default), Full -->
          <Level>OnDemand</Level>
          <!-- whether to warn about unmapped columns and other non-fatal errors -->
          <Silent>false</Silent>
        </Analyzer>
        <Cache>
          <!-- default cache strategy (use only Never or Temporary) -->
          <DefaultStrategy>Temporary</DefaultStrategy>
          <CacheStatements>true</CacheStatements>
          <CacheObjects>true</CacheObjects>
          <!-- when true Gentle will try to bypass query execution and compose
                             the result from cached data alone -->
          <SkipQueryExecution>true</SkipQueryExecution>
          <!-- the scope within which to ensure uniqing 
                             options: Thread (default), Application or WebSession -->
          <UniqingScope>Application</UniqingScope>
        </Cache>
        <Logging>
          <!-- This setting controls the lowest log level emitted. See the
    		                 Verbosity enum for details on the available values. -->
          <Verbosity>Warning</Verbosity>
          <!-- Do not edit this unless you know what you're doing. This setting
                     		 controls at what level error conditions are considered fatal.  -->
          <Frailty>Warning</Frailty>
          <!-- Use values defined in the LogCategories enum to turn logging on/off
            		         for selected categories. The available values include:
    		                 	All (all categories)
                       			StatementExecutionRead (select statements)
                       			StatementExecutionWrite (insert/update/delete statements)
                       			StatementExecutionOther (any other kind of statement)
                       			StatementExecution (any kind of statement; same as all three groups above)
                       			Cache (cache accesses)
                       			Metadata (metadata updates)
                       			General (everything else) -->
          <!-- The following sample first disables all categories, then selectively
                             turns on various subcategories -->
          <Category name="All" enabled="false" />
          <Category name="StatementExecution" enabled="false" />
          <Category name="Cache" enabled="false" />
          <Category name="Metadata" enabled="false" />
        </Logging>
      </Options>
      <!--            
                <NamespaceProviders>
                    <Namespace namespace="Gentle.First"  provider="SQLServer" connectionstring="..." />
                    <Namespace namespace="Gentle.Second" provider="SQLServer" connectionString="..." />
                </NamespaceProviders>
                -->
      <DefaultProvider name="MySQL" connectionString="Server=tvbox;Database=MpTvDb;User ID=root;Password=MediaPortal;charset=utf8;Connection Timeout=300;" />
      <!--
                <DefaultProvider name="Firebird" connectionString="User=SYSDBA;Password=masterkey;Data Source=TvLibrary.fdb;ServerType=1;Charset=UNICODE_FSS;" />
                <DefaultProvider name="Jet" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Code\Gentle.NET\Source\Gentle.Framework.Tests\Database Files\Gentle_MSAccess.mdb;OLE DB Services=-1;" />
                <DefaultProvider name="MySQL" connectionString="Server=10.0.0.2;Database=test;User ID=xxx;Password=xxx" />
                <DefaultProvider name="PostgreSQL" connectionString="Server=10.0.0.2;Database=Test;User ID=xxx;Password=xxx" />
                <DefaultProvider name="Oracle" connectionString="Data Source=kermit.symbiote.sporadicism.com,1521;User ID=gentle;password=xxx" />
                <DefaultProvider name="OracleODP" connectionString="Data Source=kermit.symbiote.sporadicism.com,1521;User ID=gentle;password=xxx" />
                <DefaultProvider name="SQLite" connectionString="URI=file:c:/Code/Gentle.NET/Source/Gentle.Framework.Tests/Database Files/Gentle_SQLite.db" />
                <DefaultProvider name="SQLServer" connectionString="data source=127.0.0.1;initial catalog=Test;user id=xxx;password=xxx;packet size=4096" />
                -->
      <!-- IMPORTANT: You must uncomment ONLY the providers that you will be using. If a provider 
                     is defined below, but Gentle cannot find or load the associated library, an exception
                     will most likely be raised! -->
      <Providers>
        <!-- list known provider assemblies; the assembly .dll suffix is optional -->
        <!-- Provider name="CE"         assembly="Gentle.Provider.CE" /-->
        <!-- Provider name="Firebird"   assembly="Gentle.Provider.Firebird" /-->
        <!-- Provider name="Jet"        assembly="Gentle.Provider.Jet" /-->
        <Provider name="MySQL" assembly="Gentle.Provider.MySQL.dll" />
        <!-- Provider name="Oracle"     assembly="Gentle.Provider.Oracle" /-->
        <!-- Provider name="OracleODP"  assembly="Gentle.Provider.OracleODP" /-->
        <!-- Provider name="PostgreSQL" assembly="Gentle.Provider.PostgreSQL" /-->
        <!-- Provider name="SQLite"     assembly="Gentle.Provider.SQLite" / -->
        <Provider name="SQLServer" assembly="Gentle.Provider.SQLServer" />
        <!-- Provider name="Sybase"     assembly="Gentle.Provider.Sybase" / -->
        <!-- Provider name="SybaseASA"  assembly="Gentle.Provider.SybaseASA" / -->
      </Providers>
    </Gentle.Framework>
     

    jameson_uk

    Retired Team Member
  • Premium Supporter
  • January 27, 2005
    7,258
    2,528
    Birmingham
    Home Country
    United Kingdom United Kingdom
    Your gentle.conf should look like mine..
    Have MySQL Server installed too.
    Indeed it does... I was just trying to be 100% sure that something was trying to create a connection to a SQLServer database. Changing the SQL Server database connection to think it was a MySQL database proved something is trying to connect to a MS SQL Server database and not a MySQL one
     

    SurFan

    Portal Member
    August 7, 2005
    9
    0
    MediaPortal Version: 1.1.0.0 RC1
    MediaPortal Skin: Blue3wide
    Windows Version: Win7 Professional
    CPU Type: AMD Athlon X5050E
    HDD: WD Caviar Green 1TB
    Memory: 2*1GB PC-6400
    Motherboard: Gigabyte GAMA770
    Video Card: Gigabyte ATI 3450
    Video Card Driver: CCC 9.8
    Sound Card: OnBoard
    Sound Card AC3: coaxial out
    Sound Card Driver: 6.0.1.5928
    1. TV Card: Hauppauge HVR-1300
    1. TV Card Type: DVB-T (analog disabled)
    1. TV Card Driver: 2.122.26109.0
    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: nVidia Forceware 4.02.236
    MPEG2 Audio Codec: Vidia Forceware 4.02.236
    h.264 Video Codec:
    Satelite/CableTV Provider:
    HTPC Case:
    Cooling: EKL Alpenföhn
    Power Supply:
    Remote:
    TV: Optoma H79 / Metz Movea S
    TV - HTPC Connection: DVI / S-Video

    Hi similar issue here. I did a complete uninstall of everything (1.1 Beta1 and MySQL Server). MP Client could not connect to SQL Server (obviously, because it is not installed). Disabled SQL Server in gentle.config as provided by jameson_uk in the first post. MP started without problems. Ok, I thought, collecting logs of the crash by reverting the patch, but no luck, MP works just fine since then

    Ralph
     

    jameson_uk

    Retired Team Member
  • Premium Supporter
  • January 27, 2005
    7,258
    2,528
    Birmingham
    Home Country
    United Kingdom United Kingdom
    As an update, I ended up removing MP and TV server including removing database and uninstalling MySQL. This seems to have cleared the error but then I encountered the problem of not being able to scan on DVB-S :(

    I did an export of channels from old SVN version and imported that into clean install and that seems to have done the trick.

    This problem appears to have been caused by MySQL already been installed and/or the MPTVDB database already existing.
     

    cfforce

    MP Donator
  • Premium Supporter
  • March 4, 2008
    241
    21
    Home Country
    Netherlands Netherlands
    Notcied the same, multiseat, MySQL
    When fresh install; i get error message about SQL; then i re-enter the IP/Hostname of server; shutdown MP; and restart; all works fine after.
     

    Users who are viewing this thread

    Top Bottom