How to identify which database is in use - SQL mr MYSQL? (1 Viewer)

alexeix

Portal Pro
January 28, 2005
199
5
UK
Hi,

I have both SQL and MYSQL installed on my Media Portal server, but I don't know which one is in use by Media Portal.
Is there any way to tell?
Thanks!
 

HTPCSourcer

Retired Team Member
  • Premium Supporter
  • May 16, 2008
    11,382
    2,369
    Home Country
    Germany Germany
    Open a TVServer.log file that shows the startup of the TVServer and look for:
    [2015-06-26 11:53:55,272] [Log ] [TVService] [INFO ] - Controller: Initializing TVServer
    [2015-06-26 11:53:55,272] [Log ] [TVService] [INFO ] - Controller: 1 init attempt
    [2015-06-26 11:53:55,272] [Log ] [PowerEventThread] [DEBUG] - TV service PowerEventThread message loop is running
    [2015-06-26 11:53:55,288] [Log ] [TVService] [INFO ] - C:\ProgramData\Team MediaPortal\MediaPortal TV Server\gentle.config
    [2015-06-26 11:53:55,288] [Log ] [TVService] [INFO ] - Controller: using SQLServer database connection: Password
    [2015-06-26 11:53:55,288] [Log ] [TVService] [INFO ] - Controller: started at SERVER

    In this case MSSQL is used. MYSQL would show "MySQL" instead.

    Alternatively open gentle.config at C:\ProgramData\Team MediaPortal\MediaPortal TV Server and check which <DefaultProvider Name> is uncommented
     

    Users who are viewing this thread

    Similar threads

    I don't know about MP2 but as you said you tried MP1 too, how is the MP music config ? MP(1) will only use LAV if you select "Internal DirectShow player" as music output, but then you lose gapless playback. If you you don't have multichannel music you can choose WASAPI as the output and set the number of speakers to stereo. I have...
    I don't know about MP2 but as you said you tried MP1 too, how is the MP music config ? MP(1) will only use LAV if you select...
    Not sure if this a a bug/config/settings problem. I am running a media portal 2.5 server with 2.41 client but it seems I get the...
    Replies
    1
    Views
    653
    I have added a scheduled task to MariaDB to delete all entries with the same start and end date
    I have added a scheduled task to MariaDB to delete all entries with the same start and end date
    Hello, I'm encountering an issue after importing EPG data into the TV-Server/Database. The Problem: After importing an XMLTV...
    Replies
    7
    Views
    2K
    Hello, Name need to be the same as computer name. Also, logs could be useful.
    Hello, Name need to be the same as computer name. Also, logs could be useful.
    It is a bit of a long story! I successfully installed MP2 on my old PC as client/server with client on my laptop to confirm my...
    Replies
    2
    Views
    1K
    Hi, I didn't have SQL problems but just wanted to agree that on my Win7 system, a clean install of 1.36 TV server x86 does not work since it won't start the TV server configuration. Installing 1.33 first and upgrading to1.36 fixed the problem. Eggert
    Hi, I didn't have SQL problems but just wanted to agree that on my Win7 system, a clean install of 1.36 TV server x86 does not...
    Hi, went from a 1.29 install (working, reinstalled for other reasons) on a fairly fresh and fully updated Windows 10 system for a...
    Replies
    26
    Views
    9K
    4.5 is really old. I'm not sure 4.5.5 even is a version that actually existed. You should be able to install .NET Framework 4.8.0 on Windows 7 SP1
    4.5 is really old. I'm not sure 4.5.5 even is a version that actually existed. You should be able to install .NET Framework 4.8.0...
    My TV PC is more a cast-off on older hardware (a 'Quiet PC' i5 4690, 16GB ram, 2xSSD 1xHDD, system graphics), mainly as a cheap way...
    Replies
    5
    Views
    2K
    Top Bottom