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
    405
    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
    435
    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
    818
    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
    Fixed, I think. Certainly the vintage MP2 installer that I was using no longer installs the LAV filters. I can only assume that these were never part of the install package itself, but rather downloaded during the install, and that link no longer exists. Shame that the installer doesn't indicate this. Last time when I installed the...
    Fixed, I think. Certainly the vintage MP2 installer that I was using no longer installs the LAV filters. I can only assume that...
    Hi all, I've recently retired my MP2 setup for my main HTPC and gone back to separates, but I wanted to retain the ability to play...
    Replies
    4
    Views
    272
    Top Bottom