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

    Thankyou High_Five, that worked perfectly, I now remember doing that 10 years ago, thanks for jogging my old memory. Cheers Tony
    Thankyou High_Five, that worked perfectly, I now remember doing that 10 years ago, thanks for jogging my old memory. Cheers Tony
    Hi everyone, I have been using it For 16 years now (from V1.1.1) and it has worked flawlessly. I only use TV Series and Moving...
    Replies
    2
    Views
    387
    Hi. I was probably being a bit fast and loose with my terminology. I meant "somewhere within the files that MP2 uses in its database". Anyway, I found a way to do this which was far from automated but relatively low effort. I found what looked like all the images (CD covers, DVD covers, backgrounds etc all lumped together in...
    Hi. I was probably being a bit fast and loose with my terminology. I meant "somewhere within the files that MP2 uses in its...
    I am in the process of setting up a legacy media player (Mede8er) which I happened to have laying around into my home cinema setup...
    Replies
    2
    Views
    434
    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
    814
    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
    3K
    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
    Top Bottom